www.pudn.com > opy_LMS.rar > frmSearch.frm
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Object = "{CDE57A40-8B86-11D0-B3C6-00A0C90AEA82}#1.0#0"; "MSDATGRD.OCX"
Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
Begin VB.Form frmSearch
BorderStyle = 1 'Fixed Single
Caption = "查询"
ClientHeight = 5310
ClientLeft = 45
ClientTop = 330
ClientWidth = 9825
LinkTopic = "Form1"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
ScaleHeight = 5310
ScaleWidth = 9825
Begin TabDlg.SSTab SSTab1
Height = 4455
Left = 120
TabIndex = 0
Top = 600
Width = 9555
_ExtentX = 16854
_ExtentY = 7858
_Version = 393216
Style = 1
Tabs = 2
Tab = 1
TabHeight = 529
TabMaxWidth = 2646
ForeColor = 8388608
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
TabCaption(0) = "图书"
TabPicture(0) = "frmSearch.frx":0000
Tab(0).ControlEnabled= 0 'False
Tab(0).Control(0)= "fra_search"
Tab(0).Control(1)= "bpbar"
Tab(0).Control(2)= "bdatagrid"
Tab(0).ControlCount= 3
TabCaption(1) = "读者"
TabPicture(1) = "frmSearch.frx":001C
Tab(1).ControlEnabled= -1 'True
Tab(1).Control(0)= "mdatagrid"
Tab(1).Control(0).Enabled= 0 'False
Tab(1).Control(1)= "mpbar"
Tab(1).Control(1).Enabled= 0 'False
Tab(1).Control(2)= "fra_msearch"
Tab(1).Control(2).Enabled= 0 'False
Tab(1).ControlCount= 3
Begin VB.Frame fra_search
Caption = "查询"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000040&
Height = 1095
Left = -74760
TabIndex = 9
Top = 600
Width = 6135
Begin VB.TextBox txt_bvalue
ForeColor = &H00400000&
Height = 285
Left = 1560
TabIndex = 12
ToolTipText = "查询的赋值条件"
Top = 720
Width = 3135
End
Begin VB.ComboBox cmb_bfield
ForeColor = &H00400000&
Height = 300
ItemData = "frmSearch.frx":0038
Left = 1560
List = "frmSearch.frx":005A
TabIndex = 11
ToolTipText = "选择图书的字段"
Top = 240
Width = 3135
End
Begin VB.CommandButton cmd_bsearch
Caption = "查询"
Height = 735
Left = 4920
MouseIcon = "frmSearch.frx":009E
MousePointer = 99 'Custom
Picture = "frmSearch.frx":01F0
Style = 1 'Graphical
TabIndex = 10
ToolTipText = "查询"
Top = 240
Width = 975
End
Begin VB.Label lbl_value
BackStyle = 0 'Transparent
Caption = "赋值"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800000&
Height = 255
Left = 720
TabIndex = 14
Top = 750
Width = 615
End
Begin VB.Label lbl_field
BackStyle = 0 'Transparent
Caption = "字段"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800000&
Height = 255
Left = 720
TabIndex = 13
Top = 280
Width = 615
End
End
Begin VB.Frame fra_msearch
Caption = "查找"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00404080&
Height = 1095
Left = 240
TabIndex = 3
Top = 600
Width = 6135
Begin VB.CommandButton txt_msearch
Caption = "查询"
Height = 735
Left = 4920
MouseIcon = "frmSearch.frx":07F9
MousePointer = 99 'Custom
Picture = "frmSearch.frx":094B
Style = 1 'Graphical
TabIndex = 6
ToolTipText = "查询"
Top = 240
Width = 975
End
Begin VB.ComboBox cmb_mfield
ForeColor = &H00400000&
Height = 300
ItemData = "frmSearch.frx":0F54
Left = 1560
List = "frmSearch.frx":0F70
TabIndex = 5
ToolTipText = "选择读者的字段"
Top = 240
Width = 3135
End
Begin VB.TextBox txt_mvalue
ForeColor = &H00400000&
Height = 285
Left = 1560
TabIndex = 4
ToolTipText = "查询的赋值条件"
Top = 720
Width = 3135
End
Begin VB.Label lbl_fields
BackColor = &H00C8D0D4&
BackStyle = 0 'Transparent
Caption = "字段"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800000&
Height = 255
Left = 720
TabIndex = 8
Top = 280
Width = 615
End
Begin VB.Label lbl_values
BackColor = &H00C8D0D4&
BackStyle = 0 'Transparent
Caption = "赋值"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800000&
Height = 255
Left = 720
TabIndex = 7
Top = 750
Width = 615
End
End
Begin MSComctlLib.ProgressBar mpbar
Height = 375
Left = 6600
TabIndex = 1
Top = 1200
Width = 2775
_ExtentX = 4895
_ExtentY = 661
_Version = 393216
Appearance = 1
End
Begin MSComctlLib.ProgressBar bpbar
Height = 375
Left = -68400
TabIndex = 2
Top = 1200
Width = 2775
_ExtentX = 4895
_ExtentY = 661
_Version = 393216
Appearance = 1
End
Begin MSDataGridLib.DataGrid bdatagrid
Height = 2415
Left = -74760
TabIndex = 15
ToolTipText = "Detail view of books"
Top = 1800
Width = 9135
_ExtentX = 16113
_ExtentY = 4260
_Version = 393216
AllowUpdate = 0 'False
AllowArrows = -1 'True
Appearance = 0
BackColor = -2147483633
DefColWidth = 7
HeadLines = 1
RowHeight = 13
FormatLocked = -1 'True
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 8.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Caption = "图书查询结果"
ColumnCount = 14
BeginProperty Column00
DataField = "Bookid"
Caption = "书号"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column01
DataField = "Title"
Caption = "书名"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column02
DataField = "Author1"
Caption = "作者一"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column03
DataField = "Author2"
Caption = "作者二"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column04
DataField = "Author3"
Caption = "作者三"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column05
DataField = "Avano"
Caption = "可借"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column06
DataField = "Issno"
Caption = "已借"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column07
DataField = "Totalno"
Caption = "总数"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column08
DataField = "Edition"
Caption = "版次"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column09
DataField = "ISBNNumber"
Caption = "ISBN号"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column10
DataField = "Pages"
Caption = "页数"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column11
DataField = "Price"
Caption = "定价"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column12
DataField = "Subject"
Caption = "类型"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column13
DataField = "Publication"
Caption = "出版社"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
SizeMode = 1
AllowRowSizing = 0 'False
BeginProperty Column00
ColumnWidth = 645.165
EndProperty
BeginProperty Column01
ColumnWidth = 2835.213
EndProperty
BeginProperty Column02
ColumnWidth = 1709.858
EndProperty
BeginProperty Column03
ColumnWidth = 1590.236
EndProperty
BeginProperty Column04
EndProperty
BeginProperty Column05
ColumnWidth = 705.26
EndProperty
BeginProperty Column06
ColumnWidth = 659.906
EndProperty
BeginProperty Column07
ColumnWidth = 629.858
EndProperty
BeginProperty Column08
ColumnWidth = 1335.118
EndProperty
BeginProperty Column09
ColumnWidth = 1305.071
EndProperty
BeginProperty Column10
ColumnWidth = 794.835
EndProperty
BeginProperty Column11
ColumnWidth = 764.787
EndProperty
BeginProperty Column12
ColumnWidth = 1725.165
EndProperty
BeginProperty Column13
ColumnWidth = 2624.882
EndProperty
EndProperty
End
Begin MSDataGridLib.DataGrid mdatagrid
Height = 2415
Left = 240
TabIndex = 16
Top = 1800
Width = 9135
_ExtentX = 16113
_ExtentY = 4260
_Version = 393216
AllowUpdate = -1 'True
BackColor = -2147483633
HeadLines = 1
RowHeight = 13
FormatLocked = -1 'True
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 8.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Caption = "读者查询结果"
ColumnCount = 11
BeginProperty Column00
DataField = "Memid"
Caption = "借书证号"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column01
DataField = "Mname"
Caption = "姓名"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column02
DataField = "Sex"
Caption = "性别"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column03
DataField = "Birthdate"
Caption = "出生日期"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column04
DataField = "Address"
Caption = "地址"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column05
DataField = "Phone"
Caption = "联系电话"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column06
DataField = "Email"
Caption = "电子邮箱"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column07
DataField = "Deposite"
Caption = "按金"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column08
DataField = "Dojoin"
Caption = "加入时间"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column09
DataField = "Doexpire"
Caption = "期满时间"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column10
DataField = "Noted"
Caption = "备注"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
BeginProperty Column00
ColumnWidth = 824.882
EndProperty
BeginProperty Column01
ColumnWidth = 1604.976
EndProperty
BeginProperty Column02
ColumnWidth = 3404.977
EndProperty
BeginProperty Column03
ColumnWidth = 1665.071
EndProperty
BeginProperty Column04
ColumnWidth = 2505.26
EndProperty
BeginProperty Column05
ColumnWidth = 1170.142
EndProperty
BeginProperty Column06
ColumnWidth = 1230.236
EndProperty
BeginProperty Column07
ColumnWidth = 1184.882
EndProperty
BeginProperty Column08
ColumnWidth = 1140.095
EndProperty
BeginProperty Column09
ColumnWidth = 734.74
EndProperty
BeginProperty Column10
ColumnWidth = 2429.858
EndProperty
EndProperty
End
End
Begin VB.Label lbl_status
BackStyle = 0 'Transparent
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 720
TabIndex = 17
Top = 120
Width = 8895
End
End
Attribute VB_Name = "frmSearch"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim fnd As String
Dim mflag As Boolean
Dim bflag As Boolean
Dim conn As ADODB.Connection
Dim MR As ADODB.Recordset
Dim BR As ADODB.Recordset
Private Sub cmb_bfield_click()
If (cmb_bfield.Text = "所有") Then
txt_bvalue.Enabled = False
Else
txt_bvalue.Enabled = True
End If
lbl_status.Caption = "查询图书记录字段."
txt_bvalue.Text = ""
End Sub
Private Sub cmb_mfield_click()
If (cmb_mfield.Text = "所有") Then
txt_mvalue.Enabled = False
Else
txt_mvalue.Enabled = True
End If
txt_mvalue.Text = ""
lbl_status.Caption = " 查询读者记录字段."
End Sub
Private Sub cmd_bsearch_Click()
On eror GoTo errlable:
'write code for validity
again:
bpbar.Value = 0
If (cmb_bfield.Text = "所有" Or txt_bvalue.Text = "") Then
fnd = "select Author1,Author2,Author3,Avano,Bookid,Edition,ISBNNumber,Issno,Pages,Price,Publication,Subject,Title,Totalno from Book order by Bookid"
lbl_status.Caption = " 查询图书所有记录数据."
bpbar.Value = 30
ElseIf (cmb_bfield.Text = "作者") Then
fnd = "select Author1,Author2,Author3,Avano,Bookid,Edition,ISBNNumber,Issno,Pages,Price,Publication,Subject,Title,Totalno from Book where Author1 like'" & Trim(txt_bvalue.Text) & "%' or Author2 like'" & Trim(txt_bvalue.Text) & "%' or Author3 like'" & Trim(txt_bvalue.Text) & "%'"
lbl_status.Caption = " 查询图书的作者字段."
bpbar.Value = 30
ElseIf (cmb_bfield.Text = "书号") Then
fnd = "select Author1,Author2,Author3,Avano,Bookid,Edition,ISBNNumber,Issno,Pages,Price,Publication,Subject,Title,Totalno from Book where Bookid like'" & Trim(txt_bvalue.Text) & "%'"
lbl_status.Caption = " 查询图书的书号字段."
bpbar.Value = 30
ElseIf (cmb_bfield.Text = "书名") Then
fnd = "select Author1,Author2,Author3,Avano,Bookid,Edition,ISBNNumber,Issno,Pages,Price,Publication,Subject,Title,Totalno from Book where Title like'" & Trim(txt_bvalue.Text) & "%'"
lbl_status.Caption = " 查询图书的书名字段."
bpbar.Value = 30
ElseIf (cmb_bfield.Text = "出版社") Then
fnd = "select Author1,Author2,Author3,Avano,Bookid,Edition,ISBNNumber,Issno,Pages,Price,Publication,Subject,Title,Totalno from Book where Publication like'" & Trim(txt_bvalue.Text) & "%'"
lbl_status.Caption = " 查询图书的出版社字段."
bpbar.Value = 30
ElseIf (cmb_bfield.Text = "ISBN号") Then
fnd = "select Author1,Author2,Author3,Avano,Bookid,Edition,ISBNNumber,Issno,Pages,Price,Publication,Subject,Title,Totalno from Book where ISBNNumber like'" & Trim(txt_bvalue.Text) & "%'"
lbl_status.Caption = " 查询图书的ISBN号字段."
bpbar.Value = 30
ElseIf (cmb_bfield.Text = "类型") Then
fnd = "select Author1,Author2,Author3,Avano,Bookid,Edition,ISBNNumber,Issno,Pages,Price,Publication,Subject,Title,Totalno from Book where Subject like'" & Trim(txt_bvalue.Text) & "%'"
lbl_status.Caption = " 查询图书的类型字段."
bpbar.Value = 30
ElseIf (cmb_bfield.Text = "定价") Then
fnd = "select Author1,Author2,Author3,Avano,Bookid,Edition,ISBNNumber,Issno,Pages,Price,Publication,Subject,Title,Totalno from Book where Price like'" & Trim(txt_bvalue.Text) & "%'"
lbl_status.Caption = " 查询图书的价格字段."
bpbar.Value = 30
ElseIf (cmb_bfield.Text = "页数") Then
fnd = "select Author1,Author2,Author3,Avano,Bookid,Edition,ISBNNumber,Issno,Pages,Price,Publication,Subject,Title,Totalno from Book where Pages like'" & Trim(txt_bvalue.Text) & "%'"
lbl_status.Caption = " 查询图书的页数字段."
bpbar.Value = 30
ElseIf (cmb_bfield.Text = "版次") Then
fnd = "select Author1,Author2,Author3,Avano,Bookid,Edition,ISBNNumber,Issno,Pages,Price,Publication,Subject,Title,Totalno from Book where Edition like'" & Trim(txt_bvalue.Text) & "%'"
lbl_status.Caption = " 查询图书的版次字段."
bpbar.Value = 30
End If
If (bflag = False) Then
BR.Open fnd, conn, adOpenStatic, adLockOptimistic
bpbar.Value = 50
bdatagrid.Visible = True
Set bdatagrid.DataSource = BR
bpbar.Value = 70
bdatagrid.ReBind
bflag = True
bpbar.Value = 85
Else
bflag = False
BR.Close
GoTo again
bpbar.Value = 90
End If
bpbar.Value = 100
bpbar.Value = 0
Exit Sub
errlable:
bpbar.Value = 0
MsgBox Err.Description
End Sub
Private Sub Form_Load()
On Error GoTo errlable
If (view = 1) Then
Me.Top = 50
Me.Left = 50
ElseIf (view = 2) Then
Me.Top = 700
Me.Left = (Screen.Width - Me.Width) / 2
End If
'Image1.Picture = mdi_start.ImageList1.ListImages(2).Picture
Set conn = New ADODB.Connection
conn.CursorLocation = adUseClient
conn.ConnectionString = "DSN=library;UID=sa;PWD=;"
conn.Open
Set BR = New ADODB.Recordset
Set MR = New ADODB.Recordset
lbl_status.Caption = " 为数据源选择字段选项,为查询指定赋值条件."
Exit Sub
errlable:
MsgBox Err.Number & " " & Err.Description
End Sub
Private Sub Form_Unload(Cancel As Integer)
Unload Me
End Sub
Private Sub txt_msearch_Click()
'write a code validity
On Error GoTo errlable
again:
mpbar.Value = 0
lbl_status.Caption = "查询读者的" & Trim(cmb_mfield.Text) & " 字段."
If (cmb_mfield.Text = "所有" Or txt_mvalue.Text = "") Then
fnd = "select Address,Birthdate,Bookinhand,Deposite,Doexpire,Dojoin,Email,Mname,Memid,Noted,Phone,Sex from Member Order by Memid"
lbl_status.Caption = " 查询读者所有记录数据."
mpbar.Value = 40
ElseIf (cmb_mfield.Text = "姓名") Then
fnd = "select Address,Birthdate,Bookinhand,Deposite,Doexpire,Dojoin,Email,Mname,Memid,Noted,Phone,Sex from Member where Mname like '" & Trim(txt_mvalue.Text) & "%'"
mpbar.Value = 40
ElseIf (cmb_mfield.Text = "借书证号") Then
fnd = "select Address,Birthdate,Bookinhand,Deposite,Doexpire,Dojoin,Email,Mname,Memid,Noted,Phone,Sex from Member where Memid=" & Trim(txt_mvalue.Text)
mpbar.Value = 40
ElseIf (cmb_mfield.Text = "地址") Then
fnd = "select Address,Birthdate,Bookinhand,Deposite,Doexpire,Dojoin,Email,Mname,Memid,Noted,Phone,Sex from Member where Address like '" & Trim(txt_mvalue.Text) & "%'"
mpbar.Value = 40
ElseIf (cmb_mfield.Text = "联系电话") Then
fnd = "select Address,Birthdate,Bookinhand,Deposite,Doexpire,Dojoin,Email,Mname,Memid,Noted,Phone,Sex from Member where Phone like'" & Trim(txt_mvalue.Text) & "%'"
mpbar.Value = 40
ElseIf (cmb_mfield.Text = "电子邮箱") Then
fnd = "select Address,Birthdate,Bookinhand,Deposite,Doexpire,Dojoin,Email,Mname,Memid,Noted,Phone,Sex from Member where Email like'" & Trim(txt_mvalue.Text) & "%'"
mpbar.Value = 40
ElseIf (cmb_mfield.Text = "出生日期") Then
fnd = "select Address,Birthdate,Bookinhand,Deposite,Doexpire,Dojoin,Email,Mname,Memid,Noted,Phone,Sex from Member where Birthdate like'" & Trim(txt_mvalue.Text) & "%'"
mpbar.Value = 40
ElseIf (cmb_mfield.Text = "加入时间") Then
fnd = "select Address,Birthdate,Bookinhand,Deposite,Doexpire,Dojoin,Email,Mname,Memid,Noted,Phone,Sex from Member where Dojoin like'" & Trim(txt_mvalue.Text) & "%'"
mpbar.Value = 40
End If
If (mflag = False) Then
MR.Open fnd, conn, adOpenStatic, adLockOptimistic
mpbar.Value = 65
mdatagrid.Visible = True
Set mdatagrid.DataSource = MR
mpbar.Value = 80
mdatagrid.ReBind
mflag = True
mpbar.Value = 90
Else
mflag = False
MR.Close
GoTo again
End If
mpbar.Value = 100
mpbar.Value = 0
Exit Sub
errlable:
mpbar.Value = 0
MsgBox Err.Number & " " & Err.Description
End Sub