/// <summary>
/// 根据主键删除 T_UserRole 表数据
/// </summary>
/// <param name=id>主键</param>
public bool Delete(System.Int64 id)
{
T_UserRole info = new T_UserRole();
info.URId = id;
return(dal.Delete(info));
}
public ActionResult AddUserRole(T_UserRole userrole)
{
T_UserRole ur = new T_UserRole();
var ure = _iuserrole.LoadEntities(u => u.UserID == userrole.UserID);
foreach (var userr in ure)
{
if (userr.RoleID == userrole.RoleID)
{
return(Content("Failed"));
}
}
var userre = _iuserrole.LoadEntities(u => u.SID > 0);
List <int> urole = new List <int>();
foreach (var i in userre)
{
urole.Add(i.SID);
}
int maxid = urole.Max();
ur.SID = maxid + 1;
ur.UserID = userrole.UserID;
ur.RoleID = userrole.RoleID;
var EntityUserRole = _iuserrole.AddEntities(ur);
if (EntityUserRole != null)
{
return(Content("OK"));
}
else
{
return(Content("添加失败哦！"));
}
}
public ActionResult Login(string userName, string password)
{
Admins user = db.Admins.Where(item => item.AdminName == userName && item.Password == password && item.LoginState == 0).FirstOrDefault();
if (user != null)
{
T_UserRole ur = db.T_UserRole.Where(o => o.UserID == user.Id).FirstOrDefault();
UserData userData = new UserData();
userData.UserId = user.Id;
userData.UserName = user.AdminName;
userData.Password = user.Password;
userData.CompanyId = user.CompanyID;
if (ur.RoleID == 4)
{
userData.Identity = "设计师";
}
else
{
userData.Identity = "业务员";
}
return(Json(new { state = "success", data = userData }));
}
else
{
return(Json(new { state = "error" }));
}
}
public bool SetUserInfoRole(string userID, List <int> roleIDList)
{
//首先根据用户ID，查询出用户的信息
var currentUser = user.LoadEntities(c => c.UserID == userID).FirstOrDefault();
if (currentUser == null)
{
return(false);
}
//得到角色表中的数据全部返回
var listRoles = currentUser.T_UserRole.ToList();
///处理清空原来的数据，用户的和角色的中间表信息
for (int i = 0; i < listRoles.Count; i++)
{
userrole.DeleteEntities(listRoles[i]);
}
//在此重新将数据加载会数据库
foreach (var roleID in roleIDList)
{
T_UserRole rUserInfoRole = new T_UserRole();
rUserInfoRole.RoleID = roleID;
rUserInfoRole.UserID = userID;
userrole.AddEntities(rUserInfoRole);
}
return(true);
}
/// <summary>
/// 根据主键查询一个实体
/// </summary>
/// <param name=id>主键</param>
public T_UserRole SelectForID(System.Int64 id)
{
T_UserRole info = new T_UserRole();
info.URId = id;
dal.SelectForID(info);
return(info);
}
public override void Update(FormCollection formInfo)
{
T_User user = userService.GetUserInfo(formInfo);
userService.Update(user);
T_UserRole ur = userService.GetEditUserRoleInfo(formInfo);
urService.Update(ur);
}
public T_UserRole GetNewUserRoleInfo(FormCollection formInfo)
{
T_UserRole ur = new T_UserRole
{
UserId = dao.GetInsertId(),
RoleId = Convert.ToInt32(formInfo["RoleID"])
};
return(ur);
}
public T_UserRole GetEditUserRoleInfo(FormCollection formInfo)
{
T_UserRole ur = new T_UserRole
{
UserId = Convert.ToInt32(formInfo["ID"]),
RoleId = Convert.ToInt32(formInfo["RoleID"])
};
return(ur);
}
public override void Create(FormCollection formInfo)
{
//TODO： 提交前判断用户名是否重复
T_User user = userService.GetUserInfo(formInfo);
userService.Create(user);
T_UserRole userRole = userService.GetNewUserRoleInfo(formInfo);
urService.Create(userRole);
T_UserCache userCache = userService.GetNewUserNodeInfo(formInfo);
unService.Create(userCache);
}
/// <summary>
/// 根据主键修改 T_UserRole 表数据
/// </summary>
/// <param name=info>T_UserRole 实体对象</param>
public bool Update(T_UserRole info)
{
return(dal.Update(info));
}
/// <summary>
/// 新增 T_UserRole 表数据
/// </summary>
/// <param name=info>T_UserRole 实体对象</param>
public bool Insert(T_UserRole info)
{
return(dal.Insert(info));
}
