📄 excelfile.frm
字号:
VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "comdlg32.ocx"
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form excelfile
BorderStyle = 1 'Fixed Single
Caption = "excel文件数据转入库存"
ClientHeight = 5820
ClientLeft = 45
ClientTop = 330
ClientWidth = 9270
Icon = "excelfile.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 5820
ScaleWidth = 9270
StartUpPosition = 1 'CenterOwner
Begin VB.CheckBox Check1
Caption = "ISBN处理"
Height = 285
Left = 1770
TabIndex = 33
Top = 3120
Value = 1 'Checked
Width = 1125
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1
Height = 2415
Left = 120
TabIndex = 32
Top = 600
Width = 9015
_ExtentX = 15901
_ExtentY = 4260
_Version = 393216
FixedCols = 0
BackColor = -2147483628
BackColorBkg = 16776960
ScrollBars = 1
End
Begin VB.OptionButton Option4
Caption = "ISBN、书名和价格查重"
Height = 255
Left = 7080
TabIndex = 31
Top = 3120
Width = 2175
End
Begin VB.OptionButton Option3
Caption = "ISBN和书名查重"
Height = 255
Left = 5340
TabIndex = 30
Top = 3120
Width = 1695
End
Begin VB.OptionButton Option2
Caption = "ISBN查重"
Height = 255
Left = 3960
TabIndex = 29
Top = 3120
Width = 1335
End
Begin VB.OptionButton Option1
Caption = "不查重"
Height = 255
Left = 3000
TabIndex = 28
Top = 3120
Value = -1 'True
Width = 885
End
Begin VB.CommandButton Command3
Caption = "退出"
Height = 375
Left = 8160
TabIndex = 16
Top = 120
Width = 975
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
Height = 1725
Left = 30
MultiLine = -1 'True
TabIndex = 19
Top = 3510
Width = 9225
End
Begin VB.ComboBox Combo7
Height = 315
Left = 4560
TabIndex = 18
Text = "无字段对应"
Top = 4800
Width = 1335
End
Begin VB.CommandButton Command2
Caption = "第三步:excel数据转入 "
Height = 375
Left = 120
TabIndex = 15
Top = 5400
Width = 2895
End
Begin VB.ComboBox Combo2
Height = 315
Left = 4560
TabIndex = 7
Text = "无字段对应"
Top = 3600
Width = 1335
End
Begin VB.ComboBox Combo3
Height = 315
Left = 1080
TabIndex = 6
Text = "无字段对应"
Top = 4800
Width = 1335
End
Begin VB.ComboBox Combo4
Height = 315
Left = 1080
TabIndex = 5
Text = "无字段对应"
Top = 3960
Width = 1335
End
Begin VB.ComboBox Combo5
Height = 315
Left = 4560
TabIndex = 4
Text = "无字段对应"
Top = 4440
Width = 1335
End
Begin VB.ComboBox Combo6
Height = 315
Left = 4560
TabIndex = 3
Text = "无字段对应"
Top = 3960
Width = 1335
End
Begin VB.ComboBox Combo1
Height = 315
IMEMode = 1 'ON
ItemData = "excelfile.frx":0442
Left = 1080
List = "excelfile.frx":0444
TabIndex = 2
Text = "无字段对应"
Top = 3600
Width = 1335
End
Begin MSComDlg.CommonDialog CommonDialog1
Left = 2760
Top = 3720
_ExtentX = 847
_ExtentY = 847
_Version = 393216
DefaultExt = "*.xls"
Filter = "*.xls|*.xls"
End
Begin VB.CommandButton Command1
Caption = "第一步:请选择excel文件>"
Height = 375
Left = 120
TabIndex = 0
Top = 120
Width = 2895
End
Begin VB.ComboBox Combo9
Height = 315
Left = 1080
TabIndex = 21
Text = "无字段对应"
Top = 4440
Width = 1335
End
Begin VB.ComboBox Combo10
Height = 315
Left = 7560
TabIndex = 22
Text = "无字段对应"
Top = 4440
Width = 1335
End
Begin VB.ComboBox Combo12
Height = 315
Left = 7560
TabIndex = 26
Text = "无字段对应"
Top = 3960
Width = 1335
End
Begin VB.ComboBox Combo11
Height = 315
Left = 7560
TabIndex = 25
Text = "无字段对应"
Top = 3600
Width = 1335
End
Begin VB.ComboBox Combo13
Height = 315
Left = 7560
TabIndex = 27
Text = "无对应字段"
Top = 4800
Width = 1335
End
Begin VB.Data Data2
Caption = "Data2"
Connect = "Access"
DatabaseName = "D:\CBSSYS\bookcgk.mdb"
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 345
Left = 6240
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "本馆数据"
Top = 120
Visible = 0 'False
Width = 1695
End
Begin VB.Label Label11
Caption = "分 类："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 6480
TabIndex = 24
Top = 3600
Width = 975
End
Begin VB.Label Label9
Caption = "排架号："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Left = 6480
TabIndex = 23
Top = 3960
Width = 1095
End
Begin VB.Label Label5
Caption = "内 容:"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 1
Left = 240
TabIndex = 20
Top = 4440
Width = 975
End
Begin VB.Label Label10
Caption = "库存数："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 315
Left = 3480
TabIndex = 17
Top = 4800
Width = 975
End
Begin VB.Label Label8
Caption = "第二步:对字段>"
Height = 255
Left = 240
TabIndex = 14
Top = 3120
Width = 1665
End
Begin VB.Line Line1
X1 = 0
X2 = 9240
Y1 = 5280
Y2 = 5280
End
Begin VB.Label Label2
Caption = "ISBN号:"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 240
TabIndex = 13
Top = 3600
Width = 1335
End
Begin VB.Label Label3
Caption = "书 名:"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 3480
TabIndex = 12
Top = 3600
Width = 855
End
Begin VB.Label Label4
Caption = "作者:"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 240
TabIndex = 11
Top = 4800
Width = 975
End
Begin VB.Label Label5
Caption = "出版社:"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 0
Left = 240
TabIndex = 10
Top = 3960
Width = 975
End
Begin VB.Label Label6
Caption = "出版年:"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -