querydepositform.cs

一个很好的宾馆管理系统 VC++和SQL做的

//文件名：QueryDepositForm.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace MyHotel
{
    public partial class QueryDepositForm : Form
    {
        public QueryDepositForm()
        {
            InitializeComponent();
        }

        private void 查询Button_Click(object sender, EventArgs e)
        {
            this.押金DataGridView.Rows.Clear();
            String MySQLConnectionString = global::MyHotel.Properties.Settings.Default.MyHotelConnectionString;
            SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
            MyConnection.Open();
            System.Data.DataTable MyGuestTable = new System.Data.DataTable();
            string MySQL = "Select 入住编号,客人姓名,房号,预收押金,折扣价格,入住日期,住宿人数 From 客房入住单 Where 入住编号 NOT IN (Select 入住编号 From 客房结帐单)";
            SqlDataAdapter MyAdapter = new SqlDataAdapter(MySQL, MyConnection);
            MyAdapter.Fill(MyGuestTable);
            foreach (DataRow MyRow in MyGuestTable.Rows)
            {
                string My入住编号 = MyRow[0].ToString();
                string My客人姓名 = MyRow[1].ToString();
                string My房号 = MyRow[2].ToString();
                string My预收押金 = MyRow[3].ToString();
                string My折扣价格 = MyRow[4].ToString();
                int My住宿人数 = Convert.ToInt16(MyRow[6].ToString());

                double MyD店内消费 = 0;
                double MyD电话费 = 0;
                double MyD用餐费 = 0;
                double MyD住宿费 = 0;

                DateTime My入住日期 = (DateTime)MyRow[5];
                TimeSpan MySpan = this.截止日期DateTimePicker.Value.Subtract(My入住日期);
                MyD住宿费 = Convert.ToDouble(My折扣价格) * Math.Round(MySpan.TotalDays, 0) * My住宿人数;

                MySQL = "Select SUM(金额) From 话费入帐 Where 入住编号='" + My入住编号 + "'";
                SqlCommand MyCommand = new SqlCommand(MySQL, MyConnection);
                string My电话费 = MyCommand.ExecuteScalar().ToString();
                if (My电话费.Length > 0)
                {
                    MyD电话费 = Convert.ToDouble(My电话费);
                }

                MySQL = "Select SUM(金额) From 餐费入帐 Where 入住编号='" + My入住编号 + "'";
                MyCommand = new SqlCommand(MySQL, MyConnection);
                string My用餐费 = MyCommand.ExecuteScalar().ToString();
                if (My用餐费.Length > 0)
                {
                    MyD用餐费 = Convert.ToDouble(My用餐费);
                }

                MySQL = "Select SUM(数量*折扣价格) From 消费入帐 Where 入住编号='" + My入住编号 + "'";
                MyCommand = new SqlCommand(MySQL, MyConnection);
                string My店内消费 = MyCommand.ExecuteScalar().ToString();
                if (My店内消费.Length > 0)
                {
                    MyD店内消费 = Convert.ToDouble(My店内消费);
                }

                double MyD费用总额 = MyD住宿费 + MyD电话费 + MyD用餐费 + MyD店内消费;

                double MyD应补金额 = MyD费用总额 - Convert.ToDouble(My预收押金);

                Object[] MyCells = { My入住编号, My客人姓名, My房号, MyD应补金额.ToString(),My预收押金, 
                MyD费用总额.ToString(),MyD住宿费.ToString(),My用餐费,My店内消费,My电话费};
                this.押金DataGridView.Rows.Add(MyCells);
            }
            if (MyConnection.State == ConnectionState.Open)
            {
                MyConnection.Close();
            }
        }
    }
}