先说数据访问层:就是sql中增删改查的方法
DAL----->DB.cs
namespace DAL
{ public class DB
{ SqlHelper helper = new SqlHelper();
public DataTable GetAll()
{ string strsql = "select * from users";
SqlCommand cmd = helper.GetCommand(strsql, null);
DataTable dt = new DataTable();
using(SqlDataReader rdr=cmd.ExecuteReader())
{ dt.Load(rdr);}
return dt;
}
public DataTable GetByModel(UserInfo model)
{ SqlHelper helper = new SqlHelper();
string strsql = "select * from users where id=@id";
SqlParameter[] parm = new SqlParameter[]
{new SqlParameter("@id",model.ID)};
SqlCommand cmd = helper.GetCommand(strsql, parm);
DataTable dt = new DataTable();
using (SqlDataReader rdr = cmd.ExecuteReader())
{dt.Load(rdr);}
return dt;
}
}
}
业务逻辑层:
BBL------->userBBL.cs 调用db.cs中的方法 它自己也是个方法
namespace BBL
{ public class UserBBL
{ DB db = new DB();
UserInfo ui = new UserInfo();
public DataTable ALL(UserInfo model)
{ if (model != null)
{ return db.GetByModel(model); }
else
{ return db.GetAll(); }
}
}
}