From b0c18d369abd06075c83759b0e19823c2a11d716 Mon Sep 17 00:00:00 2001
From: ulysseskao <ulysseskao@gmail.com>
Date: Fri, 29 Apr 2016 18:45:41 +0800
Subject: [PATCH] update for new model
---
CCSTrace/CCS/Object/EventRecord.cs | 364 ++++++++++-----------------------------------------
1 files changed, 73 insertions(+), 291 deletions(-)
diff --git a/CCSTrace/CCS/Object/EventRecord.cs b/CCSTrace/CCS/Object/EventRecord.cs
index dc5f557..d3add68 100644
--- a/CCSTrace/CCS/Object/EventRecord.cs
+++ b/CCSTrace/CCS/Object/EventRecord.cs
@@ -1,311 +1,93 @@
-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()
}
-}
+}
\ No newline at end of file
--
Gitblit v0.0.0-SNAPSHOT