//根据条件查询
public List <VolunteerActivity> SearchInfoByWhere(AllSearchViewModel VSearchViewModel)
{
//查询条件
var predicate = WhereExtension.True <VolunteerActivity>();//初始化where表达式
// 不显示 已删除的信息 status=0 (20191128)
predicate = predicate.And(p => !p.Status.Equals("0"));
predicate = predicate.And(p => (p.Title.Contains(VSearchViewModel.Title) || p.Community.Contains(VSearchViewModel.Community) || p.Address.Contains(VSearchViewModel.Address) || p.Type.Contains(VSearchViewModel.Type)));
if (!String.IsNullOrEmpty(VSearchViewModel.Status))
{
predicate = predicate.And(p => (p.Status.Equals(VSearchViewModel.Status)));
}
if (!String.IsNullOrEmpty(VSearchViewModel.CommunityID))
{
predicate = predicate.And(p => p.CommunityID.Equals(VSearchViewModel.CommunityID));
}
if (!String.IsNullOrEmpty(VSearchViewModel.TypeID))
{
predicate = predicate.And(p => p.TypeIDs.Equals(VSearchViewModel.TypeID));
}
var result = DbSet.Where(predicate)
.OrderByDescending(o => o.CreateDate).ToList();
return(result);
}
public ActionResult <VolunteerActivitySearchResModel> Manage_Search(AllSearchViewModel viewModel)
{
VolunteerActivitySearchResModel SearchResModel = new VolunteerActivitySearchResModel();
var SearchResult = _VolunteerActivityService.VolunteerActivity_Search(viewModel);
SearchResModel.Volunteer_Activity = SearchResult;
SearchResModel.isSuccess = true;
SearchResModel.baseViewModel.Message = "查询成功";
SearchResModel.baseViewModel.ResponseCode = 200;
SearchResModel.TotalNum = 1;
return(Ok(SearchResModel));
}
public ActionResult <VHelpAreaSearchResModel> Manage_Search(AllSearchViewModel SearchViewModel)
{
VHelpAreaSearchResModel SearchResModel = new VHelpAreaSearchResModel();
var SearchResult = _VHelpAreaService.VHelpArea_Search(SearchViewModel);
SearchResModel.VHelpArea = SearchResult;
SearchResModel.isSuccess = true;
SearchResModel.baseViewModel.Message = "查询成功";
SearchResModel.baseViewModel.ResponseCode = 200;
SearchResModel.TotalNum = 1;
return(Ok(SearchResModel));
}
//根据条件查询互助信息 （互助标题Title、所属组织架构Community,互助地址Address,擅长技能Type）
public List <VHelpAreaSearchMiddle> VHelpArea_Search(AllSearchViewModel VSearchViewModel)
{
List <VHelpArea> Infos = _IVHelpAreaRepository.SearchInfoByWhere(VSearchViewModel);
List <VHelpAreaSearchMiddle> Searches = new List <VHelpAreaSearchMiddle>();
//默认地址 天津市滨海新区宏达街19号 (显示距离)
string longitude = "117.70889";
string latitude = "39.02749";
var VolunteerInfo = _IVolunteerInfoRepository.SearchInfoByID(VSearchViewModel.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 Infos)
{
//判断 互助地址与志愿者注册详细地址间距离
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(VSearchViewModel.VID, item.ID);
item.bak2 = baseViewModel.ResponseCode.ToString();
var SearchMiddlecs = _IMapper.Map <VHelpArea, VHelpAreaSearchMiddle>(item);
Searches.Add(SearchMiddlecs);
}
return(Searches);
}
//根据条件查询互助信息 （ 互助标题Title、所属组织架构Community,互助地址Address,擅长技能Type）
public List <VHelpArea> SearchInfoByWhere(AllSearchViewModel VSearchViewModel)
{
//查询条件
var predicate = WhereExtension.True <VHelpArea>();//初始化where表达式
// 不显示 已删除的信息 status=3 20191111 ,不显示 居民发布未审核的信息 status=9;审核不通过信息 status=8 (20191120)
predicate = predicate.And(p => !p.Status.Equals("3"));
predicate = predicate.And(p => !p.Status.Equals("9"));
predicate = predicate.And(p => !p.Status.Equals("8"));
if (!String.IsNullOrEmpty(VSearchViewModel.Title))
{
predicate = predicate.And(p => p.Title.Contains(VSearchViewModel.Title));
}
if (!String.IsNullOrEmpty(VSearchViewModel.Community))
{
predicate = predicate.And(p => p.Community.Contains(VSearchViewModel.Community));
}
if (!String.IsNullOrEmpty(VSearchViewModel.CommunityID))
{
predicate = predicate.And(p => p.CommunityID.Contains(VSearchViewModel.CommunityID));
}
if (!String.IsNullOrEmpty(VSearchViewModel.Address))
{
predicate = predicate.And(p => p.Address.Contains(VSearchViewModel.Address));
}
if (!String.IsNullOrEmpty(VSearchViewModel.Type))
{
predicate = predicate.And(p => p.Type.Contains(VSearchViewModel.Type));
}
if (!String.IsNullOrEmpty(VSearchViewModel.Status))
{
predicate = predicate.And(p => p.Status.Contains(VSearchViewModel.Status));
}
var result = DbSet.Where(predicate)
.OrderByDescending(o => o.CreateDate).ToList();
return(result);
}
