📄 cpbjlj.frm
字号:
VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Object = "{C932BA88-4374-101B-A56C-00AA003668DC}#1.1#0"; "MSMASK32.OCX"
Object = "{4F29B06F-16D9-4A0C-9C8A-2F0C02F625FE}#1.0#0"; "FlexCell.ocx"
Begin VB.Form cpbjlj
Caption = "产品、部件、零件"
ClientHeight = 8460
ClientLeft = 60
ClientTop = 450
ClientWidth = 11880
LinkTopic = "Form1"
MDIChild = -1 'True
ScaleHeight = 8460
ScaleWidth = 11880
Begin VB.CheckBox chkyn
Caption = "显示NO"
Height = 255
Left = 9720
TabIndex = 3
Top = 240
Width = 975
End
Begin VB.CommandButton cmdfind
Caption = "刷新"
Height = 315
Left = 10860
TabIndex = 12
Top = 180
Width = 915
End
Begin MSMask.MaskEdBox mskdate0
Height = 255
Left = 8040
TabIndex = 29
Top = 240
Width = 1275
_ExtentX = 2249
_ExtentY = 450
_Version = 393216
PromptChar = "_"
End
Begin MSComCtl2.MonthView MonthView1
Height = 2370
Left = 7740
TabIndex = 26
Top = 600
Width = 4065
_ExtentX = 7170
_ExtentY = 4180
_Version = 393216
ForeColor = -2147483630
BackColor = -2147483633
Appearance = 1
StartOfWeek = 65077249
CurrentDate = 38911
End
Begin VB.CommandButton cmddate0
Caption = "Command1"
Height = 255
Left = 9360
TabIndex = 25
Top = 240
Width = 255
End
Begin VB.Frame Frame4
Caption = "产品信息输入"
Height = 3495
Left = -60
TabIndex = 8
Top = 540
Width = 11775
Begin FlexCell.Grid Grid1
Height = 2265
Left = 150
TabIndex = 30
Top = 240
Width = 11595
_ExtentX = 20452
_ExtentY = 3995
Cols = 5
Rows = 30
End
Begin VB.TextBox txtcpxh
Appearance = 0 'Flat
Height = 315
Left = 6300
MaxLength = 12
TabIndex = 27
Top = 2520
Width = 2115
End
Begin VB.TextBox mskdate1
Appearance = 0 'Flat
Height = 315
Left = 6300
TabIndex = 23
Top = 3000
Width = 1515
End
Begin VB.Frame Frame1
Height = 615
Left = 8760
TabIndex = 16
Top = 2640
Width = 2835
Begin VB.CommandButton cmdadd1
Caption = "增加"
Height = 255
Left = 120
TabIndex = 19
Top = 240
Width = 795
End
Begin VB.CommandButton cmdsave1
Caption = "保存"
Height = 255
Left = 1020
TabIndex = 18
Top = 240
Width = 795
End
Begin VB.CommandButton cmddelete1
Caption = "删行"
Height = 255
Left = 1920
TabIndex = 17
Top = 240
Width = 795
End
End
Begin VB.ComboBox cmbdh
Height = 315
Left = 840
TabIndex = 11
Text = "Combo1"
Top = 3060
Width = 4275
End
Begin VB.TextBox txtcpbh
Appearance = 0 'Flat
BackColor = &H00E0E0E0&
Enabled = 0 'False
Height = 315
Left = 840
TabIndex = 10
Top = 2520
Width = 1275
End
Begin VB.TextBox txtcpmc
Appearance = 0 'Flat
Height = 315
Left = 3000
MaxLength = 24
TabIndex = 9
Top = 2520
Width = 2055
End
Begin VB.Label Label1
Caption = "产品型号"
Height = 195
Index = 0
Left = 5400
TabIndex = 28
Top = 2640
Width = 735
End
Begin VB.Label Label3
Caption = "填制日期"
Height = 195
Index = 1
Left = 5460
TabIndex = 24
Top = 3060
Width = 735
End
Begin VB.Label Label1
Caption = "订货单位"
Height = 195
Index = 1
Left = 120
TabIndex = 15
Top = 3060
Width = 735
End
Begin VB.Label Label1
Caption = "产品编号"
Height = 195
Index = 2
Left = 120
TabIndex = 14
Top = 2580
Width = 735
End
Begin VB.Label Label1
Caption = "产品名称"
Height = 195
Index = 3
Left = 2160
TabIndex = 13
Top = 2580
Width = 735
End
End
Begin VB.TextBox txtcode2
Height = 285
Left = 11220
TabIndex = 2
Top = 240
Width = 615
End
Begin VB.Frame Frame3
Height = 4155
Left = 60
TabIndex = 1
Top = 4260
Width = 11715
Begin FlexCell.Grid Grid2
Height = 3375
Left = 90
TabIndex = 31
Top = 180
Width = 11535
_ExtentX = 20346
_ExtentY = 5953
Cols = 5
Rows = 30
End
Begin VB.Frame Frame2
Height = 555
Left = 8460
TabIndex = 4
Top = 3540
Width = 3135
Begin VB.CommandButton cmdexit
Caption = "退出"
Height = 255
Left = 2160
TabIndex = 20
Top = 180
Width = 795
End
Begin VB.CommandButton cmdadd2
Caption = "增行"
Height = 255
Left = 120
TabIndex = 6
Top = 180
Width = 795
End
Begin VB.CommandButton cmdsave2
Caption = "保存"
Height = 255
Left = 1200
TabIndex = 5
Top = 180
Width = 735
End
End
Begin VB.Label Label1
Caption = "注：部件长度20位，图号10位"
Height = 195
Index = 4
Left = 420
TabIndex = 7
Top = 3780
Width = 3375
End
End
Begin VB.TextBox txtcode1
Height = 285
Left = 11100
TabIndex = 0
Top = 60
Width = 555
End
Begin VB.Label Label3
Caption = "显示日期"
Height = 195
Index = 0
Left = 7260
TabIndex = 22
Top = 300
Width = 795
End
Begin VB.Label Label2
Caption = "产品、部件信息录入"
BeginProperty Font
Name = "MS Sans Serif"
Size = 18
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 375
Left = 3720
TabIndex = 21
Top = 60
Width = 3555
End
End
Attribute VB_Name = "cpbjlj"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'为保证数据库结构的完整性，如下级有信息录入，则上级不能删除
'表1产品填制日期决定本产品的数据是否在统计区间，是否统计决定本产品是否统计数据(Y计入/N不计入)
'单位更改时，只选择单位编号，单位名称在保存时自动更改
Option Explicit
Dim tempcpbh As String, tempcpmc As String, tempdate1 As String
Dim cpzltemp As Currency '产品重量
Private Sub Form_Load()
Me.Width = 12000
Me.Height = 9000
dogridfirst
dogridfill1
dogridfill2
mskdate0.Text = Format(NOWDate - 100, "yyyy-mm-dd")
Mskdate1.Text = Format(NOWDate, "yyyy-mm-dd") '默认填制日期为当天
dogridfind '产品表内容
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -