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;
|
}
|
}
|
}
|
