📄 form_wenjian.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form form_WenJian
BorderStyle = 1 'Fixed Single
ClientHeight = 6255
ClientLeft = 45
ClientTop = 330
ClientWidth = 10920
KeyPreview = -1 'True
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
Picture = "form_WenJian.frx":0000
ScaleHeight = 6255
ScaleWidth = 10920
StartUpPosition = 2 '屏幕中心
Begin VB.CommandButton Command7
Height = 315
Left = 7368
Picture = "form_WenJian.frx":2209F
Style = 1 'Graphical
TabIndex = 9
Top = 5820
Width = 1065
End
Begin VB.CommandButton Command1
Height = 315
Left = 3708
Picture = "form_WenJian.frx":224BF
Style = 1 'Graphical
TabIndex = 8
Top = 5820
Width = 1065
End
Begin VB.CommandButton Command2
Height = 315
Left = 4928
Picture = "form_WenJian.frx":2259E
Style = 1 'Graphical
TabIndex = 7
Top = 5820
Width = 1065
End
Begin VB.CommandButton Command3
Height = 315
Left = 6148
Picture = "form_WenJian.frx":2267D
Style = 1 'Graphical
TabIndex = 6
Top = 5820
Width = 1065
End
Begin VB.CommandButton Command4
Height = 315
Left = 2488
Picture = "form_WenJian.frx":22762
Style = 1 'Graphical
TabIndex = 5
Top = 5820
Width = 1065
End
Begin VB.CommandButton Command5
Cancel = -1 'True
Height = 315
Left = 8588
Picture = "form_WenJian.frx":228AA
Style = 1 'Graphical
TabIndex = 4
Top = 5820
Width = 1065
End
Begin VB.CommandButton Command6
Height = 315
Left = 1268
Picture = "form_WenJian.frx":22982
Style = 1 'Graphical
TabIndex = 3
Top = 5820
Width = 1065
End
Begin MSComctlLib.ListView ListView2
Height = 5085
Left = 180
TabIndex = 1
Top = 480
Width = 10590
_ExtentX = 18680
_ExtentY = 8969
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = -1 'True
AllowReorder = -1 'True
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = 12640511
BorderStyle = 1
Appearance = 1
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
NumItems = 0
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "Label2"
Height = 225
Left = 9660
TabIndex = 2
Top = 210
Width = 1065
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "归档文件列表"
BeginProperty Font
Name = "隶书"
Size = 18
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 4500
TabIndex = 0
Top = 90
Width = 2160
End
End
Attribute VB_Name = "form_WenJian"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Call closeRecordSet(rs)
queryflag = "no"
flag = "Insert"
form_WenShu_WJ.Show 1
End Sub
Private Sub Command2_Click()
queryflag = "no"
flag = "Modify"
If ListView2.ListItems.Count = 0 Then
MsgBox "没有记录!", vbInformation, ""
Exit Sub
End If
num = ListView2.SelectedItem.SubItems(1)
form_WenShu_WJ.Show 1
Exit Sub
End Sub
Private Sub Command3_Click()
On Error GoTo e
Call closeRecordSet(rs)
queryflag = "no"
If ListView2.ListItems.Count = 0 Then
MsgBox "没有记录!", vbInformation, ""
Exit Sub
End If
rs.Open "select locked from T_ARCHIVE_FILE_VOLUME where RECORD_SEQUENCE_NUMBER=" & ListView2.SelectedItem.SubItems(1) & "", conn
If Not IsNull(rs(0)) And rs(0) = 1 Then
rs.Close
MsgBox "该记录已经经过排序，你不能删除该记录！", vbInformation, ""
Exit Sub
End If
rs.Close
If MsgBox("确实要删除该记录吗？", vbYesNo + vbQuestion, "") = vbYes Then
rs.Open "delete from T_ARCHIVE_FILE_VOLUME where RECORD_SEQUENCE_NUMBER=" & ListView2.SelectedItem.SubItems(1) & "", conn
MsgBox "删除成功!", vbInformation, ""
ListView2.ListItems.Remove (ListView2.SelectedItem.Index)
End If
Label2.Caption = CStr(ListView2.ListItems.Count) + "条"
Exit Sub
e:
MsgBox Err.Description
End Sub
Private Sub Command4_Click()
Call closeRecordSet(rs)
queryflag = "query"
query = "file"
form_Query.Show 1
End Sub
Private Sub Command5_Click()
Unload Me
End Sub
Private Sub Command6_Click()
Call closeRecordSet(rs)
query = "file"
form_dossier2.Show 1
End Sub
Private Sub Command7_Click()
On Error GoTo e
If MsgBox("您将要进行排序操作！" & vbCrLf & "排序操作将会对当前所有未排序的记录进行排序编号" & vbCrLf & "一旦您选择是，您就不能再删除任何排完序的数据！" & vbCrLf & "同时您可以将排完序的数据进行数据合并。" & vbCrLf & "您确认要排序吗？", vbYesNo + vbExclamation, "排序确认") = vbNo Then
Exit Sub
End If
CopyFile App.Path & "\db\db.mdb", App.Path & "\db\" & year(Now()) & "-" & Month(Now()) & "-" & Day(Now()) & "-" & Hour(Now()) & "-" & Minute(Now()) & "-" & Second(Now()) & ".mdb", 0
Dim strSql As String
Dim officeLastRefCode As Long
Dim refLastCode As Long
strSql = "delete from t_archive_file_volume_temp"
conn.Execute strSql
If flagWhereF <> "" Then
strSql = "insert into t_archive_file_volume_temp " & flagWhereF '选择的记录复制到临时表
Else
strSql = "insert into t_archive_file_volume_temp select * from t_archive_file_volume"
End If
conn.Execute strSql
Call sortRecord(, , 0, 0)
strSql = "update t_archive_file_volume_temp set locked=1 where locked=0"
conn.Execute strSql
If flagWhereF <> "" Then
strSql = "delete from (" & flagWhereF & ")" '删除选择的记录
Else
strSql = "delete from t_archive_file_volume"
End If
conn.Execute strSql
strSql = "insert into t_archive_file_volume select * from t_archive_file_volume_temp"
conn.Execute strSql
MsgBox "排序成功！", vbInformation, ""
DoEvents
Call Form_Load
Exit Sub
e:
MsgBox Err.Description
End Sub
Private Sub Form_Activate()
Label2.Caption = CStr(ListView2.ListItems.Count) + "条"
If queryflag = "no" Then
ListView2.Visible = False
Call Form_Load
ListView2.Visible = True
End If
End Sub
Private Sub Form_Unload(Cancel As Integer)
flagWhereF = ""
Unload Me
End Sub
Private Sub ListView2_ColumnClick(ByVal ColumnHeader As MSComctlLib.ColumnHeader)
Dim i As Integer
With ListView2
For i = 1 To .ColumnHeaders.Count
If i = ColumnHeader.Index Then
.SortKey = i - 1 ''对指定的列进行排列
.Sorted = True
If .SortOrder = lvwDescending Then
.SortOrder = lvwAscending
Else
.SortOrder = lvwDescending
End If
.Refresh
End If
Next
End With
End Sub
Private Sub Form_Load()
Dim bTempFlagF As Boolean
Dim lLineNumF As Long
bTempFlagF = False
lLineNumF = 1
If flagWhereF <> "" Then
bTempFlagF = True
End If
If ListView2.ListItems.Count > 0 Then
lLineNumF = ListView2.SelectedItem.Index
End If
Call listFile(bTempFlagF, lLineNumF)
End Sub
Public Sub listFile(Optional ByVal bFlagWhere As Boolean = False, Optional ByVal lineNum As Long = 1)
Dim i As Long
backColor = bgColor
Label1.backColor = bgColor
With ListView2
.ColumnHeaders.Clear
.ColumnHeaders.Add , , "序号", 0
.ColumnHeaders.Add , , "唯一号", 0
.ColumnHeaders.Add , , "归档件号", 2000
.ColumnHeaders.Add , , "年度", 1000
.ColumnHeaders.Add , , "保管期限", 2000
.ColumnHeaders.Add , , "室编件号", 2000
.ColumnHeaders.Add , , "科室编号", 1500
.ColumnHeaders.Add , , "科室流水号", 1500
.ColumnHeaders.Add , , "责任者", 1500
.ColumnHeaders.Add , , "文件材料题名", 3000
.ColumnHeaders.Add , , "文件编号", 1200
.ColumnHeaders.Add , , "日期", 3000
.ColumnHeaders.Add , , "页数", 1200
.ColumnHeaders.Add , , "盒号", 1500
.ColumnHeaders.Add , , "馆编件号", 1500
.ColumnHeaders.Add , , "备注", 1200
.ColumnHeaders.Add , , "是否排序", 1500
.View = lvwReport
End With
'文件
ListView2.ListItems.Clear
i = 0
If bFlagWhere = False Then
strSql = "select * from T_ARCHIVE_FILE_VOLUME where FILE_NUMBER=0 and locked=0 order by archive_year,RETENTION_PERIOD,REFERENCE_CODE_OF_FILE_OFFICE"
Else
strSql = flagWhereF
End If
rs.Open strSql, conn
While Not rs.EOF
i = i + 1
Set itmX = ListView2.ListItems.Add(, , i)
itmX.SubItems(1) = rs.Fields(0).Value
itmX.SubItems(2) = xml("archive_year") + CStr(xml("RETENTION_PERIOD") + 1) + xml("REFERENCE_CODE_OF_FILE_OFFICE")
itmX.SubItems(3) = xml("archive_year")
Select Case xml("RETENTION_PERIOD")
Case 0
itmX.SubItems(4) = "永久"
Case 1
itmX.SubItems(4) = "长期"
Case 2
itmX.SubItems(4) = "短期"
End Select
itmX.SubItems(5) = xml("REFERENCE_CODE_OF_FILE_OFFICE")
itmX.SubItems(6) = xml("office_code")
itmX.SubItems(7) = xml("office_reference_code")
itmX.SubItems(8) = xml("PRIMARY_CREATOR")
itmX.SubItems(9) = xml("TITLE_PROPER")
itmX.SubItems(10) = xml("DOCUMENT_CODE")
itmX.SubItems(11) = Replace(xml("DATE_BEGUN"), "-", " ") + " " + Replace(xml("DATE_FINISHED"), "-", " ")
itmX.SubItems(12) = xml("medium_quantity")
itmX.SubItems(13) = xml("inboxcode")
itmX.SubItems(14) = xml("boxcode")
itmX.SubItems(15) = xml("NOTES_OF_ARCHIVIST")
Select Case xml("locked")
Case 0
itmX.SubItems(16) = "否"
Case 1
itmX.SubItems(16) = "是"
End Select
rs.MoveNext
Wend
rs.Close
'添加记录到列表框
Label2.Caption = CStr(ListView2.ListItems.Count) + "条"
If bFlagWhere = False Then
flagWhereF = ""
End If
If ListView2.ListItems.Count >= lineNum Then
ListView2.ListItems(lineNum).EnsureVisible
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -