融合CURD的类的设计方式

在学习.net的早期，设计类时习惯把CRUD的方法也写到类中，后来考虑到这样的写法不方便扩展，特别当数据库类型移植时要做很多的工作，但是还是把他写出来。

using System;
using System.Data;
using System.Data.OracleClient;
using Fjeptri.DataAccess.DataHelper;

namespace oilManage
{
    public class DatfaultEntity
    {
        public DatfaultEntity()
        {
        }
        public DatfaultEntity(string descrption,string dispose,decimal fault_id,DateTime operatedate,string operateuser,decimal trialinfo_id)
        {
            this.Descrption=descrption;
            this.Dispose=dispose;
            this.Fault_id=fault_id;
            this.Operatedate=operatedate;
            this.Operateuser=operateuser;
            this.Trialinfo_id=trialinfo_id;
        }
        public DatfaultEntity(DatfaultPK datfaultPK)
        {
            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 mOperatedate;
        public DateTime Operatedate
        {
            get{ return mOperatedate ;}
            set{ mOperatedate=value ;}
        }
        private string mOperateuser;
        public string Operateuser
        {
            get{ return mOperateuser ;}
            set{ mOperateuser=value ;}
        }
        private decimal mTrialinfo_id;
        public decimal Trialinfo_id
        {
            get{ return mTrialinfo_id ;}
            set{ mTrialinfo_id=value ;}
        }
        private DatfaultPK datfaultPK;
        public DatfaultPK PK
        {
            get
            {
                return new DatfaultPK(this.Fault_id);
            }
            set
            {
                this.Fault_id=value.Fault_id;
            }
        }
        public void Create()
        {
            OracleConnection connection=new OracleConnection(ConfigInfo.GetConnectionString());
            connection.Open();
            OracleTransaction transaction=connection.BeginTransaction(IsolationLevel.ReadCommitted);
            try
            {
                this.Create(transaction);
                transaction.Commit();
            }
            catch(Exception ex)
            {
                transaction.Rollback();
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }
        internal void Create(OracleTransaction transaction)
        {
            string CREATE="insert into DATFAULT(DESCRPTION,DISPOSE,FAULT_ID,OPERATEDATE,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.Operatedate;
            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.GetConnectionString());
            connection.Open();
            OracleTransaction transaction=connection.BeginTransaction(IsolationLevel.ReadCommitted);
            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 FAULT_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(ConfigInfo.GetConnectionString(),CommandType.Text,READ,param))
            {
                if(dr.Read()==false)
                    return;
                if(!dr.IsDBNull(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 DataTable 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.GetConnectionString());
            connection.Open();
            OracleTransaction transaction=connection.BeginTransaction(IsolationLevel.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.Operatedate;
            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);
        }
    }
}