public List <VHelpArea> SearchMyInfoByWhere(GetMyListViewModel VSearchModel) { //查询条件 var predicate = WhereExtension.True <VHelpArea>();//初始化where表达式 // 不显示 已删除的信息 20191111 predicate = predicate.And(p => !p.Status.Equals("3")); if (!String.IsNullOrEmpty(VSearchModel.CommunityID)) { predicate = predicate.And(p => p.CommunityID.Contains(VSearchModel.CommunityID)); } if (!String.IsNullOrEmpty(VSearchModel.TypeIDs)) { predicate = predicate.And(p => p.TypeID.Contains(VSearchModel.TypeIDs)); } if (!String.IsNullOrEmpty(VSearchModel.Status)) { predicate = predicate.And(p => p.Address.Contains(VSearchModel.Status)); } var result = DbSet.Where(predicate) .OrderByDescending(o => o.CreateDate).ToList(); return(result); }
//获取我的互助信息(志愿者ID、所属社区ID、活动类型ID、状态 等) public List <VHelpAreaSearchMiddle> GetMyAllInfoByWhere(GetMyListViewModel vidModel) { List <String> Infos = _IVHA_SignRepository.GetMyList(vidModel.VID); List <VHelpAreaSearchMiddle> Searches = new List <VHelpAreaSearchMiddle>(); List <VHelpArea> middle = _IVHelpAreaRepository.GetByIDList(Infos); if (!String.IsNullOrEmpty(vidModel.CommunityID)) { middle = middle.Where(o => o.CommunityID.Contains(vidModel.CommunityID)).ToList(); } if (!String.IsNullOrEmpty(vidModel.Type)) { middle = middle.Where(o => o.ProblemType.Contains(vidModel.Type)).ToList(); } //默认地址 天津市滨海新区宏达街19号 (显示距离) string longitude = "117.70889"; string latitude = "39.02749"; var VolunteerInfo = _IVolunteerInfoRepository.SearchInfoByID(vidModel.VID); //根据活动地址推荐 两公里以内 string address = VolunteerInfo.Address; if (address != "") { string content = GetFunction(address); JObject jo = (JObject)JsonConvert.DeserializeObject(content);//或者JObject jo = JObject.Parse(jsonText); if (jo["status"].ToString() == "0") { longitude = jo["result"]["location"]["lng"].ToString(); latitude = jo["result"]["location"]["lat"].ToString(); } } foreach (var item in middle) { //判断 互助地址与志愿者注册详细地址间距离 double dis = GetDistance(double.Parse(longitude), double.Parse(latitude), double.Parse(item.longitude), double.Parse(item.latitude)); item.bak3 = dis.ToString("f2"); //获取本志愿者针对该互助信息 所有状态 BaseViewModel baseViewModel = GetVHAStatus(vidModel.VID, item.ID); item.bak2 = baseViewModel.ResponseCode.ToString(); } if (!String.IsNullOrEmpty(vidModel.Status)) { middle = middle.Where(o => o.bak2.Contains(vidModel.Status)).ToList(); } Searches = _IMapper.Map <List <VHelpArea>, List <VHelpAreaSearchMiddle> >(middle); return(Searches); }
public ActionResult <VHelpAreaSearchResModel> GetMyAllByWhere(GetMyListViewModel vidModel) { VHelpAreaSearchResModel SearchResModel = new VHelpAreaSearchResModel(); var SearchResult = _VHelpAreaService.GetMyAllInfoByWhere(vidModel); SearchResModel.VHelpArea = SearchResult; SearchResModel.isSuccess = true; SearchResModel.baseViewModel.Message = "查询成功"; SearchResModel.baseViewModel.ResponseCode = 200; SearchResModel.TotalNum = 1; return(Ok(SearchResModel)); }
//按条件查询 志愿活动列表 public List <VolunteerActivity> SearchMyInfoByWhere(GetMyListViewModel VSearchModel) { //查询条件 var predicate = WhereExtension.True <VolunteerActivity>();//初始化where表达式 if (!String.IsNullOrEmpty(VSearchModel.CommunityID)) { predicate = predicate.And(p => p.CommunityID.Contains(VSearchModel.CommunityID)); } if (!String.IsNullOrEmpty(VSearchModel.TypeIDs)) { predicate = predicate.And(p => p.TypeIDs.Contains(VSearchModel.TypeIDs)); } if (!String.IsNullOrEmpty(VSearchModel.Status)) { predicate = predicate.And(p => p.Address.Contains(VSearchModel.Status)); } var result = DbSet.Where(predicate) .OrderByDescending(o => o.CreateDate).ToList(); return(result); }