public long GetTotalCount(long cityId, string status) { using (MyDbContext ctx = new MyDbContext()) { BaseService <HouseAppointmentEntity> bs = new BaseService <HouseAppointmentEntity>(ctx); var count = bs.GetAll().LongCount(c => c.House.Communitie.Region.CityId == cityId && c.Status == status); return(count); } }
/// <summary> /// 获取指定城市的管理员 /// </summary> /// <param name="cityId">如果为null则获取总部管理员;否则获取某个地区的</param> /// <returns></returns> public AdminUserDTO[] GetAll(long?cityId) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <AdminUserEntity> bs = new BaseService <AdminUserEntity>(ctx); var all = bs.GetAll().Include(u => u.City) .AsNoTracking().Where(u => u.CityId == cityId); return(all.ToList().Select(u => ToDTO(u)).ToArray()); } }
public IdNameDTO[] GetAll(string typeName) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <IdNameEntity> bs = new BaseService <IdNameEntity>(ctx); return(bs.GetAll().Where(e => e.TypeName == typeName) .ToList().Select(e => ToDTO(e)).ToArray()); } }
public long GetCount(long cityId, DateTime startDateTome, DateTime endDateTime) { using (MyDbContext ctx = new MyDbContext()) { BaseService <HouseEntity> houseBs = new BaseService <HouseEntity>(ctx); return(houseBs.GetAll().Count(h => h.Communitie.Region.CityId == cityId && h.CreateDateTime >= startDateTome && h.CreateDateTime <= endDateTime)); } }
public int GetTodayNewHouseCount(long cityId) { using (var ctx = new ZSZDbContext()) { BaseService <HouseEntity> bs = new BaseService <HouseEntity>(ctx); return(bs.GetAll().Where(p => p.Community.Region.CityId == cityId && SqlFunctions.DateDiff("hh", p.CreateDateTime, DateTime.Now) <= 24) .Count()); } }
public CityDTO[] GetAll() { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <CityEntity> bs = new BaseService <CityEntity>(ctx); return(bs.GetAll().AsNoTracking().ToList() .Select(c => ToDTO(c)).ToArray()); } }
public AttachmentDTO[] GetAll() { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <AttachmentEntity> bs = new BaseService <AttachmentEntity>(ctx); var items = bs.GetAll().AsNoTracking(); return(items.ToList().Select(a => ToDTO(a)).ToArray()); } }
public IdNameDTO[] GetAll(string typeName) { using (MyDbContext ctx = new MyDbContext()) { BaseService <IdNameEntity> bs = new BaseService <IdNameEntity>(ctx); return(bs.GetAll().Where(e => e.TypeName == typeName) .ToList().Select(e => ToDTO(e)).ToArray()); //EF有可能翻译不成SQL语句,通过ToList拿到内存中操作。 } }
public bool CheckLogin(string phoneNum, string password) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <UserEntity> bs = new BaseService <UserEntity>(ctx); var theuser = bs.GetAll().ToList(); var user = bs.GetAll().SingleOrDefault(u => u.PhoneNum == phoneNum); if (user == null) { return(false); } else { string dbPwdHash = user.PasswordHash; string salt = user.PasswordSalt; string userPwdHash = CommonHelper.CalcMD5(salt + password); return(dbPwdHash == userPwdHash); } } }
public AdminUserDTO[] GetAll() { using (ZSZDbContext ctx = new ZSZDbContext()) { //using System.Data.Entity;才能在IQueryable中用Include、AsNoTracking BaseService <AdminUserEntity> bs = new BaseService <AdminUserEntity>(ctx); return(bs.GetAll().Include(u => u.City) .AsNoTracking().ToList().Select(u => ToDTO(u)).ToArray()); } }
public CityDTO[] GetAll() { using (ZSZDbContext context = new ZSZDbContext()) { BaseService <CityEntity> service = new BaseService <CityEntity>(context); return(service.GetAll().AsNoTracking().Select(p => new CityDTO { Name = p.Name, Id = p.Id }).ToArray()); } }
/// <summary> /// 通过城市id获得所有的区域 /// </summary> /// <param name="cityId"></param> /// <returns></returns> public RegionDTO[] GetAll(long cityId) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <RegionEntity> bs = new BaseService <RegionEntity>(ctx); return(bs.GetAll().Include(r => r.City) .Where(r => r.CityId == cityId).ToList() .Select(r => ToDTO(r)).ToArray()); } }
public RegionDTO GetById(long id) { using (MyDbContext ctx = new MyDbContext()) { BaseService <RegionEntity> bs = new BaseService <RegionEntity>(ctx); var region = bs.GetAll().Include(r => r.City) .SingleOrDefault(r => r.Id == id); return(region == null ? null : ToDTO(region)); } }
public long GetTotalCount(long cityId, string status) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <HouseAppointmentEntity> bs = new BaseService <HouseAppointmentEntity>(ctx); var count = bs.GetAll() //Where(a => a.House.Community.Region.CityId == cityId && a.Status == status).LongCount() .LongCount(a => a.House.Community.Region.CityId == cityId && a.Status == status); return(count); } }
//获得某一城市管理员 //如果为null就获取总部管理员 //否则就是某个地区的 public AdminUserDTO[] GetAll(long?cityId) { //如果ciityid为null会翻译成city is null??;city=3 using (MyDbContext ctx = new MyDbContext()) { BaseService <AdminUserEntity> bs = new BaseService <AdminUserEntity>(ctx); var all = bs.GetAll().Include(u => u.City) .AsNoTracking().Where(u => u.CityId == cityId); return(all.ToList().Select(u => ToDto(u)).ToArray()); //EF有可能翻译不成SQL语句,通过ToList拿到内存中操作。 } }
public AttachementDTO[] GetAll() { using (MyDbContext ctx = new MyDbContext()) { BaseService <AttachmentEntity> bs = new BaseService <AttachmentEntity>(ctx); var items = bs.GetAll().AsNoTracking(); //asnotracking数据只用于显示 //return items.Select(a => ToDTO(a)).ToArray(); return(items.ToList().Select(a => ToDTO(a)).ToArray()); //EF有可能翻译不成SQL语句,通过ToList拿到内存中操作。 } }
public RegionDTO[] GetAll(long cityId) { using (MyDbContext ctx = new MyDbContext()) { BaseService <RegionEntity> bs = new BaseService <RegionEntity>(ctx); return(bs.GetAll().Include(r => r.City) .Where(r => r.CityId == cityId).ToList() .Select(r => ToDTO(r)).ToArray()); //EF有可能翻译不成SQL语句,通过ToList拿到内存中操作。 } }
public RoleDTO GetByName(string name) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <RoleEntity> userBs = new BaseService <RoleEntity>(ctx); var user = userBs.GetAll().SingleOrDefault(r => r.Name == name); if (user == null) { return(null); } return(ToDTO(user)); } }
public bool HasPermission(long adminUserId, string permissionName) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <AdminUserEntity> bs = new BaseService <AdminUserEntity>(ctx); var user = bs.GetAll().Include(a => a.Roles).AsNoTracking().SingleOrDefault(a => a.Id == adminUserId); if (user == null) { throw new ArgumentException("找不到id=" + adminUserId + "的用户"); } return(user.Roles.SelectMany(r => r.Permissions).Any(p => p.Name == permissionName)); } }
public long GetTotalCount(string keyWords) { using (ZSZContext zsz = new ZSZContext()) { BaseService <AdminUserEntity> bsAdmin = new BaseService <AdminUserEntity>(zsz); if (!string.IsNullOrEmpty(keyWords)) { var list = bsAdmin.GetAll().Where(e => e.Name.Contains(keyWords) || e.PhoneNum.Contains(keyWords)); return(list.LongCount()); } return(bsAdmin.GetTotalCount()); } }
/// <summary> /// 根据id获取AdminUserDTO /// </summary> /// <param name="id">id</param> /// <returns></returns> public AdminUserDTO GetById(long id) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <AdminUserEntity> service = new BaseService <AdminUserEntity>(ctx); AdminUserEntity user = service.GetAll().Include(u => u.City).AsNoTracking().SingleOrDefault(u => u.Id == id); if (user == null) { return(null); } return(ToDTO(user)); } }
public HouseAppointmentDTO[] GetPagedData(long cityId, string status, int pageSize, int currentIndex) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <HouseAppointmentEntity> bs = new BaseService <HouseAppointmentEntity>(ctx); var apps = bs.GetAll().Include(a => a.House).Include(nameof(HouseAppointmentEntity.House) + "." + nameof(HouseEntity.Community)) .Include(a => a.FollowAdminUser). 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);//skip之前要先排序 return(apps.ToList().Select(a => ToDTO(a)).ToArray()); } }
//获得所有管理员 public AdminUserDTO[] GetAll() { //using System.Data.Entity;才能在IQuerable中用Include //关联属性会引发延迟加载,通过Include避免延迟加载 //asnotracking:取出来的数据只是显示,不用修改可稍微调高性能 using (MyDbContext ctx = new MyDbContext()) { BaseService <AdminUserEntity> bs = new BaseService <AdminUserEntity>(ctx); return(bs.GetAll().Include(u => u.City).AsNoTracking() .ToList().Select(u => ToDto(u)).ToArray()); //EF有可能翻译不成SQL语句,通过ToList拿到内存中操作。 } }
public AttachmentDTO[] GetAttachments(long houseId) { using (ZSZDbContext ctx = new Service.ZSZDbContext()) { BaseService <HouseEntity> bs = new BaseService <HouseEntity>(ctx); var house = bs.GetAll().Include(h => h.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 HouseDTO GetById(long id) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <HouseEntity> service = new BaseService <HouseEntity>(ctx); var house = service.GetAll().Include(u => u.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.RoomType).Include(h => h.Status).Include(h => h.Type).Include(h => h.HousePics).SingleOrDefault(u => u.Id == id); if (house == null) { return(null); } return(ToDTO(house)); } }
public AttachmentDTO[] GetAttachments(long houseId) { using (var ctx = new ZSZDbContext()) { var bs = new BaseService <HouseEntity>(ctx); var house = bs.GetAll().Include(p => p.Attachments) .AsNoTracking().SingleOrDefault(); if (house == null) { throw new ArgumentException($"House:{houseId}不存在"); } return(house.Attachments.Select(p => ToDTO(p)).ToArray()); } }
public SettingDTO[] GetAll() { using (ZSZDbContext context = new ZSZDbContext()) { BaseService <SettingEntity> service = new BaseService <SettingEntity>(context); return(service.GetAll().AsNoTracking().Select(p => new SettingDTO { Id = p.Id, CreateDateTime = p.CreateDateTime, Name = p.Name, Value = p.Value }).ToArray()); } }
public AdminUserDTO[] GetAllAdmin(int pageSize, int currentIndex, string keyWords) { using (ZSZContext context = new ZSZContext()) { BaseService <AdminUserEntity> adbs = new BaseService <AdminUserEntity>(context); var items = adbs.GetAll(); if (!string.IsNullOrEmpty(keyWords)) { items = items.Where(e => e.Name.Contains(keyWords) || e.PhoneNum.Contains(keyWords)); } return(items.AsNoTracking().OrderByDescending(m => m.CreateDateTime).Skip(currentIndex).Take(pageSize).ToList().Select(u => ToDTO(u)).ToArray()); } }
public AttachmentDTO[] GetAttachments(long houseId) { using (ZSZDbContext ctx = new ZSZDbContext()) { BaseService <HouseEntity> houseBS = new BaseService <HouseEntity>(ctx); var house = houseBS.GetAll().Include(a => a.Attachments) .AsNoTracking().SingleOrDefault(h => h.Id == houseId); if (house == null) { } return(house.Attachments.ToList().Select(a => ToDTO(a)).ToArray()); } }
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(a => a.Id == id); if (user == null) { return(null); } return(ToDTO(user)); } }