using System;
|
|
using System.Collections;
|
using System.Collections.Generic;
|
using System.Data.OracleClient;
|
using CCSTrace.TPower.DMMS.Model.CCS;
|
using NLog;
|
|
namespace CCSTrace.CCS.Object
|
{
|
public class DeptContrast
|
{
|
private static readonly Logger Logger = LogManager.GetCurrentClassLogger();
|
|
public const string DefaultDept = "市區巡修課";
|
public static DeptContrast Instance { get; } = new DeptContrast();
|
|
private List<DEPTCONTRAST> _mTotalData;
|
|
private DeptContrast()
|
{
|
}
|
|
public int getDept_Code(string mMeter)
|
{
|
//int Result = CCS.CCSMain.EOSCodelist.getKeyID(CCS.GlobalVariable.Dept, DefaultDept);
|
var result = -1;
|
|
try
|
{
|
for (var i = 0; i < _mTotalData.Count; i++)
|
{
|
var tmpData = _mTotalData[i];
|
|
if (tmpData.MAXMETER == null)
|
{
|
result = Convert.ToInt32(tmpData.DEPTCODE);
|
break;
|
}
|
else
|
{// 一對多(需作比對)
|
var minMeter = Convert.ToInt64(tmpData.MINMETER);
|
var maxMeter = Convert.ToInt64(tmpData.MAXMETER);
|
var custMeter = Convert.ToInt64(mMeter);
|
|
if ((custMeter > minMeter) && (custMeter < maxMeter))
|
{
|
result = Convert.ToInt32(tmpData.DEPTCODE);
|
break;
|
}
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
Logger.Warn(ex, ex.Message);
|
}
|
return result;
|
}
|
|
public int getDept_Code(int scCode, string meter)
|
{
|
var result = GlobalVariable.EosCodelist.GetKeyId(GlobalVariable.Dept, DefaultDept);
|
try
|
{
|
for (var i = 0; i < _mTotalData.Count; i++)
|
{
|
var tmpData = _mTotalData[i];
|
var tmpDept = Convert.ToInt32(tmpData.SCCODE);
|
|
if (tmpDept == scCode)
|
{
|
// 一對一(無最大最小電號限制)
|
if (tmpData.MAXMETER == null)
|
{
|
result = Convert.ToInt32(tmpData.DEPTCODE);
|
break;
|
}
|
else
|
{// 一對多(需作比對)
|
var minMeter = Convert.ToInt64(tmpData.MINMETER);
|
var maxMeter = Convert.ToInt64(tmpData.MAXMETER);
|
var custMeter = Convert.ToInt64(meter);
|
|
if ((custMeter > minMeter) && (custMeter < maxMeter))
|
{
|
result = Convert.ToInt32(tmpData.DEPTCODE);
|
break;
|
}
|
}
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
Logger.Warn(ex, ex.Message);
|
}
|
|
return result;
|
}
|
|
public void Initialize(OracleConnection conn)
|
{
|
_mTotalData = new List<DEPTCONTRAST>();
|
|
var sqlStmt = "SELECT SC_CODE,DEPT_CODE,MAX_METER,MIN_METER FROM CCS.DEPT_CONTRAST";
|
var command = new OracleCommand(sqlStmt, conn);
|
var reader = command.ExecuteReader();
|
|
try
|
{
|
while (reader.Read())
|
{
|
var deptcontrast = new DEPTCONTRAST
|
{
|
SCCODE = reader["SC_CODE"].ToString(),
|
DEPTCODE = reader["Dept_Code"].ToString(),
|
MAXMETER = reader["Max_Meter"].ToString(),
|
MINMETER = reader["Min_Meter"].ToString()
|
};
|
|
|
_mTotalData.Add(deptcontrast);
|
}
|
}
|
catch (Exception e)
|
{
|
Logger.Warn(e, e.Message);
|
}
|
finally
|
{
|
reader?.Close();
|
command?.Dispose();
|
}
|
}
|
}
|
}
|
