/// <summary> /// 右侧角色对应用户的数据绑定 /// 创建 毛枫 2015-4-17 /// </summary> private void BindGrid2() { string R_CODE = FineUITable.GetSelectedDataKeyCode(Grid1); if (R_CODE == "") { Grid2.RecordCount = 0; Grid2.DataSource = null; Grid2.DataBind(); } else { // 过滤选中角色下的所有用户 long allcount = 0; var query = new DapperExQuery <T_ADMIN_ROLES>().AndWhere(n => n.R_CODE, OperationMethod.Equal, R_CODE); int PageIndex = Grid2.PageIndex + 1; int PageSize = Grid2.PageSize; List <T_ADMIN_ROLES> qs = T_ADMIN_ROLES_BLL.GetListByPage(query, "", PageIndex, PageSize, out allcount); List <T_ADMIN> q = new List <T_ADMIN>(); foreach (T_ADMIN_ROLES t in qs) { var query1 = new DapperExQuery <T_ADMIN>().AndWhere(n => n.A_CODE, OperationMethod.Equal, t.A_CODE); T_ADMIN T_ADMIN = new T_ADMIN(); T_ADMIN = T_ADMIN_BLL.GetEntity(query1); q.Add(T_ADMIN); } //获取总记录数 Grid2.RecordCount = Int32.Parse(allcount.ToString()); Grid2.DataSource = q; Grid2.DataBind(); } }
//============操作方法=========== #region 数据保存按钮事件 /// <summary> /// 保存 /// 创建人:林以恒 /// 2015年7月6日14:24:11 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSaveClose_Click(object sender, EventArgs e) { //设置页面权限 power.SetViewPower("mod_admin"); //验证权限 if (power.VerifyPower() == false) { return; } string str; if (Request.QueryString["id"].IsNum()) { string id = Request.QueryString["id"]; //修改 var query = new DapperExQuery <T_ADMIN>().AndWhere(n => n.ID, OperationMethod.Equal, int.Parse(id)); var adminUser = _adminUserBll.GetEntity(query); if (tbxPassword.Text != adminUser.PASSWORD && tbxPassword.Text == tbxCfm_Password.Text) { adminUser.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16); } else if (tbxPassword.Text != adminUser.PASSWORD && tbxPassword.Text != tbxCfm_Password.Text) { Alert.Show("确认密码与填写密码不匹配"); } adminUser = Save(adminUser); str = _adminUserBll.Update(adminUser) ? "修改成功!" : "修改失败!"; } else { T_ADMIN adminUser = new T_ADMIN(); //添加 adminUser = Save(adminUser); if (tbxPassword.Text != tbxCfm_Password.Text) { Alert.Show("确认密码与填写密码不匹配"); } else { adminUser.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16); } str = _adminUserBll.Add(adminUser) ? "添加成功!" : "添加失败!"; } // 2. 关闭本窗体,然后刷新父窗体 PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); Alert.ShowInTop(str); }
/// <summary> /// 更新用户实体 /// 创建人:林以恒 /// 2015年7月25日10:22:06 /// 修改:密码MD5 /// </summary> /// <param name="adminUser">用户实体</param> /// <returns></returns> private T_ADMIN Save(T_ADMIN adminUser) { adminUser.A_NAME = tbxA_NAME.Text.Trim(); adminUser.A_TRUE_NAME = tbxA_CHINESE_NAME.Text.Trim(); adminUser.A_PHONE = tbxPhone.Text.Trim(); adminUser.A_GENDER = rbtnFirst.Checked ? 1 : 0; if (adminUser.ID != 0) { return(adminUser); } //添加随机验证码 adminUser.A_CODE = StringRandomUtil.GuidTo16String(); //获取登入用户信息 var adminUserModel = AdminwebUserManager.GetCurrentAdminUser(); if (adminUserModel != null) { adminUser.CREATE_USER = adminUserModel.A_NAME; adminUser.CREATE_USER_NAME = adminUserModel.A_CHINESE_NAME; } adminUser.CREATE_TIME = DateTime.Now; return(adminUser); }
/// <summary> /// 更新用户实体 /// 创建人:林以恒 /// 2015年7月25日10:22:06 /// 修改:密码MD5 /// </summary> /// <param name="adminUser">用户实体</param> /// <returns></returns> private T_ADMIN Save(T_ADMIN adminUser) { adminUser.A_NAME = tbxA_NAME.Text.Trim(); adminUser.A_TRUE_NAME = tbxA_CHINESE_NAME.Text.Trim(); adminUser.A_PHONE = tbxPhone.Text.Trim(); adminUser.A_GENDER = rbtnFirst.Checked ? 1 : 0; if (adminUser.ID != 0) return adminUser; //添加随机验证码 adminUser.A_CODE = StringRandomUtil.GuidTo16String(); //获取登入用户信息 var adminUserModel = AdminwebUserManager.GetCurrentAdminUser(); if (adminUserModel != null) { adminUser.CREATE_USER = adminUserModel.A_NAME; adminUser.CREATE_USER_NAME = adminUserModel.A_CHINESE_NAME; } adminUser.CREATE_TIME = DateTime.Now; return adminUser; }
//============操作方法=========== #region 数据保存按钮事件 /// <summary> /// 保存 /// 创建人:林以恒 /// 2015年7月6日14:24:11 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSaveClose_Click(object sender, EventArgs e) { //设置页面权限 power.SetViewPower("mod_admin"); //验证权限 if (power.VerifyPower() == false) { return; } string str; if (Request.QueryString["id"].IsNum()) { string id = Request.QueryString["id"]; //修改 var query = new DapperExQuery<T_ADMIN>().AndWhere(n => n.ID, OperationMethod.Equal, int.Parse(id)); var adminUser = _adminUserBll.GetEntity(query); if (tbxPassword.Text != adminUser.PASSWORD && tbxPassword.Text == tbxCfm_Password.Text) { adminUser.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16); } else if (tbxPassword.Text != adminUser.PASSWORD && tbxPassword.Text != tbxCfm_Password.Text) { Alert.Show("确认密码与填写密码不匹配"); } adminUser = Save(adminUser); str = _adminUserBll.Update(adminUser) ? "修改成功!" : "修改失败!"; } else { T_ADMIN adminUser = new T_ADMIN(); //添加 adminUser = Save(adminUser); if (tbxPassword.Text != tbxCfm_Password.Text) { Alert.Show("确认密码与填写密码不匹配"); } else { adminUser.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16); } str = _adminUserBll.Add(adminUser) ? "添加成功!" : "添加失败!"; } // 2. 关闭本窗体,然后刷新父窗体 PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); Alert.ShowInTop(str); }
/// <summary> /// 管理员登录 /// 创建 毛枫 2015-4-21 /// 修改 毛枫 2015-7-31 /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public static bool AdminLoginIn(string username, string password) { bool result = false; try { T_ADMIN admin = new T_ADMIN(); admin = IsLoginFromSql(username, password); if (admin != null) { #region Cookie和Session的设置 //System.Web.HttpContext.Current.Session["A_ID"] = admin.ID; //System.Web.HttpContext.Current.Session["A_Code"] = admin.A_CODE; //System.Web.HttpContext.Current.Session["A_TrueName"] = admin.A_TRUE_NAME; //System.Web.HttpContext.Current.Session["A_AdminName"] = admin.A_NAME; //System.Web.HttpContext.Current.Session.Timeout = 10800; WebHelperUtil.SessionAdd("A_ID", admin.ID.ToString(), 60); WebHelperUtil.SessionAdd("A_Code", admin.A_CODE, 60); WebHelperUtil.SessionAdd("A_TrueName", admin.A_TRUE_NAME, 60); WebHelperUtil.SessionAdd("A_AdminName", admin.A_NAME, 60); ////生成用户模型 //System.Web.HttpContext.Current.Session["A_AdminUser"] = new AdminUserModel() //{ // A_ID = admin.ID, // A_CODE = admin.A_CODE, // A_NAME = admin.A_NAME, // A_CHINESE_NAME = admin.A_TRUE_NAME, //}; string userModle = new AdminUserModel() { A_ID = admin.ID, A_CODE = admin.A_CODE, A_NAME = admin.A_NAME, A_CHINESE_NAME = admin.A_TRUE_NAME, }.toJson(); //加密处理 userModle = EncryptUtil.Base64Encode(userModle); WebHelperUtil.SetCookie("A_AdminUser", userModle, ExpiresDayCookiesSession); //生成验证字符串cookie string authStr = admin.ID + "^" + username.ToLower() + "^" + DateTime.Now.AddHours(2); authStr = EncryptUtil.DESEncryptString(authStr); //添加Cookie WebHelperUtil.SetCookie("AdminToken", EncryptUtil.MD5(admin.ID.ToString(), 16), ExpiresDayCookiesSession); WebHelperUtil.SetCookie("AdminAuth", authStr, ExpiresDayCookiesSession); WebHelperUtil.SetCookie("AdminLastLogTime", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), ExpiresDayCookiesSession); WebHelperUtil.SetCookie("AdminUserLogin", "login", ExpiresDayCookiesSession); #endregion LoginCommon.InsertAdminLoginLog(admin); result = true; } else { result = false; } } catch (Exception ex) { result = false; } return(result); }
/// <summary> /// 右侧角色对应用户的数据绑定 /// 创建 毛枫 2015-4-17 /// </summary> private void BindGrid2() { string R_CODE = FineUITable.GetSelectedDataKeyCode(Grid1); if (R_CODE =="") { Grid2.RecordCount = 0; Grid2.DataSource = null; Grid2.DataBind(); } else { // 过滤选中角色下的所有用户 long allcount = 0; var query = new DapperExQuery<T_ADMIN_ROLES>().AndWhere(n => n.R_CODE, OperationMethod.Equal, R_CODE); int PageIndex = Grid2.PageIndex + 1; int PageSize = Grid2.PageSize; List<T_ADMIN_ROLES> qs = T_ADMIN_ROLES_BLL.GetListByPage(query, "", PageIndex, PageSize, out allcount); List<T_ADMIN> q = new List<T_ADMIN>(); foreach (T_ADMIN_ROLES t in qs) { var query1 = new DapperExQuery<T_ADMIN>().AndWhere(n => n.A_CODE, OperationMethod.Equal, t.A_CODE); T_ADMIN T_ADMIN = new T_ADMIN(); T_ADMIN = T_ADMIN_BLL.GetEntity(query1); q.Add(T_ADMIN); } //获取总记录数 Grid2.RecordCount = Int32.Parse(allcount.ToString()); Grid2.DataSource = q; Grid2.DataBind(); } }
/// <summary> /// 管理员登录 /// 创建 毛枫 2015-4-21 /// 修改 毛枫 2015-7-31 /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public static bool AdminLoginIn(string username, string password) { bool result = false; try { T_ADMIN admin = new T_ADMIN(); admin = IsLoginFromSql(username, password); if (admin != null) { #region Cookie和Session的设置 //System.Web.HttpContext.Current.Session["A_ID"] = admin.ID; //System.Web.HttpContext.Current.Session["A_Code"] = admin.A_CODE; //System.Web.HttpContext.Current.Session["A_TrueName"] = admin.A_TRUE_NAME; //System.Web.HttpContext.Current.Session["A_AdminName"] = admin.A_NAME; //System.Web.HttpContext.Current.Session.Timeout = 10800; WebHelperUtil.SessionAdd("A_ID", admin.ID.ToString(), 60); WebHelperUtil.SessionAdd("A_Code", admin.A_CODE, 60); WebHelperUtil.SessionAdd("A_TrueName", admin.A_TRUE_NAME, 60); WebHelperUtil.SessionAdd("A_AdminName", admin.A_NAME, 60); ////生成用户模型 //System.Web.HttpContext.Current.Session["A_AdminUser"] = new AdminUserModel() //{ // A_ID = admin.ID, // A_CODE = admin.A_CODE, // A_NAME = admin.A_NAME, // A_CHINESE_NAME = admin.A_TRUE_NAME, //}; string userModle = new AdminUserModel() { A_ID = admin.ID, A_CODE = admin.A_CODE, A_NAME = admin.A_NAME, A_CHINESE_NAME = admin.A_TRUE_NAME, }.toJson(); //加密处理 userModle = EncryptUtil.Base64Encode(userModle); WebHelperUtil.SetCookie("A_AdminUser", userModle, ExpiresDayCookiesSession); //生成验证字符串cookie string authStr = admin.ID + "^" + username.ToLower() + "^" + DateTime.Now.AddHours(2); authStr = EncryptUtil.DESEncryptString(authStr); //添加Cookie WebHelperUtil.SetCookie("AdminToken", EncryptUtil.MD5(admin.ID.ToString(), 16), ExpiresDayCookiesSession); WebHelperUtil.SetCookie("AdminAuth", authStr, ExpiresDayCookiesSession); WebHelperUtil.SetCookie("AdminLastLogTime", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), ExpiresDayCookiesSession); WebHelperUtil.SetCookie("AdminUserLogin", "login", ExpiresDayCookiesSession); #endregion LoginCommon.InsertAdminLoginLog(admin); result = true; } else { result = false; } } catch (Exception ex) { result = false; } return result; }
/// <summary> /// 登录功能 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void IbtDL_Click(object sender, ImageClickEventArgs e) { LoginUser dlUser = new LoginUser(); //校验 if (this.txtUser.Text == "") { Alert("账户不能为空!"); return; } if (this.txtPwd.Text == "") { Alert("密码不能为空!"); return; } if (this.dlType.SelectedValue.Trim() == "管理") { T_ADMIN model = new T_ADMIN(); model = model.GetModelByName(this.txtUser.Text); if (model == null) { ResponseMessage(this, "账户不存在!"); return; } if (model.ADMINMM != txtPwd.Text) { ResponseMessage(this, "密码错误,请查证后重新输入!"); return; } dlUser.JSID = 1; dlUser.JSNAME = "超级管理员"; dlUser.Password = txtPwd.Text; dlUser.ZH = txtUser.Text; dlUser.ID = model.ADMINID; dlUser.RealName = "超级管理员"; } else if (dlType.SelectedValue.Trim() == "用户") { T_YH model = new T_YH(); model = model.GetModelByName(txtUser.Text); if (model == null) { ResponseMessage(this, "账户不存在!"); return; } if (model.DLMM != txtPwd.Text) { ResponseMessage(this, "密码错误,请查证后重新输入!"); return; } dlUser.JSID = 2; dlUser.JSNAME = "用户"; dlUser.Password = txtPwd.Text; dlUser.ZH = txtUser.Text; dlUser.ID = model.YHID; dlUser.RealName = model.YHMC; } else { ResponseMessage(this, "登录类型错误!"); return; } Session["LoginUser"] = dlUser; Response.Redirect("index.aspx"); }