新增工序保存、工作中心保存、班组保存方法

沈泽

2021-08-20 d111e4321dcc4baa63f63597694f80d94e67ca11

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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
 
namespace DAL
{
    public class ClsGy_Mould_View:DBUtility.ClsGy_Base_View
    {
        
        //
        public Model.ClsGy_Mould_Model omodel = new Model.ClsGy_Mould_Model();
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); 
 
        public ClsGy_Mould_View()
        {
            base.MvarReportTitle = "模具设置";
            base.MvarItemKey = "h_v_Gy_Mould";
            base.SQLName = "Select HItemID,HNumber 模具代码,HName 模具名称,HModel 模具规格 from h_v_Gy_Mould  Order by HNumber ";
            base.SQLList = "Select * from " + MvarItemKey + " ";
        }
        //
        public void Dispose()
        {
            GC.SuppressFinalize(this);
        }
        //
         
        //返回项目信息
        public override bool GetInfoByID(Int64 sItemID)
        {
            DataSet DS ;
            try
            {
                DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HItemID='" + sItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count  == 0)
                    return false;
                else
                {
                    return GetInfo(DS);
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
        //根据代码返回项目信息
        public override bool GetInfoByNumber(string sNumber)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HNumber='" + sNumber + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    return GetInfo(DS);
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        } 
        //返回项目信息
        public override bool GetInfo(DataSet DS)
        {
            try
            {
                omodel = new Model.ClsGy_Mould_Model();
                omodel.HItemID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HItemID"]);
                omodel.HNumber = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HNumber"]);
                omodel.HhgNumber = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HhgNumber"]);
                omodel.HName = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HName"]);
                omodel.HModel = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HModel"]);
                omodel.HHelpCode = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HHelpCode"]);
                omodel.HPhaseFlag = DBUtility.ClsPub.isBool(DS.Tables[0].Rows[0]["HPhaseFlag"]);
                omodel.HRemark = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
                omodel.HBarCode = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HBarCode"]);
                omodel.HProcID =DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HProcID"]);
                omodel.HStopflag = DBUtility.ClsPub.isBool(DS.Tables[0].Rows[0]["HStopflag"]);
                return true;
 
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
 
        //模具 寿命
        public bool GetMouldLife(long HMouldID)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select * from h_v_Sc_MouldProdCheckStockBillList  Where HMaterID=" + HMouldID.ToString(), MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    omodel.HDesignLife = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["设计寿命"]);
                    omodel.HUseLife = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["使用寿命"]);
                    omodel.HLeaveLife = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["剩余寿命"]);
                    return true;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
 
        //根据条码档案 查找库存 获取信息 仓库仓位
        public bool get_StockAndSPInfoByMould(long sHMould, double HQty)
        {
            try
            {
                DataSet Ds;
                Ds = oCn.RunProcReturn("select * from h_v_KF_ICInventoryList_Mould where hmaterid=" + sHMould.ToString() + " and 即时库存>=" + HQty.ToString(), "xt_xtgnb", ref DBUtility.ClsPub.sExeReturnInfo);
                if (Ds == null || Ds.Tables[0].Rows.Count == 0)
                {
                    return false;
                }
                omodel.HWHID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HWHID"]);
                omodel.HSPID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSPID"]);
                return true;
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
 
 
    }
}