main_note.frm

医院门诊管理系统

VERSION 5.00
Begin VB.Form Main_Note 
   BackColor       =   &H00E0E0E0&
   BorderStyle     =   3  'Fixed Dialog
   ClientHeight    =   3000
   ClientLeft      =   45
   ClientTop       =   45
   ClientWidth     =   5085
   ControlBox      =   0   'False
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3000
   ScaleWidth      =   5085
   ShowInTaskbar   =   0   'False
   StartUpPosition =   1  '所有者中心
   Begin VB.CommandButton CmdCancel 
      Caption         =   "取消"
      Height          =   390
      Left            =   2505
      TabIndex        =   7
      Top             =   2505
      Width           =   1470
   End
   Begin VB.CommandButton CmdOK 
      Caption         =   "确定"
      Height          =   390
      Left            =   1050
      TabIndex        =   8
      Top             =   2505
      Width           =   1470
   End
   Begin VB.Frame Frame1 
      BackColor       =   &H00FFFFC0&
      Height          =   2295
      Left            =   105
      TabIndex        =   0
      Top             =   105
      Width           =   4890
      Begin VB.TextBox Txtxsjh 
         Height          =   300
         Left            =   1725
         MaxLength       =   7
         TabIndex        =   1
         Top             =   1530
         Width           =   2325
      End
      Begin VB.Label Lblysjh 
         BackStyle       =   0  'Transparent
         Height          =   225
         Left            =   1725
         TabIndex        =   9
         Top             =   1155
         Width           =   2445
      End
      Begin VB.Label Lblckh 
         BackStyle       =   0  'Transparent
         Height          =   225
         Left            =   1725
         TabIndex        =   6
         Top             =   705
         Width           =   2445
      End
      Begin VB.Label Label1 
         BackStyle       =   0  'Transparent
         Caption         =   "设置收据号"
         BeginProperty Font 
            Name            =   "华文行楷"
            Size            =   14.25
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H000000FF&
         Height          =   345
         Left            =   90
         TabIndex        =   5
         Top             =   210
         Width           =   3195
      End
      Begin VB.Label Label2 
         BackStyle       =   0  'Transparent
         Caption         =   "窗口号"
         Height          =   270
         Left            =   405
         TabIndex        =   4
         Top             =   705
         Width           =   705
      End
      Begin VB.Label Label3 
         BackStyle       =   0  'Transparent
         Caption         =   "原起始收据号"
         Height          =   345
         Left            =   405
         TabIndex        =   3
         Top             =   1155
         Width           =   1215
      End
      Begin VB.Label Label4 
         BackStyle       =   0  'Transparent
         Caption         =   "新起始收据号"
         Height          =   345
         Left            =   405
         TabIndex        =   2
         Top             =   1620
         Width           =   2595
      End
   End
End
Attribute VB_Name = "Main_Note"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rs As New ADODB.Recordset
Private Sub Form_Load()
  Lblckh.Caption = ckh
  rs.Open "select * from 编码表", cnn, adOpenKeyset, adLockOptimistic
  If rs.RecordCount > 0 Then
     Lblysjh.Caption = rs.Fields("原起始收据号")
  End If
  rs.Close
End Sub
Private Sub Txtxsjh_KeyDown(KeyCode As Integer, Shift As Integer)
  If KeyCode = vbKeyReturn Then CmdOK.SetFocus
End Sub
Private Sub cmdOK_Click()
  rs.Open "select * from 编码表", cnn, adOpenKeyset, adLockOptimistic
  If rs.RecordCount > 0 Then
     rs.Fields("新起始收据号") = Format(Val(Txtxsjh.Text) - 1, "0000000")
     rs.Update
  Else
     rs.AddNew
     rs.Fields("原起始收据号") = Format(Val(Txtxsjh.Text), "0000000")
     rs.Fields("新起始收据号") = Format(Val(Txtxsjh.Text), "0000000")
     rs.Update
  End If
  rs.Close
  sjh = Txtxsjh.Text
  Load Main_Charge
  Main_Charge.Show
  Unload Me
End Sub
Private Sub CmdCancel_Click()
  Unload Me
  EnaT Frm_Main
End Sub