| | |
|---|
| | | 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 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)
|
|---|
| | | public EventRecord(int mCaseId, OracleConnection conn, OracleTransaction trx)
|
|---|
| | | {
|
|---|
| | | this.CaseID = m_CaseID;
|
|---|
| | | this.m_Equipment = new CCS.Object.LocateEquipment(CaseID, false,_Conn,_Trx);
|
|---|
| | | CaseId = mCaseId;
|
|---|
| | | LocateEquipment = new LocateEquipment(CaseId, false, conn, trx);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | public CCS.Object.LocateEquipment getLocateEquipment()
|
|---|
| | | public LocateEquipment LocateEquipment { get; }
|
|---|
| | |
|
|---|
| | | public int CaseId { get; }
|
|---|
| | |
|
|---|
| | | public string Name { get; set; } = "";
|
|---|
| | |
|
|---|
| | | public string Meter { get; set; } = "";
|
|---|
| | |
|
|---|
| | | public string Tel { get; set; } = "";
|
|---|
| | |
|
|---|
| | | public string Addr { get; set; } = "";
|
|---|
| | |
|
|---|
| | | public string Brief { get; set; } = "";
|
|---|
| | |
|
|---|
| | | public string Log { get; set; } = "";
|
|---|
| | |
|
|---|
| | | public int Dept { get; set; } = 0;
|
|---|
| | |
|
|---|
| | | public string AcceptNum { get; set; }
|
|---|
| | |
|
|---|
| | | public string AcceptDate { get; set; }
|
|---|
| | |
|
|---|
| | | public int TraceFinish { get; set; } = 0;
|
|---|
| | |
|
|---|
| | | public int Fsc { get; set; } = 0;
|
|---|
| | |
|
|---|
| | | public int Ufid { get; set; } = 0;
|
|---|
| | |
|
|---|
| | | public int FdrId { get; set; } = 0;
|
|---|
| | |
|
|---|
| | | public int ParentId { get; set; } = 0;
|
|---|
| | |
|
|---|
| | | public int ImportCase { get; set; }
|
|---|
| | |
|
|---|
| | | public string Note { get; set; } = "";
|
|---|
| | |
|
|---|
| | | public int IsReCall { get; set; }
|
|---|
| | |
|
|---|
| | | public string ReCallTel { get; set; } = "";
|
|---|
| | |
|
|---|
| | | public string ReCallName { get; set; } = "";
|
|---|
| | |
|
|---|
| | | public int Level { get; set; } = 0;
|
|---|
| | |
|
|---|
| | |
|
|---|
| | | public int TmpCaseId { get; set; } = 0;
|
|---|
| | |
|
|---|
| | | public bool IsDespatched { get; set; }
|
|---|
| | |
|
|---|
| | | public string Tpclid { get; set; } = "";
|
|---|
| | |
|
|---|
| | | public void SetIsDespatched(bool mDespatched)
|
|---|
| | | {
|
|---|
| | | return this.m_Equipment;
|
|---|
| | | IsDespatched = mDespatched;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | public int getCaseID()
|
|---|
| | | public string GetSqlStmt()
|
|---|
| | | {
|
|---|
| | | return this.CaseID;
|
|---|
| | | var sqlStmt = "INSERT INTO EOS.EVENTRECORD VALUES (" + CaseId + ",'" + Name + "','" + Meter + "','" + Tel +
|
|---|
| | | "','" + Addr + "','" + Brief + "'," + Dept + ",'" + Log + "','" + AcceptNum + "',to_date('"
|
|---|
| | | + AcceptDate + "','yyyy/mm/dd hh24:mi:ss')," + Fsc + "," + Ufid + "," + FdrId + "," +
|
|---|
| | | TraceFinish + "," + ImportCase + ",'" + Note + "'," + IsReCall + ",'"
|
|---|
| | | + ReCallTel + "','" + ReCallName + "'," + Level + ")";
|
|---|
| | |
|
|---|
| | | return sqlStmt;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | 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;
|
|---|
| | | //}
|
|---|
| | | // return SqlStmt;
|
|---|
| | | // + getReCallName() + "',CASELEVEL = " + getLevel() + ",DEPT = " + getDept() + " WHERE CASEID = " + getCaseID();
|
|---|
| | | // + ",NOTE = '" + getNote() + "',ISRECALL = " + getisReCall() + ",RECALLTEL = '" + getReCallTel() + "',RECALLNAME = '"
|
|---|
| | |
|
|---|
| | | // 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;
|
|---|
| | | //}
|
|---|
| | | // String SqlStmt;
|
|---|
| | | //{
|
|---|
| | |
|
|---|
| | | public String getTpclid()
|
|---|
| | | {
|
|---|
| | | return tpclid;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | public void setTpclid(String m_tpclid)
|
|---|
| | | {
|
|---|
| | | tpclid = m_tpclid;
|
|---|
| | | }
|
|---|
| | | //public String getUpdateSqlStmt()
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | } |
|---|
