📄 frmbaseinfoport.frm
字号:
VERSION 5.00
Object = "{4932CEF1-2CAA-11D2-A165-0060081C43D9}#2.0#0"; "Actbar2.OCX"
Object = "{0ECD9B60-23AA-11D0-B351-00A0C9055D8E}#6.0#0"; "MSHFLXGD.OCX"
Begin VB.Form frmBasicPort
Caption = "港口信息設置"
ClientHeight = 3195
ClientLeft = 60
ClientTop = 345
ClientWidth = 4680
LinkTopic = "Form1"
MDIChild = -1 'True
ScaleHeight = 3195
ScaleWidth = 4680
Begin ActiveBar2LibraryCtl.ActiveBar2 ActiveBar21
Height = 11115
Left = 0
TabIndex = 0
Top = 0
Width = 15240
_LayoutVersion = 1
_ExtentX = 26882
_ExtentY = 19606
_DataPath = ""
Bands = "frmBaseinfoPort.frx":0000
Begin VB.Frame Frame1
Height = 8535
Left = 60
TabIndex = 1
Top = 540
Width = 15015
Begin MSHierarchicalFlexGridLib.MSHFlexGrid MSHF2
Height = 8175
Left = 120
TabIndex = 3
Top = 240
Width = 3615
_ExtentX = 6376
_ExtentY = 14420
_Version = 393216
Cols = 1
FixedCols = 0
AllowUserResizing= 1
_NumberOfBands = 1
_Band(0).Cols = 1
_Band(0).GridLinesBand= 1
_Band(0).TextStyleBand= 0
_Band(0).TextStyleHeader= 0
End
Begin MSHierarchicalFlexGridLib.MSHFlexGrid MSHF1
Height = 8175
Left = 3840
TabIndex = 2
Top = 240
Width = 11055
_ExtentX = 19500
_ExtentY = 14420
_Version = 393216
AllowUserResizing= 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
_NumberOfBands = 1
_Band(0).Cols = 2
End
End
End
End
Attribute VB_Name = "frmBasicPort"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'Dim rs As New ADODB.Recordset
Dim newItem As Boolean
Dim lngrow As Long
Private Sub ActiveBar21_ToolClick(ByVal Tool As ActiveBar2LibraryCtl.Tool)
Select Case Tool.Name
Case "cmdAdd":
NewOperatorInf
Case "cmdEdit":
EditOperatorInf
Case "cmdDel":
DelOperatorInf
Case "cmdCancel":
Unload Me
Case "cmdExport":
Dim strFile As String
frmMain.CDFile.ShowOpen
strFile = frmMain.CDFile.FileName
If strFile = "" Then Exit Sub
ExportExcel MSHF1, strFile
End Select
End Sub
Private Sub Form_Load()
FormInit Me, True
SetObjectWH Frame1
SetObjectWH MSHF1
SetObjectWH MSHF2
FillMshf1 ("select * from tBasicPort")
FillMshf2 ("select * from tBasicCountries")
Me.Caption = "港口信息設置"
ActiveBar21.Bands("toolbar").Tools.item("cmdAdd").Enabled = False
ActiveBar21.Bands("toolbar").Tools.item("cmdDel").Enabled = False
ActiveBar21.Bands("toolbar").Tools.item("cmdEdit").Enabled = False
End Sub
'增加港口信息
Private Sub NewOperatorInf()
frmBasicPortInfo.newItem = True
If lngrow <= 1 Then Exit Sub
frmBasicPortInfo.InitInfo MSHF2.TextMatrix(lngrow, 0)
frmBasicPortInfo.Show vbModal
ActiveBar21.Bands("toolbar").Tools.item("cmdDel").Enabled = False
ActiveBar21.Bands("toolbar").Tools.item("cmdEdit").Enabled = False
End Sub
'编辑港口信息
Private Sub EditOperatorInf()
frmBasicPortInfo.newItem = False
If lngrow = 1 Then Exit Sub
frmBasicPortInfo.InitInfo MSHF1.TextMatrix(lngrow, 1)
frmBasicPortInfo.Show vbModal
ActiveBar21.Bands("toolbar").Tools.item("cmdDel").Enabled = False
ActiveBar21.Bands("toolbar").Tools.item("cmdEdit").Enabled = False
End Sub
'删除港口信息
Private Sub DelOperatorInf()
Dim strSql As String
If lngrow > MSHF1.Rows - 1 Then Exit Sub
If lngrow <= 1 Then
MsgBox "请选中一条要删除的记录！", vbExclamation, "提示"
Exit Sub
End If
On Error GoTo errHandle
If MsgBox("确定要刪除？", vbQuestion + vbYesNo, "询问") = vbNo Then
Exit Sub
Else
strSql = "delete from tBasicPort where id=" & MSHF1.TextMatrix(lngrow, 1)
objDatabase.ExecCmd strSql
MsgBox "刪除成功!", vbInformation, "提示"
End If
FillMshf1 ("select * from tBasicPort")
ActiveBar21.Bands("toolbar").Tools.item("cmdDel").Enabled = False
ActiveBar21.Bands("toolbar").Tools.item("cmdEdit").Enabled = False
Exit Sub
errHandle:
objDatabase.DatabaseError
End Sub
Public Sub FillMshf2(ByVal strSql As String)
Dim rs As ADODB.Recordset
Dim lngrow As Long
Dim j As Long
Screen.MousePointer = vbHourglass
On Error GoTo errLabel
Set rs = New ADODB.Recordset
With rs
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
Set .ActiveConnection = Cn
End With
rs.Open strSql
With MSHF2
.Redraw = False
.Rows = 2
.Cols = 1
.Clear
.WordWrap = False
.TextMatrix(0, 0) = "國家信息 | 國家名稱"
.ColWidth(0) = MSHF2.Width
'.....................................................
.Rows = rs.RecordCount + 2
On Error Resume Next
For lngrow = 2 To rs.RecordCount + 1
.TextMatrix(lngrow, 0) = rs.Fields!CountriesName
rs.MoveNext
Next
lngrow = 0
.TextMatrix(1, 0) = "总計 " & .Rows - 2 & " 條信息"
For j = 2 To .Rows - 1
If j Mod 2 = 0 Then
.row = j
.CellBackColor = objDispalyIni.GetItemColor
Else
.row = j
.CellBackColor = objDispalyIni.GetItemSpaceColor
End If
Next j
.row = 1
.CellBackColor = &HC0C0FF
.Redraw = True
End With
rs.Close
remClear:
Set rs = Nothing
Screen.MousePointer = vbDefault
Exit Sub
errLabel:
On Error Resume Next
MSHF2.Redraw = True
GoTo remClear
End Sub
Public Sub FillMshf1(ByVal strSql As String)
Dim rs As ADODB.Recordset
Dim lngrow As Long
Screen.MousePointer = vbHourglass
On Error GoTo errLabel
Set rs = New ADODB.Recordset
With rs
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
Set .ActiveConnection = Cn
End With
rs.Open strSql
With MSHF1
.Redraw = False
.Rows = 2
'.FixedRows = 2
.Cols = 8
'.FixedCols = 3
.Clear
'初始化
.WordWrap = False
.TextMatrix(0, 0) = "序号"
.TextMatrix(0, 1) = ""
.TextMatrix(0, 2) = "國家名稱"
.TextMatrix(0, 3) = "國家英文名稱"
.TextMatrix(0, 4) = "港口名稱"
.TextMatrix(0, 5) = "港口英文名稱"
.TextMatrix(0, 6) = "填寫人"
.TextMatrix(0, 7) = "填寫日期"
.ColWidth(0) = 600
.ColWidth(1) = 0
.ColWidth(2) = 2000
.ColWidth(3) = 2000
.ColWidth(4) = 2000
.ColWidth(5) = 2000
.ColWidth(6) = 2000
.ColWidth(7) = 2000
'.....................................................
.Rows = rs.RecordCount + 2
On Error Resume Next
For lngrow = 2 To rs.RecordCount + 1
.TextMatrix(lngrow, 0) = lngrow - 1
.TextMatrix(lngrow, 1) = NullValue(rs.Fields!ID)
.TextMatrix(lngrow, 2) = Trim$(NullValue(rs.Fields!StateName))
.TextMatrix(lngrow, 3) = Trim$(NullValue(rs.Fields!eStateName))
.TextMatrix(lngrow, 4) = Trim$(NullValue(rs.Fields!PortName))
.TextMatrix(lngrow, 5) = Trim$(NullValue(rs.Fields!ePortName))
.TextMatrix(lngrow, 6) = Trim$(NullValue(rs.Fields!UpdateOperator))
.TextMatrix(lngrow, 7) = Trim$(NullValue(rs.Fields!UpdateDate))
rs.MoveNext
Next
lngrow = 0
.TextMatrix(1, 0) = ""
.TextMatrix(1, 2) = "總計 " & .Rows - 2 & " 條信息"
SetItemBackColor MSHF1
.Redraw = True
End With
rs.Close
remClear:
Set rs = Nothing
Screen.MousePointer = vbDefault
Exit Sub
errLabel:
On Error Resume Next
MSHF1.Redraw = True
GoTo remClear
End Sub
Private Sub MSHF1_Click()
lngrow = Val(MSHF1.row)
MSHF1.row = lngrow
MSHF1.col = 0
MSHF1.ColSel = MSHF1.Cols - 1
ActiveBar21.Bands("toolbar").Tools.item("cmdDel").Enabled = True
ActiveBar21.Bands("toolbar").Tools.item("cmdEdit").Enabled = True
End Sub
Private Sub MSHF1_DblClick()
EditOperatorInf
End Sub
Private Sub MSHF2_Click()
Dim strId As String
lngrow = Val(MSHF2.row)
If lngrow = 1 Then
FillMshf1 ("select * from tBasicPort")
Exit Sub
End If
strId = MSHF2.TextMatrix(lngrow, 0)
FillMshf1 ("select * from tBasicPort where stateName='" & strId & "'")
ActiveBar21.Bands("toolbar").Tools.item("cmdAdd").Enabled = True
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -