public static ResultMsg_User EditPsw(mg_userModel dataEntity, ResultMsg_User result) { try { string strSql = " SELECT COUNT(1) AS SM FROM [Sys_UserInfo] WHERE Lower(user_name) = '" + dataEntity.user_name.ToLower().Trim() + "' and user_pwd='" + dataEntity.user_pwd + "'"; DataTable dt = new DataTable(); dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, CommandType.Text, strSql, null); int num = NumericParse.StringToInt(DataHelper.GetCellDataToStr(dt.Rows[0], "SM")); if (dt != null && dt.Rows.Count > 0 && num > 0) { result.result = ""; result.msg = ""; } else { result.result = "failed"; result.msg = "原密码不正确!"; } if (result.result == "") { strSql = "update Sys_UserInfo set user_pwd='" + dataEntity.user_NewPassword + "',lasteditpwdtime=getdate() where Lower(user_name)='" + dataEntity.user_name.ToLower() + "'"; int re = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, CommandType.Text, strSql, null); if (re == 1) { result.result = "success"; result.msg = "修改密码成功!"; } } } catch (Exception ex) { result.result = "failed"; result.msg = "保存失败! \n" + ex.Message; } return(result); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; Action = RequstString("Action"); if (Action.Length == 0) { Action = ""; } if (Action == "EditPsw") { mg_userModel userinfo = new mg_userModel(); userinfo.user_name = RequstString("UserID"); userinfo.user_pwd = RequstString("OldPsw"); userinfo.user_NewPassword = RequstString("NewPsw"); ResultMsg_User result = new ResultMsg_User(); result = EditPsw(userinfo, result); context.Response.Write(jsc.Serialize(result)); } }
public ResultMsg_User EditPsw(mg_userModel dataEntity, ResultMsg_User result) { return(EditPassword_BLL.EditPsw(dataEntity, result)); }