📄 cpcx.frm
字号:
VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "COMDLG32.OCX"
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form frmcpcx
Caption = "产品查询"
ClientHeight = 8595
ClientLeft = 60
ClientTop = 345
ClientWidth = 11880
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 8595
ScaleWidth = 11880
StartUpPosition = 3 '窗口缺省
WindowState = 2 'Maximized
Begin MSComDlg.CommonDialog CommonDialog1
Left = 5160
Top = 8040
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin VB.Data Data1
Caption = "Data1"
Connect = "Access"
DatabaseName = "xsys"
DefaultCursorType= 0 '缺省游标
DefaultType = 1 '使用 ODBC
Exclusive = 0 'False
Height = 375
Left = 2760
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = ""
Top = 8160
Visible = 0 'False
Width = 2055
End
Begin VB.Frame Frame1
Caption = "产品查询"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 6975
Left = 840
TabIndex = 0
Top = 840
Width = 10095
Begin VB.CommandButton Command3
Caption = "打 印"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 8040
TabIndex = 6
Top = 720
Width = 1215
End
Begin VB.CommandButton Command2
Caption = "返 回"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 6600
TabIndex = 5
Top = 720
Width = 1215
End
Begin MSDBGrid.DBGrid DBGrid1
Bindings = "cpcx.frx":0000
Height = 5055
Left = 1080
OleObjectBlob = "cpcx.frx":0014
TabIndex = 4
Top = 1680
Width = 8175
End
Begin VB.CommandButton Command1
Caption = "查 询"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 5160
TabIndex = 3
Top = 720
Width = 1215
End
Begin VB.TextBox txtid
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 2640
TabIndex = 2
Top = 720
Width = 2055
End
Begin VB.Label Label1
Caption = "产品编号："
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 495
Left = 1080
TabIndex = 1
Top = 720
Width = 1455
End
End
End
Attribute VB_Name = "frmcpcx"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
DefaultType = dbUseODBC
Dim db As Database
Dim wk As Workspace
Dim sql As String
Set wk = DBEngine.Workspaces(0)
Set db = OpenDatabase("xsys", dbDriverNoPrompt, False, "odbc;database=glxt;uid=;pwd=;dsn=xsys")
wk.BeginTrans
If txtid = "" Then
sql = "select 产品编号,条码,规格 from xhk"
Data1.RecordSource = sql
Data1.Refresh
Else
sql = "select 产品编号,条码,规格 from xhk where 产品编号='" + txtid.Text + "'"
Data1.RecordSource = sql
Data1.Refresh
End If
db.Close
End Sub
Private Sub Command2_Click()
Unload Me
frmmenu.Show
End Sub
Private Sub Command3_Click()
DefaultType = dbUseODBC
Dim db As Database
Dim rs1 As Recordset
Dim wk As Workspace
Dim sql As String
Set wk = DBEngine.Workspaces(0)
Set db = OpenDatabase("xsys", dbDriverNoPrompt, False, "odbc;database=glxt;uid=;pwd=;dsn=xsys")
sql = "select 产品编号,条码,规格 from xhk"
Set rs1 = db.OpenRecordset(sql, dbOpenDynaset, dbwrite, dbOptimistic)
CommonDialog1.ShowPrinter
Printer.Orientation = vbPRORPortrait
Printer.PaperSize = vbPRPSA4
Printer.ScaleMode = vbMillimeters
Printer.FontName = "宋体"
rs1.MoveFirst
Printer.FontSize = 18
Printer.CurrentX = 50
Printer.CurrentY = 15
Printer.Print "扬州市兴盛牙刷厂产品型号表"
Printer.Line (40, 22)-(140, 22)
Printer.Line (40, 23)-(140, 23)
Printer.FontSize = 10
Printer.CurrentX = 29.5
Printer.CurrentY = 41.5
Printer.Line (29.5, 41.5)-(150, 41.5)
Printer.CurrentX = 29
Printer.CurrentY = 42
Printer.Line (30, 42)-(30, 47)
Printer.CurrentX = 31
Printer.CurrentY = 42
Printer.Print " 产品型号"
Printer.CurrentX = 55
Printer.CurrentY = 42
Printer.Line (56, 42)-(56, 47)
Printer.CurrentX = 62
Printer.CurrentY = 42
Printer.Print " 条 码"
Printer.CurrentX = 91
Printer.CurrentY = 42
Printer.Line (92, 42)-(92, 47)
Printer.CurrentX = 93
Printer.CurrentY = 42
Printer.Print " 规 格"
Printer.CurrentX = 150
Printer.CurrentY = 42
Printer.Line (150, 42)-(150, 47)
Printer.Line (30, 47)-(150, 47)
CurrentY = 47
Do While rs1.EOF <> True
1 Printer.FontSize = 10
CurrentX = 29.75
Printer.Line (CurrentX, CurrentY)-(CurrentX, CurrentY + 5)
CurrentX = CurrentX + 1
Printer.CurrentX = CurrentX
Printer.CurrentY = CurrentY + 1
Printer.Print rs1.Fields("产品编号")
CurrentX = CurrentX + 25
Printer.Line (CurrentX, CurrentY)-(CurrentX, CurrentY + 5)
CurrentX = CurrentX + 1
Printer.CurrentX = CurrentX
Printer.CurrentY = CurrentY + 1
Printer.Print rs1.Fields("条码")
CurrentX = CurrentX + 35
Printer.Line (CurrentX, CurrentY)-(CurrentX, CurrentY + 5)
CurrentX = CurrentX + 1
Printer.CurrentX = CurrentX
Printer.CurrentY = CurrentY + 1
Printer.Print rs1.Fields("规格")
CurrentX = CurrentX + 57.5
Printer.Line (CurrentX, CurrentY)-(CurrentX, CurrentY + 5)
Printer.Line (30, CurrentY + 5)-(150, CurrentY + 5)
CurrentY = CurrentY + 5
rs1.MoveNext
If CurrentY >= 250 Then
Printer.NewPage
CurrentY = 15
Printer.Line (30, CurrentY)-(150, CurrentY)
GoTo 1
End If
If rs1.EOF = True Then
Exit Do
End If
Loop
Printer.EndDoc
rs1.Close
db.Close
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -