国内资费.frm

以前做的移动公司的一个多媒体查询系统,有话费查询

VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form Form7 
   BorderStyle     =   0  'None
   Caption         =   "Form7"
   ClientHeight    =   9000
   ClientLeft      =   0
   ClientTop       =   0
   ClientWidth     =   12000
   LinkTopic       =   "Form7"
   Picture         =   "国内资费.frx":0000
   ScaleHeight     =   9000
   ScaleWidth      =   12000
   ShowInTaskbar   =   0   'False
   StartUpPosition =   3  'Windows Default
   Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1 
      Height          =   6615
      Left            =   1200
      TabIndex        =   3
      Top             =   2040
      Width           =   7335
      _ExtentX        =   12938
      _ExtentY        =   11668
      _Version        =   327680
      Cols            =   3
      FixedCols       =   0
      ForeColor       =   8421631
      ScrollBars      =   2
   End
   Begin VB.CommandButton Command2 
      Height          =   855
      Left            =   9360
      Picture         =   "国内资费.frx":15F942
      Style           =   1  'Graphical
      TabIndex        =   2
      Top             =   7800
      Visible         =   0   'False
      Width           =   1335
   End
   Begin VB.CommandButton Command1 
      Height          =   855
      Left            =   9360
      Picture         =   "国内资费.frx":163DC4
      Style           =   1  'Graphical
      TabIndex        =   0
      ToolTipText     =   "返回"
      Top             =   840
      Width           =   1245
   End
   Begin VB.Label Label1 
      BackStyle       =   0  'Transparent
      BorderStyle     =   1  'Fixed Single
      Height          =   1215
      Left            =   1200
      TabIndex        =   1
      Top             =   720
      Width           =   5655
   End
End
Attribute VB_Name = "Form7"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
    Form1.Show
    Unload Me
End Sub

Private Sub Command2_Click()
    Form5.Show
    Unload Me
End Sub
Private Sub Form_Load()
    Dim DB As Database
    Dim rdset_code As Recordset
    Dim num_row As Integer
    
    MSFlexGrid1.Rows = 1
    MSFlexGrid1.Cols = 3
    MSFlexGrid1.ColWidth(0) = 3000
    MSFlexGrid1.ColWidth(1) = 2000
    MSFlexGrid1.ColWidth(2) = 2000
    MSFlexGrid1.Col = 0
    MSFlexGrid1.Row = 0
    MSFlexGrid1.Text = " 地名"
    MSFlexGrid1.Col = 1
    MSFlexGrid1.Text = " 区号"
    MSFlexGrid1.Col = 2
    MSFlexGrid1.Text = " 资费"
    
    Set DB = OpenDatabase(App.Path & "\zj.mdb")
    Set rdset_code = DB.OpenRecordset("select * from china_zip ")
    MSFlexGrid1.Rows = 1
    num_row = 0
    MSFlexGrid1.Col = 2
    While Not rdset_code.EOF
        MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1
        num_row = num_row + 1
        MSFlexGrid1.Row = num_row
        MSFlexGrid1.Text = rdset_code.Fields(2)
        MSFlexGrid1.Col = 1
        MSFlexGrid1.Text = rdset_code.Fields(1)
        MSFlexGrid1.Col = 0
        MSFlexGrid1.Text = IIf(IsNull(rdset_code.Fields(0)), "", rdset_code.Fields(0))
        MSFlexGrid1.Col = 2
        rdset_code.MoveNext
    Wend
    rdset_code.Close
    DB.Close

End Sub