public IActionResult CpcList(CpcmanRequestpayload payload)
{
var query = from u in _dbContext.Userinfoty
where u.IsDeleted != 1 && u.DyStaues == "1"
select new
{
u.Id,
u.TownUuid,
u.UserInfoUuid,
u.RealName,
u.Sex,
u.Birth,
u.Education,
u.Category,
u.Partybranch,
u.JoinDate,
u.Phone,
u.Residence,
u.Work,
u.Age
};
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.Residence.Contains(payload.Kw));
}
if (!string.IsNullOrEmpty(payload.Kw1))
{
query = query.Where(x => x.RealName.Contains(payload.Kw1.Trim()));
}
if (!string.IsNullOrEmpty(payload.Kw2))
{
query = query.Where(x => x.Residence.Contains(payload.Kw2));
}
if (payload.FirstSort != null)
{
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(CpcmanRequestpayload payload)
{
var query = from c in _dbContext.Cunzhenmb
where c.IsDeleted == 0
select new
{
c.CunzhenmbUuid,
c.Id,
c.RealName, //姓名
c.Address, //地址
c.Phone, //手机
c.Sex, //性别
c.Birth, //生日
c.IdentityCard, //身份证
c.Domicile, //户籍地
c.Nation, //政治面貌
c.Education, //文化程度
c.Residence, //职务
c.Wechat, //班级
};
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.RealName.Contains(payload.Kw.Trim()));
}
if (payload.FirstSort != null)
{
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(CpcmanRequestpayload payload)
{
var query = _dbContext.Userinfoty.Where(x => x.IsDeleted == 0 && x.Age >= 18 && x.Age <= 24);
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.Education == payload.Kw1.Trim());
}
if (payload.FirstSort != null)
{
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));
}
