项目初始化

zhuguifei

2026-03-10 58402bd5e762361363a0f7d7907153c77dbb819f

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
package com.shlanbao.tzsc.pms.sch.workorder.service.impl;
 
import java.util.List;
 
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import com.shlanbao.tzsc.base.dao.SchWorkorderCraftDaoI;
import com.shlanbao.tzsc.base.mapping.SchWorkorderCraft;
import com.shlanbao.tzsc.base.model.DataGrid;
import com.shlanbao.tzsc.base.service.BaseService;
import com.shlanbao.tzsc.pms.sch.workorder.beans.CraftBean;
import com.shlanbao.tzsc.pms.sch.workorder.service.CraftServiceI;
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
import com.shlanbao.tzsc.utils.tools.DateUtil;
import com.shlanbao.tzsc.utils.tools.StringUtil;
@Service
public class CraftServiceImpl extends BaseService implements CraftServiceI{
    @Autowired
    private SchWorkorderCraftDaoI schWorkorderCraftDao;
 
    @Override
    public DataGrid queryCraftByWorkOrder(String workOrderId) {
        /*try {
            //String hql = "select o.id,o.parameterCode,o.parameterName,o.pcp,o.qc,o.pval,o.zval,o.cpk,o.cp,o.pp,o.ppk,o.ppm,o.std,o.uval,o.lval, o.cuval,o.clval,o.wuval,o.wlval,o.dtm,o.dtmuval,o.dtmlval,o.paramType from SchWorkorderCraft o ,SchWorkorder b where  o.parameterSetRevision=b.parameterSetRevision and b.id=?";
            String sql="SELECT o.* FROM SCH_WORKORDER_CRAFT o, SCH_WORKORDER b WHERE o.PARAMETER_SETREVISION = b.parameter_Set_Revision and b.id='"+workOrderId+"' ";
            return new DataGrid(BeanConvertor.copyList(schWorkorderCraftDao.queryBySql(sql),CraftBean.class), 0L);
        } catch (Exception e) {
            log.error("查询工单ID:["+workOrderId+"]的工艺参数异常", e);
        }
        return null;*/
        try {
            String hql = "from SchWorkorderCraft o where o.parameterSetRevision in (select  a.parameterSetRevision from SchWorkorder a where a.id=?)";
            return new DataGrid(BeanConvertor.copyList(schWorkorderCraftDao.query(hql, workOrderId),CraftBean.class), 0L);
        } catch (Exception e) {
            log.error("查询工单ID:["+workOrderId+"]的工艺参数异常", e);
        }
        return null;
    }
    
    /*@Override
    public DataGrid queryCraftByWorkOrder(String workOrderId) {
        try {
            String hql = "from SchWorkorderCraft o where o.materialCode=(select  a.mdMat from SchWorkorder a where a.id=?)";
            return new DataGrid(BeanConvertor.copyList(schWorkorderCraftDao.query(hql, workOrderId),CraftBean.class), 0L);
        } catch (Exception e) {
            log.error("查询工单ID:["+workOrderId+"]的工艺参数异常", e);
        }
        return null;
    }*/
 
    @Override
    public void saveCraft(SchWorkorderCraft craft) {
        schWorkorderCraftDao.save(craft);
    }
 
    @Override
    public SchWorkorderCraft queryByMatAndCode(String matCode, String paramCode) {
        String sql="SELECT id from SCH_WORKORDER_CRAFT where MATERIAL_CODE='"+matCode+"' and PARAMETER_CODE='"+paramCode+"'";
        List<?> ls=schWorkorderCraftDao.queryBySql(sql);
        if(ls!=null && ls.size()>0){
            return new SchWorkorderCraft(StringUtil.convertObjToString(ls.get(0)));
        }
        return null;
    }
 
    @Override
    public void saveOrUpdateCraft(SchWorkorderCraft craft) {
        //保存
        //schWorkorderCraftDao.saveOrUpdate(craft);
        schWorkorderCraftDao.save(craft);
    }
 
    
    @Override
    public void deleteByCraft(String parameterSetRevision, String materialCode) {
        try {
            schWorkorderCraftDao.updateBySql("delete SCH_WORKORDER_CRAFT where effect_remark='"+parameterSetRevision+materialCode+"'", null);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    
    
    
    
}