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;

namespace CCSTrace.CCS.Object
{
    public class EventRecord
    {
        private int CaseID;
        private String Name = "";
        private String Meter = "";
        private String Tel = "";
        private String Addr = "";
        private String Brief = "";
        private String Log = ""; // default
        private int Dept = 0; // default
        private String AcceptNum;
        private String AcceptDate;
        private int Fsc = 0;
        private int Ufid = 0;
        private int FdrID = 0;
        private int Trace_Finish = 0;
        private int ParentID = 0;
        private int ImportCase;
        private String Note = "";
        private int isReCall;
        private String ReCallTel = "";
        private String ReCallName = "";
        private bool despatched = false;// 專案案件升級為母案件時,判斷原先案件是否已派工
        private int Level = 0;
        private int TmpCaseID = 0;
        private String tpclid = "";
        //private CCS.Function.TransferDate Convert = new CCS.Function.TransferDate();
        private CCS.Object.LocateEquipment m_Equipment;

        public EventRecord(int m_CaseID,System.Data.OracleClient.OracleConnection _Conn,System.Data.OracleClient.OracleTransaction _Trx)
        {
            this.CaseID = m_CaseID;
            this.m_Equipment = new CCS.Object.LocateEquipment(CaseID, false,_Conn,_Trx);
        }

        public CCS.Object.LocateEquipment getLocateEquipment()
        {
            return this.m_Equipment;
        }

        public int getCaseID()
        {
            return this.CaseID;
        }

        public String getName()
        {
            return this.Name;
        }

        public void setName(String m_Name)
        {
            this.Name = m_Name;
        }

        public String getMeter()
        {
            return this.Meter;
        }

        public void setMeter(String m_Meter)
        {
            this.Meter = m_Meter;
        }

        public String getTel()
        {
            return this.Tel;
        }

        public void setTel(String m_Tel)
        {
            this.Tel = m_Tel;
        }

        public String getAddr()
        {
            return this.Addr;
        }

        public void setAddr(String m_Addr)
        {
            this.Addr = m_Addr;
        }

        public String getBrief()
        {
            return this.Brief;
        }

        public void setBrief(String m_Brief)
        {
            this.Brief = m_Brief;
        }

        public String getLog()
        {
            return this.Log;
        }

        public void setLog(String m_Log)
        {
            this.Log = m_Log;
        }

        public int getDept()
        {
            return this.Dept;
        }

        public void setDept(int m_Dept)
        {
            this.Dept = m_Dept;
        }

        public String getAcceptNum()
        {
            return this.AcceptNum;
        }

        public void setAcceptNum(String m_AcceptNum)
        {
            this.AcceptNum = m_AcceptNum;
        }

        public String getAcceptDate()
        {
            return this.AcceptDate;
        }

        public void setAcceptDate(String m_AcceptDate)
        {
            this.AcceptDate = m_AcceptDate;
        }

        public int getTrace_Finish()
        {
            return this.Trace_Finish;
        }

        public void setFsc(int m_Fsc)
        {
            this.Fsc = m_Fsc;
        }

        public int getFsc()
        {
            return this.Fsc;
        }

        public void setUfid(int m_Ufid)
        {
            this.Ufid = m_Ufid;
        }

        public int getUfid()
        {
            return this.Ufid;
        }

        public void setFdrID(int m_FdrID)
        {
            this.FdrID = m_FdrID;
        }

        public int getFdrID()
        {
            return this.FdrID;
        }

        public void setTrace_Finish(int m_Trace_Finish)
        {
            this.Trace_Finish = m_Trace_Finish;
        }

        public void setParentID(int m_ParentID)
        {
            this.ParentID = m_ParentID;
        }

        public int getParentID()
        {
            return this.ParentID;
        }

        public void setImportCase(int m_ImportCase)
        {
            this.ImportCase = m_ImportCase;
        }

        public int getImportCase()
        {
            return this.ImportCase;
        }

        public void setNote(String m_Note)
        {
            this.Note = m_Note;
        }

        public String getNote()
        {
            return this.Note;
        }

        public void setisReCall(int m_isReCall)
        {
            this.isReCall = m_isReCall;
        }

        public int getisReCall()
        {
            return this.isReCall;
        }

        public void setReCallTel(String m_ReCallTel)
        {
            this.ReCallTel = m_ReCallTel;
        }

        public String getReCallTel()
        {
            return this.ReCallTel;
        }

        public void setReCallName(String m_ReCallName)
        {
            this.ReCallName = m_ReCallName;
        }

        public String getReCallName()
        {
            return this.ReCallName;
        }

        public void setLevel(int m_Level)
        {
            this.Level = m_Level;
        }

        public int getLevel()
        {
            return this.Level;
        }

        public int getTmpCaseID()
        {
            return this.TmpCaseID;
        }

        public void setTmpCaseID(int CaseID)
        {
            this.TmpCaseID = CaseID;
        }

        public void setDespatched(bool m_Despatched)
        {
            this.despatched = m_Despatched;
        }

        public bool isDespatched()
        {
            return this.despatched;
        }

        public String getSqlStmt()
        {
            String SqlStmt;

            SqlStmt = "insert into eos.eventrecord values (" + getCaseID() + ",'" + getName() + "','" + getMeter() + "','" + getTel() + "','" + getAddr()
                    + "','" + getBrief() + "'," + getDept() + ",'" + getLog() + "','" + getAcceptNum() + "',to_date('"
                    + getAcceptDate() + "','yyyy/mm/dd hh24:mi:ss')," + getFsc() + "," + getUfid()
                    + "," + getFdrID() + "," + getTrace_Finish() + "," + getImportCase() + ",'" + getNote() + "'," + getisReCall() + ",'"
                    + getReCallTel() + "','" + getReCallName() + "'," + getLevel() + ")";

            return SqlStmt;
        }

        //public String getUpdateSqlStmt()
        //{
        //    String SqlStmt;

        //    SqlStmt = "UPDATE EOS.EVENTRECORD SET CUSTOMERADDR = '" + getAddr() + "',EVENTBRIEF = '" + getBrief() + "',IMPORTCASE = " + getImportCase()
        //            + ",NOTE = '" + getNote() + "',ISRECALL = " + getisReCall() + ",RECALLTEL = '" + getReCallTel() + "',RECALLNAME = '"
        //            + getReCallName() + "',CASELEVEL = " + getLevel() + ",DEPT = " + getDept() + " WHERE CASEID = " + getCaseID();
        //    return SqlStmt;
        //}

        public String getTpclid()
        {
            return tpclid;
        }

        public void setTpclid(String m_tpclid)
        {
            tpclid = m_tpclid;
        }
    }
}