📄 frmproductionfollow.frm
字号:
VERSION 5.00
Object = "{4932CEF1-2CAA-11D2-A165-0060081C43D9}#2.0#0"; "Actbar2.OCX"
Object = "{0ECD9B60-23AA-11D0-B351-00A0C9055D8E}#6.0#0"; "MSHFLXGD.OCX"
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form frmProductionFollow
Caption = "客戶跟貨表"
ClientHeight = 9075
ClientLeft = 60
ClientTop = 345
ClientWidth = 15150
LinkTopic = "Form1"
MDIChild = -1 'True
ScaleHeight = 9075
ScaleWidth = 15150
Begin ActiveBar2LibraryCtl.ActiveBar2 ActiveBar21
Height = 9075
Left = 0
TabIndex = 0
Top = 0
Width = 15150
_LayoutVersion = 1
_ExtentX = 26723
_ExtentY = 16007
_DataPath = ""
Bands = "frmProductionFollow.frx":0000
Begin VB.Frame Frame1
Height = 8475
Left = 60
TabIndex = 1
Top = 540
Width = 15015
Begin VB.PictureBox fraFind
Appearance = 0 'Flat
BackColor = &H80000005&
ForeColor = &H80000008&
Height = 2775
Left = 120
ScaleHeight = 2745
ScaleWidth = 9465
TabIndex = 3
Top = 240
Visible = 0 'False
Width = 9495
Begin VB.TextBox txtCustomerName
BackColor = &H00C0FFC0&
Height = 315
Left = 6660
TabIndex = 27
Top = 180
Width = 1935
End
Begin VB.TextBox txtCustomerNo
Height = 315
Left = 2160
TabIndex = 26
Top = 180
Width = 1995
End
Begin VB.CommandButton CmdCustomer
Caption = "..."
Height = 255
Left = 4320
TabIndex = 25
Top = 180
Width = 495
End
Begin VB.ComboBox txtLayoutColor
BackColor = &H00C0FFC0&
Height = 315
Left = 6660
TabIndex = 24
Top = 660
Width = 1935
End
Begin VB.ComboBox txtContractNo
Height = 315
Left = 2160
TabIndex = 23
Top = 660
Width = 1995
End
Begin VB.CheckBox chkPatternDate
BackColor = &H80000005&
Caption = "Check1"
Height = 255
Left = 4320
TabIndex = 18
Top = 1620
Width = 195
End
Begin VB.CommandButton cmdFindAll
Caption = "全部 &A"
Height = 315
Left = 3540
TabIndex = 7
Top = 2160
Width = 855
End
Begin VB.CommandButton cmdFind
Caption = "查询 &F"
Height = 315
Left = 5220
TabIndex = 6
Top = 2160
Width = 855
End
Begin VB.CommandButton cmdCancel
Caption = "取消 &C"
Height = 315
Left = 6720
TabIndex = 5
Top = 2160
Width = 855
End
Begin VB.CheckBox chkFounddate
BackColor = &H80000005&
Caption = "Check1"
Height = 255
Left = 4320
TabIndex = 4
Top = 1140
Width = 195
End
Begin MSComCtl2.DTPicker EndFounddate
Height = 315
Left = 6660
TabIndex = 8
Top = 1140
Width = 1935
_ExtentX = 3413
_ExtentY = 556
_Version = 393216
Format = 52363265
CurrentDate = 39588
End
Begin MSComCtl2.DTPicker Founddate
Height = 315
Left = 2160
TabIndex = 9
Top = 1140
Width = 1995
_ExtentX = 3519
_ExtentY = 556
_Version = 393216
Format = 52363265
CurrentDate = 39587
End
Begin MSComCtl2.DTPicker endPatternDate
Height = 315
Left = 6660
TabIndex = 19
Top = 1620
Width = 1935
_ExtentX = 3413
_ExtentY = 556
_Version = 393216
Format = 52363265
CurrentDate = 39588
End
Begin MSComCtl2.DTPicker PatternDate
Height = 315
Left = 2160
TabIndex = 20
Top = 1620
Width = 1995
_ExtentX = 3519
_ExtentY = 556
_Version = 393216
Format = 52363265
CurrentDate = 39587
End
Begin VB.Label Label2
BackColor = &H80000005&
Caption = "出辦日期"
Height = 315
Left = 1020
TabIndex = 22
Top = 1620
Width = 915
End
Begin VB.Label Label1
BackColor = &H80000005&
Caption = "至"
Height = 255
Left = 5640
TabIndex = 21
Top = 1620
Width = 255
End
Begin VB.Label Label15
BackColor = &H00C0FFC0&
Height = 195
Left = 1440
TabIndex = 17
Top = 2220
Width = 375
End
Begin VB.Label Label12
BackColor = &H00FFFFFF&
Caption = "模糊查询项"
Height = 255
Left = 2100
TabIndex = 16
Top = 2220
Width = 915
End
Begin VB.Image Image1
Height = 480
Left = 360
Picture = "frmProductionFollow.frx":3A78
Top = 480
Width = 480
End
Begin VB.Label Label11
BackColor = &H80000005&
Caption = "合約編號"
Height = 255
Left = 1020
TabIndex = 15
Top = 660
Width = 1035
End
Begin VB.Label Label3
BackColor = &H80000005&
Caption = "客戶編號"
Height = 255
Index = 4
Left = 1020
TabIndex = 14
Top = 240
Width = 1035
End
Begin VB.Label Label4
BackColor = &H80000005&
Caption = "出貨日期"
Height = 315
Left = 1020
TabIndex = 13
Top = 1140
Width = 915
End
Begin VB.Label Label5
BackColor = &H80000005&
Caption = "客戶名稱"
Height = 315
Left = 5580
TabIndex = 12
Top = 240
Width = 915
End
Begin VB.Label Label6
BackColor = &H80000005&
Caption = "花型顏色"
Height = 255
Left = 5580
TabIndex = 11
Top = 660
Width = 915
End
Begin VB.Label Label13
BackColor = &H80000005&
Caption = "至"
Height = 255
Left = 5640
TabIndex = 10
Top = 1200
Width = 255
End
End
Begin MSHierarchicalFlexGridLib.MSHFlexGrid MSHF1
Height = 8115
Left = 120
TabIndex = 2
Top = 240
Width = 14775
_ExtentX = 26061
_ExtentY = 14314
_Version = 393216
AllowBigSelection= 0 'False
SelectionMode = 1
AllowUserResizing= 1
_NumberOfBands = 1
_Band(0).Cols = 2
End
End
End
End
Attribute VB_Name = "frmProductionFollow"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim lngrow As Long
Dim flag As Boolean
Private Sub ActiveBar21_ToolClick(ByVal Tool As ActiveBar2LibraryCtl.Tool)
Select Case Tool.Name
Case "cmdCancel":
Unload Me
Case "cmdFind"
fraFind.Visible = True
Case "cmdRefurbish":
FillMshf1 ("select * from tBusinessContract a,(select CustomerNo,CustomerName,email,tel,address,fax from tCustomer) c ,(select ContractNo,ShipmentsPatternNo,FabricNo,FabricName,Composition,LayoutColor,InvoiceQuantity,InvoicePrice,InvoiceNo,orderNo from tBusinessContractSub) b left join(select PatternNo,Founddate as FounddatePattern from tShipmentsPattern) d on (b.ShipmentsPatternNo=d.PatternNo) left join (select InvoiceNo,Founddate as FounddateInvoice from tShipmentsInvoice)e on (b.InvoiceNo=e.InvoiceNo) where a.ContractNo=b.ContractNo and a.customerNo=c.CustomerNo order by a.CustomerNo")
' Case "cmdPrint":
' Select Case ActiveBar21.Bands("toolbar").Tools.item("cmdSelect").CBListIndex
' Case 0:
' flag = True
' Call printProductionFollow
' Case 1:
' flag = False
' Call printProductionFollowA
' Case Else:
' flag = True
' Call printProductionFollow
' End Select
End Select
End Sub
Private Sub ActiveBar21_ComboSelChange(ByVal Tool As ActiveBar2LibraryCtl.Tool)
If Tool.CBListIndex = 0 Then
flag = False
FillMshf1 ("select * from vProductionFollow")
Else
flag = True
FillMshf1 ("select * from vProductionFollow")
End If
End Sub
Private Sub printProductionFollow()
' Dim tempValue1, tempValue2 As Integer
' Dim i, iRows As Integer
' Dim rs As ADODB.Recordset
' Set rs = New ADODB.Recordset
' With rs
' .LockType = adLockOptimistic
' .CursorType = adOpenDynamic
' End With
' rs.Fields.Append "CustomerNo", adVarChar, 20
' rs.Fields.Append "CustomerName", adVarChar, 20
' rs.Fields.Append "Composition", adVarChar, 50
' rs.Fields.Append "Width", adVarChar, 20
' rs.Fields.Append "tel", adVarChar, 20
' rs.Fields.Append "Quantity", adVarChar, 20
' rs.Fields.Append "fax", adVarChar, 20
' rs.Fields.Append "layoutColor", adVarChar, 20
' rs.Fields.Append "Founddate", adVarChar, 20
' rs.Fields.Append "FounddatePattern", adVarChar, 20
' rs.Fields.Append "email", adVarChar, 20
' rs.Fields.Append "price", adVarChar, 20
' rs.Fields.Append "FabricName", adVarChar, 20
' rs.Fields.Append "Address", adVarChar, 100
' rs.Open
' With Me.MSHF1
' iRows = .Rows - 2
' For i = 1 To iRows + 1
' rs.AddNew
' rs.Fields!CustomerNo = .TextMatrix(i, 0)
' rs.Fields!CustomerName = .TextMatrix(i, 1)
' rs.Fields!Composition = .TextMatrix(i, 5)
' rs.Fields!Width = .TextMatrix(i, 6)
' rs.Fields!Tel = .TextMatrix(i, 13)
' rs.Fields!Quantity = .TextMatrix(i, 11)
' rs.Fields!Fax = .TextMatrix(i, 14)
' rs.Fields!LayoutColor = .TextMatrix(i, 3)
' rs.Fields!Founddate = .TextMatrix(i, 10)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -