package com.shlanbao.tzsc.pms.sch.workorder.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import com.shlanbao.tzsc.base.dao.SchWorkorderDaoI;
|
import com.shlanbao.tzsc.utils.tools.FillUserInfoUtil;
|
import com.shlanbao.tzsc.utils.tools.LogAnno;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.shlanbao.tzsc.base.dao.SchWorkorderBomDaoI;
|
import com.shlanbao.tzsc.base.mapping.MdMat;
|
import com.shlanbao.tzsc.base.mapping.MdUnit;
|
import com.shlanbao.tzsc.base.mapping.SchWorkorder;
|
import com.shlanbao.tzsc.base.mapping.SchWorkorderBom;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.pms.sch.workorder.beans.BomBean;
|
import com.shlanbao.tzsc.pms.sch.workorder.service.BomServiceI;
|
|
import javax.servlet.http.HttpServletRequest;
|
|
@Service
|
public class BomServiceImpl extends BaseService implements BomServiceI{
|
@Autowired
|
private SchWorkorderBomDaoI schWorkorderBomDao;
|
@Autowired
|
private SchWorkorderDaoI workorderDaoI;
|
@Autowired
|
private HttpServletRequest request;
|
|
@Override
|
public DataGrid queryBomByWorkOrder(String workOrderId) {
|
SchWorkorder workorder = workorderDaoI.findById(SchWorkorder.class,workOrderId);
|
try {
|
String hql = "from SchWorkorderBom o join fetch o.mdMat m join fetch o.mdUnit u where o.bom_lot_id=?";
|
|
List<SchWorkorderBom> schWorkorderBoms = schWorkorderBomDao.query(hql, workorder.getBomVersion());
|
|
List<BomBean> bomBeans = new ArrayList<BomBean>();
|
|
|
for (SchWorkorderBom schWorkorderBom : schWorkorderBoms) {
|
BomBean bean = new BomBean();
|
bean.setId(schWorkorderBom.getId());
|
bean.setMat(schWorkorderBom.getMdMat().getSimpleName());
|
bean.setQty(schWorkorderBom.getQty());
|
bean.setUnit(schWorkorderBom.getMdUnit().getName());
|
bean.setMatId(schWorkorderBom.getMdMat().getCode());
|
bomBeans.add(bean);
|
|
}
|
|
return new DataGrid(bomBeans, 0L);
|
|
} catch (Exception e) {
|
|
log.error("查询工单ID:["+workOrderId+"]的BOM异常", e);
|
|
}
|
|
return null;
|
}
|
@Override
|
public void addBom(BomBean bomBean) {
|
SchWorkorderBom o = new SchWorkorderBom();
|
o.setMdMat(new MdMat(bomBean.getMat()));
|
o.setQty(bomBean.getQty());
|
o.setMdUnit(new MdUnit(bomBean.getUnit()));
|
o.setSchWorkorder(new SchWorkorder(bomBean.getOrderId()));
|
schWorkorderBomDao.save(o);
|
}
|
@LogAnno(operateType = "投料信息编辑")
|
@Override
|
public void editBom(BomBean bomBean) {
|
SchWorkorderBom o = schWorkorderBomDao.findById(SchWorkorderBom.class, bomBean.getId());
|
o.setMdMat(new MdMat(bomBean.getMat()));
|
o.setQty(bomBean.getQty());
|
o.setMdUnit(new MdUnit(bomBean.getUnit()));
|
FillUserInfoUtil.fillUpdateUserInfo(o,request);
|
//o.setSchWorkorder(new SchWorkorder(bomBean.getOrderId()));
|
}
|
@LogAnno(operateType = "投料信息删除")
|
@Override
|
public void deleteBom(String id) {
|
schWorkorderBomDao.deleteById(id, SchWorkorderBom.class);
|
}
|
@Override
|
public BomBean getBomById(String id) {
|
SchWorkorderBom schWorkorderBom = schWorkorderBomDao.findById(SchWorkorderBom.class, id);
|
BomBean bean = new BomBean();
|
bean.setId(schWorkorderBom.getId());
|
bean.setMat(schWorkorderBom.getMdMat().getSimpleName());
|
bean.setMatId(schWorkorderBom.getMdMat().getId());
|
bean.setQty(schWorkorderBom.getQty());
|
bean.setUnit(schWorkorderBom.getMdUnit().getName());
|
bean.setUnitId(schWorkorderBom.getMdUnit().getId());
|
return bean;
|
}
|
/**
|
* 查询
|
* @author wanchanghuang
|
* @create 2019年5月6日16:54:32
|
* @param schWkBom
|
*/
|
@Override
|
public long querySchWkOrderBom (SchWorkorderBom schWkBom) {
|
try {
|
String hql="from SchWorkorderBom o where o.bom_lot_id=? and o.mdMat.id=?";
|
List<SchWorkorderBom> list=schWorkorderBomDao.query(hql, schWkBom.getBom_lot_id(),schWkBom.getMdMat().getId());
|
if(list!=null) {
|
return list.size();
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return 0;
|
}
|
/**
|
*插入
|
* @author wanchanghuang
|
* @create 2019年5月6日16:54:32
|
* @param schWkBom
|
*/
|
@Override
|
public void addSchWkOrderBom(SchWorkorderBom schWkBom) {
|
schWorkorderBomDao.save(schWkBom);
|
}
|
/**
|
*查询
|
* @author wanchanghuang
|
* @create 2019年5月6日16:54:32
|
* @param schWkBom
|
*/
|
@Override
|
public List<SchWorkorderBom> querySchWorkBomByBomId(SchWorkorder schWk) {
|
String hql="from SchWorkorderBom o where o.bom_lot_id=? and o.del=1 ";//1表示数采关键物料
|
List<SchWorkorderBom> list=schWorkorderBomDao.query(hql, schWk.getBomVersion());
|
return list;
|
}
|
|
@Override
|
public void deleteBomByBomId(String schWkBom) {
|
String sql = "delete from sch_workorder_bom where bom_lot_id = ?";
|
List<Object> list = new ArrayList<>();
|
list.add(schWkBom);
|
schWorkorderBomDao.updateBySql(sql,list);
|
}
|
|
|
public SchWorkorderDaoI getWorkorderDaoI() {
|
return workorderDaoI;
|
}
|
|
public void setWorkorderDaoI(SchWorkorderDaoI workorderDaoI) {
|
this.workorderDaoI = workorderDaoI;
|
}
|
}
|
