public void RecordLoginError(long id)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <AdminUserEntity> cs = new CommonService <AdminUserEntity>(ctx);
AdminUserEntity user = cs.GetById(id);
if (user == null)
{
throw new ArgumentException("用户不存在" + id);
}
user.LoginErrorTimes++;
user.LastLoginErrorDateTime = DateTime.Now;
ctx.SaveChanges();
}
}
public long AddNewCommunitity(string name, long regionId, string location, string traffic, int?buildYear)
{
CommunitityEntity communitity = new CommunitityEntity();
communitity.BuiltYear = buildYear;
communitity.Location = location;
communitity.Name = name;
communitity.RegionId = regionId;
communitity.Traffic = traffic;
using (ZSZDbContext ctx = new ZSZDbContext())
{
ctx.Communitities.Add(communitity);
ctx.SaveChanges();
return(communitity.Id);
}
}
public bool MarkDeleted(long id)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <AdminUserEntity> cs = new CommonService <AdminUserEntity>(ctx);
AdminUserEntity adminUser = cs.GetById(id);
if (adminUser != null)
{
adminUser.IsDelete = true;
ctx.SaveChanges();
return(true);
}
return(false);
}
}
public void ResetLoginError(long id)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <UserEntity> userService = new CommonService <UserEntity>(ctx);
var user = userService.GetById(id);
if (user == null)
{
throw new ArgumentException("用户不存在" + id);
}
user.LoginErrorTimes = 0;
user.LastLoginErrorDateTime = null;
ctx.SaveChanges();
}
}
public long AddNewHouseAppointment(long?userId, string name, string phoneNum, DateTime visiDate, long houseId)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
HouseAppointmentEntity houseAppointment = new HouseAppointmentEntity();
houseAppointment.UserId = userId;
houseAppointment.Name = name;
houseAppointment.PhoneNum = phoneNum;
houseAppointment.VisitDate = visiDate;
houseAppointment.HouseId = houseId;
houseAppointment.Status = "未处理";
ctx.HouseAppointments.Add(houseAppointment);
ctx.SaveChanges();
return(houseAppointment.Id);
}
}
public void UpdatePermission(long id, string name, string description)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <PermissionEntity> service = new CommonService <PermissionEntity>(ctx);
var permission = service.GetById(id);
if (permission == null)
{
throw new ArgumentException("权限不存在" + id);
}
permission.Name = name;
permission.Description = description;
ctx.SaveChanges();
}
}
public void UpdateHouse(HouseDTO houseDto)
{
HouseEntity houseEntity = ToEntity(houseDto);
using (ZSZDbContext ctx = new ZSZDbContext())
{
var house = ctx.Houses.SingleOrDefault(h => h.Id == houseDto.Id);
if (house == null)
{
throw new ArgumentException("房子信息不存在" + houseDto.Id);
}
house = houseEntity;
ctx.SaveChanges();
}
}
public long UpdateUser(string phoneNum, string password, long?cityId)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <UserEntity> userService = new CommonService <UserEntity>(ctx);
UserEntity user = userService.GetAll().Include(u => u.CityEntity).SingleOrDefault(u => u.PhoneNum == phoneNum);
if (user == null)
{
throw new Exception("用户不存在" + phoneNum);
}
user.PasswordSalt = WebCommonHelper.CreateVerifyCode(4);
user.PasswordHash = Common.CommonHelper.CalcMD5(user.PasswordSalt + password);
user.CityId = cityId;
ctx.SaveChanges();
return(user.Id);
}
}
public bool IsLocked(long id)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <UserEntity> userService = new CommonService <UserEntity>(ctx);
var user = userService.GetById(id);
if (user == null)
{
throw new ArgumentException("用户不存在" + id);
}
if (user.LoginErrorTimes >= 5 && user.LastLoginErrorDateTime > DateTime.Now.AddMinutes(-30))
{
return(true);
}
return(false);
}
}
public void UpdateAdminUser(long id, string name, string phoneNum, string email, long?cityId)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <AdminUserEntity> cs = new CommonService <AdminUserEntity>(ctx);
bool exists = cs.GetAll().Any(u => u.Id == id);
if (!exists)
{
throw new ArgumentException("用户不存在" + id);
}
var adminUser = cs.GetById(id);
adminUser.Name = name;
adminUser.PhoneNum = phoneNum;
adminUser.CityId = cityId;
adminUser.EMail = email;
ctx.SaveChanges();
}
}
public bool CheckLogin(string phoneNum, string userPwd)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <AdminUserEntity> cs = new CommonService <AdminUserEntity>(ctx);
AdminUserEntity adminUser = cs.GetAll().SingleOrDefault(a => a.PhoneNum == phoneNum);
if (adminUser == null)
{
return(false);
}
string pwd = Common.CommonHelper.CalcMD5(adminUser.PasswordSalt + userPwd);
if (pwd != adminUser.PasswordHash)
{
return(false);
}
return(true);
}
}
public void AddRoleIds(long adminUserId, long[] roleIds)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <AdminUserEntity> adminService = new CommonService <AdminUserEntity>(ctx);
AdminUserEntity adminUser = adminService.GetById(adminUserId);
if (adminUser == null)
{
throw new ArgumentException("管理员用户不存在！" + adminUserId);
}
CommonService <RoleEntity> roleService = new CommonService <RoleEntity>(ctx);
var roles = roleService.GetAll().Where(r => roleIds.Contains(r.Id)).Include(r => r.AdminUserEntities).Include(r => r.PermissionEntities);
foreach (RoleEntity role in roles.ToList())
{
adminUser.RoleEntities.Add(role);
}
ctx.SaveChanges();
}
}
public void AddPermIds(long roleId, long[] permIds)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <RoleEntity> service = new CommonService <RoleEntity>(ctx);
var role = service.GetById(roleId);
if (role == null)
{
throw new ArgumentException("角色不存在" + roleId);
}
CommonService <PermissionEntity> permCs = new CommonService <PermissionEntity>(ctx);
var permissions = permCs.GetAll().Where(p => permIds.Contains(p.Id)).ToList();
foreach (var permission in permissions)
{
//permission.RoleEntities.Add(role);
role.PermissionEntities.Add(permission);
}
ctx.SaveChanges();
}
}
public long AddNewUser(string phoneNum, string password, long?cityId)
{
UserEntity user = new UserEntity();
user.PhoneNum = phoneNum;
user.PasswordSalt = WebCommonHelper.CreateVerifyCode(4);
user.PasswordHash = Common.CommonHelper.CalcMD5(user.PasswordSalt + password);
user.CityId = cityId;
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <UserEntity> userService = new CommonService <UserEntity>(ctx);
bool exists = userService.GetAll().Any(u => u.PhoneNum == phoneNum);
if (exists)
{
throw new ArgumentException("手机号已存在" + phoneNum);
}
ctx.Users.Add(user);
ctx.SaveChanges();
return(user.Id);
}
}
public bool CheckLogin(string phoneNum, string userPwd)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <UserEntity> userService = new CommonService <UserEntity>(ctx);
UserEntity user = userService.GetAll().SingleOrDefault(u => u.PhoneNum == phoneNum);
if (user == null)
{
return(false);
}
string salt = user.PasswordSalt;
string password = Common.CommonHelper.CalcMD5(salt + userPwd);
if (password != user.PasswordHash)
{
return(false);
}
return(true);
}
}
public void UpdateAdminUser(long id, string name, string phoneNum, string password, string email, long?cityId)
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
CommonService <AdminUserEntity> cs = new CommonService <AdminUserEntity>(ctx);
bool exists = cs.GetAll().Any(u => u.Id == id);
if (!exists)
{
throw new ArgumentException("用户不存在" + id);
}
AdminUserEntity adminUser = cs.GetById(id);
adminUser.Name = name;
adminUser.PhoneNum = phoneNum;
string salt = Web.Common.WebCommonHelper.CreateVerifyCode(5);
adminUser.PasswordSalt = salt;
adminUser.CityId = cityId;
adminUser.EMail = email;
adminUser.PasswordHash = Common.CommonHelper.CalcMD5(salt + password);
ctx.SaveChanges();
}
}
public CommonService(ZSZDbContext ctx)
{
this.ctx = ctx;
}