From b0c18d369abd06075c83759b0e19823c2a11d716 Mon Sep 17 00:00:00 2001
From: ulysseskao <ulysseskao@gmail.com>
Date: Fri, 29 Apr 2016 18:45:41 +0800
Subject: [PATCH] update for new model

---
 CCSTrace/CCS/Object/NumberContrast.cs |   72 ++++++++++++++++--------------------
 1 files changed, 32 insertions(+), 40 deletions(-)

diff --git a/CCSTrace/CCS/Object/NumberContrast.cs b/CCSTrace/CCS/Object/NumberContrast.cs
index c306a54..9265da4 100644
--- a/CCSTrace/CCS/Object/NumberContrast.cs
+++ b/CCSTrace/CCS/Object/NumberContrast.cs
@@ -1,12 +1,4 @@
 using System;
-using System.Data;
-using System.Configuration;
-using System.Web;
-using System.Web.Security;
-using System.Web.UI;
-using System.Web.UI.HtmlControls;
-using System.Web.UI.WebControls;
-using System.Web.UI.WebControls.WebParts;
 
 using System.Data.OracleClient;
 
@@ -14,99 +6,99 @@
 {
     public class NumberContrast
     {
-        private String CCSID;
-        private String AcceptNum;
-        private int CaseID;
+        private string _ccsid;
+        private string _acceptNum;
+        private int _caseId;
 
         public NumberContrast()
         {
         }
 
-        public void setCCSID(String m_CCSID)
+        public void SetCcsid(string mCcsid)
         {
-            this.CCSID = m_CCSID;
+            _ccsid = mCcsid;
         }
 
-        public String getCCSID()
+        public string GetCcsid()
         {
-            return this.CCSID;
+            return _ccsid;
         }
 
-        public void setAcceptNum(String m_AcceptNum)
+        public void SetAcceptNum(string mAcceptNum)
         {
-            this.AcceptNum = m_AcceptNum;
+            _acceptNum = mAcceptNum;
         }
 
-        public String getAcceptNum()
+        public string GetAcceptNum()
         {
-            return this.AcceptNum;
+            return _acceptNum;
         }
 
-        public void setCaseID(int m_CaseID)
+        public void SetCaseId(int mCaseId)
         {
-            this.CaseID = m_CaseID;
+            _caseId = mCaseId;
         }
 
-        public int getCaseID()
+        public int GetCaseId()
         {
-            return this.CaseID;
+            return _caseId;
         }
 
-        public bool Insert(OracleConnection _Conn,OracleTransaction _Transaction)
+        public bool Insert(OracleConnection conn, OracleTransaction transaction)
         {
-            String SqlStmt;
+            string sqlStmt;
 
             if (!Check())
             {
                 return false;
             }
 
-            SqlStmt = "INSERT INTO CCS.NUM_CONTRAST (CCSID,ACCEPTNUM,CASEID) VALUES ('" + CCSID + "','" + AcceptNum + "'," + CaseID + ")";
+            sqlStmt = "INSERT INTO CCS.NUM_CONTRAST (CCSID,ACCEPTNUM,CASEID) VALUES ('" + _ccsid + "','" + _acceptNum + "'," + _caseId + ")";
 
-            OracleCommand Command = new OracleCommand(SqlStmt, _Conn, _Transaction);
+            OracleCommand command = new OracleCommand(sqlStmt, conn, transaction);
 
-            if (Command.ExecuteNonQuery() > 0)
+            if (command.ExecuteNonQuery() > 0)
             {
-                Command.Dispose();
+                command.Dispose();
                 return true;
             }
 
-            Command.Dispose();
+            command.Dispose();
             return false;
         }
 
-        public bool Update(OracleConnection _Conn,OracleTransaction _Transaction)
+        public bool Update(OracleConnection conn, OracleTransaction transaction)
         {
             if (!Check())
             {
                 return false;
             }
-            String SqlStmt = "UPDATE CCS.NUM_CONTRAST SET ACCEPTNUM='" + this.AcceptNum + "',CASEID=" + this.CaseID + " WHERE CCSID='" + this.CCSID + "'";
+            string sqlStmt = "UPDATE CCS.NUM_CONTRAST SET ACCEPTNUM='" + _acceptNum + "',CASEID=" + _caseId + " WHERE CCSID='" + _ccsid + "'";
 
-            OracleCommand Command = new OracleCommand(SqlStmt, _Conn, _Transaction);
+            OracleCommand command = new OracleCommand(sqlStmt, conn, transaction);
 
-            if (Command.ExecuteNonQuery() <= 0)
+            if (command.ExecuteNonQuery() <= 0)
             {
-                Command.Dispose();
+                command.Dispose();
                 return false;
             }
 
-            Command.Dispose();
+            command.Dispose();
             return true;
         }
 
         private bool Check()
         {
-            if (this.CCSID == null)
+            if (_ccsid == null)
                 return false;
 
-            if (this.AcceptNum == null)
+            if (_acceptNum == null)
                 return false;
 
-            if (CaseID == 0)
+            if (_caseId == 0)
                 return false;
 
             return true;
         }
     }
-}
+}
\ No newline at end of file

--
Gitblit v0.0.0-SNAPSHOT