?? frmbook_search.frm
字號:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Object = "{0ECD9B60-23AA-11D0-B351-00A0C9055D8E}#6.0#0"; "MSHFLXGD.OCX"
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form frmbook_search
Caption = "圖書查詢"
ClientHeight = 8280
ClientLeft = 60
ClientTop = 345
ClientWidth = 13335
Icon = "frmbook_search.frx":0000
LinkTopic = "Form1"
MDIChild = -1 'True
ScaleHeight = 8280
ScaleWidth = 13335
WindowState = 2 'Maximized
Begin VB.Frame Frame2
Caption = "類別"
Height = 6855
Left = 120
TabIndex = 12
Top = 1320
Width = 13095
Begin MSComctlLib.TreeView TreeView1
Height = 6495
Left = 120
TabIndex = 13
Top = 240
Width = 2535
_ExtentX = 4471
_ExtentY = 11456
_Version = 393217
Style = 7
Appearance = 1
End
Begin MSHierarchicalFlexGridLib.MSHFlexGrid MSHFlexGrid1
Height = 6495
Left = 2760
TabIndex = 14
ToolTipText = "雙擊可修改圖書信息"
Top = 240
Width = 10215
_ExtentX = 18018
_ExtentY = 11456
_Version = 393216
Cols = 9
FixedCols = 0
HighLight = 2
SelectionMode = 1
AllowUserResizing= 3
_NumberOfBands = 1
_Band(0).Cols = 9
End
End
Begin VB.Frame Frame1
Height = 1095
Left = 120
TabIndex = 0
Top = 120
Width = 13095
Begin MSComCtl2.DTPicker DTPicker2
Height = 375
Left = 3480
TabIndex = 11
Top = 600
Width = 1935
_ExtentX = 3413
_ExtentY = 661
_Version = 393216
Format = 24510464
CurrentDate = 38327
End
Begin MSComCtl2.DTPicker DTPicker1
Height = 375
Left = 3480
TabIndex = 10
Top = 240
Width = 1935
_ExtentX = 3413
_ExtentY = 661
_Version = 393216
Format = 24510464
CurrentDate = 38327
End
Begin VB.CommandButton Cmd_Book_del
Caption = "刪除"
Height = 375
Left = 10440
TabIndex = 9
Top = 360
Width = 1215
End
Begin VB.CommandButton Cmd_Book_print
Caption = "預覽/打印"
Height = 375
Left = 9120
TabIndex = 8
Top = 360
Width = 1215
End
Begin VB.CommandButton Cmd_Book_clear
Caption = "重置"
Height = 375
Left = 7800
TabIndex = 7
Top = 360
Width = 1215
End
Begin VB.CommandButton Cmd_Book_search
Caption = "查詢(&S)"
Default = -1 'True
Height = 375
Left = 6480
TabIndex = 5
Top = 360
Width = 1215
End
Begin VB.ComboBox Combo1
Height = 300
ItemData = "frmbook_search.frx":08CA
Left = 720
List = "frmbook_search.frx":08EC
Style = 2 'Dropdown List
TabIndex = 3
Top = 360
Width = 1935
End
Begin VB.CommandButton Cmd_BS_exit
Caption = "退出(&E)"
Height = 375
Left = 11760
TabIndex = 2
Top = 360
Width = 1215
End
Begin VB.TextBox Text1
Height = 375
Left = 3480
TabIndex = 1
Text = "關鍵字"
Top = 360
Width = 2895
End
Begin VB.Label Label2
Caption = "選項"
Height = 255
Left = 120
TabIndex = 6
Top = 420
Width = 375
End
Begin VB.Label Label1
Caption = "關鍵字"
Height = 255
Left = 2760
TabIndex = 4
Top = 420
Width = 615
End
End
End
Attribute VB_Name = "frmbook_search"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub renew()
Combo1.Text = Combo1.List(0)
Text1.Text = "關鍵字"
Text1.Visible = True
DTPicker1.Visible = False
DTPicker2.Visible = False
Cmd_Book_del.Enabled = False
End Sub
Private Sub MSHGridset()
MSHFlexGrid1.TextMatrix(0, 0) = "圖書編號"
MSHFlexGrid1.TextMatrix(0, 1) = "圖書名稱"
MSHFlexGrid1.TextMatrix(0, 2) = "圖書類別"
MSHFlexGrid1.TextMatrix(0, 3) = "出版日期"
MSHFlexGrid1.TextMatrix(0, 4) = "圖書價格"
MSHFlexGrid1.TextMatrix(0, 5) = "圖書作者(主編)"
MSHFlexGrid1.TextMatrix(0, 6) = "出版社"
MSHFlexGrid1.TextMatrix(0, 7) = "圖書簡介"
MSHFlexGrid1.TextMatrix(0, 8) = "登記日期"
End Sub
Private Sub Cmd_Book_del_Click()
Dim bid As String
bid = "BOOK_ID='" + MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 0) + "'"
If rds_jieyue.State = adStateOpen Then rds_jieyue.Close
rds_jieyue.Open "select * from 借閱信息 where " + bid, myconn, adOpenKeyset, adLockOptimistic, 1
If rds_jieyue.RecordCount > 0 Then
If MsgBox("此圖書尚末歸還，確認要刪除嗎" + vbCrLf + vbCrLf + "確認 刪除" + vbCrLf + "否 取消", vbInformation + vbYesNo, "圖書刪除") = vbNo Then Exit Sub
End If
If MsgBox("確認真的要刪除該圖書嗎", vbCritical + vbYesNo, "刪除") = vbYes Then
myconn.Execute "delete * from 圖書信息 where " + bid
MsgBox "刪除成功"
Call Cmd_Book_clear_Click '重置
End If
End Sub
Private Sub Combo1_Click()
If Combo1.Text = "出版日期" Or Combo1.Text = "登記日期" Then
Text1.Visible = False
DTPicker1.Visible = True
DTPicker2.Visible = True
Else
Text1.Visible = True
DTPicker1.Visible = False
DTPicker2.Visible = False
End If
End Sub
Private Sub Cmd_BS_exit_Click() '退出
Call renew
Unload Me
MDIMain.StatusBar1.Panels(3) = ""
End Sub
Private Sub Cmd_Book_search_Click() '查詢
Dim search_item As String
Cmd_Book_del.Enabled = False '刪除不可用
If Text1.Visible And Text1 = "關鍵字" Or Text1 = "" Then
MsgBox "請輸入關鍵字"
Text1.SetFocus
Text1.SelStart = 0
Text1.SelLength = Len(Combo1)
Exit Sub
End If
If Combo1.Text = "請選擇……" Then
MsgBox "請選擇查詢選項"
Combo1.SetFocus
Exit Sub
Else
If Combo1.Text = "圖書編號" Then search_item = "BOOK_ID like '"
If Combo1.Text = "圖書名稱" Then search_item = "BOOK_NAME like '"
If Combo1.Text = "圖書類別" Then search_item = "BOOK_SORT like '"
If Combo1.Text = "出版日期" Then search_item = "BOOK_DATE between #"
If Combo1.Text = "價格范圍" Then search_item = "BOOK_PRICE like '"
If Combo1.Text = "作者" Then search_item = "BOOK_WRITER like '"
If Combo1.Text = "出版社" Then search_item = "BOOK_CONCERN like '"
If Combo1.Text = "登記日期" Then search_item = "BOOK_CHECK_DATE between #"
End If
'清理兩個表格
MSHFlexGrid1.Clear
Call MSHGridset
If InStr(1, Text1, "*") > 0 Then MsgBox "通配符請用%表示": Text1.SetFocus: Exit Sub
If InStr(1, Text1, "?") > 0 Then MsgBox "通配符請用%表示": Text1.SetFocus: Exit Sub
If rds_book.State = adStateOpen Then rds_book.Close
If Combo1.Text = "出版日期" Or Combo1.Text = "登記日期" Then
rds_book.Open "select * from 圖書信息 where " & search_item & DTPicker1.Value & "# and #" & DTPicker2.Value & "#", myconn, adOpenKeyset, adLockOptimistic, 1
Else
rds_book.Open "select * from 圖書信息 where " & search_item & Text1 & "%'", myconn, adOpenKeyset, adLockOptimistic, 1
End If
Set MSHFlexGrid1.DataSource = rds_book
Call MSHGridset
MDIMain.StatusBar1.Panels(3) = "共有圖書" & MSHFlexGrid1.Rows - 1 & "本滿足條件"
End Sub
Private Sub Cmd_Book_clear_Click() '重置
Call renew
If rds_book.State = adStateOpen Then rds_book.Close
rds_book.Open "select * from 圖書信息 ", myconn, adOpenKeyset, adLockOptimistic, 1
Set MSHFlexGrid1.DataSource = rds_book
Call MSHGridset
'rds_book.Close
MDIMain.StatusBar1.Panels(3) = "共有圖書" & MSHFlexGrid1.Rows - 1 & "本滿足條件"
End Sub
Private Sub Cmd_Book_print_Click() '打印
Set DR_book.DataSource = rds_book
DR_book.Show
End Sub
Private Sub Form_Activate()
Dim i As Integer
Dim rds_booksort As ADODB.Recordset
Set rds_booksort = New ADODB.Recordset
Call renew
'刪除類別表
myconn.Execute "drop table BOOK_SORT "
'無重復查找所有類別
rds_booksort.Open "SELECT DISTINCT BOOK_SORT INTO BOOK_SORT FROM 圖書信息", myconn, adOpenKeyset, adLockOptimistic, 1
'將所有類別添加到新表
rds_booksort.Open "SELECT BOOK_SORT FROM BOOK_SORT", myconn, adOpenKeyset, adLockOptimistic, 1
'樹根
TreeView1.Nodes.Add , , "R", "所有"
'樹子節點
For i = 0 To rds_booksort.RecordCount - 1
TreeView1.Nodes.Add "R", tvwChild, "s" & i, rds_booksort.Fields(0)
rds_booksort.MoveNext
Next i
'樹自動展開
TreeView1.Nodes("R").Expanded = True
rds_booksort.Close
'查詢全部圖書
Call Cmd_Book_clear_Click
Call MSHGridset
MDIMain.StatusBar1.Panels(3) = "共有圖書" & MSHFlexGrid1.Rows - 1 & "本滿足條件"
End Sub
Private Sub Form_Resize()
Frame1.Left = (Me.ScaleWidth - Frame1.Width) / 2
Frame2.Left = (Me.ScaleWidth - Frame2.Width) / 2
End Sub
Private Sub Form_Unload(Cancel As Integer)
MDIMain.StatusBar1.Panels(3) = ""
End Sub
Private Sub MSHFlexGrid1_Click()
If MSHFlexGrid1.Row > 0 Then Cmd_Book_del.Enabled = True
End Sub
Private Sub MSHFlexGrid1_DblClick()
If MSHFlexGrid1.Rows > 1 Then
Dim i As Integer
For i = 0 To 8
If i <> 3 Then frmbook_check.txt_book(i) = MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, i)
Next i
frmbook_check.DTPicker1 = CDate(MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 3))
frmbook_check.Tag = "modify"
frmbook_check.txt_book(0).Enabled = False
frmbook_check.Show vbModal
Cmd_Book_clear_Click '重新查詢所有
End If
End Sub
Private Sub TreeView1_NodeClick(ByVal Node As MSComctlLib.Node)
Combo1.Text = "圖書類別"
If Node.Text = "所有" Then
Text1 = "%"
Else
Text1 = Node
End If
Call Cmd_Book_search_Click
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -