/// <summary> /// 返回单个对象 /// </summary> /// <param name="id"></param> /// <returns></returns> public T_AdminUser GetModel(int id) { T_AdminUser model = null; string strSql = string.Format("SELECT [Id],[AdminLogName],[AdminLogPass],[AdminName],[AdminTel],[UnitCode],[AdminType],[AdminState],[AdminLogNum],[IsCheck],[Editor],[CreateDate],[EndDate],roleid FROM [T_AdminUser] where Id = {0}", id); using (dynamic read = DbHelper.Factory().ExecuteReader(strSql)) { if (read.Read()) { model = new T_AdminUser(); model.Id = int.Parse(read["Id"].ToString()); model.AdminLogName = read["AdminLogName"].ToString(); model.AdminLogPass = read["AdminLogPass"].ToString(); model.AdminName = read["AdminName"].ToString(); model.AdminTel = read["AdminTel"].ToString(); model.UnitCode = read["UnitCode"].ToString(); model.AdminType = int.Parse(read["AdminType"].ToString()); model.AdminState = int.Parse(read["AdminState"].ToString()); model.AdminLogNum = int.Parse(read["AdminLogNum"].ToString()); model.IsCheck = int.Parse(read["IsCheck"].ToString()); model.Editor = read["Editor"].ToString(); model.CreateDate = DateTime.Parse(read["CreateDate"].ToString()); model.EndDate = DateTime.Parse(read["EndDate"].ToString()); model.Roleid = read["roleid"].ToString(); } read.Dispose(); } return(model); }
// public string ProcessRequest(HttpContext context) { try { adminUser = context.Session["SuperAdminUser"] as T_AdminUser; } catch { } string action = context.Request.QueryString["action"].ToString(); string returnDate; switch (action) { case "fun": returnDate = GetSysFun(); break; case "aname": returnDate = GetAdminUserName(); break; case "emp": returnDate = GetEliminateUserSession(context); break; default: returnDate = "请求错误!"; break; } return(returnDate); }
/// <summary> /// 保存用户信息 /// </summary> /// <param name="user"></param> public int SaveAccountInfo(T_AdminUser user, string newPwz) { if (user.id.Equals(Guid.Empty)) { user.id = Guid.NewGuid(); using (var dbContext = new IPathDBEntities()) { user.Pwz = AESHelper.Encrypt(user.Pwz); dbContext.T_AdminUser.Add(user); return(dbContext.SaveChanges()); } } else { using (var dbContext = new IPathDBEntities()) { dbContext.T_AdminUser.Attach(user); dbContext.Entry(user).Property("UserName").IsModified = true; dbContext.Entry(user).Property("PermissionInfo").IsModified = true; if (!string.IsNullOrEmpty(newPwz)) { user.Pwz = AESHelper.Encrypt(newPwz); dbContext.Entry(user).Property("Pwz").IsModified = true; } dbContext.Configuration.ValidateOnSaveEnabled = false; return(dbContext.SaveChanges()); } } }
public string ProcessRequest(HttpContext context) { try { admin = context.Session["SuperAdminUser"] as T_AdminUser; } catch { } string action = context.Request.QueryString["action"].ToString(); string returnDate; switch (action) { case "paging": string str = "\"total\":" + CountNum(context) + ","; returnDate = JsonHelper <T_News, int> .JsonDataTable(GetAllList(context), "rows").Insert(1, (str)); break; case "del": returnDate = Delete(context); break; case "add": returnDate = Create(context); break; case "up": returnDate = Update(context); break; case "top": returnDate = JsonHelper <T_News, int> .JsonDataTable(GetTopPageShow(context)); break; case "Home": returnDate = JsonHelper <T_News, int> .JsonDataTable(GetHomeList(context)); break; case "HomeCount": returnDate = HomeCount(context); break; case "Id": returnDate = JsonHelper <T_News, int> .JsonWriter(GetById(context)); break; case "rs": returnDate = RowsState(context); break; default: returnDate = null; break; } return(returnDate); }
public string ProcessRequest(HttpContext context) { try { admin = context.Session["SuperAdminUser"] as T_AdminUser; } catch { } string action = context.Request.QueryString["action"].ToString(); string returnDate; switch (action) { case "paging": returnDate = JsonHelper <T_NewsType, int> .JsonDataTable(GetAllList(context), "rows"); break; case "tree": returnDate = GetTree(); break; case "node": returnDate = AddNodes(context); break; case "list": returnDate = GetAllList(); break; case "add": returnDate = Create(context); break; case "up": returnDate = Update(context); break; case "del": returnDate = Delete(context); break; case "id": returnDate = JsonHelper <T_NewsType, int> .JsonWriter(GetById(context)); break; case "upid": string UpId = context.Request.QueryString["UpId"]; string order = " order by TypeLevel"; returnDate = GetAllList(UpId, order); break; default: returnDate = null; break; } return(returnDate); }
protected void btn_login_Click(object sender, EventArgs e) { string checkCode = Session["CheckCode"] as string; string checkCodeImg = txt_CheckCodeImg.Text; if (checkCode != null) { if (checkCode.ToLower().Equals(checkCodeImg.ToLower())) { if (txt_AdminLogName.Text.Trim() != "" || txt_AdminLogPass.Text.Trim() != "") { T_AdminUserBll adminUserBll = new T_AdminUserBll(); T_AdminUser AdminUser = adminUserBll.AdminUserLogin(txt_AdminLogName.Text.Trim(), txt_AdminLogPass.Text.Trim()); if (AdminUser.AdminLogName.Equals(txt_AdminLogName.Text.Trim()) || AdminUser.AdminLogPass.Equals(txt_AdminLogPass.Text.Trim())) { if (AdminUser.AdminState != 0) { AddCookie(AdminUser.Id); adminUserBll.NumberLogin(AdminUser.Id); Session["SuperAdminUser"] = AdminUser; Session["AdminState"] = AdminUser.AdminState; // Session["unitcode"] = AdminUser.UnitCode; new T_SysLogBll().Create("登陆", "成功", ComFunction.GetClientIP(), txt_AdminLogName.Text, ComFunction.GetHostName()); Response.Redirect("Main.aspx"); } else { showMessage("管理员账户信息处于禁用状态,请联系上级部门!"); } } else { showMessage("用户登录失败!请检查用户名和密码是否正确?"); new T_SysLogBll().Create("登陆", "失败", ComFunction.GetClientIP(), txt_AdminLogName.Text, ComFunction.GetHostName()); } } else { showMessage("用户名和密码不能为空!"); } } else { showMessage("验证码错误,请重新输入验证码!"); } } else { showMessage("登录超时请刷新页面重新登录!"); } }
/// <summary> /// 更新操作 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(T_AdminUser model) { object[] obj = { model.AdminLogName, model.AdminLogPass, model.AdminName, model.AdminTel, model.UnitCode, model.AdminType, model.AdminState, model.AdminLogNum, model.IsCheck, model.Editor, model.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"), model.EndDate.ToString("yyyy-MM-dd HH:mm:ss"), model.Id, model.Roleid }; string strSql = string.Format(" update T_AdminUser set AdminLogName='{0}',AdminLogPass='******',AdminName='{2}',AdminTel='{3}',UnitCode='{4}',AdminType={5},AdminState={6},AdminLogNum={7},IsCheck={8},Editor='{9}',CreateDate='{10}',EndDate='{11}',roleid='{13}' where Id={12}", obj); if (DbHelper.Factory().ExecuteNonQuery(strSql) > 0) { return(true); } else { return(false); } }
/// <summary> /// 添加操作 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Create(T_AdminUser model) { object[] obj = { model.AdminLogName, model.AdminLogPass, model.AdminName, model.AdminTel, model.UnitCode, model.AdminType, model.AdminState, model.AdminLogNum, model.IsCheck, model.Editor, model.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"), model.EndDate.ToString("yyyy-MM-dd HH:mm:ss"), model.Roleid }; string strSql = string.Format("insert into [T_AdminUser]([AdminLogName],[AdminLogPass],[AdminName],[AdminTel],[UnitCode],[AdminType],[AdminState],[AdminLogNum],[IsCheck],[Editor],[CreateDate],[EndDate],roleid) values ('{0}','{1}','{2}','{3}','{4}',{5},{6},{7},{8},'{9}','{10}','{11}','{12}')", obj); if (DbHelper.Factory().ExecuteNonQuery(strSql) > 0) { return(true); } else { return(false); } }
public string ProcessRequest(HttpContext context) { try { admin = context.Session["SuperAdminUser"] as T_AdminUser; } catch { } string action = context.Request.QueryString["action"].ToString(); string returnDate; switch (action) { case "paging": returnDate = JsonHelper <T_SysFun, int> .JsonDataTable(GetAllList(context), "rows"); break; case "del": returnDate = Delete(context); break; case "add": returnDate = Create(context); break; case "up": returnDate = Update(context); break; case "id": returnDate = JsonHelper <T_SysFun, int> .JsonWriter(GetById(context)); break; case "parent": returnDate = ParentNode(); break; case "tree": returnDate = GetTree(context); break; case "node": returnDate = AddNode(context); break; default: returnDate = null; break; } return(returnDate); }
/// <summary> /// 根据id删除用户 /// </summary> /// <param name="id"></param> /// <returns></returns> public int Remove(string id) { Guid _id = new Guid(id); using (var dbContext = new IPathDBEntities()) { var entity = new T_AdminUser() { id = _id }; dbContext.T_AdminUser.Attach(entity); dbContext.Entry(entity).State = System.Data.Entity.EntityState.Deleted; return(dbContext.SaveChanges()); } }
public string ProcessRequest(HttpContext context) { try { admin = context.Session["SuperAdminUser"] as T_AdminUser; } catch { } string action = context.Request.QueryString["action"].ToString(); string returnDate; switch (action) { case "list": returnDate = GetAllList(); break; case "node": returnDate = AddNodes(context); break; case "easycom": returnDate = GetLongList(); break; case "orglist": returnDate = GetOrglist(context); break; case "add": returnDate = Create(context); break; case "edit": returnDate = Edit(context); break; case "id": returnDate = JsonHelper <T_Organization, int> .JsonWriter(GetById(context)); break; case "del": returnDate = Del(context); break; default: returnDate = null; break; } return(returnDate); }
public string ProcessRequest(HttpContext context) { try { admin = context.Session["SuperAdminUser"] as T_AdminUser; } catch { } string action = context.Request.QueryString["action"].ToString(); string returnDate; switch (action) { case "paging": returnDate = JsonHelper <Model.T_role, int> .JsonDataTable(GetAllList(context), "rows"); break; case "del": returnDate = Delete(context); break; case "add": returnDate = Create(context); break; case "up": returnDate = Update(context); break; case "Id": returnDate = JsonHelper <Model.T_role, int> .JsonWriter(GetById(context)); break; case "roleid": returnDate = JsonHelper <T_RoleRight, int> .JsonWriter(GetById(context)); break; case "rolecombox": returnDate = GetRoleList(); break; default: returnDate = null; break; } return(returnDate); }
private string Create(T_AdminUser model) { if (admin.AdminType == dal.HighestLevel()) { if (dal.Create(model)) { return("添加管理员登录账号成功!"); } else { return("添加管理员登录账号失败,错误代码:500"); } } else { return("您没有添加管理员登录账号权限!"); } }
public string ProcessRequest(HttpContext context) { try { admin = context.Session["SuperAdminUser"] as T_AdminUser; } catch { } string action = context.Request.QueryString["action"].ToString(); string returnDate; switch (action) { case "paging": string str = "\"total\":" + CountNum(context) + ","; returnDate = JsonHelper <T_BusinessConsulting, int> .JsonDataTable(GetAllList(context), "rows").Insert(1, (str)); break; case "tousu": string strs = "\"total\":" + CountNumts(context) + ","; returnDate = JsonHelper <T_BusinessConsulting, int> .JsonDataTable(GetAllListts(context), "rows").Insert(1, (strs)); break; case "del": returnDate = Delete(context); break; case "add": returnDate = Create(GetModel(context)); break; case "up": returnDate = Update(GetModel(context)); break; case "Id": returnDate = JsonHelper <T_BusinessConsulting, int> .JsonWriter(GetById(context)); break; default: returnDate = null; break; } return(returnDate); }
/// <summary> /// 用户登录 /// </summary> /// <param name="adminLogName"></param> /// <param name="adminLogPass"></param> /// <returns></returns> public T_AdminUser AdminUserLogin(string adminLogName, string adminLogPass) { try { string strSql = string.Format("select top 1 Id,AdminLogName,AdminLogPass,AdminName,AdminTel,UnitCode,AdminType,AdminState,AdminLogNum,IsCheck,Editor,CreateDate,EndDate,roleid from T_AdminUser where AdminLogName='{0}' and AdminLogPass='******'", adminLogName, adminLogPass); T_AdminUser model = new T_AdminUser(); using (dynamic read = DbHelper.Factory().ExecuteReader(strSql)) { if (read.Read()) { model.Id = (int)read["Id"]; model.AdminLogName = read["AdminLogName"]; model.AdminLogPass = read["AdminLogPass"]; model.AdminName = read["AdminName"]; model.AdminTel = read["AdminTel"]; model.UnitCode = read["UnitCode"]; try { model.Roleid = read["roleid"]; } catch { model.Roleid = ""; } try { model.AdminType = (int)read["AdminType"]; } catch { model.AdminType = 0; } try { model.AdminState = (int)read["AdminState"]; } catch { model.AdminState = 0; } try { model.AdminLogNum = (int)read["AdminLogNum"]; } catch { model.AdminLogNum = 0; } try { model.IsCheck = (int)read["IsCheck"]; } catch { model.IsCheck = 0; } model.Editor = read["Editor"]; try { model.CreateDate = (DateTime)read["CreateDate"]; } catch { model.CreateDate = DateTime.Now; } try { model.EndDate = (DateTime)read["EndDate"]; } catch { model.EndDate = DateTime.Now; } } read.Dispose(); } return(model); } catch (Exception) { throw; } }
// private T_AdminUser GetModel(HttpContext context) { T_AdminUser model = new T_AdminUser(); try { model.Id = int.Parse(context.Request.Form["Id"].ToString()); } catch { } model.AdminLogName = context.Request.Form["AdminLogName"].ToString(); model.AdminLogPass = context.Request.Form["AdminLogPass"].ToString(); model.AdminName = context.Request.Form["AdminName"].ToString(); model.AdminTel = context.Request.Form["AdminTel"].ToString(); model.UnitCode = context.Request.Form["UnitCode"].ToString(); try { model.AdminType = new T_OrganizationDal().GetLevel(model.UnitCode); } catch { } try { model.AdminState = int.Parse(context.Request.Form["AdminState"].ToString()); } catch { } try { model.AdminLogNum = int.Parse(context.Request.Form["AdminLogNum"].ToString()); } catch { } try { model.IsCheck = int.Parse(context.Request.Form["IsCheck"].ToString()); } catch { } model.Editor = admin.AdminLogName; model.Roleid = context.Request.Form["roleid"].ToString(); return(model); }
public string ProcessRequest(HttpContext context) { try { admin = context.Session["SuperAdminUser"] as T_AdminUser; } catch { } string action = context.Request.QueryString["action"].ToString(); string returnDate; switch (action) { case "paging": returnDate = JsonHelper <T_ListedProjectType, int> .JsonDataTable(GetAllList(context), "rows"); break; case "add": returnDate = Create(context); break; case "up": returnDate = Update(context); break; case "id": returnDate = JsonHelper <T_ListedProjectType, int> .JsonWriter(GetById(context)); break; case "list": returnDate = GetAllList(); break; default: returnDate = null; break; } return(returnDate); }