/// <summary>
/// 新增
/// </summary>
/// <returns></returns>
public ActionResult AddInfo(string Role_Code, string Role_Name)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
var ro = hee.T_Role.Where(o => o.Role_Code == Role_Code).FirstOrDefault();
if (ro == null)
{
T_Role tc = new T_Role();
tc.Role_Code = Role_Code;
tc.Role_Name = Role_Name;
hee.T_Role.Add(tc);
hee.SaveChanges();
rd.IsSuccess = "1";
rd.MessageString = "信息新增成功!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "RoleController-AddInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
else
{
rd.IsSuccess = "0";
rd.MessageString = "角色编码已存在!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "RoleController-AddInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
}
}
/// <summary>
/// 修改保存
/// </summary>
/// <param name="ID"></param>
/// <param name="Questionnaire_Name"></param>
/// <returns></returns>
public ActionResult SaveInfo(int ID, string Role_Code, string Role_Name)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
var em = hee.T_Role.Where(o => o.ID == ID).FirstOrDefault();
if (em != null)
{
em.Role_Code = Role_Code;
em.Role_Name = Role_Name;
hee.SaveChanges();
rd.IsSuccess = "1";
rd.MessageString = "信息修改成功!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "RoleController-SaveInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
else
{
rd.IsSuccess = "0";
rd.MessageString = "信息修改出错!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "RoleController-SaveInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
}
}
/// <summary>
/// 编辑查询
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public ActionResult Edit2(int ID)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
var em = hee.T_User.Where(o => o.ID == ID).FirstOrDefault();
if (em != null)
{
ViewBag.ID = em.ID;
ViewBag.User_Name = em.User_Name;
ViewBag.Chinese_Name = em.Chinese_Name;
ViewBag.Company_Name = em.Company_Name;
ViewBag.Department_Name = em.Department_Name;
ViewBag.Position_Name = em.Position_Name;
var comList = hee.T_Company.ToList();
ViewBag.comList = comList;
if (comList.Count > 0)
{
string companyName = comList.FirstOrDefault().Company_Name;
if (!companyName.Equals(""))
{
var depList = hee.T_Department.Where(o => o.Company_Name.Equals(companyName))
.ToList();
ViewBag.depList = depList;
}
}
}
}
return(View());
}
public ActionResult SaveRolePermission(int ID, string authids)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
var rpList = hee.T_Role_Permission.Where(o => o.Role_ID == ID).ToList();
if (rpList.Count > 0)
{
hee.T_Role_Permission.RemoveRange(rpList);
}
var peCode = authids.Split(new char[1] {
','
});
foreach (var code in peCode)
{
T_Role_Permission rp = new T_Role_Permission();
rp.Permission_Code = code;
rp.Role_ID = ID;
hee.T_Role_Permission.Add(rp);
}
hee.SaveChanges();
rd.IsSuccess = "1";
rd.MessageString = "权限保存成功!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "RoleController-RolePermission", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public ActionResult DelInfo(int ID)
{
ReturnData rd = new ReturnData();
using (LFAdminEntities hee = new LFAdminEntities())
{
var em = hee.T_User.Where(o => o.ID == ID).FirstOrDefault();
if (em != null)
{
hee.T_User.Remove(em);
hee.SaveChanges();
rd.IsSuccess = "1";
rd.MessageString = "信息删除成功!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "UserController-DelInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
else
{
rd.IsSuccess = "0";
rd.MessageString = "信息删除出错!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "UserController-DelInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
}
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="username"></param>
/// <param name="employeename"></param>
/// <param name="companyname"></param>
/// <param name="depertmentname"></param>
/// <param name="positionname"></param>
/// <returns></returns>
public ActionResult SavePassword(string username, string password1, string password2)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
var em = hee.T_User.Where(o => o.User_Name == username && o.Password == password1).FirstOrDefault();
if (em != null)
{
em.Password = password2;
hee.SaveChanges();
rd.IsSuccess = "1";
rd.MessageString = "密码修改成功!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "UserController-SavePassword", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
else
{
rd.IsSuccess = "0";
rd.MessageString = "账号 :" + username + "的密码不正确!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "UserController-SavePassword", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
}
}
public ActionResult Add2()
{
//int j = 0;
//int i = 8 / j;
using (LFAdminEntities hee = new LFAdminEntities())
{
var comList = hee.T_Company.ToList();
ViewBag.comList = comList;
if (comList.Count > 0)
{
string companyName = comList.FirstOrDefault().Company_Name;
if (!companyName.Equals(""))
{
var depList = hee.T_Department.Where(o => o.Company_Name.Equals(companyName))
.ToList();
ViewBag.depList = depList;
}
}
}
return(View());
}
//修改个人信息
public ActionResult SaveInfo(string username, string employeename, string Company_Name, string Department_Name, string positionname)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
var em = hee.T_User.Where(o => o.User_Name == username).FirstOrDefault();
if (em != null)
{
em.Chinese_Name = employeename;
em.Company_Name = Company_Name;
em.Department_Name = Department_Name;
em.Position_Name = positionname;
hee.SaveChanges();
rd.IsSuccess = "1";
rd.MessageString = "信息修改成功!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "UserController-SaveInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
else
{
rd.IsSuccess = "0";
rd.MessageString = "查询账号 :" + username + "信息时出错!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "UserController-SaveInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
}
}
/// <summary>
/// 重置密码
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public ActionResult ResetInfo(int ID)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
var em = hee.T_User.Where(o => o.ID == ID).FirstOrDefault();
if (em != null)
{
em.Password = BaseVariable.defaultPassword;
hee.SaveChanges();
rd.IsSuccess = "1";
rd.MessageString = "密码重置为" + em.Password + "成功!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "UserController-ResetInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
else
{
rd.IsSuccess = "0";
rd.MessageString = "密码重置出错!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "UserController-ResetInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
}
}
public ActionResult LoginOn(string username, string pasword)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
//var emlist = hee.T_User.ToList();
var em = hee.T_User.Where(o => o.User_Name == username).FirstOrDefault();
if (em != null)
{
var em2 = hee.T_User.Where(o => o.User_Name == username && o.Password == "").FirstOrDefault();
if (em2 != null)
{
LoggerHelper.Info("账号 :" + username + ",首次登录,需先设置密码!");
rd.IsSuccess = "0";
rd.MessageString = "首次登录,需先设置密码,请联系管理员!";
return(new JsonResult {
Data = rd
});
}
else
{
var em3 = hee.T_User.Where(o => o.User_Name == username && o.Password == pasword).FirstOrDefault();
if (em3 != null)
{
LoggerHelper.Info("账号 :" + username + ",登录成功!");
rd.IsSuccess = "1";
Session.Add("IsLogin", "True"); //登录状态
Session.Add("JGLoginAccount", username); //账号
Session.Add("JGLoginAccountID", em3.ID); //ID
Session.Add("JGLoginAccountName", em3.Chinese_Name.ToString()); //姓名
Session.Add("JGLoginCompanyName", em3.Company_Name.ToString()); //公司名称
Session.Add("JGIsCompany", em3.Is_Company); //是否集团
return(new JsonResult {
Data = rd
});
}
else
{
LoggerHelper.Info("账号 :" + username + ",登录失败,密码不正确!");
rd.IsSuccess = "0";
rd.MessageString = "账号 : " + username + ",登录失败,密码不正确!";
return(new JsonResult {
Data = rd
});
}
}
}
else
{
LoggerHelper.Info("账号 :" + username + " 不存在,登录失败!");
rd.IsSuccess = "0";
rd.MessageString = "账号 :" + username + " 不存在,登录失败!";
return(new JsonResult {
Data = rd
});
}
}
}
public string getList <T>(int page, int limit, Object obj)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
//var emList = hee.obj.ToList();
//if (emList.Count > 0)
//{
// if (!string.IsNullOrEmpty(company))
// {
// emList = emList.Where(o => o.Company_Name.Contains(company)).ToList();
// }
// if (!string.IsNullOrEmpty(depertment))
// {
// emList = emList.Where(o => o.Department_Name.Contains(depertment)).ToList();
// }
// if (!string.IsNullOrEmpty(employee))
// {
// emList = emList.Where(o => o.Chinese_Name.Contains(employee)).ToList();
// }
// rl.code = 0;
// rl.msg = "";
// int rowCount = emList.Count;
// rl.count = rowCount;
// //通过计算，得到分页应该需要分几页，其中不满一页的数据按一页计算
// if (rowCount % limit != 0)
// {
// rowCount = rowCount / limit + 1;
// }
// else
// {
// rowCount = rowCount / limit;
// }
// emList = emList.Skip((page - 1) * limit).Take(limit).ToList();
// rl.data = emList;
// var strResult = JsonConvert.SerializeObject(rl);
// return strResult;
// //return Json(strResult, JsonRequestBehavior.AllowGet);
//}
//else
//{
// rl.code = 1;
// rl.msg = "查询结果为空!";
// LoggerHelper.Error(Session["JGLoginAccountID"].ToString(), "UserController-getList", rl.msg);
// var strResult = JsonConvert.SerializeObject(rl);
// return strResult;
// //return Json(strResult, JsonRequestBehavior.AllowGet);
//}
return(null);
}
}
/// <summary>
/// 保存用户角色
/// </summary>
/// <param name="ID">用户ID</param>
/// <param name="Role_Name">角色名称</param>
/// <param name="Role_ID">角色ID</param>
/// <returns></returns>
public ActionResult SaveRole(int ID, int Role_ID)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
var turList = hee.T_User_Role.Where(o => o.User_ID == ID).ToList();
if (turList.Count > 0)
{
hee.T_User_Role.RemoveRange(turList);
}
//保存用户角色
T_User_Role ur = new T_User_Role();
ur.Role_ID = Role_ID;
ur.User_ID = ID;
hee.T_User_Role.Add(ur);
//保存用户角色名称
var user = hee.T_User.Where(o => o.ID == ID).FirstOrDefault();
if (user != null)
{
var ro = hee.T_Role.Where(o => o.ID == Role_ID).FirstOrDefault();
if (ro != null)
{
user.Role_Name = ro.Role_Name;
}
}
//保存用户权限
var rpList = hee.T_Role_Permission.Where(o => o.Role_ID == Role_ID).ToList();
if (rpList.Count() > 0)
{
var upList = hee.T_User_Permission.Where(o => o.User_ID == ID).ToList();
if (upList.Count() > 0)
{
hee.T_User_Permission.RemoveRange(upList);
}
foreach (var rp in rpList)
{
T_User_Permission up = new T_User_Permission();
up.User_ID = ID;
up.Rule_Code = rp.Permission_Code;
hee.T_User_Permission.Add(up);
}
}
hee.SaveChanges();
rd.IsSuccess = "1";
rd.MessageString = "权限保存成功!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "UserController-SaveRole", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
}
public ActionResult RolePermission(int ID)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
var tc = hee.T_Role.Where(o => o.ID == ID).FirstOrDefault();
if (tc != null)
{
ViewBag.Role = tc;
}
}
return(View());
}
public ActionResult AddRole(int ID)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
ViewBag.ID = ID;
var roleList = hee.T_Role.ToList();
if (roleList.Count() > 0)
{
ViewBag.RoleList = roleList;
}
}
return(View());
}
/// <summary>
/// 返回数据
/// </summary>
/// <returns></returns>
public string getList(int page, int limit, string Department, string Organization_Type)
{
try
{
using (LFAdminEntities hee = new LFAdminEntities())
{
var queList = hee.T_Role.ToList();
if (queList.Count > 0)
{
rl.code = 0;
rl.msg = "";
int rowCount = queList.Count;
rl.count = rowCount;
//通过计算，得到分页应该需要分几页，其中不满一页的数据按一页计算
if (rowCount % limit != 0)
{
rowCount = rowCount / limit + 1;
}
else
{
rowCount = rowCount / limit;
}
queList = queList.Skip((page - 1) * limit).Take(limit).ToList();
rl.data = queList;
var strResult = JsonConvert.SerializeObject(rl);
return(strResult);
}
else
{
rl.code = 1;
rl.msg = "查询结果为空!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "RoleController-getList", rl.msg);
var strResult = JsonConvert.SerializeObject(rl);
return(strResult);
}
}
}
catch (Exception ex)
{
rl.code = 1;
rl.msg = "查询数据失败 :" + ex.Message;
LoggerHelper.Error(Session["JGLoginAccountID"].ToString(), "RoleController-getList", rl.msg, ex);
var strResult = JsonConvert.SerializeObject(rl);
return(strResult);
}
}
//public ILoggerHelper LoggerHelper { get; }
//public IBaseVariable _baseVariable { get; }
//public HomeController(ILoggerHelper loggerHelper, IBaseVariable baseVariable)
//{
// LoggerHelper = loggerHelper;
// _baseVariable = baseVariable;
//}
#endregion
/// <summary>
/// 首页
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
ViewBag.EmployeeName = Session["JGLoginAccountName"];
int userid = Session["JGLoginAccountID"] != null?int.Parse(Session["JGLoginAccountID"].ToString()) : 0;
using (LFAdminEntities hee = new LFAdminEntities())
{
List <string> ruleList = hee.V_User_Permission.Where(o => o.User_ID == userid).Select(o => o.Rule_Code).ToList();
if (ruleList.Count > 0)
{
ViewBag.RuleList = ruleList;
}
}
return(View());
}
/// <summary>
/// 获取权限tree
/// </summary>
/// <returns></returns>
public ActionResult getTreeData(int ID)
{
TreeData td = new TreeData();
td.code = 0;
td.msg = "获取成功";
using (LFAdminEntities hee = new LFAdminEntities())
{
data dt = new data();
List <Nodes> NodesList = new List <Nodes>();
var tpList = hee.T_Permission.ToList();
foreach (var tp in tpList)
{
Nodes nd = new Nodes();
nd.id = tp.ID;
nd.name = tp.name;
nd.alias = tp.alias;
nd.palias = tp.palias;
NodesList.Add(nd);
}
var trpList = hee.T_Role_Permission.Where(o => o.Role_ID == ID).ToList();
List <string> aliasList = new List <string>();
foreach (var tp in NodesList)
{
if (trpList.Where(o => o.Permission_Code == tp.alias).FirstOrDefault() != null)
{
aliasList.Add(tp.alias);
}
}
dt.checkedAlias = aliasList;
//dt.disabledAlias = li;
dt.list = NodesList;
td.data = dt;
}
return(new JsonResult {
Data = td
});
}
/// <summary>
/// 删除
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public ActionResult DelInfo(int ID)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
var em = hee.T_Role.Where(o => o.ID == ID).FirstOrDefault();
if (em != null)
{
var urList = hee.T_User_Role.Where(o => o.Role_ID == ID).ToList();
if (urList.Count > 0)
{
rd.IsSuccess = "0";
rd.MessageString = "该角色已绑定用户,请解绑后删除!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "RoleController-DelInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
hee.T_Role.Remove(em);
hee.SaveChanges();
rd.IsSuccess = "1";
rd.MessageString = "信息删除成功!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "RoleController-DelInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
else
{
rd.IsSuccess = "0";
rd.MessageString = "信息删除出错!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "RoleController-DelInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="ID"></param>
/// <param name="Phone"></param>
/// <param name="Employee_Name"></param>
/// <param name="Company_Name"></param>
/// <param name="Department_Name"></param>
/// <param name="Position_Name"></param>
/// <returns></returns>
public ActionResult AddInfo(string User_Name, string Chinese_Name, string Company_Name, string Department_Name, string Position_Name)
{
using (LFAdminEntities hee = new LFAdminEntities())
{
T_User em = new T_User();
em.User_Name = User_Name;
em.Chinese_Name = Chinese_Name;
em.Company_Name = Company_Name;
em.Department_Name = Department_Name;
em.Position_Name = Position_Name;
em.Password = BaseVariable.defaultPassword;
em.Is_Company = false;
hee.T_User.Add(em);
hee.SaveChanges();
rd.IsSuccess = "1";
rd.MessageString = "信息新增成功!";
LoggerHelper.Info(Session["JGLoginAccountID"].ToString(), "UserController-AddInfo", rd.MessageString);
return(new JsonResult {
Data = rd
});
}
}
/// <summary>
/// 查看 个人信息
/// </summary>
/// <returns></returns>
public ActionResult Edit()
{
string username = Session["JGLoginAccount"] != null ? Session["JGLoginAccount"].ToString() : "";
if (!string.IsNullOrEmpty(username))
{
ViewBag.UserName = username;
using (LFAdminEntities hee = new LFAdminEntities())
{
var em = hee.T_User.Where(o => o.User_Name == username).FirstOrDefault();
if (em != null)
{
ViewBag.Chinese_Name = em.Chinese_Name;
ViewBag.Company_Name = em.Company_Name;
ViewBag.Department_Name = em.Department_Name;
ViewBag.Position_Name = em.Position_Name;
}
}
}
return(View());
}
public SysUserRepository(LFAdminEntities db)
{
this.db = db;
}
