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 CCSRecord
|
{
|
private String Meter;
|
private String CustomerName;
|
private String CustomerTel;
|
private String ADDR_City;
|
private String ADDR_Town;
|
private String ADDR_Road;
|
private String ADDR_Other;
|
private String RecallName;
|
private String RecallTel;
|
private int EventBrief;
|
private String AcceptTime;
|
private String CCSID;
|
private int ImportCase;
|
private String Dept;
|
private int PartHicustomer;
|
private String Note;
|
|
public CCSRecord(String _CCSID, String _METER, String _CUSTOMERNAME, String _CUSTOMERTEL, String _ADDR_CITY, String _ADDR_TOWN, String _ADDR_ROAD,
|
String _ADDR_OTHER, String _RECALLNAME, String _RECALLTEL, int _EVENTBRIEF, String _ACCEPTTIME, int _IMPORTCASE, String _DEPT,
|
int _PartHicustomer,String _NOTE)
|
{
|
this.Meter = _METER;
|
this.CustomerName = _CUSTOMERNAME;
|
this.CustomerTel = _CUSTOMERTEL;
|
this.ADDR_City = _ADDR_CITY;
|
this.ADDR_Town = _ADDR_TOWN;
|
this.ADDR_Road = _ADDR_ROAD;
|
this.ADDR_Other = _ADDR_OTHER;
|
this.RecallName = _RECALLNAME;
|
this.RecallTel = _RECALLTEL;
|
this.EventBrief = _EVENTBRIEF; ;
|
this.CCSID = _CCSID;
|
this.ImportCase = _IMPORTCASE;
|
this.Dept = _DEPT;
|
this.Note = _NOTE;
|
this.PartHicustomer = _PartHicustomer;
|
this.AcceptTime = _ACCEPTTIME;
|
}
|
|
public CCSRecord(String _CCSID, OracleConnection _ConnectionTPC, SEventLog _PLog)
|
{
|
String SqlStmt;
|
|
SqlStmt = "SELECT METER,CUSTOMERNAME,CUSTOMERTEL,ADDR_CITY,ADDR_TOWN,ADDR_ROAD,ADDR_OTHER,RECALLNAME,RECALLTEL,EVENTBRIEF,"
|
+ "TO_CHAR(ACCEPTTIME,'YYYY/MM/DD HH24:MI:SS') as ACCEPTTIME,CCSID,IMPORTCASE,DEPT,PARTHICUSTOMER,NOTE FROM CCS.EVENTRECORD "
|
+ "WHERE CCSID = '" + _CCSID + "'";
|
|
OracleCommand Command = new OracleCommand(SqlStmt, _ConnectionTPC);
|
OracleDataReader reader = Command.ExecuteReader();
|
|
try
|
{
|
while (reader.Read())
|
{
|
Meter = reader["METER"].ToString();
|
CustomerName = reader["CUSTOMERNAME"].ToString();
|
CustomerTel = reader["CUSTOMERTEL"].ToString();
|
ADDR_City = reader["ADDR_CITY"].ToString();
|
ADDR_Town = reader["ADDR_TOWN"].ToString();
|
ADDR_Road = reader["ADDR_ROAD"].ToString();
|
ADDR_Other = reader["ADDR_OTHER"].ToString();
|
RecallName = reader["RECALLNAME"].ToString();
|
RecallTel = reader["RECALLTEL"].ToString();
|
EventBrief = Int32.Parse(reader["EVENTBRIEF"].ToString());
|
AcceptTime = reader["ACCEPTTIME"].ToString();
|
CCSID = reader["CCSID"].ToString();
|
ImportCase = Int32.Parse(reader["IMPORTCASE"].ToString());
|
Dept = reader["DEPT"].ToString();
|
PartHicustomer = Int32.Parse(reader["PARTHICUSTOMER"].ToString());
|
Note = reader["NOTE"].ToString();
|
}
|
}
|
catch (Exception e)
|
{
|
_PLog.Error("無法取得CCS報案資訊!" + e.Message);
|
Console.WriteLine(e.StackTrace);
|
|
if (LocalVariable.ShowError)
|
_PLog.Error(e.StackTrace);
|
|
throw e;
|
}
|
finally
|
{
|
reader.Close();
|
Command.Dispose();
|
}
|
}
|
|
public bool InsertDB(OracleConnection _ConnectionTPC, System.Data.OracleClient.OracleTransaction _Transaction, SEventLog _PLog)
|
{
|
String SqlStmt;
|
|
SqlStmt = "INSERT INTO CCS.EVENTRECORD VALUES ('" + this.Meter + "','" + CustomerName + "','" + CustomerTel + "','" + ADDR_City + "','"
|
+ ADDR_Town + "','" + ADDR_Road + "','" + ADDR_Other + "','" + RecallName + "','" + RecallTel + "',"
|
+ EventBrief + ",TO_DATE('" + AcceptTime + "','YYYY/MM/DD HH24:MI:SS'),'" + CCSID + "'," + ImportCase + ",'" + Dept + "',"
|
+ PartHicustomer + ",'" + Note + "')";
|
|
OracleCommand Command = new OracleCommand(SqlStmt, _ConnectionTPC, _Transaction);
|
|
try
|
{
|
if (Command.ExecuteNonQuery() != 1)
|
{
|
_PLog.Error("CCS 案件受理程序初始化失敗...無法將CCS報案資訊存入資料庫中!");
|
|
throw new Exception("CCS 案件受理程序初始化失敗...無法將CCS報案資訊存入資料庫中!");
|
}
|
}
|
catch (Exception e)
|
{
|
Console.WriteLine(e.StackTrace);
|
|
if (LocalVariable.ShowError)
|
_PLog.Error(e.StackTrace);
|
|
_PLog.Error("CCS 案件受理程序初始化失敗...無法將CCS報案資訊存入資料庫中!" + e.Message);
|
//throw new Exception("CCS 案件受理程序初始化失敗...無法將CCS報案資訊存入資料庫中");
|
throw e;
|
}
|
finally
|
{
|
Command.Dispose();
|
}
|
return true;
|
}
|
|
public String getMeter()
|
{
|
return this.Meter;
|
}
|
|
public String getCustomerName()
|
{
|
return this.CustomerName;
|
}
|
|
public String getCustomerTel()
|
{
|
return this.CustomerTel;
|
}
|
|
public String getADDR_City()
|
{
|
return this.ADDR_City;
|
}
|
|
public String getADDR_Town()
|
{
|
return this.ADDR_Town;
|
}
|
|
public String getADDR_Road()
|
{
|
return this.ADDR_Road;
|
}
|
|
public String getADDR_Other()
|
{
|
return this.ADDR_Other;
|
}
|
|
public String getRecallName()
|
{
|
return this.RecallName;
|
}
|
|
public String getRecallTel()
|
{
|
return this.RecallTel;
|
}
|
|
public int getEventBrief()
|
{
|
return this.EventBrief;
|
}
|
|
public String getAcceptTime()
|
{
|
return this.AcceptTime;
|
}
|
|
public String getCCSID()
|
{
|
return this.CCSID;
|
}
|
|
public int getImportCase()
|
{
|
return this.ImportCase;
|
}
|
|
public String getDetp()
|
{
|
return this.Dept;
|
}
|
|
public int getPartHicustomer()
|
{
|
return PartHicustomer;
|
}
|
|
public String getNote()
|
{
|
return this.Note;
|
}
|
}
|
}
|
