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();        }      }    }  }}

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 + "http://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 + "http://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 + "http://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 + "http://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 + "http://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 + "http://res//紅.gif");      }    }    private void btnRefesh_Click(object sender, EventArgs e)    {          }  }}