public static JsMessage Add_Userinfo(UserInfo u)
{
JsMessage js = new JsMessage();
string SqlStr = "INSERT INTO [dbo].[AccountManage] ([am_LoginUser],[am_PWD],[am_Email],[am_Name],[am_Phone],[am_Status],[am_CreateTime],[am_Role]) values(@am_LoginUser,@am_PWD,@am_Email,@am_Name,@am_Phone,@am_Status,@am_CreateTime,@am_Role)";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@am_LoginUser",u.U_LoginName),
new SqlParameter("@am_PWD",u.U_PWD),
new SqlParameter("@am_Email",u.U_Email),
new SqlParameter("@am_Role",u.U_Role),
//new SqlParameter("@am_Phone",u.U_Phone),
new SqlParameter("@am_Name",""),
new SqlParameter("@am_Phone",""),
new SqlParameter("@am_Status",u.U_Status),
new SqlParameter("@am_CreateTime",u.CreateTime)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
public static JsMessage ChangePWD(UserInfo user)
{
JsMessage jm = new JsMessage();
string SqlStr = " UPDATE [dbo].[AccountManage] SET [am_PWD]=@am_PWD WHERE am_LoginUser=@am_LoginUser";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@am_PWD",user.U_Name),
new SqlParameter("@am_LoginUser",user.U_LoginName)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
jm.IsSuccess = true;
jm.ErrorMsg = "密码修改完成";
}
else
{
jm.IsSuccess = false;
jm.ErrorMsg = "密码修改失败";
}
}
catch (SqlException ex)
{
jm.IsSuccess = false;
jm.ErrorMsg = ex.ToString();
}
return jm;
}
public ActionResult ChangePWD_DB(UserInfo user)
{
string ResultStr = string.Empty;
JsMessage jm = new JsMessage();
string dbpwd = Sql_AccounrManage.OldPWD_NewPWD(user.U_LoginName);
if (dbpwd == user.U_PWD)
{
jm = Sql_AccounrManage.ChangePWD(user);
}
else {
jm.IsSuccess = false;
jm.ErrorMsg = "原始密码不正确";
}
ResultStr = JsonTool.ObjToJson(jm);
return Content(ResultStr);
}
public ActionResult AddAccount(UserInfo u)
{
JsMessage jm=new JsMessage ();
string ResultStr = string.Empty;
if (u.U_ID != 0)
{
jm = Sql_AccounrManage.Modify_Userinfo(u);
}
else
{
u.CreateTime = DateTime.Now.ToString();
u.U_Role = "1";
u.U_PWD = "snnu111111";// 随机6位密码
jm= Sql_AccounrManage.Add_Userinfo(u);
}
ResultStr = JsonTool.ObjToJson(jm);
return Content(ResultStr);
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
/*
* UPDATE [dbo].[AccountManage] SET [am_LoginUser] ='' ,[am_PWD] =,
[am_Email] = '',
[am_Name] ='',
[am_Phone] = '',
[am_Status] = '',
[am_CreateTime] = ''
WHERE [am_ID]=@am_ID
*/
public static JsMessage Modify_Userinfo(UserInfo u)
{
JsMessage js = new JsMessage();
string SqlStr = "UPDATE [dbo].[AccountManage] SET [am_LoginUser] =@am_LoginUser,[am_Email] =@am_Email WHERE [am_ID]=@am_ID";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@am_LoginUser",u.U_LoginName),
new SqlParameter("@am_Email",u.U_Email),
new SqlParameter("@am_ID",u.U_ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
