www.pudn.com > 图书管理系统包括VB,ASP各一份代码.rar > JieYueDengJi.dob
VERSION 5.00
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
Object = "{CDE57A40-8B86-11D0-B3C6-00A0C90AEA82}#1.0#0"; "MSDATGRD.OCX"
Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
Object = "{F0D2F211-CCB0-11D0-A316-00AA00688B10}#1.0#0"; "MSDATLST.OCX"
Begin VB.UserDocument JieYueDengJi
BackColor = &H80000005&
ClientHeight = 9240
ClientLeft = 0
ClientTop = 0
ClientWidth = 8580
HScrollSmallChange= 225
ScaleHeight = 9240
ScaleWidth = 8580
VScrollSmallChange= 225
Begin VB.PictureBox picButtons
Appearance = 0 'Flat
BackColor = &H00FFFFFF&
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 300
Left = 2040
ScaleHeight = 300
ScaleWidth = 4695
TabIndex = 34
Top = 7440
Width = 4695
Begin VB.CommandButton cmdRefresh
Caption = "刷新(&R)"
Enabled = 0 'False
Height = 300
Left = 3521
TabIndex = 38
Top = 0
Width = 1095
End
Begin VB.CommandButton cmdDelete
Caption = "删除(&D)"
Enabled = 0 'False
Height = 300
Left = 2367
TabIndex = 37
Top = 0
Width = 1095
End
Begin VB.CommandButton cmdUpdate
Caption = "更新(&U)"
Enabled = 0 'False
Height = 300
Left = 1213
TabIndex = 36
Top = 0
Width = 1095
End
Begin VB.CommandButton cmdAdd
Caption = "添加(&A)"
Enabled = 0 'False
Height = 300
Left = 59
TabIndex = 35
Top = 0
Width = 1095
End
End
Begin MSAdodcLib.Adodc Adodc4
Height = 330
Left = 6240
Top = 8040
Visible = 0 'False
Width = 1935
_ExtentX = 3413
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = "Adodc4"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin TabDlg.SSTab SSTab1
Height = 3255
Left = 360
TabIndex = 11
Top = 1680
Width = 7935
_ExtentX = 13996
_ExtentY = 5741
_Version = 393216
Tabs = 2
TabsPerRow = 5
TabHeight = 520
BackColor = -2147483634
TabCaption(0) = "图书"
TabPicture(0) = "JieYueDengJi.dox":0000
Tab(0).ControlEnabled= -1 'True
Tab(0).Control(0)= "lblLabels(3)"
Tab(0).Control(0).Enabled= 0 'False
Tab(0).Control(1)= "lblLabels(14)"
Tab(0).Control(1).Enabled= 0 'False
Tab(0).Control(2)= "lblLabels(15)"
Tab(0).Control(2).Enabled= 0 'False
Tab(0).Control(3)= "lblLabels(16)"
Tab(0).Control(3).Enabled= 0 'False
Tab(0).Control(4)= "DataCombo2"
Tab(0).Control(4).Enabled= 0 'False
Tab(0).Control(5)= "DataGrid2"
Tab(0).Control(5).Enabled= 0 'False
Tab(0).Control(6)= "opt语言(1)"
Tab(0).Control(6).Enabled= 0 'False
Tab(0).Control(7)= "opt语言(0)"
Tab(0).Control(7).Enabled= 0 'False
Tab(0).Control(8)= "cmdFilter"
Tab(0).Control(8).Enabled= 0 'False
Tab(0).Control(9)= "txt图书id"
Tab(0).Control(9).Enabled= 0 'False
Tab(0).Control(10)= "txt书名"
Tab(0).Control(10).Enabled= 0 'False
Tab(0).Control(11)= "txt作者"
Tab(0).Control(11).Enabled= 0 'False
Tab(0).ControlCount= 12
TabCaption(1) = "期刊"
TabPicture(1) = "JieYueDengJi.dox":001C
Tab(1).ControlEnabled= 0 'False
Tab(1).Control(0)= "txtQKYM"
Tab(1).Control(1)= "txtQKMC"
Tab(1).Control(2)= "txtQKQH"
Tab(1).Control(3)= "cmdFindQK"
Tab(1).Control(4)= "txtQKND"
Tab(1).Control(5)= "DataGrid3"
Tab(1).Control(6)= "lblLabels(8)"
Tab(1).Control(7)= "lblLabels(7)"
Tab(1).Control(8)= "lblLabels(6)"
Tab(1).Control(9)= "lblLabels(4)"
Tab(1).ControlCount= 10
Begin VB.TextBox txtQKYM
Height = 285
Left = -73680
TabIndex = 32
Top = 840
Width = 4695
End
Begin VB.TextBox txtQKMC
Height = 285
Left = -73680
TabIndex = 31
Top = 480
Width = 4695
End
Begin VB.TextBox txtQKQH
Height = 285
Left = -70800
TabIndex = 26
Top = 1200
Width = 1815
End
Begin VB.CommandButton cmdFindQK
Caption = "查找(&L)"
Height = 375
Left = -68640
TabIndex = 25
Top = 480
Width = 1215
End
Begin VB.TextBox txtQKND
Height = 285
Left = -73680
TabIndex = 24
Top = 1200
Width = 1935
End
Begin VB.TextBox txt作者
Height = 285
Left = 4080
TabIndex = 17
Top = 840
Width = 1935
End
Begin VB.TextBox txt书名
Height = 285
Left = 1320
TabIndex = 16
Top = 480
Width = 4695
End
Begin VB.TextBox txt图书id
Height = 285
Left = 1320
TabIndex = 15
Top = 840
Width = 1575
End
Begin VB.CommandButton cmdFilter
Caption = "查找(&L)"
Height = 375
Left = 6360
TabIndex = 14
Top = 480
Width = 1215
End
Begin VB.OptionButton opt语言
Caption = "中文"
Height = 255
Index = 0
Left = 3600
TabIndex = 13
Top = 1238
Value = -1 'True
Width = 855
End
Begin VB.OptionButton opt语言
Caption = "外文"
Height = 255
Index = 1
Left = 4800
TabIndex = 12
Top = 1238
Width = 855
End
Begin MSDataGridLib.DataGrid DataGrid2
Bindings = "JieYueDengJi.dox":0038
Height = 1455
Left = 120
TabIndex = 18
Top = 1680
Width = 7635
_ExtentX = 13467
_ExtentY = 2566
_Version = 393216
Appearance = 0
HeadLines = 1
RowHeight = 15
FormatLocked = -1 'True
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ColumnCount = 11
BeginProperty Column00
DataField = "图书ID"
Caption = "图书ID"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column01
DataField = "书名"
Caption = "书名"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column02
DataField = "分类ID"
Caption = "分类ID"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column03
DataField = "作者"
Caption = "作者"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column04
DataField = "出版单位"
Caption = "出版单位"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column05
DataField = "单价"
Caption = "单价"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column06
DataField = "册数"
Caption = "册数"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column07
DataField = "页数"
Caption = "页数"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column08
DataField = "出版日期"
Caption = "出版日期"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column09
DataField = "登记日期"
Caption = "登记日期"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column10
DataField = "备注"
Caption = "备注"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
BeginProperty Column00
ColumnWidth = 1094.74
EndProperty
BeginProperty Column01
ColumnWidth = 2085.166
EndProperty
BeginProperty Column02
ColumnWidth = 615.118
EndProperty
BeginProperty Column03
ColumnWidth = 2085.166
EndProperty
BeginProperty Column04
ColumnWidth = 2085.166
EndProperty
BeginProperty Column05
ColumnWidth = 2085.166
EndProperty
BeginProperty Column06
ColumnWidth = 464.882
EndProperty
BeginProperty Column07
ColumnWidth = 734.74
EndProperty
BeginProperty Column08
ColumnWidth = 2085.166
EndProperty
BeginProperty Column09
ColumnWidth = 2085.166
EndProperty
BeginProperty Column10
ColumnWidth = 2085.166
EndProperty
EndProperty
End
Begin MSDataListLib.DataCombo DataCombo2
Bindings = "JieYueDengJi.dox":004D
Height = 330
Left = 1320
TabIndex = 19
Top = 1200
Width = 1575
_ExtentX = 2778
_ExtentY = 582
_Version = 393216
ListField = "分类"
BoundColumn = "分类ID"
Text = ""
End
Begin MSDataGridLib.DataGrid DataGrid3
Bindings = "JieYueDengJi.dox":0062
Height = 1455
Left = -74880
TabIndex = 33
Top = 1680
Width = 7635
_ExtentX = 13467
_ExtentY = 2566
_Version = 393216
Appearance = 0
HeadLines = 1
RowHeight = 15
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ColumnCount = 2
BeginProperty Column00
DataField = ""
Caption = ""
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column01
DataField = ""
Caption = ""
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
BeginProperty Column00
EndProperty
BeginProperty Column01
EndProperty
EndProperty
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "期号:"
Height = 180
Index = 8
Left = -71280
TabIndex = 30
Top = 1260
Width = 450
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "期刊名称:"
Height = 180
Index = 7
Left = -74520
TabIndex = 29
Top = 540
Width = 810
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "年度:"
Height = 180
Index = 6
Left = -74520
TabIndex = 28
Top = 1260
Width = 450
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "译名:"
Height = 180
Index = 4
Left = -74520
TabIndex = 27
Top = 900
Width = 450
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "作者:"
Height = 180
Index = 16
Left = 3600
TabIndex = 23
Top = 900
Width = 450
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "书名:"
Height = 180
Index = 15
Left = 600
TabIndex = 22
Top = 540
Width = 450
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "图书ID:"
Height = 180
Index = 14
Left = 600
TabIndex = 21
Top = 870
Width = 630
End
Begin VB.Label lblLabels
AutoSize = -1 'True
Caption = "分类:"
Height = 180
Index = 3
Left = 600
TabIndex = 20
Top = 1260
Width = 450
End
End
Begin MSDataGridLib.DataGrid DataGrid1
Bindings = "JieYueDengJi.dox":0077
Height = 1935
Left = 360
TabIndex = 5
Top = 5040
Width = 7935
_ExtentX = 13996
_ExtentY = 3413
_Version = 393216
AllowUpdate = -1 'True
AllowArrows = -1 'True
Appearance = 0
HeadLines = 1
RowHeight = 15
TabAction = 1
FormatLocked = -1 'True
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Caption = "借阅登记"
ColumnCount = 6
BeginProperty Column00
DataField = "借阅ID"
Caption = "借阅ID"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column01
DataField = "语言"
Caption = "语言"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column02
DataField = "职员ID"
Caption = "职员ID"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column03
DataField = "图书ID"
Caption = "图书ID"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column04
DataField = "借阅日期"
Caption = "借阅日期"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column05
DataField = "归还日期"
Caption = "归还日期"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
BeginProperty Column00
Locked = -1 'True
ColumnWidth = 1094.74
EndProperty
BeginProperty Column01
Locked = -1 'True
ColumnWidth = 645.165
EndProperty
BeginProperty Column02
Locked = -1 'True
ColumnWidth = 1094.74
EndProperty
BeginProperty Column03
Locked = -1 'True
ColumnWidth = 734.74
EndProperty
BeginProperty Column04
ColumnWidth = 2085.166
EndProperty
BeginProperty Column05
ColumnWidth = 2085.166
EndProperty
EndProperty
End
Begin VB.Frame Frame1
Appearance = 0 'Flat
BackColor = &H80000005&
Caption = "借阅者"
ForeColor = &H80000008&
Height = 1215
Index = 0
Left = 360
TabIndex = 0
Top = 360
Width = 7935
Begin VB.TextBox txt电话
Height = 285
Left = 5640
TabIndex = 8
Top = 720
Width = 1815
End
Begin VB.TextBox txt部门
Height = 285
Left = 1320
TabIndex = 6
Top = 720
Width = 1815
End
Begin VB.CommandButton cmdFind
Caption = "查找(&F)"
Height = 300
Left = 3240
TabIndex = 4
Top = 360
Width = 975
End
Begin VB.TextBox txt姓名
Height = 285
Left = 1320
TabIndex = 2
Top = 360
Width = 1815
End
Begin VB.TextBox txt职员id
Height = 285
Left = 5640
TabIndex = 1
Top = 360
Width = 1815
End
Begin VB.Label lblLabels
AutoSize = -1 'True
BackColor = &H80000005&
Caption = "职员ID:"
Height = 180
Index = 1
Left = 4920
TabIndex = 10
Top = 405
Width = 630
End
Begin VB.Label lblLabels
AutoSize = -1 'True
BackColor = &H80000005&
Caption = "电话:"
Height = 180
Index = 2
Left = 5100
TabIndex = 9
Top = 720
Width = 450
End
Begin VB.Label lblLabels
AutoSize = -1 'True
BackColor = &H80000005&
Caption = "部门:"
Height = 180
Index = 0
Left = 780
TabIndex = 7
Top = 720
Width = 450
End
Begin VB.Label lblLabels
AutoSize = -1 'True
BackColor = &H80000005&
Caption = "借阅者姓名:"
Height = 180
Index = 5
Left = 240
TabIndex = 3
Top = 405
Width = 990
End
End
Begin MSAdodcLib.Adodc Adodc1
Height = 330
Left = 120
Top = 8040
Visible = 0 'False
Width = 1980
_ExtentX = 3493
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 1
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = "Adodc1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin MSAdodcLib.Adodc Adodc2
Height = 330
Left = 2160
Top = 8040
Visible = 0 'False
Width = 1980
_ExtentX = 3493
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 1
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = "Adodc2"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin MSAdodcLib.Adodc Adodc3
Height = 330
Left = 4200
Top = 8040
Visible = 0 'False
Width = 1980
_ExtentX = 3493
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 2
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = "Adodc3"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
End
Attribute VB_Name = "JieYueDengJi"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = True
Dim adoRS职员 As ADODB.Recordset
Dim db As Connection
Dim strSQL As String
Private Sub cmdAdd_Click()
On Error GoTo AddErr
Adodc1.Recordset.AddNew
Adodc1.Recordset.Fields("职员id").Value = txt职员id.Text
If SSTab1.Tab = 0 Then
Adodc1.Recordset.Fields("图书id").Value = Adodc2.Recordset.Fields("图书id").Value
If opt语言(0).Value Then
Adodc1.Recordset.Fields("语言").Value = "中"
Else
Adodc1.Recordset.Fields("语言").Value = "外"
End If
End If
Adodc1.Recordset.Update
Exit Sub
AddErr:
MsgBox Err.Description
End Sub
Private Sub cmdDelete_Click()
On Error GoTo DeleteErr
Dim nYN As Byte
nYN = MsgBox("您正准备删除当前记录。" & Chr(13) & Chr(13) & _
"假如您单击“是”，您将不能撤消这个删除操作。" & Chr(13) & _
"您确认删除这条记录吗?", vbExclamation + vbYesNo)
If nYN = vbYes Then
With Adodc1.Recordset
If .EOF And .BOF Then Exit Sub
.Delete
.MoveNext
If .RecordCount > 0 And .EOF Then
.MoveLast
ElseIf .RecordCount = 0 Then .MovePrevious
End If
End With
End If
Exit Sub
DeleteErr:
MsgBox Err.Description
End Sub
Private Sub cmdFilter_Click()
Dim strFilter As String
'生成filter字符串
strFilter = ""
If Trim(txt图书id.Text) <> "" Then
strFilter = "图书ID=" & Trim(txt图书id.Text)
End If
If Trim(txt作者.Text) <> "" Then
If strFilter = "" Then
strFilter = "作者 like '%" & Trim(txt作者.Text) & "%'"
Else
strFilter = strFilter & " and 作者 like '%" & Trim(txt作者.Text) & "%'"
End If
End If
If txt书名.Text <> "" Then
If strFilter = "" Then
strFilter = "书名 like '%" & txt书名.Text & "%'"
Else
strFilter = strFilter & " and 书名 like '%" & txt书名.Text & "%'"
End If
End If
If DataCombo2.Text <> "" Then
If strFilter = "" Then
strFilter = "分类id=" & DataCombo2.BoundText
Else
strFilter = strFilter & " and 分类id=" & DataCombo2.BoundText
End If
End If
If opt语言(0).Value Then
If strFilter = "" Then
Adodc2.RecordSource = "select 图书ID, 分类ID, 书名, 作者, 出版单位, 单价, 册数, 出版日期, 登记日期, 备注, 页数 from 中文图书"
Else
Adodc2.RecordSource = "select 图书ID, 分类ID, 书名, 作者, 出版单位, 单价, 册数, 出版日期, 登记日期, 备注, 页数 from 中文图书 where " & strFilter
End If
Else
If strFilter = "" Then
Adodc2.RecordSource = "select 图书ID, 分类ID, 书名, 译名, 文种ID, 作者, 出版单位, 单价, 册数, 出版日期, 登记日期, 备注, 页数 from 外文图书"
Else
Adodc2.RecordSource = "select 图书ID, 分类ID, 书名, 译名, 文种ID, 作者, 出版单位, 单价, 册数, 出版日期, 登记日期, 备注, 页数 from 外文图书 where " & strFilter
End If
End If
Adodc2.Refresh
If Adodc2.Recordset.RecordCount = 0 Then
setButtons False
Else
If Trim(txt职员id.Text) = "" Then
setButtons False
Else
setButtons True
End If
End If
End Sub
Private Sub cmdFind_Click()
strSQL = "select a.职员id, a.电话, b.部门名称 from 职员 a, 部门 b where a.部门ID=b.部门ID and 姓名 = '" & txt姓名.Text & "'"
Set adoRS职员 = db.Execute(strSQL)
If Not (adoRS职员.EOF Or adoRS职员.BOF) Then
txt职员id.Text = adoRS职员.Fields("职员id").Value
txt部门.Text = IIf(IsNull(adoRS职员.Fields("部门名称").Value), "", adoRS职员.Fields("部门名称").Value)
txt电话.Text = IIf(IsNull(adoRS职员.Fields("电话").Value), "", adoRS职员.Fields("电话").Value)
Else
txt职员id.Text = ""
txt部门.Text = ""
txt电话.Text = ""
MsgBox "不存在该职员，请检查所输入的姓名。如果添加职员，请与系统管理员联系。", vbExclamation
End If
End Sub
Private Sub cmdRefresh_Click()
'只有多用户应用程序需要
On Error GoTo RefreshErr
Adodc1.Refresh
Exit Sub
RefreshErr:
MsgBox Err.Description
End Sub
Private Sub cmdUpdate_Click()
On Error GoTo UpdateErr
Adodc1.Recordset.UpdateBatch adAffectAll
Exit Sub
UpdateErr:
MsgBox Err.Description
End Sub
Private Sub cmdFindQK_Click()
Dim strFilter As String
'生成filter字符串
strFilter = ""
If Trim(txtQKMC.Text) <> "" Then
strFilter = "名称 like '%" & Trim(txtQKMC.Text) & "%'"
End If
If Trim(txtQKYM.Text) <> "" Then
If strFilter = "" Then
strFilter = "译名 like '%" & Trim(txtQKYM.Text) & "%'"
Else
strFilter = strFilter & " and 译名 like '%" & Trim(txtQKYM.Text) & "%'"
End If
End If
If txtQKND.Text <> "" Then
If strFilter = "" Then
strFilter = "年度=" & txtQKND.Text
Else
strFilter = strFilter & " and 年度=" & txtQKND.Text
End If
End If
If txtQKQH.Text <> "" Then
If strFilter = "" Then
strFilter = "期号=" & txtQKQH.Text
Else
strFilter = strFilter & " and 期号=" & txtQKQH.Text
End If
End If
If strFilter = "" Then
Adodc4.RecordSource = "SELECT 期刊登记ID, 名称, 译名, 年度, 期号, 刊期, 库存册数, 借阅册数, 在库册数 FROM 期刊在库册数 Order by 名称, 年度, 期号"
Else
Adodc4.RecordSource = "SELECT 期刊登记ID, 名称, 译名, 年度, 期号, 刊期, 库存册数, 借阅册数, 在库册数 FROM 期刊在库册数 where " & strFilter & " Order by 名称, 年度, 期号"
End If
Adodc4.Refresh
If Adodc4.Recordset.RecordCount = 0 Then
setButtons False
Else
If Trim(txt职员id.Text) = "" Then
setButtons False
Else
setButtons True
End If
End If
End Sub
Private Sub SSTab1_Click(PreviousTab As Integer)
If SSTab1.Tab = 0 Then
If Adodc2.Recordset.RecordCount = 0 Then
setButtons False
Else
If Trim(txt职员id.Text) = "" Then
setButtons False
Else
setButtons True
End If
End If
Else
If Adodc4.Recordset.RecordCount = 0 Then
setButtons False
Else
If Trim(txt职员id.Text) = "" Then
setButtons False
Else
setButtons True
End If
End If
End If
End Sub
Private Sub txt职员id_Change()
Dim sID As String
sID = txt职员id.Text
If sID = "" Then
With Adodc1
.RecordSource = "select 借阅ID,语言,职员ID,图书ID,借阅日期,归还日期 from 图书借阅 WHERE 职员ID = -1 Order by 借阅ID;"
.Refresh
End With
setButtons False
Else
With Adodc1
.RecordSource = "select 借阅ID,语言,职员ID,图书ID,借阅日期,归还日期 from 图书借阅 WHERE 职员ID = " & sID & " Order by 借阅ID;"
.Refresh
End With
If SSTab1.Tab = 0 Then
If Adodc2.Recordset.RecordCount = 0 Then
setButtons False
Else
setButtons True
End If
Else
If Adodc4.Recordset.RecordCount = 0 Then
setButtons False
Else
setButtons True
End If
End If
End If
End Sub
Private Sub UserDocument_Initialize()
With Adodc1
.ConnectionString = pConn
.RecordSource = "select 借阅ID,语言,职员ID,图书ID,借阅日期,归还日期 from 图书借阅 Order by 借阅ID"
.Refresh
End With
With Adodc2
.ConnectionString = pConn
.RecordSource = "select 图书ID, 分类ID, 书名, 作者, 出版单位, 单价, 册数, 出版日期, 登记日期, 备注, 页数 from 中文图书 where 图书ID=-1"
.Refresh
End With
With Adodc3
.ConnectionString = pConn
.RecordSource = "图书分类"
.Refresh
End With
With Adodc4
.ConnectionString = pConn
.RecordSource = "SELECT 期刊登记ID, 名称, 译名, 年度, 期号, 刊期, 库存册数, 借阅册数, 在库册数 FROM 期刊在库册数 where 期刊登记ID=-1 Order by 名称, 年度, 期号"
.Refresh
End With
Set db = New Connection
db.CursorLocation = adUseClient
db.Open pConn
End Sub
Private Sub setButtons(blnEnable As Boolean)
cmdAdd.Enabled = blnEnable
cmdUpdate.Enabled = blnEnable
cmdDelete.Enabled = blnEnable
cmdRefresh.Enabled = blnEnable
End Sub