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