服务器之家

服务器之家 > 正文

C#实现餐饮管理系统

时间:2022-03-09 13:34     来源/作者:wxtydd123

本文实例为大家分享了C#实现餐饮管理系统的具体代码,供大家参考,具体内容如下

此系统采用C#语言的Winfrom和ADO.NET技术搭建的简单的CS系统。

部分代码:

frmBook.cs

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DAL;
 
namespace Catering
{
  public partial class frmBook : Form
  {
    public frmBook()
    {
      InitializeComponent();
    }
    public void getData()
    {
      string Filter = " WHERE 1 = 1 ";
 
      if (txtName.Text.Trim() != "")
      {
        Filter += " AND Name Like '%" + txtName.Text + "%'";
 
      }
 
      BookEntity book = new BookEntity();
      DataTable dt = book.Query(Filter);
      this.dataGridView1.DataSource = dt;
 
      for (int i = 1; i < this.dataGridView1.Columns.Count; i++)
      {
        this.dataGridView1.Columns[i].ReadOnly = true;
      }
 
    }
 
    private void frmBook_Load(object sender, EventArgs e)
    {
      getData();
    }
 
    //全选
    private void btnChose_Click(object sender, EventArgs e)
    {
      bool b = false;
      if (btnChose.Text == "全 选")
      {
        b = true;
        btnChose.Text = "取消全选";
      }
      else
      {
        b = false;
        btnChose.Text = "全 选";
      }
 
      for (int i = 0; i < this.dataGridView1.Rows.Count; i++)
      {
        dataGridView1.Rows[i].Cells[0].Value = b;
      }
      this.dataGridView1.EndEdit();
      this.dataGridView1.CurrentCell = null;
    }
 
    //删除
    private void btnDelete_Click(object sender, EventArgs e)
    {
      dataGridView1.EndEdit();
      dataGridView1.CurrentCell = null;
      DataTable dt = (DataTable)this.dataGridView1.DataSource;
      DataRow[] drs = dt.Select("选择=1");
      if (drs.Length == 0)
      {
        MessageBox.Show("请选择要删除的记录!");
        return;
      }
      foreach (DataRow dr in drs)
      {
        BookEntity book = new BookEntity();
        book.Id = Convert.ToInt32(dr["编号"].ToString());
        book.Delete();
      }
      MessageBox.Show("删除成功!");
      getData();
    }
 
    //查询
    private void btnSearch_Click(object sender, EventArgs e)
    {
      getData();
    }
 
    //双击修改
    private void dataGridView1_MouseDoubleClick(object sender, MouseEventArgs e)
    {
      if (this.dataGridView1.CurrentRow.Index > -1)
      {
        frmBookEdit frm = new frmBookEdit();
        frm.StartPosition = FormStartPosition.CenterScreen;
        
        frm.IdNo = dataGridView1.CurrentRow.Cells[1].Value.ToString();
        if (frm.ShowDialog() == DialogResult.OK)
        {
          getData();
        }
      }
    }
  }
}

frmControl.cs

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DAL;
 
namespace Catering
{
  public partial class frmControl : Form
  {
    public frmControl()
    {
      InitializeComponent();
    }
 
