frmdatashow2.frm

一个交通专用的gis-T系统

VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "Msflxgrd.ocx"
Begin VB.Form FrmDatashow2 
   Caption         =   "数据查看"
   ClientHeight    =   5235
   ClientLeft      =   165
   ClientTop       =   450
   ClientWidth     =   7365
   Icon            =   "frmDataShow2.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   5235
   ScaleWidth      =   7365
   StartUpPosition =   2  '屏幕中心
   Begin VB.Frame Frame1 
      Caption         =   "搜索范围设置"
      Height          =   855
      Left            =   0
      TabIndex        =   1
      Top             =   4320
      Width           =   7215
      Begin VB.CommandButton Command1 
         Caption         =   "关闭(&C)"
         Height          =   375
         Left            =   6000
         TabIndex        =   7
         Top             =   360
         Width           =   975
      End
      Begin VB.CommandButton cmdsearch 
         Caption         =   "搜索(&S)"
         Default         =   -1  'True
         Height          =   375
         Left            =   4800
         TabIndex        =   6
         Top             =   360
         Width           =   975
      End
      Begin VB.ComboBox cmbfield 
         Height          =   300
         Left            =   120
         TabIndex        =   4
         Text            =   "字段选择"
         Top             =   360
         Width           =   1335
      End
      Begin VB.TextBox txtval 
         Height          =   315
         Left            =   3240
         TabIndex        =   3
         Top             =   360
         Width           =   1215
      End
      Begin VB.ComboBox cmbval 
         Height          =   300
         Left            =   2280
         TabIndex        =   2
         Text            =   "Combo1"
         Top             =   360
         Width           =   855
      End
      Begin VB.Label Label1 
         Caption         =   "搜索值："
         Height          =   255
         Left            =   1560
         TabIndex        =   5
         Top             =   405
         Width           =   855
      End
   End
   Begin MSFlexGridLib.MSFlexGrid fg1 
      Height          =   4215
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   7215
      _ExtentX        =   12726
      _ExtentY        =   7435
      _Version        =   393216
      Cols            =   5
      FixedRows       =   0
      FixedCols       =   0
      ScrollBars      =   2
   End
End
Attribute VB_Name = "FrmDatashow2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'*********************************************************************
'*
'*                本源码完全免费，共交通同仁学习参考                 *
'*                      www.tranbbs.com                              *
'*                   Developed by Yang Ming                          *
'*       Nanjing Institute of City Transportation Planning           *
'*                 请保留本版权信息，谢谢合作                        *
'*                      中国交通技术论坛                             *
'*                                                                   *
'*                                                                   *
'*********************************************************************
Option Explicit
Private Sub cmblayer_Click()

End Sub

Private Sub cmbval_Click()
txtval.SetFocus
End Sub



Private Sub cmdsearch_Click()

    Dim TbName, FdName As String
    Dim SelVal, KeyV As String
    Dim RsResult As Recordset
    
    TbName = FrmDbManage.List1.Text
    FdName = cmbfield.Text
    SelVal = cmbval.Text
    KeyV = txtval.Text
    
    Set RsResult = mDbBiblio.OpenRecordset("select * from " & TbName & " where " & FdName & " " & SelVal & " " & KeyV)
    
    Dim FirNum, i
    FirNum = RsResult.Fields.Count
    
    For i = 0 To FirNum - 1
        fg1.Row = 0
        fg1.Col = i
        fg1.Text = RsResult.Fields(i).Name
    Next i
    
    If RsResult.RecordCount <> 0 Then
    
            Dim coutnum
            RsResult.MoveFirst
            RsResult.MoveLast
            coutnum = RsResult.RecordCount
            fg1.Rows = coutnum + 1
            RsResult.MoveFirst
            step = 1
            
            Do While Not RsResult.EOF
                For i = 0 To FirNum - 1
                    fg1.Row = step
                    fg1.Col = i
                    
                    If IsNull(RsResult.Fields(i).Value) = True Then
                        fg1.Text = "N/A"
                    Else
                        fg1.Text = RsResult.Fields(i).Value
                    End If
                Next i
                step = step + 1
                RsResult.MoveNext
            Loop
            fg1.Refresh
            
    Else
        MsgBox "没有找到记录！"
        Exit Sub
    End If
    
End Sub

Private Sub Command1_Click()
    Unload Me
End Sub

Private Sub Form_Load()
    
    If FrmDbManage.List1.Text = "" Then
        MsgBox "请首先选择有效数据表！"
        Exit Sub
    End If
    
    Dim Rsshow As Recordset
    If FrmDbManage.List1.Text <> "" Then
        Set Rsshow = mDbBiblio.OpenRecordset(FrmDbManage.List1.Text)
        If Rsshow.RecordCount = 0 Then
            MsgBox "数据表中暂无数据！"
            Exit Sub
        End If
    Else
        Exit Sub
    End If
    
    Dim FirNum, i
    FirNum = Rsshow.Fields.Count
    
    'setup the grid
    fg1.Cols = FirNum
    fg1.FixedCols = 0
    fg1.FixedRows = 0
    fg1.AllowUserResizing = flexResizeColumns
    
    For i = 0 To FirNum - 1
        fg1.ColWidth(i) = fg1.Width / FirNum
    Next i
    fg1.Width = fg1.Width + 100
    fg1.Refresh
    
    For i = 0 To FirNum - 1
        fg1.Row = 0
        fg1.Col = i
        fg1.Text = Rsshow.Fields(i).Name
    Next i
    
    Dim coutnum
    Rsshow.MoveFirst
    Rsshow.MoveLast
      
    coutnum = Rsshow.RecordCount
    fg1.Rows = coutnum + 1
    Rsshow.MoveFirst
    step = 1
    
    Do While Not Rsshow.EOF
        For i = 0 To FirNum - 1
            fg1.Row = step
            fg1.Col = i
            
            If IsNull(Rsshow.Fields(i).Value) = True Then
                fg1.Text = "N/A"
            Else
                fg1.Text = Rsshow.Fields(i).Value
            End If
        Next i
        step = step + 1
        Rsshow.MoveNext
    Loop
    fg1.Refresh
    
      
        cmbval.AddItem ">"
        cmbval.AddItem "="
        cmbval.AddItem "<"
        cmbval.Text = "="
        
        
        SQL_str = ""
    
    
        cmbfield.Clear

        '遍历表中的字段，将其字段名添加到 List2 中。
        For Each Fd In mDbBiblio.TableDefs(FrmDbManage.List1.Text).Fields
            cmbfield.AddItem Fd.Name
        Next
        '控制cmdsel按钮数组的有效性，以免发生错误。
        If cmbfield.ListCount <> 0 Then
            cmdsearch.Enabled = True
            cmbfield.Text = cmbfield.List(0)
           Else
            cmdsearch.Enabled = False
        End If
        '获取要查询的表名。
        
        TbName = cmbfield.Text
    
End Sub