📄 商品调拨单.frm
字号:
End
Begin VB.TextBox Text2
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 285
Index = 3
Left = 4590
TabIndex = 20
Top = 4170
Width = 825
End
Begin VB.TextBox Text2
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 285
Index = 2
Left = 4590
TabIndex = 19
Top = 3810
Width = 825
End
Begin VB.TextBox Text2
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 285
Index = 1
Left = 4590
TabIndex = 18
Top = 3480
Width = 825
End
Begin VB.TextBox Text2
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 285
Index = 0
Left = 4590
TabIndex = 17
Top = 3120
Width = 825
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 285
Index = 5
Left = 3150
TabIndex = 16
Top = 4890
Width = 1365
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 285
Index = 4
Left = 3150
TabIndex = 15
Top = 4530
Width = 1395
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 285
Index = 3
Left = 3150
TabIndex = 14
Top = 4200
Width = 1365
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 285
Index = 2
Left = 3150
TabIndex = 13
Top = 3870
Width = 1365
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 255
Index = 1
Left = 3120
TabIndex = 12
Top = 3510
Width = 1395
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 285
Index = 0
Left = 3150
TabIndex = 11
Top = 3120
Width = 1395
End
Begin VB.TextBox Text
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 270
Index = 5
Left = 360
TabIndex = 10
Top = 4890
Width = 2715
End
Begin VB.TextBox Text
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 270
Index = 4
Left = 330
TabIndex = 9
Top = 4560
Width = 2745
End
Begin VB.TextBox Text
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 270
Index = 3
Left = 330
TabIndex = 8
Top = 4200
Width = 2745
End
Begin VB.TextBox Text
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 270
Index = 2
Left = 330
TabIndex = 7
Top = 3840
Width = 2745
End
Begin VB.TextBox Text
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 270
Index = 1
Left = 360
TabIndex = 6
Top = 3450
Width = 2685
End
Begin VB.TextBox Text
Appearance = 0 'Flat
BorderStyle = 0 'None
Height = 270
Index = 0
Left = 360
TabIndex = 5
Top = 3120
Width = 2685
End
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 1110
Left = 0
TabIndex = 4
Top = 0
Width = 11460
_ExtentX = 20214
_ExtentY = 1958
ButtonWidth = 1455
ButtonHeight = 1799
ToolTips = 0 'False
Wrappable = 0 'False
Appearance = 1
ImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 4
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "入库保存"
Key = "save"
ImageIndex = 1
Style = 1
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "修改"
Key = "modify"
ImageIndex = 2
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "打印"
Key = "print"
ImageIndex = 3
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "退出"
Key = "quit"
ImageIndex = 4
EndProperty
EndProperty
BorderStyle = 1
MousePointer = 99
OLEDropMode = 1
Begin MSComctlLib.ImageList ImageList1
Left = 840
Top = 240
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 48
ImageHeight = 48
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 4
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "商品调拨单.frx":0442
Key = "first"
Object.Tag = "fi"
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "商品调拨单.frx":214C
Key = "modify"
Object.Tag = "mo"
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "商品调拨单.frx":259E
Key = "print"
Object.Tag = "pr"
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "商品调拨单.frx":33F0
Key = "quit"
Object.Tag = "qu"
EndProperty
EndProperty
End
End
Begin MSComDlg.CommonDialog cd
Left = 0
Top = 0
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin VB.Label date1
BackStyle = 0 'Transparent
Height = 435
Left = 960
TabIndex = 65
Top = 1890
Width = 1935
End
Begin VB.Label date
BackStyle = 0 'Transparent
Caption = "日期："
Height = 255
Left = 330
TabIndex = 3
Top = 2070
Width = 2415
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "№：00000001"
Height = 255
Left = 9090
TabIndex = 2
Top = 2070
Width = 2535
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "商品入库单"
BeginProperty Font
Name = "宋体"
Size = 18
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 5010
TabIndex = 1
Top = 1710
Width = 1935
End
Begin VB.Line Line1
BorderColor = &H00FFFF00&
BorderWidth = 3
X1 = 5010
X2 = 6930
Y1 = 2190
Y2 = 2190
End
Begin WordCtl.Document Document1
Height = 4680
Index = 0
Left = 300
OleObjectBlob = "商品调拨单.frx":370A
TabIndex = 0
Top = 2310
Width = 14370
End
End
Attribute VB_Name = "tpaper"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub Form_Load()
date1.Caption = Year(Now) & "年" & Month(Now) & "月" & Day(Now) & "日"
End Sub
'VB 在线
'www.VBzx.net
' VB在线 收集整理
'+------------------------------------------------+
' http://www.VBzx.net
'+------------------------------------------------+
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Key
Case "save"
Static numi As Integer
numi = numi + 1
num = numi
Dim txtSQL(0 To 2) As String
Dim mrc As ADODB.Recordset
Dim MsgText As String
Dim miCount As Integer
'ToDo: create test for correct password
'check for correct password
If Trim(Text8.Text) = "" Then
MsgBox "调拨单填写不正确！请填好！"
Exit Sub
Else
txtSQL(0) = "select *from 商品调拨单 "
Set mrc = ExecuteSQL(txtSQL(0), MsgText)
miCount = mrc.RecordCount + 1
If numi <= miCount Then numi = miCount
Text9.Text = numi
Text9.Enabled = False
Label2.Caption = "№0000000" & numi
mrc.AddNew
mrc.Fields(0) = Trim(Text8.Text)
mrc.Fields(1) = Trim(Text9.Text)
mrc.Fields(2) = Trim(Text10.Text)
mrc.Fields(3) = Trim(Text(0).Text)
mrc.Fields(4) = Trim(Text1(0).Text)
mrc.Fields(5) = Trim(Text2(0).Text)
mrc.Fields(6) = Trim(Text3(1).Text)
mrc.Fields(7) = Trim(Text4(0).Text)
mrc.Fields(8) = Trim(Text5(0).Text)
mrc.Fields(9) = Trim(Text6(0).Text)
If Trim(Text(1).Text) <> "" Then
numi = numi + 1
mrc.Fields(0) = Trim(Text8.Text)
mrc.Fields(1) = Trim(Text9.Text)
mrc.Fields(3) = Trim(Text(1).Text)
mrc.Fields(4) = Trim(Text1(1).Text)
mrc.Fields(5) = Trim(Text2(1).Text)
mrc.Fields(6) = Trim(Text3(0).Text)
mrc.Fields(7) = Trim(Text4(1).Text)
mrc.Fields(8) = Trim(Text5(1).Text)
mrc.Fields(9) = Trim(Text6(1).Text)
End If
If Trim(Text(2).Text) <> "" Then
numi = numi + 1
mrc.Fields(0) = Trim(Text8.Text)
mrc.Fields(1) = Trim(Text9.Text)
mrc.Fields(3) = Trim(Text(2).Text)
mrc.Fields(4) = Trim(Text1(2).Text)
mrc.Fields(5) = Trim(Text2(2).Text)
mrc.Fields(6) = Trim(Text3(2).Text)
mrc.Fields(7) = Trim(Text4(2).Text)
mrc.Fields(8) = Trim(Text5(2).Text)
mrc.Fields(9) = Trim(Text6(2).Text)
End If
If Trim(Text(3).Text) <> "" Then
numi = numi + 1
mrc.Fields(0) = Trim(Text8.Text)
mrc.Fields(1) = Trim(Text9.Text)
mrc.Fields(3) = Trim(Text(3).Text)
mrc.Fields(4) = Trim(Text1(3).Text)
mrc.Fields(5) = Trim(Text2(3).Text)
mrc.Fields(6) = Trim(Text3(3).Text)
mrc.Fields(7) = Trim(Text4(3).Text)
mrc.Fields(8) = Trim(Text5(3).Text)
mrc.Fields(9) = Trim(Text6(3).Text)
End If
If Trim(Text(4).Text) <> "" Then
numi = numi + 1
mrc.Fields(0) = Trim(Text8.Text)
mrc.Fields(1) = Trim(Text9.Text)
mrc.Fields(3) = Trim(Text(4).Text)
mrc.Fields(4) = Trim(Text1(4).Text)
mrc.Fields(5) = Trim(Text2(4).Text)
mrc.Fields(6) = Trim(Text3(4).Text)
mrc.Fields(7) = Trim(Text4(4).Text)
mrc.Fields(8) = Trim(Text5(4).Text)
mrc.Fields(9) = Trim(Text6(4).Text)
End If
If Trim(Text(5).Text) <> "" Then
numi = numi + 1
mrc.Fields(0) = Trim(Text8.Text)
mrc.Fields(1) = Trim(Text9.Text)
mrc.Fields(3) = Trim(Text(5).Text)
mrc.Fields(4) = Trim(Text1(5).Text)
mrc.Fields(5) = Trim(Text2(5).Text)
mrc.Fields(6) = Trim(Text3(5).Text)
mrc.Fields(7) = Trim(Text4(5).Text)
mrc.Fields(8) = Trim(Text5(5).Text)
mrc.Fields(9) = Trim(Text6(5).Text)
End If
mrc.Update
mrc.Close
MsgBox "调拨单保存入数据库成功！", vbOKOnly + vbExclamation, "保存调拨单"
Unload Me
End If
Case "modify"
MsgBox "直接在单上修改保存既可！"
Case "print"
付款单.PrintForm
Case "quit"
Unload Me
End Select
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -