📄 frmoperatelog.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form frmOperateLog
BorderStyle = 3 'Fixed Dialog
Caption = "系统操作日志"
ClientHeight = 6450
ClientLeft = 45
ClientTop = 330
ClientWidth = 7965
Icon = "frmOperateLog.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 6450
ScaleWidth = 7965
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin VB.Frame fraFind
Caption = "查询操作日志"
Height = 1335
Left = 120
TabIndex = 1
Top = 120
Width = 7695
Begin VB.ComboBox cboUser
Height = 300
Left = 1440
Style = 2 'Dropdown List
TabIndex = 5
Top = 360
Width = 1335
End
Begin VB.ComboBox cboFindType
Height = 300
ItemData = "frmOperateLog.frx":000C
Left = 4200
List = "frmOperateLog.frx":0016
Style = 2 'Dropdown List
TabIndex = 4
Top = 360
Width = 1335
End
Begin VB.CommandButton cmdfFind
Caption = "查 询"
Default = -1 'True
Height = 375
Left = 6360
TabIndex = 3
Top = 360
Width = 975
End
Begin VB.CommandButton cmdPrint
Caption = "打 印"
Height = 375
Left = 6360
TabIndex = 2
Top = 840
Width = 975
End
Begin MSComCtl2.DTPicker DTPTo
Height = 300
Left = 4200
TabIndex = 6
Top = 840
Width = 1335
_ExtentX = 2355
_ExtentY = 529
_Version = 393216
Format = 24772609
CurrentDate = 38057
End
Begin MSComCtl2.DTPicker DTPFrom
Height = 300
Left = 1440
TabIndex = 7
Top = 840
Width = 1335
_ExtentX = 2355
_ExtentY = 529
_Version = 393216
Format = 24772609
CurrentDate = 38057
End
Begin VB.Label lbluser
AutoSize = -1 'True
Caption = "用户："
Height = 180
Left = 360
TabIndex = 11
Top = 400
Width = 540
End
Begin VB.Label lblType
AutoSize = -1 'True
Caption = "查询方式："
Height = 180
Left = 3120
TabIndex = 10
Top = 400
Width = 900
End
Begin VB.Label lblFrom
AutoSize = -1 'True
Caption = "从："
Height = 180
Left = 360
TabIndex = 9
Top = 900
Width = 360
End
Begin VB.Label lblTo
AutoSize = -1 'True
Caption = "到："
Height = 180
Left = 3120
TabIndex = 8
Top = 900
Width = 360
End
End
Begin MSComctlLib.ListView lvwOperateLog
Height = 4815
Left = 120
TabIndex = 0
Top = 1560
Width = 7695
_ExtentX = 13573
_ExtentY = 8493
LabelWrap = -1 'True
HideSelection = -1 'True
FullRowSelect = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 1
NumItems = 0
End
End
Attribute VB_Name = "frmOperateLog"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'' ''
''Filename frmOperateLog.frm ''
'' ''
''Created On 2004.4.25 ''
'' ''
''Description 查询操作日志信息并提供打印功能 ''
'' ''
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Dim rsUser As Recordset
Dim rsDeleteLog As Recordset
Public rsOperateLog As Recordset
Dim lItem As ListItem
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''根据用户的日期选择，显示或隐藏相关信息 ''
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private Sub cboFindType_Click()
If cboFindType.Text = "单日查询" Then
lblFrom.Caption = "查询日期："
lblTo.Visible = False
DTPTo.Visible = False
ElseIf cboFindType.Text = "时间段查询" Then
lblFrom.Caption = "从："
lblTo.Visible = True
DTPTo.Visible = True
End If
End Sub
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''根据查询条件查询信息，并将其结果显示在下方的列表中 ''
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private Sub cmdfFind_Click()
Set rsOperateLog = New Recordset
Dim strfind As String
strfind = "select * from TbOperateLog,tbuser" & where & " and TbOperateLog.u_id=tbuser.u_id"
rsOperateLog.Open strfind, Modmain.conn, 3, 2
LoadDate
Set rsDeleteLog = New Recordset
rsDeleteLog.Open "select OL_ID, TbOperateLog.U_ID,TIME,EVENTS,Description,Date from TbOperateLog,tbuser" & where & " and TbOperateLog.u_id=tbuser.u_id", Modmain.conn, 3, 2
End Sub
Private Function where() As String '查询条件
Dim s As String
If DTPTo.Visible = False Then
If s <> "" Then
s = s & "and Date like '" & DTPFrom.Value & "'"
Else
s = " where Date like '" & DTPFrom.Value & "'"
End If
Else
Dim dtFrom As String
Dim dtTo As String
'''''''''''''''''手工转换日期格式使其与ACCESS数据库相对应''''''''''''''''''''''''
dtFrom = Month(DTPFrom.Value) & "/" & Day(DTPFrom.Value) & "/" & Year(DTPFrom.Value)
dtTo = Month(DTPTo.Value) & "/" & Day(DTPTo.Value) & "/" & Year(DTPTo.Value)
If s <> "" Then
s = s & "and Date>= #" & dtFrom & "# and Date<=#" & dtTo & "#"
Else
s = " where Date>=#" & dtFrom & "# and Date<=#" & dtTo & "#"
End If
End If
If cboUser.Text <> "" Then
Set rsUser = New Recordset
rsUser.Open "select * from TbUser Where U_Name like '" & cboUser.Text & "'", Modmain.conn, 3, 2
If s <> "" Then
s = s & " and tbuser.U_ID like '" & rsUser.Fields!U_ID & "'"
Else
s = " where tbuser.U_ID like '" & rsUser.Fields!U_ID & "'"
End If
End If
where = s
End Function
Private Sub cmdPrint_Click()
If rsOperateLog.RecordCount = 0 Then
MsgBox "没有可打印的信息！", vbOKOnly + vbExclamation, "机房管理"
Else
If MsgBox("确实要打印吗?打印后系统将删除打印的信息！", vbYesNo + vbQuestion, "机房管理") = vbYes Then
DROperateLog.Show 1
While Not rsDeleteLog.EOF
rsDeleteLog.Delete
rsDeleteLog.MoveNext
Wend
End If
End If
lvwOperateLog.ListItems.Clear
End Sub
Private Sub DTPFrom_Change()
If DTPFrom.Value <> "" Then
DTPTo.MinDate = DTPFrom.Value
End If
End Sub
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''给用户列表框赋值 ''
''配置lvwExitCard控件 ''
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private Sub Form_Load()
Set rsUser = New Recordset
rsUser.Open "select * from TbUser", Modmain.conn, 3, 2
While Not rsUser.EOF
cboUser.AddItem (rsUser.Fields!u_name)
rsUser.MoveNext
Wend
cboUser.AddItem ""
rsUser.Close
Set rsUser = Nothing
lvwOperateLog.ColumnHeaders.Add , , "用户名", lvwOperateLog.Width / 8 '配置lvwInstitute控件
lvwOperateLog.ColumnHeaders.Add , , "操作时间", lvwOperateLog.Width / 4.5
lvwOperateLog.ColumnHeaders.Add , , "操作事件", lvwOperateLog.Width / 6
lvwOperateLog.ColumnHeaders.Add , , "事件描述", lvwOperateLog.Width / 2
lvwOperateLog.GridLines = True
lvwOperateLog.Sorted = True
lvwOperateLog.View = lvwReport
Set rsOperateLog = New Recordset
rsOperateLog.Open "select * from TbOperateLog,tbuser where TbOperateLog.U_ID=tbuser.u_id", Modmain.conn, 3, 2
LoadDate
Set rsDeleteLog = New Recordset
rsDeleteLog.Open "select * from TbOperateLog", Modmain.conn, 3, 2
End Sub
Private Sub LoadDate()
lvwOperateLog.ListItems.Clear
While Not rsOperateLog.EOF ' 添加相应的 ListItem
Set lItem = lvwOperateLog.ListItems.Add
lItem.Text = rsOperateLog.Fields("u_name")
lItem.SubItems(1) = rsOperateLog.Fields("Date") & " " & rsOperateLog.Fields("time")
lItem.SubItems(2) = rsOperateLog.Fields("events")
lItem.SubItems(3) = rsOperateLog.Fields!Description
rsOperateLog.MoveNext
Wend
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -