珠海南方三层构架第一天

崔翔老师给了我们讲解了三层构架的例子，是用一个酒店里面的

服务员 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(); } } 

 

以上就是今天完成的工作了。

 

总结：有王中军在影响我，写的博文不是很好。通过这次的学习对三层构架有了进一步的了解