Merge branch 'master' of http://101.37.171.70:10101/r/ARSRM-LMESAPI

yangle

2023-05-31 dc683710bf1eaa9b2d1d026a31d3b40d05db5c89

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
using System;
using System.Collections.Generic;
using System.Text;
 
namespace SQLHelper
{
    public class ClsSQLEdit
    {
        public string sSQL_Table;
        public string sSQL_Filed;
        public string sSQL_Value;
        public string sSQL_Last;
 
        public void set_BeginStr(string sTableName)
        {
            sSQL_Table = sTableName;
            sSQL_Filed = "";
            sSQL_Value = "";
            sSQL_Last = "";
        }
 
        public void set_EndStr()
        {
            if (sSQL_Filed.Trim() == "")
            {
                sSQL_Last = "";
                return;
            }
            else
            {
                sSQL_Filed = sSQL_Filed.Substring(1, sSQL_Filed.Length - 1);
            }
            if (sSQL_Value.Trim() == "")
            {
                sSQL_Last = "";
                return;
            }
            else
            {
                sSQL_Value = sSQL_Value.Substring(1, sSQL_Value.Length - 1);
            }
            sSQL_Last = "Insert into " + sSQL_Table + "(" + sSQL_Filed + ")   values(" + sSQL_Value + ")";
        }
 
 
        public void set_AddFiled(string sFiledName,object sFiledValue)
        {
            Type sFiledType;
            sFiledType = sFiledValue.GetType();
            sSQL_Filed = sSQL_Filed + "," + sFiledName;
            //ÅжÏÊý¾ÝÀàÐÍ
            if (sFiledType == Type.GetType("System.Double"))
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
            else if (sFiledType == Type.GetType("System.Single"))
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
            else if (sFiledType == Type.GetType("System.Int16"))
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
            else if (sFiledType == Type.GetType("System.Int32"))
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
            else if (sFiledType == Type.GetType("System.Int64"))
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
            else if (sFiledType == Type.GetType("System.Decimal"))
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
            else if (sFiledType == Type.GetType("System.String"))
            {
                if (sFiledValue.ToString().ToLower() == "getdate()")
                {
                    sSQL_Value = sSQL_Value + "," + sFiledValue + "";
                }
                else
                {
                    sSQL_Value = sSQL_Value + ",'" + sFiledValue + "'";
                }
            }
            else if (sFiledType == Type.GetType("System.DateTime"))
            {
                sSQL_Value = sSQL_Value + ",'" + sFiledValue + "'";
            }
            else if (sFiledType == Type.GetType("System.Boolean"))
            {
                if (Pub_Class.ClsPub.isBool(sFiledValue) == true)
                {
                    sSQL_Value = sSQL_Value + ",1";
                }
                else
                {
                    sSQL_Value = sSQL_Value + ",0";
                }
 
            }
            else
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
        }
 
 
 
    }
}