public List<Model.Category> CategoryPid(int id = 0)
{
string sql = "select * from category order by cate_sort asc "; //顶级分类
List<Model.Category> list = new List<Model.Category>();
DataTable sql_id = SqlHelper.GetTableText(sql, null)[0];
Model.Category cate = null;
foreach (DataRow row in sql_id.Rows)
{
//if(Convert.ToInt32(row["cate_pid"])==0){
// cate = new Model.Category();
// cate.Cate_Name = row["Cate_Name"].ToString();
// cate.Cate_Pid = Convert.ToInt32(row["cate_pid"]);
// cate.Cate_Sort = Convert.ToInt32(row["Cate_Sort"]);
// cate.Cate_State = Convert.ToInt32(row["Cate_State"].ToString());
// list.Add(cate);
// string sql_pid = "select * from category where cate_pid=" + Convert.ToInt32(row["id"]) + " order by cate_sort asc";
// DataTable sql_pids = SqlHelper.GetTableText(sql_pid, null)[0];
// foreach (DataRow rows in sql_pids.Rows)
// {
// cate = new Model.Category();
// cate.Cate_Name = rows["Cate_Name"].ToString();
// cate.Cate_Pid = Convert.ToInt32(rows["cate_pid"]);
// cate.Cate_Sort = Convert.ToInt32(rows["Cate_Sort"]);
// cate.Cate_State = Convert.ToInt32(rows["Cate_State"].ToString());
// list.Add(cate);
// }
//}
}
return list;
}
public List<Model.Category> CategoryPid(int id = 0) { string sql = "select * from category order by cate_sort asc "; //顶级分类 List<Model.Category> list = new List<Model.Category>(); DataTable sql_id = SqlHelper.GetTableText(sql, null)[0]; Model.Category cate = null; foreach (DataRow row in sql_id.Rows) { if (Convert.ToInt32(row["cate_pid"]) == id) { cate = new Model.Category(); cate.Cate_Name = row["Cate_Name"].ToString(); cate.Cate_Pid = Convert.ToInt32(row["cate_pid"]); cate.Cate_Sort = Convert.ToInt32(row["Cate_Sort"]); cate.Cate_State = Convert.ToInt32(row["Cate_State"].ToString()); list.Add(cate); list.AddRange(CategoryPid(Convert.ToInt32(row["id"]))); } } return list; }