package com.shlanbao.tzsc.pms.md.mattype.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.MdMatGrpDaoI;
|
import com.shlanbao.tzsc.base.dao.MdMatTypeDaoI;
|
import com.shlanbao.tzsc.base.mapping.MdMatGrp;
|
import com.shlanbao.tzsc.base.mapping.MdMatType;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.plugin.service.LoadComboboxServiceI;
|
import com.shlanbao.tzsc.pms.md.mattype.beans.MatTypeBean;
|
import com.shlanbao.tzsc.pms.md.mattype.service.MatTypeServiceI;
|
import com.shlanbao.tzsc.utils.params.ComboboxType;
|
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
import javax.servlet.http.HttpServletRequest;
|
|
@Service
|
public class MatTypeServiceImpl extends BaseService implements MatTypeServiceI {
|
@Autowired
|
private MdMatTypeDaoI mdMatTypeDao;
|
@Autowired
|
private LoadComboboxServiceI loadComboboxService;
|
@Autowired
|
private MdMatGrpDaoI mdMatGroupDao;
|
@Autowired
|
private HttpServletRequest request;
|
@Override
|
public List<MatTypeBean> queryAllMatTypesForComboBox() throws Exception {
|
return BeanConvertor.copyList(mdMatTypeDao.query("from MdMatType o where o.del='0' and o.enable=1 order by (o.code+0) asc"), MatTypeBean.class);
|
}
|
@LogAnno(operateType = "新增物料类型")
|
@Override
|
public void addMatType(MatTypeBean matTypeBean) throws Exception {
|
MdMatType o = new MdMatType();
|
BeanConvertor.copyProperties(matTypeBean, o);
|
if(StringUtil.notNull(matTypeBean.getMatGrp())){
|
o.setMdMatGrp(new MdMatGrp(matTypeBean.getMatGrp()));
|
}
|
o.setDel("0");
|
FillUserInfoUtil.fillCreateUserInfo(o,request);
|
mdMatTypeDao.save(o);
|
loadComboboxService.initCombobox(ComboboxType.MATTYPE);
|
}
|
@LogAnno(operateType = "编辑物料类型")
|
@Override
|
public void editMatType(MatTypeBean matTypeBean) throws Exception {
|
MdMatType o = mdMatTypeDao.findById(MdMatType.class, matTypeBean.getId());
|
BeanConvertor.copyProperties(matTypeBean, o);
|
MdMatGrp matGroup=mdMatGroupDao.findById(MdMatGrp.class, matTypeBean.getMatGrp());
|
if(matGroup==null){
|
matGroup=mdMatGroupDao.unique(MdMatGrp.class, "from MdMatGrp where name=?", matTypeBean.getMatGrp());
|
}
|
o.setMdMatGrp(matGroup);
|
FillUserInfoUtil.fillUpdateUserInfo(o,request);
|
loadComboboxService.initCombobox(ComboboxType.MATTYPE);
|
}
|
@LogAnno(operateType = "删除物料类型")
|
@Override
|
public void deleteMatType(String id) throws Exception {
|
mdMatTypeDao.updateByParams("update MdMatType o set o.del='1' where o.id=?", id);
|
loadComboboxService.initCombobox(ComboboxType.MATTYPE);
|
}
|
@Override
|
public DataGrid getAllMatTypes(MatTypeBean matTypeBean) throws Exception {
|
String hql = "from MdMatType o left join fetch o.mdMatGrp g where o.del='0' and o.name like '%"+matTypeBean.getName()+"%' " +
|
((matTypeBean.getMatGrp()!=null&&!"".equals(matTypeBean.getMatGrp()))?" and g.id = " + matTypeBean.getMatGrp():"")+
|
" order by cast(o.code as integer) asc";
|
List<MatTypeBean> list = new ArrayList<MatTypeBean>();
|
for (MdMatType mdMatType : mdMatTypeDao.query(hql)) {
|
|
MatTypeBean typeBean = BeanConvertor.copyProperties(mdMatType, MatTypeBean.class);
|
if(mdMatType.getMdMatGrp()!=null){
|
typeBean.setMatGrp(mdMatType.getMdMatGrp().getName());
|
}
|
FillUserInfoUtil.fillCreateAndUpdateUserInfo(mdMatType,typeBean);
|
list.add(typeBean);
|
}
|
return new DataGrid(list, 0L);
|
}
|
@Override
|
public MatTypeBean getMatTypeById(String id) throws Exception{
|
MdMatType mdMatType = mdMatTypeDao.findById(MdMatType.class, id);
|
MatTypeBean matTypeBean = BeanConvertor.copyProperties(mdMatType,MatTypeBean.class);
|
if(mdMatType.getMdMatGrp()!=null){
|
matTypeBean.setMatGrp(mdMatType.getMdMatGrp().getName());
|
}
|
return matTypeBean;
|
|
}
|
@Override
|
public DataGrid getAllTypesByGrp(String gid) throws Exception {
|
String hql = "from MdMatType o left join fetch o.mdMatGrp g where o.del='0' and o.mdMatGrp.id = '"+gid+"' order by cast(o.code as integer) asc";
|
List<MatTypeBean> list = new ArrayList<MatTypeBean>();
|
for (MdMatType mdMatType : mdMatTypeDao.query(hql)) {
|
MatTypeBean typeBean = BeanConvertor.copyProperties(mdMatType, MatTypeBean.class);
|
if(mdMatType.getMdMatGrp()!=null){
|
typeBean.setMatGrp(mdMatType.getMdMatGrp().getName());
|
}
|
FillUserInfoUtil.fillCreateAndUpdateUserInfo(mdMatType,typeBean);
|
list.add(typeBean);
|
}
|
return new DataGrid(list, 0L);
|
|
}
|
|
@Override
|
public void batchDeleteMatType(String ids) {
|
String[] split = ids.split(",");
|
for (int i = 0; i < split.length; i++) {
|
mdMatTypeDao.updateByParams("update MdMatType o set o.del='1' where o.id=?", split[i]);
|
}
|
loadComboboxService.initCombobox(ComboboxType.MATTYPE);
|
}
|
}
|
