public AttachmentDTO[] GetAttachments(long houseId) { using (ZSZDbContext ctx = new ZSZDbContext()) { CommonService <HouseEntity> houseBS = new CommonService <HouseEntity>(ctx); var house = houseBS.GetAll().Include(a => a.Attachments) .AsNoTracking().SingleOrDefault(h => h.Id.Equals(houseId)); if (house == null) { throw new ArgumentException("houseId" + houseId + "不存在"); } return(house.Attachments.Select(a => ToDTO(a)).ToArray()); } }
public void UpdatePermission(long id, string permName, string description) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <PermissionEntity> permBS = new BaseService <PermissionEntity>(ctx); var permission = permBS.GetById(id); if (permission == null) { throw new ArgumentException("permission不存在" + id); } permission.Name = permName; permission.Description = description; ctx.SaveChanges(); } }
public AdminUserDTO GetById(long id) { using (ZSZDbContext ctx = new ZSZDbContext()) { CommonService <AdminUserEntity> bs = new CommonService <AdminUserEntity>(ctx); var user = bs.GetAll().Include(u => u.City) .AsNoTracking().SingleOrDefault(u => u.Id.Equals(id)); //var user = bs.GetById(id); 没机会使用include了,DTO需要返回城市信息 if (user == null) { return(null);//不抛异常,由调用者决定处理方式 } return(ToDTO(user)); } }
/// <summary> /// 记录用户登录次数 /// </summary> /// <param name="id"></param> public long?IncrLoginError(long id) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <UserEntity> bs = new BaseService <UserEntity>(ctx); var user = bs.GetById(id); if (user == null) { throw new ArgumentException("用户不存在" + id); } user.LoginErrorTimes++; user.LastLoginErrorDateTime = DateTime.Now; ctx.SaveChanges(); return(user.LoginErrorTimes); } }
public long AddNew(long?userId, string name, string phoneNum, long houseId, DateTime visitDate) { using (ZSZDbContext ctx = new ZSZDbContext()) { HouseAppointmentEntity houseApp = new HouseAppointmentEntity(); houseApp.HouseId = houseId; houseApp.Name = name; houseApp.PhoneNum = phoneNum; houseApp.Status = "未处理"; houseApp.UserId = userId; houseApp.VisitDate = visitDate; ctx.HouseAppointments.Add(houseApp); ctx.SaveChanges(); return(houseApp.Id); } }
/// <summary> /// 更新用户的密码 /// </summary> /// <param name="userId"></param> /// <param name="newPassword"></param> public void UpdatePwd(long userId, string newPassword) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <UserEntity> bs = new BaseService <UserEntity>(ctx); var user = bs.GetById(userId); if (user == null) { throw new ArgumentException("用户id不存在" + userId); } string salt = user.PasswordSalt; string hash = Common.CommonHelper.CalMD5(salt + newPassword); user.PasswordHash = hash; ctx.SaveChanges(); } }
/* * private CommunityDTO ToDTO(CommunityEntity en) * { * CommunityDTO dto = new CommunityDTO(); * dto.bui * }*/ /// <summary> /// 根据区域id获得所有的小区 /// </summary> /// <param name="regionId">区域id</param> /// <returns></returns> public CommunityDTO[] GetByRegionId(long regionId) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <CommunityEntity> bs = new BaseService <CommunityEntity>(ctx); var cities = bs.GetAll().AsNoTracking() .Where(c => c.RegionId == regionId); //下面这段也可以to dto return(cities.Select(c => new CommunityDTO { BuiltYear = c.BuiltYear, CreateDateTime = c.CreateDateTime, Id = c.Id, Location = c.Location, Name = c.Name, RegionId = c.RegionId, Traffic = c.Traffic }).ToArray()); } }
public bool CheckLogin(string phoneNum, string password) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <AdminUserEntity> bs = new BaseService <AdminUserEntity>(ctx); var theUser = bs.GetAll().SingleOrDefault(u => u.PhoneNum == phoneNum); if (theUser == null) { return(false); } string dbHash = theUser.PasswordHash; string userHash = CommonHelper.CalcMD5(theUser.PasswordSalt + password); //与数据库数据比较是否一致 return(dbHash == userHash); } }
public void ResetLoginError(long id) { using (ZSZDbContext ctx = new ZSZDbContext()) { //检查手机号不能重复 BaseService <UserEntity> bs = new BaseService <UserEntity>(ctx); var user = bs.GetById(id); if (user == null) { throw new ArgumentException("用户不存在 " + id); } user.LoginErrorTimes = 0; user.LastLoginErrorDateTime = null; ctx.SaveChanges(); } }
/// <summary> /// 获得某个房子的所有的配套设施 /// </summary> /// <param name="houseId">房子的id</param> /// <returns></returns> public AttachmentDTO[] GetAttachments(long houseId) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <HouseEntity> houseBS = new BaseService <HouseEntity>(ctx); //先获id为houseId的房子延迟加载Attachments(房子的配套设施)的属性 var house = houseBS.GetAll().Include(a => a.Attachments) .AsNoTracking().SingleOrDefault(h => h.Id == houseId); if (house == null) { throw new ArgumentException("houseId" + houseId + "不存在"); } //一个房子有多个配套设施 return(house.Attachments.ToList().Select(a => ToDTO(a)).ToArray()); } }
public long AddNew(string cityName) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <CityEntity> bs = new BaseService <CityEntity>(ctx); var exist = bs.GetAll().Any(p => p.Name == cityName); if (exist) { throw new ArgumentException("城市已存在"); } CityEntity c = new CityEntity(); c.Name = cityName; ctx.Cities.Add(c); ctx.SaveChanges(); return(c.Id); } }
/// <summary> /// 新增城市 /// </summary> /// <param name="cityName"></param> /// <returns></returns> public long AddNew(string cityName) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <CityEntity> service = new BaseService <CityEntity>(ctx); bool exist = service.GetAll().Any(u => u.Name == cityName); if (exist) { throw new ArgumentException("城市名已存在"); } CityEntity city = new CityEntity(); city.Name = cityName; ctx.Cities.Add(city); ctx.SaveChanges(); return(city.Id); } }
public long AddNew(string cityName) { using (ZSZDbContext context = new ZSZDbContext()) { BaseService <CityEntity> service = new BaseService <CityEntity>(context); bool isExists = service.GetAll().Any(p => p.Name == cityName); if (isExists) { throw new AggregateException("城市已经存在!"); } CityEntity city = new CityEntity(); city.Name = cityName; context.Cities.Add(city); context.SaveChanges(); return(city.Id); } }
public string GetValue(string name) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <SettingEntity> bs = new BaseService <SettingEntity>(ctx); var setting = bs.GetAll().Where(s => s.Name == name).SingleOrDefault(); if (setting == null) { return(null); //throw new ArgumentException("配置项Name不存在"); } else { return(setting.Value); } } }
/// <summary> /// 新增房子的图片 /// </summary> /// <param name="housePic">图片的dto对象</param> /// <returns></returns> public long AddNewHousePic(HousePicDTO housePic) { HousePicEntity entity = new HousePicEntity(); //房子的id entity.HouseId = housePic.HouseId; //房子缩略图地址 entity.ThumbUrl = housePic.ThumbUrl; //房子图片地址 entity.Url = housePic.Url; using (ZSZDbContext ctx = new ZSZDbContext()) { ctx.HousePics.Add(entity); ctx.SaveChanges(); return(entity.Id); } }
public string GetValue(string name) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <SettingEntity> bs = new BaseService <SettingEntity>(ctx); var setting = bs.GetAll().AsNoTracking() .SingleOrDefault(s => s.Name == name); if (setting == null)//没有 { return(null); } else { return(setting.Value); } } }
public long AddNew(string roleName) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <RoleEntity> service = new BaseService <RoleEntity>(ctx); var exist = service.GetAll().Any(u => u.Name == roleName); if (exist) { throw new ArgumentException("角色名字已经存在" + roleName); } RoleEntity entity = new RoleEntity(); entity.Name = roleName; ctx.Roles.Add(entity); ctx.SaveChanges(); return(entity.Id); } }
public long AddNew(string roleName) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <RoleEntity> bs = new BaseService <RoleEntity>(ctx); bool exists = bs.GetAll().Any(r => r.Name == roleName); if (exists) { throw new ArgumentException("角色名字已经存在" + roleName); } RoleEntity role = new RoleEntity(); role.Name = roleName; ctx.Roles.Add(role); ctx.SaveChanges(); return(role.Id); } }
public HouseAppointmentDTO[] GetPagedData(long cityId, string status, int pageSize, int currentIndex) { using (ZSZDbContext ctx = new ZSZDbContext()) { CommonService <HouseAppointmentEntity> bs = new CommonService <HouseAppointmentEntity>(ctx); var apps = bs.GetAll().Include(a => a.House) .Include(nameof(HouseAppointmentEntity.House) + "." + nameof(HouseEntity.Community)) .Include(a => a.FollowAdminUser) .Include(nameof(HouseAppointmentEntity.House) + "." + nameof(HouseEntity.Community) + "." + nameof(CommunityEntity.Region)) .AsNoTracking() .Where(a => a.House.Community.Region.CityId == cityId && a.Status == status) .OrderByDescending(a => a.CreateDateTime) .Skip(currentIndex).Take(pageSize); return(apps.Select(a => ToDTO(a)).ToArray()); } }
public HousePicDTO[] GetPics(long houseId) { using (ZSZDbContext ctx = new ZSZDbContext()) { CommonService <HousePicEntity> bs = new CommonService <HousePicEntity>(ctx); return(bs.GetAll().AsNoTracking().Where(p => p.HouseId == houseId) .Select(p => new HousePicDTO { CreateDateTime = p.CreateDateTime, HouseId = p.HouseId, Id = p.Id, ThumbUrl = p.ThumbUrl, Url = p.Url }) .ToArray()); } }
public void Update(long roleId, string roleName) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <RoleEntity> bs = new BaseService <RoleEntity>(ctx); bool exists = bs.GetAll().Any(r => r.Name == roleName && r.Id != roleId); if (exists) { throw new ArgumentException("数据不正确"); } RoleEntity role = new RoleEntity(); role.Id = roleId; ctx.Entry(role).State = System.Data.Entity.EntityState.Unchanged; role.Name = roleName; ctx.SaveChanges(); } }
public bool CheckLogin(string phoneNum, string password) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <AdminUserEntity> bs = new BaseService <AdminUserEntity>(ctx); //除了错不可怕,最怕的是有错但是表面“风平浪静” var user = bs.GetAll().SingleOrDefault(u => u.PhoneNum == phoneNum); if (user == null) { return(false); } string dbHash = user.PasswordHash; string userHash = CommonHelper.CalcMD5(user.PasswordSalt + password); //比较数据库中的PasswordHash是否和MD5(salt+用户输入密码)一直 return(userHash == dbHash); } }
public long AddPermission(string permName, string description) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <PermissionEntity> permBS = new BaseService <PermissionEntity>(ctx); bool exists = permBS.GetAll().Any(p => p.Name == permName); if (exists) { throw new ArgumentException("权限项已经存在"); } PermissionEntity perm = new PermissionEntity(); perm.Description = description; perm.Name = permName; ctx.Permissions.Add(perm); ctx.SaveChanges(); return(perm.Id); } }
public HouseDTO[] GetAll() { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <HouseEntity> houseBS = new BaseService <HouseEntity>(ctx); var houses = houseBS.GetAll() .Include(h => h.Attachments).Include(h => h.Community) .Include(nameof(HouseEntity.Community) + "." + nameof(CommunityEntity.Region) + "." + nameof(RegionEntity.City)) .Include(nameof(HouseEntity.Community) + "." + nameof(CommunityEntity.Region)) .Include(h => h.DecorateStatus) .Include(h => h.HousePics) .Include(h => h.RoomType) .Include(h => h.Status) .Include(h => h.Type); return(houses.ToList().Select(h => ToDTO(h)).ToArray()); } }
public bool HasPermission(long adminUserId, string permissionName) { using (ZSZDbContext ctx = new ZSZDbContext()) { CommonService <AdminUserEntity> bs = new CommonService <AdminUserEntity>(ctx); //var user = bs.GetById(adminUserId);//没法使用include var user = bs.GetAll().Include(u => u.City).Single(u => u.Id.Equals(adminUserId)); if (user == null) { throw new ArgumentException("找不到id=" + adminUserId + "的用户"); } //Roles前面使用include连接查询出来了,不存在延迟加载 return(user.Roles.SelectMany(r => r.Permissions) .Any(p => p.Name == permissionName)); } }
public AdminUserDTO GetById(long id) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <AdminUserEntity> bs = new BaseService <AdminUserEntity>(ctx); //这里不能用bs.GetById(id);因为无法Include、AsNoTracking()等 var user = bs.GetAll().Include(u => u.City) .AsNoTracking().SingleOrDefault(u => u.Id == id); //.AsNoTracking().Where(u=>u.Id==id).SingleOrDefault(); //var user = bs.GetById(id); 用include就不能用GetById if (user == null) { return(null); } return(ToDTO(user)); } }
public HousePicDTO[] GetPics(long houseId) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <HousePicEntity> bs = new Service.BaseService <Entities.HousePicEntity>(ctx); var housePics = bs.GetAll().Where(h => h.HouseId == houseId); List <HousePicDTO> list = new List <HousePicDTO>(); foreach (var housePic in housePics) { HousePicDTO dto = new HousePicDTO(); dto.Url = housePic.Url; dto.ThumbUrl = housePic.Url; dto.Id = housePic.Id; list.Add(dto); } return(list.ToArray()); } }
public long AddPermission(string permName, string description) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <PermissionEntity> permissionBS = new BaseService <PermissionEntity>(ctx); var exist = permissionBS.GetAll().Any(u => u.Name == permName); if (exist) { throw new ArgumentException("权限项已经存在"); } PermissionEntity entity = new PermissionEntity(); entity.Name = permName; entity.Description = description; ctx.Permissions.Add(entity); ctx.SaveChanges(); return(entity.Id); } }
/// <summary> /// 修改前台用户的密码 /// </summary> /// <param name="userId"></param> /// <param name="newPassword"></param> public void UpdatePwd(long userId, string newPassword) { using (ZSZDbContext ctx = new ZSZDbContext()) { //检查手机号不能重复 BaseService <UserEntity> bs = new BaseService <UserEntity>(ctx); var user = bs.GetById(userId); if (user == null) { throw new ArgumentException("用户不存在 " + userId); } string salt = user.PasswordSalt;// CommonHelper.CreateVerifyCode(5); string pwdHash = CommonHelper.CalcMD5(salt + newPassword); user.PasswordHash = pwdHash; user.PasswordSalt = salt; ctx.SaveChanges(); } }
/// <summary> /// 检查用户登录 /// </summary> /// <param name="phoneNum">手机号码</param> /// <param name="password">密码</param> /// <returns></returns> public bool CheckLogin(string phoneNum, string password) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <AdminUserEntity> service = new BaseService <AdminUserEntity>(ctx); var user = service.GetAll().SingleOrDefault(u => u.PhoneNum == phoneNum); if (user == null) { return(false); } string pwdHash = CommonHelper.CaclMD5(user.PasswordSalt + password); if (pwdHash == user.PasswordHash) { return(true); } return(false); } }