/// <summary> /// 私有方法:从数据库中判断用户是否登录 /// 创建 毛枫 2015-4-21 /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> private static T_ADMIN IsLoginFromSql(string username, string password) { T_ADMIN_BLL T_ADMIN_BLL = new T_ADMIN_BLL(); var query = new DapperExQuery <T_ADMIN>().AndWhere(n => n.A_NAME, OperationMethod.Equal, username) .AndWhere(n => n.PASSWORD, OperationMethod.Equal, EncryptUtil.Md5Encode(password.Trim(), 16)); var admin = T_ADMIN_BLL.GetEntity(query); return(admin); }
/// <summary> /// 保存修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_OnClick(object sender, EventArgs e) { string message = ""; T_ADMIN_BLL T_ADMIN_BLL = new T_ADMIN_BLL(); try { //①获取当前登录用户 AdminUserModel adminInfo = AdminwebUserManager.GetCurrentAdminUser(); //②判断当前登录用户原密码 var query = new DapperExQuery <T_ADMIN>().AndWhere(n => n.A_CODE, OperationMethod.Equal, adminInfo.A_CODE) .AndWhere(n => n.PASSWORD, OperationMethod.Equal, EncryptUtil.Md5Encode(tbxOriPassword.Text.Trim(), 16)); var entity = T_ADMIN_BLL.GetEntity(query); if (entity != null) { //③判断确认密码是否等于密码 if (tbxPassword.Text == tbxCfm_Password.Text) { //④保存新密码 entity.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16); if (new T_ADMIN_BLL().Update(entity)) { message = "修改成功"; updateWindow.Hidden = true; } else { message = "修改失败"; } } else { message = "确认密码错误"; } } else { message = "用户密码错误,请输入原密码"; } } catch (Exception ex) { message = ex.ToString(); } Alert.Show(message); }
/// <summary> /// 功能:列表数据绑定 /// 创建:金协民 /// 时间:2015年10月28日 /// </summary> private void BindGrid() { //获取数据 BaseSearchParam parm = new BaseSearchParam { //当前页数 index = Grid1.PageIndex + 1 }; Grid1.PageSize = parm.size; string massage = string.Empty; var modelList = T_ADMIN_BLL.BindData(parm, out massage); // 在查询添加之后,获取总记录数 Grid1.RecordCount = int.Parse(parm.allcount.ToString()); Grid1.DataSource = modelList; Grid1.DataBind(); }
/// <summary> /// 私有方法:从数据库中判断用户是否登录 /// 创建 毛枫 2015-4-21 /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> private static T_ADMIN IsLoginFromSql(string username, string password) { T_ADMIN_BLL T_ADMIN_BLL = new T_ADMIN_BLL(); var query = new DapperExQuery<T_ADMIN>().AndWhere(n => n.A_NAME, OperationMethod.Equal, username) .AndWhere(n => n.PASSWORD, OperationMethod.Equal, EncryptUtil.Md5Encode(password.Trim(), 16)); var admin = T_ADMIN_BLL.GetEntity(query); return admin; }
/// <summary> /// 保存修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_OnClick(object sender, EventArgs e) { string message = ""; T_ADMIN_BLL T_ADMIN_BLL = new T_ADMIN_BLL(); try { //①获取当前登录用户 AdminUserModel adminInfo = AdminwebUserManager.GetCurrentAdminUser(); //②判断当前登录用户原密码 var query = new DapperExQuery<T_ADMIN>().AndWhere(n => n.A_CODE, OperationMethod.Equal, adminInfo.A_CODE) .AndWhere(n => n.PASSWORD, OperationMethod.Equal, EncryptUtil.Md5Encode(tbxOriPassword.Text.Trim(), 16)); var entity = T_ADMIN_BLL.GetEntity(query); if (entity != null) { //③判断确认密码是否等于密码 if (tbxPassword.Text == tbxCfm_Password.Text) { //④保存新密码 entity.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16); if (new T_ADMIN_BLL().Update(entity)) { message = "修改成功"; updateWindow.Hidden = true; } else { message = "修改失败"; } } else { message = "确认密码错误"; } } else { message = "用户密码错误,请输入原密码"; } } catch (Exception ex) { message = ex.ToString(); } Alert.Show(message); }