update for new model

ulysseskao

2016-04-29 b0c18d369abd06075c83759b0e19823c2a11d716

 CCSTrace/CCS/Object/LocateEquipment.cs

@@ -1,12 +1,4 @@
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;



@@ -14,52 +6,49 @@
{

    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 = "";

        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)

        public LocateEquipment(int mCaseId, bool hasData, OracleConnection conn, OracleTransaction transaction)

        {

            String SqlStmt;

            OracleCommand Command = null;

            string sqlStmt;

            OracleCommand command = null;

            OracleDataReader reader = null;



            this.setCaseID(m_CaseID);

            SetCaseId(mCaseId);



            try

            {

                if (hasData)

                {

                    SqlStmt = "SELECT DSUFID,FSC,UFID,FDR,TPCLID FROM EOS.EVENTRECORD_EX WHERE CASEID = " + m_CaseID;

                    sqlStmt = "SELECT DSUFID,FSC,UFID,FDR,TPCLID FROM EOS.EVENTRECORD_EX WHERE CASEID = " + mCaseId;



                    Command = new OracleCommand(SqlStmt, _Conn, _Transaction);

                    reader = Command.ExecuteReader();

                    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());

                        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 = " + CCS.LocalVariable.isDisaster;

                    sqlStmt = "SELECT UFID FROM EOS.DISASTER_EX WHERE ISDISASTER = " + GlobalVariable.IsDisaster;



                    Command = new OracleCommand(SqlStmt, _Conn, _Transaction);

                    reader = Command.ExecuteReader();

                    command = new OracleCommand(sqlStmt, conn, transaction);

                    reader = command.ExecuteReader();



                    if (reader.Read())

                        this.setDSUFID(Convert.ToInt32(reader["UFID"].ToString()));

                        SetDsufid(Convert.ToInt32(reader["UFID"].ToString()));

                }



            }

            catch (Exception e)

            {

@@ -67,79 +56,79 @@
                Console.WriteLine(e.StackTrace);

            }

            finally

            { 
            {

                reader.Close();

                Command.Dispose();

                command.Dispose();

            }

        }



        public int getCaseID()

        public int GetCaseId()

        {

            return this.CaseID;

            return _caseId;

        }



        public void setCaseID(int m_CaseID)

        public void SetCaseId(int mCaseId)

        {

            this.CaseID = m_CaseID;

            _caseId = mCaseId;

        }



        public int getDSUFID()

        public int GetDsufid()

        {

            return this.DSUfid;

            return _dsUfid;

        }



        public void setDSUFID(int m_DSUfid)

        public void SetDsufid(int mDsUfid)

        {

            this.DSUfid = m_DSUfid;

            _dsUfid = mDsUfid;

        }



        public int getFSC()

        public int GetFsc()

        {

            return this.Fsc;

            return _fsc;

        }



        public void setFSC(int m_FSC)

        public void SetFsc(int mFsc)

        {

            this.Fsc = m_FSC;

            _fsc = mFsc;

        }



        public int getUFID()

        public int GetUfid()

        {

            return this.Ufid;

            return _ufid;

        }



        public void setUFID(int m_UFID)

        public void SetUfid(int mUfid)

        {

            this.Ufid = m_UFID;

            _ufid = mUfid;

        }



        public String getFDR()

        public string GetFdr()

        {

            return this.FDR;

            return _fdr;

        }



        public void setFDR(String m_FDR)

        public void SetFdr(string mFdr)

        {

            this.FDR = m_FDR;

            _fdr = mFdr;

        }



        public String getTPCLID()

        public string GetTpclid()

        {

            return this.TPCLID;

            return _tpclid;

        }



        public void setTPCLID(String m_TPCLID)

        public void SetTpclid(string mTpclid)

        {

            this.TPCLID = m_TPCLID;

            _tpclid = mTpclid;

        }



        public String getSqlStmt()

        public string GetSqlStmt()

        {

            String SqlStmt;

            string sqlStmt;



            SqlStmt = "INSERT INTO EOS.EVENTRECORD_EX (CASEID,DSUFID,FSC,UFID,TPCLID,FDR) VALUES(" + getCaseID() + "," + getDSUFID() + "," + getFSC()

                    + "," + getUFID() + ",'" + getTPCLID() + "','" + getFDR() + "')";

            return 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()

@@ -152,4 +141,4 @@
        //    return SqlStmt;

        //}

    }

}

}