快捷建增加字段

yangle

17 小时以前 9643928dccb5656708d0c7d5567e4185abf54928

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
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Pub_Class;
 
namespace SQLHelper
{
    public  class ClsCNmaster:ClsCN
    {
        public ClsCNmaster()
        {
            ClsIni oIni = new ClsIni();
            sServer = ClsIni.ReadIni("Erp", "Server", ClsPub.AppPath + @"\" + "HXErp.ini");
            sDataBase = "master";
            sUser = ClsIni.ReadIni("Erp", "UserName", ClsPub.AppPath + @"\" + "HXErp.ini");
            sPassword = ClsIni.ReadIni("Erp", "PassWord", ClsPub.AppPath + @"\" + "HXErp.ini");
        }
 
        public string GetDataBase(string sItem,ref string sK3 )
        {
            string[] sNumber;
            ClsCNmaster oCn = new ClsCNmaster();
            char c = Convert.ToChar("-");
            sNumber = sItem.Split(c);
            ClsPub.AccNumber = sNumber[0];
            ClsPub.AccName = sNumber[1];
            DataSet Ds = oCn.RunProcReturn("select DataBasesName,K3Erp from HDSystem_DataBases where Number='" + sNumber[0] + "'", "HDSystem_DataBases");
            if (Ds.Tables[0].Rows.Count > 0)
            {
                sK3 = Ds.Tables[0].Rows[0]["K3Erp"].ToString();
                //sK32 = Ds.Tables[0].Rows[0]["K32Erp"].ToString();
                //sK33 = Ds.Tables[0].Rows[0]["K33Erp"].ToString();
                return Ds.Tables[0].Rows[0]["DataBasesName"].ToString();
            }
            else
            {
                return "";
            }
        }
 
        public string GetDataBase(string sItem)
        {
            string[] sNumber;
            ClsCNmaster oCn = new ClsCNmaster();
            char c = Convert.ToChar("-");
            sNumber = sItem.Split(c);
            ClsPub.AccNumber = sNumber[0];
            ClsPub.AccName = sNumber[1];
            DataSet Ds = oCn.RunProcReturn("select DataBasesName  From HDSystem_DataBases where Number='" + sNumber[0] + "'", "HDSystem_DataBases");
            if (Ds.Tables[0].Rows.Count > 0)
            {
                //sK3 = Ds.Tables[0].Rows[0]["K3Erp"].ToString();
                //sK32 = Ds.Tables[0].Rows[0]["K32Erp"].ToString();
                //sK33 = Ds.Tables[0].Rows[0]["K33Erp"].ToString();
                return Ds.Tables[0].Rows[0]["DataBasesName"].ToString();
            }
            else
            {
                return "";
            }
        }
    }
}