public ActionResult ExitLogin()
{
var user = (from u in medc.ps_user
where u.id == int.Parse(Session["userid"].ToString())
select u).FirstOrDefault();
//添加数据
ps_logs logs = new ps_logs()
{
userCode = user.userCode,
userName = user.userName,
operateDateTime = DateTime.Now,
operateInfo = "退出系统"
};
bool b = true;
try
{
medc.SubmitChanges();
}
catch (Exception)
{
b = false;
}
return(Json(b, JsonRequestBehavior.AllowGet));
}
//验证登录
public ActionResult CheckLogin()
{
//获得用户名和密码
string userid = Request.Params["userid"];
string userpwd = Request.Params["userpwd"];
MyElectrCheck_DBDataContext medc = new MyElectrCheck_DBDataContext();
var result = (from u in medc.ps_user
where u.userCode == userid && u.userPassword == userpwd
select u).FirstOrDefault();
string b = "false";
if (result != null)
{
if (result.userStatus == 1)
{
b = "true";
Session["userid"] = result.id;
Session["userCode"] = result.userCode;
Session["roleid"] = result.roleId;
//修改数据
result.lastLoginTime = DateTime.Now;
result.lastUpdateTime = DateTime.Now;
try
{
medc.SubmitChanges();
}
catch (Exception)
{
b = "false";
}
if (b == "true")
{
//添加logo日志
ps_logs logs = new ps_logs()
{
userCode = result.userCode,
userName = result.userName,
operateInfo = "登录系统",
operateDateTime = DateTime.Now
};
medc.ps_logs.InsertOnSubmit(logs);
//保存数据
medc.SubmitChanges();
}
}
else
{
b = "freeze";
}
}
return(Json(b));
}
//修改用户信息的action
public ActionResult UpdUser()
{
int id = int.Parse(Request.Params["uid"]);
string userid = Request.Params["userid"];
string username = Request.Params["username"];
string userpwd = Request.Params["userpwd"];
string roleid = Request.Params["roleid"];
DateTime overdate = Convert.ToDateTime(Request.Params["overdate"]);
DateTime outdate = Convert.ToDateTime(Request.Params["outdate"]);
int status = int.Parse(Request.Params["status"]);
var role = (from r in medc.ps_role
where r.roleName == roleid
select r).FirstOrDefault();
var user = (from u in medc.ps_user
where u.id == id
select u).FirstOrDefault();
//获得session中保存的值
int usersid = int.Parse(Session["userid"].ToString());
var pu = (from u in medc.ps_user
where u.id == usersid
select u).FirstOrDefault();
//修改数据
user.userCode = userid;
user.userName = username;
user.userPassword = userpwd;
user.roleId = role.id;
user.entryDate = overdate;
user.dimissionDate = outdate;
user.userStatus = status;
bool b = true;
try
{
//保存数据
medc.SubmitChanges();
ps_logs logs = new ps_logs()
{
userCode = pu.userCode,
userName = pu.userName,
operateInfo = "修改用户信息",
operateDateTime = DateTime.Now
};
medc.ps_logs.InsertOnSubmit(logs);
medc.SubmitChanges();
}
catch (Exception)
{
b = false;
}
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));
}
//删除数据
public ActionResult DelData()
{
string rid = Request.Params["roleid"];
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();
var role = (from u in medc.ps_role
where u.id == rid
select u).FirstOrDefault();
bool b = true;
medc.ps_role.DeleteOnSubmit(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));
}
public ActionResult DelData()
{
int id = int.Parse(Request.Params["userid"]);
var user = (from u in medc.ps_user
where u.id == id
select u).FirstOrDefault();
//获得session中保存的值
int usersid = int.Parse(Session["userid"].ToString());
var pu = (from u in medc.ps_user
where u.id == usersid
select u).FirstOrDefault();
//删除对象
medc.ps_user.DeleteOnSubmit(user);
bool b = true;
try
{
medc.SubmitChanges();
ps_logs logs = new ps_logs()
{
userCode = pu.userCode,
userName = pu.userName,
operateInfo = "删除用户信息",
operateDateTime = DateTime.Now
};
medc.ps_logs.InsertOnSubmit(logs);
medc.SubmitChanges();
}
catch (Exception)
{
b = false;
}
return(Json(b));
}
//添加用户信息
public ActionResult AddUser()
{
string userid = Request.Params["userid"];
string username = Request.Params["username"];
string userpwd = Request.Params["userpwd"];
string roleid = Request.Params["roleid"];
DateTime?overdate = null;
if (Request.Params["overdate"] != "")
{
overdate = Convert.ToDateTime(Request.Params["overdate"]);
}
DateTime?outdate = null;
if (Request.Params["overdate"] != "")
{
overdate = Convert.ToDateTime(Request.Params["overdate"]);
}
int status = int.Parse(Request.Params["status"]);
//获取session中的值
//获得session中保存的值
int id = int.Parse(Session["userid"].ToString());
var pu = (from u in medc.ps_user
where u.id == id
select u).FirstOrDefault();
ps_user user = new ps_user()
{
userCode = userid,
userName = username,
userPassword = userpwd,
sex = null,
age = null,
entryDate = overdate,
dimissionDate = outdate,
phoneTel = null,
email = null,
creationTime = DateTime.Now,
lastLoginTime = DateTime.Now,
createdBy = pu.userCode,
lastUpdateTime = DateTime.Now,
userStatus = status,
roleId = roleid
};
//添加到数据库
medc.ps_user.InsertOnSubmit(user);
bool b = true;
try
{
medc.SubmitChanges();
ps_logs logs = new ps_logs()
{
userCode = pu.userCode,
userName = pu.userName,
operateInfo = "添加用户信息",
operateDateTime = DateTime.Now
};
medc.ps_logs.InsertOnSubmit(logs);
medc.SubmitChanges();
}
catch (Exception)
{
b = false;
}
return(Json(b));
}
