package com.shlanbao.tzsc.pms.equ.eqpWheelCover.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
|
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.EqmWheelCoverDaoI;
|
import com.shlanbao.tzsc.base.mapping.EqmWheelCover;
|
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.PageParams;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.pms.equ.eqpWheelCover.service.EqmWheelCoverServiceI;
|
import com.shlanbao.tzsc.utils.tools.DateUtil;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
|
|
@Service
|
public class EqmWheelCoverServiceImpl extends BaseService implements EqmWheelCoverServiceI {
|
@Autowired
|
private EqmWheelCoverDaoI eqmWheelCoverDaoI;
|
@Autowired
|
private BaseDaoI<Object> baseDao;
|
@LogAnno(operateType = "新增设备轮保数据明细")
|
@Override
|
public boolean addBean(EqmWheelCover bean) {
|
return eqmWheelCoverDaoI.save(bean);
|
|
}
|
@Override
|
public EqmWheelCover getBeanById(String id) {
|
EqmWheelCover eqmWheelCover=eqmWheelCoverDaoI.findById(EqmWheelCover.class, id);
|
List<?> sysEc = eqmWheelCoverDaoI.queryBySql("select name from SYS_EQP_CATEGORY where id = ?", eqmWheelCover.getSysEc());
|
if (sysEc != null && sysEc.size() > 0) {
|
eqmWheelCover.setCategoryName(sysEc.get(0).toString());
|
}
|
List<?> role = eqmWheelCoverDaoI.queryBySql("select name from SYS_ROLE where id = ?", eqmWheelCover.getRoleId());
|
if (role != null && role.size() > 0) {
|
eqmWheelCover.setRoleName(role.get(0).toString());
|
}
|
eqmWheelCover.setcTime(DateUtil.formatDateToString(eqmWheelCover.getCreateTime(), "yyyy-MM-dd HH:mm:ss"));
|
eqmWheelCover.setuTime(DateUtil.formatDateToString(eqmWheelCover.getLastUpdateTime(), "yyyy-MM-dd HH:mm:ss"));
|
return eqmWheelCover;
|
}
|
@Override
|
public EqmWheelCover getBeanByIds(String id) throws Exception {
|
EqmWheelCover eqmWheelCover=eqmWheelCoverDaoI.findById(EqmWheelCover.class, id);
|
List<?> sysEc = eqmWheelCoverDaoI.queryBySql("select name from SYS_EQP_CATEGORY where id = ?", eqmWheelCover.getSysEc());
|
if (sysEc != null && sysEc.size() > 0) {
|
eqmWheelCover.setCategoryName(sysEc.get(0).toString());
|
}
|
List<?> role = eqmWheelCoverDaoI.queryBySql("select name from SYS_ROLE where id = ?", eqmWheelCover.getRoleId());
|
if (role != null && role.size() > 0) {
|
eqmWheelCover.setRoleName(role.get(0).toString());
|
}
|
eqmWheelCover.setcTime(DateUtil.formatDateToString(eqmWheelCover.getCreateTime(), "yyyy-MM-dd HH:mm:ss"));
|
eqmWheelCover.setuTime(DateUtil.formatDateToString(eqmWheelCover.getLastUpdateTime(), "yyyy-MM-dd HH:mm:ss"));
|
return eqmWheelCover;
|
}
|
@Override
|
public DataGrid queryWheelCoverById(SysEqpCategory bean, PageParams pageParams) {
|
List<EqmWheelCover> beans = new ArrayList<EqmWheelCover>();
|
StringBuffer sb=new StringBuffer();
|
long total=0;
|
sb.append(" select a.*,c.name roleName,b.name ecName from EQM_WHEELCOVER a ");
|
sb.append(" join SYS_EQP_CATEGORY b on a.SYS_EC = b.id left join SYS_ROLE c on a.role_id = c.id ");
|
sb.append(" where b.maintainace_type='"+bean.getMaintainaceType()+"' and b.id='"+bean.getId()+"'");
|
if(StringUtil.notEmpty(bean.getCode())&&!"4".equals(bean.getCode())){
|
sb.append(" and a.SHIFT_ID ="+StringUtil.convert2Integer(bean.getCode())+"");
|
}
|
if (StringUtil.notEmpty(bean.getEquLocation())) {
|
sb.append(" and a.MAIN_MENU like '%"+bean.getEquLocation()+"%'");
|
}
|
if (StringUtil.notEmpty(bean.getSpePerson())) {
|
sb.append(" and c.NAME like '%"+bean.getSpePerson()+"%'");
|
}
|
sb.append(" order by a.num asc ");
|
List<?> list= eqmWheelCoverDaoI.queryBySql(sb.toString());
|
if(list!=null && list.size()>0){
|
EqmWheelCover eb=null;
|
for(Object o:list){
|
Object[] temp=(Object[]) o;
|
eb=new EqmWheelCover();
|
eb.setId(StringUtil.convertObjToString(temp[0]));
|
eb.setMainMenu(StringUtil.convertObjToString(temp[1]));
|
eb.setMainStandards( StringUtil.convertObjToString(temp[2]));
|
eb.setInsResult( StringUtil.convertObjToString(temp[3]));
|
eb.setSchUserName( StringUtil.convertObjToString(temp[4]));
|
eb.setCycle(StringUtil.convertObjToString(temp[5]));
|
eb.setRemark( StringUtil.convertObjToString(temp[6]));
|
eb.setCreateTime(DateUtil.formatStringToDate(temp[7].toString(), "yyyy-MM-dd HH:mm:ss"));
|
eb.setcTime(StringUtil.convertObjToString(temp[7]));
|
eb.setLastUpdateTime(DateUtil.formatStringToDate(temp[8].toString(), "yyyy-MM-dd HH:mm:ss"));
|
eb.setuTime(StringUtil.convertObjToString(temp[8]));
|
eb.setSysEc( StringUtil.convertObjToString(temp[9]));
|
eb.setRoleId(StringUtil.convertObjToString(temp[10]));
|
eb.setNum(StringUtil.convert2Integer(temp[11]));
|
eb.setDel(StringUtil.convert2Integer(temp[12]));
|
eb.setShiftId(StringUtil.convert2Integer(temp[13]));
|
eb.setRoleName( StringUtil.convertObjToString(temp[14]));
|
eb.setCategoryName( StringUtil.convertObjToString(temp[15]));
|
beans.add(eb);
|
}
|
}
|
return new DataGrid(beans, total);
|
}
|
|
@Override
|
public void batchDeleteWheelCover(String ids) {
|
String[] split = ids.split(",");
|
try {
|
for (int i = 0; i < split.length; i++) {
|
eqmWheelCoverDaoI.deleteById(split[i], EqmWheelCover.class);
|
}
|
}catch (Exception e){
|
e.printStackTrace();
|
}
|
|
}
|
|
@LogAnno(operateType = "编辑设备轮保数据明细")
|
@Override
|
public boolean updateBean(EqmWheelCover bean) {
|
bean.setCreateTime(DateUtil.formatStringToDate(bean.getcTime(), "yyyy-MM-dd HH:mm:ss"));
|
bean.setLastUpdateTime(new Date());
|
return eqmWheelCoverDaoI.saveOrUpdate(bean);
|
}
|
|
|
@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 deleteWheelCover(String id) {
|
eqmWheelCoverDaoI.deleteById(id, EqmWheelCover.class);
|
}
|
|
|
}
|
