package com.shlanbao.tzsc.pms.equ.eqpInspection.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.UUID;
|
|
import javax.servlet.http.HttpSession;
|
|
import com.shlanbao.tzsc.utils.tools.LogAnno;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.shlanbao.tzsc.base.dao.BaseDaoI;
|
import com.shlanbao.tzsc.base.dao.EqmInspectionDaoI;
|
import com.shlanbao.tzsc.base.interceptor.WorkOrderStatChangeInterceptor;
|
import com.shlanbao.tzsc.base.mapping.EqmInspection;
|
import com.shlanbao.tzsc.base.mapping.SysEqpCategory;
|
import com.shlanbao.tzsc.base.mapping.SysRole;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.model.Json;
|
import com.shlanbao.tzsc.base.model.PageParams;
|
import com.shlanbao.tzsc.base.model.SessionInfo;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.pms.equ.eqpInspection.bean.EqmInspectionBean;
|
import com.shlanbao.tzsc.pms.equ.eqpInspection.service.EqmInspectionServiceI;
|
import com.shlanbao.tzsc.pms.equ.overhaul.beans.RepairCallInfoBean;
|
import com.shlanbao.tzsc.pms.sys.repairResquest.beans.RepairResquestBean;
|
import com.shlanbao.tzsc.pms.sys.user.beans.UserBean;
|
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.DateUtil;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
|
|
@Service
|
public class EqmInspectionServiceImpl extends BaseService implements EqmInspectionServiceI {
|
@Autowired
|
private EqmInspectionDaoI InspectionDao;
|
@Autowired
|
private BaseDaoI<Object> baseDao;
|
@LogAnno(operateType = "新增设备点检数据明细")
|
@Override
|
public boolean addBean(EqmInspection bean) {
|
return InspectionDao.save(bean);
|
|
}
|
@Override
|
public EqmInspection getBeanById(String id) {
|
return InspectionDao.findById(EqmInspection.class, id);
|
}
|
@Override
|
public EqmInspectionBean getBeanByIds(String id) throws Exception {
|
EqmInspection eqmInspection=InspectionDao.findById(EqmInspection.class, id);
|
EqmInspectionBean bean=BeanConvertor.copyProperties(eqmInspection, EqmInspectionBean.class);
|
bean.setCategoryId(eqmInspection.getSysEqpCategory().getId());
|
bean.setCategoryName(eqmInspection.getSysEqpCategory().getName());
|
return bean;
|
}
|
@Override
|
public DataGrid queryInspectionById(SysEqpCategory bean, PageParams pageParams) {
|
List<EqmInspectionBean> beans = new ArrayList<EqmInspectionBean>();
|
StringBuffer sb=new StringBuffer();
|
long total=0;
|
sb.append(" select a.ID,a.NUM,a.SYSTEM_NAME,a.PARTS_NAME,a.SPARE_PARTS_NAME,a.FIXED_POINTS,a.IMPORTANCE,a.SAFETY_WARNING,a.CHECK_CONTENTS,a.CYCLE,a.DEVICE_STATUS, ");
|
sb.append(" a.CHECK_METHOD,a.JUDGEMENT_STANDARD,a.BRK,a.MAIN_STANDARDS,a.MAIN_METHOD,a.SPE_PERSON,a.REC_MEASURES,a.DES,a.CREATE_TIME,a.LAST_UPDATE_TIME,a.SYS_EC,a.ENABLE,a.ROLE_ID,a.SHIFT_ID from EQM_INSPECTION a,SYS_EQP_CATEGORY b ");
|
sb.append(" where b.maintainace_type='"+bean.getMaintainaceType()+"' and b.id='"+bean.getId()+"' and a.SYS_EC=b.id ");
|
if(StringUtil.notEmpty(bean.getCode())&&!"4".equals(bean.getCode())){
|
sb.append(" and a.SHIFT_ID ="+StringUtil.convert2Integer(bean.getCode())+"");
|
}
|
if (StringUtil.notEmpty(bean.getSpePerson())) {
|
sb.append(" and a.SPE_PERSON like '%"+bean.getSpePerson()+"%'");
|
}
|
if (StringUtil.notEmpty(bean.getSystemName())) {
|
sb.append(" and a.SYSTEM_NAME like '%"+bean.getSystemName()+"%'");
|
}
|
sb.append(" order by a.num asc ");
|
List<?> list= InspectionDao.queryBySql(sb.toString());
|
if(list!=null && list.size()>0){
|
EqmInspectionBean eb=null;
|
for(Object o:list){
|
Object[] temp=(Object[]) o;
|
eb=new EqmInspectionBean();
|
eb.setId(StringUtil.convertObjToString(temp[0]));
|
eb.setNum(StringUtil.convert2Integer(temp[1]));
|
eb.setSystemName(StringUtil.convertObjToString(temp[2]));
|
eb.setPartsName(StringUtil.convertObjToString(temp[3]));
|
eb.setSparePartsname(StringUtil.convertObjToString(temp[4]));
|
eb.setFixedPoints(StringUtil.convertObjToString(temp[5]));
|
eb.setImportance(StringUtil.convertObjToString(temp[6]));
|
eb.setSafetyWarning(StringUtil.convertObjToString(temp[7]));
|
eb.setCheckContents(StringUtil.convertObjToString(temp[8]));
|
eb.setCycle(StringUtil.convertObjToString(temp[9]));
|
eb.setDeviceStatus(StringUtil.convertObjToString(temp[10]));
|
eb.setCheckMethod(StringUtil.convertObjToString(temp[11]));
|
eb.setJudgementStandard(StringUtil.convertObjToString(temp[12]));
|
eb.setBrk(StringUtil.convertObjToString(temp[13]));
|
eb.setMainStandards(StringUtil.convertObjToString(temp[14]));
|
eb.setMainMethod(StringUtil.convertObjToString(temp[15]));
|
eb.setSpePerson(StringUtil.convertObjToString(temp[16]));
|
eb.setRecMeasures(StringUtil.convertObjToString(temp[17]));
|
eb.setDes(StringUtil.convertObjToString(temp[18]));
|
eb.setCreateTime(DateUtil.formatStringToDate(temp[19].toString(), "yyyy-MM-dd HH:mm:ss"));
|
eb.setLastUpdateTime(DateUtil.formatStringToDate(temp[20].toString(), "yyyy-MM-dd HH:mm:ss"));
|
eb.setCategoryId(StringUtil.convertObjToString(temp[21]));
|
eb.setEnable(StringUtil.convertObjToString(temp[22]));
|
eb.setRoleId(StringUtil.convertObjToString(temp[23]));
|
eb.setShiftId(StringUtil.convert2Integer(temp[24]));
|
beans.add(eb);
|
}
|
}
|
return new DataGrid(beans, total);
|
}
|
|
|
|
@LogAnno(operateType = "编辑设备点检数据明细")
|
@Override
|
public boolean updateBean(EqmInspectionBean bean) {
|
EqmInspection eb=InspectionDao.findById(EqmInspection.class, bean.getId());
|
eb.setNum(bean.getNum());
|
eb.setSystemName(bean.getSystemName());
|
eb.setPartsName(bean.getPartsName());
|
eb.setSparePartsname(bean.getSparePartsname());
|
eb.setFixedPoints(bean.getFixedPoints());
|
eb.setImportance(bean.getImportance());
|
eb.setSafetyWarning(bean.getSafetyWarning());
|
eb.setCheckContents(bean.getCheckContents());
|
eb.setCycle(bean.getCycle());
|
eb.setDeviceStatus(bean.getDeviceStatus());
|
eb.setCheckMethod(bean.getCheckMethod());
|
eb.setJudgementStandard(bean.getJudgementStandard());
|
eb.setBrk(bean.getBrk());
|
eb.setMainStandards(bean.getMainStandards());
|
eb.setMainMethod(bean.getMainMethod());
|
eb.setSpePerson(bean.getSpePerson());
|
eb.setRecMeasures(bean.getRecMeasures());
|
eb.setDes(bean.getDes());
|
eb.setRoleId(bean.getRoleId());
|
eb.setLastUpdateTime(bean.getLastUpdateTime());
|
eb.setEnable(bean.getEnable());
|
eb.setShiftId(bean.getShiftId());
|
return InspectionDao.saveOrUpdate(eb);
|
}
|
|
|
@Override
|
public List<SysRole> getRoleAll() {
|
try {
|
String sql="select id,name from SYS_ROLE where del=0";
|
List<?> list=baseDao.queryBySql(sql);
|
List<SysRole> srlist=new ArrayList<SysRole>();
|
if(list!=null && list.size()>0){
|
SysRole sr=null;
|
for(Object o:list){
|
Object[] temp=(Object[]) o;
|
sr=new SysRole();
|
sr.setId(StringUtil.convertObjToString(temp[0]));
|
sr.setName(StringUtil.convertObjToString(temp[1]));
|
srlist.add(sr);
|
}
|
}
|
return srlist;
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return null;
|
}
|
@LogAnno(operateType = "删除设备点检数据明细")
|
@Override
|
public void deleteInspection(String id) {
|
InspectionDao.deleteById(id, EqmInspection.class);
|
}
|
@LogAnno(operateType = "批量删除设备点检数据明细")
|
@Override
|
public void batchDeleteInspection(String ids) {
|
String[] split = ids.split(",");
|
try {
|
for (int i = 0; i < split.length; i++) {
|
InspectionDao.deleteById(split[i], EqmInspection.class);
|
}
|
}catch (Exception e){
|
e.printStackTrace();
|
}
|
|
|
}
|
|
}
|
