/// <summary>
/// 根据二级列表元素的ID
/// 查找其上级元素的ID
/// 然后找出一级元素下的所有的二级元素
/// </summary>
/// <param name="sonId"></param>
/// <returns></returns>
private List <Entity.Son> getSonList(Guid sonId)
{
DboUtils db = new DboUtils();
String sql1 = "select up_item from top_sub where id='" + sonId + "'";
DataSet ds1 = db.query(sql1);
if (ds1.Tables[0].Rows.Count > 0)
{
Guid parentId = (Guid)ds1.Tables[0].Rows[0]["up_item"];
String sql = "select * from top_sub where up_item='" + parentId + "' order by position";
DataSet ds = db.query(sql);
List <Entity.Son> list = new List <Entity.Son>();
foreach (DataRow mDr in ds.Tables[0].Rows)
{
Entity.Son son = new Entity.Son()
{
id = (Guid)mDr["id"],
title = mDr["title"].ToString(),
up_item = (Guid)mDr["up_item"],
position = (int)mDr["position"],
pageType = mDr["pagetype"].ToString()
};
list.Add(son);
}
return(list);
}
else
{
return(new List <Entity.Son>());
}
}
private void AddSon(Entity.Nav nav, DataRow mDr)
{
Entity.Son son = new Entity.Son();
son.id = (Guid)mDr["sonid"];
son.up_item = (Guid)mDr["up_item"];
son.position = (int)mDr["sonposition"];
son.title = mDr["sontitle"].ToString();
son.createtime = (DateTime)mDr["createtime"];
son.pageType = mDr["pagetype"].ToString();
nav.sonList.Add(son);
}
