16,554
社区成员
发帖
与我相关
我的任务
分享
Protected Sub Form_Load(sender As Object, e As EventArgs)
BindDrpClass()
End Sub
'绑定顶级分类
Private Sub BindDrpClass()
Dim classSystem As New Bll.Class()
Dim dt As DataTable = classSystem.GetClassList("").Tables(0)
ddlClass.Items.Clear()
ddlClass.Items.Add(New ListItem("添加根栏目", "0"))
Dim drs As DataRow() = dt.[Select]("ParentID= " & 0)
For Each dr As DataRow In drs
Dim classid As String = dr("ClassID").ToString()
Dim classname As String = dr("ClassName").ToString()
'顶级分类显示形式
classname = "╋" & classname
ddlClass.Items.Add(New ListItem(classname, classid))
Dim sonparentid As Integer = Integer.Parse(classid)
Dim blank As String = "├"
'递归子分类方法
BindNode(sonparentid, dt, blank)
Next
ddlClass.DataBind()
End Sub
'绑定子分类
Private Sub BindNode(parentid As Integer, dt As DataTable, blank As String)
Dim drs As DataRow() = dt.[Select]("ParentID= " & parentid)
For Each dr As DataRow In drs
Dim classid As String = dr("ClassID").ToString()
Dim classname As String = dr("ClassName").ToString()
classname = blank & classname
ddlClass.Items.Add(New ListItem(classname, classid))
Dim sonparentid As Integer = Integer.Parse(classid)
Dim blank2 As String = blank & "─"
BindNode(sonparentid, dt, blank2)
Next
End Sub
Public Function GetClassList(strWhere As String) As DataSet
Dim strSql As New StringBuilder()
strSql.Append("select * from tb_Class ")
If strWhere.Trim() <> "" Then
strSql.Append(" where " & strWhere)
End If
Return SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString())
End Function