package com.shlanbao.tzsc.pms.md.FilterCount.service.impl;
|
|
|
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.SchFilterCountDaoI;
|
import com.shlanbao.tzsc.base.mapping.SchFilterCount;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.pms.md.FilterCount.SchFilterCountBean;
|
import com.shlanbao.tzsc.pms.md.FilterCount.service.FilterCountServiceI;
|
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
import javax.servlet.http.HttpServletRequest;
|
import java.util.List;
|
|
@Service
|
public class FilterCountServiceImpl extends BaseService implements
|
FilterCountServiceI {
|
@Autowired
|
private SchFilterCountDaoI filterCountDaoI;
|
@Autowired
|
private HttpServletRequest request;
|
|
@Override
|
public DataGrid getAllFilterCount(SchFilterCountBean filterCount) throws Exception {
|
String hql = "from SchFilterCount o where 1=1 ";
|
if (StringUtil.notEmpty(filterCount.getStim())&&StringUtil.notEmpty(filterCount.getEtim())) {
|
hql+="and to_char(o.stim,'yyyy-mm-dd')>='"+filterCount.getStim()+"'&& to_char(o.etim,'yyyy-mm-dd')<='"+filterCount.getEtim()+"'";
|
}
|
List<SchFilterCount> query = filterCountDaoI.query(hql);
|
List<SchFilterCountBean> rows = BeanConvertor.copyList(query, SchFilterCountBean.class);
|
FillUserInfoUtil.fillCreateAndUpdateUserInfoByLists(query,rows);
|
return new DataGrid(rows, 0L);
|
}
|
@LogAnno(operateType = "新增成型配盘数量")
|
@Override
|
public void addFilterCount(SchFilterCountBean filterCount) throws Exception {
|
SchFilterCount o = BeanConvertor.copyProperties(filterCount, SchFilterCount.class);
|
o.setMatName(filterCountDaoI.queryBySql("select name from md_mat where id = ?", o.getMat()).get(0).toString());
|
FillUserInfoUtil.fillCreateUserInfo(o,request);
|
filterCountDaoI.save(o);
|
}
|
@LogAnno(operateType = "编辑成型配盘数量")
|
@Override
|
public void editFilterCount(SchFilterCountBean filterCount) throws Exception {
|
SchFilterCount o = BeanConvertor.copyProperties(filterCount, SchFilterCount.class);
|
SchFilterCount schFilterCount = filterCountDaoI.findById(SchFilterCount.class, filterCount.getId());
|
BeanConvertor.copyProperties(o,schFilterCount);
|
schFilterCount.setMatName(filterCountDaoI.queryBySql("select name from md_mat where id = ?", schFilterCount.getMat()).get(0).toString());
|
FillUserInfoUtil.fillUpdateUserInfo(schFilterCount,request);
|
filterCountDaoI.update(schFilterCount);
|
}
|
@LogAnno(operateType = "删除成型配盘数量")
|
@Override
|
public void deleteFilterCount(String id) throws Exception {
|
filterCountDaoI.deleteById(id, SchFilterCount.class);
|
|
}
|
@Override
|
public SchFilterCountBean getFilterCountById(String id) throws Exception {
|
return BeanConvertor.copyProperties(filterCountDaoI.findById(SchFilterCount.class, id),SchFilterCountBean.class);
|
}
|
|
@Override
|
public void batchDdeleteFilterCount(String ids) {
|
String[] split = ids.split(",");
|
for (int i = 0; i < split.length; i++) {
|
filterCountDaoI.deleteById(split[i], SchFilterCount.class);
|
}
|
}
|
|
}
|