不知所云
View(.aspx)--------->BILL(业务处理)------>DAL(数据处理)---->永久存储(数据库)
DALFactory(工厂)、IDL(接口)、Model来直接或间接的联系他们之间的关系
View(.aspx)--------->BILL(业务处理)------>DAL(数据处理)---->永久存储(数据库)
DALFactory(工厂)、IDL(接口)、Model来直接或间接的联系他们之间的关系
调试欢乐多
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using GZWeb.IDAL;
namespace yournamespace.SQLServerDAL
{
public class tb_Member:Itb_Member
{
public DataSet GetDataSet()
{
string strSql="select name as 员工姓名,sex as 性别,nPlace as 籍贯,date as 注册日期,money as 工资,photo from tb_Member";
return DbHelper.ExecuteDataSet(strSql.ToString());//取DataSet函数
}
}
}
-----------------------
IDAL using System;
using System.Data;
namespace yournamespace.IDAL
{
public interface Itb_Member
{
DataSet GetDataSet();
}
}
--------------------
using System;
using System.Reflection;
using System.Configuration;
using GZWeb.IDAL;
namespace yournamespace.DALFactory
{
private static readonly string path = System.Configuration.ConfigurationSettings.AppSettings["DAL"];
public sealed class DataAccess
{
private static readonly string path = System.Configuration.ConfigurationSettings.AppSettings["DAL"];
public static ERP.IDAL.IAccount Createtb_Member()
{
string className = path + ".Createtb_Member";
return (yournamespace.IDAL.ICreatetb_Member)Assembly.Load(path).CreateInstance(className);
}
}
}
----------------------
BILL
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using GZWeb.IDAL;
using GZWeb.DALFactory;
namespace yournamespace.BLL
{
public class tb_Member
{
private static readonly Itb_Member dal = DataAccess.Createtb_Member();
public DataSet GetDataSet()
{
return dal.GetDataSet();
}
}
}
}