| | |
| | | using System;
|
| | | using System.Data.OracleClient;
|
| | | using System.Runtime.CompilerServices;
|
| | | using NLog;
|
| | |
|
| | | namespace CCSTrace.CCS.Function
|
| | | {
|
| | | public class InitialEventData
|
| | | {
|
| | | private static readonly Logger Logger = LogManager.GetCurrentClassLogger();
|
| | |
|
| | | private string _mAcceptNum = "";
|
| | | private int _mCaseId = 0;
|
| | | private int _mYear = 0;
|
| | | private bool _mChangeYear = false;
|
| | | private string _mNowYear = string.Empty;
|
| | | private readonly string _mAcceptTime = "";
|
| | | private readonly RecordLog _pLog;
|
| | | private readonly 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)
|
| | | public InitialEventData(OracleConnection conn)
|
| | | {
|
| | | _connectionTpc = conn;
|
| | | _pLog = log;
|
| | |
|
| | | string sqlStmt = "SELECT ACCEPTNUM,CASEID,YEAR,TO_CHAR(SYSDATE,'YYYY/MM/DD') as ACCEPTTIME FROM EOS.EVENTNUM";
|
| | | var 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();
|
| | |
| | | }
|
| | | else
|
| | | {
|
| | | _pLog.Error("起始號碼資料遺失!");
|
| | | Logger.Error("起始號碼資料遺失!");
|
| | | return;
|
| | | }
|
| | | }
|
| | | catch (Exception e)
|
| | | {
|
| | | _pLog.Error("Problems occur when Initializing EventData: " + e.Message);
|
| | | Logger.Error(e, "Problems occur when Initializing EventData: " + e.Message);
|
| | | Console.WriteLine(e.StackTrace);
|
| | | return;
|
| | | }
|
| | |
| | | }
|
| | | catch (Exception e)
|
| | | {
|
| | | _pLog.Error("Problems occur during EventNumCreating: " + e.Message);
|
| | | Console.WriteLine(e.StackTrace);
|
| | | throw e;
|
| | | Logger.Error(e, "Problems occur during EventNumCreating: " + e.Message);
|
| | | throw;
|
| | | }
|
| | | finally
|
| | | {
|
| | |
| | |
|
| | | private void RegetNumber()
|
| | | {
|
| | | string sqlStmt = "SELECT ACCEPTNUM,CASEID,YEAR FROM EOS.EVENTNUM";
|
| | | var sqlStmt = "SELECT ACCEPTNUM,CASEID,YEAR FROM EOS.EVENTNUM";
|
| | | OracleCommand command = new OracleCommand(sqlStmt, _connectionTpc);
|
| | | OracleDataReader reader = command.ExecuteReader();
|
| | |
|