/// <summary> /// 修改管理员信息 /// </summary> /// <param name="Name"></param> /// <param name="JobId"></param> /// <param name="College"></param> /// <param name="Mail"></param> /// <param name="Phone"></param> /// <param name="Sex"></param> /// <param name="UserID"></param> /// <returns></returns> public static int UpdateAdminModel(string Id, string Name, string JobId, string College, string Mail, string Phone, string Sex, string UserID) { #region 输入合法性检测 int id = 0; int userId = 0; if (string.IsNullOrEmpty(Name) || string.IsNullOrEmpty(Sex) || string.IsNullOrEmpty(JobId) || string.IsNullOrEmpty(Phone) || string.IsNullOrEmpty(College) || string.IsNullOrEmpty(Mail) || string.IsNullOrEmpty(UserID)) { return(0); } try { id = Convert.ToInt32(Id); userId = Convert.ToInt32(UserID); } catch { return(0); } #endregion #region 把输入组装成类的实例 Models.DB.AdminModel admin = new Models.DB.AdminModel(); admin.Id = id; admin.Name = Name; admin.JobId = JobId; admin.College = College; admin.Mail = Mail; admin.Phone = Phone; admin.Sex = Sex; admin.UserId = userId; #endregion return(DAL.Update.ChangeSome(admin, "Id")); }
public static Models.DB.AdminModel SelectAdminModelByUserID(String UserID) { int userid; try { userid = Convert.ToInt32(UserID); } catch { return(null); } Models.DB.AdminModel Admin = null; System.Data.DataTable dt = DAL.Select.QueryOne(userid, "Tb_AdminModel", "UserId"); if (dt.Rows.Count > 0) { Admin = new Models.DB.AdminModel(); Admin.Id = Convert.ToInt32(dt.Rows[0]["Id"]); Admin.Name = dt.Rows[0]["Name"].ToString(); Admin.JobId = dt.Rows[0]["JobID"].ToString(); Admin.College = dt.Rows[0]["College"].ToString(); Admin.Mail = dt.Rows[0]["Mail"].ToString(); Admin.Phone = dt.Rows[0]["Phone"].ToString(); Admin.Sex = dt.Rows[0]["Sex"].ToString(); Admin.UserId = Convert.ToInt32(dt.Rows[0]["UserID"]); } return(Admin); }
/// <summary> /// 根据学院选择一页记录 /// </summary> /// <param name="Page"></param> /// <param name="PageSize"></param> /// <returns></returns> public static List <Models.DB.AdminModel> SelectOnePage(int Page, int PageSize, String College) { if (String.IsNullOrEmpty(College)) { return(null); } List <Models.DB.AdminModel> Admins = new List <Models.DB.AdminModel>(); Models.DB.AdminModel Admin; System.Data.DataTable dt = DAL.Select.SearchByCollege("Tb_AdminModel", PageSize, Page, "Id", "", College); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Admin = new Models.DB.AdminModel(); Admin.Id = Convert.ToInt32(dt.Rows[i]["Id"]); Admin.Name = dt.Rows[i]["Name"].ToString(); Admin.JobId = dt.Rows[i]["JobID"].ToString(); Admin.College = dt.Rows[i]["College"].ToString(); Admin.Mail = dt.Rows[i]["Mail"].ToString(); Admin.Phone = dt.Rows[i]["Phone"].ToString(); Admin.Sex = dt.Rows[i]["Sex"].ToString(); Admin.UserId = Convert.ToInt32(dt.Rows[i]["UserID"]); Admins.Add(Admin); } } return(Admins); }
/// <summary> /// 插入管理员基本信息 /// </summary> public static int CreateAdminModel(string Name, string JobId, string College, string Mail, string Phone, string Sex, int UserID) { #region 输入合法性检测 if (string.IsNullOrEmpty(Name) || string.IsNullOrEmpty(Sex) || string.IsNullOrEmpty(JobId) || string.IsNullOrEmpty(Phone) || string.IsNullOrEmpty(College) || string.IsNullOrEmpty(Mail)) { return(0); } if (Name.Length > 255 || Sex.Length > 255 || JobId.Length > 255 || Phone.Length > 255 || College.Length > 255 || Mail.Length > 255) { return(0); } #endregion #region 把输入组装成类的实例 Models.DB.AdminModel admin = new Models.DB.AdminModel(); admin.Name = Name; admin.JobId = JobId; admin.College = College; admin.Mail = Mail; admin.Phone = Phone; admin.Sex = Sex; admin.UserId = UserID; #endregion return(DAL.Create.CreateOne(admin)); }
private void accessControl() { if (Session["user"] == null || Session["role"] == null) { Response.Redirect(ResolveUrl("~/Web/Login/Default.aspx")); } String UserID = Session["user"].ToString(); String RoleID = Session["role"].ToString(); LoginRole = BLL.Role.SelectRoleOne(Convert.ToInt32(RoleID)); LoginAdmin = BLL.AdminModel.SelectAdminModelByUserID(UserID); }
/// <summary> /// 根据Id选择一条记录 /// </summary> /// <param name="Id"></param> /// <returns></returns> public static Models.DB.AdminModel SelectAdminModelOne(int Id) { Models.DB.AdminModel Admin = null; System.Data.DataTable dt = DAL.Select.GetOne("Tb_AdminModel", Id); if (dt.Rows.Count > 0) { Admin = new Models.DB.AdminModel(); Admin.Id = Convert.ToInt32(dt.Rows[0]["Id"]); Admin.Name = dt.Rows[0]["Name"].ToString(); Admin.JobId = dt.Rows[0]["JobID"].ToString(); Admin.College = dt.Rows[0]["College"].ToString(); Admin.Mail = dt.Rows[0]["Mail"].ToString(); Admin.Phone = dt.Rows[0]["Phone"].ToString(); Admin.Sex = dt.Rows[0]["Sex"].ToString(); Admin.UserId = Convert.ToInt32(dt.Rows[0]["UserID"]); } return(Admin); }
protected void Page_Load(object sender, EventArgs e) { accessControl(); if (Request["edit"] == null) { Response.Redirect("Default.aspx"); return; } try { int Id = Convert.ToInt32(Request["edit"]); Admin = BLL.AdminModel.SelectAdminModelOne(Id); user = BLL.User.SelectUserOne(Admin.UserId); Role = BLL.Role.SelectRoleOne(user.RoleId); initRoles(); } catch { Response.Redirect("Default.aspx"); } }