houseadd2.frm

一部酒店管理系统

VERSION 5.00
Begin VB.Form houseadd2 
   Caption         =   "追加新客房"
   ClientHeight    =   3315
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   3540
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3315
   ScaleWidth      =   3540
   StartUpPosition =   3  '窗口缺省
   Begin VB.PictureBox Picture1 
      BackColor       =   &H00404000&
      Height          =   3255
      Left            =   0
      ScaleHeight     =   3195
      ScaleWidth      =   3435
      TabIndex        =   0
      Top             =   0
      Width           =   3495
      Begin VB.ComboBox Combo1 
         BackColor       =   &H00FFFFC0&
         Height          =   315
         Left            =   1080
         TabIndex        =   10
         Text            =   "Combo1"
         Top             =   800
         Width           =   1335
      End
      Begin VB.TextBox txt_chuang 
         BackColor       =   &H00FFFFC0&
         Height          =   285
         Left            =   1080
         TabIndex        =   9
         Top             =   1760
         Width           =   1335
      End
      Begin VB.TextBox txt_lou 
         BackColor       =   &H00FFFFC0&
         Height          =   285
         Left            =   1080
         TabIndex        =   8
         Top             =   1280
         Width           =   1335
      End
      Begin VB.TextBox txt_no 
         BackColor       =   &H00FFFFC0&
         Height          =   285
         Left            =   1080
         TabIndex        =   7
         Top             =   320
         Width           =   1335
      End
      Begin VB.CommandButton cmd_ret 
         Caption         =   "返回"
         Height          =   375
         Left            =   1800
         TabIndex        =   6
         Top             =   2400
         Width           =   855
      End
      Begin VB.CommandButton cmd_add 
         Caption         =   "增加"
         Height          =   375
         Left            =   600
         TabIndex        =   5
         Top             =   2400
         Width           =   855
      End
      Begin VB.Label Label4 
         BackColor       =   &H00404000&
         Caption         =   "床位数:"
         Height          =   255
         Left            =   360
         TabIndex        =   4
         Top             =   1800
         Width           =   615
      End
      Begin VB.Label Label3 
         BackColor       =   &H00404000&
         Caption         =   "楼  层:"
         Height          =   255
         Left            =   360
         TabIndex        =   3
         Top             =   1320
         Width           =   615
      End
      Begin VB.Label Label2 
         BackColor       =   &H00404000&
         Caption         =   "类  别:"
         Height          =   255
         Left            =   360
         TabIndex        =   2
         Top             =   840
         Width           =   615
      End
      Begin VB.Label Label1 
         BackColor       =   &H00404000&
         Caption         =   "房间号:"
         Height          =   255
         Left            =   360
         TabIndex        =   1
         Top             =   360
         Width           =   735
      End
   End
End
Attribute VB_Name = "houseadd2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Public m_kind As String



Private Sub cmd_add_Click()

    Call InsertHouse

End Sub

Private Sub cmd_ret_Click()

    Unload Me
    houseinput.Show

End Sub

Private Sub Combo1_Click()

    m_kind = Combo1.Text

End Sub



Private Sub Form_Load()

    '窗口居中
    Me.Left = (Screen.Width - Me.Width) / 2
    Me.Top = (Screen.Height - Me.Height) / 2 - 550
    
    Call LoadsHouseKind

End Sub



'加载客房类别信息

Private Sub LoadsHouseKind()

    Dim str As String
    str = "select * from housekind"
    
    Dim myrs As ADODB.Recordset
    Set myrs = New ADODB.Recordset
    
    myrs.CursorLocation = adUseClient
    myrs.LockType = adLockOptimistic
    myrs.CursorType = adOpenDynamic
    myrs.Open str, myCon
    myrs.MoveFirst
    
    While Not myrs.EOF
    
        Combo1.AddItem (myrs("kind"))
        myrs.MoveNext
    
    Wend
    
    Combo1.ListIndex = 0
End Sub


'添加新客房
Private Sub InsertHouse()
    
    Dim m_no As String
    Dim m_lou As String
    Dim m_chuang As String
    
    m_no = txt_no.Text
    m_lou = txt_lou.Text
    m_chuang = txt_chuang.Text
    
    
    Dim str1 As String
    str1 = "select * from house where nam='" & m_no & "'"
    
    Dim myrs As ADODB.Recordset
    Set myrs = New ADODB.Recordset
    
    myrs.CursorLocation = adUseClient
    myrs.LockType = adLockOptimistic
    myrs.CursorType = adOpenDynamic
    myrs.Open str1, myCon
    
    Dim m_sum As Integer '读取共多少条记录
    m_sum = myrs.RecordCount
    If m_sum = 0 Then
    
        Dim str As String
        
        str = "insert into house(nam,kind,kong,xingbie,ding,man,weixiu,qingsao" & _
        ",chuang,zhu,lou) values('" & m_no & "','" & m_kind & "','1','2','0','0','0'," & _
        "'0','" & m_chuang & "','0','" & m_lou & "')"
        
        myCon.Execute (str)
        
        Call CleanScreen
        MsgBox "添加成功!", vbExclamation
    
    Else
        
        MsgBox "客房名已存在，请更换!", vbExclamation
        txt_no.SetFocus
        
    End If
    
End Sub


Private Sub CleanScreen()

    txt_no.Text = ""
    txt_lou.Text = ""
    txt_chuang.Text = ""
    Combo1.ListIndex = 0

End Sub