/// <summary> /// 获取管理员 /// </summary> /// <returns></returns> public Admin SelectAdmin(string userName,string password) { Admin admin = new Admin(); string sql = "select * from Admin where Admin_Name=@Admin_Name and Admin_PassWord=@Admin_Password"; SqlParameter[] parms = new SqlParameter[2]; parms[0] = new SqlParameter("@Admin_Name", SqlDbType.VarChar, 50); parms[0].Value = userName; parms[1] = new SqlParameter("@Admin_Password", SqlDbType.VarChar, 150); parms[1].Value = password; DataTable dt = DataMake.DataTableRead(sql,parms); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { admin.Id = int.Parse(dt.Rows[i][0].ToString()); admin.AdminName = dt.Rows[i][1].ToString(); admin.AdminPassword = dt.Rows[i][2].ToString(); admin.AdminRemark = dt.Rows[i][3].ToString(); } } return admin; }
/// <summary> /// 获取所有管理员 /// </summary> /// <returns></returns> public List<Admin> SelectAdmins() { List<Admin> list = new List<Admin>(); Admin admin = new Admin(); string sql = "select * from Admin"; DataTable dt = DataMake.DataTableRead(sql); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { admin.Id = int.Parse(dt.Rows[i][0].ToString()); admin.AdminName = dt.Rows[i][1].ToString(); admin.AdminPassword = dt.Rows[i][2].ToString(); admin.AdminRemark = dt.Rows[i][3].ToString(); list.Add(admin); } } return list; }