📄 main_rcyw_tsrk.frm
字号:
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 VB.ComboBox Combo1
Height = 300
Left = 6630
TabIndex = 14
Top = 1245
Visible = 0 'False
Width = 1110
End
Begin VB.Frame Frame3
Height = 645
Left = 5325
TabIndex = 3
Top = 405
Width = 5715
Begin VB.Label rq
BackStyle = 0 'Transparent
ForeColor = &H00FF0000&
Height = 210
Left = 3900
TabIndex = 16
Top = 255
Width = 1185
End
Begin VB.Label PH
BackStyle = 0 'Transparent
ForeColor = &H00FF0000&
Height = 210
Left = 900
TabIndex = 15
Top = 255
Width = 1905
End
Begin VB.Label Label3
BackColor = &H00FFFFFF&
BackStyle = 0 'Transparent
Caption = "票 号： 入库日期："
Height = 180
Left = 105
TabIndex = 4
Top = 270
Width = 4890
End
End
Begin VB.Frame Frame2
Height = 645
Left = 15
TabIndex = 1
Top = 405
Width = 5340
Begin VB.TextBox jsr
BackColor = &H00FFFFFF&
Height = 270
Left = 975
TabIndex = 22
Top = 240
Width = 2580
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = " 经手人："
ForeColor = &H00000000&
Height = 255
Left = 105
TabIndex = 2
Top = 285
Width = 840
End
End
Begin VB.TextBox text1
BackColor = &H00C0C0FF&
BorderStyle = 0 'None
Height = 210
Left = 375
TabIndex = 0
Top = 1395
Visible = 0 'False
Width = 1485
End
Begin MSFlexGridLib.MSFlexGrid MS1
Height = 3630
Left = 45
TabIndex = 6
Top = 1065
Width = 11055
_ExtentX = 19500
_ExtentY = 6403
_Version = 393216
BackColorFixed = -2147483636
BackColorBkg = 16777215
ScrollBars = 2
End
Begin VB.Frame Frame4
Height = 645
Left = 15
TabIndex = 7
Top = 4680
Width = 5730
Begin VB.Label hjje
BackStyle = 0 'Transparent
ForeColor = &H000000FF&
Height = 210
Left = 4140
TabIndex = 19
Top = 270
Width = 1245
End
Begin VB.Label hjsl
BackStyle = 0 'Transparent
ForeColor = &H00FF0000&
Height = 210
Left = 2370
TabIndex = 18
Top = 270
Width = 840
End
Begin VB.Label pz
BackStyle = 0 'Transparent
ForeColor = &H0000FF00&
Height = 210
Left = 930
TabIndex = 17
Top = 270
Width = 585
End
Begin VB.Label Label4
BackStyle = 0 'Transparent
Caption = "入库品种： 合计数量： 合计金额： 元"
Height = 315
Left = 75
TabIndex = 8
Top = 285
Width = 5625
End
End
Begin VB.Frame Frame5
Height = 645
Left = 5715
TabIndex = 9
Top = 4680
Width = 5325
Begin VB.CommandButton CmdReg
BackColor = &H00FF8080&
Caption = "&D 登记"
Height = 390
Left = 150
Picture = "main_rcyw_tsrk.frx":0457
TabIndex = 13
Top = 180
Width = 1200
End
Begin VB.CommandButton CmdSave
BackColor = &H00C0C0C0&
Caption = "&S 保存"
Enabled = 0 'False
Height = 390
Left = 1425
Picture = "main_rcyw_tsrk.frx":1635
TabIndex = 12
Top = 180
Width = 1200
End
Begin VB.CommandButton CmdCancel
BackColor = &H00FF8080&
Caption = "&C 取消"
Enabled = 0 'False
Height = 390
Left = 2700
Picture = "main_rcyw_tsrk.frx":2813
TabIndex = 11
Top = 180
Width = 1200
End
Begin VB.CommandButton CmdEnd
BackColor = &H00FF8080&
Caption = "&E 退出"
Height = 390
Left = 3975
Picture = "main_rcyw_tsrk.frx":39F1
TabIndex = 10
Top = 180
Width = 1200
End
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "图 书 入 库 凭 证"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 285
Index = 0
Left = 4320
TabIndex = 20
Top = 90
Width = 2655
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "图 书 入 库 凭 证"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Index = 1
Left = 4290
TabIndex = 5
Top = 90
Width = 2655
End
End
Attribute VB_Name = "main_rcyw_tsrk"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim s, Y, i '声明变量
'声明数据集对象
Dim rs1 As New ADODB.Recordset
Dim rs2 As New ADODB.Recordset
Dim rs3 As New ADODB.Recordset
Dim lsph As Integer '声明一个整型变量
Private Sub Form_Load()
'定义MS1表的行数、列数
MS1.Rows = 102
MS1.Cols = 12
'定义MS1表的列宽和表头信息
s = Array("300", "800", "700", "2600", "800", "700", "1000", "800", "800", "600", "800", "800", "800")
Y = Array("xh", "书号", "条形码", "书名", "作者", "出版社", "版 次", "类别", "存放位置", "单价", "入库数量", "金额")
For i = 0 To 11
MS1.ColWidth(i) = s(i)
MS1.TextMatrix(0, i) = Y(i)
Next i
'定义MS1表的行号
For i = 1 To 101
MS1.TextMatrix(i, 0) = i
Next i
rq.Caption = Date '设置入库日期
'添加图书类别列表
Set rs1 = New ADODB.Recordset
rs1.Open "select 类别名称 from tslbb group by 类别名称", Cnn, adOpenKeyset, adLockOptimistic
If rs1.BOF = False Then rs1.MoveFirst
For i = 0 To rs1.RecordCount - 1
Combo1.AddItem (Trim(rs1.Fields("类别名称")))
rs1.MoveNext
Next i
rs1.Close
'添加图书存放位置列表
Set rs2 = New ADODB.Recordset
rs2.Open "select 存放位置 from tswzb group by 存放位置", Cnn, adOpenKeyset, adLockOptimistic
If rs2.BOF = False Then rs2.MoveFirst
For i = 0 To rs2.RecordCount - 1
Combo2.AddItem (Trim(rs2.Fields("存放位置")))
rs2.MoveNext
Next i
rs2.Close
End Sub
Private Sub Form_Unload(Cancel As Integer)
frm_main.Enabled = True
End Sub
Private Sub Combo1_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyReturn Then
MS1.text = Combo1.text
Combo1.Visible = False
MS1.Col = 8
Combo2.Visible = True
Combo2.Width = MS1.CellWidth
Combo2.Left = MS1.CellLeft + MS1.Left
Combo2.Top = MS1.CellTop + MS1.Top
Combo2.SetFocus
End If
End Sub
Private Sub Combo2_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyReturn Then
MS1.text = Combo2.text
Combo2.Visible = False
MS1.Col = 9
Text1.Visible = True
Text1.SetFocus
End If
End Sub
Private Sub grid1_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyReturn Then '当按回车键时
With Adodc1.Recordset
If .RecordCount > 0 Then
If .Fields("书号") <> "" Then
'赋值给MS1表格
If .Fields("书号") <> "" Then MS1.TextMatrix(MS1.Row, 1) = .Fields("书号")
If .Fields("条形码") <> "" Then MS1.TextMatrix(MS1.Row, 2) = .Fields("条形码")
If .Fields("书名") <> "" Then MS1.TextMatrix(MS1.Row, 3) = .Fields("书名")
If .Fields("作者") <> "" Then MS1.TextMatrix(MS1.Row, 4) = .Fields("作者")
If .Fields("出版社") <> "" Then MS1.TextMatrix(MS1.Row, 5) = .Fields("出版社")
If .Fields("图书类别") <> "" Then MS1.TextMatrix(MS1.Row, 7) = .Fields("图书类别")
If .Fields("存放位置") <> "" Then MS1.TextMatrix(MS1.Row, 8) = .Fields("存放位置")
If .Fields("单价") <> "" Then MS1.TextMatrix(MS1.Row, 9) = .Fields("单价")
Text1.text = MS1.text
Text1.SetFocus
MS1.Col = 5 '到达第6列
Grid1.Visible = False
Else
MsgBox ("库存没有图书信息可供选择！")
Grid1.Visible = False 'grid1不可见
Text1.SetFocus
End If
End If
End With
Text1.SetFocus 'text1获得焦点
End If
If KeyCode = vbKeyEscape Then '按ESC键
Grid1.Visible = False 'grid1不可见
Text1.SetFocus 'text1获得焦点
End If
End Sub
Private Sub jsr_GotFocus()
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -