/// <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(); } }