增加 审核，反审核，禁用，反禁用，按钮设置 等按钮；并修改视图，将 审核人，审核日期，禁用人，禁用日期 4列 显示出来；

cwjbxqmz

2023-09-27 be368ef45174e5e47c6896dea8abc87e3bb6293a

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
153
154
155
156
157
158
159
160
161
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
 
namespace DBUtility
{
    public class ClsGy_Base_Ctl
    {
        public string MvarItemKey;
        public string MvarReportTitle;
        public Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper(); 
        //新增
        public virtual bool AddNew()
        {
            return true;
        }
 
        //修改
        public virtual bool ModifyByID(Int64 sItemID)
        {
            return true;
        }
 
        #region 固定代码
        //是否存在子项目
        public bool HavChildCodes(Int64 sItemID)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select HItemID from " + MvarItemKey + " Where HParentID='" + sItemID + "'", MvarItemKey , ref Pub_Class.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
        //根据代码判断信息
        public virtual bool HavParentCode(string sCode, Int64 sItemID)
        {
            return true;
        }
        //重复代码
        public bool HavSameNumber(Int64 sItemID, string sNumber)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select HItemID from " + MvarItemKey + " Where HItemID<>" + sItemID + " and HNumber='" + sNumber + "'", MvarItemKey, ref Pub_Class.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
 
        //审核
        public bool AuditByID(Int64 sItemID, ref string sReturn)
        {
            try
            {
                string HCheckEmp = ClsPub.CurUserName;
                oCn.RunProc("Update " + MvarItemKey + "   set HCheckEmp = '" + HCheckEmp  + "',HCheckDate=getdate()  where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                sReturn = "";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }
 
        //反审核
        public bool DeAuditByID(Int64 sItemID, ref string sReturn)
        {
            try
            {
                oCn.RunProc("Update " + MvarItemKey + "   set HCheckEmp = '', HCheckDate=null  where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                sReturn = "";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }
 
        //禁用
        public bool StopByID(Int64 sItemID)
        {
            try
            {
                oCn.RunProc("Update " + MvarItemKey + "   set HStopflag=1  where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
 
        //反禁用
        public bool UnStopByID(Int64 sItemID)
        {
            try
            {
                oCn.RunProc("Update " + MvarItemKey + "   set HStopflag=0  where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
 
        //删除
        public bool DeleteByID(Int64 sItemID)
        {
            try
            {
                oCn.RunProc("Delete from " + MvarItemKey + " where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
 
 
        //删除
        public bool DeleteByNumber(string  sNumber)
        {
            try
            {
                oCn.RunProc("Delete from " + MvarItemKey + " where HNumber='" + sNumber + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                throw (e);
            }
        } 
        #endregion
    }
}