frmroominfo.cs

利用vs2008+sql开发的酒店管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using HotelManageDBL;
using HotelManageMDL;

namespace HotelManager
{
    public partial class frmRoomInfo : Form
    {
        DataSet ds = new DataSet();
        RoomDB rDB = new RoomDB();
        Room r = new Room();
        RoomType rt = new RoomType();
        RoomTypeDB rtDB = new RoomTypeDB();
        
        
        public frmRoomInfo()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void frmRoomInfo_Load(object sender, EventArgs e)
        {
            SelectAll();
            this.toolStripButton2.Enabled = false;
            this.toolStripButton4.Enabled = false;
        }
        /// <summary>
        /// 新增按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            UnLock();
            Clear();
            CboBing();
            this.toolStripButton4.Enabled = true;
            
            
        }
        /// <summary>
        /// 修改按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void toolStripButton2_Click(object sender, EventArgs e)
        {
            IsEmpty();
            RoomObject();
            RoomTypeObject();
            bool flag;
            try
            {
                
                flag = rDB.UpdateRoom(rt,r);
                if (flag)
                {
                    MessageBox.Show("修改成功！", "修改", MessageBoxButtons.OK, MessageBoxIcon.None);
                    Clear();
                }
                else
                {
                    MessageBox.Show("修改失败！", "修改", MessageBoxButtons.OK, MessageBoxIcon.None);
                }
            }
            catch(Exception ex)
            {
                MessageBox.Show("修改失败！" + ex.Message, "修改", MessageBoxButtons.OK, MessageBoxIcon.None);   
            }
            frmRoomInfo_Load(this,e);
            Clear();
            SelectAll();
            Lock();

        }
        /// <summary>
        /// 删除按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void toolStripButton3_Click(object sender, EventArgs e)
        {
          
            try
            {
                r.RoomID = int.Parse(dataGridView1.SelectedCells[0].Value.ToString());
                rDB.DeleteRoom(r.RoomID);
            }
            catch
            {
                MessageBox.Show("删除失败！", "删除", MessageBoxButtons.OK, MessageBoxIcon.None);
                return;
            }

                MessageBox.Show("删除成功！", "删除", MessageBoxButtons.OK, MessageBoxIcon.None);
            
            SelectAll();
        }
        /// <summary>
        /// 保存按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void toolStripButton4_Click(object sender, EventArgs e)
        {
            IsEmpty();
            r.Number = txtNumber.Text.Trim();
            r.TypeID = cboTypeName.SelectedIndex + 1;
            r.GuestNumber = int.Parse(txtGuestNumber.Text.Trim());
            r.BedNumber = int.Parse(txtBedNumber.Text.Trim());
            r.State = cboState.Text; ;
            r.Discription = txtDiscription.Text.Trim();
            bool flag = rDB.InsertRoom(r);
            if (flag)
            {
                MessageBox.Show("保存成功！","保存",MessageBoxButtons.OK,MessageBoxIcon.None);
            }
            else
            {
                MessageBox.Show("保存失败！", "保存", MessageBoxButtons.OK, MessageBoxIcon.None);
            }
            frmRoomInfo_Load(this,e);
            Clear();
            Lock();

        }
        /// <summary>
        /// 取消按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void toolStripButton5_Click(object sender, EventArgs e)
        {
            Lock();
        }
        /// <summary>
        /// 退出按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void toolStripButton6_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("是否真的要退出？", "友情提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                this.Close();
            }
        }
        /// <summary>
        /// 按房间号查询按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            string roomNum = txtRoomNum.Text;
            if (roomNum == "")
            {
                MessageBox.Show("房间号不能为空，请输入", "友情提示",MessageBoxButtons.OK,MessageBoxIcon.None);
                return;
            }
            ds.Tables[0].Clear();
            ds = rDB.SelectByRoomId(roomNum);
            if (ds != null)
            {
                dataGridView1.DataSource = ds.Tables[0];
            }
            else
            {
                MessageBox.Show("对不起，您查找的类型不存在！", "友情提示", MessageBoxButtons.OK, MessageBoxIcon.None);
            }
        }
        /// <summary>
        /// 在选中的行的值设置到相应的文本框中
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dataGridView1_Click(object sender, EventArgs e)
        {
            UnLock();
            CboBing();
            try
            {
                int roomID = int.Parse(dataGridView1.SelectedCells[0].Value.ToString());
                txtNumber.Text = dataGridView1.SelectedCells[1].Value.ToString();
                cboTypeName.Text = dataGridView1.SelectedCells[2].Value.ToString();
                txtPrice.Text = dataGridView1.SelectedCells[3].Value.ToString(); 
                txtBedNumber.Text = dataGridView1.SelectedCells[5].Value.ToString();
                txtGuestNumber.Text = dataGridView1.SelectedCells[4].Value.ToString();
                cboState.Text = dataGridView1.SelectedCells[6].Value.ToString();
                txtDiscription.Text = dataGridView1.SelectedCells[7].Value.ToString();
                this.toolStripButton4.Enabled = false;
                this.toolStripButton2.Enabled = true;
                
                
                
            }
            catch { }
        }
        /// <summary>
        /// 锁定文本框的方法
        /// </summary>
        public void Lock()
        {
            txtNumber.Enabled = false;
            cboTypeName.Enabled = false;
            txtPrice.Enabled = false;
            txtGuestNumber.Enabled = false;
            txtBedNumber.Enabled = false;
            txtDiscription.Enabled = false;
            cboState.Enabled = false;
        }
        /// <summary>
        /// 解锁的方法
        /// </summary>
        public void UnLock()
        {
            txtNumber.Enabled = true;
            cboTypeName.Enabled = true;
            txtPrice.Enabled = true;
            txtGuestNumber.Enabled = true;
            txtBedNumber.Enabled = true;
            txtDiscription.Enabled = true;
            cboState.Enabled = true;
        }
        /// <summary>
        /// 清空文本的方法
        /// </summary>
        public void Clear()
        {
            txtNumber.Clear();
            cboTypeName.Text="";
            txtPrice.Clear();
            txtGuestNumber.Clear();
            txtBedNumber.Clear();
            txtDiscription.Clear();
            cboState.Text="";
        }

        /// <summary>
        /// 查找所有的方法
        /// </summary>
        public void SelectAll()
        {
            try
            {
                ds = rDB.SelectRoom();
                if (ds != null)
                {
                    this.dataGridView1.DataSource = ds.Tables["RoomInfo"];
                }
            }
            catch(Exception ex)
            {
                MessageBox.Show("查找失败"+ex.Message);
            }
           
        }
        /// <summary>
        /// 文本框非空判断
        /// </summary>
        public void IsEmpty()
        {
            if (txtNumber.Text == "")
            {
                MessageBox.Show("房间号不能为空!");
                return;
            }
            if (txtPrice.Text == "")
            {
                MessageBox.Show("价格不能为空!");
                return;
            }
            if (txtGuestNumber.Text == "")
            {
                MessageBox.Show("入住人数能为空!");
                return;
            }
            if (txtBedNumber.Text == "")
            {
                MessageBox.Show("床位号不能为空!");
                return;
                
            }
            if (txtDiscription.Text == "")
            {
                MessageBox.Show("描述不能为空!");
                return;
            }
           
        }

        /// <summary>
        /// 封装Room方法
        /// </summary>
        public void RoomObject()
        {
            r.RoomID = int.Parse(dataGridView1.SelectedCells[0].Value.ToString());
            r.Number = txtNumber.Text.Trim();
            r.TypeID = cboTypeName.SelectedIndex + 1;
            r.GuestNumber = int.Parse(txtGuestNumber.Text.Trim());
            r.BedNumber = int.Parse(txtBedNumber.Text.Trim());
            r.State = cboState.Text; ;
            r.Discription = txtDiscription.Text.Trim();
        }
        /// <summary>
        /// 封装RoomType的方法
        /// </summary>
        public void RoomTypeObject()
        {
            rt.TypeName = cboTypeName.Text;
            rt.TypePrice = Convert.ToDouble(txtPrice.Text);
            

        }

        /// <summary>
        /// 将roomType中的字段与下拉列表框绑定
        /// </summary>
        public void CboBing()
        {
             
            ds = rtDB.SelectRoomType();
            cboTypeName.Items.Clear();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                cboTypeName.Items.Add(dr[1]);
            }
            
        }
    }
}