using System;
|
|
using System.Data.OracleClient;
|
using NLog;
|
|
namespace CCSTrace.CCS.Object
|
{
|
public class NumberContrast
|
{
|
private static readonly Logger Logger = LogManager.GetCurrentClassLogger();
|
|
private string _ccsid;
|
private string _acceptNum;
|
private int _caseId;
|
|
public NumberContrast()
|
{
|
}
|
|
public string Ccsid
|
{
|
get { return _ccsid; }
|
set { _ccsid = value; }
|
}
|
|
public string AcceptNum
|
{
|
get { return _acceptNum; }
|
set { _acceptNum = value; }
|
}
|
|
public int CaseId
|
{
|
get { return _caseId; }
|
set { _caseId = value; }
|
}
|
|
public void SetCcsid(string mCcsid)
|
{
|
_ccsid = mCcsid;
|
}
|
|
public string GetCcsid()
|
{
|
return _ccsid;
|
}
|
|
public void SetAcceptNum(string mAcceptNum)
|
{
|
_acceptNum = mAcceptNum;
|
}
|
|
public string GetAcceptNum()
|
{
|
return _acceptNum;
|
}
|
|
public void SetCaseId(int mCaseId)
|
{
|
_caseId = mCaseId;
|
}
|
|
public int GetCaseId()
|
{
|
return _caseId;
|
}
|
|
public bool Insert(OracleConnection conn, OracleTransaction transaction)
|
{
|
if (!Check())
|
{
|
return false;
|
}
|
|
var sqlStmt = "INSERT INTO CCS.NUM_CONTRAST (CCSID,ACCEPTNUM,CASEID) VALUES ('" + _ccsid + "','" + _acceptNum + "'," + _caseId + ")";
|
|
OracleCommand command = new OracleCommand(sqlStmt, conn, transaction);
|
|
try
|
{
|
if (command.ExecuteNonQuery() > 0)
|
{
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
Logger.Warn(e, e.Message);
|
}
|
finally
|
{
|
command?.Dispose();
|
}
|
|
return false;
|
}
|
|
public bool Update(OracleConnection conn, OracleTransaction transaction)
|
{
|
if (!Check())
|
{
|
return false;
|
}
|
var sqlStmt = "UPDATE CCS.NUM_CONTRAST SET ACCEPTNUM='" + _acceptNum + "',CASEID=" + _caseId + " WHERE CCSID='" + _ccsid + "'";
|
|
OracleCommand command = new OracleCommand(sqlStmt, conn, transaction);
|
|
try {
|
if (command.ExecuteNonQuery() <= 0)
|
{
|
return false;
|
}
|
}
|
catch (Exception e)
|
{
|
Logger.Warn(e, e.Message);
|
}
|
finally
|
{
|
command?.Dispose();
|
}
|
|
return true;
|
}
|
|
private bool Check()
|
{
|
if (_ccsid == null)
|
return false;
|
|
if (_acceptNum == null)
|
return false;
|
|
if (_caseId == 0)
|
return false;
|
|
return true;
|
}
|
}
|
}
|
