From b66af4500c0b5d6a923d864eb4047b5150c8aac1 Mon Sep 17 00:00:00 2001
From: ulysseskao <ulysseskao@gmail.com>
Date: Tue, 03 May 2016 18:36:24 +0800
Subject: [PATCH] refator code
---
CCSTrace/CCS/Object/EOSEventRecord.cs | 188 +++++++++++++++++++++++-----------------------
1 files changed, 94 insertions(+), 94 deletions(-)
diff --git a/CCSTrace/CCS/Object/EventRecord.cs b/CCSTrace/CCS/Object/EOSEventRecord.cs
similarity index 94%
rename from CCSTrace/CCS/Object/EventRecord.cs
rename to CCSTrace/CCS/Object/EOSEventRecord.cs
index 4e98475..eb9c737 100644
--- a/CCSTrace/CCS/Object/EventRecord.cs
+++ b/CCSTrace/CCS/Object/EOSEventRecord.cs
@@ -1,95 +1,95 @@
-using System.Data.OracleClient;
-using NLog;
-
-namespace CCSTrace.CCS.Object
-{
- public class EventRecord
- {
- private static readonly Logger Logger = LogManager.GetCurrentClassLogger();
- //private CCS.Function.TransferDate Convert = new CCS.Function.TransferDate();
-
- public EventRecord(int mCaseId, OracleConnection conn, OracleTransaction trx)
- {
- CaseId = mCaseId;
- LocateEquipment = new LocateEquipment(CaseId, false, conn, trx);
- }
-
- 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)
- {
- IsDespatched = mDespatched;
- }
-
- public string GetSqlStmt()
- {
- 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;
- }
-
- //}
- // 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()
- // String SqlStmt;
- //{
-
- //public String getUpdateSqlStmt()
- }
+using System.Data.OracleClient;
+using NLog;
+
+namespace CCSTrace.CCS.Object
+{
+ public class EOSEventRecord
+ {
+ private static readonly Logger Logger = LogManager.GetCurrentClassLogger();
+ //private CCS.Function.TransferDate Convert = new CCS.Function.TransferDate();
+
+ public EOSEventRecord(int mCaseId, OracleConnection conn, OracleTransaction trx)
+ {
+ CaseId = mCaseId;
+ LocateEquipment = new LocateEquipment(CaseId, false, conn, trx);
+ }
+
+ 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)
+ {
+ IsDespatched = mDespatched;
+ }
+
+ public string GetInsertSqlStmt()
+ {
+ 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;
+ }
+
+ //}
+ // 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()
+ // String SqlStmt;
+ //{
+
+ //public String getUpdateSqlStmt()
+ }
}
\ No newline at end of file
--
Gitblit v0.0.0-SNAPSHOT