#region Select(无限级分类列表)
public static List<ClassModel> Select()
{
DataTable dt = GetTable();
List<ClassModel> list = new List<ClassModel>();
ClassModel model = new ClassModel();
model.id = 0;
model.name = "===请选择类别===";
list.Add(model);
OrderSelect(dt, list, 0, "|-");
dt.Clear();
return list;
}
static DataTable GetTable()
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
Database.RunProc("CLASS_Select", out ds);
dt = ds.Tables[0];
return dt;
}
static void OrderSelect(DataTable dt, List<ClassModel> list, int classid, string strTop)
{
DataRow[] rows = dt.Select("classid=" + classid);
for (int i = 0; i < rows.Length; i++)
{
ClassModel model = new ClassModel();
model.id = int.Parse(rows[i]["id"].ToString());
model.name = strTop + rows[i]["name"].ToString();
list.Add(model);
string str = " " + strTop;
int id = int.Parse(rows[i]["id"].ToString());
OrderSelect(dt, list, id, str);
}
}
#endregion
public static List<ClassModel> Select()
{
DataTable dt = GetTable();
List<ClassModel> list = new List<ClassModel>();
ClassModel model = new ClassModel();
model.id = 0;
model.name = "===请选择类别===";
list.Add(model);
OrderSelect(dt, list, 0, "|-");
dt.Clear();
return list;
}
static DataTable GetTable()
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
Database.RunProc("CLASS_Select", out ds);
dt = ds.Tables[0];
return dt;
}
static void OrderSelect(DataTable dt, List<ClassModel> list, int classid, string strTop)
{
DataRow[] rows = dt.Select("classid=" + classid);
for (int i = 0; i < rows.Length; i++)
{
ClassModel model = new ClassModel();
model.id = int.Parse(rows[i]["id"].ToString());
model.name = strTop + rows[i]["name"].ToString();
list.Add(model);
string str = " " + strTop;
int id = int.Parse(rows[i]["id"].ToString());
OrderSelect(dt, list, id, str);
}
}
#endregion