/*从 数据库 获取 当前小区 3层之内 的 对打小区信息*/
private void initializeLyaer_OverlaySector(DB db, XML xml)
{
string sqlInitLyDuidaInfo;
string temSql;
xml.getSqlCommand(xmlNodeLayerSectors, out sqlInitLyDuidaInfo);
SqlDataReader reader;
foreach (Sector s in sectorList)
{
temSql = sqlInitLyDuidaInfo.Replace("@sectorId", s.sectorID);
reader = db.selectR(temSql);
while (reader.Read())
{
NearSector sector = new NearSector(reader.GetString(0), isInSectorList(reader.GetString(0)), reader.GetInt32(1));
if (sector.NearIndex != -1)
s.ly_over_List.Add(sector);
}
reader.Close();
}
}
/*从 数据库 读取 每个小区 的 第一层地理邻区*/
private void initializeFirNearSector(DB db, XML xml)
{
string sqlInitFirstNear;
string tempSql;
xml.getSqlCommand(xmlNodeFirstNearSectors, out sqlInitFirstNear);
SqlDataReader reader;
for (int i = 0; i < sectorList.Count; i++)
{
tempSql = sqlInitFirstNear.Replace("@sectorId", sectorList[i].sectorID);
reader = db.selectR(tempSql);
while (reader.Read())
{
NearSector sector = new NearSector(reader.GetString(0), isInSectorList(reader.GetString(0)), 1);
if (sector.NearIndex != -1)
{
sectorList[i].fnList.Add(sector);
sectorList[i].fnIndexList.Add(sector.NearIndex);
//if (!sectorList[i].faIndexList.Contains(sector.NearIndex))
//{//不是一阶邻区则添加到一阶邻区里
// sectorList[i].faIndexList.Add(sector.NearIndex);
// double d = CJWDHelper.GetDistance2(sectorList[i].Longitude, sectorList[i].Latitude, sectorList[sector.NearIndex].Longitude, sectorList[sector.NearIndex].Latitude);
// sectorList[i].faList.Add(new FirAdjSector(sector.NearSectorID, sector.NearIndex, d));
// sectorList[i].fnNotfaIndexList.Add(sector.NearIndex);//记录非一阶邻区的一层邻区
//}
}
}
reader.Close();
}
}
