建立中间数据访问层BusinessFacade

来源：互联网发布：怎么去看网络主播视频编辑：程序博客网时间：2024/06/05 16:54

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

//抽象类定义

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

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;}
}

}
}