谢谢谁能告诉我用treeview控件怎么编写能修改删除查找增加纪录的系统? 谢谢大家拉 用treeview编写的人事管理系统谁有给我一份 重谢哦QQ289481818 email:[email protected] 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我写的一个类,内容你参考下啊'============================='可以开工程单的TreeView'从产品的角度'Write By zcs'Date 2006-8-4 pm'www.vhshop.com'==============================Public Function MakeOrderRow_NeedProductionInstruction(ByRef TreeView1 As TreeView, ByRef ImageList1 As ImageList)'Screen.MousePointer = vbHourglassDim mNode As NodeDim OrderMasterRs As New RecordsetDim ClientRs As New RecordsetDim OrderRowRs As New RecordsetDim sql As StringTreeView1.Nodes.ClearTreeView1.Sorted = TrueTreeView1.ImageList = ImageList1Set mNode = TreeView1.Nodes.Add()'显示根目录mNode.text = "CanCreateNoteManufacture"mNode.Tag = "root"mNode.Image = "closed"mNode.ExpandedImage = "open"mNode.EnsureVisibleDim intProdIndex As IntegerDim intClientIndex As Integer'按客户显示'ClinentID CanUseQty:[Sum(CanUseQty]'ProductName CanUseQty:[CanUseQty]sql = "SELECT ClientID,Name,sum(FreeProductionQty) as FreeProductionQty FROM V_OrderRow_Need_ProductionInstruction " & _ " Group By ClientID,Name "ClientRs.Open sql, cn, adOpenStatic, adLockReadOnlyDo Until ClientRs.EOF 'sum(canuseqty) Set mNode = TreeView1.Nodes.Add(1, tvwChild) mNode.text = "-------CustomerName: " & ClientRs!Name mNode.Tag = "Customer" '标识表。 mNode.Key = ClientRs!ClientID & "Client" mNode.Image = "closed" mNode.ExpandedImage = "open" mNode.EnsureVisible intProdIndex = mNode.Index sql = "SELECT OrderMasterID,OrderNum,sum(FreeProductionQty) as FreeProductionQty from V_OrderRow_Need_ProductionInstruction" & _ " Where ClientID = " & ClientRs!ClientID _ & " Group By OrderMasterID,OrderNum" OrderMasterRs.Open sql, cn, adOpenStatic, adLockReadOnly Do Until OrderMasterRs.EOF 'clientname Set mNode = TreeView1.Nodes.Add(intProdIndex, tvwChild) mNode.text = "-------PONum: " & OrderMasterRs!OrderNum & "-------CanUseQty: " & OrderMasterRs!FreeProductionQty '文本。" mNode.Key = OrderMasterRs!OrderMasterID & "OrderMasterID" & ClientRs!ClientID & "ClientID" '唯一的 ID。 mNode.Tag = "OrderMaster" '标识表 mNode.Image = "closed" mNode.ExpandedImage = "open" intClientIndex = mNode.Index sql = "SELECT OrderRowID,OrderMasterID,OrderNum,ProductID,ProductName,FreeProductionQty FROM V_OrderRow_Need_ProductionInstruction " & _ " WHERE OrderMasterID=" & OrderMasterRs!OrderMasterID & _ " AND ClientID=" & ClientRs!ClientID OrderRowRs.Open sql, cn, adOpenStatic, adLockReadOnly Do Until OrderRowRs.EOF Set mNode = TreeView1.Nodes.Add(intClientIndex, tvwChild) mNode.text = "-------ProductName:" & OrderRowRs!ProductName & "-------CanUseQty: " & OrderRowRs!FreeProductionQty mNode.Key = OrderRowRs!OrderRowID & "OrderRowID" '唯一的 ID。 mNode.Tag = "PORow" '表名。 mNode.Image = "smallFile" OrderRowRs.MoveNext Loop OrderRowRs.Close OrderMasterRs.MoveNext Loop OrderMasterRs.Close ClientRs.MoveNextLoop ClientRs.Close Screen.MousePointer = vbDefault Exit FunctionErrHandle: Screen.MousePointer = vbDefaultEnd Function VB 制作安装程序时,如何让安装时提示的 界面都是中文? 关于VB的文本输出问题 问一个关于数据库的问题?? 如何将mshflexgrid生成的带有层次结构的表格的父层默认为折叠? 如何实现当图片框(picturebox)获得焦点时能够出现按钮那样的虚框? 关于DOS程序动态数值的捕获! 請各位高手幫小弟的忙呀.如何編寫一個com. 编历数据记录? 关于TREEVIEW的问题 紧急!!!服务器上调用comm组件的问题 VB程序打包后不能在其他机器正常运行?! 急~~~进来帮帮忙~~~~~~
'=============================
'可以开工程单的TreeView
'从产品的角度
'Write By zcs
'Date 2006-8-4 pm
'www.vhshop.com
'==============================
Public Function MakeOrderRow_NeedProductionInstruction(ByRef TreeView1 As TreeView, ByRef ImageList1 As ImageList)
'Screen.MousePointer = vbHourglass
Dim mNode As Node
Dim OrderMasterRs As New Recordset
Dim ClientRs As New Recordset
Dim OrderRowRs As New Recordset
Dim sql As StringTreeView1.Nodes.Clear
TreeView1.Sorted = True
TreeView1.ImageList = ImageList1
Set mNode = TreeView1.Nodes.Add()
'显示根目录
mNode.text = "CanCreateNoteManufacture"
mNode.Tag = "root"
mNode.Image = "closed"
mNode.ExpandedImage = "open"
mNode.EnsureVisible
Dim intProdIndex As Integer
Dim intClientIndex As Integer
'按客户显示
'ClinentID CanUseQty:[Sum(CanUseQty]
'ProductName CanUseQty:[CanUseQty]
sql = "SELECT ClientID,Name,sum(FreeProductionQty) as FreeProductionQty FROM V_OrderRow_Need_ProductionInstruction " & _
" Group By ClientID,Name "
ClientRs.Open sql, cn, adOpenStatic, adLockReadOnly
Do Until ClientRs.EOF
'sum(canuseqty)
Set mNode = TreeView1.Nodes.Add(1, tvwChild)
mNode.text = "-------CustomerName: " & ClientRs!Name
mNode.Tag = "Customer" '标识表。
mNode.Key = ClientRs!ClientID & "Client"
mNode.Image = "closed"
mNode.ExpandedImage = "open"
mNode.EnsureVisible
intProdIndex = mNode.Index
sql = "SELECT OrderMasterID,OrderNum,sum(FreeProductionQty) as FreeProductionQty from V_OrderRow_Need_ProductionInstruction" & _
" Where ClientID = " & ClientRs!ClientID _
& " Group By OrderMasterID,OrderNum"
OrderMasterRs.Open sql, cn, adOpenStatic, adLockReadOnly
Do Until OrderMasterRs.EOF
'clientname
Set mNode = TreeView1.Nodes.Add(intProdIndex, tvwChild)
mNode.text = "-------PONum: " & OrderMasterRs!OrderNum & "-------CanUseQty: " & OrderMasterRs!FreeProductionQty '文本。"
mNode.Key = OrderMasterRs!OrderMasterID & "OrderMasterID" & ClientRs!ClientID & "ClientID" '唯一的 ID。
mNode.Tag = "OrderMaster" '标识表
mNode.Image = "closed"
mNode.ExpandedImage = "open"
intClientIndex = mNode.Index
sql = "SELECT OrderRowID,OrderMasterID,OrderNum,ProductID,ProductName,FreeProductionQty FROM V_OrderRow_Need_ProductionInstruction " & _
" WHERE OrderMasterID=" & OrderMasterRs!OrderMasterID & _
" AND ClientID=" & ClientRs!ClientID
OrderRowRs.Open sql, cn, adOpenStatic, adLockReadOnly
Do Until OrderRowRs.EOF
Set mNode = TreeView1.Nodes.Add(intClientIndex, tvwChild)
mNode.text = "-------ProductName:" & OrderRowRs!ProductName & "-------CanUseQty: " & OrderRowRs!FreeProductionQty
mNode.Key = OrderRowRs!OrderRowID & "OrderRowID" '唯一的 ID。
mNode.Tag = "PORow" '表名。
mNode.Image = "smallFile"
OrderRowRs.MoveNext
Loop
OrderRowRs.Close
OrderMasterRs.MoveNext
Loop
OrderMasterRs.Close
ClientRs.MoveNext
Loop
ClientRs.Close
Screen.MousePointer = vbDefault
Exit Function
ErrHandle:
Screen.MousePointer = vbDefault
End Function