public ActionResult UpdateForForm()
{
#region 修改个人资料
bool b = true;
//获得params传过来的全部参数对象
int age = int.Parse(Request.Params["age"]);
string usern = Request.Params["usern"];
string username = Request.Params["username"];
string newpwd = Request.Params["newpwd"];
string phone = Request.Params["phone"];
string email = Request.Params["email"];
string sex = Request.Params["sex"];
if (Request.Params["outdate"] != "" && Request.Params["indate"] != "")
{
DateTime?outdate = Convert.ToDateTime(Request.Params["outdate"]);
DateTime?indate = Convert.ToDateTime(Request.Params["indate"]);
//先根据username查出ps_role表中职位名称对应的ROLE_ID
ps_role result2 = (from a in mecd.ps_role where a.roleName == username select a).FirstOrDefault();
//获得Session中保存的ID转Int类型然后作为条件继续查
int id = Convert.ToInt32(Session["userid"]);
//根据ID查出ps_user对象然后修改属性值再保存即可
ps_user result = (from a in mecd.ps_user
where a.id == id
select a).FirstOrDefault();
//修改------------------------------------------------
result.age = age;
result.userName = usern;
result.roleId = result2.id;
result.userPassword = newpwd;
result.dimissionDate = outdate;
result.entryDate = indate;
result.phoneTel = phone;
result.email = email;
result.sex = sex;
try
{
//最后保存
mecd.SubmitChanges();
}
catch (Exception)
{
b = false;
}
}
else
{
b = false;
}
#endregion
return(Json(b));
}
//添加角色信息
public ActionResult AddRole()
{
string roleid = Request.Params["roleid"];
string rolename = Request.Params["rolename"];
int status = int.Parse(Request.Params["status"]);
MyElectrCheck_DBDataContext medc = new MyElectrCheck_DBDataContext();
//获得session中保存的值
int id = int.Parse(Session["userid"].ToString());
var user = (from u in medc.ps_user
where u.id == id
select u).FirstOrDefault();
//创建实体类对象
ps_role role = new ps_role()
{
id = roleid,
roleName = rolename,
creationTime = DateTime.Now,
createdBy = user.userCode,
lastUpdateTime = DateTime.Now,
isStart = status
};
bool b = true;
//添加到数据库
medc.ps_role.InsertOnSubmit(role);
try
{
//保存数据
medc.SubmitChanges();
ps_logs logs = new ps_logs()
{
userCode = user.userCode,
userName = user.userName,
operateInfo = "添加角色信息",
operateDateTime = DateTime.Now
};
medc.ps_logs.InsertOnSubmit(logs);
medc.SubmitChanges();
}
catch (Exception)
{
b = false;
}
return(Json(b));
}