    private void frmControl_Load(object sender, EventArgs e)
    {
      #region 生成餐桌信息
 
      TableNoEntity table = new TableNoEntity();
      DataTable dt = table.Query(" ORDER BY DispalyIndex ");
      int x = 46;
      int y = 66;
      int width = 150;
      int height = 95;
 
      //动态生成餐台
      for (int i = 0; i < dt.Rows.Count; i = i + 5)
      {
        for (int j = 0; j < 5 && (i + j) < dt.Rows.Count; j++)
        {
          DataRow dr = dt.Rows[i + j];
          //生成餐台图片控件
          PictureBox pictureBox = new PictureBox();
          pictureBox.ContextMenuStrip = this.contextMenuStrip1;
 
          pictureBox.Image = Image.FromFile(Application.StartupPath + "\\res\\绿.gif");
          
          //判断是否有预定
          BookEntity book = new BookEntity();
          DataTable dat = book.Query(" where TableNo ='" + dr["TableNo"] + "' AND BookTime>getdate()");
          if (dat.Rows.Count > 0)
          {
            pictureBox.Image = Image.FromFile(Application.StartupPath + "\\res\\黄.gif");
          }
 
          //判断是否在使用
          OrdersEntity orders = new OrdersEntity();
          DataTable dats = orders.Query(" where TableNo ='" + dr["TableNo"] + "' and PayORnot ='否'");
 
          if (dats.Rows.Count > 0)
          {
            pictureBox.Image = Image.FromFile(Application.StartupPath + "\\res\\红.gif");
          }
          pictureBox.Location = new System.Drawing.Point(x, y);
          pictureBox.Name = "pictureBox_" + dr["TableNo"].ToString();
          pictureBox.Size = new System.Drawing.Size(width, height);
          pictureBox.TabStop = false;
          pictureBox.Visible = true;
          pictureBox.SendToBack();
          this.Controls.Add(pictureBox);
 
          //生成餐台说明信息
          Label lbl = new Label();
          lbl.Name = "lbl_" + dr["TableNo"].ToString();
          lbl.Text = dr["TableNo"].ToString() + " " + dr["SitCount"].ToString() + "座位";
          lbl.Font = new Font("宋体", 10);
          lbl.BackColor = Color.Transparent;
          lbl.Location = new Point(25, 30);
          pictureBox.Controls.Add(lbl);
 
          x = x + 200;
 
        }
 
        y = y + 150;
        x = 46;
      }
 
      #endregion
 
 
    }
 
    private void 预定ToolStripMenuItem_Click(object sender, EventArgs e)
    {
      string Name = contextMenuStrip1.SourceControl.Name;
      string[] str = Name.Split('_');
      frmBookEdit frm = new frmBookEdit();
      frm.StartPosition = FormStartPosition.CenterScreen;
 
      frm.TopMost = true;
      frm.Id = str[1];
      if (frm.ShowDialog() == DialogResult.OK)
      {
        ((PictureBox)contextMenuStrip1.SourceControl).Image = Image.FromFile(Application.StartupPath + "\\res\\黄.gif");
      }
    }
 
 
 
 
    private void 结账ToolStripMenuItem_Click(object sender, EventArgs e)
    {
      string Name = contextMenuStrip1.SourceControl.Name;
      string[] str = Name.Split('_');
      frmPayEdit frm = new frmPayEdit();
      frm.StartPosition = FormStartPosition.CenterScreen;
      //frm.TopMost = true;
      frm.Id = str[1];
      if (frm.ShowDialog() == DialogResult.OK)
      {
        ((PictureBox)contextMenuStrip1.SourceControl).Image = Image.FromFile(Application.StartupPath + "\\res\\绿.gif");
      }
 
 
    }
 
    private void 退订ToolStripMenuItem_Click(object sender, EventArgs e)
    {
 
    }
 
    private void 点菜ToolStripMenuItem1_Click(object sender, EventArgs e)
    {
      string Name = contextMenuStrip1.SourceControl.Name;
      string[] str = Name.Split('_');
      frmOrdersEdit frm = new frmOrdersEdit();
      frm.StartPosition = FormStartPosition.CenterScreen;
      frm.TopMost = true;
      frm.Id = str[1];
      if (frm.ShowDialog() == DialogResult.OK)
      {
        ((PictureBox)contextMenuStrip1.SourceControl).Image = Image.FromFile(Application.StartupPath + "\\res\\红.gif");
      }
 
    }
 
    private void btnRefesh_Click(object sender, EventArgs e)
    {
      
    }
 
 
  }
}

源码下载:C#实现餐饮管理系统

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持服务器之家。

相关文章

热门资讯

2022年最旺的微信头像大全 微信头像2022年最新版图片
2022年最旺的微信头像大全 微信头像2022年最新版图片 2022-01-10
蜘蛛侠3英雄无归3正片免费播放 蜘蛛侠3在线观看免费高清完整
蜘蛛侠3英雄无归3正片免费播放 蜘蛛侠3在线观看免费高清完整 2021-08-24
背刺什么意思 网络词语背刺是什么梗
背刺什么意思 网络词语背刺是什么梗 2020-05-22
yue是什么意思 网络流行语yue了是什么梗
yue是什么意思 网络流行语yue了是什么梗 2020-10-11
2020微信伤感网名听哭了 让对方看到心疼的伤感网名大全
2020微信伤感网名听哭了 让对方看到心疼的伤感网名大全 2019-12-26
返回顶部