/// <summary>
/// 绑定栏目
/// </summary>
private void DBindLm()
{
ddlColumn.Items.Add(new ListItem("栏目", "0"));
var dataTable = cDAL.GetDateList().Tables[0];
var table1 = GetNewDataTable(dataTable, " Level=1 ", " ColId ");
for (int i = 0; i < table1.Rows.Count; i++)
{
ddlColumn.Items.Add(new ListItem(table1.Rows[i]["ColName"].ToString(),//绑定父类
table1.Rows[i]["ColID"].ToString()));
var table2 = GetNewDataTable(dataTable, " ParentID='" + table1.Rows[i]["ColID"] + "'", " ColId ");
if (table2.Rows.Count > 0)
{
for (int k = 0; k < table2.Rows.Count; k++)
{
ddlColumn.Items.Add(new ListItem(HttpUtility.HtmlDecode(" ┠┄┄" + table2.Rows[k]["ColName"]),//绑定子类
table2.Rows[k]["ColID"].ToString()));
var table3 = GetNewDataTable(dataTable, " ParentID='" + table2.Rows[k]["ColID"] + "'",
" ColId");
if (table3.Rows.Count > 0)
{
for (int j = 0; j < table3.Rows.Count; j++)
{
ddlColumn.Items.Add(new ListItem(HttpUtility.HtmlDecode(" ┠┄┄┄┄" + table3.Rows[j]["ColName"]),//绑定二级子类
table3.Rows[j]["ColID"].ToString()));
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", false);
try
{
var id = Convert.ToInt32(Request.QueryString["id"]);
var ds = colDAL.GetDateList(" ParentId='" + id + "' ");
var str = string.Empty;
if (ds.Tables[0].Rows.Count > 0)
{
str = ds.Tables[0].Rows.Cast <DataRow>()
.Aggregate(str,
(current, dr) =>
current + ("," + dr["ColId"]));
}
Response.Write(str);
Response.End();
}
catch (System.Threading.ThreadAbortException ex)
{
throw ex;
}
catch
{
Response.Write("");
Response.End();
}
}