main_jbzl_myunits.frm

EMS是一个企业营销管理系统,功能强大,供大家享用,希望大家多多支持!!

VERSION 5.00
Begin VB.Form main_jbzl_myunits 
   BorderStyle     =   3  'Fixed Dialog
   ClientHeight    =   3300
   ClientLeft      =   2775
   ClientTop       =   4005
   ClientWidth     =   5730
   Icon            =   "main_jbzl_myunits.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3300
   ScaleWidth      =   5730
   ShowInTaskbar   =   0   'False
   StartUpPosition =   1  '所有者中心
   Begin VB.Frame Frame1 
      Height          =   3015
      Left            =   195
      TabIndex        =   0
      Top             =   90
      Width           =   5355
      Begin VB.TextBox gs 
         Height          =   315
         Index           =   6
         Left            =   705
         MaxLength       =   20
         ScrollBars      =   2  'Vertical
         TabIndex        =   14
         Top             =   2505
         Width           =   4305
      End
      Begin VB.TextBox gs 
         Height          =   315
         Index           =   5
         Left            =   1530
         TabIndex        =   12
         Top             =   2055
         Width           =   3465
      End
      Begin VB.TextBox gs 
         Height          =   315
         Index           =   4
         Left            =   1200
         TabIndex        =   10
         Top             =   1605
         Width           =   3795
      End
      Begin VB.TextBox gs 
         Height          =   315
         Index           =   3
         Left            =   1035
         TabIndex        =   8
         Top             =   1155
         Width           =   3945
      End
      Begin VB.TextBox gs 
         Height          =   315
         Index           =   2
         Left            =   1065
         TabIndex        =   6
         Top             =   705
         Width           =   3930
      End
      Begin VB.TextBox gs 
         Height          =   315
         Index           =   1
         Left            =   3195
         TabIndex        =   4
         Top             =   255
         Width           =   1815
      End
      Begin VB.TextBox gs 
         Height          =   315
         Index           =   0
         Left            =   1080
         TabIndex        =   2
         Top             =   240
         Width           =   1215
      End
      Begin VB.Label Label7 
         Caption         =   "备注"
         Height          =   330
         Left            =   300
         TabIndex        =   13
         Top             =   2550
         Width           =   1035
      End
      Begin VB.Label Label6 
         Caption         =   "开户银行及账号"
         Height          =   330
         Left            =   240
         TabIndex        =   11
         Top             =   2100
         Width           =   1365
      End
      Begin VB.Label Label5 
         Caption         =   "税务登记号"
         Height          =   330
         Left            =   270
         TabIndex        =   9
         Top             =   1650
         Width           =   1035
      End
      Begin VB.Label Label4 
         Caption         =   "公司地址"
         Height          =   330
         Left            =   270
         TabIndex        =   7
         Top             =   1200
         Width           =   1035
      End
      Begin VB.Label Label3 
         Caption         =   "公司全称"
         Height          =   330
         Left            =   270
         TabIndex        =   5
         Top             =   750
         Width           =   1035
      End
      Begin VB.Label Label2 
         Caption         =   "公司电话"
         Height          =   210
         Left            =   2385
         TabIndex        =   3
         Top             =   300
         Width           =   780
      End
      Begin VB.Label Label1 
         Caption         =   "公司简称"
         Height          =   330
         Left            =   270
         TabIndex        =   1
         Top             =   300
         Width           =   1035
      End
   End
End
Attribute VB_Name = "main_jbzl_myunits"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rs1 As New ADODB.Recordset     '定义数据集对象
Private Sub Form_Load()
  Me.Caption = text
  rs1.Open "select * from 本单位信息表", Cnn, adOpenStatic
  If rs1.RecordCount > 0 Then
   For i = 0 To 6
     If rs1.Fields(i) <> "" Then gs(i).text = Trim(rs1.Fields(i))
   Next i
  End If
  rs1.Close
End Sub
Private Sub Form_Unload(Cancel As Integer)
  rs1.Open "select * from 本单位信息表", Cnn, adOpenStatic
  If rs1.RecordCount > 0 Then
    Cnn.Execute ("update 本单位信息表 set 公司简称='" + gs(0) + "',公司电话='" + gs(1) + _
                 "',公司全称='" + gs(2) + "',公司地址='" + gs(3) + "',税务登记号='" + gs(4) + _
                 "',开户银行及账号='" + gs(5) + "',备注='" + gs(6) + "'")
  Else
    If gs(2).text <> "" Then
      Cnn.Execute ("insert into 本单位信息表(公司简称,公司电话,公司全称,公司地址,税务登记号,开户银行及账号,备注)values('" + _
                   gs(0) + "','" + gs(1) + "','" + gs(2) + "','" + gs(3) + "','" + gs(4) + "','" + gs(5) + "','" + gs(6) + "')")
    End If
  End If
  rs1.Close
End Sub
Private Sub gs_GotFocus(Index As Integer)
  gs(Index).BackColor = &HFFFF80
  gs(Index).SelStart = 0
  gs(Index).SelLength = Len(gs(Index))
End Sub
Private Sub gs_LostFocus(Index As Integer)
  gs(Index).BackColor = &HFFFFFF
End Sub
Private Sub gs_KeyDown(Index As Integer, KeyCode As Integer, Shift As Integer)
  If KeyCode = vbKeyReturn And Index < 6 Then gs(Index + 1).SetFocus     '回车获得焦点
  If KeyCode = vbKeyUp And Index > 1 Then gs(Index - 1).SetFocus
End Sub