package com.shlanbao.tzsc.pms.equ.resume.service.impl;
|
|
|
import java.util.ArrayList;
|
import java.util.List;
|
import java.util.UUID;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.shlanbao.tzsc.base.dao.EqmAuxilDaoI;
|
import com.shlanbao.tzsc.base.mapping.EqmAuxil;
|
import com.shlanbao.tzsc.base.mapping.EqmResume;
|
import com.shlanbao.tzsc.base.mapping.SysUser;
|
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.resume.beans.EqmAuxilBean;
|
import com.shlanbao.tzsc.pms.equ.resume.service.EqmAuxilServiceI;
|
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.DateUtil;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
@Service
|
public class EqmAuxilServiceImpl extends BaseService implements EqmAuxilServiceI {
|
@Autowired
|
private EqmAuxilDaoI eqmAuxilDao;
|
|
@Override
|
public EqmAuxilBean getById(String id) throws Exception {
|
EqmAuxil bean = eqmAuxilDao.findById(EqmAuxil.class, id);
|
EqmAuxilBean lastBean = BeanConvertor.copyProperties(bean, EqmAuxilBean.class);
|
if(null!=bean.getEqmResume()&&!"".equals(bean.getEqmResume())){
|
lastBean.setEqmResumeId(bean.getEqmResume().getId());//设备履历ID
|
lastBean.setEqmResumeName(bean.getEqmResume().getResumeName());
|
}
|
if(null!=bean.getSysUserByAddUserid()&&!"".equals(bean.getSysUserByAddUserid())){
|
lastBean.setAddUserid(bean.getSysUserByAddUserid().getId());
|
lastBean.setAddUserName(bean.getSysUserByAddUserid().getName());
|
}
|
if(null!=bean.getSysUserByModifyUserid()&&!"".equals(bean.getSysUserByModifyUserid())){
|
lastBean.setModifyUserid(bean.getSysUserByModifyUserid().getId());
|
lastBean.setModifyUserName(bean.getSysUserByModifyUserid().getName());
|
}
|
return lastBean;
|
}
|
|
@Override
|
public void addOrEditBean(String eqmResumeId,EqmAuxilBean[] beans,String userId) throws Exception {
|
if(null!=beans){
|
for(int i=0;i<beans.length;i++){
|
EqmAuxilBean bean = beans[i];
|
if(null!=bean.getAuxilId()&&!"".equals(bean.getAuxilId())){//更新
|
EqmAuxil updateBean = eqmAuxilDao.findById(EqmAuxil.class, bean.getAuxilId());
|
SysUser modifyUserBean = new SysUser();
|
modifyUserBean.setId(userId);
|
updateBean.setSysUserByModifyUserid(modifyUserBean);
|
updateBean.setModifyTime(DateUtil.getNowDateTime("yyyy-MM-dd HH:mm:ss"));
|
updateBean.setRemarks(StringUtil.trim(bean.getRemarks()));
|
updateBean.setAuxilName(StringUtil.trim(bean.getAuxilName()));
|
updateBean.setAuxilNorms(StringUtil.trim(bean.getAuxilNorms()));
|
updateBean.setAuxilUnit(StringUtil.trim(bean.getAuxilUnit()));
|
updateBean.setAuxilPrice(StringUtil.trim(bean.getAuxilPrice()));
|
updateBean.setAuxilNumber(StringUtil.trim(bean.getAuxilNumber()));
|
updateBean.setAuxilMoney(StringUtil.trim(bean.getAuxilMoney()));
|
}else{//保存
|
EqmAuxil eqmBean = BeanConvertor.copyProperties(bean, EqmAuxil.class);
|
eqmBean.setAuxilId(UUID.randomUUID().toString());//内部转移主键ID
|
EqmResume eqmResume = new EqmResume();
|
eqmResume.setId(eqmResumeId);
|
eqmBean.setEqmResume(eqmResume);//设备履历ID
|
SysUser modify = new SysUser();
|
modify.setId(userId);
|
eqmBean.setSysUserByModifyUserid(modify);
|
eqmBean.setModifyTime(DateUtil.getNowDateTime("yyyy-MM-dd HH:mm:ss"));
|
SysUser insert = new SysUser();
|
insert.setId(userId);
|
eqmBean.setSysUserByAddUserid(insert);
|
eqmBean.setAddTime(DateUtil.getNowDateTime("yyyy-MM-dd HH:mm:ss"));
|
eqmBean.setDel("0");
|
eqmAuxilDao.save(eqmBean);
|
}
|
}
|
}
|
}
|
@Override
|
public DataGrid queryList(EqmAuxilBean bean,PageParams pageParams) throws Exception {
|
StringBuffer hql = new StringBuffer();
|
hql.append("from EqmAuxil o ");//内部转移
|
hql.append("left join fetch o.eqmResume resume ");//设备履历
|
hql.append("left join fetch o.sysUserByAddUserid addUser ");//用户信息
|
hql.append("left join fetch o.sysUserByModifyUserid modifyUser ");//用户信息
|
hql.append(" where o.del=0 ");//单位信息
|
List<Object> params = new ArrayList<Object>();
|
if(StringUtil.notNull(bean.getEqmResumeId())){
|
hql.append(" and o.eqmResume.id=? ");
|
params.add(bean.getEqmResumeId());
|
}
|
//long total = 0;
|
List<EqmAuxilBean> lastList= new ArrayList<EqmAuxilBean>();
|
try {
|
/*total=eqmInsideDao.queryTotal("select count(*) "+hql.toString().replaceAll("fetch", ""),params);
|
if(total>0){*/
|
hql.append("order by o.modifyTime desc ");
|
// pageParams.getPage(), pageParams.getRows()
|
List<EqmAuxil> rows = eqmAuxilDao.query(hql.toString(), params);
|
for(EqmAuxil eqmBean:rows){
|
EqmAuxilBean oneBean = BeanConvertor.copyProperties(eqmBean, EqmAuxilBean.class);
|
if(null!=eqmBean.getEqmResume()){
|
oneBean.setEqmResumeId(eqmBean.getEqmResume().getId());
|
oneBean.setEqmResumeName(eqmBean.getEqmResume().getResumeName());
|
}
|
if(null!=eqmBean.getSysUserByAddUserid()){
|
oneBean.setAddUserid(eqmBean.getSysUserByAddUserid().getId());
|
oneBean.setAddUserName(eqmBean.getSysUserByAddUserid().getName());
|
}
|
if(null!=eqmBean.getSysUserByModifyUserid()){
|
oneBean.setModifyUserid(eqmBean.getSysUserByModifyUserid().getId());
|
oneBean.setModifyUserName(eqmBean.getSysUserByModifyUserid().getName());
|
}
|
lastList.add(oneBean);
|
}
|
//}
|
} catch (Exception e) {
|
log.error("POVO转换异常", e);
|
}
|
long size = Long.parseLong(String.valueOf(lastList.size()));
|
return new DataGrid(lastList,size);
|
}
|
|
@Override
|
public void deleteById(String id) throws Exception {
|
String[] args = id.split(",");
|
if(null!=args&&args.length>0){
|
for(int i=0;i<args.length;i++){
|
EqmAuxil updateBean = eqmAuxilDao.findById(EqmAuxil.class,args[i]);
|
if(null!=updateBean&&!"".equals(updateBean)){
|
updateBean.setDel("1");
|
}
|
}
|
}
|
|
}
|
}
|
