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