protected void gvShow_RowCommand(object sender, GridViewCommandEventArgs e) { using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { int id = Convert.ToInt32(e.CommandArgument); T_User user = context.T_User.Where(x => x.User_ID == id).FirstOrDefault(); if (user == null) { return; } if (e.CommandName == "re") { ResetUser(user, context); } else if (e.CommandName == "state") { ResetState(user, context); } else if (e.CommandName == "up") { UpdateUser(user, context); } else if (e.CommandName == "del") { DeleteUser(user, context); } else if (e.CommandName == "set") { SetRole(user, context); } } }
private void BingRoleToDataGridview() { Expression <Func <T_Role, bool> > whereExp = null; if (!string.IsNullOrEmpty(txtSearchName.Text.Trim())) { whereExp = n => n.Role_Name.Contains(txtSearchName.Text.Trim()); } using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { if (whereExp == null) { int totalCount = context.T_Role.Count(); Pager.Data_AspNetPager(AspNetPager1, totalCount, AspNetPager1.PageSize); this.gvShow.DataSource = context.T_Role.OrderBy(x => x.Role_ID).Skip(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1)) .Take(AspNetPager1.PageSize).ToList(); this.gvShow.DataBind(); } else { int totalCount = context.T_Role.Where(whereExp).Count(); Pager.Data_AspNetPager(AspNetPager1, totalCount, AspNetPager1.PageSize); this.gvShow.DataSource = context.T_Role.Where(whereExp).OrderBy(x => x.Role_ID).Skip(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1)) .Take(AspNetPager1.PageSize).ToList(); this.gvShow.DataBind(); } } }
private void ResetState(T_Role role, DrisionDbContext context) { if (role.Role_Status == 1) { if (role.T_Users.Count > 0 || RoleFunctionManager.GetInstance().GetFunctions(role.Role_ID).Count > 0) { this.AjaxAlert("此角色已使用,不能停用!"); return; } role.Role_Status = 0; context.SaveChanges(); BingRoleToDataGridview(); this.AjaxAlert("停用角色成功!"); return; } else if (role.Role_Status == 0) { role.Role_Status = 1; context.SaveChanges(); BingRoleToDataGridview(); this.AjaxAlert("启用角色成功!"); return; } }
private void AddUser(string name) { using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { if (context.T_Role.Where(x => x.Role_Name == name).Count() != 0) { this.AjaxAlert("角色名称不能重复!"); return; } int roleId; var query = context.T_Role.OrderByDescending(x => x.Role_ID).FirstOrDefault(); if (query == null) { roleId = 1; } else { roleId = query.Role_ID + 1; } context.T_Role.Add(new T_Role() { Role_ID = roleId, Role_Name = txtName.Text.Trim(), Role_Status = Convert.ToInt32(rbtnState.SelectedValue), Role_Comment = txtRemark.Text.Trim() }); context.SaveChanges(); } BingRoleToDataGridview(); ClearControl(); this.AjaxAlert("添加角色成功!"); }
protected void gvShow_RowCommand(object sender, GridViewCommandEventArgs e) { T_Role role = null; using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { int roleId = Convert.ToInt32(e.CommandArgument); role = context.T_Role.Where(x => x.Role_ID == roleId).FirstOrDefault(); if (e.CommandName == "state") { ResetState(role, context); } else if (e.CommandName == "up") { UpdateUser(role, context); } else if (e.CommandName == "del") { DeleteUser(role, context); } else if (e.CommandName == "set") { SetRight(role, context); } } }
protected void btnOk_Click(object sender, EventArgs e) { var UserCode = this.txtUserCode.Text; var Email = this.txtEMail.Text; if (string.IsNullOrWhiteSpace(UserCode) || string.IsNullOrWhiteSpace(Email)) { this.AjaxAlert("请输入用户名和邮箱!"); return; } using (DrisionDbContext context = new DrisionDbContext()) { var User = context.T_User.FirstOrDefault(p => p.User_Code == UserCode && p.User_EMail == Email); if (User == null) { this.AjaxAlert("输入的用户名和邮箱不匹配!"); return; } string NewPwd = new Random().Next(100000, 1000000).ToString(); User.User_Password = this.Md5(NewPwd); context.SaveChanges(); //调用邮件接口 Drision.Framework.Manager.EmailManager.SendEmail(User.User_EMail, string.Empty, "密码帮助", string.Format("新密码为:{0},请重新登录!", NewPwd)); Response.Redirect("Login.aspx", false); } }
private void BindGrid() { try { using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { var list = context.T_MobileOperationErrorLog.ToList(); var result = list.OrderBy(p => p.State).ThenByDescending(p => p.CreateTime).ToList(); this.gcProcessInstance.PagerSettings.DataCount = result.Count(); //绑定 if (result.Count() > this.PageIndex * this.PageSize) { result = result.Skip(this.PageIndex * this.PageSize).Take(this.PageSize).ToList(); } else { this.PageIndex = 0; this.gcProcessInstance.PagerSettings.PageIndex = 0; result = result.Take(this.PageSize).ToList(); } gcProcessInstance.DataSource = result; gcProcessInstance.DataBind(); } } catch (ApplicationException ex) { this.AjaxAlert(ex.Message); } }
private void ResetUser(T_User user, DrisionDbContext context) { user.User_Password = this.Md5("1"); context.SaveChanges(); UserShow(); this.AjaxAlert("重置密码成功!"); }
protected void gvShow_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { T_User user = e.Row.DataItem as T_User; Label lblUserRole = e.Row.FindControl("lblUserRole") as Label; Label lblState = e.Row.FindControl("lblState") as Label; Label lblDept = e.Row.FindControl("lblDept") as Label; LinkButton lbtnReset = e.Row.FindControl("lbtnReset") as LinkButton; LinkButton lbtnState = e.Row.FindControl("lbtnState") as LinkButton; LinkButton lbtnEdit = e.Row.FindControl("lbtnEdit") as LinkButton; LinkButton lbtnDel = e.Row.FindControl("lbtnDel") as LinkButton; LinkButton lbtnSet = e.Row.FindControl("lbtnSet") as LinkButton; using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { //var query = from n in context.T_User_Role // join r in context.T_Role on n.Role_ID equals r.Role_ID // where n.User_ID == user.User_ID // select r.Role_Name; var query = user.T_Roles.Select(p => p.Role_Name); lblUserRole.Text = string.Join(" ", query.ToList()); } if (user.User_Status == 1) { lblState.Text = "启用"; lbtnState.Text = "停用"; lbtnState.OnClientClick = "if (!confirm('是否停用用户?')) {return false;}"; } else { lblState.Text = "停用"; lbtnState.Text = "启用"; lbtnState.OnClientClick = "if (!confirm('是否启用用户?')) {return false;}"; } lblDept.Text = ""; lbtnReset.CommandArgument = user.User_ID.ToString(); lbtnState.CommandArgument = user.User_ID.ToString(); lbtnEdit.CommandArgument = user.User_ID.ToString(); lbtnDel.CommandArgument = user.User_ID.ToString(); lbtnSet.CommandArgument = user.User_ID.ToString(); if (user.User_ID == 1) { lbtnReset.Enabled = false; lbtnState.Enabled = false; lbtnEdit.Enabled = false; lbtnDel.Enabled = false; lbtnSet.Enabled = false; } } }
//页面定义的参数 protected void Page_Load(object sender, EventArgs e) { try { if (!this.IsPostBack) { if (Request.QueryString["id"] == null) { //转到错误页 Response.Redirect("~/Error.aspx"); } //赋值定义的参数 //绑定启动流程下拉选择框 //绑定枚举 ctrl_User_Status.DataSource = typeof(Drision.Framework.Enum.EffectiveFlagEnum); ctrl_User_Status.DataBind(); ctrl_Is_Prohibit_Web.DataSource = typeof(Drision.Framework.Enum.ForbiddenWebFlagEmum); ctrl_Is_Prohibit_Web.DataBind(); ctrl_Is_Prohibit_Mobile.DataSource = typeof(Drision.Framework.Enum.ForbiddenMobileFlagEmum); ctrl_Is_Prohibit_Mobile.DataBind(); txt_User_TypeJW.DataSource = typeof(Drision.Framework.Enum.User_User_TypeEnum); txt_User_TypeJW.DataBind(); //绑定引用字段下拉 using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { Tension.DataPage <dynamic> dataPage = new Tension.DataPage <dynamic>(1, int.MaxValue); dynamic result1 = null; result1 = context.T_Department.ToList(); foreach (var m in result1) { var p = new DataWrapper(m); ctrl_Department_ID.Items.Add(new ComboItem() { Text = p["Department_Name"], Value = p["Department_ID"], }); } } //查询并加载数据 __Id = Convert.ToInt32(Request.QueryString["id"]); this.hc.Text = this.ClientScript.GetPostBackEventReference(this.hc, "refresh"); SetTabSelectedIndex(); } } catch (Exception ex) { this.AjaxAlert(ex); } }
private void UpdateUser(T_Role role, DrisionDbContext context) { txtName.Text = role.Role_Name; rbtnState.SelectedValue = role.Role_Status.ToString(); txtRemark.Text = role.Role_Comment; lblEdit.Text = role.Role_ID.ToString(); btnAdd.Visible = false; btnEdit.Visible = true; Panel1.Visible = true; }
/// <summary> /// 更新日志状态 /// </summary> /// <param name="id">日志ID</param> /// <param name="state">日志状态</param> void UpdateState(int id, OperationErrorLogStateEnum state) { using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { T_MobileOperationErrorLog log = context.T_MobileOperationErrorLog.FirstOrDefault(p => p.Id == id); if (log != null) { log.StateEnum = state; context.SaveChanges(); } } }
private void DeptShow() { using (DrisionDbContext context = new DrisionDbContext()) { var departmentlist = context.T_Department.Select(x => new { x.Department_ID, x.Department_Name }).ToList(); this.ddlDept.Items.Clear(); this.ddlDept.Items.Add(new ListItem("请选择", "-1")); this.ddlDept.DataSource = departmentlist; this.ddlDept.DataTextField = "Department_Name"; this.ddlDept.DataValueField = "Department_ID"; this.ddlDept.DataBind(); } }
private void EditUser(string code, int id) { using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { T_User user = context.T_User.Where(x => x.User_ID == id).FirstOrDefault(); if (user == null) { return; } if (ddlDept.Items.Count == 0) { this.AjaxAlert("部门不存在,请先添加部门!"); return; } else { user.Department_ID = Convert.ToInt32(ddlDept.SelectedValue); } if (context.T_User.Where(x => x.User_ID != id && x.User_Code == code).Count() != 0) { this.AjaxAlert("用户工号不能重复!"); return; } else { user.User_Code = code; } user.User_Name = txtName.Text.Trim(); user.EntryDate = Convert.ToDateTime(txtEntryTime.Text.Trim()); user.Card_No = txtCardNum.Text.Trim(); user.User_Mobile = txtPhone.Text.Trim(); user.User_EMail = txtEmail.Text.Trim(); user.User_Status = Convert.ToInt32(rbtnState.SelectedValue); user.User_Comment = txtRemark.Text.Trim(); context.SaveChanges(); } UserShow(); ClearControl(); this.AjaxAlert("编辑用户成功!"); }
private void DeleteUser(T_Role role, DrisionDbContext context) { if (role.T_Users.Count > 0 || RoleFunctionManager.GetInstance().GetFunctions(role.Role_ID).Count > 0) { this.AjaxAlert("此角色已使用,不能删除!"); return; } context.T_Role.Remove(role); context.SaveChanges(); BingRoleToDataGridview(); if (lblEdit.Text.Trim() == role.Role_ID.ToString()) { ClearControl(); } this.AjaxAlert("删除角色成功!"); }
private void AddUser(string code) { using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { T_User user = new T_User(); if (ddlDept.Items.Count == 0) { this.AjaxAlert("部门不存在,请先添加部门!"); return; } else { user.Department_ID = Convert.ToInt32(ddlDept.SelectedValue); } if (context.T_User.Where(x => x.User_Code == code).Count() != 0) { this.AjaxAlert("用户工号不能重复!"); return; } else { user.User_Code = code; } var query = context.T_User.OrderByDescending(x => x.User_ID).FirstOrDefault(); user.User_ID = query == null ? 1 : query.User_ID + 1; user.User_Password = this.Md5("1"); user.User_Name = txtName.Text.Trim(); user.EntryDate = Convert.ToDateTime(txtEntryTime.Text.Trim()); user.Card_No = txtCardNum.Text.Trim(); user.User_Mobile = txtPhone.Text.Trim(); user.User_EMail = txtEmail.Text.Trim(); user.User_Status = Convert.ToInt32(rbtnState.SelectedValue); user.User_Comment = txtRemark.Text.Trim(); context.SaveChanges(); } UserShow(); ClearControl(); this.AjaxAlert("添加用户成功!"); }
private void UserShow() { using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { IEnumerable <T_User> userQuery; if (string.IsNullOrEmpty(txtSearchName.Text.Trim())) { userQuery = context.T_User.OrderBy(x => x.User_ID); } else { userQuery = context.T_User.Where(x => x.User_Name.Contains(txtSearchName.Text.Trim())).OrderBy(x => x.User_ID); } int totalCount = userQuery.Count(); Pager.Data_AspNetPager(AspNetPager1, totalCount, AspNetPager1.PageSize); this.gvShow.DataSource = userQuery.Skip(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1)) .Take(AspNetPager1.PageSize).ToList(); this.gvShow.DataBind(); } }
/// <summary> /// 加载数据 /// </summary> void LoadData() { string id = Request.QueryString["id"]; if (!string.IsNullOrEmpty(id)) { int piid = int.Parse(id); using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { T_MobileOperationErrorLog log = context.T_MobileOperationErrorLog.FirstOrDefault(p => p.Id == piid); if (log != null) { lblCreateUserId.Text = log.CreateUserId.HasValue?OrgManager.GetDisplayValue("T_User", log.CreateUserId.Value):string.Empty; lblCreateTime.Text = log.CreateTime.HasValue ? log.CreateTime.Value.ToString("yyyy-MM-dd HH:mm:ss") : string.Empty; lblOperationRecord.Text = log.OperationRecord; lblState.Text = log.State.HasValue? EnumHelper.GetDescription(typeof(OperationErrorLogStateEnum), log.State.Value):string.Empty; } } } }
private void DeleteUser(T_User user, DrisionDbContext context) { context.T_User.Remove(user); context.SaveChanges(); UserShow(); if (lblEdit.Text.Trim() == user.User_ID.ToString()) { ClearControl(); } if (user.User_ID == this.LoginUserID) { LoginUser = null; Session["ModuleId"] = 1; Session["FunctionId"] = 101; Response.Redirect("~/Home/Login.aspx"); } this.AjaxAlert("删除用户成功!"); }
private void ResetState(T_User user, DrisionDbContext context) { if (user.User_Status == 1) { user.User_Status = 0; context.SaveChanges(); UserShow(); this.AjaxAlert("停用用户成功!"); return; } else if (user.User_Status == 0) { user.User_Status = 1; context.SaveChanges(); UserShow(); this.AjaxAlert("启用用户成功!"); return; } }
private void EditUser(string name, int id) { using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { if (context.T_Role.Where(x => x.Role_ID != id && x.Role_Name == name).Count() != 0) { this.AjaxAlert("角色名称不能重复!"); return; } var query = context.T_Role.Where(x => x.Role_ID == id).FirstOrDefault(); query.Role_Name = txtName.Text.Trim(); query.Role_Status = Convert.ToInt32(rbtnState.SelectedValue); query.Role_Comment = txtRemark.Text.Trim(); context.SaveChanges(); } BingRoleToDataGridview(); ClearControl(); this.AjaxAlert("编辑角色成功!"); }
/// <summary> /// 绑定数据 /// </summary> protected void ListBind() { using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { var activeRoleQuery = context.T_Role.Where(x => x.Role_Status == 0); int totalCount = activeRoleQuery.Count(); Pager.Data_AspNetPager(AspNetPager1, totalCount, AspNetPager1.PageSize); var activeRoleList = activeRoleQuery.OrderBy(x => x.Role_ID).Skip(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1)) .Take(AspNetPager1.PageSize).ToList(); //var userRoleList = context.T_User_Role.Where(x => x.User_ID == UserId).ToList(); var userRoleList = context.T_User.FirstOrDefault(p => p.User_ID == UserId).T_Roles.ToList(); this.gvShow.DataSource = activeRoleList.Select(x => new SetRoleEntity() { Role_ID = x.Role_ID, Role_Name = x.Role_Name, Role_Comment = x.Role_Comment, CheckedFlag = (userRoleList.Where(y => y.Role_ID == x.Role_ID).Count() != 0) }).ToList(); this.gvShow.DataBind(); } }
/// <summary> /// 绑定用户ID号 /// </summary> private void BingDataToUserId(string userId) { //如果传入ID号有误,则变成下拉菜单来处理 bool nextSetp = true; if (!string.IsNullOrEmpty(userId)) { this.UserId = Convert.ToInt32(userId); using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { var query = context.T_User.Where(x => x.User_ID == this.UserId).FirstOrDefault(); if (query != null) { lblUserName.Text += query.User_Name; this.ddlRoleList.Visible = false; nextSetp = false; } } } if (nextSetp) { using (DrisionDbContext Context = new DrisionDbContext(GlobalObject.ConnString)) { var roleList = Context.T_User.Select(x => new { x.User_ID, x.User_Name }).ToList(); this.ddlRoleList.DataSource = roleList; this.ddlRoleList.DataValueField = "User_ID"; this.ddlRoleList.DataTextField = "User_Name"; this.ddlRoleList.DataBind(); this.UserId = Convert.ToInt32(this.ddlRoleList.SelectedValue); this.ddlRoleList.Visible = true; } } }
private void UpdateUser(T_User user, DrisionDbContext context) { txtCode.Text = user.User_Code; txtName.Text = user.User_Name; if (user.EntryDate == null) { txtEntryTime.Text = ""; } else { txtEntryTime.Text = Convert.ToDateTime(user.EntryDate).ToString("yyyy-MM-dd"); } txtCardNum.Text = user.Card_No; txtPhone.Text = user.User_Mobile; txtEmail.Text = user.User_EMail; if (context.T_Department.Where(x => x.Department_ID == user.Department_ID).Count() != 0) { ddlDept.SelectedValue = user.Department_ID.ToString(); } else { ddlDept.SelectedIndex = -1; } rbtnState.SelectedValue = user.User_Status.ToString(); txtRemark.Text = user.User_Comment; lblEdit.Text = user.User_ID.ToString(); btnAdd.Visible = false; btnEdit.Visible = true; Panel1.Visible = true; }
private void SetRole(T_User user, DrisionDbContext context) { Response.Redirect("SetRole.aspx?UserId=" + user.User_ID); }
private void SetRight(T_Role role, DrisionDbContext context) { context.Dispose(); Response.Redirect("RightOfMenu.aspx?RoleId=" + role.Role_ID); return; }
protected void btnAdd_Click(object sender, EventArgs e) { string RoleID = ""; for (int i = 0; i < this.gvShow.Rows.Count; i++) { if (((CheckBox)this.gvShow.Rows[i].Cells[1].FindControl("CheckBox1")).Checked) { RoleID += this.gvShow.DataKeys[i]["Role_ID"].ToString() + ","; } } if (RoleID == "") { this.AjaxAlert("没有选中任何项!"); return; } RoleID = RoleID.Trim(','); string[] RoleArr = RoleID.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString)) { //var delList = context.T_User_Role.Where(x => x.User_ID == UserId).ToList(); //foreach (var del in delList) //{ // context.T_User_Role.Remove(del); //} T_User user = context.T_User.FirstOrDefault(p => p.User_ID == UserId); if (user != null) { user.T_Roles.Clear(); foreach (var str in RoleArr) { int roleId = int.Parse(str); T_Role role = context.T_Role.FirstOrDefault(p => p.Role_ID == roleId); if (role != null) { user.T_Roles.Add(role); } } //int id; //var query = context.T_User_Role.OrderByDescending(x => x.Id).FirstOrDefault(); //if (query == null) // id = 1; //else // id = query.Id + 1; //int roleId; //foreach (var str in RoleArr) //{ // roleId = int.Parse(str); // context.T_User_Role.Add(new WebContext.Model.T_User_Role() { // Id = id, // User_ID = UserId, // Role_ID = roleId // }); // id++; //} context.SaveChanges(); } } this.AjaxAlert("设置成功!"); //Response.Redirect("UserInfo.aspx"); Response.Redirect("../HR_Common/UserQuery.aspx"); }