package com.shlanbao.tzsc.pms.cos.matassess.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
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.MdEqpTypeDaoI;
|
import com.shlanbao.tzsc.base.dao.MdMatDaoI;
|
import com.shlanbao.tzsc.base.mapping.CosMatAssess;
|
import com.shlanbao.tzsc.base.mapping.MdEqpType;
|
import com.shlanbao.tzsc.base.mapping.MdMat;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.model.PageParams;
|
import com.shlanbao.tzsc.pms.cos.matassess.bean.CosMatAssessBean;
|
import com.shlanbao.tzsc.pms.cos.matassess.service.CosMatAssessServiceI;
|
import com.shlanbao.tzsc.utils.extents.DateFmtAnnotation;
|
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.DateUtil;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
/**
|
*
|
* @ClassName: CosMatAssessServiceImpl
|
* @Description: 辅料考核版本控制ServiceImpl
|
* @author luoliang
|
* @date 2015-1-7 上午10:44:37
|
*
|
*/
|
@Service
|
public class CosMatAssessServiceImpl implements CosMatAssessServiceI{
|
|
private static final String STATUS1="新建";
|
private static final String STATUS2="生效";
|
private static final String STATUS3="归档";
|
|
@Autowired
|
private CosMatAssessDaoI cosMatAssessDao;
|
@Autowired
|
private MdMatDaoI mdMatDao;
|
@Autowired
|
private MdEqpTypeDaoI mdEqpTypeDao;
|
|
//添加或修改Bean
|
@Override
|
public boolean addOrUpdateBean(CosMatAssessBean bean) throws Exception {
|
CosMatAssess cosMatAssess=new CosMatAssess();
|
if(!StringUtil.notNull(bean.getId())){
|
bean.setId(null);
|
cosMatAssess.setStatus(STATUS1);
|
cosMatAssess.setStatusLasting(DateUtil.getNowDateTime(null));
|
}else{
|
cosMatAssess=getBeanByIds(bean.getId());
|
}
|
BeanConvertor.copyProperties(bean,cosMatAssess);
|
if(StringUtil.notNull(bean.getMdMatId())){
|
MdMat mat=mdMatDao.findById(MdMat.class, bean.getMdMatId());
|
if(mat!=null){
|
cosMatAssess.setMdMat(mat);
|
}
|
}else{
|
throw new Exception();
|
}
|
if(StringUtil.notNull(bean.getEqpTypeID())){
|
MdEqpType mdEqpType=mdEqpTypeDao.findById(MdEqpType.class, bean.getEqpTypeID());
|
if(mdEqpType!=null){
|
cosMatAssess.setEqpType(mdEqpType);
|
}
|
}
|
cosMatAssessDao.saveOrUpdate(cosMatAssess);
|
return true;
|
}
|
//根据ID获取mapping bean
|
@Override
|
public CosMatAssess getBeanByIds(String id) throws Exception {
|
return cosMatAssessDao.findById(CosMatAssess.class, id);
|
}
|
//版本生效
|
@Override
|
public boolean editStatus(String id) throws Exception{
|
CosMatAssess cosMatAssess=getBeanByIds(id);
|
//查询当前 机型、牌号有没有生效的版本
|
CosMatAssess bean=new CosMatAssess();
|
bean.setStatus(STATUS2);
|
bean.setEqpType(cosMatAssess.getEqpType());
|
bean.setMdMat(cosMatAssess.getMdMat());
|
List<CosMatAssess> oldBeans=queryBeans(bean,new PageParams());
|
//如果存在已经生效的版本，则修改状态为生效状态，并且修改状态变化日期
|
for(CosMatAssess c:oldBeans){
|
c.setStatus(STATUS3);
|
c.setStatusLasting(DateUtil.getNowDateTime(null));
|
cosMatAssessDao.saveOrUpdate(c);
|
}
|
//生效当前
|
cosMatAssess.setStatus(STATUS2);
|
cosMatAssess.setStatusLasting(DateUtil.getNowDateTime(null));
|
cosMatAssessDao.saveOrUpdate(cosMatAssess);
|
return true;
|
}
|
|
//根据ID获取bean
|
@Override
|
public CosMatAssessBean getBeanById(String id) throws Exception {
|
if(!StringUtil.notNull(id)){
|
return null;
|
}
|
CosMatAssess c = cosMatAssessDao.findById(CosMatAssess.class, id);
|
CosMatAssessBean b=new CosMatAssessBean();
|
BeanConvertor.copyProperties(c,b);
|
b.setMdMatId(c.getMdMat().getId());
|
b.setMdMatName(c.getMdMat().getName());
|
b.setEqpTypeName(c.getEqpType().getName());
|
b.setEqpTypeID(c.getEqpType().getId());
|
b.setEqpTypeDes(c.getEqpType().getDes());
|
return b;
|
}
|
//查询
|
@Override
|
public List<CosMatAssess> queryBeans(CosMatAssess bean,PageParams pageParams){
|
String hql="from CosMatAssess o where 1=1 ";
|
StringBuffer params = new StringBuffer();
|
if(StringUtil.notNull(bean.getId())) params.append(" and o.id='" + bean.getId() + "'");
|
if(StringUtil.notNull(bean.getStatus())) params.append(" and o.status='" + bean.getStatus() + "'");
|
if(bean.getEqpType()!=null) params.append(" and o.eqpType.id='" + bean.getEqpType().getId() + "'");
|
if(bean.getMdMat()!=null) params.append(" and o.mdMat.id='" + bean.getMdMat().getId() + "'");
|
return cosMatAssessDao.queryByPage(hql.concat(params.toString()),pageParams);
|
}
|
//界面中翻页查询
|
@Override
|
public DataGrid queryBean(CosMatAssess bean, PageParams pageParams) throws Exception {
|
String hql="from CosMatAssess o where 1=1 ";
|
StringBuffer params = new StringBuffer();
|
if(StringUtil.notNull(bean.getId())) params.append(" and o.id='" + bean.getId() + "'");
|
if(StringUtil.notNull(bean.getStatus())) params.append(" and o.status='" + bean.getStatus() + "'");
|
if(bean.getEqpType()!=null&&StringUtil.notNull(bean.getEqpType().getId())) params.append(" and o.eqpType.id='" + bean.getEqpType().getId() + "'");
|
if(bean.getMdMat()!=null&&StringUtil.notNull(bean.getMdMat().getId())) params.append(" and o.mdMat.id='" + bean.getMdMat().getId() + "'");
|
List<CosMatAssess> oldbeans = cosMatAssessDao.queryByPage(hql.concat(params.toString()),pageParams);
|
List<CosMatAssessBean> beans=new ArrayList<CosMatAssessBean>();
|
for(CosMatAssess c:oldbeans){
|
CosMatAssessBean b=new CosMatAssessBean();
|
BeanConvertor.copyProperties(c, b);
|
b.setMdMatId(c.getMdMat().getId());
|
b.setMdMatName(c.getMdMat().getName());
|
b.setEqpTypeName(c.getEqpType().getName());
|
b.setEqpTypeID(c.getEqpType().getId());
|
b.setEqpTypeDes(c.getEqpType().getDes());
|
beans.add(b);
|
}
|
hql = "select count(*) from CosMatAssess o where 1=1 ";
|
long total = cosMatAssessDao.queryTotal(hql.concat(params.toString()));
|
|
return new DataGrid(beans,total);
|
}
|
|
//界面中翻页查询
|
@Override
|
public DataGrid queryBeanByExtends(CosMatAssessBean bean, PageParams pageParams) throws Exception {
|
String hql="from CosMatAssess o where 1=1 ";
|
StringBuffer params = new StringBuffer();
|
if(StringUtil.notNull(bean.getId())) params.append(" and o.id='" + bean.getId() + "'");
|
if(StringUtil.notNull(bean.getStatus())) params.append(" and o.status='" + bean.getStatus() + "'");
|
if(StringUtil.notNull(bean.getEqpTypeID())) params.append(" and o.eqpType.id='" + bean.getEqpTypeID() + "'");
|
if(StringUtil.notNull(bean.getMdMatId())) params.append(" and o.mdMat.id='" + bean.getMdMatId() + "'");
|
List<CosMatAssess> oldbeans = cosMatAssessDao.queryByPage(hql.concat(params.toString()),pageParams);
|
List<CosMatAssessBean> beans=new ArrayList<CosMatAssessBean>();
|
for(CosMatAssess c:oldbeans){
|
CosMatAssessBean b=new CosMatAssessBean();
|
BeanConvertor.copyProperties(c, b);
|
b.setMdMatId(c.getMdMat().getId());
|
b.setMdMatName(c.getMdMat().getName());
|
b.setEqpTypeName(c.getEqpType().getName());
|
b.setEqpTypeID(c.getEqpType().getId());
|
b.setEqpTypeDes(c.getEqpType().getDes());
|
beans.add(b);
|
}
|
hql = "select count(*) from CosMatAssess o where 1=1 ";
|
long total = cosMatAssessDao.queryTotal(hql.concat(params.toString()));
|
|
return new DataGrid(beans,total);
|
}
|
|
|
|
|
}
|
