public void UpdateAdminUser(long id, string name, string phoneNum, string password, string email, long?cityId)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
BaseService <AdminUserEntity> bs
= new BaseService <AdminUserEntity>(ctx);
var user = bs.GetById(id);
if (user == null)
{
throw new ArgumentException("找不到id=" + id + "的管理员");
}
user.Name = name;
user.PhoneNum = phoneNum;
user.Email = email;
if (!string.IsNullOrEmpty(password))
{
user.PasswordHash =
CommonHelper.CalcMD5(user.PasswordSalt + password);
}
user.CityId = cityId;
ctx.SaveChanges();
}
}
//2,3,4
//3,4,5
public void UpdatePermIds(long roleId, long[] permIds)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
BaseService <RoleEntity> roleBS
= new BaseService <RoleEntity>(ctx);
var role = roleBS.GetById(roleId);
if (role == null)
{
throw new ArgumentException("roleId不存在" + roleId);
}
role.Permissions.Clear();
BaseService <PermissionEntity> permBS
= new BaseService <PermissionEntity>(ctx);
var perms = permBS.GetAll()
.Where(p => permIds.Contains(p.Id)).ToList();
foreach (var perm in perms)
{
role.Permissions.Add(perm);
}
ctx.SaveChanges();
}
}
public void AddRoleIds(long adminUserId, long[] roleIds)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
BaseService <AdminUserEntity> adminBS = new BaseService <AdminUserEntity>(ctx);
AdminUserEntity user = adminBS.GetById(adminUserId);
if (user == null)
{
throw new ArgumentException("用户不存在" + adminUserId);
}
if (roleIds != null)
{
BaseService <RoleEntity> roleBS = new BaseService <RoleEntity>(ctx);
var roles = roleBS.GetAll().Where(u => roleIds.Contains(u.Id)).ToArray();
foreach (var role in roles)
{
user.Roles.Add(role);
}
}
ctx.SaveChanges();
}
}
public long AddNew(string phoneNum, string password)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
//检查手机号不能重复
BaseService <UserEntity> bs = new BaseService <UserEntity>(ctx);
bool exists = bs.GetAll().Any(u => u.PhoneNum == phoneNum);
if (exists)
{
throw new ArgumentException("手机号已经存在");
}
UserEntity user = new UserEntity();
user.PhoneNum = phoneNum;
string salt = CommonHelper.CreateVerifyCode(5);
string pwdHash = CommonHelper.CalcMD5(salt + password);
user.PasswordHash = pwdHash;
user.PasswordSalt = salt;
ctx.Users.Add(user);
ctx.SaveChanges();
return(user.Id);
}
}
/// <summary>
/// 根据roleId更新角色名称
/// </summary>
/// <param name="roleId"></param>
/// <param name="roleName"></param>
public void Update(long roleId, string roleName)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
BaseService <RoleEntity> bs = new BaseService <RoleEntity>(ctx);
var role = bs.GetAll().ToList().SingleOrDefault(r => r.Name == roleName && r.Id == roleId);
//正常情况不应该执行这个异常，因为UI层应该把这些情况处理好
//这里只是“把好最后一关”
if (role == null)
{
throw new ArgumentException("不存在" + roleId + "角色");
}
/*role.Name = roleName;
* ctx.Roles.Add(role);
* ctx.SaveChanges();*/
RoleEntity roleentity = new Entities.RoleEntity();
roleentity.Id = roleId;
ctx.Entry(role).State = EntityState.Unchanged;
role.Name = roleName;
ctx.SaveChanges();
}
}
public void AddPermIds(long roleId, long[] permIds)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
BaseService <RoleEntity> roleBS = new BaseService <RoleEntity>(ctx);
var role = roleBS.GetById(roleId);
if (role == null)
{
throw new ArgumentException("roleId不存在 " + roleId);
}
if (permIds != null)
{
BaseService <PermissionEntity> permissionBS = new BaseService <PermissionEntity>(ctx);
var pers = permissionBS.GetAll().Where(u => permIds.Contains(u.Id)).ToArray();
foreach (var per in pers)
{
role.Permissions.Add(per);
}
}
ctx.SaveChanges();
}
}
public long AddNew(string cityName)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <CityEntity> bs
= new CommonService <CityEntity>(ctx);
//判断是否存在任何一条数据满足 c.Name == cityName
//即存在这样一个名字的城市
//如果只是判断“是否存在”，那么用Any效率比Where().count()效率高
//Where(c => c.Name == cityName).Count()>0
var datas = bs.GetAll();
bool exists = datas.Any(c => c.Name == cityName);
if (exists)
{
throw new ArgumentException("城市已经存在");
}
CityEntity city = new CityEntity();
city.Name = cityName;
ctx.Cities.Add(city);
ctx.SaveChanges();
return(city.Id);
}
}
public long AddNew(HouseAddNewDTO house)
{
HouseEntity houseEntity = new HouseEntity();
houseEntity.Address = house.Address;
houseEntity.Area = house.Area;
using (ZSZDbContext ctx = new ZSZDbContext())
{
BaseService <AttachmentEntity> attbs
= new BaseService <AttachmentEntity>(ctx);
//拿到house.AttachmentIds为主键的房屋配套设施
var atts = attbs.GetAll().Where(a => house.AttachmentIds.Contains(a.Id));
foreach (var att in atts)
{
houseEntity.Attachments.Add(att);
}
houseEntity.CheckInDateTime = house.CheckInDateTime;
houseEntity.CommunityId = house.CommunityId;
houseEntity.DecorateStatusId = house.DecorateStatusId;
houseEntity.Description = house.Description;
houseEntity.Direction = house.Direction;
houseEntity.FloorIndex = house.FloorIndex;
//houseEntity.HousePics 新增后再单独添加
houseEntity.LookableDateTime = house.LookableDateTime;
houseEntity.MonthRent = house.MonthRent;
houseEntity.OwnerName = house.OwnerName;
houseEntity.OwnerPhoneNum = house.OwnerPhoneNum;
houseEntity.RoomTypeId = house.RoomTypeId;
houseEntity.StatusId = house.StatusId;
houseEntity.TotalFloorCount = house.TotalFloorCount;
houseEntity.TypeId = house.TypeId;
ctx.Houses.Add(houseEntity);
ctx.SaveChanges();
return(houseEntity.Id);
}
}