update for logger

ulysseskao

2016-05-01 8f5c8891aba521570fa63c4baf616e3a3c8d9526

 CCSTrace/CCS/Object/Addr_Contrast.cs

@@ -2,23 +2,22 @@


using System.Collections;

using System.Data.OracleClient;

using NLog;



namespace CCSTrace.CCS.Object

{

    public class AddrContrast

    {

        private static readonly Logger Logger = LogManager.GetCurrentClassLogger();



        public static Hashtable MTotalData = null;

        public static string DefaultDept = "市區巡修課";

        private OracleConnection _connectionTpc;

        private RecordLog _pLog;



        public AddrContrast(OracleConnection conn, OracleTransaction trx, RecordLog log)

        public AddrContrast(OracleConnection conn, OracleTransaction trx)

        {

            _connectionTpc = conn;

            _pLog = log;



            string sqlStmt;

            string city;

            ArrayList mData = new ArrayList();

            string tmp = "";



@@ -26,7 +25,7 @@
                return;



            MTotalData = new Hashtable();

            sqlStmt = "SELECT DEPTID,CITY,TOWN,ROAD FROM CCS.ADDR_CONTRAST ORDER BY CITY,TOWN,ROAD";

            var sqlStmt = "SELECT DEPTID,CITY,TOWN,ROAD FROM CCS.ADDR_CONTRAST ORDER BY CITY,TOWN,ROAD";



            OracleCommand command = null;

            OracleDataReader reader = null;

@@ -38,7 +37,7 @@
                while (reader.Read())

                {

                    ArrayList mRecord = new ArrayList();

                    city = reader["CITY"].ToString();

                    var city = reader["CITY"].ToString();

                    mRecord.Add(city);

                    mRecord.Add(reader["TOWN"].ToString());

                    mRecord.Add(reader["ROAD"].ToString());

@@ -86,9 +85,10 @@
                        return deptId;

                }

            }

            catch (Exception)

            catch (Exception e)

            {

                _pLog.Warn("無法取得所屬巡修部門代號,預設案件所屬巡修部門為市區巡修課!");

                Logger.Warn(e , e.Message);

                Logger.Warn("無法取得所屬巡修部門代號,預設案件所屬巡修部門為市區巡修課!");

            }

            // 當找不到部門別時,Default 設定為市巡

            dept = GlobalVariable.EosCodelist.GetKeyId(GlobalVariable.Dept, DefaultDept);