From d7d23f920634fd2e70457ca77a137af12b81ec5a Mon Sep 17 00:00:00 2001
From: ulysseskao <ulysseskao@gmail.com>
Date: Thu, 05 May 2016 10:20:25 +0800
Subject: [PATCH] rename file
---
/dev/null | 133 --------------------------
CCSTrace/CCS/Object/DeptContrast.cs | 137 +++++++++++++++++++++++++++
2 files changed, 137 insertions(+), 133 deletions(-)
diff --git a/CCSTrace/CCS/Object/DeptContrast.cs b/CCSTrace/CCS/Object/DeptContrast.cs
new file mode 100644
index 0000000..9e3a324
--- /dev/null
+++ b/CCSTrace/CCS/Object/DeptContrast.cs
@@ -0,0 +1,137 @@
+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();
+ }
+ }
+ }
+}
\ No newline at end of file
diff --git a/CCSTrace/CCS/Object/Dept_Contrast.cs b/CCSTrace/CCS/Object/Dept_Contrast.cs
deleted file mode 100644
index af2a35e..0000000
--- a/CCSTrace/CCS/Object/Dept_Contrast.cs
+++ /dev/null
@@ -1,133 +0,0 @@
-using System;
-
-using System.Collections;
-using System.Data.OracleClient;
-using NLog;
-
-namespace CCSTrace.CCS.Object
-{
- public class DeptContrast
- {
- private static readonly Logger Logger = LogManager.GetCurrentClassLogger();
-
- private ArrayList _mTotalData = null;
- public static string DefaultDept = "市區巡修課";
-
- public DeptContrast(OracleConnection connectionTpc, OracleTransaction trx)
- {
- if (_mTotalData == null)
- Initial(connectionTpc, trx);
- }
-
- public int getDept_Code(string mMeter)
- {
- //int Result = CCS.CCSMain.EOSCodelist.getKeyID(CCS.GlobalVariable.Dept, DefaultDept);
- int result = -1;
-
- try
- {
- for (int i = 0; i < _mTotalData.Count; i++)
- {
- ArrayList tmpData = (ArrayList)_mTotalData[i];
-
- if (tmpData[2] == null)
- {
- result = Convert.ToInt32(tmpData[1].ToString());
- break;
- }
- else
- {// 一對多(需作比對)
- var minMeter = Convert.ToInt64(tmpData[3].ToString());
- var maxMeter = Convert.ToInt64(tmpData[2].ToString());
- var custMeter = Convert.ToInt64(mMeter);
-
- if ((custMeter > minMeter) && (custMeter < maxMeter))
- {
- result = Convert.ToInt32(tmpData[1].ToString());
- break;
- }
- }
- }
- }
- catch (Exception ex)
- {
- Logger.Warn(ex, ex.Message);
- }
- return result;
- }
-
- public int getDept_Code(int scCode, string meter)
- {
- int result = GlobalVariable.EosCodelist.GetKeyId(GlobalVariable.Dept, DefaultDept);
- try
- {
- for (int i = 0; i < _mTotalData.Count; i++)
- {
- ArrayList tmpData = (ArrayList)_mTotalData[i];
- int tmpDept = Convert.ToInt32(tmpData[0].ToString());
-
- if (tmpDept == scCode)
- {
- // 一對一(無最大最小電號限制)
- if (tmpData[2] == null)
- {
- result = Convert.ToInt32(tmpData[1].ToString());
- break;
- }
- else
- {// 一對多(需作比對)
- long minMeter = Convert.ToInt64(tmpData[3].ToString());
- long maxMeter = Convert.ToInt64(tmpData[2].ToString());
- long custMeter = Convert.ToInt64(meter);
-
- if ((custMeter > minMeter) && (custMeter < maxMeter))
- {
- result = Convert.ToInt32(tmpData[1].ToString());
- break;
- }
- }
- }
- }
- }
- catch (Exception ex)
- {
- Logger.Warn(ex, ex.Message);
- }
-
- return result;
- }
-
- private void Initial(OracleConnection connectionTpc, OracleTransaction trx)
- {
- _mTotalData = new ArrayList();
-
- var sqlStmt = "SELECT SC_CODE,DEPT_CODE,MAX_METER,MIN_METER FROM CCS.DEPT_CONTRAST";
- OracleCommand command = new OracleCommand(sqlStmt, connectionTpc, trx);
- OracleDataReader reader = command.ExecuteReader();
-
- try
- {
- while (reader.Read())
- {
- ArrayList record = new ArrayList();
- int scCode = Convert.ToInt32(reader["SC_CODE"].ToString());
- record.Add(scCode);
- record.Add(Convert.ToInt32(reader["Dept_Code"].ToString()));
- record.Add(reader["Max_Meter"].ToString());
- record.Add(reader["Min_Meter"].ToString());
-
- _mTotalData.Add(record);
- }
- }
- catch (Exception e)
- {
- Logger.Warn(e, e.Message);
- }
- finally
- {
- reader?.Close();
- command?.Dispose();
- }
- }
- }
-}
\ No newline at end of file
--
Gitblit v0.0.0-SNAPSHOT