/// <summary>
/// 根据条件查询领导意见
/// </summary>
/// <param name="opinionInfoSearchViewModel"></param>
/// <returns></returns>
public List <OpinionInfoSearchMiddlecs> OpinionInfo_Search(OpinionInfoSearchViewModel opinionInfoSearchViewModel)
{
OpinionInfoSearchMiddlecs oism = new OpinionInfoSearchMiddlecs();
List <Opinion_Info> opinionInfo_Infos = _IOpinionInfoRepository.SearchOpinionInfoByWhere(opinionInfoSearchViewModel).ToList();
var repairSearchMiddlecs = _IMapper.Map <List <Opinion_Info>, List <OpinionInfoSearchMiddlecs> >(opinionInfo_Infos);
return(repairSearchMiddlecs);
}
/// <summary>
/// 根据条件查询领导意见
/// </summary>
/// <param name="opinionInfoSearchViewModel"></param>
/// <returns></returns>
public IQueryable <Opinion_Info> SearchOpinionInfoByWhere(OpinionInfoSearchViewModel opinionInfoSearchViewModel)
{
int SkipNum = opinionInfoSearchViewModel.pageViewModel.CurrentPageNum * opinionInfoSearchViewModel.pageViewModel.PageSize;
var preciateByopinionInfo = SearchOpinionInfoWhere(opinionInfoSearchViewModel);
IQueryable <Opinion_Info> OpinionInfo = Db.opinion_Infos.Where(preciateByopinionInfo);
IQueryable <Opinion_Info> SearchResultTemp = OpinionInfo.Include(a => a.User_Info)
.Include(a => a.Flow_NodeDefine)
.Skip(SkipNum)
.Take(opinionInfoSearchViewModel.pageViewModel.PageSize).OrderBy(o => o.AddDate);
return(SearchResultTemp);
}
//根据条件查询领导意见
private Expression <Func <Opinion_Info, bool> > SearchOpinionInfoWhere(OpinionInfoSearchViewModel opinionInfoSearchViewModel)
{
var predicate = WhereExtension.True <Opinion_Info>();//初始化where表达式
predicate = predicate.And(p => p.User_Info.UserName.Contains(opinionInfoSearchViewModel.UserName));
if (opinionInfoSearchViewModel.Repair_InfoId != null)
{
predicate = predicate.And(p => p.Repair_InfoId == opinionInfoSearchViewModel.Repair_InfoId.Value);
}
predicate = predicate.And(p => p.Flow_NodeDefine.NodeName.Contains(opinionInfoSearchViewModel.NodeName));
predicate = predicate.And(p => p.status.Contains(opinionInfoSearchViewModel.status));
predicate = predicate.And(p => p.AddDate.ToString().Contains(opinionInfoSearchViewModel.AddDate.ToString()));
return(predicate);
}
public ActionResult <OpinionInfoSearchResModel> Manage_OpinionInfo_Search(OpinionInfoSearchViewModel opinionInfoSearchViewModel)
{
OpinionInfoSearchResModel opinionInfoSearchResModel = new OpinionInfoSearchResModel();
var BusSearchResult = _opinionInfoService.OpinionInfo_Search(opinionInfoSearchViewModel);
// var TotalNum = _userService.User_Get_ALLNum();
var TotalNum = _opinionInfoService.OpinionInfo_Get_ALLNum(opinionInfoSearchViewModel);
opinionInfoSearchResModel.suggestBoxInfo = BusSearchResult;
opinionInfoSearchResModel.IsSuccess = true;
opinionInfoSearchResModel.baseViewModel.Message = "查询成功";
opinionInfoSearchResModel.baseViewModel.ResponseCode = 200;
opinionInfoSearchResModel.TotalNum = TotalNum;
_ILogger.Information("查询领导回复意见信息成功");
return(Ok(opinionInfoSearchResModel));
}
public IQueryable <Opinion_Info> GetOpinionInfoAll(OpinionInfoSearchViewModel opinionInfoSearchViewModel)
{
var predicate = SearchOpinionInfoWhere(opinionInfoSearchViewModel);
return(DbSet.Where(predicate));
}
public int OpinionInfo_Get_ALLNum(OpinionInfoSearchViewModel opinionInfoSearchViewModel)
{
return(_IOpinionInfoRepository.GetOpinionInfoAll(opinionInfoSearchViewModel).Count());
}
