public void getLiJiaoSite(Linq2SqlGeography.LinqSql.FromMap.DataClasses1DataContext dc, SITE site, List<LiJiaoSite> lijiaosites) { var sp = SqlGeography.Point((double)site.latitude, (double)site.longitude, 4326); var sitebuffer = sp.STBuffer(50); //类型转换以后没有问题,单位是米 foreach (var lj in dc.城市内部主要交通干道) { if (lj.SP_GEOMETRY != null) { //SqlGeometry ->SqlGeography var ljp = SqlGeography.STGeomFromWKB(lj.SP_GEOMETRY.STAsBinary(), 4326); /* 1.掉话和立交的距离? 2.切换失败和立交的距离? 3.未接通和立交的距离? 异常事件类型 触发次数 SDCCH掉话 71 TCH掉话 215 未接通 208 切换失败 633 上行连续弱覆盖 5122 下行连续弱覆盖 783 上行连续质差 417 下行连续质差 510 * */ //基站和立交的距离? if (ljp.STIntersects(sitebuffer)) { LiJiaoSite lijiaosite = new LiJiaoSite(); lijiaosite.lj = lj; lijiaosite.site = site; lijiaosites.Add(lijiaosite); } } } Console.WriteLine(lijiaosites.Count()); WriteConsoleLine(lijiaosites); }
partial void Update城市内部主要交通干道(Linq2SqlGeography.城市内部主要交通干道 instance);
partial void DeleteSITE(Linq2SqlGeography.SITE instance);
partial void UpdateSITE(Linq2SqlGeography.SITE instance);
partial void UpdateAbis_Ho(Linq2SqlGeography.Abis_Ho instance);
partial void InsertCELLTRACINGqq(Linq2SqlGeography.CELLTRACINGqq instance);
partial void InsertCellTracing(Linq2SqlGeography.CellTracing instance);
partial void InsertEventLocating(Linq2SqlGeography.EventLocating instance);
partial void InsertMCOMNEIGH(Linq2SqlGeography.MCOMNEIGH instance);
partial void DeleteAbis_MR(Linq2SqlGeography.Abis_MR instance);
partial void UpdateAbis_MR(Linq2SqlGeography.Abis_MR instance);
partial void InsertAbis_MR(Linq2SqlGeography.Abis_MR instance);
partial void DeleteAbis_Ho(Linq2SqlGeography.Abis_Ho instance);
partial void Insert城市内部主要交通干道abc(Linq2SqlGeography.城市内部主要交通干道abc instance);
partial void DeleteMCOMNEIGH(Linq2SqlGeography.MCOMNEIGH instance);
partial void Delete城市内部主要交通干道abc(Linq2SqlGeography.城市内部主要交通干道abc instance);
partial void InsertMCOMCARRIER(Linq2SqlGeography.MCOMCARRIER instance);
partial void DeleteEventLocating(Linq2SqlGeography.EventLocating instance);
partial void DeleteMCOMCARRIER(Linq2SqlGeography.MCOMCARRIER instance);
partial void DeleteCellTracing(Linq2SqlGeography.CellTracing instance);
partial void InsertSITE(Linq2SqlGeography.SITE instance);
partial void DeleteCELLTRACINGqq(Linq2SqlGeography.CELLTRACINGqq instance);
partial void InsertAbis_Ho(Linq2SqlGeography.Abis_Ho instance);