public async Task <Role_Menu> AddAsync(RoleMenuDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { var role = await db.Role_Menus.Where(x => x.MenuId == dto.MenuId && x.RolesId == dto.RoleId && x.IsDeleted == false).FirstOrDefaultAsync(token); if (role != null) { role.LastOperationTime = dto.OperationTime; role.LastOperationUserId = dto.OperationUserId; await db.SaveChangesAsync(token); return(role); } role = new Role_Menu { MenuId = dto.MenuId, RolesId = dto.RoleId, CreateOperationTime = dto.OperationTime, CreateOperationUserId = dto.OperationUserId, IsDeleted = false }; db.Role_Menus.Add(role); await db.SaveChangesAsync(token); return(role); } }
public async Task <WeiXinUser> AddAsync(WeiXinUserDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { var weiXinUser = await db.WeiXinUsers.Where(x => x.Unionid == dto.Unionid && x.IsDeleted == false).FirstOrDefaultAsync(token); if (weiXinUser != null) { weiXinUser.City = dto.City; weiXinUser.Country = dto.Country; weiXinUser.Groupid = dto.Groupid; weiXinUser.Headimgurl = dto.Headimgurl; weiXinUser.Language = dto.Language; weiXinUser.Nickname = dto.Nickname; weiXinUser.OpenId = dto.Openid; weiXinUser.Province = dto.Province; weiXinUser.Qr_scene = dto.Qr_scene; weiXinUser.Qr_scene_str = dto.Qr_scene_str; weiXinUser.Remark = dto.Remark; weiXinUser.Sex = dto.Sex; weiXinUser.Subscribe = dto.Subscribe; weiXinUser.Subscribe_scene = dto.Subscribe_scene; weiXinUser.Subscribe_time = dto.Subscribe_time; weiXinUser.Tagid_list = dto.Tagid_list; weiXinUser.LastOperationTime = dto.OperationTime; weiXinUser.LastOperationUserId = dto.OperationUserId; await db.SaveChangesAsync(token); return(weiXinUser); } var entity = db.WeiXinUsers.Add(new WeiXinUser { City = dto.City, Country = dto.Country, Groupid = dto.Groupid, Headimgurl = dto.Headimgurl, Language = dto.Language, Nickname = dto.Nickname, OpenId = dto.Openid, Province = dto.Province, Qr_scene = dto.Qr_scene, Qr_scene_str = dto.Qr_scene_str, Remark = dto.Remark, Sex = dto.Sex, Subscribe = dto.Subscribe, Subscribe_scene = dto.Subscribe_scene, Subscribe_time = dto.Subscribe_time, Tagid_list = dto.Tagid_list, Unionid = dto.Unionid, CreateOperationTime = dto.OperationTime, CreateOperationUserId = dto.OperationUserId, LastOperationTime = dto.OperationTime, LastOperationUserId = dto.OperationUserId }); await db.SaveChangesAsync(token); return(entity); } }
public async Task UpdateAsync(CommunityDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("社区信息不正确!"); } var community = await db.Communities.Where(x => x.Id == uid).FirstOrDefaultAsync(token); if (community == null) { throw new NotImplementedException("该社区不存在!"); } if (await db.Communities.Where(x => x.Name == dto.Name && x.IsDeleted == false && x.StreetOfficeId == community.StreetOfficeId && x.Id != uid).FirstOrDefaultAsync(token) != null) { throw new NotImplementedException("该社区名称已存在!"); } community.Name = dto.Name; community.LastOperationTime = dto.OperationTime; community.LastOperationUserId = dto.OperationUserId; await OnUpdate(db, community, token); await db.SaveChangesAsync(token); } }
public async Task <VoteRecord> AddAsync(VoteRecordDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.VoteId, out var voteId)) { throw new NotImplementedException("投票Id信息不正确!"); } var vote = await db.Votes.Where(x => x.Id == voteId && x.IsDeleted == false).FirstOrDefaultAsync(token); if (vote == null) { throw new NotImplementedException("投票信息不存在!"); } var entity = db.VoteRecords.Add(new VoteRecord { Feedback = dto.Feedback, VoteId = dto.VoteId, OwnerCertificationId = dto.OwnerCertificationId, CreateOperationTime = dto.OperationTime, CreateOperationUserId = dto.OperationUserId, LastOperationTime = dto.OperationTime, LastOperationUserId = dto.OperationUserId }); await db.SaveChangesAsync(token); return(entity); } }
public async Task <StreetOffice> AddAsync(StreetOfficeDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { var streetOffice = await db.StreetOffices.Where(x => x.Name == dto.Name && x.IsDeleted == false).FirstOrDefaultAsync(token); if (streetOffice != null) { throw new NotImplementedException("该街道办已存在!"); } var entity = db.StreetOffices.Add(new StreetOffice { Name = dto.Name, City = dto.City, Region = dto.Region, State = dto.State, CreateOperationTime = dto.OperationTime, CreateOperationUserId = dto.OperationUserId, LastOperationTime = dto.OperationTime, LastOperationUserId = dto.OperationUserId }); await db.SaveChangesAsync(token); return(entity); } }
public async Task UpdateAsync(VipOwnerCertificationConditionDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("高级认证申请条件Id信息不正确!"); } var vipOwnerCertificationCondition = await db.VipOwnerCertificationConditions.Where(x => x.Id == uid).FirstOrDefaultAsync(token); if (vipOwnerCertificationCondition == null) { throw new NotImplementedException("该高级认证申请条件不存在!"); } if (await db.VipOwnerCertificationConditions.Where(x => x.Title == dto.Title && x.IsDeleted == false && x.Id != vipOwnerCertificationCondition.Id).FirstOrDefaultAsync(token) != null) { throw new NotImplementedException("该高级认证申请条件名称已存在!"); } vipOwnerCertificationCondition.Title = dto.Title; vipOwnerCertificationCondition.Description = dto.Description; vipOwnerCertificationCondition.LastOperationTime = dto.OperationTime; vipOwnerCertificationCondition.LastOperationUserId = dto.OperationUserId; await db.SaveChangesAsync(token); } }
public async Task <Building> AddAsync(BuildingDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.SmallDistrictId, out var smallDistrictId)) { throw new NotImplementedException("小区信息不正确!"); } var smallDistricts = await db.SmallDistricts.Where(x => x.Id == smallDistrictId && x.IsDeleted == false).FirstOrDefaultAsync(token); if (smallDistricts == null) { throw new NotImplementedException("小区信息不存在!"); } var duilding = await db.Buildings.Where(x => x.Name == dto.Name && x.IsDeleted == false && x.SmallDistrictId == smallDistrictId).FirstOrDefaultAsync(token); if (duilding != null) { throw new NotImplementedException("该楼宇信息已存在!"); } var entity = db.Buildings.Add(new Building { Name = dto.Name, SmallDistrictId = smallDistrictId, CreateOperationTime = dto.OperationTime, CreateOperationUserId = dto.OperationUserId, LastOperationTime = dto.OperationTime, LastOperationUserId = dto.OperationUserId }); await db.SaveChangesAsync(token); return(entity); } }
public async Task DeleteAsync(SmallDistrictDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("小区信息不正确!"); } var smallDistrict = await db.SmallDistricts.Where(x => x.Id == uid && x.IsDeleted == false).FirstOrDefaultAsync(token); if (smallDistrict == null) { throw new NotImplementedException("该小区不存在!"); } if (await OnDelete(db, dto, token)) { throw new NotImplementedException("该小区下存在下级业务数据"); } smallDistrict.LastOperationTime = dto.OperationTime; smallDistrict.LastOperationUserId = dto.OperationUserId; smallDistrict.DeletedTime = dto.OperationTime; smallDistrict.IsDeleted = true; await db.SaveChangesAsync(token); } }
public async Task DeleteAsync(OwnerDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("业主信息不正确!"); } var owner = await db.Owners.Where(x => x.Id == uid && x.IsDeleted == false).FirstOrDefaultAsync(token); if (owner == null) { throw new NotImplementedException("该业主信息不存在!"); } if (owner.IsLegalize) { throw new NotImplementedException("业主已认证不允许删除!"); } if (await OnDelete(db, dto, token)) { throw new NotImplementedException("该业主信息下存在下级数据"); } owner.LastOperationTime = dto.OperationTime; owner.LastOperationUserId = dto.OperationUserId; owner.DeletedTime = dto.OperationTime; owner.IsDeleted = true; await db.SaveChangesAsync(token); } }
public async Task UpdateAsync(OwnerDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("业主信息不正确!"); } var owner = await db.Owners.Where(x => x.Id == uid).FirstOrDefaultAsync(token); if (owner == null) { throw new NotImplementedException("该业主不存在!"); } if (await db.Owners.Where(x => x.Name == dto.Name && x.IsDeleted == false && x.IndustryId == owner.IndustryId && x.Id != uid).FirstOrDefaultAsync(token) != null) { throw new NotImplementedException("该业主名称已存在!"); } var ownerCertificationRecord = await db.OwnerCertificationRecords.Where(x => x.OwnerId.ToString() == dto.Id && x.IsDeleted == false).FirstOrDefaultAsync(token); if (ownerCertificationRecord == null) { owner.Birthday = dto.Birthday; owner.Gender = dto.Gender; owner.IDCard = dto.IDCard; owner.Name = dto.Name; } owner.PhoneNumber = dto.PhoneNumber; owner.LastOperationTime = dto.OperationTime; owner.LastOperationUserId = dto.OperationUserId; await db.SaveChangesAsync(token); } }
public async Task <VipOwnerStructure> AddAsync(VipOwnerStructureDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { var community = await db.VipOwnerStructures.Where(x => x.Name == dto.Name && x.IsDeleted == false).FirstOrDefaultAsync(token); if (community != null) { throw new NotImplementedException("该业委会职能已存在!"); } var entity = db.VipOwnerStructures.Add(new VipOwnerStructure { Name = dto.Name, Description = dto.Description, IsReview = dto.IsReview.Value, Weights = dto.Weights, CreateOperationTime = dto.OperationTime, CreateOperationUserId = dto.OperationUserId, LastOperationTime = dto.OperationTime, LastOperationUserId = dto.OperationUserId }); await db.SaveChangesAsync(token); return(entity); } }
public async Task UpdateAsync(VipOwnerStructureDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("业委会职能信息不正确!"); } var vipOwnerStructure = await db.VipOwnerStructures.Where(x => x.Id == uid).FirstOrDefaultAsync(token); if (vipOwnerStructure == null) { throw new NotImplementedException("该业委会职能不存在!"); } if (await db.VipOwnerStructures.Where(x => x.Name == dto.Name && x.IsDeleted == false && x.Id != uid).FirstOrDefaultAsync(token) != null) { throw new NotImplementedException("该业委会职能已存在!"); } vipOwnerStructure.Name = dto.Name; vipOwnerStructure.Description = dto.Description; vipOwnerStructure.Weights = dto.Weights; vipOwnerStructure.IsReview = dto.IsReview.Value; vipOwnerStructure.LastOperationTime = dto.OperationTime; vipOwnerStructure.LastOperationUserId = dto.OperationUserId; await OnUpdateAsync(db, vipOwnerStructure, token); await db.SaveChangesAsync(token); } }
public async Task <OwnerCertificationRecord> UpdateStatusAsync(OwnerCertificationRecordDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("认证信息Id不正确!"); } var ownerCertificationRecord = await db.OwnerCertificationRecords.Where(x => x.Id == uid).FirstOrDefaultAsync(token); if (ownerCertificationRecord == null) { throw new NotImplementedException("该认证信息不存在!"); } if (Guid.TryParse(dto.OwnerId, out var ownerId)) { //throw new NotImplementedException("业主Id信息不正确!"); ownerCertificationRecord.OwnerId = ownerId; } //ownerCertificationRecord.OwnerName = dto.OwnerName; ownerCertificationRecord.CertificationStatusName = dto.CertificationStatusName; ownerCertificationRecord.CertificationStatusValue = dto.CertificationStatusValue; ownerCertificationRecord.CertificationResult = dto.CertificationResult; ownerCertificationRecord.LastOperationTime = dto.OperationTime; ownerCertificationRecord.LastOperationUserId = dto.OperationUserId; ownerCertificationRecord.CertificationTime = dto.OperationTime; OnUpdate(db, dto, token); await db.SaveChangesAsync(token); return(ownerCertificationRecord); } }
public async Task <OwnerCertificationAnnex> AddAsync(OwnerCertificationAnnexDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (Guid.TryParse(dto.ApplicationRecordId, out Guid applicationRecordId)) { } var entity = db.OwnerCertificationAnnices.Add(new OwnerCertificationAnnex { ApplicationRecordId = applicationRecordId, OwnerCertificationAnnexTypeValue = dto.OwnerCertificationAnnexTypeValue, AnnexContent = dto.AnnexContent, CreateOperationTime = dto.OperationTime, CreateOperationUserId = dto.OperationUserId, }); if (!Guid.TryParse(dto.AnnexContent, out var annexContent)) { throw new NotImplementedException("业主认证附件id信息不正确!"); } var upload = db.Uploads.Where(x => x.Id == annexContent).FirstOrDefault(); entity.AnnexId = annexContent; entity.AnnexContent = upload.Agreement + upload.Host + upload.Domain + upload.Directory + upload.File; await db.SaveChangesAsync(token); return(entity); } }
public async Task DeleteAsync(CommunityDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("社区信息不正确!"); } var community = await db.Communities.Where(x => x.Id == uid && x.IsDeleted == false).FirstOrDefaultAsync(token); if (community == null) { throw new NotImplementedException("该社区不存在!"); } if (await OnDelete(db, dto, token)) { throw new NotImplementedException("该社区下存在下级小区数据"); } community.LastOperationTime = dto.OperationTime; community.LastOperationUserId = dto.OperationUserId; community.DeletedTime = dto.OperationTime; community.IsDeleted = true; await db.SaveChangesAsync(token); } }
public async Task UpdateAsync(IndustryDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("业户信息不正确!"); } var industrie = await db.Industries.Include(x => x.BuildingUnit.Building.SmallDistrict.Community.StreetOffice).Where(x => x.Id == uid).FirstOrDefaultAsync(token); if (industrie == null) { throw new NotImplementedException("该业户不存在!"); } if (await db.Industries.Where(x => x.Name == dto.Name && x.IsDeleted == false && x.BuildingUnit.BuildingId == industrie.BuildingUnit.BuildingId && x.Id != uid && x.BuildingUnitId.ToString() == dto.BuildingUnitId).FirstOrDefaultAsync(token) != null) { throw new NotImplementedException("该业户名称已存在!"); } industrie.Name = dto.Name; industrie.LastOperationTime = dto.OperationTime; industrie.LastOperationUserId = dto.OperationUserId; //await OnUpdateAsync(db, dto, token); await db.SaveChangesAsync(token); } }
public async Task DeleteAsync(IndustryDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("业户Id信息不正确!"); } var industrie = await db.Industries.Where(x => x.Id == uid && x.IsDeleted == false).FirstOrDefaultAsync(token); if (industrie == null) { throw new NotImplementedException("该业户不存在!"); } if (await OnDeleteAsync(db, dto, token)) { throw new NotImplementedException("该业户下存在下级数据"); } industrie.LastOperationTime = dto.OperationTime; industrie.LastOperationUserId = dto.OperationUserId; industrie.DeletedTime = dto.OperationTime; industrie.IsDeleted = true; await db.SaveChangesAsync(token); } }
public async Task <VipOwner> AddAsync(VipOwnerDto dto, CancellationToken token = default) { //TODO检查是否存在未竞选业委会信息 using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.SmallDistrictId, out var smallDistrictId)) { throw new NotImplementedException("小区信息不正确!"); } var smallDistrict = await db.SmallDistricts.Where(x => x.Id == smallDistrictId && x.IsDeleted == false).FirstOrDefaultAsync(token); if (smallDistrict == null) { throw new NotImplementedException("小区信息不存在!"); } var entity = db.VipOwners.Add(new VipOwner { Name = smallDistrict.Name + dto.Name, RemarkName = dto.RemarkName, SmallDistrictId = smallDistrictId, CreateOperationTime = dto.OperationTime, CreateOperationUserId = dto.OperationUserId, LastOperationTime = dto.OperationTime, LastOperationUserId = dto.OperationUserId }); await db.SaveChangesAsync(token); return(entity); } }
public async Task UpdateVoteAsync(VipOwnerApplicationRecordDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("申请记录Id信息不正确!"); } var vipOwnerApplicationRecord = await db.VipOwnerApplicationRecords.Where(x => x.Id == uid && x.IsDeleted == false).FirstOrDefaultAsync(token); if (vipOwnerApplicationRecord == null) { throw new NotImplementedException("该申请记录不存在!"); } vipOwnerApplicationRecord.VoteId = dto.VoteId; vipOwnerApplicationRecord.VoteQuestionId = dto.VoteQuestionId; vipOwnerApplicationRecord.VoteQuestionOptionId = dto.VoteQuestionOptionId; vipOwnerApplicationRecord.LastOperationTime = dto.OperationTime; vipOwnerApplicationRecord.LastOperationUserId = dto.OperationUserId; vipOwnerApplicationRecord.IsInvalid = true; vipOwnerApplicationRecord.VipOwnerId = dto.VipOwnerId; vipOwnerApplicationRecord.VipOwnerName = dto.VipOwnerName; await db.SaveChangesAsync(token); } }
public async Task UpdateIsElectionAsync(VipOwnerDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("业委会Id信息不正确!"); } var vipOwner = await db.VipOwners.Where(x => x.Id == uid).FirstOrDefaultAsync(token); if (vipOwner == null) { throw new NotImplementedException("该业委会不存在!"); } var entity = await db.VipOwners.Where(x => x.Name == dto.Name && x.IsDeleted == false && x.SmallDistrictId.ToString() == dto.SmallDistrictId && x.Id != uid).FirstOrDefaultAsync(token); if (entity != null) { throw new NotImplementedException("该业委会已存在!"); } vipOwner.IsElection = true; vipOwner.LastOperationTime = dto.OperationTime; vipOwner.LastOperationUserId = dto.OperationUserId; await OnUpdateAsync(db, vipOwner, token); await db.SaveChangesAsync(token); } }
public async Task DeleteAsync(BuildingDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("楼宇信息不正确!"); } var building = await db.Buildings.Where(x => x.Id == uid && x.IsDeleted == false).FirstOrDefaultAsync(token); if (building == null) { throw new NotImplementedException("该楼宇不存在!"); } if (await OnDeleteAsync(db, dto, token)) { throw new NotImplementedException("该楼宇信息存在下级数据!"); } building.LastOperationTime = dto.OperationTime; building.LastOperationUserId = dto.OperationUserId; building.DeletedTime = dto.OperationTime; building.IsDeleted = true; await db.SaveChangesAsync(token); } }
public async Task UpdateInvalidAsync(VipOwnerDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("业委会Id信息不正确!"); } var vipOwner = await db.VipOwners.Where(x => x.Id == uid).FirstOrDefaultAsync(token); if (vipOwner == null) { throw new NotImplementedException("该业委会不存在!"); } await db.VipOwnerCertificationRecords.Where(x => x.VipOwnerId == dto.Id).UpdateAsync(x => new VipOwnerCertificationRecord { IsInvalid = true }); vipOwner.IsValid = false; vipOwner.LastOperationTime = dto.OperationTime; vipOwner.LastOperationUserId = dto.OperationUserId; await OnUpdateAsync(db, vipOwner, token); await db.SaveChangesAsync(token); } }
public async Task <VipOwnerCertificationCondition> AddAsync(VipOwnerCertificationConditionDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { var vipOwnerCertificationCondition = await db.VipOwnerCertificationConditions.Where(x => x.Title == dto.Title && x.IsDeleted == false).FirstOrDefaultAsync(token); if (vipOwnerCertificationCondition != null) { throw new NotImplementedException("高级认证申请条件已存在!"); } var entity = db.VipOwnerCertificationConditions.Add(new VipOwnerCertificationCondition { Title = dto.Title, Description = dto.Description, TypeName = dto.TypeName, TypeValue = dto.TypeValue, CreateOperationTime = dto.OperationTime, CreateOperationUserId = dto.OperationUserId, LastOperationTime = dto.OperationTime, LastOperationUserId = dto.OperationUserId }); await db.SaveChangesAsync(token); return(entity); } }
public async Task DeleteAsync(OrderDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("订单Id信息不正确!"); } var order = await db.Orders.Where(x => x.Id == uid && x.IsDeleted == false).FirstOrDefaultAsync(token); if (order == null) { throw new NotImplementedException("该订单信息不存在!"); } if (order.OrderStatusValue != OrderStatus.Finish.Value) { throw new NotImplementedException("订单未完成不能删除!"); } order.LastOperationTime = dto.OperationTime; order.LastOperationUserId = dto.OperationUserId; order.DeletedTime = dto.OperationTime; order.IsDeleted = true; await db.SaveChangesAsync(token); } }
public async Task <Announcement> AddAsync(AnnouncementDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { var entity = db.Announcements.Add(new Announcement { Content = dto.Content, SmallDistrictArray = dto.SmallDistrictArray, DepartmentName = dto.DepartmentName, DepartmentValue = dto.DepartmentValue, Summary = dto.Summary, Title = dto.Title, CreateOperationTime = dto.OperationTime, CreateOperationUserId = dto.OperationUserId, LastOperationTime = dto.OperationTime, LastOperationUserId = dto.OperationUserId, CommunityId = dto.CommunityId, CommunityName = dto.CommunityName, SmallDistrictId = dto.SmallDistrictId, SmallDistrictName = dto.SmallDistrictName, StreetOfficeId = dto.StreetOfficeId, StreetOfficeName = dto.StreetOfficeName }); await db.SaveChangesAsync(token); return(entity); } }
public async Task UpdateAsync(OrderDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var ID)) { throw new NotImplementedException("订单ID无效!"); } var order = await db.Orders.Where(item => item.Id == ID).FirstOrDefaultAsync(token); if (order == null) { throw new NotImplementedException("订单不存在!"); } order.OrderStatusName = dto.OrderStatusName; order.OrderStatusValue = dto.OrderStatusValue; order.LastOperationTime = dto.OperationTime; order.LastOperationUserId = dto.OperationUserId; if (await db.SaveChangesAsync(token) <= 0) { throw new NotImplementedException("数据执行失败。"); } } }
public async Task DeleteAsync(StreetOfficeDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("街道办信息不正确!"); } var streetOffice = await db.StreetOffices.Where(x => x.Id == uid && x.IsDeleted == false).FirstOrDefaultAsync(token); if (streetOffice == null) { throw new NotImplementedException("该街道办不存在!"); } if (await OnDelete(db, dto, token)) { throw new NotImplementedException("该街道办存在下级社区数据!"); } streetOffice.LastOperationTime = dto.OperationTime; streetOffice.LastOperationUserId = dto.OperationUserId; streetOffice.DeletedTime = dto.OperationTime; streetOffice.IsDeleted = true; await db.SaveChangesAsync(token); } }
public async Task <Order> UpdatePaymentStatusAsync(string id, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(id, out var ID)) { throw new NotImplementedException("订单ID无效!"); } var order = await db.Orders.Where(item => item.Id == ID).FirstOrDefaultAsync(token); if (order == null) { throw new NotImplementedException("订单不存在!"); } order.PaymentStatusValue = PaymentStatus.Paid.Value; order.PaymentStatusName = PaymentStatus.Paid.Name; order.OrderStatusName = OrderStatus.WaitingAccept.Name; order.OrderStatusValue = OrderStatus.WaitingAccept.Value; if (await db.SaveChangesAsync(token) <= 0) { throw new NotImplementedException("数据执行失败。" + id); } return(order); } }
public async Task DeleteAsync(ShopCommodityDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("商品Id信息不正确!"); } var shopCommodity = await db.ShopCommodities.Where(x => x.Id == uid && x.IsDeleted == false).FirstOrDefaultAsync(token); if (shopCommodity == null) { throw new NotImplementedException("该商品不存在!"); } if (shopCommodity.SalesTypeValue == SalesType.Shelf.Value) { throw new NotImplementedException("该商品为销售状态不允许删除!"); } shopCommodity.LastOperationTime = dto.OperationTime; shopCommodity.LastOperationUserId = dto.OperationUserId; shopCommodity.DeletedTime = dto.OperationTime; shopCommodity.IsDeleted = true; await db.SaveChangesAsync(token); } }
public async Task UpdateCalculationMethodAsync(VoteDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.Id, out var uid)) { throw new NotImplementedException("投票Id信息不正确!"); } var vote = await db.Votes.Where(x => x.Id == uid).FirstOrDefaultAsync(token); if (vote == null) { throw new NotImplementedException("该投票不存在!"); } if (vote.VoteTypeValue == VoteTypes.VipOwnerElection.Value) { throw new NotImplementedException("业委会改选不能进行此操作"); } vote.CalculationMethodValue = CalculationMethod.Opposition.Value; vote.CalculationMethodName = CalculationMethod.Opposition.Name; vote.LastOperationTime = dto.OperationTime; vote.LastOperationUserId = dto.OperationUserId; await db.SaveChangesAsync(token); } }