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