/*从 数据库 获取 当前小区 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(); } }