/// <summary> /// 获取区域id和名称的集合 /// </summary> /// <returns></returns> public List <AreaId_Name> GetAreaList() { List <AreaId_Name> r = new List <AreaId_Name>(); var list = GetExist(); foreach (var item in list) { AreaId_Name area = new AreaId_Name(item); r.Add(area); } return(r); }
/// <summary> /// 根据经纬度,获得目前所在位置(用Location) /// </summary> /// <param name="lat"></param> /// <param name="lng"></param> public List <AreaId_Name> GetAreaByLocation(decimal lat, decimal lng) { List <AreaId_Name> r = new List <AreaId_Name>(); //var list = Get().Where(p => p.lat1 > lat && p.lat2 < lat && p.lng1 < lng && p.lng2 > lng).ToList(); var list = CacheHelper.GetByCondition <AreaInfo>("areainfo", " lat1>" + lat + " and lat2<" + lat + " and lng1<" + lng + " and lng2>" + lng + " and isDeleted=0"); foreach (var item in list) { AreaId_Name area = new AreaId_Name(item); r.Add(area); } return(r); }