www.pudn.com > jiudianguanli.rar > frmtuifang.frm

VERSION 5.00 
Begin VB.Form frmtuifang  
   BorderStyle     =   3  'Fixed Dialog 
   Caption         =   "退房结算" 
   ClientHeight    =   1380 
   ClientLeft      =   2100 
   ClientTop       =   2865 
   ClientWidth     =   3735 
   Icon            =   "frmtuifang.frx":0000 
   LinkTopic       =   "Form1" 
   MaxButton       =   0   'False 
   MinButton       =   0   'False 
   ScaleHeight     =   1380 
   ScaleWidth      =   3735 
   ShowInTaskbar   =   0   'False 
   Begin VB.CommandButton cmdquxiao  
      Caption         =   "取消" 
      Height          =   375 
      Left            =   2760 
      TabIndex        =   3 
      Top             =   840 
      Width           =   735 
   End 
   Begin VB.CommandButton cmdqueding  
      Caption         =   "确定" 
      Height          =   375 
      Left            =   1680 
      TabIndex        =   2 
      Top             =   840 
      Width           =   735 
   End 
   Begin VB.TextBox Txtfangjianhao  
      Height          =   375 
      Left            =   1680 
      TabIndex        =   1 
      Top             =   240 
      Width           =   1695 
   End 
   Begin VB.Label lblfangjianhao  
      Caption         =   "客户编号" 
      Height          =   495 
      Left            =   240 
      TabIndex        =   0 
      Top             =   240 
      Width           =   1095 
   End 
End 
Attribute VB_Name = "frmtuifang" 
Attribute VB_GlobalNameSpace = False 
Attribute VB_Creatable = False 
Attribute VB_PredeclaredId = True 
Attribute VB_Exposed = False 
Private Sub cmdqueding_Click() 
    Dim chaxun As String 
    Dim ca As String 
    Dim riqi As String 
    Dim days As String 
    Dim jiage As String 
    If Txtfangjianhao <> Empty Then 
    chaxun = "select * from kehudengji where kehuid=" & Txtfangjianhao 
       If querydata(chaxun) = True Then 
    rct.MoveFirst 
    riqi = rct.Fields("ruzhuriqi").Value 
     
    days = DateDiff("d", riqi, Now) 
    End If 
    ca = "select * from fangjianbiao" 
        If querydata(ca) = True Then 
    rct.MoveFirst 
    jiage = rct.Fields("fangjianjiage").Value 
    MsgBox "共住" & (days + 1) & "天" & (days + 1) * jiage & "元" 
    End If 
    Else 
        MsgBox "你输入无效" 
    End If 
End Sub 
 
Private Sub cmdquxiao_Click() 
    Unload Me 
End Sub