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));
}
}
