package com.shlanbao.tzsc.pms.cos.incomplete.service.impl;
|
|
import java.util.List;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
|
|
import com.shlanbao.tzsc.base.dao.CosIncompleteCoefficientDaoI;
|
import com.shlanbao.tzsc.base.mapping.CosIncompleteCoefficient;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.model.PageParams;
|
import com.shlanbao.tzsc.pms.cos.incomplete.service.IncompleteCoefficientServiceI;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
@Service
|
public class IncompleteCoefficientServiceImpl implements IncompleteCoefficientServiceI {
|
|
@Autowired
|
public CosIncompleteCoefficientDaoI incompleteCoefficientDao;
|
|
@Override
|
public CosIncompleteCoefficient queryBeanById(String id) {
|
return incompleteCoefficientDao.findById(CosIncompleteCoefficient.class, id);
|
}
|
|
/**
|
* 查询
|
*/
|
@Override
|
public List<CosIncompleteCoefficient> queryBeanListByBean(CosIncompleteCoefficient bean) {
|
String hql="from CosIncompleteCoefficient o where 1=1 ";
|
StringBuffer params=new StringBuffer();
|
if(StringUtil.notNull(bean.getId())) params.append("and o.id='"+bean.getId()+"' ");
|
if(StringUtil.notNull(bean.getCode())) params.append("and o.code='"+bean.getCode()+"' ");
|
if(StringUtil.notNull(bean.getName())) params.append("and o.name='"+bean.getName()+"' ");
|
return incompleteCoefficientDao.query(hql.concat(params.toString()));
|
}
|
|
/**
|
* 界面查询,返回DataGrid
|
*/
|
@Override
|
public DataGrid queryBeanGridByBean(CosIncompleteCoefficient bean,PageParams pageParams) {
|
String hql="from CosIncompleteCoefficient o where 1=1 ";
|
StringBuffer params=new StringBuffer();
|
if(StringUtil.notNull(bean.getId())) params.append("and o.id='"+bean.getId()+"' ");
|
if(StringUtil.notNull(bean.getCode())) params.append("and o.code='"+bean.getCode()+"' ");
|
if(StringUtil.notNull(bean.getName())) params.append("and o.name like '%"+bean.getName()+"%' ");
|
List<CosIncompleteCoefficient> lists=incompleteCoefficientDao.queryByPage(hql.concat(params.toString()), pageParams);
|
hql = "select count(*) from CosMatAssess o where 1=1 ";
|
long total = incompleteCoefficientDao.queryTotal(hql.concat(params.toString()));
|
return new DataGrid(lists,total);
|
}
|
|
/**
|
* 添加或修改
|
*/
|
@Override
|
public boolean addOrUpdateBean(CosIncompleteCoefficient bean) {
|
return incompleteCoefficientDao.saveOrUpdate(bean);
|
}
|
}
|