using System;
|
|
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;
|
|
public AddrContrast(OracleConnection conn, OracleTransaction trx)
|
{
|
_connectionTpc = conn;
|
|
ArrayList mData = new ArrayList();
|
string tmp = "";
|
|
if (MTotalData != null)
|
return;
|
|
MTotalData = new Hashtable();
|
var sqlStmt = "SELECT DEPTID,CITY,TOWN,ROAD FROM CCS.ADDR_CONTRAST ORDER BY CITY,TOWN,ROAD";
|
|
OracleCommand command = null;
|
OracleDataReader reader = null;
|
try
|
{
|
command = new OracleCommand(sqlStmt, _connectionTpc, trx);
|
reader = command.ExecuteReader();
|
|
while (reader.Read())
|
{
|
ArrayList mRecord = new ArrayList();
|
var city = reader["CITY"].ToString();
|
mRecord.Add(city);
|
mRecord.Add(reader["TOWN"].ToString());
|
mRecord.Add(reader["ROAD"].ToString());
|
mRecord.Add(Convert.ToInt32(reader["DEPTID"].ToString()));
|
|
if (tmp.Equals(city))
|
mData.Add(mRecord);
|
else
|
{
|
MTotalData.Add(tmp, mData);
|
tmp = city;
|
mData = new ArrayList();
|
mData.Add(mRecord);
|
}
|
}
|
MTotalData.Add(tmp, mData);
|
}
|
catch (Exception e)
|
{
|
Console.WriteLine(e.StackTrace);
|
MTotalData = null;
|
}
|
finally
|
{
|
reader.Close();
|
command.Dispose();
|
}
|
}
|
|
public int FindDeptId(string city, string region, string road)
|
{
|
int dept = 0;
|
ArrayList mData = (ArrayList)MTotalData[city];
|
|
try
|
{
|
for (int i = 0; i < mData.Count; i++)
|
{
|
ArrayList tmp = (ArrayList)mData[i];
|
string mRegion = tmp[1].ToString().Trim();
|
string mRoad = tmp[2].ToString().Trim();
|
int deptId = Convert.ToInt32(tmp[3].ToString());
|
|
if ((region.Trim().Equals(mRegion)) && (road.Trim().Equals(mRoad)))
|
return deptId;
|
}
|
}
|
catch (Exception e)
|
{
|
Logger.Warn(e , e.Message);
|
Logger.Warn("無法取得所屬巡修部門代號,預設案件所屬巡修部門為市區巡修課!");
|
}
|
// 當找不到部門別時,Default 設定為市巡
|
dept = GlobalVariable.EosCodelist.GetKeyId(GlobalVariable.Dept, DefaultDept);
|
return dept;
|
}
|
}
|
}
|
