/// <summary> /// 从DataSet中加载城市信息 /// </summary> /// <param name="ds"></param> void InitZoneFromDataSet(DataSet ds) { this.ZoneList = new ObservableCollection <Entity.Zone>(); this.AreaList = new ObservableCollection <Entity.Area>(); var dtZone = ds.Tables[0]; var dtArea = ds.Tables[1]; this.ZoneList.Clear(); foreach (DataRow dr in dtZone.Rows) { var zone = new Entity.Zone() { ID = Convert.ToInt32(dr["ID"]), Name = dr["Zone"].ToString(), }; var drAreas = dtArea.Select("ZoneID=" + zone.ID); foreach (DataRow drArea in drAreas) { var area = new Entity.Area() { ID = Convert.ToInt32(drArea["ID"]), ZoneID = Convert.ToInt32(drArea["ZoneID"]), Name = drArea["Area"].ToString(), AreaCode = drArea["AreaCode"].ToString() }; this.AreaList.Add(area); } this.ZoneList.Add(zone); } }
public List <Entity.Zone> LoadZones() { DAL.ZoneDA.IZoneDA zoneDA = new DAL.ZoneDA.ZoneDAO(); List <DAL.Zone> zlist = zoneDA.GetZone(); List <Entity.Zone> resList = new List <Entity.Zone>(); foreach (DAL.Zone z in zlist) { z.Name = z.Name.Trim(); Entity.Zone ztmp = new Entity.Zone(); ztmp.DAL_SetZone(z); resList.Add(ztmp); //consume the random color Entity.Zone.NextRandomColor(); } _map.Zones = resList; _DAL_Zone = zlist; return(resList); }