.net简单的三层实现功能(15)

33             foreach (DataRow dr in dt.Rows)
34             {
35                 LoginModel login = new LoginModel();
36                 login.AdminUID = dr["AdminUID"].ToString();
37                 login.AdminPWD = dr["AdminPWD"].ToString();
38                 list.Add(login);
39             }
40             return list;
41         }

4.创建BLL层，主要是针对具体的问题的操作，也可以理解成对数据层的操作,对数据业务逻辑处理
  View Code
 1  public static bool Add(LoginModel user)
 2         {
 3             return DAL.LoginDAL.Add(user);
 4         }
 5         public static bool Delete(int UserID)
 6         {
 7             return DAL.LoginDAL.Delete(UserID);
 8         }
 9         public static bool Modify(LoginModel user)
10         {
11             return DAL.LoginDAL.Modelfy(user);
12         }
13         public static List<LoginModel> GetAllUsers()
14         {
15             return DAL.LoginDAL.GetAllUser();
16         }

5.显示数据到页面，后台CS代码
  View Code
 1    public SqlCommand com;
 2
 3         protected void Page_Load(object sender, EventArgs e)
 4         {
 5             SqlConnection sql = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=ThreeLayer");
 6             string selSQL = "select AdminUID,AdminPWD,AdminId ,isExits from admin";