In the early days of learning .NET, it is used to writing crudous methods to the class, and later considering that this kind of writing is inconvenient to expand, especially when the database type is transplanted, it is necessary to do a lot of work, but write him out.
Using system;
Using system.data;
Using system.data.oraclient;
Using fjPtri.DataAccess.dataHelper;
Namespace Oilmanage
{
Public Class Datfaultentity
{
Public datfaultentity ()
{
}
Public Datfaultent (String Descrption, String Dispose, Decimal Fault_ID, DateTime Operate, String Operateuser, Decimal TriaLinfo_ID)
{
THIS.DESCRPTION = DESCRPTION;
THISPOSE = Dispose;
THIS.FAULT_ID = fault_id;
THIS.OPERATEDATE = OPERATEDATE
This.operateuser = OPERATEUSER;
THIS.TRIALINFO_ID = trialinfo_id;
}
Public Datfaultentity (Datfaultpk Datfault PK)
{
THIS.PK = DATFAULTPK;
this.read ();
}
PRIVATE STRING MDESCRPTION;
Public String Descrption
{
Get {return mdescrption;}
Set {mdescrption = value;
}
PRIVATE STRING MDISPOSE;
Public String Dispose
{
Get {return mdispose;}
Set {mdispose = value;
}
PRIVATE DECIMAL MFAULT_ID;
Public Decimal Fault_ID
{
Get {return mfault_id;}
Set {mfault_id = value;}
}
PRIVATE dateTime Mopedate;
Public DateTime OperateDate
{
Get {returnometedate;}
Set {MOPERATEDATE = VALUE;
}
PRIVATE STRING MOPERATEUSER;
Public String Operateuser
{
Get {return moprateuser;}
Set {moprateuser = value;
}
PRIVATE DECIMAL MTRIALINFO_ID;
Public Decimal TriaLinfo_ID
{
Get {return mtrialInfo_id;}
Set {mtrialInfo_id = value;
}
Private datfaultpk datfaultpk;
Public Datfaultpk PK PK
{
get
{
Return New Datfaultpk (this.fault_id);
}
set
{
THIS.FAULT_ID = VALUE.FAULT_ID;
}
}
Public void create ()
{
OracleConnection Connection = New OracleConnection (ConfigInfo.getConnection ";
Connection.open ();
OracleTransaction Transaction = Connection.Begintractions; Try
{
THIS.CREATE (Transaction);
Transaction.commit ();
}
Catch (Exception EX)
{
Transaction.rollback ();
Throw EX;
}
Finally
{
Connection.Close ();
}
}
Internal Void Create (Oracletractions)
{
String create = "INSERT INTO DATFAULT (Descrption, Dispose, Fault_ID, OPERITEDATE, OPERATEUSER, TRIALINFO_ID) VALUES (: Descrption,: dispose,: fault_id,: operatedate,: operateuser,: trialinfo_id)"
OracleParameter [] Param = OracleHelper.getCacheParameter (CREATE);
IF (param == NULL)
{
Param = New OracleParameter [6];
Param [0] = New OracleParameter ("Descrption", Oracletype.varchar, 4000);
Param [1] = New OracleParameter ("Dispose", ORACletype.varchar, 4000);
Param [2] = New OracleParameter ("fault_id", oracletype.number);
Param [3] = New OracleParameter ("OperateDate", ORACLETYPE.DATETIME);
Param [4] = New OracleParameter ("Operateuser", Oracletype.varchar, 20);
Param [5] = New OracleParameter ("TriaLinfo_ID", ORACLETYPE.NUMBER);
OracleHelper.cacheParameter (Create, Param);
}
PARAM [0] .value = this.descrption == null? string.empty: this.descrption;
Param [1] .value = this.dispose == NULL? String.empty: this.dispose;
Param [2] .value = this.fault_id;
Param [3] .value = this.oprate;
Param [4] .value = this.operateuser == NULL? String.empty: this.operateuser;
Param [5] .value = this.trialInfo_id;
OracleHelper.executenonQuery (Transaction, CommandType.Text, Create, Param);
}
Public void delete ()
{
OracleConnection Connection = New OracleConnection (ConfigInfo.getConnection ";
Connection.open ();
OracleTransaction Transaction = Connection.Begintractions; Try
{
THIS.DELETE (Transaction);
Transaction.commit ();
}
Catch (Exception EX)
{
Transaction.rollback ();
Throw EX;
}
Finally
{
Connection.Close ();
}
}
Internal Void Delete (OracleTransaction Transaction)
{
String delete = "delete datfault where fail_id =: fault_id";
OracleParameter [] Param = OracleHelper.getCacheParameter (delete);
IF (param == NULL)
{
Param = New OracleParameter [1];
Param [0] = New OracleParameter ("Fault_ID", ORACletype.Number);
OracleHelper.cacheParameter (Delete, Param);
}
Param [0] .value = this.fault_id;
OracleHelper.executenonQuery (Transaction, CommandType.Text, Delete, Param);
}
Public void read ()
{
String read = "SELECT Descrption, Dispose, Fault_ID, OPERATEDATE, OPERATEUSER, TRIALINFO_ID from Datfault where fault_id =: fault_id";
OracleParameter [] Param = OracleHelper.getCacheParameter (Read);
IF (param == NULL)
{
Param = New OracleParameter [1];
Param [0] = New OracleParameter ("Fault_ID", ORACletype.Number);
OracleHelper.cacheParameter (Read, Param);
}
Param [0] .value = this.fault_id;
Using (OracleDataReader Dr = OracleHelper.executeReader (), CommandType.Text, Read, PARAM)
{
IF (Dr.Read () == false)
Return;
IF (! Dr.Indbnull (0))
this.descrption = Dr.getstring (0);
IF (! Dr.isdbnull (1))
THIS.DISPOSE = Dr.getstring (1);
IF (! Dr.isdbnull (2))
THIS.FAULT_ID = Dr.GetDecimal (2);
IF (! Dr.isdbnull (3))
this.operatedate = Dr.GetDateTime (3);
IF (! Dr.isdbnull (4))
THIS.OPERATEUSER = Dr.getstring (4);
IF (! Dr.isdbnull (5))
THIS.TRIALINFO_ID = Dr.GetDecimal (5);
}
}
Public static dataable selectalldatfauLtentity () {
String selectalldatfaultentity = "Select Descrption, Dispose, Fault_ID, OperateDate, Operateuser, TriaLinfo_id from Datfault";
Return OracleHelper.executedataTable (ConfigInfo.getConnectionstring (), CommandType.Text, SelectAllDatfauLtentity;
}
Public void update ()
{
OracleConnection Connection = New OracleConnection (ConfigInfo.getConnection ";
Connection.open ();
OracleTransaction Transaction = Connection.Begintractions (isolationledLevel.Readcommitted);
Try
{
THIS.UPDATE (Transaction);
Transaction.commit ();
}
Catch (Exception EX)
{
Transaction.rollback ();
Throw EX;
}
Finally
{
Connection.Close ();
}
}
Internal Void Update (OracleTransaction Transaction)
{
string UPDATE = "update DATFAULT set DESCRPTION =: DESCRPTION, DISPOSE =: DISPOSE, FAULT_ID =: FAULT_ID, OPERATEDATE =: OPERATEDATE, OPERATEUSER =: OPERATEUSER, TRIALINFO_ID =: TRIALINFO_ID where FAULT_ID =: FAULT_ID";
OracleParameter [] Param = OracleHelper.getCacheParameter (Update);
IF (param == NULL)
{
Param = New OracleParameter [7];
Param [0] = New OracleParameter ("Descrption", Oracletype.varchar, 4000);
Param [1] = New OracleParameter ("Dispose", ORACletype.varchar, 4000);
Param [2] = New OracleParameter ("fault_id", oracletype.number);
Param [3] = New OracleParameter ("OperateDate", ORACLETYPE.DATETIME);
Param [4] = New OracleParameter ("Operateuser", Oracletype.varchar, 20);
Param [5] = New OracleParameter ("TriaLinfo_ID", ORACLETYPE.NUMBER);
Param [6] = New OracleParameter ("fault_id", oracletype.number);
OracleHelper.cacheParameter (Update, Param);
}
PARAM [0] .value = this.descrption == null? string.empty: this.descrption; param [1] .value = this.dispose == null? string.empty: this.dispose;
Param [2] .value = this.fault_id;
Param [3] .value = this.oprate;
Param [4] .value = this.operateuser == NULL? String.empty: this.operateuser;
Param [5] .value = this.trialInfo_id;
Param [6] .value = this.fault_id;
OracleHelper.executenonQuery (configinfo.getConnectionstring (), CommandType.Text, Update, Param;
}
}
}
