frombooktoregisterform.cs

宾馆酒店管理系统 Visual Studio 2005 + SQL Server 2005

//文件名：FromBookToRegisterForm.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 FromBookToRegisterForm : Form
    {
        public FromBookToRegisterForm()
        {
            InitializeComponent();
        }
        public string MyOperator;
        public String MyCompany;
        public string My预约编号;
        private void FromBookToRegisterForm_Load(object sender, EventArgs e)
        {
            //显示酒店预约房间信息
            this.酒店预约房间DataGridView.GridColor = Color.Blue;
            String MySQLConnectionString = global::MyHotel.Properties.Settings.Default.MyHotelConnectionString;
            string MySQL = "Select 房号,客人姓名,住宿人数,预收押金,客人性别,联系电话,入住日期,离开日期,预约编号 From 客房预约单 Where 入住编号 IS NULL";
            SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
            MyConnection.Open();
            DataTable MyTable = new DataTable();
            SqlDataAdapter MyAdapter = new SqlDataAdapter(MySQL, MyConnection);
            MyAdapter.Fill(MyTable);
            this.酒店预约房间DataGridView.DataSource = MyTable;
            if (MyConnection.State == ConnectionState.Open)
            {
                MyConnection.Close();
            }
        }
        private void 酒店预约房间DataGridView_Click(object sender, EventArgs e)
        {
            this.房号TextBox.Text = this.酒店预约房间DataGridView.CurrentRow.Cells[0].Value.ToString();
            this.客人姓名TextBox.Text = this.酒店预约房间DataGridView.CurrentRow.Cells[1].Value.ToString();
            this.住宿人数TextBox.Text = this.酒店预约房间DataGridView.CurrentRow.Cells[2].Value.ToString();
            this.预收押金TextBox.Text = this.酒店预约房间DataGridView.CurrentRow.Cells[3].Value.ToString();
            this.客人性别TextBox.Text = this.酒店预约房间DataGridView.CurrentRow.Cells[4].Value.ToString();
            this.联系电话TextBox.Text = this.酒店预约房间DataGridView.CurrentRow.Cells[5].Value.ToString();
            this.入住日期DateTimePicker.Value = (DateTime)this.酒店预约房间DataGridView.CurrentRow.Cells[6].Value ;
            this.离开日期DateTimePicker.Value = (DateTime)this.酒店预约房间DataGridView.CurrentRow.Cells[7].Value;
            this.My预约编号 = this.酒店预约房间DataGridView.CurrentRow.Cells[8].Value.ToString();
        }

        private void 新增Button_Click(object sender, EventArgs e)
        {
            this.房号TextBox.Text = "";
            this.折扣价格TextBox.Text = "";
            this.预收押金TextBox.Text = "";
            this.入住日期DateTimePicker.Value = DateTime.Now;
            this.离开日期DateTimePicker.Value = DateTime.Now;
            this.客人姓名TextBox.Text = "";
            this.证件名称ComboBox.Text = "居民身份证";
            this.证件号码TextBox.Text = "";
            this.证件地址TextBox.Text = "";
            this.住宿人数TextBox.Text = "0";
            this.客人性别TextBox.Text = "男";
            this.联系电话TextBox.Text = "";
            this.操作人员TextBox.Text = this.MyOperator;
            //自动计算入住编号
            String MySQLConnectionString = global::MyHotel.Properties.Settings.Default.MyHotelConnectionString;
            SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
            MyConnection.Open();
            SqlCommand MyCommand = MyConnection.CreateCommand();
            MyCommand.CommandText = "Select max(入住编号) 最大编号 From 客房入住单";
            object MyResult = MyCommand.ExecuteScalar();
            Int64 MyID = 1;
            if (MyResult != System.DBNull.Value)
            {
                String MyMaxID = MyResult.ToString().Trim();
                MyMaxID = MyMaxID.Substring(2, MyMaxID.Length - 2);
                MyID = Convert.ToInt64(MyMaxID) + 1;
            }
            int MyLength = MyID.ToString().Length;
            string MyNewID = "";
            switch (MyLength)
            {
                case 1:
                    MyNewID = "RZ0000000" + MyID.ToString();
                    break;
                case 2:
                    MyNewID = "RZ000000" + MyID.ToString();
                    break;
                case 3:
                    MyNewID = "RZ00000" + MyID.ToString();
                    break;
                case 4:
                    MyNewID = "RZ0000" + MyID.ToString();
                    break;
                case 5:
                    MyNewID = "RZ000" + MyID.ToString();
                    break;
                case 6:
                    MyNewID = "RZ00" + MyID.ToString();
                    break;
                case 7:
                    MyNewID = "RZ0" + MyID.ToString();
                    break;
            }
            if (MyConnection.State == ConnectionState.Open)
            {
                MyConnection.Close();
            }
            this.入住编号TextBox.Text = MyNewID;          
        }

        private void 打印Button_Click(object sender, EventArgs e)
        {
            this.printPreviewDialog1.Document = this.printDocument1;
            this.printPreviewDialog1.ShowDialog();
        }

        private void 保存Button_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("请检查旅客信息是否正确，一旦保存就无法修改，是否继续？", "信息提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
            {
                return;
            }
            String MySQLConnectionString = global::MyHotel.Properties.Settings.Default.MyHotelConnectionString;
            string MySQL = "INSERT INTO [客房入住单] ([入住编号], [房号], [折扣价格], [预收押金], [入住日期], [离开日期], [客人姓名], [证件名称], [证件号码], [证件地址], [住宿人数], [客人性别], [联系电话], [操作人员]) VALUES (@入住编号, @房号, @折扣价格, @预收押金, @入住日期, @离开日期, @客人姓名,@证件名称, @证件号码, @证件地址, @住宿人数, @客人性别, @联系电话, @操作人员)";
            SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
            MyConnection.Open();
            SqlCommand MyCommand = MyConnection.CreateCommand();
            MyCommand.CommandText = MySQL;
            MyCommand.Parameters.Add(new SqlParameter("@入住编号", SqlDbType.VarChar));
            MyCommand.Parameters.Add(new SqlParameter("@房号", SqlDbType.VarChar));
            MyCommand.Parameters.Add(new SqlParameter("@折扣价格", SqlDbType.Float));
            MyCommand.Parameters.Add(new SqlParameter("@预收押金", SqlDbType.Float));
            MyCommand.Parameters.Add(new SqlParameter("@入住日期", SqlDbType.DateTime));
            MyCommand.Parameters.Add(new SqlParameter("@离开日期", SqlDbType.DateTime));
            MyCommand.Parameters.Add(new SqlParameter("@客人姓名", SqlDbType.VarChar));
            MyCommand.Parameters.Add(new SqlParameter("@证件名称", SqlDbType.VarChar));
            MyCommand.Parameters.Add(new SqlParameter("@证件号码", SqlDbType.VarChar));
            MyCommand.Parameters.Add(new SqlParameter("@证件地址", SqlDbType.VarChar));
            MyCommand.Parameters.Add(new SqlParameter("@住宿人数", SqlDbType.Int));
            MyCommand.Parameters.Add(new SqlParameter("@客人性别", SqlDbType.VarChar));
            MyCommand.Parameters.Add(new SqlParameter("@联系电话", SqlDbType.VarChar));
            MyCommand.Parameters.Add(new SqlParameter("@操作人员", SqlDbType.VarChar));

            MyCommand.Parameters["@入住编号"].Value = this.入住编号TextBox.Text;
            MyCommand.Parameters["@房号"].Value = this.房号TextBox.Text;
            MyCommand.Parameters["@折扣价格"].Value = this.折扣价格TextBox.Text;
            MyCommand.Parameters["@预收押金"].Value = this.预收押金TextBox.Text;
            MyCommand.Parameters["@入住日期"].Value = this.入住日期DateTimePicker.Value;
            MyCommand.Parameters["@离开日期"].Value = this.离开日期DateTimePicker.Value;
            MyCommand.Parameters["@客人姓名"].Value = this.客人姓名TextBox.Text;
            MyCommand.Parameters["@证件名称"].Value = this.证件名称ComboBox.Text;
            MyCommand.Parameters["@证件号码"].Value = this.证件号码TextBox.Text;
            MyCommand.Parameters["@证件地址"].Value = this.证件地址TextBox.Text;
            MyCommand.Parameters["@住宿人数"].Value = this.住宿人数TextBox.Text;
            MyCommand.Parameters["@客人性别"].Value = this.客人性别TextBox.Text;
            MyCommand.Parameters["@联系电话"].Value = this.联系电话TextBox.Text;
            MyCommand.Parameters["@操作人员"].Value = this.操作人员TextBox.Text;
            MyCommand.ExecuteNonQuery();
            MySQL = "Update 客房预约单 Set 入住编号='" + this.入住编号TextBox.Text + "' WHERE 预约编号='" + this.My预约编号 + "'";
            MyCommand.CommandText = MySQL;
            MyCommand.ExecuteNonQuery();
            if (MyConnection.State == ConnectionState.Open)
            {
                MyConnection.Close();
            }
            FromBookToRegisterForm_Load(null, null);
           新增Button_Click(null, null);
        }

        private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
        {
            //打印入住单
            e.Graphics.DrawString(this.MyCompany + "旅客入住单", new Font("宋体", 20), Brushes.Black, 220, 80);
            e.Graphics.DrawString("入住编号：" + this.入住编号TextBox.Text, new Font("宋体", 12), Brushes.Black, 100, 150);
            DateTime MyPrintTime = DateTime.Now;
            e.Graphics.DrawString("打印日期：" + MyPrintTime.ToLongDateString() + MyPrintTime.ToLongTimeString(), new Font("宋体", 12), Brushes.Black, 450, 150);
            e.Graphics.DrawLine(new Pen(Color.Black), 100, 180, 720, 180);
            e.Graphics.DrawLine(new Pen(Color.Black), 100, 220, 720, 220);
            e.Graphics.DrawLine(new Pen(Color.Black), 100, 260, 720, 260);
            e.Graphics.DrawLine(new Pen(Color.Black), 100, 300, 720, 300);
            e.Graphics.DrawLine(new Pen(Color.Black), 100, 340, 720, 340);

            e.Graphics.DrawLine(new Pen(Color.Black), 100, 180, 100, 340);
            e.Graphics.DrawLine(new Pen(Color.Black), 220, 180, 220, 340);
            e.Graphics.DrawLine(new Pen(Color.Black), 400, 180, 400, 340);
            e.Graphics.DrawLine(new Pen(Color.Black), 720, 180, 720, 340);

            e.Graphics.DrawString("房号：" + this.房号TextBox.Text, new Font("宋体", 12), Brushes.Black, 105, 190);
            e.Graphics.DrawString("姓名：" + this.客人姓名TextBox.Text, new Font("宋体", 12), Brushes.Black, 105, 230);
            e.Graphics.DrawString("性别：" + this.客人性别TextBox.Text, new Font("宋体", 12), Brushes.Black, 105, 270);
            e.Graphics.DrawString("人数：" + this.住宿人数TextBox.Text, new Font("宋体", 12), Brushes.Black, 105, 310);

            e.Graphics.DrawString("折扣价格：" + this.折扣价格TextBox.Text, new Font("宋体", 12), Brushes.Black, 225, 190);
            e.Graphics.DrawString("预收押金：" + this.预收押金TextBox.Text, new Font("宋体", 12), Brushes.Black, 225, 230);
            if (this.入住日期DateTimePicker.Value.ToString().Length > 0)
            {
                e.Graphics.DrawString("入住日期：" + this.入住日期DateTimePicker.Value.ToString().Remove(10), new Font("宋体", 12), Brushes.Black, 225, 270);
            }
            if (this.离开日期DateTimePicker.Value.ToString().Length > 0)
            {
                e.Graphics.DrawString("离开日期：" + this.离开日期DateTimePicker.Value.ToString().Remove(10), new Font("宋体", 12), Brushes.Black, 225, 310);
            }
            e.Graphics.DrawString("证件名称：" + this.证件名称ComboBox.Text, new Font("宋体", 12), Brushes.Black, 405, 190);
            e.Graphics.DrawString("证件编号：" + this.证件号码TextBox.Text, new Font("宋体", 12), Brushes.Black, 405, 230);
            e.Graphics.DrawString("证件地址：" + this.证件地址TextBox.Text, new Font("宋体", 12), Brushes.Black, 405, 270);
            e.Graphics.DrawString("联系电话：" + this.联系电话TextBox.Text, new Font("宋体", 12), Brushes.Black, 405, 310);

            e.Graphics.DrawString("操作员：" + this.操作人员TextBox.Text, new Font("宋体", 12), Brushes.Black, 600, 350);

            e.Graphics.DrawString("温馨提示：为了维护您及他人的合法权益，请不要带未经登记的人员进出您的房间。", new Font("宋体", 12), Brushes.Black, 100, 380);
            e.Graphics.DrawString("警察提示：请保管好您的物品，重要物品请寄存于酒店寄存处，免费寄存！", new Font("宋体", 12), Brushes.Black, 100, 420);
            e.Graphics.DrawString("谢谢合作!", new Font("宋体", 20), Brushes.Black, 550, 460);
        }


    }
}