/// <summary> /// 保存用户(编辑页面) /// </summary> /// <returns></returns> public JsonResult AjaxUpdateUser() { object retJson = new { success = 0, msg = "操作失败" }; JMP.MDL.jmp_locuser mol_localuser = new JMP.MDL.jmp_locuser(); JMP.MDL.jmp_locuser old_mol_localuser = new JMP.MDL.jmp_locuser(); old_mol_localuser = bll_localuser.GetModel(int.Parse(Request["id"])); mol_localuser.u_pwd = JMP.TOOL.DESEncrypt.Encrypt(Request["pwd"]); mol_localuser.u_realname = Request["realName"]; mol_localuser.u_department = Request["department"]; mol_localuser.u_position = Request["position"]; mol_localuser.u_role_id = int.Parse(Request["roteId"]); mol_localuser.u_state = int.Parse(Request["state"]); mol_localuser.u_id = int.Parse(Request["id"]); mol_localuser.u_loginname = Request["name"]; mol_localuser.u_mobilenumber = Request["mobilenumber"]; mol_localuser.u_emailaddress = Request["emailaddress"]; mol_localuser.u_qq = Request["qq"]; bool result = false; if (!bll_localuser.ExistsName(mol_localuser.u_loginname, mol_localuser.u_id.ToString())) { result = bll_localuser.Update(mol_localuser); } if (result) { Logger.ModifyLog("修改用户", old_mol_localuser, mol_localuser); retJson = new { success = 1, msg = "操作成功" }; } return(Json(retJson)); }
/// <summary> /// 保存用户(添加页面) /// </summary> /// <returns></returns> public JsonResult AjaxAddUser() { object retJson = new { success = 0, msg = "操作失败" }; JMP.MDL.jmp_locuser mol_localuser = new JMP.MDL.jmp_locuser(); mol_localuser.u_loginname = Request["name"]; mol_localuser.u_pwd = JMP.TOOL.DESEncrypt.Encrypt(Request["pwd"]); mol_localuser.u_realname = Request["realName"]; mol_localuser.u_department = Request["department"]; mol_localuser.u_position = Request["position"]; mol_localuser.u_role_id = int.Parse(Request["roteId"]); mol_localuser.u_state = int.Parse(Request["state"]); mol_localuser.u_mobilenumber = Request["mobilenumber"]; mol_localuser.u_emailaddress = Request["emailaddress"]; mol_localuser.u_qq = Request["qq"]; if (bll_localuser.ExistsName(mol_localuser.u_loginname)) { retJson = new { success = 2, msg = "用户名重复,请重新填写" }; } else { int result = bll_localuser.Add(mol_localuser); if (result >= 0) { #region 添加日志 Logger.CreateLog("添加本地管理员用户", mol_localuser); #endregion retJson = new { success = 1, msg = "操作成功" }; } } return(Json(retJson)); }
public JsonResult loginUpdatePwd() { JMP.BLL.jmp_locuser bll = new JMP.BLL.jmp_locuser(); object result = new { success = 0, msg = "修改失败!" }; string o_pwd = !string.IsNullOrEmpty(Request["upass"]) ? Request["upass"] : ""; string n_pwd = !string.IsNullOrEmpty(Request["xpwd"]) ? Request["xpwd"] : ""; JMP.MDL.jmp_locuser j_user = bll.GetModel(UserInfo.UserId); //判断是否修改了密码 if (!string.IsNullOrEmpty(o_pwd)) { string temp = DESEncrypt.Encrypt(o_pwd); if (temp == j_user.u_pwd) { string u_password = DESEncrypt.Encrypt(n_pwd); j_user.u_pwd = u_password; bool flag = bll.Update(j_user); result = new { success = 1, msg = "修改成功,请重新登录!" }; } else { result = new { success = 2, msg = "原密码输入错误!" }; } } return(Json(result)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_locuser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update JMP_LOCUSER set "); strSql.Append("u_role_id=@u_role_id,"); strSql.Append("u_pwd=@u_pwd,"); strSql.Append("u_realname=@u_realname,"); strSql.Append("u_department=@u_department,"); strSql.Append("u_position=@u_position,"); strSql.Append("u_count=@u_count,"); strSql.Append("u_state=@u_state,"); strSql.Append("u_loginname=@u_loginname,"); strSql.Append("u_mobilenumber=@u_mobilenumber,"); strSql.Append("u_emailaddress=@u_emailaddress,"); strSql.Append("u_qq=@u_qq"); strSql.Append(" where u_id=@u_id"); SqlParameter[] parameters = { new SqlParameter("@u_role_id", SqlDbType.Int, 4), new SqlParameter("@u_pwd", SqlDbType.NVarChar, -1), new SqlParameter("@u_realname", SqlDbType.NVarChar, -1), new SqlParameter("@u_department", SqlDbType.NVarChar, -1), new SqlParameter("@u_position", SqlDbType.NVarChar, -1), new SqlParameter("@u_count", SqlDbType.Int, 4), new SqlParameter("@u_state", SqlDbType.Int, 4), new SqlParameter("@u_loginname", SqlDbType.NVarChar, -1), new SqlParameter("@u_id", SqlDbType.Int, 4), new SqlParameter("@u_mobilenumber", SqlDbType.NVarChar, 20), new SqlParameter("@u_emailaddress", SqlDbType.NVarChar, 120), new SqlParameter("@u_qq", SqlDbType.NVarChar, 20) }; parameters[0].Value = model.u_role_id; parameters[1].Value = model.u_pwd; parameters[2].Value = model.u_realname; parameters[3].Value = model.u_department; parameters[4].Value = model.u_position; parameters[5].Value = model.u_count; parameters[6].Value = model.u_state; parameters[7].Value = model.u_loginname; parameters[8].Value = model.u_id; parameters[9].Value = model.u_mobilenumber; parameters[10].Value = model.u_emailaddress; parameters[11].Value = model.u_qq; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 用户编辑页面 /// </summary> /// <returns></returns> public ActionResult UpdateUsers() { int uid = int.Parse(Request["u_id"]); int admin = Int32.Parse(ConfigurationManager.AppSettings["administrator"].ToString()); ViewBag.admin = admin; mol_locuser = bll_localuser.GetModel(uid); ViewBag.model = mol_locuser; GetListRote(mol_locuser.u_role_id); GetState(mol_locuser.u_state); return(View()); }
/// <summary> /// 得到一个对象实体 /// </summary> public JMP.MDL.jmp_locuser GetModel(string userName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select u_id, u_role_id, u_loginname, u_pwd, u_realname, u_department, u_position, u_count, u_state,u_mobilenumber,u_emailaddress,u_qq "); strSql.Append(" from jmp_locuser "); strSql.Append(" where u_loginname=@u_loginname"); SqlParameter[] parameters = { new SqlParameter("@u_loginname", SqlDbType.NVarChar, -1) }; parameters[0].Value = userName; JMP.MDL.jmp_locuser model = new JMP.MDL.jmp_locuser(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["u_id"].ToString() != "") { model.u_id = int.Parse(ds.Tables[0].Rows[0]["u_id"].ToString()); } if (ds.Tables[0].Rows[0]["u_role_id"].ToString() != "") { model.u_role_id = int.Parse(ds.Tables[0].Rows[0]["u_role_id"].ToString()); } model.u_loginname = ds.Tables[0].Rows[0]["u_loginname"].ToString(); model.u_pwd = ds.Tables[0].Rows[0]["u_pwd"].ToString(); model.u_realname = ds.Tables[0].Rows[0]["u_realname"].ToString(); model.u_department = ds.Tables[0].Rows[0]["u_department"].ToString(); model.u_position = ds.Tables[0].Rows[0]["u_position"].ToString(); if (ds.Tables[0].Rows[0]["u_count"].ToString() != "") { model.u_count = int.Parse(ds.Tables[0].Rows[0]["u_count"].ToString()); } if (ds.Tables[0].Rows[0]["u_state"].ToString() != "") { model.u_state = int.Parse(ds.Tables[0].Rows[0]["u_state"].ToString()); } model.u_mobilenumber = ds.Tables[0].Rows[0]["u_mobilenumber"].ToString(); model.u_emailaddress = ds.Tables[0].Rows[0]["u_emailaddress"].ToString(); model.u_qq = ds.Tables[0].Rows[0]["u_qq"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_locuser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into jmp_locuser("); strSql.Append("u_role_id,u_loginname,u_pwd,u_realname,u_department,u_position,u_count,u_state,u_mobilenumber,u_emailaddress,u_qq"); strSql.Append(") values ("); strSql.Append("@u_role_id,@u_loginname,@u_pwd,@u_realname,@u_department,@u_position,@u_count,@u_state,@u_mobilenumber,@u_emailaddress,@u_qq"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@u_role_id", SqlDbType.Int, 4), new SqlParameter("@u_loginname", SqlDbType.NVarChar, -1), new SqlParameter("@u_pwd", SqlDbType.NVarChar, -1), new SqlParameter("@u_realname", SqlDbType.NVarChar, -1), new SqlParameter("@u_department", SqlDbType.NVarChar, -1), new SqlParameter("@u_position", SqlDbType.NVarChar, -1), new SqlParameter("@u_count", SqlDbType.Int, 4), new SqlParameter("@u_state", SqlDbType.Int, 4), new SqlParameter("@u_mobilenumber", SqlDbType.NVarChar, 20), new SqlParameter("@u_emailaddress", SqlDbType.NVarChar, 120), new SqlParameter("@u_qq", SqlDbType.NVarChar, 20) }; parameters[0].Value = model.u_role_id; parameters[1].Value = model.u_loginname; parameters[2].Value = model.u_pwd; parameters[3].Value = model.u_realname; parameters[4].Value = model.u_department; parameters[5].Value = model.u_position; parameters[6].Value = model.u_count; parameters[7].Value = model.u_state; parameters[8].Value = model.u_mobilenumber; parameters[9].Value = model.u_emailaddress; parameters[10].Value = model.u_qq; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }