📄 frmdlpurchase.frm
字号:
VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Object = "{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0"; "FM20.DLL"
Object = "{9C4B12C2-D5CE-11D1-9ABC-444553540000}#1.0#0"; "GATLCTRL.DLL"
Begin VB.Form frmdlPurchase
Caption = "受托结算"
ClientHeight = 4455
ClientLeft = 1260
ClientTop = 1350
ClientWidth = 8205
LinkTopic = "Form1"
ScaleHeight = 4455
ScaleWidth = 8205
Begin GATLCTRLLibCtl.CalEdit ytext
Height = 255
Left = 6960
OleObjectBlob = "frmdlpurchase.frx":0000
TabIndex = 13
Top = 3060
Visible = 0 'False
Width = 855
End
Begin VB.CommandButton Cmdall
Caption = "全部取消"
Height = 350
Index = 1
Left = 6840
Picture = "frmdlpurchase.frx":0081
TabIndex = 12
Top = 2460
Width = 1215
End
Begin VB.CommandButton Cmdall
Caption = "全部结算"
Height = 350
Index = 0
Left = 6840
Picture = "frmdlpurchase.frx":17DC
TabIndex = 11
Top = 2100
Width = 1215
End
Begin VB.CommandButton cmdok
Enabled = 0 'False
Height = 350
Index = 4
Left = 7140
Style = 1 'Graphical
TabIndex = 5
Top = 3990
UseMaskColor = -1 'True
Visible = 0 'False
Width = 1215
End
Begin VB.CommandButton cmdok
Caption = "筛选"
Height = 350
Index = 2
Left = 6840
TabIndex = 3
Top = 1245
Width = 1215
End
Begin VB.CommandButton cmdok
Caption = "栏目设置"
Height = 350
Index = 3
Left = 6870
TabIndex = 4
Top = 1620
Width = 1215
End
Begin VB.CommandButton cmdok
Height = 350
Index = 5
Left = 6840
Style = 1 'Graphical
TabIndex = 1
Top = 360
UseMaskColor = -1 'True
Width = 1215
End
Begin VB.CommandButton cmdok
Height = 350
Index = 1
Left = 6840
Style = 1 'Graphical
TabIndex = 2
Top = 720
UseMaskColor = -1 'True
Width = 1215
End
Begin MSFlexGridLib.MSFlexGrid msgGrid
Bindings = "frmdlpurchase.frx":2F37
Height = 3495
Left = 60
TabIndex = 0
Top = 360
Width = 6615
_ExtentX = 11668
_ExtentY = 6165
_Version = 65541
Rows = 150
Cols = 75
BackColor = 16777215
End
Begin VB.Data data1
Caption = "Data1"
Connect = "Access"
DatabaseName = ""
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 345
Left = 0
Options = 0
ReadOnly = 0 'False
RecordsetType = 2 'Snapshot
RecordSource = ""
Top = 3000
Visible = 0 'False
Width = 2655
End
Begin MSForms.Label Lbbz
Height = 255
Index = 1
Left = 5700
TabIndex = 14
Top = 120
Width = 915
Size = "1614;450"
BorderColor = -2147483639
FontName = "宋体"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
End
Begin VB.Label hLb
BackColor = &H80000014&
Caption = "0"
Height = 255
Index = 0
Left = 480
TabIndex = 10
Top = 3960
Width = 855
End
Begin VB.Label hLb
BackColor = &H80000014&
Caption = "0"
Height = 255
Index = 1
Left = 1380
TabIndex = 9
Top = 3930
Width = 855
End
Begin MSForms.Label lbdw
Height = 255
Left = 600
TabIndex = 8
Top = 120
Width = 4305
Size = "7594;450"
FontName = "宋体"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
End
Begin MSForms.Label Lbbz
Height = 255
Index = 0
Left = 5220
TabIndex = 7
Top = 120
Width = 615
Caption = "币种："
Size = "1085;450"
FontName = "宋体"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
End
Begin MSForms.Label Label1
Height = 255
Index = 0
Left = 78
TabIndex = 6
Top = 120
Width = 615
Caption = "单位："
Size = "1085;450"
FontName = "宋体"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
End
Begin VB.Menu menuchk
Caption = ""
Visible = 0 'False
Begin VB.Menu chklist1
Caption = "完全结算"
End
Begin VB.Menu menbar1
Caption = "-"
End
Begin VB.Menu chklist2
Caption = "完全取消"
End
End
End
Attribute VB_Name = "frmdlPurchase"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'标题：受托结算
'作者：邓普德
'日期：1998.07.02
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Option Explicit
Private CustomerID As Long '单位ID
Private CurrencyID As Long '币种ID
Private DetailID As Long 'DetailID为单据业务ID
Private WithEvents mclsGrid As NewGrid '声明类模块
Attribute mclsGrid.VB_VarHelpID = -1
Private mlhls As rdoResultset '声明数据表类型
Private hldate As Date '声明系统期间日期
Private strWorkID As String '在筛选或栏目设置时需保留的ID串
Private ytextRow As Integer '记录当前FLEXGRID单元的行号
Private ytextCol As Integer '记录当前FLEXGRID单元的列号
Private Customernm As String '单位名称
Private Currencynm As String '币种名称
Private Const intViewID = 73 '视图ID号
Private Const intfixl = 45 '列偏移行数
Private inthl As Integer '币种保留小数点位数
Private Const msgcaption = "受托结算" 'SHOWMSG窗体的标题名称
Private Const intFormHeight = 4018 '当前窗体的最小高度
Private Const intFormWidth = 7368 '当前窗体的最小宽度
Private mblnFormNoRezise As Boolean '窗体是否允许Resize
Private isinit As Boolean '窗体金额栏是否需要汇总
Private mfrmToFormname As Object '输出窗体的名称
Private blnIsCancel As Boolean '按钮退出吗
Private bsdate As Base 'Base声明
'响应完全结算菜单
Private Sub chklist1_Click()
Cmdall_Click (0)
End Sub
'响应完全取消菜单
Private Sub chklist2_Click()
Cmdall_Click (1)
End Sub
'响应全部结算动作
Private Sub BalanceAll(Index As Integer)
Dim intCount As Integer, k As Integer, i As Integer, p As Integer
Dim xx As Double
i = intfixl
k = intfixl
'本循环找出本次收款及本次折扣所在的列
While (msgGrid.TextMatrix(0, i) <> "结算金额")
i = i + 1
Wend
While (msgGrid.TextMatrix(0, k) <> "结算数量")
k = k + 1
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -