frmfp.frm

这是一个基于金蝶K/3的磅秤插件源代码。安装本差价需要金蝶K/310.0以上的版本。本插件是客户端程序。在车辆过磅时自动产生金蝶K/3的出库单。

VERSION 5.00
Object = "{F856EC8B-F03C-4515-BDC6-64CBD617566A}#6.0#0"; "fpSpr60.ocx"
Begin VB.Form FrmFp 
   Caption         =   "发票选择"
   ClientHeight    =   5625
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   8220
   Icon            =   "FrmFp.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   ScaleHeight     =   5625
   ScaleWidth      =   8220
   StartUpPosition =   1  '所有者中心
   Begin VB.CommandButton CmdGL2 
      Caption         =   "过虑"
      Height          =   315
      Left            =   7080
      TabIndex        =   7
      Top             =   180
      Width           =   735
   End
   Begin VB.CommandButton CmdGL1 
      Caption         =   "过虑"
      Height          =   315
      Left            =   2880
      TabIndex        =   6
      Top             =   180
      Width           =   735
   End
   Begin VB.TextBox TxtKhMc 
      Height          =   300
      Left            =   4740
      TabIndex        =   5
      Top             =   180
      Width           =   2235
   End
   Begin VB.TextBox TxtFpH 
      Height          =   300
      Left            =   1200
      TabIndex        =   3
      Top             =   180
      Width           =   1635
   End
   Begin VB.CommandButton CmdClose 
      Caption         =   "返回"
      Height          =   375
      Left            =   6540
      TabIndex        =   1
      Top             =   5040
      Width           =   1455
   End
   Begin VB.CommandButton CmdQd 
      Caption         =   "选定"
      Height          =   375
      Left            =   4440
      TabIndex        =   0
      Top             =   5040
      Width           =   1515
   End
   Begin FPSpreadADO.fpSpread fpSpd 
      Height          =   4275
      Left            =   240
      TabIndex        =   8
      Top             =   600
      Width           =   7695
      _Version        =   393216
      _ExtentX        =   13573
      _ExtentY        =   7541
      _StockProps     =   64
      AllowUserFormulas=   -1  'True
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "MS Sans Serif"
         Size            =   8.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      MaxCols         =   7
      MaxRows         =   1
      OperationMode   =   5
      SelectBlockOptions=   0
      SpreadDesigner  =   "FrmFp.frx":030A
   End
   Begin VB.Label Label2 
      AutoSize        =   -1  'True
      Caption         =   "客户名称："
      Height          =   180
      Left            =   3780
      TabIndex        =   4
      Top             =   240
      Width           =   900
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      Caption         =   "发票号码："
      Height          =   180
      Left            =   240
      TabIndex        =   2
      Top             =   240
      Width           =   900
   End
End
Attribute VB_Name = "FrmFp"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public rsFp As ADODB.Recordset  '发票记录

Private Sub GetData()
On Error GoTo HERROR
    Dim I, J As Integer
    
    fpSpd.ClearRange 1, 1, fpSpd.MaxCols, fpSpd.MaxRows, False
    
    fpSpd.MaxRows = 1
    I = 0
    Do While Not rsFp.EOF
        I = I + 1
        If I = fpSpd.MaxRows + 1 Then
          fpSpd.MaxRows = fpSpd.MaxRows + 1
        End If
        fpSpd.Row = I
        fpSpd.Col = 1
        fpSpd.Text = NS(rsFp.Fields("fbillno").Value)
        fpSpd.Col = 2
        fpSpd.Text = NS(rsFp.Fields("fnumber").Value)
        fpSpd.Col = 3
        fpSpd.Text = NS(rsFp.Fields("fname").Value)
        fpSpd.Col = 4
        fpSpd.Text = NI(rsFp.Fields("fpiaozhong").Value)
        fpSpd.Col = 5
        fpSpd.Text = NI(rsFp.Fields("fdaizhong").Value)
        fpSpd.Col = 6
        fpSpd.Text = NI(rsFp.Fields("fpiaozhong").Value) + NI(rsFp.Fields("fdaizhong").Value)
        fpSpd.Col = 7
        fpSpd.Text = NI(rsFp.Fields("finterid").Value)
        rsFp.MoveNext
    Loop
    Exit Sub
    'fpSpd.SetActiveCell
    
HERROR:
    MsgBox Err.Description, vbCritical
End Sub

Private Sub CmdClose_Click()
    Unload Me
End Sub

Private Sub CmdGL_Click()
End Sub

Private Sub CmdGL1_Click()
    If Trim(TxtFpH.Text) = "" Then
        rsFp.Filter = ""
    Else
        rsFp.Filter = "fbillno like '%" & Trim(TxtFpH.Text) & "%'"
    End If
    GetData
End Sub

Private Sub CmdGL2_Click()
    If Trim(TxtKhMc.Text) = "" Then
        rsFp.Filter = ""
    Else
        rsFp.Filter = "fname like '%" & Trim(TxtKhMc.Text) & "%'"
    End If
    GetData
End Sub

Private Sub CmdQd_Click()
On Error GoTo HERROR
    Dim I As Integer
    Dim Index As Integer
    Dim ret As Long
    ret = 0
    Index = 0
    
    If fpSpd.SelectionCount = 0 Then Exit Sub
    ReDim arrayFp(fpSpd.SelectionCount - 1, 6) As String
    
    Do
        ret = fpSpd.GetMultiSelItem(ret)
        If ret = -1 Then
            Exit Do
        End If
        For I = 0 To fpSpd.MaxCols - 1
            fpSpd.Row = ret
            fpSpd.Col = I + 1
            arrayFp(Index, I) = fpSpd.Text
        Next I
        Index = Index + 1
    Loop
    Unload Me
    Exit Sub
HERROR:
    MsgBox Err.Description, vbCritical
End Sub

Private Sub Form_Load()
    ReDim arrayFp(1, 1) As String
    GetData
End Sub

Private Sub fpSpd_DblClick(ByVal Col As Long, ByVal Row As Long)
    CmdQd_Click
End Sub