/// <summary>
///为县级Areas和测站Msite提供树形数据
/// </summary>
/// <returns></returns>
public List <Model.ViewMode.TreeMsite> GetAreasTree(int ProvinceID)
{
string str = "select * from Areas where ProvinceID=" + ProvinceID;
DataTable dt = SqlHelper.ExecuteDataTable(str, CommandType.Text, null);
List <Model.ViewMode.TreeMsite> Tree = new List <Model.ViewMode.TreeMsite>();
foreach (DataRow dw in dt.Rows)
{
Model.ViewMode.TreeMsite AreasTree = new Model.ViewMode.TreeMsite();
AreasTree.AreaSID = Convert.ToInt32(dw["AreaSID"]);
AreasTree.AreasName = dw["AreasName"].ToString();
AreasTree.Mistes = new DAL.Msite().GetMsiteByAreasId(AreasTree.AreaSID);
Tree.Add(AreasTree);
}
return(Tree);
}
/// <summary>
/// 县
/// </summary>
/// <returns></returns>
public List <Model.ViewMode.TreeMsite> GetMsiteList()
{
List <Model.ViewMode.TreeMsite> list = new List <Model.ViewMode.TreeMsite>();
string str = "select * from Areas";
SqlDataReader dr = SqlHelper.ExecuteReader(str, System.Data.CommandType.Text, null);
if (dr.HasRows)
{
while (dr.Read())
{
Model.ViewMode.TreeMsite AreasTree = new Model.ViewMode.TreeMsite();
AreasTree.AreaSID = dr.GetInt32(0);
AreasTree.AreasName = dr.GetString(1);
list.Add(AreasTree);
list.Add(AreasTree);
}
return(list);
}
else
{
list = null;
return(list);
}
}
