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