package com.shlanbao.tzsc.pms.sys.datadict.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.UUID;
|
|
import org.apache.poi.hssf.record.formula.functions.T;
|
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.SysEqpTypeDaoI;
|
import com.shlanbao.tzsc.base.mapping.CosSpareParts;
|
import com.shlanbao.tzsc.base.mapping.EqmLubricantMaintain;
|
import com.shlanbao.tzsc.base.mapping.EqmLubricantPlan;
|
import com.shlanbao.tzsc.base.mapping.MdEquipment;
|
import com.shlanbao.tzsc.base.mapping.SysEqpCategory;
|
import com.shlanbao.tzsc.base.mapping.SysEqpType;
|
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.plugin.service.LoadComboboxServiceI;
|
import com.shlanbao.tzsc.pms.equ.lubricate.beans.EqmBubricantfBean;
|
import com.shlanbao.tzsc.pms.sys.datadict.beans.SysEqpTypeBean;
|
import com.shlanbao.tzsc.pms.sys.datadict.service.SysEqpTypeServiceI;
|
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
/**
|
* 数据字典实现类
|
*/
|
@Service
|
public class SysEqpTypeServiceImpl extends BaseService implements
|
SysEqpTypeServiceI {
|
@Autowired
|
private SysEqpTypeDaoI sysEqpTypeDao;
|
@Autowired
|
private BaseDaoI<T> baseDao;
|
@Autowired
|
private LoadComboboxServiceI comboboxServiceI;
|
|
// 更新 图片设置的点信息
|
@Override
|
public void addSetUpImages(String id, String imagePointMsg, String filePath)
|
throws Exception {
|
if (null != id && !"".equals(id)) {
|
SysEqpType mdEqpType = sysEqpTypeDao.findById(SysEqpType.class, id);
|
if (null != mdEqpType) {
|
imagePointMsg = imagePointMsg.replaceAll("\"", "\'");// 双引号替换成单引号
|
imagePointMsg = imagePointMsg.replaceAll(" ", "");
|
mdEqpType.setSetImagePoint(imagePointMsg);
|
if (null != filePath && !"".equals(filePath)) {
|
mdEqpType.setFilePath(filePath);
|
} else {
|
if (null != mdEqpType.getSysEqpCategory()) {
|
/*
|
* if(null!=mdEqpType.getSysEqpCategory().getUploadBean()
|
* ){
|
* mdEqpType.setFilePath(mdEqpType.getSysEqpCategory()
|
* .getUploadBean().getFileId()); }
|
*/
|
}
|
}
|
}
|
}
|
}
|
|
@Override
|
public void addMdType(SysEqpTypeBean mdEqpTypeBean) throws Exception {
|
SysEqpType mdEqpType = new SysEqpType();
|
if (StringUtil.notNull(mdEqpTypeBean.getId())) {
|
mdEqpType = sysEqpTypeDao.findById(SysEqpType.class,
|
mdEqpTypeBean.getId());
|
BeanConvertor.copyProperties(mdEqpTypeBean, mdEqpType);
|
} else {// 保存
|
mdEqpType = BeanConvertor.copyProperties(mdEqpTypeBean,
|
SysEqpType.class);
|
mdEqpType.setId(UUID.randomUUID().toString());
|
}
|
if (StringUtil.notNull(mdEqpTypeBean.getCategoryId())) {
|
mdEqpType.setSysEqpCategory(new SysEqpCategory(mdEqpTypeBean
|
.getCategoryId()));
|
}
|
if (StringUtil.notNull(mdEqpTypeBean.getOilId())) {// 润 滑 油（脂）ID
|
EqmLubricantMaintain bean = new EqmLubricantMaintain();
|
bean.setId(mdEqpTypeBean.getOilId());
|
mdEqpType.setOilIdBean(bean);
|
}
|
if (StringUtil.notNull(mdEqpTypeBean.getFillUnit())) {// 加注量单位ID
|
SysEqpType bean = new SysEqpType();
|
bean.setId(mdEqpTypeBean.getFillUnit());
|
mdEqpType.setFillUnitBean(bean);
|
}
|
if (StringUtil.notNull(mdEqpTypeBean.getFashion())) {// 方式ID
|
SysEqpType bean = new SysEqpType();
|
bean.setId(mdEqpTypeBean.getFashion());
|
mdEqpType.setFashionBean(bean);
|
}
|
mdEqpType.setDel("0");
|
if (StringUtil.notNull(mdEqpTypeBean.getId())) {
|
// 更新不用写
|
} else {
|
sysEqpTypeDao.save(mdEqpType);
|
}
|
// comboboxServiceI.initCombobox(ComboboxType.EQPTYPE);
|
}
|
|
@Override
|
public SysEqpTypeBean getTypeById(String id) throws Exception {
|
SysEqpType mdEqpType = sysEqpTypeDao.findById(SysEqpType.class, id);
|
SysEqpTypeBean bean = BeanConvertor.copyProperties(mdEqpType,
|
SysEqpTypeBean.class);
|
if (null != mdEqpType.getSysEqpCategory()) {
|
bean.setCategoryId(mdEqpType.getSysEqpCategory().getId());
|
bean.setCategoryName(mdEqpType.getSysEqpCategory().getName());
|
}
|
if (null != mdEqpType.getOilIdBean()) {// 润滑油
|
bean.setOilId(mdEqpType.getOilIdBean().getId());
|
bean.setOilName(mdEqpType.getOilIdBean().getLubricantName());
|
}
|
if (null != mdEqpType.getFillUnitBean()) {// 单位
|
bean.setFillUnit(mdEqpType.getFillUnitBean().getId());
|
bean.setFillUnitName(mdEqpType.getFillUnitBean().getName());
|
}
|
if (null != mdEqpType.getFashionBean()) {// 方式
|
bean.setFashion(mdEqpType.getFashionBean().getId());
|
bean.setFashionName(mdEqpType.getFashionBean().getName());
|
}
|
return bean;
|
}
|
|
@Override
|
public DataGrid queryMdType(SysEqpTypeBean mdTypeBean, PageParams pageParams)
|
throws Exception {
|
String hql = "from SysEqpType o ";
|
hql += " left join fetch o.sysEqpCategory sys1 ";//
|
hql += " left join fetch o.oilIdBean sys2 "; // 润滑油
|
hql += " left join fetch o.fillUnitBean sys3 "; // 单位
|
hql += " left join fetch o.fashionBean sys4 "; // 方式
|
hql += " where o.del=0 ";
|
StringBuffer params = new StringBuffer();
|
if (StringUtil.notNull(mdTypeBean.getName())) {
|
params.append(" and o.name like '%" + mdTypeBean.getName() + "%'");
|
}
|
if (StringUtil.notNull(mdTypeBean.getCode())) {
|
params.append(" and o.code like '%" + mdTypeBean.getCode() + "%'");
|
}
|
if (StringUtil.notNull(mdTypeBean.getCategoryId())) {
|
params.append(" and o.sysEqpCategory.id='"
|
+ mdTypeBean.getCategoryId() + "'");
|
}
|
if (StringUtil.notNull(mdTypeBean.getId())) {
|
params.append(" and o.id='" + mdTypeBean.getId() + "'");
|
}
|
List<SysEqpType> rows = sysEqpTypeDao.queryByPage(
|
hql.concat(params.toString()), pageParams);
|
List<SysEqpTypeBean> beans = new ArrayList<SysEqpTypeBean>();
|
for (SysEqpType mdEqpType : rows) {
|
try {
|
SysEqpTypeBean bean = new SysEqpTypeBean();
|
beanConvertor.copyProperties(mdEqpType, bean);
|
if (null != mdEqpType.getSysEqpCategory()) {
|
bean.setCategoryId(mdEqpType.getSysEqpCategory().getId());
|
bean.setCategoryName(mdEqpType.getSysEqpCategory().getName());
|
}
|
if (null != mdEqpType.getOilIdBean()) {// 润滑油
|
bean.setOilId(mdEqpType.getOilIdBean().getId());
|
bean.setOilName(mdEqpType.getOilIdBean().getLubricantName());
|
}
|
if (null != mdEqpType.getFillUnitBean()) {// 单位
|
bean.setFillUnit(mdEqpType.getFillUnitBean().getId());
|
bean.setFillUnitName(mdEqpType.getFillUnitBean().getName());
|
}
|
if (null != mdEqpType.getFashionBean()) {// 方式
|
bean.setFashion(mdEqpType.getFashionBean().getId());
|
bean.setFashionName(mdEqpType.getFashionBean().getName());
|
}
|
beans.add(bean);
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
}
|
hql = "select count(*) from SysEqpType o where o.del=0 ";
|
long total = sysEqpTypeDao.queryTotal(hql.concat(params.toString()));
|
return new DataGrid(beans, total);
|
}
|
|
@Override
|
public void deleteMdType(String id) throws Exception {
|
// sysEqpTypeDao.findById(SysEqpType.class, id).setDel("1");
|
sysEqpTypeDao.deleteById(id, SysEqpType.class);
|
// comboboxServiceI.initCombobox(ComboboxType.EQPTYPE);
|
}
|
|
@Override
|
public List<SysEqpTypeBean> queryMdType() throws Exception {
|
// String hql = "from SysEqpType o where 1=1 and o.del=0";
|
String hql = "from SysEqpType o ";
|
hql += " left join fetch o.sysEqpCategory sys1 ";//
|
hql += " left join fetch o.oilIdBean sys2 "; // 润滑油
|
hql += " left join fetch o.fillUnitBean sys3 "; // 单位
|
hql += " left join fetch o.fashionBean sys4 "; // 方式
|
hql += " where o.del=0 ";
|
List<SysEqpType> eqpTypes = sysEqpTypeDao.query(hql, new Object[] {});
|
List<SysEqpTypeBean> beans = new ArrayList<SysEqpTypeBean>();
|
for (SysEqpType mdEqpType : eqpTypes) {
|
SysEqpTypeBean bean = new SysEqpTypeBean();
|
beanConvertor.copyProperties(mdEqpType, bean);
|
if (null != mdEqpType.getSysEqpCategory()) {
|
bean.setCategoryId(mdEqpType.getSysEqpCategory().getId());
|
bean.setCategoryName(mdEqpType.getSysEqpCategory().getName());
|
}
|
if (null != mdEqpType.getOilIdBean()) {// 润滑油
|
bean.setOilId(mdEqpType.getOilIdBean().getId());
|
bean.setOilName(mdEqpType.getOilIdBean().getLubricantName());
|
}
|
if (null != mdEqpType.getFillUnitBean()) {// 单位
|
bean.setFillUnit(mdEqpType.getFillUnitBean().getId());
|
bean.setFillUnitName(mdEqpType.getFillUnitBean().getName());
|
}
|
if (null != mdEqpType.getFashionBean()) {// 方式
|
bean.setFashion(mdEqpType.getFashionBean().getId());
|
bean.setFashionName(mdEqpType.getFashionBean().getName());
|
}
|
beans.add(bean);
|
}
|
return beans;
|
}
|
|
@Override
|
public List<SysEqpTypeBean> queryMdEqpTypeByCategory(String[] categoryIds)
|
throws Exception {
|
// String hql = "from SysEqpType o where 1=1 and o.del=0 ";
|
String hql = "from SysEqpType o ";
|
hql += " left join fetch o.sysEqpCategory sys1 ";//
|
hql += " left join fetch o.oilIdBean sys2 "; // 润滑油
|
hql += " left join fetch o.fillUnitBean sys3 "; // 单位
|
hql += " left join fetch o.fashionBean sys4 "; // 方式
|
hql += " where o.del=0 ";
|
hql += " and o.sysEqpCategory.id in ("
|
+ StringUtil.arrayToStringBySqlin(categoryIds) + ") ";
|
List<SysEqpType> eqpTypes = sysEqpTypeDao.query(hql);
|
List<SysEqpTypeBean> beans = new ArrayList<SysEqpTypeBean>();
|
for (SysEqpType mdEqpType : eqpTypes) {
|
SysEqpTypeBean bean = new SysEqpTypeBean();
|
beanConvertor.copyProperties(mdEqpType, bean);
|
if (null != mdEqpType.getSysEqpCategory()) {
|
bean.setCategoryId(mdEqpType.getSysEqpCategory().getId());
|
bean.setCategoryName(mdEqpType.getSysEqpCategory().getName());
|
}
|
if (null != mdEqpType.getOilIdBean()) {// 润滑油
|
bean.setOilId(mdEqpType.getOilIdBean().getId());
|
bean.setOilName(mdEqpType.getOilIdBean().getLubricantName());
|
}
|
if (null != mdEqpType.getFillUnitBean()) {// 单位
|
bean.setFillUnit(mdEqpType.getFillUnitBean().getId());
|
bean.setFillUnitName(mdEqpType.getFillUnitBean().getName());
|
}
|
if (null != mdEqpType.getFashionBean()) {// 方式
|
bean.setFashion(mdEqpType.getFashionBean().getId());
|
bean.setFashionName(mdEqpType.getFashionBean().getName());
|
}
|
beans.add(bean);
|
}
|
return beans;
|
}
|
|
@Override
|
public List<SysEqpType> queryBean(SysEqpTypeBean mdTypeBean) {
|
String hql = "from SysEqpType o ";
|
hql += " left join fetch o.sysEqpCategory sys1 ";//
|
hql += " left join fetch o.oilIdBean sys2 "; // 润滑油
|
hql += " left join fetch o.fillUnitBean sys3 "; // 单位
|
hql += " left join fetch o.fashionBean sys4 "; // 方式
|
hql += " where o.del=0 ";
|
StringBuffer params = new StringBuffer();
|
if (StringUtil.notNull(mdTypeBean.getName())) {
|
params.append(" and o.name like '%" + mdTypeBean.getName() + "%'");
|
}
|
if (StringUtil.notNull(mdTypeBean.getCode())) {
|
params.append(" and o.code like '%" + mdTypeBean.getCode() + "%'");
|
}
|
if (StringUtil.notNull(mdTypeBean.getCategoryId())) {
|
params.append(" and o.sysEqpCategory.id='"
|
+ mdTypeBean.getCategoryId() + "'");
|
}
|
if (StringUtil.notNull(mdTypeBean.getId())) {
|
params.append(" and o.id='" + mdTypeBean.getId() + "'");
|
}
|
List<SysEqpType> rows = sysEqpTypeDao.query(hql.concat(params
|
.toString()));
|
return rows;
|
}
|
|
@Override
|
public void inputExeclAndReadWrite(List<SysEqpTypeBean> lt,
|
SysEqpTypeBean etb) throws Exception {
|
for (int i = 0; i < lt.size(); i++) {
|
SysEqpTypeBean etp = lt.get(i);
|
if(etp.getName().trim().equals("")||etp.getDes().trim().equals("")){
|
continue;
|
}
|
SysEqpType sysEqpType = new SysEqpType();
|
SysEqpCategory c = new SysEqpCategory();
|
c.setId(etb.getId());
|
sysEqpType.setSysEqpCategory(c);
|
sysEqpType.setDel("0");
|
sysEqpType.setEnable(1L);
|
sysEqpType.setCode(UUID.randomUUID().toString());
|
// 判断是否已经存在
|
String sql = "select cid from SYS_EQP_TYPE where cid='"
|
+ etb.getId() + "' and name='" + etp.getName() + "'";
|
List list = sysEqpTypeDao.queryBySql(sql);
|
if (list != null && list.size() > 0) {
|
continue;
|
} else {
|
beanConvertor.copyProperties(etp, sysEqpType);
|
// 润滑油
|
if (StringUtil.notNull(etp.getOilId())) {
|
EqmLubricantMaintain e = new EqmLubricantMaintain();
|
e.setId(etp.getOilId());
|
sysEqpType.setOilIdBean(e);
|
}
|
// 润滑油加注单位
|
if (StringUtil.notNull(etp.getCategoryId())) {
|
SysEqpType e = new SysEqpType();
|
e.setId(etp.getCategoryId());
|
sysEqpType.setFillUnitBean(e);
|
}
|
// 润滑方式
|
if (StringUtil.notNull(etp.getFashion())) {
|
SysEqpType e = new SysEqpType();
|
e.setId(etp.getFashion());
|
sysEqpType.setFashionBean(e);
|
}
|
if(StringUtil.notNull(etp.getPeriodUnit2())){
|
sysEqpType.setUnit_id(etp.getPeriodUnit2());
|
}
|
sysEqpTypeDao.save(sysEqpType);
|
}
|
}
|
|
}
|
|
/**
|
* 功能说明：通过设备Id，日期时间，班次，润滑类型查找表eqm_lubricat_plan表
|
* @author wanchanghuang
|
* @time 2015年9月17日16:24:37
|
*
|
* */
|
@Override
|
public EqmBubricantfBean queryEqmLubricantPlanByPar(
|
EqmBubricantfBean bean,String date,String unit_id,String shift_id,String eqp_id) {
|
String sql="select id,lub_id,shift_id from EQM_LUBRICAT_PLAN where shift_id='"+shift_id+"' and CONVERT(varchar(50),date_p,23)='"+date+"' and lub_id='"+unit_id+"' and eqp_id='"+eqp_id+"' ";
|
List<?> list=baseDao.queryBySql(sql);
|
EqmBubricantfBean b=new EqmBubricantfBean();
|
if(list.size()>0){
|
Object[] temp=(Object[])list.get(0);
|
try {
|
b.setId(temp[0].toString());
|
if(temp[1]!=null){
|
b.setLub_id(Integer.parseInt(temp[1].toString()));
|
}
|
b.setShift_id(temp[2].toString());
|
} catch (Exception e) {
|
// TODO: handle exception
|
}
|
}else{
|
b=null;
|
}
|
return b;
|
}
|
|
/**
|
* [功能说明]：根据sys_eqp_type表cid查询集合
|
* @time 2015年9月24日9:19:51
|
* @author wanchanghuang
|
*
|
* */
|
@Override
|
public List<SysEqpTypeBean> querySysEqmTypeByCid(SysEqpTypeBean sysEqpType) {
|
List<SysEqpTypeBean> listSete=new ArrayList<SysEqpTypeBean>();
|
String sql="SELECT a.id, a.name, a.des, (select lubricant_name from EQM_LUBRICANT_MAINTAIN where id=a.oilid) as oilid, a.fill_quantity, (select name from SYS_EQP_TYPE where id=a.fill_unit ) as fill_unit_name, (select name from SYS_EQP_TYPE where id=a.fashion ) as fashion_name, a.period, a.unit_id FROM SYS_EQP_TYPE a WHERE a.del = 0 AND cid = '"+sysEqpType.getCategoryId()+"'";
|
List<?> list=baseDao.queryBySql(sql);
|
if(list.size()>0){
|
for(Object o:list){
|
SysEqpTypeBean st=new SysEqpTypeBean();
|
Object[] temp=(Object[]) o;
|
st.setId(temp[0].toString());
|
st.setName(temp[1].toString());
|
if(temp[2]!=null){
|
st.setDes(temp[2].toString());
|
}
|
if(temp[3]!=null){
|
st.setOilId(temp[3].toString());
|
}
|
if(temp[4]!=null){
|
st.setFillQuantity(temp[4].toString());
|
}
|
if(temp[5]!=null){
|
st.setFillUnitName(temp[5].toString());
|
}
|
if(temp[6]!=null){
|
st.setFashionName(temp[6].toString());
|
}
|
if(temp[7]!=null){
|
st.setPeriod(Integer.parseInt(temp[7].toString()));
|
}
|
if(temp[8]!=null){
|
st.setUnit_id(temp[8].toString());
|
}
|
|
listSete.add(st);
|
}
|
}
|
return listSete;
|
}
|
|
}
|
