?? settype.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 SetType
BorderStyle = 3 'Fixed Dialog
Caption = "設置圖書類別和借出時間"
ClientHeight = 3915
ClientLeft = 45
ClientTop = 630
ClientWidth = 5055
Icon = "SetType.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 3915
ScaleWidth = 5055
ShowInTaskbar = 0 'False
Begin VB.PictureBox Picture2
Height = 3135
Left = 120
ScaleHeight = 3075
ScaleWidth = 2835
TabIndex = 6
Top = 360
Width = 2895
Begin VB.CommandButton cmdSaveCancel
Caption = "取消(&C)"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 1
Left = 1800
TabIndex = 13
Top = 2520
Width = 855
End
Begin VB.CommandButton cmdSaveCancel
Caption = "保存(&S)"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 0
Left = 480
TabIndex = 12
Top = 2520
Width = 855
End
Begin VB.Frame Frame1
Height = 135
Left = 120
TabIndex = 11
Top = 2040
Width = 2535
End
Begin MSComCtl2.UpDown UpD
Height = 375
Left = 1920
TabIndex = 10
Top = 1560
Width = 225
_ExtentX = 450
_ExtentY = 661
_Version = 393216
BuddyControl = "comTime"
BuddyDispid = 196612
OrigLeft = 1920
OrigTop = 1440
OrigRight = 2145
OrigBottom = 1695
Max = 1000
SyncBuddy = -1 'True
BuddyProperty = 0
Enabled = -1 'True
End
Begin VB.ComboBox comTime
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 300
ItemData = "SetType.frx":0442
Left = 840
List = "SetType.frx":045B
TabIndex = 9
Top = 1560
Width = 1095
End
Begin VB.TextBox txtTypeName
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 315
Left = 840
TabIndex = 0
Top = 720
Width = 1815
End
Begin VB.Label labFlag
AutoSize = -1 'True
Caption = "添加"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000C0&
Height = 180
Left = 1680
TabIndex = 16
Top = 120
Width = 360
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "規定借出時間"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 180
Index = 1
Left = 120
TabIndex = 8
Top = 1200
Width = 1080
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "類別名稱"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 180
Index = 0
Left = 120
TabIndex = 7
Top = 360
Width = 720
End
End
Begin VB.PictureBox Picture1
BorderStyle = 0 'None
Height = 3255
Left = 3120
ScaleHeight = 3255
ScaleWidth = 1815
TabIndex = 2
Top = 360
Width = 1815
Begin VB.Frame Frame2
Height = 135
Left = 120
TabIndex = 15
Top = 1440
Width = 1575
End
Begin VB.CommandButton cmdEdit
Caption = "修改類別"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 735
Left = 120
Picture = "SetType.frx":047F
Style = 1 'Graphical
TabIndex = 14
Top = 720
Width = 1575
End
Begin VB.CommandButton cmdExit
Caption = "關閉<=>返回"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 735
Left = 120
Picture = "SetType.frx":08C1
Style = 1 'Graphical
TabIndex = 5
Top = 2400
Width = 1575
End
Begin VB.CommandButton cmdDelete
Caption = "刪除舊類別"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 735
Left = 120
Picture = "SetType.frx":0D03
Style = 1 'Graphical
TabIndex = 4
Top = 1680
Width = 1575
End
Begin VB.CommandButton cmdAdd
Caption = "添加新類別"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 735
Left = 120
Picture = "SetType.frx":1145
Style = 1 'Graphical
TabIndex = 3
Top = 0
Width = 1575
End
End
Begin MSComctlLib.ListView Lv
Height = 3135
Left = 120
TabIndex = 1
Top = 360
Width = 2895
_ExtentX = 5106
_ExtentY = 5530
View = 3
LabelWrap = -1 'True
HideSelection = -1 'True
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 1
NumItems = 2
BeginProperty ColumnHeader(1) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Text = "圖書類別"
Object.Width = 2469
EndProperty
BeginProperty ColumnHeader(2) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 1
Text = "規定借出時間"
Object.Width = 2540
EndProperty
End
Begin VB.Menu MainMnu
Caption = "操作"
Begin VB.Menu AddMnu
Caption = "添加新類別(&A)"
Shortcut = ^A
End
Begin VB.Menu EditMnu
Caption = "編輯類別(&E)"
Shortcut = ^E
End
Begin VB.Menu s1
Caption = "-"
End
Begin VB.Menu DeleteMnu
Caption = "刪除類別(&D)"
Shortcut = ^D
End
Begin VB.Menu ShowMnu
Caption = "顯示所有類別(&S)"
Shortcut = ^S
End
Begin VB.Menu s2
Caption = "-"
End
Begin VB.Menu ExitMnu
Caption = "退出(&X)"
Shortcut = ^X
End
End
End
Attribute VB_Name = "SetType"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim db As Database
Dim rst As Recordset
Dim Rec As Integer
Dim StrFlag As String
Dim Se As Integer
Private Sub AddMnu_Click()
cmdAdd_Click
End Sub
Private Sub cmdAdd_Click()
StrFlag = "添加"
labFlag.Caption = "添加狀態"
txtTypeName = ""
comTime = ""
Lv.Visible = False
Picture2.Visible = True
cmdFlag (False)
End Sub
Private Sub cmdDelete_Click()
Dim St As String
rst.Seek "=", Lv.SelectedItem.Text
St = "確實要刪除 " & Lv.SelectedItem.Text & " 類嗎？"
If MsgBox(St, 4 + 32, "刪除類別") = vbYes Then
rst.Delete
Disp
Else
Exit Sub
End If
End Sub
Private Sub cmdEdit_Click()
StrFlag = "編輯"
labFlag.Caption = "修改狀態"
Se = Lv.SelectedItem.Index
rst.Seek "=", Lv.SelectedItem.Text
txtTypeName.Text = rst.Fields("類別")
comTime.Text = rst.Fields("借出天數")
Picture2.Visible = True
Lv.Visible = False
cmdFlag (False)
End Sub
Private Sub cmdExit_Click()
Unload Me
End Sub
Private Sub cmdSaveCancel_Click(Index As Integer)
Select Case Index
Case 0
If StrFlag = "添加" Then
If txtTypeName.Text = "" Or comTime.Text = "" Then
MsgBox "請填寫完整！", 0 + 48, "提示"
Exit Sub
End If
rst.Seek "=", txtTypeName
If rst.NoMatch = False Then
MsgBox txtTypeName & " 類別已經存在，請填寫其它類！", 0 + 48, "類別重復"
txtTypeName.SetFocus
Exit Sub
End If
rst.AddNew
rst.Fields("類別") = txtTypeName.Text & vbNullString
rst.Fields("借出天數") = comTime.Text & vbNullString
rst.Update
Picture2.Visible = False
Lv.Visible = True
Disp
cmdFlag (True)
ElseIf StrFlag = "編輯" Then
If txtTypeName.Text = "" Or comTime.Text = "" Then
MsgBox "請填寫完整！", 0 + 48, "提示"
Exit Sub
End If
rst.Edit
rst.Fields("類別") = txtTypeName.Text & vbNullString
rst.Fields("借出天數") = comTime.Text
rst.Update
Picture2.Visible = False
Lv.Visible = True
Disp
cmdFlag (True)
End If
Case 1
Picture2.Visible = False
Lv.Visible = True
cmdFlag (True)
End Select
End Sub
Private Sub DeleteMnu_Click()
cmdDelete_Click
End Sub
Private Sub EditMnu_Click()
cmdEdit_Click
End Sub
Private Sub ExitMnu_Click()
cmdExit_Click
End Sub
Private Sub Form_Load()
Lv.Visible = True
Picture2.Visible = False
Set db = Workspaces(0).OpenDatabase(App.Path & "\DataBase\BookMIS.mdb", False)
Set rst = db.OpenRecordset("Type", dbOpenTable)
rst.Index = "類別"
Disp
End Sub
Private Sub Disp()
Dim i As Integer
Lv.ListItems.Clear
rst.MoveLast
Rec = rst.RecordCount
rst.MoveFirst
For i = 1 To Rec
Lv.ListItems.Add i, , rst.Fields("類別")
Lv.ListItems(i).SubItems(1) = rst.Fields("借出天數")
rst.MoveNext
If rst.EOF Then Exit For
Next
End Sub
Private Sub cmdFlag(Bool As Boolean)
cmdAdd.Enabled = Bool
cmdDelete.Enabled = Bool
cmdExit.Enabled = Bool
cmdEdit.Enabled = Bool
End Sub
Private Sub Form_Unload(Cancel As Integer)
rst.Close
db.Close
End Sub
Private Sub Lv_DblClick()
cmdEdit_Click
End Sub
Private Sub Lv_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
If Button = 2 Then
PopupMenu MainMnu
End If
End Sub
Private Sub ShowMnu_Click()
Disp
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -