使用C#怎么編寫一個餐飲管理系統?針對這個問題,這篇文章詳細介紹了相對應的分析和解答,希望可以幫助更多想解決這個問題的小伙伴找到更簡單易行的方法。
frmBook.cs
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
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#怎么編寫一個餐飲管理系統問題的解答就分享到這里了,希望以上內容可以對大家有一定的幫助,如果你還有很多疑惑沒有解開,可以關注億速云行業資訊頻道了解更多相關知識。
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。