hank

2015-08-18 2d4b747b3ac277babbd8eddfd88f378953f497bd

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
145
146
147
148
149
150
151
152
153
154
155
using System; 
using System.Data; 
using System.Configuration; 
using System.Web; 
using System.Web.Security; 
using System.Web.UI; 
using System.Web.UI.HtmlControls; 
using System.Web.UI.WebControls; 
using System.Web.UI.WebControls.WebParts; 
 
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 m_CaseID, bool hasData,OracleConnection _Conn, OracleTransaction _Transaction) 
        { 
            String SqlStmt; 
            OracleCommand Command = null; 
            OracleDataReader reader = null; 
 
            this.setCaseID(m_CaseID); 
 
            try 
            { 
                if (hasData) 
                { 
                    SqlStmt = "SELECT DSUFID,FSC,UFID,FDR,TPCLID FROM EOS.EVENTRECORD_EX WHERE CASEID = " + m_CaseID; 
 
                    Command = new OracleCommand(SqlStmt, _Conn, _Transaction); 
                    reader = Command.ExecuteReader(); 
 
                    if (reader.Read()) 
                    { 
                        this.setDSUFID(Convert.ToInt32(reader["DSUFID"].ToString())); 
                        this.setFSC(Convert.ToInt32(reader["FSC"].ToString())); 
                        this.setUFID(Convert.ToInt32(reader["UFID"].ToString())); 
                        this.setFDR(reader["FDR"].ToString()); 
                        this.setTPCLID(reader["TPCLID"].ToString()); 
                    } 
 
 
                } 
                else 
                { 
                    SqlStmt = "SELECT UFID FROM EOS.DISASTER_EX WHERE ISDISASTER = " + CCS.LocalVariable.isDisaster; 
 
                    Command = new OracleCommand(SqlStmt, _Conn, _Transaction); 
                    reader = Command.ExecuteReader(); 
 
                    if (reader.Read()) 
                        this.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 this.CaseID; 
        } 
 
        public void setCaseID(int m_CaseID) 
        { 
            this.CaseID = m_CaseID; 
        } 
 
        public int getDSUFID() 
        { 
            return this.DSUfid; 
        } 
 
        public void setDSUFID(int m_DSUfid) 
        { 
            this.DSUfid = m_DSUfid; 
        } 
 
        public int getFSC() 
        { 
            return this.Fsc; 
        } 
 
        public void setFSC(int m_FSC) 
        { 
            this.Fsc = m_FSC; 
        } 
 
        public int getUFID() 
        { 
            return this.Ufid; 
        } 
 
        public void setUFID(int m_UFID) 
        { 
            this.Ufid = m_UFID; 
        } 
 
        public String getFDR() 
        { 
            return this.FDR; 
        } 
 
        public void setFDR(String m_FDR) 
        { 
            this.FDR = m_FDR; 
        } 
 
        public String getTPCLID() 
        { 
            return this.TPCLID; 
        } 
 
        public void setTPCLID(String m_TPCLID) 
        { 
            this.TPCLID = m_TPCLID; 
        } 
 
        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; 
        //} 
    } 
}