C#数据访问层

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

namespace ClothLib.Common
{
 public class DataBaseOperate:IDisposable
 {
  // 保存数据库连接字符串
  private string m_sConnectionString;
  
  // 数据库连接标志
  private bool m_bConnected;
  
  // 存储过程开启标志
  private bool m_bTransaction;
  
  
  //数据库连接对象
  private SqlConnection m_sqlConnection;
  private SqlCommand m_sqlCommand;
  private SqlTransaction m_sqlTransaction;
  private SqlDataAdapter m_sqlDataAdapter;
  
  /// <summary>
  /// 构造函数，初始化内部变量
  /// </summary>
  public DataBaseOperate()
   :this("Integrated Security=SSPI;server=.;database=Wear")
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }
  
  public DataBaseOperate(
   string sConnectionString)
  {
   if (sConnectionString !&