package com.shlanbao.tzsc.pms.qm.qmOutWord.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
import com.shlanbao.tzsc.utils.tools.LogAnno;
|
import org.apache.commons.lang.StringUtils;
|
import org.hibernate.Query;
|
import org.hibernate.Session;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.shlanbao.tzsc.base.dao.QmOutwardDefectItemDaoI;
|
import com.shlanbao.tzsc.base.dao.QmSelfCheckStripDaoI;
|
import com.shlanbao.tzsc.base.mapping.QmOutwardDefectItem;
|
import com.shlanbao.tzsc.base.mapping.QmSelfCheckStrip;
|
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.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.DateUtil;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
import com.shlanbao.tzsc.pms.qm.qmOutWord.beans.QmOutwardDefectItemBean;
|
import com.shlanbao.tzsc.pms.qm.qmOutWord.service.QmOutwardDefectItemService;
|
/**
|
* 缺陷定义查询实现类
|
* <li>@author luther.zhang
|
* <li>@create 2015-02-27
|
*/
|
@Service
|
public class QmOutwardDefectItemServiceImpl extends BaseService implements QmOutwardDefectItemService{
|
@Autowired
|
private QmOutwardDefectItemDaoI qmOutwardDefectItemDao;
|
private QmSelfCheckStripDaoI qmSelfCheckStripDao;
|
@Override
|
public DataGrid queryList(QmOutwardDefectItemBean bean, PageParams pageParams) throws Exception{
|
StringBuffer hql=new StringBuffer();
|
hql.append("from QmOutwardDefectItem q ");
|
|
hql.append("where q.del=0 ");//表示没删除
|
|
List<Object> params = new ArrayList<Object>();
|
|
if(StringUtil.notNull(bean.getCode())){//缺陷名称
|
hql.append(" and q.code like '%"+bean.getCode()+"%'");
|
//params.add(bean.getName());
|
}
|
if(StringUtil.notNull(bean.getName())){//缺陷名称
|
hql.append(" and q.name like '%"+bean.getName()+"%'");
|
//params.add(bean.getName());
|
}
|
if(StringUtil.notNull(bean.getType())){//缺陷类型
|
hql.append("and q.type = ? ");
|
params.add(bean.getType());
|
}
|
if(StringUtil.notNull(bean.getLvl())){//缺陷等级
|
hql.append("and q.lvl = ? ");
|
params.add(bean.getLvl());
|
}
|
|
try {
|
long total=qmOutwardDefectItemDao.queryTotal("select count(*) "+hql.toString(),params);
|
|
List<QmOutwardDefectItemBean> list= new ArrayList<QmOutwardDefectItemBean>();
|
if(total>0){
|
//hql.append("order by q.lvl asc ");
|
List<QmOutwardDefectItem> rows = qmOutwardDefectItemDao.queryByPage(hql.toString(), pageParams.getPage(), pageParams.getRows(), params);
|
for(QmOutwardDefectItem strip:rows){
|
QmOutwardDefectItemBean qmBean = BeanConvertor.copyProperties(strip, QmOutwardDefectItemBean.class);
|
list.add(qmBean);
|
}
|
}
|
return new DataGrid(list, total);
|
} catch (Exception e) {
|
log.error("POVO转换异常", e);
|
}
|
return null;
|
}
|
|
@LogAnno(operateType = "批量删除缺陷定义数据")
|
@Override
|
public void deleteDefectDefinition(String ids) {
|
String[] split = ids.split(",");
|
for (int i = 0; i < split.length; i++) {
|
qmOutwardDefectItemDao.deleteByParams("update QmOutwardDefectItem set del='1' where id=?", split[i]);
|
}
|
}
|
|
}
|
