package com.shlanbao.tzsc.pms.sch.constd.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
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.SchConStdDaoI;
|
import com.shlanbao.tzsc.base.mapping.MdMat;
|
import com.shlanbao.tzsc.base.mapping.SchConStd;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.pms.sch.constd.beans.ConStdBean;
|
import com.shlanbao.tzsc.pms.sch.constd.service.ConStdServiceI;
|
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
import javax.servlet.http.HttpServletRequest;
|
|
@Service
|
public class ConStdServiceImpl extends BaseService implements ConStdServiceI{
|
@Autowired
|
private SchConStdDaoI schConStdDao;
|
@Autowired
|
private HttpServletRequest request;
|
@LogAnno(operateType = "新增标准单耗")
|
@Override
|
public void addConStd(ConStdBean conStdBean) throws Exception {
|
SchConStd o = new SchConStd();
|
BeanConvertor.copyProperties(conStdBean, o);
|
o.setMdMatByMat(new MdMat(conStdBean.getMat()));
|
o.setMdMatByProd(new MdMat(conStdBean.getMatProd()));
|
o.setDel(0L);
|
FillUserInfoUtil.fillCreateUserInfo(o,request);
|
schConStdDao.save(o);
|
}
|
@LogAnno(operateType = "编辑标准单耗")
|
@Override
|
public void editConStd(ConStdBean conStdBean) throws Exception {
|
SchConStd o = schConStdDao.findById(SchConStd.class, conStdBean.getId());
|
BeanConvertor.copyProperties(conStdBean, o);
|
o.setMdMatByMat(new MdMat(conStdBean.getMat()));
|
o.setMdMatByProd(new MdMat(conStdBean.getMatProd()));
|
FillUserInfoUtil.fillUpdateUserInfo(o,request);
|
}
|
@LogAnno(operateType = "删除标准单耗")
|
@Override
|
public void deleteConStd(String id) throws Exception {
|
schConStdDao.updateByParams("delete from SchConStd where id=?", id);
|
}
|
@Override
|
public DataGrid getAllConStds(ConStdBean conStdBean) throws Exception {
|
String sql = "select b.id,c.name as matprod,d.name as matname,b.val,b.uval,b.lval,b.euval,b.elval,b.des,a.prod,a.mat from SCH_WORKORDER_BOM a " +
|
" left join SCH_CON_STD b on a.prod = b.prod and a.mat = b.mat " +
|
" left join md_mat c on a.prod = c.id left join md_mat d on a.mat = d.id where (b.del =0 or b.del is null) ";
|
|
if(StringUtil.notNull(conStdBean.getMatProd())){
|
sql += " and a.prod = '"+conStdBean.getMatProd()+"'";
|
}
|
if(StringUtil.notNull(conStdBean.getMat())){
|
sql += " and a.mat='"+conStdBean.getMat()+"'";
|
}
|
if (StringUtil.notNull(conStdBean.getWorkShop())) {
|
sql += " and c.tid = '" +conStdBean.getWorkShop() +"'";
|
}
|
sql += " group by a.prod, a.mat,b.val,b.uval,b.lval,b.euval,b.elval,b.elval,b.des,b.id,c.name,d.name order by a.prod ";
|
List<ConStdBean> list = new ArrayList<ConStdBean>();
|
ConStdBean bean = null;
|
List<?> objects = schConStdDao.queryBySql(sql);
|
if (objects!=null && objects.size()>0){
|
for (Object o : objects) {
|
Object[] arr = (Object[]) o;
|
bean = new ConStdBean();
|
bean.setId(StringUtil.convertObjToString(arr[0]));
|
bean.setMatProd(StringUtil.convertObjToString(arr[1]));
|
bean.setMatName(StringUtil.convertObjToString(arr[2]));
|
bean.setVal(StringUtil.converObj2Double(arr[3]));
|
bean.setUval(StringUtil.converObj2Double(arr[4]));
|
bean.setLval(StringUtil.converObj2Double(arr[5]));
|
bean.setEuval(StringUtil.converObj2Double(arr[6]));
|
bean.setElval(StringUtil.converObj2Double(arr[7]));
|
bean.setDes(StringUtil.convertObjToString(arr[8]));
|
|
bean.setProd(StringUtil.convertObjToString(arr[9]));
|
bean.setMat(StringUtil.convertObjToString(arr[10]));
|
|
list.add(bean);
|
}
|
}
|
return new DataGrid(list, 0L);
|
}
|
@Override
|
public ConStdBean getConStdById(String id) throws Exception{
|
|
SchConStd schConStd = schConStdDao.findById(SchConStd.class, id);
|
|
ConStdBean bean = BeanConvertor.copyProperties(schConStd, ConStdBean.class);
|
|
if(schConStd.getMdMatByMat()!=null && schConStd.getMdMatByProd()!=null){
|
|
bean.setMat(schConStd.getMdMatByMat().getId());//辅料
|
bean.setMatName(schConStd.getMdMatByMat().getName());//辅料名称
|
|
bean.setMatProd(schConStd.getMdMatByProd().getId());//产品
|
|
}
|
|
return bean;
|
|
}
|
|
@Override
|
public void batchDeleteConStd(String ids) {
|
String[] split = ids.split(",");
|
for (int i = 0; i < split.length; i++) {
|
schConStdDao.updateByParams("delete from SchConStd where id=?", split[i]);
|
}
|
|
}
|
}
|
