改造后的SQL SERVER数据库访问模型及使用方法3

SqlDal.cs

在使用ado.net时使用该模型的事务的方法

 

using System;
using System.Data;
using System.Data.SqlClient;

namespace AppCode.DAL
...{
 /**//// <summary>
 /// SqlDal 的摘要说明。
 /// </summary>
 public class SqlDal
 ...{
  SqlCommand myCommand;
  SqlDataReader objDataReader=null;
  SqlDataAdapter objDataAdapter=null;
  DataSet ds=null;
  public SqlDal()
  ...{
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }

  public SqlDataReader dealDataReader(string myQuery,SqlConnection myConnection)
  ...{
   myCommand= new SqlCommand();
   myCommand.CommandText=myQuery;
   myCommand.Connection=myConnection;
   objDataReader=myCommand.ExecuteReader(CommandBehavior.CloseConnection);
   return objDataReader;
  }

  public DataSet dealDataSet(string myQuery,SqlConnection myConnection)
  ...{
   objDataAdapter=new SqlDataAdapter(myQuery,myConnection);

   ds = new DataSet();
   objDataAdapter.Fill(ds,"T_table");
   if(myConnection!=null)myConnection.Close();
   return ds;
  }

  public DataSet dealDataSet(string myQuery,SqlConnection myConnection,SqlTransaction myTrans)
  ...{
   objDataAdapter=new SqlDataAdapter();
   objDataAdapter.SelectCommand=new SqlCommand(myQuery,myConnection,myTrans);

   ds = new DataSet();
   objDataAdapter.Fill(ds,"T_table");
   //if(myConnection!=null)myConnection.Close();
   return ds;
  }

  public void dealAdapter(string myQuery,DataTable table,SqlConnection myConnection,SqlTransaction myTrans)
  ...{
   objDataAdapter=new SqlDataAdapter(myQuery,myConnection);
   SqlCommandBuilder cb=new SqlCommandBuilder(objDataAdapter);

   objDataAdapter.DeleteCommand=new SqlCommand("",myConnection,myTrans);
   objDataAdapter.InsertCommand=new SqlCommand("",myConnection,myTrans);
   objDataAdapter.UpdateCommand=new SqlCommand("",myConnection,myTrans);
   objDataAdapter.SelectCommand=new SqlCommand(myQuery,myConnection,myTrans);

   objDataAdapter.DeleteCommand=cb.GetDeleteCommand();
   objDataAdapter.InsertCommand=cb.GetInsertCommand();
   objDataAdapter.UpdateCommand=cb.GetUpdateCommand();

   objDataAdapter.Update(table);
  }
 }
}