📄 main_jcxx_dzxxsz.frm
字号:
BeginProperty Column09
ColumnWidth = 464.882
EndProperty
BeginProperty Column10
ColumnWidth = 1049.953
EndProperty
BeginProperty Column11
ColumnWidth = 794.835
EndProperty
BeginProperty Column12
ColumnWidth = 1170.142
EndProperty
BeginProperty Column13
ColumnWidth = 780.095
EndProperty
BeginProperty Column14
ColumnWidth = 1260.284
EndProperty
EndProperty
End
End
Begin VB.Frame Frame3
BackColor = &H80000004&
Caption = "请选择查询条件"
Height = 660
Left = 75
TabIndex = 7
Top = 30
Width = 8355
Begin VB.CommandButton CmdPrint
Caption = "打印"
Height = 330
Left = 6765
TabIndex = 42
Top = 210
Width = 1485
End
Begin VB.TextBox Text7
Height = 300
Left = 1185
TabIndex = 10
Top = 225
Width = 3945
End
Begin VB.CommandButton CmdFind
Caption = "查询"
Height = 330
Left = 5205
TabIndex = 9
Top = 210
Width = 1485
End
Begin VB.ComboBox Combo3
Height = 300
ItemData = "main_jcxx_dzxxsz.frx":049B
Left = 105
List = "main_jcxx_dzxxsz.frx":049D
TabIndex = 8
Top = 225
Width = 1095
End
End
Begin VB.Frame Frame2
BackColor = &H00C0C0C0&
Height = 645
Left = 75
TabIndex = 11
Top = 4170
Width = 3105
Begin VB.CommandButton CmdMD
BackColor = &H00FFC0C0&
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Index = 0
Left = 90
Picture = "main_jcxx_dzxxsz.frx":049F
Style = 1 'Graphical
TabIndex = 15
Top = 180
Width = 720
End
Begin VB.CommandButton CmdMD
BackColor = &H00FFC0C0&
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Index = 1
Left = 810
Picture = "main_jcxx_dzxxsz.frx":1AE9
Style = 1 'Graphical
TabIndex = 14
Top = 180
Width = 720
End
Begin VB.CommandButton CmdMD
BackColor = &H00FFC0C0&
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Index = 2
Left = 1530
Picture = "main_jcxx_dzxxsz.frx":301B
Style = 1 'Graphical
TabIndex = 13
Top = 180
Width = 720
End
Begin VB.CommandButton CmdMD
BackColor = &H00FFC0C0&
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Index = 3
Left = 2265
Picture = "main_jcxx_dzxxsz.frx":451F
Style = 1 'Graphical
TabIndex = 12
Top = 180
Width = 720
End
End
Begin VB.Frame Frame4
Height = 645
Left = 3165
TabIndex = 20
Top = 4170
Width = 5340
Begin VB.CommandButton CmdSave
BackColor = &H00C0C0C0&
Caption = "[S]保存"
Enabled = 0 'False
Height = 360
Left = 2655
Style = 1 'Graphical
TabIndex = 26
Top = 180
Width = 855
End
Begin VB.CommandButton CmdAdd
BackColor = &H00C0C0C0&
Caption = "[A]添加"
Height = 360
Left = 90
Style = 1 'Graphical
TabIndex = 25
Top = 180
Width = 855
End
Begin VB.CommandButton CmdDelete
BackColor = &H00C0C0C0&
Caption = "[D]删除"
Height = 360
Left = 1800
Style = 1 'Graphical
TabIndex = 24
Top = 180
Width = 855
End
Begin VB.CommandButton CmdEsc
BackColor = &H00C0C0C0&
Caption = "[E]取消"
Height = 360
Left = 3510
Style = 1 'Graphical
TabIndex = 23
Top = 180
Width = 855
End
Begin VB.CommandButton CmdExit
BackColor = &H00C0C0C0&
Caption = "[X]退出"
Height = 360
Left = 4365
Style = 1 'Graphical
TabIndex = 22
Top = 180
Width = 855
End
Begin VB.CommandButton CmdModify
BackColor = &H00C0C0C0&
Caption = "[M]修改"
Height = 360
Left = 945
Style = 1 'Graphical
TabIndex = 21
Top = 180
Width = 855
End
End
End
Attribute VB_Name = "main_jcxx_dzxxsz"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'****************************************************************************
'人人为我，我为人人
'枕善居收藏整理
'发布日期：2007/08/31
'描 述：新版图书综合管理系统 Ver 2.0
'网 站：http://www.Mndsoft.com/ (VB6源码博客)
'网 站：http://www.VbDnet.com/ (VB.NET源码博客,主要基于.NET2005)
'e-mail ：Mndsoft@163.com
'e-mail ：Mndsoft@126.com
'OICQ ：88382850
' 如果您有新的好的代码别忘记给枕善居哦!
'****************************************************************************
Dim i, a, Mat As Integer '声明整型变量
Dim rs1 As New ADODB.Recordset '声明数据集对象
Private Sub view_data() '声明一个显示reads表中数据的过程
With Adodc1.Recordset
'将reads数据表中各字段的值赋给对应的控件
If .Fields("书证号") <> "" Then Text1.text = .Fields("书证号")
If .Fields("姓名") <> "" Then Text2.text = .Fields("姓名")
If .Fields("性别") <> "" Then Combo1.text = .Fields("性别")
If .Fields("身份证") <> "" Then Text3.text = .Fields("身份证")
If .Fields("单位") <> "" Then Text4.text = .Fields("单位")
If .Fields("家庭住址") <> "" Then Text5.text = .Fields("家庭住址")
If .Fields("联系电话") <> "" Then Text6.text = .Fields("联系电话")
If .Fields("读者类别") <> "" Then Combo2.text = .Fields("读者类别")
If .Fields("收费标准") <> "" Then Label3.Caption = .Fields("收费标准")
If .Fields("期限") <> "" Then Combo4.text = .Fields("期限")
If .Fields("办证价格") <> "" Then Label4.Caption = .Fields("办证价格")
If .Fields("办证日期") <> "" Then DTPicker1.Value = .Fields("办证日期")
If .Fields("到期日期") <> "" Then DTPicker2.Value = .Fields("到期日期")
If .Fields("已借书数") <> "" Then jss.Caption = .Fields("已借书数")
If .Fields("相片路径") <> "" Then
Label6.Caption = .Fields("相片路径")
If Dir(.Fields("相片路径")) <> "" Then
Picture1.Picture = LoadPicture(.Fields("相片路径"))
Else
MsgBox "此读者相片路径错误，请更改！"
Picture1.Picture = LoadPicture("")
End If
Else
Label6.Caption = ""
Picture1.Picture = LoadPicture("")
End If
End With
End Sub
Private Sub Ena() '声明一个设置控件有效或无效的过程
If a = 0 Or a = 1 Then '当变量a=0或a=1时
'设置如下控件有效或无效
Text1.Enabled = True
Text2.Enabled = True
Text3.Enabled = True
Text4.Enabled = True
Text5.Enabled = True
Text6.Enabled = True
Combo1.Enabled = True
Combo2.Enabled = True
Combo4.Enabled = True
DTPicker1.Enabled = True
DTPicker2.Enabled = True
Command1.Enabled = True
CmdSave.Enabled = True
CmdEsc.Enabled = True
CmdAdd.Enabled = False
CmdModify.Enabled = False
CmdDelete.Enabled = False
For i = 0 To 3
CmdMD(i).Enabled = False
Next i
End If
If a = 2 Or a = 3 Then '当变量a=2或a=3时
'设置如下控件有效或无效
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Combo1.Enabled = False
Combo2.Enabled = False
Combo4.Enabled = False
DTPicker1.Enabled = False
DTPicker2.Enabled = False
Command1.Enabled = False
CmdSave.Enabled = False
CmdEsc.Enabled = False
CmdAdd.Enabled = True
CmdModify.Enabled = True
CmdDelete.Enabled = True
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -