OracleHelper OracleTransaction

internal void Create( transaction)
{
string CREATE="insert into DATDISCUSSION(CONTENT,DISCUSSION_ID,EDITDATE,EDITUSER,PARENT_ID,REPLAYDATE,REPLAYUSER,TITLE) values(:CONTENT,:DISCUSSION_ID,:EDITDATE,:EDITUSER,:PARENT_ID,:REPLAYDATE,:REPLAYUSER,:TITLE)";
OracleParameter[] param= OracleHelper.GetCacheParameter(CREATE);
if(param==null)
{
param=new OracleParameter[8];
param[0]=new OracleParameter("CONTENT",OracleType.VarChar,4000);
param[1]=new OracleParameter("DISCUSSION_ID",OracleType.Number);
param[2]=new OracleParameter("EDITDATE",OracleType.DateTime);
param[3]=new OracleParameter("EDITUSER",OracleType.VarChar,50);
param[4]=new OracleParameter("PARENT_ID",OracleType.Number);
param[5]=new OracleParameter("REPLAYDATE",OracleType.DateTime);
param[6]=new OracleParameter("REPLAYUSER",OracleType.VarChar,50);
param[7]=new OracleParameter("TITLE",OracleType.VarChar,100);
OracleHelper.CacheParameter(CREATE,param);
}
param[0].Value=this.Content==null?string.Empty:this.Content;
param[1].Value=this.Discussion_id;
param[2].Value=this.Editdate;
param[3].Value=this.Edituser==null?string.Empty:this.Edituser;
param[4].Value=this.Parent_id;
param[5].Value=this.Replaydate;
param[6].Value=this.Replayuser==null?string.Empty:this.Replayuser;
param[7].Value=this.Title==null?string.Empty:this.Title;
OracleHelper.ExecuteNonQuery(transaction,CommandType.Text,CREATE,param);
}

回复人：伊斯人，吾谁与归(lovelxj) 2005-4-27 8:51:42

internal void Delete( OracleTransaction transaction)
{
string DELETE="delete DATDISCUSSION where DISCUSSION_ID=:DISCUSSION_ID";
OracleParameter[] param= OracleHelper.GetCacheParameter(DELETE);
if(param==null)
{
param=new OracleParameter[1];
param[0]=new OracleParameter("DISCUSSION_ID",OracleType.Number);
OracleHelper.CacheParameter(DELETE,param);
}
param[0].Value=this.Discussion_id;
OracleHelper.ExecuteNonQuery(transaction,CommandType.Text,DELETE,param);
}

回复人：伊斯人，吾谁与归(lovelxj) 2005-4-27 8:59:28

internal void Update( OracleTransaction transaction)
{
string UPDATE="update DATDISCUSSION set CONTENT=:CONTENT,DISCUSSION_ID=:DISCUSSION_ID,EDITDATE=:EDITDATE,EDITUSER=:EDITUSER,PARENT_ID=:PARENT_ID,REPLAYDATE=:REPLAYDATE,REPLAYUSER=:REPLAYUSER,TITLE=:TITLE where DISCUSSION_ID=:DISCUSSION_ID";
OracleParameter[] param= OracleHelper.GetCacheParameter(UPDATE);
if(param==null)
{
param=new OracleParameter[9];
param[0]=new OracleParameter("CONTENT",OracleType.VarChar,4000);
param[1]=new OracleParameter("DISCUSSION_ID",OracleType.Number);
param[2]=new OracleParameter("EDITDATE",OracleType.DateTime);
param[3]=new OracleParameter("EDITUSER",OracleType.VarChar,50);
param[4]=new OracleParameter("PARENT_ID",OracleType.Number);
param[5]=new OracleParameter("REPLAYDATE",OracleType.DateTime);
param[6]=new OracleParameter("REPLAYUSER",OracleType.VarChar,50);
param[7]=new OracleParameter("TITLE",OracleType.VarChar,100);
param[8]=new OracleParameter("DISCUSSION_ID",OracleType.Number);
OracleHelper.CacheParameter(UPDATE,param);
}
param[0].Value=this.Content==null?string.Empty:this.Content;
param[1].Value=this.Discussion_id;
param[2].Value=this.Editdate;
param[3].Value=this.Edituser==null?string.Empty:this.Edituser;
param[4].Value=this.Parent_id;
param[5].Value=this.Replaydate;
param[6].Value=this.Replayuser==null?string.Empty:this.Replayuser;
param[7].Value=this.Title==null?string.Empty:this.Title;
param[8].Value=this.Discussion_id;
OracleHelper.ExecuteNonQuery(ConfigInfo.GetConnectionString(),CommandType.Text,UPDATE,param);
}

回复人：为了俺老婆，努力写程序(wh8254) 2005-4-27 9:01:27

msdn里面有！