package com.shlanbao.tzsc.pms.qm.qmsd.service.impl;
|
|
import com.shlanbao.tzsc.base.dao.MdMatDaoI;
|
import com.shlanbao.tzsc.base.dao.QmStdDaoI;
|
import com.shlanbao.tzsc.base.mapping.MdMat;
|
import com.shlanbao.tzsc.base.mapping.QmStd;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.model.PageParams;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.pms.qm.qmsd.bean.QmStdBean;
|
import com.shlanbao.tzsc.pms.qm.qmsd.service.QmStdService;
|
import com.shlanbao.tzsc.utils.tools.DateUtil;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
@Service
|
public class QmStdServiceImpl extends BaseService implements QmStdService {
|
@Autowired
|
private QmStdDaoI qmStdDaoI;
|
@Autowired
|
private MdMatDaoI mdMatDaoI;
|
@Override
|
public DataGrid queryList(QmStdBean bean, PageParams pageParams) throws Exception {
|
List<QmStdBean > list = new ArrayList<>();
|
List<Object> params = new ArrayList<Object>();
|
StringBuffer hql=new StringBuffer();
|
hql.append("from QmStd o where 1=1 ");
|
if(StringUtil.notNull(bean.getMatid())){
|
hql.append(" and o.mdMat = "+"'"+bean.getMatid()+"'");
|
}
|
if (StringUtil.notEmpty(bean.getEffedate()) ) {
|
hql.append(" and to_char(o.effedate,'yyyy-mm-dd')='"+bean.getEffedate()+"'");
|
}
|
List<QmStd> rows = qmStdDaoI.queryByPage(hql.toString(), pageParams.getPage(), pageParams.getRows(), params);
|
Long count = 0l;
|
if(rows!=null&&rows.size()>0) {
|
count = Long.valueOf(rows.size());
|
for (QmStd item:rows){
|
QmStdBean qmStdBean = new QmStdBean();
|
qmStdBean.setId(item.getId());
|
if(item.getMatname()!=null) qmStdBean.setMatname(item.getMatname());
|
if(item.getWeightstd()!=null) qmStdBean.setWeightstd(item.getWeightstd());
|
if(item.getCirsd()!=null) qmStdBean.setCirsd(item.getCirsd());
|
if(item.getRoundsd()!=null) qmStdBean.setRoundsd(item.getRoundsd());
|
if(item.getLensd()!=null) qmStdBean.setLensd(item.getLensd());
|
if(item.getXzsd()!=null) qmStdBean.setXzsd(item.getXzsd());
|
if(item.getVentsd()!=null) qmStdBean.setVentsd(item.getVentsd());
|
if(item.getHdsd()!=null) qmStdBean.setHdsd(item.getHdsd());
|
if(item.getEffedate()!=null) {
|
String date = DateUtil.formatDateToString(item.getEffedate(), "yyyy-MM-dd");
|
qmStdBean.setEffedate(date);
|
}
|
list.add(qmStdBean);
|
}
|
}
|
|
|
return new DataGrid(list,count) ;
|
}
|
|
@Override
|
public void saveOrUpdate(QmStdBean bean) throws Exception {
|
|
MdMat mat = mdMatDaoI.findById(MdMat.class, bean.getMatid());
|
|
QmStd o = new QmStd();
|
o.setId(bean.getId());
|
o.setCirsd(bean.getCirsd());
|
o.setMatname(bean.getMatname());
|
o.setWeightstd(bean.getWeightstd());
|
o.setRoundsd(bean.getRoundsd());
|
o.setLensd(bean.getLensd());
|
o.setXzsd(bean.getXzsd());
|
o.setVentsd(bean.getVentsd());
|
o.setHdsd(bean.getHdsd());
|
if(mat!=null){
|
o.setMatname(mat.getName());
|
o.setMdMat(mat);
|
}
|
if(bean.getEffedate()!=null){
|
Date date = DateUtil.strToDate(bean.getEffedate(), "yyyy-MM-dd");
|
o.setEffedate(date);
|
}
|
if(bean.getMatid()!=null){
|
MdMat mdMat = new MdMat();
|
mdMat.setId(bean.getMatid());
|
o.setMdMat(mdMat);
|
}
|
qmStdDaoI.saveOrUpdate(o);
|
|
}
|
|
@Override
|
public void delSd(String id) throws Exception {
|
qmStdDaoI.deleteById(id,QmStd.class);
|
}
|
|
@Override
|
public void batchDeleteSd(String ids) throws Exception {
|
String[] split = ids.split(",");
|
for (int i =0;i<split.length;i++){
|
qmStdDaoI.deleteById(split[i],QmStd.class);
|
}
|
}
|
|
@Override
|
public QmStdBean querySdById(String id) {
|
QmStd bean = qmStdDaoI.findById(QmStd.class, id);
|
QmStdBean o = new QmStdBean();
|
o.setId(bean.getId());
|
o.setCirsd(bean.getCirsd());
|
o.setMatname(bean.getMatname());
|
o.setWeightstd(bean.getWeightstd());
|
o.setRoundsd(bean.getRoundsd());
|
o.setLensd(bean.getLensd());
|
o.setXzsd(bean.getXzsd());
|
o.setVentsd(bean.getVentsd());
|
o.setHdsd(bean.getHdsd());
|
if(bean.getEffedate()!=null){
|
String date = DateUtil.formatDateToString(bean.getEffedate(), "yyyy-MM-dd");
|
o.setEffedate(date);
|
}
|
if(bean.getMdMat()!=null){
|
|
o.setMatid(bean.getMdMat().getId());
|
}
|
return o;
|
}
|
}
|
