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