From 8f5c8891aba521570fa63c4baf616e3a3c8d9526 Mon Sep 17 00:00:00 2001
From: ulysseskao <ulysseskao@gmail.com>
Date: Sun, 01 May 2016 01:12:51 +0800
Subject: [PATCH] update for logger
---
CCSTrace/CCS/Object/Addr_Contrast.cs | 18 +++++++++---------
1 files changed, 9 insertions(+), 9 deletions(-)
diff --git a/CCSTrace/CCS/Object/Addr_Contrast.cs b/CCSTrace/CCS/Object/Addr_Contrast.cs
index e011861..9d18779 100644
--- a/CCSTrace/CCS/Object/Addr_Contrast.cs
+++ b/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);
--
Gitblit v0.0.0-SNAPSHOT