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.Runtime.CompilerServices;
|
using System.Data.OracleClient;
|
|
namespace CCSTrace.CCS.Function
|
{
|
public class InitialEventData
|
{
|
private String m_AcceptNum = "";
|
private int m_CaseID = 0;
|
private int m_Year = 0;
|
private bool m_ChangeYear = false;
|
private String m_AcceptTime = "";
|
private RecordLog _PLog;
|
private OracleConnection _ConnectionTPC;
|
|
//New CaseID and New AcceptNum must be seen by others,so it need not controled by transaction
|
[MethodImpl(MethodImplOptions.Synchronized)]
|
public InitialEventData(OracleConnection _Conn, RecordLog _Log)
|
{
|
_ConnectionTPC = _Conn;
|
_PLog = _Log;
|
|
String SqlStmt = "SELECT ACCEPTNUM,CASEID,YEAR,TO_CHAR(SYSDATE,'YYYY/MM/DD') as ACCEPTTIME FROM EOS.EVENTNUM";
|
|
OracleCommand Command = new OracleCommand(SqlStmt, _ConnectionTPC);
|
OracleDataReader reader = Command.ExecuteReader();
|
|
try
|
{
|
if (reader.Read())
|
{
|
m_AcceptNum = reader["ACCEPTNUM"].ToString();
|
m_CaseID = Convert.ToInt32(reader["CASEID"].ToString());
|
m_Year = Convert.ToInt32(reader["YEAR"].ToString());
|
m_AcceptTime = reader["ACCEPTTIME"].ToString();
|
}
|
else
|
{
|
_PLog.Error("起始號碼資料遺失!");
|
return;
|
}
|
}
|
catch (Exception e)
|
{
|
_PLog.Error("Problems occur when Initializing EventData: " + e.Message);
|
Console.WriteLine(e.StackTrace);
|
return;
|
}
|
finally
|
{
|
reader.Close();
|
Command.Dispose();
|
}
|
|
CheckAcceptNum();
|
|
while (!UpdateDataBase(m_ChangeYear)) {
|
this.RegetNumber();
|
CheckAcceptNum();
|
}
|
}
|
|
public int getNewCaseID() {
|
return this.m_CaseID;
|
}
|
|
public String getNewAcceptNum() {
|
return this.m_AcceptNum;
|
}
|
|
private bool UpdateDataBase(bool m_ChangeYear) {
|
String SqlStmt;
|
bool m_Result = false;
|
|
if (m_ChangeYear)
|
SqlStmt = "UPDATE EOS.EVENTNUM SET ACCEPTNUM = '" + (Convert.ToInt32(m_AcceptNum) + 1).ToString() + "',CASEID = "
|
+ (m_CaseID + 1) + ",YEAR = " + (m_Year + 1) + " WHERE CASEID = " + this.m_CaseID;
|
else
|
SqlStmt = "UPDATE EOS.EVENTNUM SET ACCEPTNUM = '" + (Convert.ToInt32(m_AcceptNum) + 1).ToString() + "',CASEID = "
|
+ (m_CaseID + 1) + " WHERE CASEID = " + this.m_CaseID;
|
|
OracleCommand Command = new OracleCommand(SqlStmt, _ConnectionTPC);
|
|
try
|
{
|
if (Command.ExecuteNonQuery() > 0)
|
m_Result = true;
|
}
|
catch (Exception e)
|
{
|
_PLog.Error("Problems occur during EventNumCreating: " + e.Message);
|
Console.WriteLine(e.StackTrace);
|
throw e;
|
}
|
finally
|
{
|
Command.Dispose();
|
}
|
|
return m_Result;
|
}
|
|
private void CheckAcceptNum() {
|
int NowYear = Convert.ToInt32(m_AcceptTime.Substring(0, 4)) - 1911;
|
int NowMonth = Convert.ToInt32(m_AcceptTime.Substring(5, 2));
|
String Tmp = this.m_AcceptNum;
|
|
if (Convert.ToInt32(Tmp.Substring(0, 3)) == NowYear)
|
{
|
if (Convert.ToInt32(Tmp.Substring(3, 2)) != NowMonth)
|
{
|
// 新月份
|
if (NowMonth < 10)
|
m_AcceptNum = NowYear.ToString() + "0" + NowMonth.ToString() + "0001";
|
else
|
m_AcceptNum = NowYear.ToString() + NowMonth.ToString() + "0001";
|
}
|
} else {
|
m_AcceptNum = NowYear.ToString() + "010001"; // 新年度
|
this.m_ChangeYear = true;
|
}
|
|
if ( !m_ChangeYear)
|
{
|
}
|
}
|
|
private void RegetNumber()
|
{
|
String SqlStmt = "SELECT ACCEPTNUM,CASEID,YEAR FROM EOS.EVENTNUM";
|
OracleCommand Command = new OracleCommand(SqlStmt, _ConnectionTPC);
|
OracleDataReader reader = Command.ExecuteReader();
|
|
try
|
{
|
if (reader.Read())
|
{
|
m_AcceptNum = reader["ACCEPTNUM"].ToString();
|
m_CaseID = Convert.ToInt32(reader["CASEID"].ToString());
|
m_Year = Convert.ToInt32(reader["YEAR"].ToString());
|
}
|
}
|
catch (Exception e)
|
{
|
Console.WriteLine(e.Message);
|
Console.WriteLine(e.StackTrace);
|
}
|
finally
|
{
|
reader.Close();
|
Command.Dispose();
|
}
|
}
|
}
|
}
|
