private List <PartCateModel> getChilder(DAO.PartsCategory p)
{
List <PartCateModel> Allcurr = new List <PartCateModel>();
string sql = "select * from PartsCategory where ParentID=" + p.ID;
List <DAO.PartsCategory> alllist = db.Database.SqlQuery <DAO.PartsCategory>(sql).ToList();
foreach (var item in alllist)
{
PartCateModel curr = new PartCateModel();
curr.currItem = item;
curr.Children = getChilder(item);
Allcurr.Add(curr);
}
return(Allcurr);
}
/// <summary>
/// 获取层次产品分类列表
/// </summary>
/// <param name="strWhere">where条件</param>
/// <param name="orderby">排序</param>
/// <param name="asc">排序方向，默认正序</param>
/// <returns></returns>
public List <PartCateModel> GetListPC()
{
List <PartCateModel> list = new List <PartCateModel>();
string sql = "select * from PartsCategory where ParentID=0 "; //顶层分类
List <DAO.PartsCategory> alllist = db.Database.SqlQuery <DAO.PartsCategory>(sql).ToList();
foreach (var item in alllist)
{
PartCateModel curr = new PartCateModel();
curr.currItem = item;
curr.Children = getChilder(item);
list.Add(curr);
}
return(list);
}
