c
资源名称:ERPSYS.zip [点击查看]
上传用户:zhpu1995
上传日期:2013-09-06
资源大小:61151k
文件大小:43k
源码类别:
企业管理
开发平台:
Visual Basic
- VERSION 5.00
- Object = "{65A39231-6133-11D1-BAA2-444553540000}#1.0#0"; "vslight6.OCX"
- Object = "{D76D7128-4A96-11D3-BD95-D296DC2DD072}#1.0#0"; "VSOCX7.OCX"
- Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
- Begin VB.Form FrmProGraph_Zst
- Caption = "成品等级走势图"
- ClientHeight = 8595
- ClientLeft = 315
- ClientTop = 390
- ClientWidth = 11820
- HelpContextID = 5001
- Icon = "c成品检验管理_成品质量等级走势图.frx":0000
- KeyPreview = -1 'True
- LinkTopic = "Form1"
- MDIChild = -1 'True
- ScaleHeight = 8595
- ScaleWidth = 11820
- WindowState = 2 'Maximized
- Begin VB.PictureBox Pic_Title
- BackColor = &H80000009&
- Height = 1065
- Left = 45
- Picture = "c成品检验管理_成品质量等级走势图.frx":1042
- ScaleHeight = 1005
- ScaleWidth = 11535
- TabIndex = 0
- Top = 570
- Width = 11595
- Begin VB.Label Label7
- BackStyle = 0 'Transparent
- ForeColor = &H00FF0000&
- Height = 255
- Left = 9870
- TabIndex = 11
- Top = 705
- Width = 375
- End
- Begin VB.Label Label6
- BackStyle = 0 'Transparent
- Caption = "周期数:"
- Height = 255
- Left = 9120
- TabIndex = 10
- Top = 705
- Width = 675
- End
- Begin VB.Label Label4
- BackStyle = 0 'Transparent
- Caption = "周期:"
- Height = 255
- Left = 10230
- TabIndex = 9
- Top = 705
- Width = 495
- End
- Begin VB.Label Label5
- BackStyle = 0 'Transparent
- ForeColor = &H00FF0000&
- Height = 255
- Left = 10800
- TabIndex = 8
- Top = 705
- Width = 375
- End
- Begin VB.Label Label3
- BackStyle = 0 'Transparent
- ForeColor = &H00FF0000&
- Height = 255
- Left = 6870
- TabIndex = 7
- Top = 705
- Width = 2235
- End
- Begin VB.Label Label2
- BackStyle = 0 'Transparent
- Caption = "生产日期:"
- Height = 255
- Left = 5970
- TabIndex = 6
- Top = 705
- Width = 975
- End
- Begin VB.Label Lab_TitleMess
- BackStyle = 0 'Transparent
- Caption = "物料名称:"
- Height = 225
- Index = 1
- Left = 2790
- TabIndex = 5
- Top = 705
- Width = 1215
- End
- Begin VB.Label label1
- BackStyle = 0 'Transparent
- ForeColor = &H00FF0000&
- Height = 225
- Index = 1
- Left = 3990
- TabIndex = 4
- Top = 705
- Width = 1695
- End
- Begin VB.Label label1
- BackStyle = 0 'Transparent
- ForeColor = &H00FF0000&
- Height = 225
- Index = 0
- Left = 1590
- TabIndex = 3
- Top = 705
- Width = 1095
- End
- Begin VB.Label Lab_TitleMess
- BackStyle = 0 'Transparent
- Caption = "物料编码:"
- Height = 225
- Index = 0
- Left = 390
- TabIndex = 2
- Top = 705
- Width = 1215
- End
- Begin VB.Label tsLabel
- AutoSize = -1 'True
- BackColor = &H80000018&
- BackStyle = 0 'Transparent
- Caption = "成品等级走势图"
- BeginProperty Font
- Name = "宋体"
- Size = 12
- Charset = 134
- Weight = 700
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- ForeColor = &H00000000&
- Height = 240
- Index = 4
- Left = 495
- TabIndex = 1
- Top = 150
- Width = 1785
- End
- End
- Begin VB.Timer Timer1
- Enabled = 0 'False
- Interval = 1
- Left = 7620
- Top = 90
- End
- Begin VSFlex8Ctl.VSFlexGrid CxbbGrid
- Height = 6885
- Left = 30
- TabIndex = 12
- Top = 1680
- Width = 11775
- _ExtentX = 20770
- _ExtentY = 12144
- Appearance = 1
- BorderStyle = 1
- Enabled = -1 'True
- BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
- Name = "宋体"
- Size = 9
- Charset = 134
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- MousePointer = 0
- BackColor = 16777215
- ForeColor = -2147483640
- BackColorFixed = 13826538
- ForeColorFixed = -2147483630
- BackColorSel = -2147483635
- ForeColorSel = -2147483634
- BackColorBkg = -2147483636
- BackColorAlternate= 16777215
- GridColor = -2147483633
- GridColorFixed = -2147483632
- TreeColor = -2147483632
- FloodColor = 192
- SheetBorder = -2147483642
- FocusRect = 1
- HighLight = 1
- AllowSelection = -1 'True
- AllowBigSelection= -1 'True
- AllowUserResizing= 0
- SelectionMode = 0
- GridLines = 1
- GridLinesFixed = 2
- GridLineWidth = 1
- Rows = 50
- Cols = 10
- FixedRows = 1
- FixedCols = 1
- RowHeightMin = 0
- RowHeightMax = 0
- ColWidthMin = 0
- ColWidthMax = 0
- ExtendLastCol = 0 'False
- FormatString = ""
- ScrollTrack = 0 'False
- ScrollBars = 3
- ScrollTips = 0 'False
- MergeCells = 0
- MergeCompare = 0
- AutoResize = -1 'True
- AutoSizeMode = 0
- AutoSearch = 0
- MultiTotals = -1 'True
- SubtotalPosition= 0
- OutlineBar = 0
- OutlineCol = 0
- Ellipsis = 0
- ExplorerBar = 0
- PicturesOver = 0 'False
- FillStyle = 0
- RightToLeft = 0 'False
- PictureType = 0
- TabBehavior = 0
- OwnerDraw = 0
- Editable = 0 'False
- ShowComboButton = -1 'True
- WordWrap = 0 'False
- TextStyle = 0
- TextStyleFixed = 0
- OleDragMode = 0
- OleDropMode = 0
- DataMode = 0
- VirtualData = -1 'True
- Begin MSComctlLib.ImageList ImageList2
- Left = 0
- Top = 0
- _ExtentX = 1005
- _ExtentY = 1005
- BackColor = -2147483643
- ImageWidth = 16
- ImageHeight = 16
- MaskColor = 12632256
- _Version = 393216
- BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
- NumListImages = 40
- BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":1FAC4
- Key = "sz"
- EndProperty
- BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":1FE5E
- Key = "dy"
- EndProperty
- BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":201F8
- Key = "yl"
- EndProperty
- BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":20592
- Key = "xg"
- EndProperty
- BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2092C
- Key = "zh"
- EndProperty
- BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":20CC6
- Key = "sh"
- EndProperty
- BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":21060
- Key = "bc"
- EndProperty
- BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":213FA
- Key = "fq"
- EndProperty
- BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":21794
- Key = "bz"
- EndProperty
- BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":21B2E
- Key = "tc"
- EndProperty
- BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":21EC8
- Key = "bcgs"
- EndProperty
- BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":22262
- Key = "mrlk"
- EndProperty
- BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":225FC
- Key = "xsxm"
- EndProperty
- BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":22996
- Key = "first"
- EndProperty
- BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":22D30
- Key = "prev"
- EndProperty
- BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":230CA
- Key = "next"
- EndProperty
- BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":23464
- Key = "last"
- EndProperty
- BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":237FE
- Key = "xx"
- EndProperty
- BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":23B98
- Key = "define"
- EndProperty
- BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":23F32
- Key = "exec"
- EndProperty
- BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":242CC
- Key = "xz"
- EndProperty
- BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":24666
- Key = "sc"
- EndProperty
- BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":24A00
- Key = "sx"
- EndProperty
- BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":24D9A
- Key = "cx"
- EndProperty
- BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":25134
- Key = "zd"
- EndProperty
- BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":254CE
- Key = "dz"
- EndProperty
- BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":25868
- Key = "ph"
- EndProperty
- BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":25C02
- Key = "fz"
- EndProperty
- BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":25F9C
- Key = "dw"
- EndProperty
- BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":26336
- Key = "hf"
- EndProperty
- BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":266D0
- Key = "pz"
- EndProperty
- BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":26A6A
- Key = "check"
- EndProperty
- BeginProperty ListImage33 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":26E04
- Key = "qs"
- EndProperty
- BeginProperty ListImage34 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2719E
- Key = "fullcheck"
- EndProperty
- BeginProperty ListImage35 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":27538
- Key = "qq"
- EndProperty
- BeginProperty ListImage36 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":278D2
- Key = "bcw"
- EndProperty
- BeginProperty ListImage37 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":27C6C
- Key = "ye"
- EndProperty
- BeginProperty ListImage38 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":28006
- Key = ""
- EndProperty
- BeginProperty ListImage39 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":283A0
- Key = "frist"
- EndProperty
- BeginProperty ListImage40 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2873A
- Key = "dj"
- EndProperty
- EndProperty
- End
- End
- Begin MSComctlLib.Toolbar SzToolbar
- Align = 1 'Align Top
- Height = 570
- Left = 0
- TabIndex = 13
- Top = 0
- Width = 11820
- _ExtentX = 20849
- _ExtentY = 1005
- ButtonWidth = 820
- ButtonHeight = 953
- AllowCustomize = 0 'False
- Appearance = 1
- Style = 1
- ImageList = "ImageList1"
- _Version = 393216
- BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
- NumButtons = 8
- BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "设置"
- Key = "ymsz"
- ImageKey = "sz"
- EndProperty
- BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "打印"
- Key = "dy"
- ImageKey = "dy"
- EndProperty
- BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "预览"
- Key = "yl"
- ImageKey = "yl"
- EndProperty
- BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Style = 3
- EndProperty
- BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "查询"
- Key = "cx"
- ImageKey = "cx"
- EndProperty
- BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Style = 3
- EndProperty
- BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "帮助"
- Key = "bz"
- ImageKey = "bz"
- EndProperty
- BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "退出"
- Key = "fh"
- ImageKey = "tc"
- EndProperty
- EndProperty
- BorderStyle = 1
- Begin MSComctlLib.ImageList ImageList1
- Left = 6990
- Top = 30
- _ExtentX = 1005
- _ExtentY = 1005
- BackColor = -2147483643
- ImageWidth = 16
- ImageHeight = 16
- MaskColor = 12632256
- _Version = 393216
- BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
- NumListImages = 33
- BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":28AD4
- Key = "sz"
- EndProperty
- BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":28E6E
- Key = "dy"
- EndProperty
- BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":29208
- Key = "yl"
- EndProperty
- BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":295A2
- Key = "xg"
- EndProperty
- BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2993C
- Key = "zh"
- EndProperty
- BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":29CD6
- Key = "sh"
- EndProperty
- BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2A070
- Key = "bc"
- EndProperty
- BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2A40A
- Key = "fq"
- EndProperty
- BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2A7A4
- Key = "bz"
- EndProperty
- BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2AB3E
- Key = "tc"
- EndProperty
- BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2AED8
- Key = "bcgs"
- EndProperty
- BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2B272
- Key = "mrlk"
- EndProperty
- BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2B60C
- Key = "xsxm"
- EndProperty
- BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2B9A6
- Key = "first"
- EndProperty
- BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2BD40
- Key = "prev"
- EndProperty
- BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2C0DA
- Key = "next"
- EndProperty
- BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2C474
- Key = "last"
- EndProperty
- BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2C80E
- Key = "xx"
- EndProperty
- BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2CBA8
- Key = "define"
- EndProperty
- BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2CF42
- Key = "exec"
- EndProperty
- BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2D2DC
- Key = "xz"
- EndProperty
- BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2D676
- Key = "sc"
- EndProperty
- BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2DA10
- Key = "sx"
- EndProperty
- BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2DDAA
- Key = "cx"
- EndProperty
- BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2E144
- Key = "zd"
- EndProperty
- BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2E4DE
- Key = "dz"
- EndProperty
- BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2E878
- Key = "ph"
- EndProperty
- BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2EC12
- Key = "fz"
- EndProperty
- BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2EFAC
- Key = "dw"
- EndProperty
- BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2F346
- Key = "hf"
- EndProperty
- BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2F6E0
- Key = "pz"
- EndProperty
- BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2FA7A
- Key = "check"
- EndProperty
- BeginProperty ListImage33 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "c成品检验管理_成品质量等级走势图.frx":2FE14
- Key = "txfx"
- EndProperty
- EndProperty
- End
- Begin MSComctlLib.Toolbar GsToolbar
- Height = 540
- Left = 10950
- TabIndex = 14
- Top = 0
- Width = 855
- _ExtentX = 1508
- _ExtentY = 953
- ButtonWidth = 1455
- ButtonHeight = 953
- Appearance = 1
- Style = 1
- ImageList = "ImageList1"
- DisabledImageList= "ImageList1"
- HotImageList = "ImageList1"
- _Version = 393216
- BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
- NumButtons = 4
- BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Object.Visible = 0 'False
- Caption = "保存格式"
- Key = "bcgs"
- ImageKey = "bcgs"
- EndProperty
- BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Object.Visible = 0 'False
- Caption = "默认列宽"
- Key = "hfmrgs"
- ImageKey = "mrlk"
- EndProperty
- BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Object.Visible = 0 'False
- Caption = "显示项目"
- Key = "xsxm"
- ImageKey = "mrlk"
- EndProperty
- BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "图形分析"
- Key = "txfx"
- ImageKey = "txfx"
- EndProperty
- EndProperty
- End
- End
- End
- Attribute VB_Name = "FrmProGraph_Zst"
- Attribute VB_GlobalNameSpace = False
- Attribute VB_Creatable = False
- Attribute VB_PredeclaredId = True
- Attribute VB_Exposed = False
- '**************************************************************************
- '* 模 块 名 称 :成品等级走势图
- '* 功 能 描 述 :
- '* 程序员姓名 :邹力
- '* 最后修改人 :张晶石
- '* 最后修改时间:2002/01/10
- '* 备 注:程序中所有依实际情况自定义部分均用[>> <<]括起
- '**************************************************************************
- Dim intcycle As Integer '分段数
- Dim resultY() As Single '优级品率
- Dim resultH() As Single '合格品率
- Dim Cycle() As String '分段数据
- Dim result() As Single '品级率
- Dim gradecode() As String '质量等级编码
- Dim gradename() As String '质量等级名称
- Dim intcount As Integer '检验项目数量
- Dim reptitle As String '图形输出标题
- Dim gradecount As Integer '质量等级个数
- Dim ReportTitle As String '报表主标题
- Dim Str_QueryCondi As String '用户录入查询条件
- Dim Rec_BillID As New ADODB.Recordset '用户查询单据ID动态集
- Dim strwlbh As String '物料编号
- Dim strName As String '物料名称
- Dim Daystart As String '起始日期
- Dim Dayend As String '结束日期
- Dim strcycle As String '周期
- '以下为固定使用变量
- Dim Dyymctbl As New DY_Dyymsz '打印页面窗体变量
- Dim GridCode As String '显示网格网格代码
- Dim GridInf() As Variant '整个网格设置信息
- Dim Tsxx As String '系统提示信息
- Dim Qslz As Long '网格隐藏(非操作显示)列数
- Dim Sjhgd As Double '网格数据行高度
- Dim Sfxshjwg As Boolean '是否显示合计网格
- Dim GridBoolean() As Boolean '网格列信息(布尔型)
- Dim GridStr() As String '网格列信息(字符型)
- Dim GridInt() As Integer '网格列信息(整型)
- Dim Szzls As Integer '数组总列数(网格列数-1)
- Private Sub Form_Resize() '根据窗体大小来调整网格,标题栏大小(Fixed)
- On Error Resume Next
- With CxbbGrid
- .Width = Me.Width - 160
- .Height = Me.Height - .Top - 400
- End With
- With Pic_Title
- .Width = Me.Width - 160
- End With
- GsToolbar.Left = Me.Width - GsToolbar.Width - 140
- End Sub
- Private Sub Form_Load() '窗体装入
- '调入打印页面设置窗体
- ReportTitle = "成品等级走势图"
- XtReportCode = "QC_ProGraphZst"
- Load Dyymctbl
- '调整标题栏及网格、格式工具条位置(Fixed)
- Pic_Title.Left = 40
- Pic_Title.Top = SzToolbar.Top + SzToolbar.Height - 10
- CxbbGrid.Left = Pic_Title.Left
- CxbbGrid.Top = Pic_Title.Top + Pic_Title.Height + 20
- '调 入 网 格(Fixed)
- GridCode = "QC_ProGraphZst"
- Call BzWgcsh(CxbbGrid, GridCode, GridInf(), GridBoolean(), GridInt(), GridStr())
- Qslz = GridInf(1)
- Sjhgd = GridInf(2)
- Sfxshjwg = GridInf(7)
- Szzls = CxbbGrid.Cols - 1
- End Sub
- Private Sub Form_Unload(Cancel As Integer) '窗体卸载
- '卸载条件窗体
- FrmProGraph_ZstQuery.UnloadCheck.Value = 1
- Unload FrmProGraph_ZstQuery
- '卸载打印页面设置窗体
- Unload Dyymctbl
- End Sub
- Private Sub CxbbGrid_BeforeMoveColumn(ByVal Col As Long, Position As Long) '网格列发生移动时自动交换网格索引信息
- Call FnBln_RefreshArray(Col, Position, GridStr(), GridInf())
- End Sub
- Private Sub GsToolbar_ButtonClick(ByVal Button As MSComctlLib.Button) '网格格式调整(Fixed)
- Select Case Button.Key
- Case "bcgs" '保存表格格式
- Call Bcwggs(CxbbGrid, GridCode, GridStr())
- Case "hfmrgs" '恢复默认格式
- Call Hfmrgs(CxbbGrid, GridCode, GridStr())
- Case "szxsxm" '设置显示项目
- Call Szxsxm(CxbbGrid, GridCode)
- Case "txfx" '图形分析报表
- If CxbbGrid.Rows = CxbbGrid.FixedRows Then
- Exit Sub
- End If
- XT_TxfxFrm.HelpContextID = 150400502
- Call Txfxbb(CxbbGrid, "QC_ProGraphZst")
- End Select
- End Sub
- Private Sub SzToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)
- Select Case Button.Key
- Case "ymsz" '页面设置
- Dyymctbl.Show 1
- Case "yl" '预 览
- Call bbyl(True)
- Case "dy" '打 印
- Call bbyl(False)
- Case "cx" '查 询
- FrmProGraph_ZstQuery.Show 1
- Case "bz" '帮 助
- Call F1bz
- Case "fh" '退 出
- Unload Me
- End Select
- End Sub
- Private Sub Timer1_Timer() '在窗体激活后调入查询程序
- Timer1.Enabled = False
- Xt_Wait.Show
- Xt_Wait.Refresh
- '加快显示速度
- CxbbGrid.Redraw = False
- '生成查询结果
- Call Sub_Query
- CxbbGrid.Redraw = True
- Xt_Wait.Hide
- End Sub
- Public Sub Sub_Query() '生成查询结果(Define)
- Dim Sqlstr, strSQL, strSQL1, strSQL2 As String
- Dim rec As ADODB.Recordset
- Dim rectemp1 As ADODB.Recordset
- Dim rectemp2 As ADODB.Recordset
- Dim ii As Integer
- Dim i As Integer
- Dim TiaoJian As String
- With FrmProGraph_ZstQuery
- If Trim(.LrText(0).Text & "") = "" Then
- Lab_TitleMess(0).Caption = "物料大类编码:"
- Lab_TitleMess(1).Caption = "物料大类名称:"
- strwlbh = Trim(.LrText(5).Tag & "")
- strName = Trim(.LrText(5).Text & "")
- Else
- Lab_TitleMess(0).Caption = "物料编码:"
- Lab_TitleMess(1).Caption = "物料名称:"
- strwlbh = Trim(.LrText(0).Text & "")
- strName = Trim(.LrText(1).Text & "")
- End If
- label1(0).Caption = strwlbh
- label1(1).Caption = strName
- Daystart = Format(Trim(.LrText(2).Text), "yyyy-mm-dd")
- Dayend = Format(Trim(.LrText(3).Text), "yyyy-mm-dd")
- intcycle = Val(.LrText(4).Text)
- strcycle = Trim(.Combo1.Text)
- Label3.Caption = Format(Daystart, "yyyy-mm-dd") & "~" & Format(Dayend, "yyyy-mm-dd")
- Label5.Caption = strcycle
- Label7.Caption = intcycle
- '查询连接串
- If Trim(.LrText(0).Text & "") = "" Then
- TiaoJian = " where msnumber = '" & strwlbh & "' "
- Else
- TiaoJian = " where mnumber = '" & strwlbh & "' "
- End If
- Sqlstr = "SELECT checksortcode FROM Qc_ProductMaterial " & TiaoJian
- Set rec = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
- If rec.RecordCount < 1 Then
- If Trim(.LrText(0).Text & "") = "" Then
- Tsxx = "请先设置该物料大类中物料的检验类别!"
- Else
- Tsxx = "请先设置该物料的检验类别!"
- End If
- Call Xtxxts(Tsxx, 0, 3)
- Exit Sub
- End If
- End With
- If Trim(FrmProGraph_ZstQuery.LrText(0).Text & "") = "" Then
- TiaoJian = " where msnumber = '" & strwlbh & "' and Checker<>'' "
- Else
- TiaoJian = " where mnumber = '" & strwlbh & "' and Checker<>'' "
- End If
- Sqlstr = "SELECT gradecode,gradename FROM QC_grade where checksortcode ='" & Trim(rec.Fields("checksortcode") & "") & "' order by gradecode"
- If rec.State Then rec.Close
- Set rec = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
- If rec.RecordCount < 1 Then
- Tsxx = "请先设置该物料的质量等级!"
- Call Xtxxts(Tsxx, 0, 3)
- Exit Sub
- End If
- gradecount = rec.RecordCount
- ReDim gradecode(gradecount) As String
- ReDim gradename(gradecount) As String
- ReDim result(gradecount, intcycle) As Single
- For i = 0 To rec.RecordCount - 1
- gradecode(i) = rec.Fields("gradecode")
- gradename(i) = rec.Fields("gradename")
- rec.MoveNext
- Next i
- ReDim resultY(intcycle) As Single
- ReDim resultH(intcycle) As Single
- ReDim Cycle(intcycle) As String
- CxbbGrid.Rows = 1
- '提取标题
- If Format(Daystart, "yyyy-mm") <> Format(Dayend, "yyyy-mm") Then
- reptitle = Format(Daystart, "yyyy-mm") + "-" + Format(Dayend, "yyyy-mm")
- Else
- reptitle = Format(Daystart, "yyyy-mm")
- End If
- reptitle = reptitle + Space(2) + label1(1).Caption
- '查询连接串
- '查询数据分布
- Dim intd() As Date
- ReDim intd(intcycle + 1) As Date
- intd(0) = Daystart
- For i = 1 To intcycle
- If strcycle = "周" Then
- intd(i) = DateAdd("ww", i, intd(0))
- Else
- intd(i) = DateAdd("m", i, intd(0))
- End If
- '总重
- strSQL = "SELECT SUM(Quantity) AS eprweight FROM (SELECT a.*, b.MSNumber AS msnumber FROM Qc_ProductCheckMain a LEFT OUTER JOIN " & _
- "Qc_ProductMaterial b ON a.MNumber = b.MNumber) c " & TiaoJian & " and PurReciptDate>='" & intd(i - 1) & "' and PurReciptDate<'" & intd(i) & "' "
- Set rectemp1 = Cw_DataEnvi.DataConnect.Execute(strSQL)
- rectemp1.MoveFirst
- If IsNull(rectemp1.Fields(0)) Then
- sind1 = 0
- Else
- sind1 = rectemp1.Fields(0)
- End If
- '********************************************************************************
- For ii = 0 To gradecount - 2
- If ii < gradecount - 2 Then
- strSQL1 = "SELECT sum(Quantity) as eprweight1 FROM (SELECT a.*, b.MSNumber AS msnumber FROM Qc_ProductCheckMain a LEFT OUTER JOIN " & _
- "Qc_ProductMaterial b ON a.MNumber = b.MNumber) c " & TiaoJian & " and gradecode='" & gradecode(ii) & "' and PurReciptDate>='" & intd(i - 1) & "' and PurReciptDate<'" & intd(i) & "' "
- Else
- strSQL1 = "SELECT sum(Quantity) as eprweight1 FROM (SELECT a.*, b.MSNumber AS msnumber FROM Qc_ProductCheckMain a LEFT OUTER JOIN " & _
- "Qc_ProductMaterial b ON a.MNumber = b.MNumber) c " & TiaoJian & " and gradecode<>'" & gradecode(ii + 1) & "' and PurReciptDate>='" & intd(i - 1) & "' and PurReciptDate<'" & intd(i) & "' "
- End If
- Set rectemp1 = Cw_DataEnvi.DataConnect.Execute(strSQL1)
- If IsNull(rectemp1.Fields(0)) Then
- sind2 = 0
- Else
- sind2 = rectemp1.Fields(0)
- End If
- If sind1 = 0 Then
- result(ii, i - 1) = 0
- Else
- result(ii, i - 1) = sind2 / sind1
- End If
- If ii <> 0 And ii <> gradecount - 2 Then
- result(ii, i - 1) = result(ii, i - 1) + result(ii - 1, i - 1)
- End If
- Next ii
- '*********************************************
- '分段数据
- Cycle(i - 1) = Format(Str(intd(i - 1)), "yyyy-mm-dd")
- Next i
- CxbbGrid.FixedRows = 1
- CxbbGrid.Clear , flexClearData
- CxbbGrid.Rows = intcycle + CxbbGrid.FixedRows
- Jsqte = CxbbGrid.FixedRows
- Call Jltcwg
- For i = Jsqte To CxbbGrid.Rows - 1
- CxbbGrid.RowHeight(Jsqte) = Sjhgd
- Next i
- End Sub
- Private Sub Jltcwg() '记录内容填充网格
- '填充表头
- With CxbbGrid
- .Cols = gradecount
- .TextMatrix(0, 0) = "生产日期"
- For Jsqte = 1 To .Cols - 1
- .TextMatrix(0, Jsqte) = Trim(gradename(Jsqte - 1) & "") & "%"
- .FixedAlignment(Jsqte) = 4
- .ColFormat(Jsqte) = "#,##0." + String(Xtslxsws, "0")
- .ColAlignment(Jsqte) = 6
- .ColWidth(Jsqte) = 2000
- Next Jsqte
- End With
- '填充时间数据
- For i = 0 To intcycle - 1
- CxbbGrid.TextMatrix(i + 1, 0) = Cycle(i)
- Next
- '填充品率数据
- For ii = 0 To gradecount - 2
- For i = 0 To intcycle - 1
- CxbbGrid.TextMatrix(i + 1, ii + 1) = result(ii, i) * 100
- Next i
- Next ii
- End Sub
- Private Sub bbyl(bbylte As Boolean) '报表打印预览
- Dim Bbzbt$, Bbxbt() As String, bbxbtzzxs() As Integer, Bbxbtgs As Integer
- Dim Bbbwh() As String, Bbbwhzzxs() As Integer, Bbbwhgs As Integer
- Bbxbtgs = 3 '报 表 小 标 题 行 数
- Bbbwhgs = 0 '报 表 表 尾 行 数
- ReDim Bbxbt(1 To Bbxbtgs)
- ReDim bbxbtzzxs(1 To Bbxbtgs)
- If Bbbwhgs <> 0 Then
- ReDim Bbbwh(1 To Bbbwhgs)
- ReDim Bbbwhzzxs(1 To Bbbwhgs)
- End If
- Bbzbt = "成品等级走势图"
- Bbxbt(2) = Space(4) + Fun_FormatOutPut(Trim(Lab_TitleMess(0).Caption & "") + Trim(label1(0).Caption & ""), 20) + Fun_FormatOutPut(Trim(Lab_TitleMess(1).Caption & "") + Trim(label1(1).Caption & ""), 30)
- Bbxbt(2) = Bbxbt(2) + Fun_FormatOutPut("生产日期: " + Trim(Label3.Caption & ""), 20)
- bbxbtzzxs(1) = 0 '报表行组织形式(0-居左 1-居中 2-居右)
- Call Scyxsjb(CxbbGrid) '生成报表数据
- Call Scdybb(Dyymctbl, Bbzbt, Bbxbt(), bbxbtzzxs(), Bbxbtgs, Bbbwh(), Bbbwhzzxs(), Bbbwhgs, bbylte)
- If Not bbylte Then
- Unload DY_Tybbyldy
- End If
- End Sub