4层,也就是数据库影射出3个层+1个界面层
用一个用户表的的例子如
using System;
using System.Data;
using JianCai.Model;
namespace JianCai.BLL
{
/// <summary>
/// 业务逻辑类Users 的摘要说明。
/// </summary>
public class Users
{
private readonly JianCai.SQLServerDAL.Users dal = new JianCai.SQLServerDAL.Users();
public Users()
{ }
...........
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
namespace JianCai.SQLServerDAL
{
/// <summary>
/// 数据访问类Users。
/// </summary>
public class Users
{
public Users()
{ }
#region 成员方法
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return DbHelperSQL.GetMaxID("UserID", "Users");
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from Users");
strSql.Append(" where UserID= @UserID");
SqlParameter[] parameters = {
new SqlParameter("@UserID", SqlDbType.Int,4)
};
parameters[0].Value = UserID;
return DbHelperSQL.Exists(strSql.ToString(), parameters);
}
#region 成员方法
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return dal.GetMaxId();
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int UserID)
{
return dal.Exists(UserID);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JianCai.Model.Users model)
{
return dal.Add(model);
}
---namespace JianCai.Model
{
/// <summary>
/// 实体类Users 。(属性说明自动提取数据库字段的描述信息)
/// </summary>
public class Users
{
public Users()
{ }
#region Model
private int _userid;
private int _usertype;
private string _username;
private string _userpwd;
private string _question;
private string _answer;
private string _email;
private DateTime _lastlog;
private decimal _integral;
private string _realname;
private string _introduction;
private int _sex;
private string _photo;
private string _city;
private string _qq;
private string _mobil--------------
--------------------------------------------------------
http://www.cnblogs.com/pyt5208/archive/2006/11/17/563524.html
------------------------
比较经典
--------------------------------------------------------
其中上面三个数据库映射出来的是model(实体层) .DAL类 .BLL类 就是业务和逻辑层
再加上界面就是四层
用一个用户表的的例子如
using System;
using System.Data;
using JianCai.Model;
namespace JianCai.BLL
{
/// <summary>
/// 业务逻辑类Users 的摘要说明。
/// </summary>
public class Users
{
private readonly JianCai.SQLServerDAL.Users dal = new JianCai.SQLServerDAL.Users();
public Users()
{ }
...........
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
namespace JianCai.SQLServerDAL
{
/// <summary>
/// 数据访问类Users。
/// </summary>
public class Users
{
public Users()
{ }
#region 成员方法
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return DbHelperSQL.GetMaxID("UserID", "Users");
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from Users");
strSql.Append(" where UserID= @UserID");
SqlParameter[] parameters = {
new SqlParameter("@UserID", SqlDbType.Int,4)
};
parameters[0].Value = UserID;
return DbHelperSQL.Exists(strSql.ToString(), parameters);
}
#region 成员方法
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return dal.GetMaxId();
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int UserID)
{
return dal.Exists(UserID);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JianCai.Model.Users model)
{
return dal.Add(model);
}
---namespace JianCai.Model
{
/// <summary>
/// 实体类Users 。(属性说明自动提取数据库字段的描述信息)
/// </summary>
public class Users
{
public Users()
{ }
#region Model
private int _userid;
private int _usertype;
private string _username;
private string _userpwd;
private string _question;
private string _answer;
private string _email;
private DateTime _lastlog;
private decimal _integral;
private string _realname;
private string _introduction;
private int _sex;
private string _photo;
private string _city;
private string _qq;
private string _mobil--------------
--------------------------------------------------------
http://www.cnblogs.com/pyt5208/archive/2006/11/17/563524.html
------------------------
比较经典
--------------------------------------------------------
其中上面三个数据库映射出来的是model(实体层) .DAL类 .BLL类 就是业务和逻辑层
再加上界面就是四层