VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form J_ywlbie 
   Caption         =   "業務員類別設置"
   ClientHeight    =   5550
   ClientLeft      =   60
   ClientTop       =   465
   ClientWidth     =   7080
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   ScaleHeight     =   5550
   ScaleWidth      =   7080
   StartUpPosition =   3  '窗口缺省
   Begin VB.Frame Frame3 
      Height          =   735
      Left            =   120
      TabIndex        =   9
      Top             =   1560
      Width           =   6735
      Begin VB.CommandButton Command5 
         Caption         =   "確定修改"
         Height          =   375
         Left            =   4800
         TabIndex        =   14
         Top             =   240
         Width           =   1215
      End
      Begin VB.CommandButton Command4 
         Caption         =   "修改"
         Height          =   375
         Left            =   3480
         TabIndex        =   13
         Top             =   240
         Width           =   1335
      End
      Begin VB.CommandButton Command3 
         Caption         =   "刪除"
         Height          =   375
         Left            =   2280
         TabIndex        =   12
         Top             =   240
         Width           =   1215
      End
      Begin VB.CommandButton Command2 
         Caption         =   "等新"
         Height          =   375
         Left            =   1200
         TabIndex        =   11
         Top             =   240
         Width           =   1095
      End
      Begin VB.CommandButton Command1 
         Caption         =   "添加"
         Height          =   375
         Left            =   120
         TabIndex        =   10
         Top             =   240
         Width           =   1095
      End
   End
   Begin VB.Frame Frame2 
      Height          =   1335
      Left            =   120
      TabIndex        =   2
      Top             =   120
      Width           =   6735
      Begin VB.TextBox Text3 
         Height          =   270
         Left            =   1080
         TabIndex        =   8
         Top             =   840
         Width           =   5175
      End
      Begin VB.TextBox Text2 
         Height          =   270
         Left            =   4320
         TabIndex        =   6
         Top             =   240
         Width           =   1935
      End
      Begin VB.TextBox Text1 
         Height          =   270
         Left            =   1080
         TabIndex        =   4
         Top             =   240
         Width           =   1815
      End
      Begin VB.Label Label3 
         Caption         =   "備注信息:"
         Height          =   255
         Left            =   240
         TabIndex        =   7
         Top             =   840
         Width           =   975
      End
      Begin VB.Label Label2 
         Caption         =   "類別名稱:"
         Height          =   255
         Left            =   3360
         TabIndex        =   5
         Top             =   240
         Width           =   1095
      End
      Begin VB.Label Label1 
         Caption         =   "類別編號:"
         Height          =   255
         Left            =   240
         TabIndex        =   3
         Top             =   240
         Width           =   1095
      End
   End
   Begin VB.Frame Frame1 
      Height          =   2655
      Left            =   240
      TabIndex        =   0
      Top             =   2400
      Width           =   6615
      Begin MSFlexGridLib.MSFlexGrid sqlist 
         Height          =   2415
         Left            =   120
         TabIndex        =   1
         Top             =   120
         Width           =   6375
         _ExtentX        =   11245
         _ExtentY        =   4260
         _Version        =   393216
      End
   End
End
Attribute VB_Name = "J_ywlbie"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim maa As ADODB.Recordset
Dim txtSQL As String
Dim msgText As String
Public Sub ShowTitle()
Dim i As Integer
With sqlist
.Cols = 4
.TextMatrix(0, 1) = "類別編號"
.TextMatrix(0, 2) = "類別名稱"
.TextMatrix(0, 3) = "備注信息"
.FixedRows = 1
For i = 0 To 3
.ColAlignment(i) = 0
Next i
.FillStyle = flexFillRepeat
        .Col = 0
        .Row = 0
        .RowSel = 1
        .ColSel = .Cols - 1
        .CellAlignment = 4
        
        .ColWidth(0) = 500
        .ColWidth(1) = 2000
        .ColWidth(2) = 2000
        .ColWidth(3) = 2000
        .Row = 1

End With
End Sub
Public Sub ShowData()
    
    Dim j As Integer
    Dim i As Integer
    Dim msgText As String
    txtSQL = "select * from g_ywyleibie"
    Set maa = ExecuteSQL(txtSQL, msgText)
        With sqlist
        .Rows = 1
        
        Do While Not maa.EOF
            .Rows = .Rows + 1
            For i = 1 To maa.Fields.Count
                Select Case maa.Fields(i - 1).Type
                    Case adDBDate
                        .TextMatrix(.Rows - 1, i) = Format(maa.Fields(i - 1) & "", "yyyy-mm-dd")
                    Case Else
                        .TextMatrix(.Rows - 1, i) = maa.Fields(i - 1) & ""
                End Select
            Next i
            maa.MoveNext
        Loop
        
          
    End With
    maa.Close
    
    
End Sub

Private Sub Form_Load()
ShowTitle
ShowData
End Sub