博客园 建立中间数据访问层BusinessFacade

//=========================================

//抽象类定义

//=========================================

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

namespace BusinessFacade
{
 /// <summary>
 /// 摘要说明。
 /// </summary>
 public abstract class myClass
 {
  private static myClass _Object;
  static myClass()
  
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
   _CreateObject();
  }
  private static void _CreateObject()
  {
   _Object=new myClass1();
  }
  public static myClassInstance()
  {
   return _Object;
  }
  //添加和修改
  public abstract bool Exce_Addupdate();
  //删除
  public abstract bool Exec_Delete();
  //查询
  public abstract DataTable Get_List();
 }
}

 

//=========================================

//实例化类定义

//=========================================

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using BusinessFacade.Components;

namespace BusinessFacade
{
 /// <summary>
 /// 摘要说明
 /// </summary>
 public class myClass1:.BusinessFacade.myClass
 {
  private BllToDbWithProc _Proc;
  private string _ConnStr;
  public myClass1()
  {
   _Proc=new BllToDbWithProc();
   _ConnStr=SystemCommon.SysOpVar.ConnString;
  }
  public override bool Exce_Addupdate()
  {
   try{
    SqlParameter[] vParams={
             new SqlParameter("@BJH_XTBM",SqlDbType.Char,10),
                                                                                         };
    vParams[0].Value = sBJH_XTBM;
    
     _Proc.ExecNonReturnProc(_ConnStr,"AddTBB_GZJH",vParams);    
      return true;
   }
   catch{return false;}
  }
  public override bool Exec_Delete()
  {
    try{

     SqlParameter[] vParams={
              new SqlParameter("@BJH_XTBM",SqlDbType.Char,10)
                        
             };
     vParams[0].Value =sBJH_XTBM;
     _Proc.ExecNonReturnProc(_ConnStr,"DeleteTBB_GZJH",vParams);
     
     return true;
    
    }
    catch{return false;}
  }
  public override DataTable Get_Tzbgzjh_List()
  {
    try{
     SqlParameter[] vParams = {
             new SqlParameter("@TJGXTBM",SqlDbType.VarChar,10)           
            };
     vParams[0].Value =sTJGXTBM;  
  
    return _Proc.ExeDataSetProcWithPar(_ConnStr,"Select * From TableName Where JGXTBM=@TJGXTBM",vParams).Tables[0];
    
    
    }

    catch{return null;}
  }

 }
}