VB开发的ERP系统

VERSION 5.00
Object = "{D76D7128-4A96-11D3-BD95-D296DC2DD072}#1.0#0"; "VSOCX7.OCX"
Begin VB.Form AutoTran_NoSaveList 
   Caption         =   "未保存的转帐凭证列表"
   ClientHeight    =   2505
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   3900
   Icon            =   "自动转帐凭证_未保存凭证列表.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2505
   ScaleWidth      =   3900
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton cmd_Exit 
      Appearance      =   0  'Flat
      Caption         =   "退出(&E)"
      Height          =   300
      Left            =   2790
      TabIndex        =   0
      Top             =   2130
      Width           =   1005
   End
   Begin VSFlex8Ctl.VSFlexGrid vsflex1 
      Height          =   1890
      Left            =   120
      TabIndex        =   1
      Top             =   150
      Width           =   3680
      _ExtentX        =   6491
      _ExtentY        =   3334
      Appearance      =   0
      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       =   -2147483643
      ForeColor       =   0
      BackColorFixed  =   -2147483633
      ForeColorFixed  =   -2147483630
      BackColorSel    =   16711680
      ForeColorSel    =   -2147483639
      BackColorBkg    =   8421504
      BackColorAlternate=   -2147483643
      GridColor       =   -2147483633
      GridColorFixed  =   -2147483632
      TreeColor       =   -2147483630
      FloodColor      =   0
      SheetBorder     =   -2147483630
      FocusRect       =   1
      HighLight       =   1
      AllowSelection  =   0   'False
      AllowBigSelection=   0   'False
      AllowUserResizing=   1
      SelectionMode   =   0
      GridLines       =   1
      GridLinesFixed  =   2
      GridLineWidth   =   1
      Rows            =   8
      Cols            =   3
      FixedRows       =   1
      FixedCols       =   0
      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=   1
      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
   End
End
Attribute VB_Name = "AutoTran_NoSaveList"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'*********************************************************************************************************
'*    模 块 名 称 :未存盘转帐凭证列表
'*    功 能 描 述 :本次转帐未保存的凭证
'*    程序员姓名  : 姜冬梅
'*    最后修改人  : 姜冬梅
'*    开始设计时间：
'*    最后修改时间:2001/4/29
'*    备        注:程序中所有依实际情况自定义部分均用[>>  <<]括起
'*
'*    1.每次调入外部功能窗体，均要加锁ChangeLock=True,窗体关闭后解锁ChangeLock=false
'*
'*
'*********************************************************************************************************

Dim jsq As Long         '临时计数器
Dim SjhHeight As Long   '数据行高度

Private Sub cmd_exit_Click()
    Unload Me
End Sub

Private Sub Form_Load()
    Me.Left = (Screen.Width - Me.Width) / 2
    Me.Top = (Screen.Height - Me.Height) / 2
    With vsflex1
        .Rows = 7
        .Cols = 3
        .ScrollBars = flexScrollBarVertical
        .TextMatrix(0, 0) = "凭证来源"
        .TextMatrix(0, 1) = "制单日期"
        .TextMatrix(0, 2) = "转帐编码"
        SjhHeight = 250
        .Width = 0
        For jsq = 0 To .Cols - 1
            .ColAlignment(jsq) = flexAlignCenterCenter
            .ColWidth(jsq) = 1200
            .Width = .Width + .ColWidth(jsq)
        Next jsq
        .Height = 0
        For jsq = 0 To .Rows - 1
            .RowHeight(jsq) = SjhHeight
            .Height = .Height + .RowHeight(jsq)
        Next jsq
        .Height = .Height + 8
    End With
    Call NoSaveList
End Sub

Private Sub NoSaveList()
    Dim RecTemp As New ADODB.Recordset
    SqlStr = "Select * from Cwzz_AccVouchMainTemp Where VouchNo is Null and OperationNo='" & Trim(AutoTran_PzFrm.Lab_OperNum.Caption) & "' order by VouchId"
    Set RecTemp = Cw_DataEnvi.DataConnect.Execute(SqlStr)
    jsq = 1
    Do While RecTemp.EOF = False
        With vsflex1
            If jsq > .Rows - 1 Then
                .AddItem ""
                .RowHeight(jsq) = SjhHeight
            End If
            vsflex1.TextMatrix(jsq, 0) = Trim(RecTemp.Fields("VouchSource") & "")
            vsflex1.TextMatrix(jsq, 1) = Format(Trim(RecTemp.Fields("Ddate") & ""), "yyyy-mm-dd")
            vsflex1.TextMatrix(jsq, 2) = Trim(RecTemp.Fields("BillNo") & "")
        End With
        RecTemp.MoveNext
        jsq = jsq + 1
        vsflex1.BackColorSel = &HFFFFFF
        vsflex1.ForeColorSel = &H0&
    Loop
End Sub