珠海南方三层构架第一天

    技术2022-05-13  2

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

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

     

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

     

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

     


    最新回复(0)