update for new model

ulysseskao

2016-04-29 b0c18d369abd06075c83759b0e19823c2a11d716

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
using System; 
 
using System.Data.OracleClient; 
 
namespace CCSTrace.CCS.Object 
{ 
    public class LocateEquipment 
    { 
        private int _caseId = 0; 
        private int _dsUfid = -1; 
        private int _fsc = 0; 
        private int _ufid = 0; 
        private string _fdr = ""; 
        private string _tpclid = ""; 
 
        public LocateEquipment(int mCaseId, bool hasData, OracleConnection conn, OracleTransaction transaction) 
        { 
            string sqlStmt; 
            OracleCommand command = null; 
            OracleDataReader reader = null; 
 
            SetCaseId(mCaseId); 
 
            try 
            { 
                if (hasData) 
                { 
                    sqlStmt = "SELECT DSUFID,FSC,UFID,FDR,TPCLID FROM EOS.EVENTRECORD_EX WHERE CASEID = " + mCaseId; 
 
                    command = new OracleCommand(sqlStmt, conn, transaction); 
                    reader = command.ExecuteReader(); 
 
                    if (reader.Read()) 
                    { 
                        SetDsufid(Convert.ToInt32(reader["DSUFID"].ToString())); 
                        SetFsc(Convert.ToInt32(reader["FSC"].ToString())); 
                        SetUfid(Convert.ToInt32(reader["UFID"].ToString())); 
                        SetFdr(reader["FDR"].ToString()); 
                        SetTpclid(reader["TPCLID"].ToString()); 
                    } 
                } 
                else 
                { 
                    sqlStmt = "SELECT UFID FROM EOS.DISASTER_EX WHERE ISDISASTER = " + GlobalVariable.IsDisaster; 
 
                    command = new OracleCommand(sqlStmt, conn, transaction); 
                    reader = command.ExecuteReader(); 
 
                    if (reader.Read()) 
                        SetDsufid(Convert.ToInt32(reader["UFID"].ToString())); 
                } 
            } 
            catch (Exception e) 
            { 
                Console.WriteLine(e.Message); 
                Console.WriteLine(e.StackTrace); 
            } 
            finally 
            { 
                reader.Close(); 
                command.Dispose(); 
            } 
        } 
 
        public int GetCaseId() 
        { 
            return _caseId; 
        } 
 
        public void SetCaseId(int mCaseId) 
        { 
            _caseId = mCaseId; 
        } 
 
        public int GetDsufid() 
        { 
            return _dsUfid; 
        } 
 
        public void SetDsufid(int mDsUfid) 
        { 
            _dsUfid = mDsUfid; 
        } 
 
        public int GetFsc() 
        { 
            return _fsc; 
        } 
 
        public void SetFsc(int mFsc) 
        { 
            _fsc = mFsc; 
        } 
 
        public int GetUfid() 
        { 
            return _ufid; 
        } 
 
        public void SetUfid(int mUfid) 
        { 
            _ufid = mUfid; 
        } 
 
        public string GetFdr() 
        { 
            return _fdr; 
        } 
 
        public void SetFdr(string mFdr) 
        { 
            _fdr = mFdr; 
        } 
 
        public string GetTpclid() 
        { 
            return _tpclid; 
        } 
 
        public void SetTpclid(string mTpclid) 
        { 
            _tpclid = mTpclid; 
        } 
 
        public string GetSqlStmt() 
        { 
            string sqlStmt; 
 
            sqlStmt = "INSERT INTO EOS.EVENTRECORD_EX (CASEID,DSUFID,FSC,UFID,TPCLID,FDR) VALUES(" + GetCaseId() + "," + GetDsufid() + "," + GetFsc() 
                    + "," + GetUfid() + ",'" + GetTpclid() + "','" + GetFdr() + "')"; 
            return sqlStmt; 
        } 
 
        //public String getUpdateSqlStmt() 
        //{ 
        //    String SqlStmt; 
 
        //    SqlStmt = "UPDATE EOS.EVENTRECORD_EX SET DSUFID = " + getDSUFID() + ",FSC = " + getFSC() + ",UFID = " + getUFID() + ",TPCLID = '" 
        //            + getTPCLID() + "',FDR = '" + getFDR() + "' WHERE CASEID = " + getCaseID(); 
 
        //    return SqlStmt; 
        //} 
    } 
}