package com.shlanbao.tzsc.pms.cos.matassess.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.shlanbao.tzsc.base.dao.CosMatAssessDaoI;
|
import com.shlanbao.tzsc.base.dao.CosMatAssessParamDaoI;
|
import com.shlanbao.tzsc.base.dao.MdMatDaoI;
|
import com.shlanbao.tzsc.base.dao.SchConStdDaoI;
|
import com.shlanbao.tzsc.base.mapping.CosMatAssess;
|
import com.shlanbao.tzsc.base.mapping.CosMatAssessParam;
|
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.model.PageParams;
|
import com.shlanbao.tzsc.pms.cos.matassess.bean.CosMatAssessParamBean;
|
import com.shlanbao.tzsc.pms.cos.matassess.service.CosMatAssessParamServiceI;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
/**
|
*
|
* @ClassName: CosMatAssessServiceImpl
|
* @Description: 辅料考核版本控制ServiceImpl
|
* @author luoliang
|
* @date 2015-1-7 上午10:44:37
|
*
|
*/
|
@Service
|
public class CosMatAssessParamServiceImpl implements CosMatAssessParamServiceI{
|
|
|
@Autowired
|
private CosMatAssessParamDaoI cosMatAssessParamDao;
|
@Autowired
|
private CosMatAssessDaoI cosMatAssessDao;
|
@Autowired
|
private SchConStdDaoI schConStdDaol;
|
@Autowired
|
private MdMatDaoI mdMatDao;
|
|
//添加或修改Bean
|
@Override
|
public boolean addOrUpdateBean(CosMatAssessParamBean bean) throws Exception {
|
CosMatAssessParam cosMatAssessParam=new CosMatAssessParam();
|
if(!StringUtil.notNull(bean.getId())){
|
bean.setId(null);
|
}else{
|
cosMatAssessParam=getBeanByIds(bean.getId());
|
}
|
cosMatAssessParam.setVal(bean.getVal());
|
cosMatAssessParam.setRemark(bean.getRemark());
|
cosMatAssessParam.setUnitprice(bean.getUnitprice());
|
cosMatAssessParam.setUval(bean.getUval());
|
cosMatAssessParam.setLval(bean.getLval());
|
if(StringUtil.notNull(bean.getMatId())){
|
MdMat m=mdMatDao.findById(MdMat.class, bean.getMatId());
|
if(m!=null){
|
cosMatAssessParam.setMat(m);
|
}
|
}
|
if(StringUtil.notNull(bean.getCid())){
|
CosMatAssess c=cosMatAssessDao.findById(CosMatAssess.class, bean.getCid());
|
if(c!=null){
|
cosMatAssessParam.setCid(c);
|
}
|
}
|
if(StringUtil.notNull(bean.getStdID())){
|
SchConStd s=schConStdDaol.findById(SchConStd.class, bean.getStdID());
|
if(s!=null){
|
cosMatAssessParam.setStdID(s);
|
}
|
}
|
cosMatAssessParamDao.saveOrUpdate(cosMatAssessParam);
|
return true;
|
}
|
//根据ID获取mapping bean
|
@Override
|
public CosMatAssessParam getBeanByIds(String id) throws Exception {
|
return cosMatAssessParamDao.findById(CosMatAssessParam.class, id);
|
}
|
|
//根据ID获取bean
|
@Override
|
public CosMatAssessParamBean getBeanById(String id) throws Exception {
|
CosMatAssessParam c = cosMatAssessParamDao.findById(CosMatAssessParam.class, id);
|
CosMatAssessParamBean b=new CosMatAssessParamBean();
|
b.setVal(c.getVal());
|
b.setRemark(c.getRemark());
|
b.setUnitprice(c.getUnitprice());
|
b.setUval(c.getUval());
|
b.setLval(c.getLval());
|
b.setCid(c.getCid().getId());
|
b.setId(c.getId());
|
b.setMatId(c.getMat().getId());
|
b.setMatName(c.getMat().getName());
|
b.setStdID(c.getStdID().getId());
|
return b;
|
}
|
//查询
|
@Override
|
public List<CosMatAssessParam> queryBeans(CosMatAssessParam bean,PageParams pageParams){
|
String hql="from CosMatAssessParam o where 1=1 ";
|
StringBuffer params = new StringBuffer();
|
if(StringUtil.notNull(bean.getId())) params.append(" and o.id='" + bean.getId() + "'");
|
if(bean.getCid()!=null&&StringUtil.notNull(bean.getCid().getId())) params.append(" and o.cid='" + bean.getCid().getId() + "'");
|
if(StringUtil.notNull(bean.getMat().getId())) params.append(" and o.mdmat.id='"+bean.getMat().getId()+"'");
|
return cosMatAssessParamDao.queryByPage(hql.concat(params.toString()),pageParams);
|
}
|
|
//查询
|
@Override
|
public List<CosMatAssessParam> queryBeansByExpand(CosMatAssessParamBean bean,PageParams pageParams){
|
String hql="from CosMatAssessParam o where 1=1 ";
|
StringBuffer params = new StringBuffer();
|
if(StringUtil.notNull(bean.getId())) params.append(" and o.id='" + bean.getId() + "'");
|
if(StringUtil.notNull(bean.getCid())) params.append(" and o.cid='" + bean.getCid() + "'");
|
if(StringUtil.notNull(bean.getMatId())) params.append(" and o.mat='"+bean.getMatId()+"'");
|
return cosMatAssessParamDao.queryByPage(hql.concat(params.toString()),pageParams);
|
}
|
|
//界面中翻页查询
|
@Override
|
public DataGrid queryBean(CosMatAssessParam bean, PageParams pageParams) throws Exception {
|
String hql="from CosMatAssessParam o where 1=1 ";
|
StringBuffer params = new StringBuffer();
|
if(StringUtil.notNull(bean.getId())) params.append(" and o.id='" + bean.getId() + "'");
|
if(bean.getCid()!=null&&StringUtil.notNull(bean.getCid().getId())) params.append(" and o.cid='" + bean.getCid().getId() + "'");
|
List<CosMatAssessParam> oldbeans = cosMatAssessParamDao.queryByPage(hql.concat(params.toString()),pageParams);
|
List<CosMatAssessParamBean> beans=new ArrayList<CosMatAssessParamBean>();
|
for(CosMatAssessParam c:oldbeans){
|
CosMatAssessParamBean b=new CosMatAssessParamBean();
|
b.setLval(c.getLval());
|
b.setRemark(c.getRemark());
|
b.setUnitprice(c.getUnitprice());
|
b.setUval(c.getUval());
|
b.setVal(c.getVal());
|
b.setCid(c.getCid().getId());
|
b.setId(c.getId());
|
b.setMatId(c.getMat().getId());
|
b.setMatName(c.getMat().getName());
|
b.setStdID(c.getStdID().getId());
|
beans.add(b);
|
}
|
hql = "select count(*) from CosMatAssessParam o where 1=1 ";
|
long total = cosMatAssessParamDao.queryTotal(hql.concat(params.toString()));
|
|
return new DataGrid(beans,total);
|
}
|
|
}
|
