package com.shlanbao.tzsc.pms.md.eqptype.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import com.shlanbao.tzsc.utils.tools.FillUserInfoUtil;
|
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.MdEqpTypeDaoI;
|
import com.shlanbao.tzsc.base.mapping.MdEqpCategory;
|
import com.shlanbao.tzsc.base.mapping.MdEqpType;
|
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.md.eqptype.beans.MdEqpTypeBean;
|
import com.shlanbao.tzsc.pms.md.eqptype.service.MdEqpTypeServiceI;
|
import com.shlanbao.tzsc.utils.params.ComboboxType;
|
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
import javax.servlet.http.HttpServletRequest;
|
|
/**
|
* 设备类型与型号实现类
|
* @author liuligong
|
* @Time 2014/11/5 10:46
|
*/
|
@Service
|
public class MdEqpTypeServiceImpl extends BaseService implements MdEqpTypeServiceI {
|
@Autowired
|
private MdEqpTypeDaoI mdEqpTypeDao;
|
@Autowired
|
private LoadComboboxServiceI comboboxServiceI;
|
@Autowired
|
private HttpServletRequest request;
|
@LogAnno(operateType = "设备型号新增或者编辑")
|
@Override
|
public void addMdType(MdEqpTypeBean mdEqpTypeBean) throws Exception {
|
MdEqpType mdEqpType = BeanConvertor.copyProperties(mdEqpTypeBean, MdEqpType.class);
|
if(StringUtil.notNull(mdEqpTypeBean.getId())){ //修改
|
mdEqpType.setId(mdEqpTypeBean.getId());
|
MdEqpType mdEqpType2 = mdEqpTypeDao.findById(MdEqpType.class, mdEqpType.getId());
|
FillUserInfoUtil.fillUpdateUserInfo(mdEqpType2,request);
|
if(StringUtil.notNull(mdEqpType.getCode())){
|
mdEqpType2.setCode(mdEqpType.getCode());
|
}
|
if(StringUtil.notNull(mdEqpType.getName())){
|
mdEqpType2.setName(mdEqpType.getName());
|
}
|
if(StringUtil.notNull(mdEqpType.getDes())){
|
mdEqpType2.setDes(mdEqpType.getDes());
|
}
|
mdEqpType2.setEnable(mdEqpType.getEnable());
|
if(StringUtil.notNull(mdEqpTypeBean.getCategoryId())){
|
mdEqpType.setMdEqpCategory(new MdEqpCategory(mdEqpTypeBean.getCategoryId()));
|
}
|
mdEqpType2.setDel("0");
|
comboboxServiceI.initCombobox(ComboboxType.EQPTYPE);
|
return;
|
}else{ //新增
|
mdEqpType.setId(null);
|
FillUserInfoUtil.fillCreateUserInfo(mdEqpType,request);
|
}
|
if(StringUtil.notNull(mdEqpTypeBean.getCategoryId())){
|
mdEqpType.setMdEqpCategory(new MdEqpCategory(mdEqpTypeBean.getCategoryId()));
|
}
|
mdEqpType.setDel("0");
|
mdEqpTypeDao.saveOrUpdate(mdEqpType);
|
comboboxServiceI.initCombobox(ComboboxType.EQPTYPE);
|
}
|
|
@Override
|
public MdEqpTypeBean getTypeById(String id) throws Exception {
|
MdEqpType mdEqpType = mdEqpTypeDao.findById(MdEqpType.class, id);
|
MdEqpTypeBean mdEqpTypeBean = BeanConvertor.copyProperties(mdEqpType, MdEqpTypeBean.class);
|
/* if("0".equals(mdEqpType.getEnable())) mdEqpTypeBean.setEnable("已启用");
|
|
if("1".equals(mdEqpType.getEnable())) mdEqpTypeBean.setEnable("未启用");*/
|
if(mdEqpType.getMdEqpCategory() != null){
|
mdEqpTypeBean.setCategoryId(mdEqpType.getMdEqpCategory().getId());
|
mdEqpTypeBean.setCategoryName(mdEqpType.getMdEqpCategory().getName());
|
}
|
return mdEqpTypeBean;
|
}
|
|
@Override
|
public DataGrid queryMdType(MdEqpTypeBean mdTypeBean, PageParams pageParams) throws Exception {
|
String hql = "from MdEqpType o where 1=1 and 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.mdEqpCategory.id='"+mdTypeBean.getCategoryId()+"'");
|
List<MdEqpType> rows = mdEqpTypeDao.queryByPage(hql.concat(params.toString()),pageParams);
|
List<MdEqpTypeBean> beans = new ArrayList<MdEqpTypeBean>();
|
for (MdEqpType mdEqpType : rows) {
|
MdEqpTypeBean bean = new MdEqpTypeBean();
|
beanConvertor.copyProperties(mdEqpType, bean);
|
if(mdEqpType.getMdEqpCategory() != null){
|
bean.setCategoryId(mdEqpType.getMdEqpCategory().getId());
|
bean.setCategoryName(mdEqpType.getMdEqpCategory().getName());
|
}
|
FillUserInfoUtil.fillCreateAndUpdateUserInfo(mdEqpType,bean);
|
beans.add(bean);
|
}
|
|
/*
|
List<MdEqpTypeBean> r = BeanConvertor.copyList(rows, MdEqpTypeBean.class);
|
for (int i = 0; i < rows.size(); i++) {
|
MdEqpTypeBean metb = (MdEqpTypeBean)rows.get(i);
|
if("0".equals(metb.getEnable())) {
|
metb.setEnableStr("已启用");
|
break;
|
}
|
|
if("1".equals(metb.getEnable())){
|
metb.setEnableStr("未启用");
|
break;
|
}
|
}*/
|
hql = "select count(*) from MdEqpType o where 1=1 and o.del=0 ";
|
long total = mdEqpTypeDao.queryTotal(hql.concat(params.toString()));
|
return new DataGrid(beans,total);
|
}
|
@LogAnno(operateType = "删除设备型号")
|
@Override
|
public void deleteMdType(String id) throws Exception {
|
mdEqpTypeDao.findById(MdEqpType.class, id).setDel("1");
|
comboboxServiceI.initCombobox(ComboboxType.EQPTYPE);
|
}
|
|
@Override
|
public List<MdEqpTypeBean> queryMdType(String categoryId) throws Exception {
|
String hql = "from MdEqpType o where 1=1 and o.del=0";
|
if(StringUtil.notNull(categoryId)){
|
hql+=" and o.mdEqpCategory.id='"+categoryId+"' ";
|
}
|
List<MdEqpType> eqpTypes = mdEqpTypeDao.query(hql, new Object[]{});
|
List<MdEqpTypeBean> beans = new ArrayList<MdEqpTypeBean>();
|
for (MdEqpType mdEqpType : eqpTypes) {
|
MdEqpTypeBean bean = new MdEqpTypeBean();
|
beanConvertor.copyProperties(mdEqpType, bean);
|
if(mdEqpType.getMdEqpCategory() != null){
|
bean.setCategoryId(mdEqpType.getMdEqpCategory().getId());
|
bean.setCategoryName(mdEqpType.getMdEqpCategory().getName());
|
}
|
beans.add(bean);
|
}
|
return beans;
|
}
|
@Override
|
public List<MdEqpTypeBean> queryMdEqpTypeByCategory(String[] categoryIds)throws Exception{
|
String hql = "from MdEqpType o where 1=1 and o.del=0 ";
|
hql+=" and o.mdEqpCategory.id in ("+StringUtil.arrayToStringBySqlin(categoryIds)+") ";
|
List<MdEqpType> eqpTypes = mdEqpTypeDao.query(hql);
|
List<MdEqpTypeBean> beans = new ArrayList<MdEqpTypeBean>();
|
for (MdEqpType mdEqpType : eqpTypes) {
|
MdEqpTypeBean bean = new MdEqpTypeBean();
|
beanConvertor.copyProperties(mdEqpType, bean);
|
if(mdEqpType.getMdEqpCategory() != null){
|
bean.setCategoryId(mdEqpType.getMdEqpCategory().getId());
|
bean.setCategoryName(mdEqpType.getMdEqpCategory().getName());
|
}
|
beans.add(bean);
|
}
|
return beans;
|
}
|
@LogAnno(operateType = "批量删除设备型号")
|
@Override
|
public void batchDeleteMdType(String ids) {
|
String[] split = ids.split(",");
|
try {
|
for (int i = 0; i < split.length; i++) {
|
mdEqpTypeDao.findById(MdEqpType.class, split[i]).setDel("1");
|
|
}
|
comboboxServiceI.initCombobox(ComboboxType.EQPTYPE);
|
}catch (Exception e){
|
e.printStackTrace();
|
}
|
|
|
}
|
}
|
