/// <summary>
/// 向该角色添加一个已有的用户
/// </summary>
/// <param name="roleName"></param>
/// <param name="userID"></param>
/// <returns></returns>
public int AddExitUser(string roleName,int userID)
{
using (CarSaleEntities context = new CarSaleEntities())
{
var role = context.Role.FirstOrDefault(r => r.RoleName == roleName);
RoleUserInfo newitem = new RoleUserInfo();
newitem.RoleID = role.ID;
newitem.UserID = userID;
context.AddToRoleUserInfo(newitem);
context.SaveChanges();
return 1;
}
}
/// <summary>
/// 在角色分配页面向该角色添加一个用户，RoleUserInfo表，UserInfo表都要新增一条记录
/// </summary>
/// <returns></returns>
public int AddUser(string roleName,string userName,string realName)
{
CarSaleEntities context=new CarSaleEntities();
UserInfoBll bll=new UserInfoBll();
bll.AddUserInfo(userName, realName, "123456", " ", " ", " ", " ", " ", 1, " ");
var user = context.UserInfo.FirstOrDefault(u => u.UserName == userName);
var role = context.Role.FirstOrDefault(r => r.RoleName == roleName);
RoleUserInfo newitem=new RoleUserInfo();
newitem.RoleID = role.ID;
newitem.UserID = user.ID;
context.AddToRoleUserInfo(newitem);
context.SaveChanges();
return 1;
}
/// <summary>
/// 已出售的车辆状态修改为“已售”
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int ChageCarStatusToSold(int id)
{
try
{
CarSaleEntities context = new CarSaleEntities();
var car = context.Car.FirstOrDefault(c => c.ID == id);
car.Statu = "已售";
context.SaveChanges();
return 1;
}
catch (Exception)
{
return 0;
}
}
/// <summary>
/// 根据传来的id删除用户的权限
/// </summary>
/// <returns></returns>
public int RemoveRoleUserInfo(int id)
{
using (CarSaleEntities context=new CarSaleEntities())
{
var item = context.RoleUserInfo.FirstOrDefault(r => r.ID == id);
context.DeleteObject(item);
context.SaveChanges();
return 1;
}
}