📄 账户管理.frm
字号:
VERSION 5.00
Object = "{18F95930-A715-11D1-92AC-A8AE05C10000}#7.0#0"; "UFSize.ocx"
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Object = "{0ECD9B60-23AA-11D0-B351-00A0C9055D8E}#6.0#0"; "Mshflxgd.OCX"
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "Msadodc.OCX"
Object = "{5AD81966-3173-4597-A32E-4F4620DA3B57}#3.4#0"; "U8TBCtl.ocx"
Begin VB.Form frmAccMgr
Caption = "账户管理"
ClientHeight = 5310
ClientLeft = 1275
ClientTop = 1530
ClientWidth = 8505
KeyPreview = -1 'True
LinkTopic = "Form4"
MDIChild = -1 'True
ScaleHeight = 5310
ScaleWidth = 8505
WindowState = 2 'Maximized
Begin MSAdodcLib.Adodc Adodc
Height = 330
Left = 0
Top = 4920
Visible = 0 'False
Width = 8415
_ExtentX = 14843
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = "Adodc"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin MSHierarchicalFlexGridLib.MSHFlexGrid msg
Height = 4215
Left = 3600
TabIndex = 0
Top = 600
Width = 4815
_ExtentX = 8493
_ExtentY = 7435
_Version = 393216
Cols = 11
FixedCols = 0
AllowBigSelection= 0 'False
ScrollTrack = -1 'True
FocusRect = 0
HighLight = 2
AllowUserResizing= 3
GridLineWidth = 100
RowSizingMode = 1
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty FontFixed {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_NumberOfBands = 1
_Band(0).Cols = 11
_Band(0).GridLinesBand= 2
_Band(0).GridLineWidthBand= 100
_Band(0).TextStyleBand= 0
_Band(0).TextStyleHeader= 0
End
Begin JackSize.JackResize jkrTree
Height = 3915
Left = 3480
TabIndex = 3
Top = 720
Width = 195
_ExtentX = 344
_ExtentY = 6906
End
Begin MSComctlLib.TreeView treStyle
Height = 4170
Left = 0
TabIndex = 1
Top = 600
Width = 3435
_ExtentX = 6059
_ExtentY = 7355
_Version = 393217
HideSelection = 0 'False
Indentation = 529
Style = 5
HotTracking = -1 'True
ImageList = "ilsTlbTre"
Appearance = 1
OLEDropMode = 1
End
Begin MSComctlLib.Toolbar tlbAction
Align = 1 'Align Top
Height = 540
Left = 0
TabIndex = 2
Top = 0
Width = 8505
_ExtentX = 15002
_ExtentY = 953
ButtonWidth = 820
ButtonHeight = 953
AllowCustomize = 0 'False
Wrappable = 0 'False
Style = 1
ImageList = "ilsTlb"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 16
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "打印"
Key = "Print"
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "预览"
Key = "Preview"
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "输出"
Key = "Export"
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "分组"
Key = "Grouping"
EndProperty
BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "查找"
Key = "Find"
EndProperty
BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "栏目"
Key = "ColumnSet"
EndProperty
BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "增加"
Key = "AddNew"
EndProperty
BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "修改"
Key = "Edit"
EndProperty
BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "删除"
Key = "Delete"
EndProperty
BeginProperty Button12 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button13 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "刷新"
Key = "Refresh"
EndProperty
BeginProperty Button14 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button15 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "帮助"
Key = "Help"
EndProperty
BeginProperty Button16 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "退出"
Key = "Exit"
EndProperty
EndProperty
End
Begin MSComctlLib.ImageList ilsTlb
Left = 200
Top = 2000
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 3
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "账户管理.frx":0000
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "账户管理.frx":0452
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "账户管理.frx":08A4
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.ImageList ilsTlbTre
Left = 0
Top = 0
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 3
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "账户管理.frx":0CF6
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "账户管理.frx":1148
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "账户管理.frx":159A
Key = ""
EndProperty
EndProperty
End
Begin prjTBCtrl.CTBCtrl ocxCtbTool
Height = 660
Left = 0
Top = 0
Width = 3975
_ExtentX = 7011
_ExtentY = 1164
End
End
Attribute VB_Name = "frmAccMgr"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'--------------------------------
'时间:2001.05.24
'版权:北京用友软件股份有限公司
'设计:章景峰
'编码:章景峰
'说明:U8资金管理---账户管理
'--------------------------------
Option Explicit
Private Const conMoveLimit = 1000
Private Const m_conBIStyle = 1
Public flag As Boolean
Public IsGroup As Boolean
Public ShowMode As ShowModeEnum
Private m_OldEO As U8FDEso.EntityObject
Private m_EO As U8FDEso.EntityObject
Private m_sql As String
Private LeftRight As Byte
Private QryFldSqc() As String
Private PrintTypeList As String
Private PrintSizeList As String
Private SetPrintDataStyleXML_flag As Boolean
Public Property Get EO() As U8FDEso.EntityObject
Set EO = m_EO
End Property
Public Property Set EO(NewEO As U8FDEso.EntityObject)
Set m_EO = NewEO
End Property
Private Sub CreateTree(ByVal ParentOID As String)
Dim objEO As U8FDEso.EntityObject
Dim objAccGrpBI As New U8FDBso.clsAccGrpBI
Dim objOID As New U8FDEso.OIDObject
Dim i As Integer, RecordCount As Long
Set objEO = objAccGrpBI.MoveTo(g_sDataSourceName, U8FDEso.esoFirst, , , ParentOID)
RecordCount = objAccGrpBI.RecordCount(g_sDataSourceName, objEO, ParentOID)
For i = 1 To RecordCount
If IsNull(objEO("parent_id")) Or Len(Trim(objEO("parent_id"))) = 0 Then
Me.treStyle.Nodes.Add , , "K" & objEO("accgrp_id"), "【" & objEO("accgrp_code") & "】" & objEO("accgrp_name")
Me.treStyle.Nodes("K" & objEO("accgrp_id")).Image = 3
CreateTree objEO("accgrp_id")
Else
Me.treStyle.Nodes.Add "K" & objEO("parent_id"), tvwChild, "K" & objEO("accgrp_id"), "【" & objEO("accgrp_code") & "】" & objEO("accgrp_name")
'Me.treStyle.Nodes("K" & objEO("parent_id")).Expanded = True
Me.treStyle.Nodes("K" & objEO("parent_id")).Image = 1
Me.treStyle.Nodes("K" & objEO("accgrp_id")).Image = 3
CreateTree objEO("accgrp_id")
End If
If i < RecordCount Then
objOID = objEO("accgrp_id")
Set objEO = objAccGrpBI.MoveTo(g_sDataSourceName, U8FDEso.esoNext, , objOID, ParentOID)
End If
Next
If RecordCount = 0 Then
If Not (IsNull(ParentOID) Or ParentOID = "") Then
Me.treStyle.Nodes("K" & Trim(ParentOID)).Image = 3
End If
End If
Set objAccGrpBI = Nothing
Set objOID = Nothing
Set objEO = Nothing
'Dim con As New ADODB.Connection
'Dim rec As New ADODB.Recordset
'Dim SQL As String
'Dim bNoRepeatAcc As String
'
'con.Open g_sDataSourceName
'If IsNull(ParentOID) Or ParentOID = "" Then
' SQL = "SELECT * From fd_accgrp where parent_id is Null order by accgrp_id"
'Else
' SQL = "SELECT * From fd_accgrp where parent_id='" & Mid(ParentOID, 1, Len(ParentOID) - 0) & "' ORDER BY accgrp_id"
'End If
'
'rec.Open SQL, con, adOpenStatic, adLockOptimistic
'If Not rec.EOF Then
' Do Until rec.EOF
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -