ulysseskao
2016-05-01 8f5c8891aba521570fa63c4baf616e3a3c8d9526
CCSTrace/CCS/Function/InitialEventData.cs
@@ -1,28 +1,29 @@
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();
@@ -38,13 +39,13 @@
                }
                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;
            }
@@ -94,9 +95,8 @@
            }
            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
            {
@@ -137,7 +137,7 @@
        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();