国际资费.frm

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

VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form Form6 
   BorderStyle     =   0  'None
   ClientHeight    =   9000
   ClientLeft      =   0
   ClientTop       =   0
   ClientWidth     =   12000
   LinkTopic       =   "Form6"
   Picture         =   "国际资费.frx":0000
   ScaleHeight     =   9000
   ScaleWidth      =   12000
   ShowInTaskbar   =   0   'False
   StartUpPosition =   3  'Windows Default
   Begin VB.CommandButton Command8 
      Height          =   855
      Left            =   10320
      Picture         =   "国际资费.frx":15F942
      Style           =   1  'Graphical
      TabIndex        =   8
      Top             =   7680
      Visible         =   0   'False
      Width           =   1335
   End
   Begin VB.CommandButton Command6 
      Height          =   800
      Left            =   840
      Picture         =   "国际资费.frx":163DC4
      Style           =   1  'Graphical
      TabIndex        =   7
      Top             =   7440
      Width           =   1780
   End
   Begin VB.CommandButton Command5 
      Height          =   800
      Left            =   840
      Picture         =   "国际资费.frx":168612
      Style           =   1  'Graphical
      TabIndex        =   6
      Top             =   6240
      Width           =   1780
   End
   Begin VB.CommandButton Command4 
      Height          =   800
      Left            =   840
      Picture         =   "国际资费.frx":16CA4C
      Style           =   1  'Graphical
      TabIndex        =   5
      Top             =   4725
      Width           =   1780
   End
   Begin VB.CommandButton Command3 
      Height          =   800
      Left            =   840
      Picture         =   "国际资费.frx":170FE2
      Style           =   1  'Graphical
      TabIndex        =   4
      Top             =   3240
      Width           =   1780
   End
   Begin VB.CommandButton Command2 
      Height          =   800
      Left            =   840
      Picture         =   "国际资费.frx":175578
      Style           =   1  'Graphical
      TabIndex        =   3
      Top             =   2040
      Width           =   1780
   End
   Begin VB.CommandButton Command1 
      Height          =   800
      Left            =   840
      Picture         =   "国际资费.frx":179B0E
      Style           =   1  'Graphical
      TabIndex        =   2
      Top             =   630
      Width           =   1780
   End
   Begin VB.CommandButton Command7 
      Height          =   850
      Left            =   10320
      Picture         =   "国际资费.frx":17E2D0
      Style           =   1  'Graphical
      TabIndex        =   1
      ToolTipText     =   "返回"
      Top             =   480
      Width           =   1245
   End
   Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1 
      Height          =   7620
      Left            =   3000
      TabIndex        =   0
      Top             =   600
      Width           =   6825
      _ExtentX        =   12039
      _ExtentY        =   13441
      _Version        =   327680
      Cols            =   3
      FixedCols       =   0
      ForeColor       =   8421631
      ForeColorFixed  =   16777215
      ScrollTrack     =   -1  'True
      ScrollBars      =   2
   End
End
Attribute VB_Name = "Form6"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Sub sub_code(str_reason As String)
    Dim DB As Database
    Dim rdset_code As Recordset
    Dim num_row As Integer
    Set DB = OpenDatabase(App.Path & "\zj.mdb")
    Set rdset_code = DB.OpenRecordset("select * from " & str_reason)
    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 = rdset_code.Fields(0)
        MSFlexGrid1.Col = 2
        rdset_code.MoveNext
    Wend
    rdset_code.Close
    DB.Close
End Sub

Private Sub Command1_Click()
    Call sub_code("asian")
End Sub

Private Sub Command2_Click()
    Call sub_code("europe")
End Sub

Private Sub Command3_Click()
    Call sub_code("africa")
End Sub

Private Sub Command4_Click()
       Call sub_code("nor_usa")
End Sub

Private Sub Command5_Click()
    Call sub_code("sou_usa")

End Sub

Private Sub Command6_Click()
    Call sub_code("oceanica")

End Sub

Private Sub Command7_Click()
    Form1.Show
    Unload Me

End Sub

Private Sub Command8_Click()
    Form5.Show
    Unload Me
End Sub

Private Sub Form_Load()
    MSFlexGrid1.Rows = 1
    MSFlexGrid1.Cols = 3
    MSFlexGrid1.ColWidth(0) = 3000
    MSFlexGrid1.ColWidth(1) = 1900
    MSFlexGrid1.ColWidth(2) = 1560
    MSFlexGrid1.Col = 0
    MSFlexGrid1.Row = 0
    MSFlexGrid1.Text = " 地名"
    MSFlexGrid1.Col = 1
    MSFlexGrid1.Text = " 区号"
    MSFlexGrid1.Col = 2
    MSFlexGrid1.Text = " 资费"
End Sub