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));
}
