public void BindClass()
{
ClassDT = new DataTable();
ClassDT.Columns.Add("Indent");
ClassDT.Columns.Add("pk_Category");
ClassDT.Columns.Add("ParentID");
ClassDT.Columns.Add("LevelID");
ClassDT.Columns.Add("CategoryName");
ClassDT.Columns.Add("IndexID");
ClassDT.Columns.Add("Visible", typeof(bool));
ClassDT.Columns.Add("SortID");
DataTable dt = new DataTable();
dt = Sql.SqlQueryDS("select * from " + TableName + " where ParentID=0" + Where).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = ClassDT.NewRow();
dr["Indent"] = "╋";
dr["pk_Category"] = dt.Rows[i]["pk_Category"].ToString();
dr["ParentID"] = dt.Rows[i]["ParentID"].ToString();
dr["LevelID"] = dt.Rows[i]["LevelID"].ToString();
dr["CategoryName"] = dt.Rows[i]["CategoryName"].ToString();
dr["IndexID"] = dt.Rows[i]["IndexID"].ToString();
dr["Visible"] = dt.Rows[i]["Visible"].ToString();
dr["SortID"] = dt.Rows[i]["SortID"].ToString();
ClassDT.Rows.Add(dr);
BindChild(dt.Rows[i]["pk_Category"].ToString(), "├──");
}
}
public void BindClass(DropDownList ddl)
{
DataTable dt = new DataTable();
dt = Sql.SqlQueryDS("select * from " + TableName + " where ParentID=0" + Where).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
ListItem li = new ListItem();
li.Text = "╋" + dt.Rows[i]["CategoryName"].ToString();
li.Value = dt.Rows[i]["pk_Category"].ToString();
ddl.Items.Add(li);
BindChild(dt.Rows[i]["pk_Category"].ToString(), "├──", ddl);
}
}
public void BindChild(string ParentID, string separator, DropDownList ddl)
{
DataTable dt = new DataTable();
dt = Sql.SqlQueryDS("select * from " + TableName + " where ParentID=" + ParentID).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
ListItem li = new ListItem();
li.Text = separator + dt.Rows[i]["CategoryName"].ToString();
li.Value = dt.Rows[i]["pk_Category"].ToString();
ddl.Items.Add(li);
string separator_ = separator + "───";
BindChild(dt.Rows[i]["pk_Category"].ToString(), separator_, ddl);
}
}
public void BindChild(string ParentID, string separator)
{
DataTable dt = new DataTable();
dt = Sql.SqlQueryDS("select * from " + TableName + " where ParentID=" + ParentID).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = ClassDT.NewRow();
dr["Indent"] = separator;
dr["pk_Category"] = dt.Rows[i]["pk_Category"].ToString();
dr["ParentID"] = dt.Rows[i]["ParentID"].ToString();
dr["LevelID"] = dt.Rows[i]["LevelID"].ToString();
dr["CategoryName"] = dt.Rows[i]["CategoryName"].ToString();
dr["IndexID"] = dt.Rows[i]["IndexID"].ToString();
dr["Visible"] = dt.Rows[i]["Visible"].ToString();
dr["SortID"] = dt.Rows[i]["SortID"].ToString();
ClassDT.Rows.Add(dr);
string separator_ = separator + "───";
BindChild(dt.Rows[i]["pk_Category"].ToString(), separator_);
}
}
