refator code

ulysseskao

2016-05-03 410dc2d04dbecf019129cd8cd65a3be2c62b4d0c

 CCSTrace/CCS/Object/Dept_Contrast.cs

@@ -37,9 +37,9 @@
                    }

                    else

                    {// 一對多(需作比對)

                        long minMeter = Convert.ToInt64(tmpData[3].ToString());

                        long maxMeter = Convert.ToInt64(tmpData[2].ToString());

                        long custMeter = Convert.ToInt64(mMeter);

                        var minMeter = Convert.ToInt64(tmpData[3].ToString());

                        var maxMeter = Convert.ToInt64(tmpData[2].ToString());

                        var custMeter = Convert.ToInt64(mMeter);



                        if ((custMeter > minMeter) && (custMeter < maxMeter))

                        {

@@ -51,7 +51,7 @@
            }

            catch (Exception ex)

            {

                Console.WriteLine(ex.Message);

                Logger.Warn(ex, ex.Message);

            }

            return result;

        }

@@ -91,7 +91,7 @@
            }

            catch (Exception ex)

            {

                Console.WriteLine(ex.Message);

                Logger.Warn(ex, ex.Message);

            }



            return result;

@@ -99,10 +99,9 @@


        private void Initial(OracleConnection connectionTpc, OracleTransaction trx)

        {

            string sqlStmt;

            _mTotalData = new ArrayList();



            sqlStmt = "SELECT SC_CODE,DEPT_CODE,MAX_METER,MIN_METER FROM CCS.DEPT_CONTRAST";

            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();



@@ -122,12 +121,12 @@
            }

            catch (Exception e)

            {

                Console.WriteLine(e.StackTrace);

                Logger.Warn(e, e.Message);

            }

            finally

            {

                reader.Close();

                command.Dispose();

                reader?.Close();

                command?.Dispose();

            }

        }

    }