public List <MydutyClaim_Info> getMydutyInfo(MydutyClaimInfoSearchViewModel mydutyClaimInfoSearchViewModel)
{
var preciate = Searchwhere(mydutyClaimInfoSearchViewModel);
var result = DbSet.Where(preciate).Include(a => a.OndutyClaims_Info.Normalization_Info).OrderByDescending(a => a.StartDutyTime).ToList();
return(result);
}
public ActionResult GetMyDutyInfo(MydutyClaimInfoSearchViewModel mydutyClaimInfoSearchViewModel)
{
MydutyClaimInfoSearchResModel mydutyClaimInfoSearchResModel = new MydutyClaimInfoSearchResModel();
mydutyClaimInfoSearchResModel.mydutyClaimInfoSearchMiddleModel = mydutyClaimInfoService.getMydutyInfoService(mydutyClaimInfoSearchViewModel);
mydutyClaimInfoSearchResModel.isSuccess = true;
mydutyClaimInfoSearchResModel.baseViewModel.Message = "查询成功";
mydutyClaimInfoSearchResModel.baseViewModel.ResponseCode = 200;
mydutyClaimInfoSearchResModel.TotalNum = 1;
return(Ok(mydutyClaimInfoSearchResModel));
}
public List <MydutyClaimInfoSearchMiddleModel> getMydutyInfoService(MydutyClaimInfoSearchViewModel mydutyClaimInfoSearchViewModel)
{
var searchresult = _IMydutyClaimInfoRepository.getMydutyInfo(mydutyClaimInfoSearchViewModel);
List <MydutyClaimInfoSearchMiddleModel> lists = new List <MydutyClaimInfoSearchMiddleModel>();
foreach (var item in searchresult)
{
var res = new MydutyClaimInfoSearchMiddleModel();
res.id = item.id;
res.StartDutyTime = item.StartDutyTime;
res.EndDutyTime = item.EndDutyTime;
res.CreateDate = item.CreateDate;
res.status = item.status;
res.title = item.OndutyClaims_Info.Normalization_Info.title;
res.Userid = item.Userid;
res.UserName = item.UserName;
res.XiaoCommunityName = item.OndutyClaims_Info.Subdistrict;
lists.Add(res);
}
return(lists);
}
//根据条件查询用户
private Expression <Func <MydutyClaim_Info, bool> > Searchwhere(MydutyClaimInfoSearchViewModel mydutyClaimInfoSearchViewModel)
{
var predicate = WhereExtension.True <MydutyClaim_Info>();//初始化where表达式
//未开始 已结束 已取消
//未开始
if (mydutyClaimInfoSearchViewModel.status == "0")
{
// 不显示 已删除的信息 status=3 20191111 ,不显示 居民发布未审核的信息 status=9;审核不通过信息 status=8 (20191120)
predicate = predicate.And(p => p.StartDutyTime > DateTime.Now);
predicate = predicate.And(p => p.status.Contains("1"));
}
//已结束
else if (mydutyClaimInfoSearchViewModel.status == "1")
{
predicate = predicate.And(p => p.EndDutyTime < DateTime.Now);
predicate = predicate.And(p => p.status.Contains("1"));
}
// 已取消
else if (mydutyClaimInfoSearchViewModel.status == "2")
{
//predicate = predicate.And(p => p.EndDutyTime < DateTime.Now);
predicate = predicate.And(p => p.status.Contains("2"));
}
predicate = predicate.And(p => p.Userid.Contains(mydutyClaimInfoSearchViewModel.Userid));
predicate = predicate.And(p => p.UserName.Contains(mydutyClaimInfoSearchViewModel.UserName));
predicate = predicate.And(p => p.EndDutyTime.Value.ToString().Contains(mydutyClaimInfoSearchViewModel.EndDutyTime));
predicate = predicate.And(p => p.CreateDate.Value.ToString().Contains(mydutyClaimInfoSearchViewModel.CreateDate));
return(predicate);
}
