崔翔老师给了我们讲解了三层构架的例子,是用一个酒店里面的
服务员 UI层
大厨 business logic layer 业务逻辑层
采购员 Data Access Layer数据访问层
三个层之间生产顺序:项目生产顺序:DAL BLL WEBUI
在DAL有SQLHelp类里面有
using System; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace DAL { public class SQLHelp { private string dbStr = ConfigurationSettings.AppSettings["DBStr"]; /// <summary> /// 根据SQL语句填充数据表 /// </summary> /// <param name="sqlQuery">SQL语句</param> /// <returns>填充的数据表</returns> public DataTable FillTable(string sqlQuery) { using (SqlConnection cn = new SqlConnection(dbStr)) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(sqlQuery, cn); try { da.Fill(dt); return dt; } catch (Exception) { return null; } finally { dt.Dispose(); da.Dispose(); } } } } }
这个类帮助连接数据库。
再新建一个类,那个类里面有就是DepartmentDAL,这个类返回一个DataTable类
using System; using System.Data; namespace DAL { public class DepartmentDAL { public DataTable GetDepartment() { SQLHelp db = new SQLHelp(); return db.FillTable("select * from Dep"); } //public string InsertDepartment(){} //public string UpdateDepartment(){} //public string DeleteDepartment(){} } }
再添加一个类库就是BLL层了。
BLL层里面有DepartmentBLL类
using System; using System.Data; namespace BLL { public class DepartmentBLL { public DataTable GetDepartment() { DAL.DepartmentDAL depDAL = new DAL.DepartmentDAL(); return depDAL.GetDepartment(); } //public string InsertDepartment(){} //public string UpdateDepartment(){} //public string DeleteDepartment(){} } }
在下面就是接口层,就是UI层了
using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; namespace WebUI { public partial class DepartmentList : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) BindGrid(); } private void BindGrid() { BLL.DepartmentBLL depBLL = new BLL.DepartmentBLL(); dgdShowData.DataSource = depBLL.GetDepartment(); dgdShowData.DataBind(); } }
以上就是今天完成的工作了。
总结:有王中军在影响我,写的博文不是很好。通过这次的学习对三层构架有了进一步的了解