酒店管理系统（C#和serverSql代码开发）

最新推荐文章于 2024-07-23 10:18:09 发布

HalfCarambola

最新推荐文章于 2024-07-23 10:18:09 发布

阅读量3.1k

点赞数 12

文章标签： c# winform 数据库

本文链接：https://blog.csdn.net/HalfCarambola/article/details/104336662

版权

本文档详细介绍了使用C#语言和SQL Server数据库开发的酒店管理系统的各个模块，包括主页、登陆界面、用户控件、客房状态、入住客户、订单管理、小商品销售、营业额统计等功能，并提供了相关代码示例。作为一个新手的作品，作者分享了完整的源码供下载学习。

摘要由CSDN通过智能技术生成

该程序由C#和serverSql完成，给大家分享下我的C#代码
我是新手，代码不够规范之处请多多包涵！！！🤞🤞🤞

可以下载我打包好的源码：酒店管理程序源码下载

1.主页：

程序的主界面
代码如下：

public partial class Homepage : Form
    {
   
        private Label label = null;
        public Homepage()
        {
   
            InitializeComponent();
            this.homeInterface1.BringToFront();
        }

        /// <summary>
        /// 让鼠标移入缩小/退出时控件发生变化
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void LabelMouseMove(object sender, MouseEventArgs e)
        {
   
            label = (Label)sender;
            if (label.Name.Equals(this.label1.Name))
            {
   
                this.label1.BackColor = Color.White;
                this.label1.ForeColor = Color.Crimson;
            }
            else if (label.Name.Equals(this.label2.Name))
            {
   
                this.label2.BackColor = Color.White;
                this.label2.ForeColor = Color.Crimson;
            }
        }

        /// <summary>
        /// 让鼠标移出缩小/退出时控件发生变化
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void LabelMouseLeave(object sender, EventArgs e)
        {
   
            label = (Label)sender;
            if (label.Name.Equals(this.label1.Name))
            {
   
                this.label1.BackColor = Color.Transparent;
                this.label1.ForeColor = Color.White;
            }
            else if (label.Name.Equals(this.label2.Name))
            {
   
                this.label2.BackColor = Color.Transparent;
                this.label2.ForeColor = Color.White;
            }
        }

        /// <summary>
        /// 点击按钮时发生的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ButtonClick(object sender, EventArgs e)
        {
   
            Button button = (Button)sender;
            if (button.Name.Equals(this.skinButton1.Name))
            {
   
                this.homeInterface1.BringToFront();
                homeInterface1.TheRefresh();
            }
            else if (button.Name.Equals(this.skinButton2.Name))
            {
   
                this.situation2.BringToFront();
                situation2.TextBox1_TextChanged(sender,e);
            }
            else if (button.Name.Equals(this.skinButton3.Name))
            {
   
                this.clients1.BringToFront();
            }
            else if (button.Name.Equals(this.skinButton4.Name))
            {
   
                this.theorder1.BringToFront();
            }
            else if (button.Name.Equals(this.skinButton5.Name))
            {
   
                this.goods1.BringToFront();
            }
            else if (button.Name.Equals(this.skinButton6.Name))
            {
   
                this.turnover1.BringToFront();
                turnover1.TheRefresh();
            }
        }

        /// <summary>
        /// 点击退出按钮时发生的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Label2_Click(object sender, EventArgs e)
        {
   
            if (MessageBox.Show("确定要退出本应用程序吗", "温馨提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
   
                Application.Exit();
            }
        }

        /// <summary>
        /// 点击缩小按钮时发生的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Label1_Click(object sender, EventArgs e)
        {
   
            this.WindowState =FormWindowState.Minimized;
        }

        private void Timer1_Tick(object sender, EventArgs e)
        {
   
            this.label3.Text = DateTime.Now.ToString("HH:mm:ss");
        }
    }

2.登陆界面

登录界面设计的比较简陋

代码如下：

public partial class Login : Form
    {
   
        private Post post = new Post();
        public Login()
        {
   
            InitializeComponent();
        }

        /// <summary>
        /// 退出
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Button1_Click(object sender, EventArgs e)
        {
   
            Application.Exit();
        }

        /// <summary>
        /// 登录
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Button2_Click(object sender, EventArgs e)
        {
   
            if (String.IsNullOrEmpty(this.textBox1.Text.Trim()) || String.IsNullOrEmpty(this.textBox2.Text.Trim()))
            {
   
                MessageBox.Show("不能为空","温馨提示",MessageBoxButtons.YesNo,MessageBoxIcon.Information);
                return;
            }
            else
            {
   
                bool en = false;
                foreach(DataRow row in post.set.Tables[9].Rows)
                {
   
                    if (row["adminid"].ToString().Equals(this.textBox1.Text.Trim().ToString()) && row["adminpwd"].ToString().Equals(this.textBox2.Text.Trim().ToString()))
                    {
   
                        en = true;
                    }
                }
                if (en)
                {
   
                    this.Hide();
                    Homepage home = new Homepage();
                    home.Show();
                }
                else
                {
   
                    MessageBox.Show("没有该管理员，请重新输入","温馨提示");
                }
            }
        }
    }

3.主页用户控件

用户控件是自定义控件，为灰色部分
在这里插入图片描述
代码如下：

public partial class HomeInterface : UserControl
    {
   
        
        private DB_sql sql = new DB_sql("Hotel");
        private Post post = null;
        private ListViewItem item = null;
        public HomeInterface()
        {
   
            InitializeComponent();
            TheRefresh();
            Bind();
        }
  
        /// <summary>
        /// 刷新客房视图
        /// </summary>
        public void TheRefresh()
        {
   
            listView1.Items.Clear();
            post = new Post();
            DataTable room = post.set.Tables[0];
            foreach(DataRow row in room.Rows)
            {
   
                item = new ListViewItem();
                item.Text = row["roomid"].ToString();
                if (row["Happeningname"].ToString().Equals("空净"))
                {
   
                    item.ImageIndex = 0;
                }else if (row["Happeningname"].ToString().Equals("空脏"))
                {
   
                    item.ImageIndex = 2;
                }
                else if (row["Happeningname"].ToString().Equals("已入住"))
                {
   
                    item.ImageIndex = 1;
                }
                this.listView1.Items.Add(item);
            }
        }

        /// <summary>
        /// 检查是否有空值
        /// </summary>
        /// <returns></returns>
        private bool Empty()
        {
   
            if(String.IsNullOrEmpty(this.textBox1.Text.Trim())|| String.IsNullOrEmpty(this.textBox2.Text.Trim())|| String.IsNullOrEmpty(this.textBox3.Text.Trim())|| String.IsNullOrEmpty(this.metroComboBox2.Text.Trim())|| String.IsNullOrEmpty(this.metroComboBox4.Text.Trim())|| String.IsNullOrEmpty(this.metroDateTime1.Text.Trim()))
            {
   
                return false;
            }
            return true;
        }

        /// <summary>
        /// 当点击结算按钮时发生
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void SkinButton1_Click(object sender, EventArgs e)
        {
   
            string fice = "select count(*) from room where roomid="+this.textBox1.Text.Trim()+" and typeid="+this.metroComboBox2.SelectedValue;
            string grid = "select Happeningid from room where roomid=" + this.textBox1.Text.Trim() + " and typeid=" + this.metroComboBox2.SelectedValue;
            if (Empty())
            {
   
                if (this.metroComboBox2.Text.Equals(typele.标准单人间.ToString())|| this.metroComboBox2.Text.Equals(typele.标准双人间.ToString()) || this.metroComboBox2.Text.Equals(typele.标准大床房.ToString()) || this.metroComboBox2.Text.Equals(typele.豪华总统套房.ToString())