zzr99
2021-09-02 04f3089a153f70d3d7cc25e62deeaea2744eda3c
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
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 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
    }
}