C#餐厅管理系统5--餐桌和职员

C#餐厅管理系统6--呼叫管理员！         地址：点击打开链接

C#餐厅管理系统5--餐桌和职员            地址：点击打开链接

C#餐厅管理系统4--增删改查！            地址：点击打开链接

C#餐厅管理系统3--MAIN窗口              地址：点击打开链接

C#餐厅管理系统2--数据连接及登录     地址：点击打开链接

C#餐厅管理系统1--ER图                      地址：点击打开链接

 

 源码下载地址：点击打开下载地址

 

此节来实现餐桌和职员的增删改查。

首先来看下餐桌的设计窗口：

 

这个设计窗口最下面是GridView控件。用来读取存放从数据库中的数据。

 

接下来介绍下BandDate()的作用。这个用来每次的添加、删除、修改后实现自动刷新数据。

 

直接贴餐桌代码：

 public partial class Desk : Form
    {
        public Desk()
        {
            InitializeComponent();
        }

        private void Desk_Load(object sender, EventArgs e)
        {
            BandDate();

        }
        private void BandDate()
        {
            SqlConnection conn = BaseClass.DBConn.SaylnConn();
            conn.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select roomName,roomJC,roomBJF,roomWZ,roomType,roomRemark from tb_Room", conn);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
            conn.Close();
            btnAdd.Enabled = true;
            btnAlt.Enabled = false;
            btnDel.Enabled = false;
        }

        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            txtRName.Text = dataGridView1.SelectedCells[0].Value.ToString();
            txtRJianCheng.Text = dataGridView1.SelectedCells[1].Value.ToString();
            txtRBJF.Text = dataGridView1.SelectedCells[2].Value.ToString();
            txtRWeiZhi.Text = dataGridView1.SelectedCells[3].Value.ToString();
            txtRType.Text = dataGridView1.SelectedCells[4].Value.ToString();
            txtRRemark.Text = dataGridView1.SelectedCells[5].Value.ToString();
            btnAdd.Enabled = false;
            btnAlt.Enabled = true;
            btnDel.Enabled = true;
        }

        private void btnClr_Click(object sender, EventArgs e)
        {
            txtRName.Text = "";
            txtRJianCheng.Text = "";
            txtRBJF.Text = "";
            txtRQiTa.Text = "";
            txtRRemark.Text = "";
            txtRType.Text = "";
            txtRWeiZhi.Text = "";
            btnAdd.Enabled = true;
            btnAlt.Enabled = false;
            btnDel.Enabled = false;
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            SqlConnection conn = BaseClass.DBConn.SaylnConn();
            conn.Open();
            SqlCommand  cmd = new SqlCommand("insert into tb_Room(roomName,roomJC,roomBJF,roomWZ,roomZT,roomType,roomRemark,roomQT) values('"+txtRName.Text +"','"+txtRJianCheng.Text+"','"+txtRBJF.Text+"','"+txtRWeiZhi.Text+"','待用','"+txtRType.Text+"','"+txtRRemark.Text+"','"+txtRQiTa.Text+"')",conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            BandDate();
        }

        private void btnDel_Click(object sender, EventArgs e)
        {
            SqlConnection conn = BaseClass.DBConn.SaylnConn();
            conn.Open();
            SqlCommand cmd = new SqlCommand("delete from tb_Room where roomJC='" + dataGridView1.SelectedCells[1].Value.ToString() + "'", conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            BandDate();
        }

        private void btnAlt_Click(object sender, EventArgs e)
        {
            SqlConnection conn = BaseClass.DBConn.SaylnConn();
            conn.Open();
            SqlCommand cmd = new SqlCommand("update tb_Room set roomName='" + txtRName.Text + "',roomJC='" + txtRJianCheng.Text + "',roomBJF='" + txtRBJF.Text + "',roomWZ='" + txtRWeiZhi.Text + "',roomType='" + txtRType.Text + "',roomRemark='" + txtRRemark.Text + "',roomQT='" + txtRQiTa + "' where roomJC='" + dataGridView1.SelectedCells[1].Value.ToString() + "'", conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            BandDate();
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

接下来是职员，职员的窗口设计图省略，代码如下：

public partial class Waiter : Form
    {
        public Waiter()
        {
            InitializeComponent();           
        }

        private void BandData()
        {
            SqlConnection conn = BaseClass.DBConn.SaylnConn();
            conn.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select waiterName,waiterNum,cardNum,sex,age,tel from tb_Waiter order by waiterID desc",conn);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
            conn.Close();
        }

        private void Waiter_Load(object sender, EventArgs e)
        {
            BandData();
            btnAdd.Enabled = true;
            btnAlt.Enabled = false;
            btnDel.Enabled = false;
        }

        private void button4_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            SqlConnection conn = BaseClass.DBConn.SaylnConn();
            conn.Open();
            SqlCommand cmd = new SqlCommand("insert into tb_Waiter(waiterName,waiterNum,cardNum,sex,age,tel) values('" + txtWName.Text + "','" + txtWNum.Text + "','" + txtWCardNum.Text + "','" + txtWSex.Text + "','" + txtWAge.Text + "','" + txtWTel.Text + "')", conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            BandData();
        }

        private void btnClr_Click(object sender, EventArgs e)
        {
            txtWTel.Text = "";
            txtWSex.Text = "";
            txtWNum.Text = "";
            txtWName.Text = "";
            txtWCardNum.Text = "";
            txtWAge.Text = "";
            btnAdd.Enabled = true;
            btnAlt.Enabled = false;
            btnDel.Enabled = false;
        }

        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            txtWName.Text = dataGridView1.SelectedCells[0].Value.ToString();
            txtWNum.Text = dataGridView1.SelectedCells[1].Value.ToString();
            txtWCardNum.Text = dataGridView1.SelectedCells[2].Value.ToString();
            txtWSex.Text = dataGridView1.SelectedCells[3].Value.ToString();
            txtWAge.Text = dataGridView1.SelectedCells[4].Value.ToString();
            txtWTel.Text = dataGridView1.SelectedCells[5].Value.ToString();
            btnAdd.Enabled = false;
            btnAlt.Enabled = true;
            btnDel.Enabled = true;
        }

        private void btnDel_Click(object sender, EventArgs e)
        {
            SqlConnection conn = BaseClass.DBConn.SaylnConn();
            conn.Open();
            SqlCommand cmd = new SqlCommand("delete from tb_Waiter where cardNum='" + dataGridView1.SelectedCells[2].Value.ToString() + "'", conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            BandData();
        }

        private void btnAlt_Click(object sender, EventArgs e)
        {
            SqlConnection conn = BaseClass.DBConn.SaylnConn();
            conn.Open();
            SqlCommand cmd = new SqlCommand("update tb_Waiter set waiterName='" + txtWName.Text + "',waiterNum='" + txtWNum.Text + "',sex='"+txtWSex.Text+"',tel='" + txtWTel.Text + "' where cardNum='" + dataGridView1.SelectedCells[2].Value.ToString() + "'", conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            BandData();
        }

 

源码下载地址：点击打开下载地址