//=========================================
//抽象类定义
//=========================================
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;}
}
}
}