6

zzr99

2022-06-27 1c5ee360efc22dbc1283ad04e96f33dd26631760

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
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
 
namespace DAL
{
 
    /// <summary>
    /// 委外工序
    /// </summary>
    public class ClsGy_ORGANIZATIONS_View:DBUtility.ClsGy_Base_View
    {
        
        //
        public Model.ClsGy_ORGANIZATIONS_Model omodel = new Model.ClsGy_ORGANIZATIONS_Model();
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); 
 
        public ClsGy_ORGANIZATIONS_View()
        {
            base.MvarReportTitle = "组织设置";
            base.MvarItemKey = "Xt_ORGANIZATIONS";
            base.SQLName = "Select HItemID,HNumber 组织代码,HName 组织 from Xt_ORGANIZATIONS where HStopflag=0 Order by HItemID ";
        }
        //
        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 DataSet GetList()
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select * from " + MvarItemKey + "  ", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return null ;
                else
                {
                    return DS;
                }
            }
            catch (Exception e)
            {
                throw (e);
                return null;
            }
        } 
 
        //根据代码返回项目信息
        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 GetInfoByName(string sName)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HName='" + sName + "'", 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_ORGANIZATIONS_Model();
                omodel.HItemID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HItemID"]);
                omodel.HNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HNumber"]);
                omodel.HName = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HName"]);
                //omodel.HShortNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HShortNumber"]);
                //omodel.HParentID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HParentID"]);
                //omodel.HLevel = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HLevel"]);
                //omodel.HEndFlag = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HEndFlag"]);
                //omodel.HStopflag = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HStopflag"]);
                //omodel.HRemark = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
                //omodel.HHelpCode = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HHelpCode"]);
                ////
                //omodel.HSNo = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSNo"]);
                return true;
 
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
    }
}