frmcheckbill.vb

单机版餐饮服务系统,结合了SqlServer数据库

Imports System
Imports System.Data
Imports System.Drawing
Imports System.Data.SqlClient

Namespace HZC.DinningService

    Public Class frmCheckBill
        Inherits System.Windows.Forms.Form
        Dim sum As Double
        Dim num As Double
        Dim dis As Double

#Region " Windows 窗体设计器生成的代码 "

        Public Sub New()
            MyBase.New()

            '该调用是 Windows 窗体设计器所必需的。
            InitializeComponent()

            '在 InitializeComponent() 调用之后添加任何初始化

        End Sub

        '窗体重写处置以清理组件列表。
        Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
            If disposing Then
                If Not (components Is Nothing) Then
                    components.Dispose()
                End If
            End If
            MyBase.Dispose(disposing)
        End Sub

        'Windows 窗体设计器所必需的
        Private components As System.ComponentModel.IContainer

        '注意：以下过程是 Windows 窗体设计器所必需的
        '可以使用 Windows 窗体设计器修改此过程。
        '不要使用代码编辑器修改它。
        Friend WithEvents CheckBillPicture As System.Windows.Forms.PictureBox
        Friend WithEvents lbTableNumber As System.Windows.Forms.Label
        Friend WithEvents GroupBox2 As System.Windows.Forms.GroupBox
        Friend WithEvents rdtCash As System.Windows.Forms.RadioButton
        Friend WithEvents rdtCards As System.Windows.Forms.RadioButton
        Friend WithEvents txtTableNumber As System.Windows.Forms.TextBox
        Friend WithEvents txtCardNumber As System.Windows.Forms.TextBox
        Friend WithEvents txtReturnMoney As System.Windows.Forms.TextBox
        Friend WithEvents txtPayMoney As System.Windows.Forms.TextBox
        Friend WithEvents txtToPayBill As System.Windows.Forms.TextBox
        Friend WithEvents txtDisCount As System.Windows.Forms.TextBox
        Friend WithEvents btnCheckBill As System.Windows.Forms.Button
        Friend WithEvents gpCheck As System.Windows.Forms.GroupBox
        Friend WithEvents lbCardNumber As System.Windows.Forms.Label
        Friend WithEvents lbCharge As System.Windows.Forms.Label
        Friend WithEvents lbPayedTo As System.Windows.Forms.Label
        Friend WithEvents lbPayedFor As System.Windows.Forms.Label
        Friend WithEvents lbDiscount As System.Windows.Forms.Label
        Friend WithEvents lbCustomerID As System.Windows.Forms.Label
        Friend WithEvents lbIdentity As System.Windows.Forms.Label
        Friend WithEvents lbTitle As System.Windows.Forms.Label
        Friend WithEvents lbDescription As System.Windows.Forms.Label
        Friend WithEvents gpVIP As System.Windows.Forms.GroupBox
        Friend WithEvents chkVIP As System.Windows.Forms.CheckBox
        Friend WithEvents gpCheckInfo As System.Windows.Forms.GroupBox
        Friend WithEvents txtVIPNumber As System.Windows.Forms.TextBox
        Friend WithEvents txtIDNumber As System.Windows.Forms.TextBox
        Friend WithEvents Label1 As System.Windows.Forms.Label
        Friend WithEvents Label2 As System.Windows.Forms.Label
        Friend WithEvents txtRoomName As System.Windows.Forms.TextBox
        Friend WithEvents dtOrderDate As System.Windows.Forms.DateTimePicker
        Friend WithEvents btnBillQuery As System.Windows.Forms.Button
        Friend WithEvents btnBillDetail As System.Windows.Forms.Button
        <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
            Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(frmCheckBill))
            Me.gpCheckInfo = New System.Windows.Forms.GroupBox
            Me.dtOrderDate = New System.Windows.Forms.DateTimePicker
            Me.Label2 = New System.Windows.Forms.Label
            Me.txtRoomName = New System.Windows.Forms.TextBox
            Me.Label1 = New System.Windows.Forms.Label
            Me.gpVIP = New System.Windows.Forms.GroupBox
            Me.lbCustomerID = New System.Windows.Forms.Label
            Me.txtVIPNumber = New System.Windows.Forms.TextBox
            Me.lbIdentity = New System.Windows.Forms.Label
            Me.txtIDNumber = New System.Windows.Forms.TextBox
            Me.lbDescription = New System.Windows.Forms.Label
            Me.lbTitle = New System.Windows.Forms.Label
            Me.chkVIP = New System.Windows.Forms.CheckBox
            Me.gpCheck = New System.Windows.Forms.GroupBox
            Me.lbCardNumber = New System.Windows.Forms.Label
            Me.txtCardNumber = New System.Windows.Forms.TextBox
            Me.rdtCards = New System.Windows.Forms.RadioButton
            Me.rdtCash = New System.Windows.Forms.RadioButton
            Me.GroupBox2 = New System.Windows.Forms.GroupBox
            Me.CheckBillPicture = New System.Windows.Forms.PictureBox
            Me.txtReturnMoney = New System.Windows.Forms.TextBox
            Me.txtPayMoney = New System.Windows.Forms.TextBox
            Me.lbCharge = New System.Windows.Forms.Label
            Me.lbPayedTo = New System.Windows.Forms.Label
            Me.txtToPayBill = New System.Windows.Forms.TextBox
            Me.lbPayedFor = New System.Windows.Forms.Label
            Me.txtDisCount = New System.Windows.Forms.TextBox
            Me.lbDiscount = New System.Windows.Forms.Label
            Me.txtTableNumber = New System.Windows.Forms.TextBox
            Me.lbTableNumber = New System.Windows.Forms.Label
            Me.btnCheckBill = New System.Windows.Forms.Button
            Me.btnBillQuery = New System.Windows.Forms.Button
            Me.btnBillDetail = New System.Windows.Forms.Button
            Me.gpCheckInfo.SuspendLayout()
            Me.gpVIP.SuspendLayout()
            Me.gpCheck.SuspendLayout()
            Me.SuspendLayout()
            '
            'gpCheckInfo
            '
            Me.gpCheckInfo.Controls.Add(Me.dtOrderDate)
            Me.gpCheckInfo.Controls.Add(Me.Label2)
            Me.gpCheckInfo.Controls.Add(Me.txtRoomName)
            Me.gpCheckInfo.Controls.Add(Me.Label1)
            Me.gpCheckInfo.Controls.Add(Me.gpVIP)
            Me.gpCheckInfo.Controls.Add(Me.lbDescription)
            Me.gpCheckInfo.Controls.Add(Me.lbTitle)
            Me.gpCheckInfo.Controls.Add(Me.chkVIP)
            Me.gpCheckInfo.Controls.Add(Me.gpCheck)
            Me.gpCheckInfo.Controls.Add(Me.rdtCards)
            Me.gpCheckInfo.Controls.Add(Me.rdtCash)
            Me.gpCheckInfo.Controls.Add(Me.GroupBox2)
            Me.gpCheckInfo.Controls.Add(Me.CheckBillPicture)
            Me.gpCheckInfo.Controls.Add(Me.txtReturnMoney)
            Me.gpCheckInfo.Controls.Add(Me.txtPayMoney)
            Me.gpCheckInfo.Controls.Add(Me.lbCharge)
            Me.gpCheckInfo.Controls.Add(Me.lbPayedTo)
            Me.gpCheckInfo.Controls.Add(Me.txtToPayBill)
            Me.gpCheckInfo.Controls.Add(Me.lbPayedFor)
            Me.gpCheckInfo.Controls.Add(Me.txtDisCount)
            Me.gpCheckInfo.Controls.Add(Me.lbDiscount)
            Me.gpCheckInfo.Controls.Add(Me.txtTableNumber)
            Me.gpCheckInfo.Controls.Add(Me.lbTableNumber)
            Me.gpCheckInfo.Location = New System.Drawing.Point(8, 8)
            Me.gpCheckInfo.Name = "gpCheckInfo"
            Me.gpCheckInfo.Size = New System.Drawing.Size(512, 400)
            Me.gpCheckInfo.TabIndex = 0
            Me.gpCheckInfo.TabStop = False
            Me.gpCheckInfo.Text = "结账信息"
            '
            'dtOrderDate
            '
            Me.dtOrderDate.Location = New System.Drawing.Point(280, 80)
            Me.dtOrderDate.Name = "dtOrderDate"
            Me.dtOrderDate.Size = New System.Drawing.Size(216, 21)
            Me.dtOrderDate.TabIndex = 33
            '
            'Label2
            '
            Me.Label2.ForeColor = System.Drawing.Color.Blue
            Me.Label2.Location = New System.Drawing.Point(208, 80)
            Me.Label2.Name = "Label2"
            Me.Label2.Size = New System.Drawing.Size(72, 21)
            Me.Label2.TabIndex = 32
            Me.Label2.Text = "消费日期："
            Me.Label2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
            '
            'txtRoomName
            '
            Me.txtRoomName.BackColor = System.Drawing.Color.Cornsilk
            Me.txtRoomName.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle
            Me.txtRoomName.ForeColor = System.Drawing.SystemColors.HotTrack
            Me.txtRoomName.Location = New System.Drawing.Point(280, 48)
            Me.txtRoomName.Name = "txtRoomName"
            Me.txtRoomName.Size = New System.Drawing.Size(216, 21)
            Me.txtRoomName.TabIndex = 31
            Me.txtRoomName.Text = ""
            Me.txtRoomName.TextAlign = System.Windows.Forms.HorizontalAlignment.Center
            '
            'Label1
            '
            Me.Label1.ForeColor = System.Drawing.Color.Blue
            Me.Label1.Location = New System.Drawing.Point(208, 48)
            Me.Label1.Name = "Label1"
            Me.Label1.Size = New System.Drawing.Size(72, 21)
            Me.Label1.TabIndex = 30
            Me.Label1.Text = "所在房间："
            Me.Label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
            '
            'gpVIP
            '
            Me.gpVIP.Controls.Add(Me.lbCustomerID)
            Me.gpVIP.Controls.Add(Me.txtVIPNumber)
            Me.gpVIP.Controls.Add(Me.lbIdentity)
            Me.gpVIP.Controls.Add(Me.txtIDNumber)
            Me.gpVIP.Enabled = False
            Me.gpVIP.ForeColor = System.Drawing.Color.Navy
            Me.gpVIP.Location = New System.Drawing.Point(200, 312)
            Me.gpVIP.Name = "gpVIP"
            Me.gpVIP.Size = New System.Drawing.Size(304, 80)
            Me.gpVIP.TabIndex = 29
            Me.gpVIP.TabStop = False
            '
            'lbCustomerID
            '
            Me.lbCustomerID.ForeColor = System.Drawing.Color.Navy
            Me.lbCustomerID.Location = New System.Drawing.Point(8, 16)
            Me.lbCustomerID.Name = "lbCustomerID"
            Me.lbCustomerID.Size = New System.Drawing.Size(72, 24)
            Me.lbCustomerID.TabIndex = 23
            Me.lbCustomerID.Text = "会员卡号："
            '
            'txtVIPNumber
            '
            Me.txtVIPNumber.BackColor = System.Drawing.Color.WhiteSmoke
            Me.txtVIPNumber.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle
            Me.txtVIPNumber.ForeColor = System.Drawing.Color.Red
            Me.txtVIPNumber.Location = New System.Drawing.Point(80, 16)
            Me.txtVIPNumber.MaxLength = 50
            Me.txtVIPNumber.Name = "txtVIPNumber"
            Me.txtVIPNumber.ReadOnly = True
            Me.txtVIPNumber.Size = New System.Drawing.Size(216, 21)
            Me.txtVIPNumber.TabIndex = 24
            Me.txtVIPNumber.Text = ""
            Me.txtVIPNumber.TextAlign = System.Windows.Forms.HorizontalAlignment.Center
            '
            'lbIdentity
            '
            Me.lbIdentity.ForeColor = System.Drawing.Color.Navy