frmtest.frm

金算盘软件代码

VERSION 5.00
Begin VB.Form frmTest 
   Caption         =   "测试窗体"
   ClientHeight    =   3255
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   5310
   LinkTopic       =   "Form1"
   MDIChild        =   -1  'True
   ScaleHeight     =   3255
   ScaleWidth      =   5310
   Begin VB.CommandButton Command3 
      Caption         =   "Command3"
      Height          =   285
      Left            =   3360
      TabIndex        =   4
      Top             =   2400
      Width           =   1425
   End
   Begin VB.CommandButton Command2 
      Caption         =   "Command2"
      Height          =   285
      Left            =   1800
      TabIndex        =   3
      Top             =   2400
      Width           =   1425
   End
   Begin Account.ReceiptList rplTry2 
      Height          =   345
      Left            =   840
      TabIndex        =   2
      Top             =   1170
      Width           =   2235
      _extentx        =   3942
      _extenty        =   609
      backcolor       =   16777215
   End
   Begin VB.CommandButton Command1 
      Caption         =   "Command1"
      Height          =   285
      Left            =   240
      TabIndex        =   1
      Top             =   2400
      Width           =   1425
   End
   Begin Account.ReceiptList rplTry 
      Height          =   345
      Left            =   870
      TabIndex        =   0
      Top             =   300
      Width           =   2115
      _extentx        =   3731
      _extenty        =   609
      backcolor       =   16777215
   End
End
Attribute VB_Name = "frmTest"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private WithEvents mclsMainControl As MainControl               '主控对象
Attribute mclsMainControl.VB_VarHelpID = -1


Private Sub Command1_Click()
   Dim strSql As String
     rplTry.TotalCols = 1
     rplTry.TotalCol(1) = 4
     strSql = "Select VoucherDetail.lngVoucherDetailID,Voucher.intVoucherNo as [凭证号],Account.strAccountCode + ' ' + Account.strAccountName as [科目],VoucherDetail.dblAmount as [金额]" & _
            " From Voucher,VoucherDetail,Account Where Voucher.lngVoucherId=VoucherDetail.lngVoucherId And VoucherDetail.lngAccountId=Account.lngAccountId And intVoucherNo=29"
     Set rplTry.RstForGrid = gclsBase.BaseDB.OpenRecordset(strSql, dbOpenSnapshot)
     rplTry.SubIdCol = 1
     rplTry.ShowCombox = False
     rplTry.TextCols = 3
     rplTry.TextCol(1) = 2
     rplTry.TextCol(2) = 3
     rplTry.TextCol(3) = 4


     rplTry2.TotalCols = 2
     rplTry2.TotalCol(1) = 4
     rplTry2.TotalCol(2) = 5
     strSql = "Select VoucherDetail.lngVoucherDetailID,Voucher.intVoucherNo as [凭证号],Account.strAccountCode + ' ' + Account.strAccountName as [科目],VoucherDetail.dblAmount as [金额],VoucherDetail.dblAmount as [金额2]" & _
            " From Voucher,VoucherDetail,Account Where Voucher.lngVoucherId=VoucherDetail.lngVoucherId And VoucherDetail.lngAccountId=Account.lngAccountId"
     Set rplTry2.RstForGrid = gclsBase.BaseDB.OpenRecordset(strSql, dbOpenSnapshot)
     rplTry2.SubIdCol = 1
     rplTry2.ShowCombox = False
     rplTry2.TextCols = 1
     rplTry2.TextCol(1) = 3
'     rplTry2.TextCol(2) = 3
'     rplTry2.TextCol(3) = 4

End Sub

Private Sub Command2_Click()
    rplTry2.SeekId 6
End Sub

Private Sub Command3_Click()
    rplTry2.SeekText "522"
End Sub

Private Sub Form_Load()
    Set mclsMainControl = gclsSys.MainControls.Add(Me)               '加入主控
End Sub

Private Sub Form_Unload(Cancel As Integer)
    gclsSys.MainControls.Remove Me
End Sub