public IActionResult GetList(UserInfoRequestpayload payload) { var query = from c in _dbContext.DangerousRoom where c.IsDeleted == 0 select new { c.Id, c.DangerousRoomUuid, c.DangerousMaster, c.DangerousPhone, c.DangerousAddress, c.AdministratorName, c.AdministratorPhone, c.Lon, c.Lat, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.DangerousMaster.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:危房信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { var query = from c in _dbContext.Mentally where c.IsDeleted == 0 select new { c.Id, c.MentallyUuid, c.Name, c.Phone, c.OwningGrid, c.Danger, c.IdCard, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Name.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("添加", "成功:添加:精神病人员信息数据", _dbContext); return(Ok(response)); }
public IActionResult UserInfoList(UserInfoRequestpayload payload) { var query = from c in _dbContext.Followvillager where c.IsDeleted == 0 select new { c.Id, c.FollowvillagerName, //姓名 c.Phone, //手机 c.Sex, //性别 c.IdentityCard, //身份证 c.Shiji, //来源地 c.Nation, //民族 c.Jieshao, c.FollowvillagerUuid, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.FollowvillagerName.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:乡贤信息数据", _dbContext); return(Ok(response)); }
public IActionResult HomeAddressList(UserInfoRequestpayload payload) { var query = from c in _dbContext.HomeAddress where c.IsDeleted == 0 select new { c.Id, c.Address, //地址 c.Addresscode, //地址编码 c.Village, //自然村 c.Town, //街道 c.Door, //门牌 c.Unit, //单元 c.Resregion, //小区 c.HomeAddressUuid, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Address.Contains(payload.Kw.Trim())); } if (!string.IsNullOrEmpty(payload.Kw1)) { query = query.Where(x => x.Addresscode.Contains(payload.Kw1.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:地址库信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { var query = from c in _dbContext.ReleasedPrison where c.IsDeleted == 0 select new { c.Id, c.ReleasedPrisonUuid, c.Name, c.OwnedNetwork, c.ControlClass, //管控等级 c.Charge, //罪名 c.Felony, //是否重犯 c.Sentence, //原判刑期 c.SolutionTime, //解判刑期 c.KeytoControl, //是否重点管控 c.CriminalAct, //犯罪行为 c.IdCard, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Name.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:刑满释放人员信息数据", _dbContext); return(Ok(response)); }
public IActionResult List(UserInfoRequestpayload payload) { var query = _dbContext.KeyYouthList.Where(x => x.IsDeleted == 0).Select(x => new { x.Name, x.OwnedNetwork, x.Id, x.KeyYouthListUuid, x.Sex, x.DateOfBirth, x.IdCard, x.PersonType, x.ContactNumber, x.ContactPhone, }); if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Name.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:重点青少年人员信息数据", _dbContext); return(Ok(response)); }
public IActionResult PTypeList(UserInfoRequestpayload payload) { var query = from c in _dbContext.Propaganda where c.IsDeleted == 0 select new { c.Id, c.PropagandaTypeName, c.Title, c.PropagandaTypeUuid, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.PropagandaTypeName.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:宣传队伍类型信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { List <GetYears> getYears = new List <GetYears>(); var q1 = _dbContext.Tongji.ToList().GroupBy(x => x.TjYear); foreach (var item in q1) { var query = from c in _dbContext.Tongji where c.TjYear == item.Key select new GetYears { gjYear = item.Key, giOne = one(item.Key, "第一季度") + "万", gjTwo = one(item.Key, "第二季度") + "万", gjThree = one(item.Key, "第三季度") + "万", gjFour = one(item.Key, "第四季度") + "万", }; var entity = query.FirstOrDefault(); getYears.Add(entity); } var getYe = getYears.OrderByDescending(x => x.gjYear); var list = getYe.AsQueryable().Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = getYe.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); return(Ok(response)); }
public IActionResult Getlishijk(UserInfoRequestpayload payload) { using (_dbContext) { var query = from c in _dbContext.WaterLevelSheb where c.Weizhi == payload.Kw1 select new { c.Id, c.WaterLevelShebUuid, c.MonitorWaterId, c.Weizhi, c.ShebeiType, c.Lon, c.Lat, c.AddTime, c.AdminPepo, c.YujingNum, c.YujingType, }; query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); return(Ok(response)); } }
public IActionResult HotelinfoList(UserInfoRequestpayload payload) { var query = from c in _dbContext.Hotel where c.IsDeleted == 0 select new { c.Id, c.HotelName, c.HotelLocation, c.HotelPhone, c.HotelPeoPle, c.HotelRecommend, c.HotelUuid, c.HotelType, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.HotelName.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:民宿信息数据", _dbContext); return(Ok(response)); }
public IActionResult RuzhuList(UserInfoRequestpayload payload) { var query = from c in _dbContext.Hotel where c.IsDeleted == 0 select new { c.Id, c.HotelName, c.HotelUuid, Rdingdan = GetRdingdan(c.HotelName), Rrenshu = GetRrenshu(c.HotelName), Ydingdan = GetYdingdan(c.HotelName), Yrenshu = GetYrenshu(c.HotelName), }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.HotelName.Contains(payload.Kw.Trim())); } //if (payload.FirstSort != null) //{ // query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC"); //} query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:酒店入住信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { var query = from c in _dbContext.Yqfkryb where c.IsDeleted == 0 select new { c.Id, c.Yqfkrybuuid, c.Name, c.OwnedNetwork, c.ReasonForConcern, c.Attention, c.IdCard, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Name.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:疫情防控人员信息数据", _dbContext); return(Ok(response)); }
public IActionResult SectarianInfoList(UserInfoRequestpayload payload) { var query = from c in _dbContext.Sectarian where c.IsDeleted == 0 select new { c.Id, c.SectarianName, //场所名称 c.SectarianLocation, //详细地址 c.SectarianTime, //建立时间 c.SectarianRecommend, //场所介绍 c.SectarianUuid, c.SectarianType, //所属宗派 }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.SectarianName.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:宗教信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { var query = from c in _dbContext.DzhizaihaiInfo where c.IsDeleted == 0 select new { c.Id, c.DzhizaihaiInfoUuid, c.Diqu, c.Shuliang, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Diqu.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:地质灾害点信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { var query = from c in _dbContext.PyramidSale where c.IsDeleted == 0 select new { c.Id, c.PyramidSaleUuid, c.Name, c.OwnedNetwork, c.UnlawfulAct, //违法行为 c.PenaltyType, //处罚类别 c.Attention, //关注程度 c.IdCard, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Name.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:传销人员信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { var query = from c in _dbContext.YoukeOverflow where c.IsDeleted == 0 select new { c.Id, c.YoukeOverflowUuid, c.JindianName, c.Rongliang, c.SsRenCount, c.OverflowInfo, c.YujinInfo, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.JindianName.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:游客溢出情况统计信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { var query = from c in _dbContext.WomenFederation where c.IsDeleted == 0 select new { c.Id, c.WomenFederationUuid, c.WomenFederationName, c.Phone, c.Zhuxi, c.Address, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.WomenFederationName.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("删除", "成功:删除:妇联组织信息数据", _dbContext); return(Ok(response)); }
public IActionResult xiangList(UserInfoRequestpayload payload) { var query = from c in _dbContext.CpcmanInfo where c.IsDeleted == 0 select new { c.Id, c.DangOrganizationName, //党组织 c.RealName, //姓名 c.Sex, //性别 Birth = c.Birth.Value.ToString("yyyy-MM-dd"), //生日 c.Education, //学历 c.Politics, //政治面貌 c.Age, c.CpcmanUuid, }; if (!string.IsNullOrEmpty(payload.Kw1)) { query = query.Where(x => x.DangOrganizationName.Contains(payload.Kw1)); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:党组织信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { var query = from c in _dbContext.Scenic where c.IsDeleted == 0 select new { c.Id, c.ScenicUuid, c.ScenicName, c.ScenicGrade, c.ScenicTickets, c.ScenicPeoPle, c.ScenicAddress, c.ScenicType, renshu = GetRdingdan(c.ScenicName), }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.ScenicName.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:景点信息数据", _dbContext); return(Ok(response)); }
public IActionResult List(UserInfoRequestpayload payload) { var query = from t in _dbContext.DangOrganization where t.IsDeleted != 1 select new { t.Id, t.DangOrganizationUuid, t.DangOrganizationName, t.DangClerk, t.DangType, OrganizationPeople = organpeople(t.DangOrganizationName) }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.DangOrganizationName.Contains(payload.Kw)); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:党组织信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { var query = from c in _dbContext.Volunteers where c.IsDeleted == 0 select new { c.Id, c.VolunteersUuid, c.VolunteersName, c.Phone, c.Jieshao, c.Staues, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.VolunteersName.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:侨界志愿者信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { var query = from c in _dbContext.WaterLevel where c.IsDeleted == 0 select new { c.Id, c.WaterLevelUuid, c.WaterName, c.WaterInfo, c.Watersw, c.Accurate, c.Weizhi, c.Lon, c.Lat, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.WaterName.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:五水共治信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { var query = from c in _dbContext.Drug where c.IsDeleted == 0 select new { c.Id, c.DrugUuid, c.Name, c.Phone, FirstTime = c.FirstTime != null?c.FirstTime.Value.ToString("yyyy-MM-dd") : "", c.Detoxification, c.OwningGrid, c.IdCard, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Name.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:吸毒人员信息数据", _dbContext); return(Ok(response)); }
public IActionResult UserInfoList(UserInfoRequestpayload payload) { var query = from c in _dbContext.Userinfoty where c.IsDeleted == 0 select new { c.Id, c.RealName, //姓名 c.Address, //地址 c.Phone, //手机 c.Email, //邮箱 c.Sex, //性别 c.Birth, //生日 c.IdentityCard, //身份证 c.Residence, //居住地 c.Domicile, //户籍地 c.Nation, //民族 c.Education, //学历 c.QianYiEtime, //迁移地 c.QianYiStime, //迁移时间 c.Occupation, //职业 c.DyStaues, //是否党员 c.Politics, //政治面貌 c.Position, //职位 c.Evaluate, //考评级别 c.JoinArmy, //参军意愿 c.ArmyTime, //参军时间 c.Age, c.UserInfoUuid, c.Relation, c.HouseholderName, c.Household, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.RealName.Contains(payload.Kw.Trim())); } if (!string.IsNullOrEmpty(payload.Kw1)) { query = query.Where(x => x.IdentityCard.Contains(payload.Kw1.Trim())); } if (!string.IsNullOrEmpty(payload.Kw2)) { query = query.Where(x => x.Education.Contains(payload.Kw2.Trim())); } //if (payload.FirstSort != null) //{ // query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC"); //} query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:统一人员信息信息数据", _dbContext); return(Ok(response)); }
public IActionResult List(UserInfoRequestpayload payload) { var query = _dbContext.DangerousGoods.Where(x => x.IsDeleted == 0); if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Name.Contains(payload.Kw.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:危险品从业人口信息数据", _dbContext); return(Ok(response)); }
public IActionResult HoruzhuGet(UserInfoRequestpayload payload) { using (_dbContext) { var query = from c in _dbContext.RuzhuInfo where c.HotelName == payload.Kw2 && c.IsDeleted == 0 select new { c.Id, c.RuzhuName, c.RuzhuPeople, c.RuzhuRoom, c.RuzhuMoney, c.RuzhuDay, c.RuzhuTime, c.LikaiTime, c.RuzhuInfoUuid, ztianshu = Gettianshu(c.RuzhuInfoUuid), c.HotelName, }; if (!string.IsNullOrEmpty(payload.Kw3)) { query = query.Where(x => x.RuzhuName.Contains(payload.Kw3.Trim())); } //if (!string.IsNullOrEmpty(payload.Kw4[0])) //{ // DateTime d1 = DateTime.Parse(payload.Kw4[0]); // DateTime d2 = DateTime.Parse(payload.Kw4[1]); // d2 = d2.AddDays(1); // query = query.Where(x => DateTime.Parse(x.RuzhuTime) >= d1 && DateTime.Parse(x.RuzhuTime) <= d2); //} query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); return(Ok(response)); } }
public IActionResult UserInfoList(UserInfoRequestpayload payload) { var query = from c in _dbContext.Sightseer where c.IsDeleted == 0 select new { c.Id, c.SightseerName, //姓名 c.Phone, //手机 c.Sex, //性别 c.IdentityCard, //身份证 c.Laiyuandi, //来源地 c.Nation, //民族 c.SightseerUuid, c.Age, c.Shengneiwai, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.SightseerName.Contains(payload.Kw.Trim())); } if (!string.IsNullOrEmpty(payload.Kw1)) { query = query.Where(x => x.IdentityCard.Contains(payload.Kw1.Trim())); } //if (payload.FirstSort != null) //{ // query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC"); //} query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:游客信息数据", _dbContext); return(Ok(response)); }
public IActionResult HqCommunaList(UserInfoRequestpayload payload) { var query = from c in _dbContext.HqCommunal where c.IsDeleted == 0 select new { c.Id, c.HqCommunalName, c.HqCommunalId, c.HqCommunalStaues, c.HqCommunalLocation, c.HqCommunalType, c.Lon, c.Lat, c.HqCommunalUuid, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.HqCommunalName.Contains(payload.Kw.Trim())); } if (!string.IsNullOrEmpty(payload.Kw1)) { query = query.Where(x => x.HqCommunalLocation.Contains(payload.Kw1.Trim())); } if (!string.IsNullOrEmpty(payload.Kw2)) { query = query.Where(x => x.HqCommunalType.Contains(payload.Kw2.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:公共设施信息一条数据", _dbContext); return(Ok(response)); }
public IActionResult HomeAddressList(UserInfoRequestpayload payload) { var query = from c in _dbContext.ConcerQiao where c.IsDeleted == 0 select new { c.Id, c.RealName, //姓名 c.UserIdCardType, //证件类型 c.UserIdCardNum, //证件号码 c.Phone, //手机号 c.Email, //邮箱 c.Sex, //性别 c.Gwaddress, //国外所在地 c.Cnaddress, //中国居住地 c.Xjaddress, //现居地址 c.ConcerningType, //涉侨类型:归侨、侨眷、港澳同胞眷属、归国留学人员、海外留学人员眷属、华侨、港澳同胞及外籍华人 c.ConcerningQiaoUuid, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.RealName.Contains(payload.Kw.Trim())); } if (!string.IsNullOrEmpty(payload.Kw1)) { query = query.Where(x => x.ConcerningType.Contains(payload.Kw1.Trim())); } query = query.OrderByDescending(x => x.Id); var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:涉侨人员信息数据", _dbContext); return(Ok(response)); }
public IActionResult GetList(UserInfoRequestpayload payload) { var response = ResponseModelFactory.CreateResultInstance; using (_dbContext) { var query = _dbContext.Barometric.Where(x => x.IsDeleted == 0); if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.BarTime.Contains(payload.Kw.Trim())); } if (payload.FirstSort != null) { query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC"); } var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:大气防治信息数据", _dbContext); return(Ok(response)); } }