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