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 EventQuery
|
{
|
private String CCSID;
|
private String Meter;
|
private int CaseStatus;
|
private String ChangeTime;
|
private String HandlingSummary;
|
private String AssumedTime;
|
private String AssumedTime_Nth;
|
private int DelayTimes = 0;
|
private String Reason;
|
private String EventLocation = "";
|
//private CCS.Function.TransferDate convert = new CCS.Function.TransferDate();
|
|
public EventQuery()
|
{
|
}
|
|
public void setCCSID(String m_CCSID)
|
{
|
this.CCSID = m_CCSID;
|
}
|
|
public String getCCSID()
|
{
|
return this.CCSID;
|
}
|
|
public void setMeter(String m_Meter)
|
{
|
this.Meter = m_Meter;
|
}
|
|
public String getMeter()
|
{
|
return this.Meter;
|
}
|
|
/**
|
* @return Returns the eventLocation.
|
*/
|
public String getEventLocation()
|
{
|
return EventLocation;
|
}
|
|
/**
|
* @param m_eventLocation The eventLocation to set.
|
*/
|
public void setEventLocation(String m_eventLocation)
|
{
|
EventLocation = m_eventLocation;
|
}
|
|
public void setCaseStatus(int m_CaseStatus)
|
{
|
this.CaseStatus = m_CaseStatus;
|
}
|
|
public void setChangeTime(String m_ChangeTime)
|
{
|
this.ChangeTime = m_ChangeTime;
|
}
|
|
public String getChangeTime()
|
{
|
return this.ChangeTime;
|
}
|
|
public void setHandlingSummary(String m_HandlingSummary)
|
{
|
this.HandlingSummary = m_HandlingSummary;
|
}
|
|
public String getHandlingSummary()
|
{
|
return this.HandlingSummary;
|
}
|
|
public void setAssumedTime(String m_AssumedTime)
|
{
|
this.AssumedTime = m_AssumedTime;
|
}
|
|
public String getAssumedTime()
|
{
|
return this.AssumedTime;
|
}
|
|
public void setAssumedTime_Nth(String m_AssumedTime_Nth)
|
{
|
this.AssumedTime_Nth = m_AssumedTime_Nth;
|
}
|
|
public String getAssumedTime_Nth()
|
{
|
return this.AssumedTime_Nth;
|
}
|
|
public void setDelayTimes(int m_DelayTimes)
|
{
|
this.DelayTimes = m_DelayTimes;
|
}
|
|
public int getDelayTimes()
|
{
|
return this.DelayTimes;
|
}
|
|
public void setReason(String m_Reason)
|
{
|
this.Reason = m_Reason;
|
}
|
|
public String getReason()
|
{
|
return this.Reason;
|
}
|
|
public bool Insert(RecordLog _PLog, OracleConnection _Conn, OracleTransaction _Transaction)
|
{
|
String SqlStmt;
|
|
if (!Check())
|
{
|
return false;
|
}
|
|
if (Meter == null)
|
{
|
SqlStmt = "INSERT INTO CCS.EVENTQUERY (CCSID,CASESTATUS,CHANGETIME,ASSUMEDTIME,ASSUMEDTIME_NTH,DELAYTIMES,REASON,INPUTTIME) values(" + "'" + CCSID
|
+ "'," + CaseStatus + ",to_date('" + ChangeTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('"
|
+ AssumedTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('" + AssumedTime_Nth + "','yyyy/mm/dd hh24:mi:ss')," + DelayTimes + ",'" + Reason + "',SYSDATE)";
|
}
|
else
|
{
|
SqlStmt = "INSERT INTO CCS.EVENTQUERY (CCSID,METER,CASESTATUS,CHANGETIME,ASSUMEDTIME,ASSUMEDTIME_NTH,DELAYTIMES,REASON,INPUTTIME) values(" + "'"
|
+ CCSID + "','" + Meter + "'," + CaseStatus + ",to_date('" + ChangeTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('" + AssumedTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('"
|
+ AssumedTime_Nth + "','yyyy/mm/dd hh24:mi:ss')," + DelayTimes + ",'" + Reason + "',SYSDATE)";
|
|
}
|
|
OracleCommand Command = new OracleCommand(SqlStmt, _Conn, _Transaction);
|
|
try
|
{
|
if (Command.ExecuteNonQuery() > 0)
|
return true;
|
else
|
return false;
|
}
|
catch (Exception e)
|
{
|
_PLog.Error(e.Message);
|
Console.WriteLine(e.StackTrace);
|
return false;
|
}
|
finally
|
{
|
Command.Dispose();
|
}
|
}
|
|
public bool Insert(SEventLog _PLog, OracleConnection _Conn, OracleTransaction _Transaction)
|
{
|
String SqlStmt;
|
|
if (!Check())
|
{
|
return false;
|
}
|
|
if (Meter == null)
|
{
|
SqlStmt = "INSERT INTO CCS.EVENTQUERY (CCSID,CASESTATUS,CHANGETIME,ASSUMEDTIME,ASSUMEDTIME_NTH,DELAYTIMES,REASON,INPUTTIME) values(" + "'" + CCSID
|
+ "'," + CaseStatus + ",to_date('" + ChangeTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('"
|
+ AssumedTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('" + AssumedTime_Nth + "','yyyy/mm/dd hh24:mi:ss')," + DelayTimes + ",'" + Reason + "',SYSDATE)";
|
}
|
else
|
{
|
SqlStmt = "INSERT INTO CCS.EVENTQUERY (CCSID,METER,CASESTATUS,CHANGETIME,ASSUMEDTIME,ASSUMEDTIME_NTH,DELAYTIMES,REASON,INPUTTIME) values(" + "'"
|
+ CCSID + "','" + Meter + "'," + CaseStatus + ",to_date('" + ChangeTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('" + AssumedTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('"
|
+ AssumedTime_Nth + "','yyyy/mm/dd hh24:mi:ss')," + DelayTimes + ",'" + Reason + "',SYSDATE)";
|
}
|
|
OracleCommand Command = new OracleCommand(SqlStmt, _Conn, _Transaction);
|
|
try
|
{
|
if (Command.ExecuteNonQuery() > 0)
|
return true;
|
else
|
return false;
|
}
|
catch (Exception e)
|
{
|
_PLog.Error(e.Message);
|
Console.WriteLine(e.StackTrace);
|
|
if (LocalVariable.ShowError)
|
_PLog.Error(e.StackTrace);
|
|
throw e;
|
}
|
finally
|
{
|
Command.Dispose();
|
}
|
}
|
|
|
public bool Update(RecordLog _PLog, OracleConnection _Conn, OracleTransaction _Transaction)
|
{
|
if (!Check())
|
{
|
return false;
|
}
|
|
String SqlStmt = "UPDATE CCS.EVENTQUERY SET CASESTATUS=" + this.CaseStatus + ",CHANGETIME=to_date('"
|
+ this.ChangeTime + "','yyyy/mm/dd hh24:mi:ss'),ASSUMEDTIME=to_date('"
|
+ this.AssumedTime + "','yyyy/mm/dd hh24:mi:ss'),ASSUMEDTIME_NTH=to_date('"
|
+ this.AssumedTime_Nth + "','yyyy/mm/dd hh24:mi:ss'),DELAYTIMES=" + this.DelayTimes + ",REASON='"
|
+ this.Reason + "',EVENTLOCATION ='" + this.EventLocation + "' WHERE CCSID='" + this.CCSID + "'";
|
|
OracleCommand Command = new OracleCommand(SqlStmt, _Conn, _Transaction);
|
|
try
|
{
|
if (Command.ExecuteNonQuery() <= 0)
|
{
|
_PLog.Error("更新CCS.EVENTQUERY資料失敗.");
|
return false;
|
}
|
}
|
catch (Exception e)
|
{
|
_PLog.Error(e.Message);
|
Console.WriteLine(e.StackTrace);
|
return false;
|
}
|
finally
|
{
|
Command.Dispose();
|
}
|
|
return true;
|
}
|
|
public bool UpdateCaseStatus(SEventLog _PLog, OracleConnection _Conn, OracleTransaction _Transaction)
|
{
|
String SqlStmt = "UPDATE CCS.EVENTQUERY SET CASESTATUS = " + CaseStatus + " WHERE CCSID = '" + CCSID + "'";
|
|
OracleCommand Command = new OracleCommand(SqlStmt, _Conn, _Transaction);
|
|
try
|
{
|
if (Command.ExecuteNonQuery() <= 0)
|
{
|
_PLog.Error("更新CCS.EVENTQUERY的CASESTATUS失敗.");
|
return false;
|
}
|
}
|
catch (Exception e)
|
{
|
_PLog.Error(e.Message);
|
Console.WriteLine(e.StackTrace);
|
|
if (LocalVariable.ShowError)
|
_PLog.Error(e.StackTrace);
|
|
throw e;
|
}
|
finally
|
{
|
Command.Dispose();
|
}
|
|
return true;
|
}
|
|
// Not Null Check
|
private bool Check()
|
{
|
if (CCSID == null)
|
{
|
return false;
|
}
|
|
if (CaseStatus == 0)
|
{
|
return false;
|
}
|
Reason = (Reason == null ? "" : Reason);
|
return true;
|
}
|
|
|
}
|
}
|
