添加项目文件。

jingh

2021-02-28 a8d6e89a914ef0f729df080cb3adf7ab4b038662

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
140
141
142
143
144
145
146
147
148
149
150
151
152
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
 
namespace DAL
{
    public class ClsGy_BarCodeBill_Ctl:DBUtility.ClsGy_Base_Ctl 
    {
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); 
        //原代码 用于 替换子项目
        public string HOldNumber;
        public Model.ClsGy_BarCodeBill_WMS_Model oModel = new Model.ClsGy_BarCodeBill_WMS_Model();
        //新增
        public override bool AddNew()
        {
            
            try
            {
                oCn.BeginTran();
                //oCn.RunProc("Insert into " + MvarItemKey + " " +
                //    " (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
                //    ",HLevel,HEndFlag,HStopflag,HRemark,HEnglishName) " +
                //    " Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() +
                //    "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "','" + oModel.HEnglishName + "')", ref DBUtility.ClsPub.sExeReturnInfo);
                //修改上级为非末级代码
                //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }
 
        //修改
        public override bool ModifyByID(Int64 sItemID)
        {
            try
            {
                oCn.BeginTran();
                //oCn.RunProc("Update " + MvarItemKey + " set " +
                //    " HNumber='" + oModel.HNumber + "'" +
                //    ",HName='" + oModel.HName + "'" +
                //    ",HShortNumber='" + oModel.HShortNumber + "'" +
                //    ",HHelpCode='" + oModel.HHelpCode + "'" +
                //    ",HLevel=" + oModel.HLevel.ToString() +
                //    ",HParentID=" + oModel.HParentID.ToString() +
                //    ",HEndflag=" + Convert.ToString(oModel.HEndFlag ? 1 : 0) +
                //    ",HStopflag=" + Convert.ToString(oModel.HStopflag ? 1 : 0) +
                //    ",HEnglishName='" + oModel.HEnglishName + "'" +
                //    ",HRemark= '" + oModel.HRemark + "' Where HItemID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo);
                //修改子项目代码
                //oCn.RunProc("exec h_p_Gy_UpdateNumber '" + MvarItemKey + "','" + oModel.HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
                ////将上级 为非末级
                //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                //
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }
        //根据代码判断信息
        public override bool HavParentCode(string sCode, Int64 sItemID)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HStopflag=0 and HNumber='" + sCode + "' and HItemID<>" + sItemID, MvarItemKey, ref Pub_Class.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    oModel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]); 
                    return true;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
 
        //更新打印次数
        public bool Set_PrintQty(string sBarCode)
        {
            try
            {
                oCn.BeginTran();
                //更新 打印次数
                oCn.RunProc("update Gy_BarCodeBill set HPrintQty=isnull(HPrintQty,0)+1 where HBarCode='" + sBarCode + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }
 
        //作废条码
        public bool Cancelltion(string sBarCode)
        {
            try
            {
                oCn.BeginTran();
                //作废条码
                oCn.RunProc("update Gy_BarCodeBill set HStopflag=1 where HBarCode='" + sBarCode + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }
 
        //反作废条码
        public bool UnCancelltion(string sBarCode)
        {
            try
            {
                oCn.BeginTran();
                //反作废条码
                oCn.RunProc("update Gy_BarCodeBill set HStopflag=0 where HBarCode='" + sBarCode + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }
 
        //构造函数
        public ClsGy_BarCodeBill_Ctl()
        {
            MvarItemKey = "Gy_BarCodeBill";
            MvarReportTitle = "条码档案设置";
            oModel = new Model.ClsGy_BarCodeBill_WMS_Model();
        } 
    }
}