点菜系统源码(c# +ms sql server 2012数据库)

【实例截图】

【核心代码】

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Collections;
using Common;
using BLL;

namespace CyManager
{
    //添加消费表
    public partial class UFBillConsume : Form
    {
        float money = 0;//存储消费列表中的金额值
        List<string> lcMenu = new List<string>();//存储拖动选中项的详细信息
        ListViewItem lvicMenu = new ListViewItem();//存储在菜单列表中的选中项
        MyListViewItem lvicbillMenu = new MyListViewItem();//存储在消费列表中的选中项
        public static string tName;
        /// <summary>
        /// 刷新消费明细和消费金额的事件
        /// </summary>
        public event Del EveNewBillListAndMoney;
        public UFBillConsume()
        {
            InitializeComponent();
        }

   // public event Del Eve
        List<CMenus> lm = new List<CMenus>();//存储所有菜单信息

        private void UBillConsume_Load(object sender, EventArgs e)
        {
            this.txtCaiPing.Focus();//清空
            // //查询该单的消费金额
            if (UFOpenBill.formType == 1)
            {
                money = Convert.ToSingle(BLLRooms.BLLRoomsFangHuiMoney(BLLRooms.BLLRoomsTNameFHID(UFBillConsume .tName )));
                this.tslblTName.Text = "餐台"   Zhu.lvSelect.Text   "  消费清单";
            }
            else
            {
                money = Convert.ToSingle(BLLRooms.BLLRoomsFangHuiMoney(Zhu.lvSelect.rtzdId));
                this.tslblTName.Text = "餐台"   Zhu.lvSelect.Text   "  消费清单";
            }

            UFBillConsumeMenusQuery();
           //查询所有菜单类型
            List<CMenuType>lmt = new List<CMenuType>();
            try
            {
                lmt = BLLMenuType.BLLMenuTypeQuerg();

            }
            catch (Exception)
            {
                MessageBox.Show("菜单类型查询失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            foreach (CMenuType cmt in lmt)
            {
                TreeNode node = new TreeNode();
                node .Text =cmt.MtName ;
                node.Tag = cmt.MtId;
                this.tvMenus.Nodes.Add(node );
                this.UFBillConsumeMenusTypeNode(node);//调用 查询传入节点下的所有子节点的方法,查询传入节点下的所有子节点
            }
            QueryBillId();//调用查询开单编号的消费明细的方法
            GetSumNumMoney();
        }
        /// <summary>
        /// 查询开单编号的消费明细的方法
        /// </summary>
        public void QueryBillId()
        {
            this.lvBillLists.Items.Clear();
            DataSet ds = null;
            try
            {
                if (UFOpenBill.formType == 1)
                {
                    ds = BLLBillConsume.BLLBillConsumeIDMingXi(BLLRooms.BLLRoomsTNameFHID(UFBillConsume .tName ));
                }
                else
                {
                    ds = BLLBillConsume.BLLBillConsumeIDMingXi(Zhu.lvSelect.rtzdId);
                }
            }
            catch (Exception)
            {
                MessageBox.Show("查询开单编号的消费明细的方法--查询失败!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                MyListViewItem lvi = new MyListViewItem();
                lvi.Text = dr["msName"].ToString();
                lvi.Tag = dr["msId"].ToString();
                lvi.msRemark = dr["msRemark"].ToString();
                this.lvBillLists.Items.Add(lvi);
                lvi.SubItems.AddRange(new string[] { dr["msPrice"].ToString(), dr["msAmount"].ToString(), dr["msMoney"].ToString(), Convert.ToDateTime(dr["msTime"]).ToString("yyyy-MM-dd HH:mm:ss") });
            }
        }
        /// <summary>
        /// 查询传入节点下的所有子节点的方法
        /// </summary>
        /// <param name="node">根节点</param>
        public void UFBillConsumeMenusTypeNode(TreeNode node)
        {
            foreach (CMenus cm in lm)
            {
                if (cm.CmtId1  == Convert.ToInt32(node.Tag))//如果菜品的类型编号等于传入节点的Tag值
                {
                    MyTreeNode n = new MyTreeNode();
                    n.Text = cm.CmsName1   " ￥"   cm.CmsPrice1;
                    n.Tag = cm.CmsId1;
                    n.msCost =cm.CmsCost1 ;
                    n.msScalar =cm.CmsScalar1 ;
                    node.Nodes.Add(n);
                }
                
            }
        }
        /// <summary>
        /// 查询所有菜单的方法
        /// </summary>
        public void UFBillConsumeMenusQuery()
        {
            this.lvMenus.Items.Clear();
            try
            {
                lm = BLLMenus.BLLMenusQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show("菜单查询失败!" ex.ToString () , "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            foreach (CMenus m in lm)
            {
                ListViewItem lvi = new ListViewItem();
                lvi.Text = m.CmsId1.ToString();
                lvi.Tag = m.CmsCost1;//设置项的Tag值为菜品成本
                lvMenus.Items.Add(lvi);
                lvi.SubItems.Add(m.CmsName1);
                lvi.SubItems.AddRange(new string[] { m.CmsPrice1.ToString(), m.CmsScalar1.ToString() });
            }
        }
        /// <summary>
        /// 在消费列表中添加菜品项的方法
        /// </summary>
        public void AddBillList()
        {
            //修改库存数量
            lvicMenu.SubItems[3].Text = Convert.ToString(Convert.ToInt32(lvicMenu.SubItems[3].Text) - Convert.ToInt32(this.txtShuLiang.Text));

            MyListViewItem lviBill = new MyListViewItem();//声明一个列表视图项,存储所选菜品的信息
            //设置它的文本为在菜品列表中选中的项的第二列的数据
            lviBill.Text = lvicMenu.SubItems[1].Text;
            lviBill.Tag = lvicMenu.SubItems[0].Text;
            lviBill.msCost = Convert.ToSingle(lvicMenu.Tag);
            this.lvBillLists.Items.Add(lviBill);
            //添加子项
            lviBill.SubItems.AddRange(new string[] { lvicMenu.SubItems[2].Text, this.txtShuLiang.Text, Convert.ToString(Convert.ToInt32(this.txtShuLiang.Text) * Convert.ToSingle(lvicMenu.SubItems[2].Text)), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")});
            lviBill.ForeColor = Color.BlueViolet;//设置所选择项的字体颜色
            //累加金额值
            money  = Convert.ToInt32(this.txtShuLiang.Text) * Convert.ToSingle(lvicMenu.SubItems[2].Text);

            //CBillConsume cbl = new CBillConsume();
            //cbl.CobId1 = UZhu.lvSelect.rtzdId;
            //cbl.CmsId1 = Convert.ToInt32(lvicMenu.SubItems[0].Text);
            //cbl.CmsAmount1 = Convert.ToInt32(this.txtShuLiang.Text);
            //cbl.CmsMoney1 = Convert.ToInt32(this.txtShuLiang.Text) * Convert.ToSingle(lvicMenu.SubItems[2].Text);
            //cbl.CmsTime1 = Convert.ToDateTime(DateTime .Now.ToString ("yyyy-MM-dd HH:mm:ss"));
            //cbl.CmsRemark1 = "*";

            //CMenus cm = new CMenus();
            //cm.CmsId1 = Convert.ToInt32(lvicMenu.SubItems[0].Text);
            //cm.CmsScalar1 = Convert.ToInt32(this.txtShuLiang.Text);
            //cm.CmsMoney1 = Convert.ToInt32(this.txtShuLiang.Text) * Convert.ToSingle(lvicMenu.Tag);

            //try
            //{
            //    BLLBillConsume.BLLBillConsumeInsertList(cbl, cm);
            //    UFBillConsumeMenusQuery();
            //}
            //catch (Exception ex)
            //{
            //   // MessageBox.Show(ex.Message);
            //    MessageBox.Show("增加失败!(在消费列表中添加菜品项的方法)"   ex.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            //}
            //QueryBillId();
        }
        /// <summary>
        /// 文本框的值发生改变事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>

        private void txtCaiPing_TextChanged(object sender, EventArgs e)
        {
            if (this.txtCaiPing.Text == "")
            {
                UFBillConsumeMenusQuery();
            }
            else
            {
                this.lvMenus.Items.Clear();
                try
                {
                    lm = BLL.BLLMenus.BLLMenusQueryMsSpell(this.txtCaiPing.Text);
                }
                catch (Exception )
                {
                    MessageBox.Show("UFBillConsume类里面的  拼音缩写查询失败!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                foreach (CMenus cm in lm)
                {
                    ListViewItem lvi = new ListViewItem();
                    lvi.Text = cm.CmsId1.ToString();
                    lvi.Tag = cm.CmsCost1;//设置项的Tag值为菜品成本
                    lvMenus.Items.Add(lvi);
                    lvi.SubItems.Add(cm.CmsName1);
                    lvi.SubItems.AddRange(new string[] { cm.CmsPrice1.ToString(),cm.CmsScalar1 .ToString ()});
                }
            }
        }
        /// <summary>
        /// 快捷菜单的增加菜品
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsmiAddMenu_Click(object sender, EventArgs e)
        {
            if (this.txtShuLiang.Text.Equals(""))
            {
                MessageBox.Show("请输入菜品数量!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.txtShuLiang.Focus();
            }
            else if( Convert .ToInt32 (this .txtShuLiang .Text )>Convert .ToInt32 (lvicMenu .SubItems [3].Text ))
            {
                 MessageBox.Show("库存数量不足!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.txtShuLiang .Text = "";
                this .txtShuLiang .Focus ();
            }
            else 
            {
                AddBillList();
                GetSumNumMoney();
            }
        }
        /// <summary>
        /// 统计总数量和总金额
        /// </summary>
        public void GetSumNumMoney()
        { 
        this .tsslblNum .Text =this .lvBillLists .Items .Count.ToString ();
        this.tsslblMoney.Text = "       "   this.money.ToString()   ".00";
        }

        /// <summary>
        /// 用户在菜单列表上拖动项时发生
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void lvMenus_ItemDrag(object sender, ItemDragEventArgs e)
        {
            lcMenu.Clear();//清空泛型集合
            //向泛型集合里添加数据
            lcMenu.Add((e.Item as ListViewItem).SubItems[0].Text);
            lcMenu.Add((e.Item as ListViewItem).SubItems[1].Text);
            lcMenu.Add((e.Item as ListViewItem).SubItems[2].Text);
            lcMenu.Add((e.Item as ListViewItem).Tag .ToString ());
            DoDragDrop(lcMenu ,DragDropEffects.Copy );//开始拖放操作

        }

       
        /// <summary>
        ///数量的　键盘按下的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtShuLiang_KeyPress(object sender, KeyPressEventArgs e)
        {
            char ch = e.KeyChar;
            if (ch >= '0' && ch <= '9' || ch == (char)8)
            {

            }
            else
            {
                e.Handled = true;
                MessageBox.Show("菜品数量必须输入数值型!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.txtShuLiang .Text = "";
                this.txtShuLiang .Focus();
            }

        }
        /// <summary>
        /// 添加－－按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnAdd_Click(object sender, EventArgs e)
        {
            if (this.lvMenus .SelectedItems .Count !=0)
            {
                if (this .txtShuLiang .Text .Equals (""))
                {
                    MessageBox.Show("请输入菜品数量!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.txtShuLiang.Focus();
                }
            
                else if (Convert.ToInt32(this.txtShuLiang.Text) > Convert.ToInt32(lvicMenu.SubItems[3].Text))
                 {
                MessageBox.Show("库存数量不足!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.txtShuLiang.Text = "";
                this.txtShuLiang.Focus();
                 }
    
                 else
                 {
                
                    AddBillList();
                    GetSumNumMoney();
                }
            }
            else 
            {
                MessageBox.Show("请选中你选择的菜品!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
           
        }
        /// <summary>
        /// 确定－－按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnConfirm_Click(object sender, EventArgs e)
        {

            int colorCount2 = 0;
            foreach (MyListViewItem lvi in this.lvBillLists.Items)
            {
                if (lvi.ForeColor.Equals(Color.BlueViolet))
                {
                    colorCount2  ;
                }
            }
            if (colorCount2 != 0)
            {
                foreach (MyListViewItem lvi in this.lvBillLists.Items)
                {
                    if (lvi.ForeColor.Equals(Color.BlueViolet))
                    {
                        CBillConsume cbl = new CBillConsume();
                        cbl.CobId1 = Zhu.lvSelect.rtzdId;
                        cbl.CmsId1 = Convert.ToInt32(lvi.Tag);
                        cbl.CmsAmount1 = Convert.ToInt32(lvi.SubItems[2].Text);
                        cbl.CmsMoney1 = Convert.ToInt32(lvi.SubItems[3].Text);
                        cbl.CmsTime1 = Convert.ToDateTime(lvi.SubItems[4].Text);
                        cbl.CmsRemark1 = "*";

                        CMenus cm = new CMenus();
                        cm.CmsId1 = Convert.ToInt32(lvi.Tag);
                        cm.CmsScalar1 = Convert.ToInt32(lvi.SubItems[2].Text);
                        cm.CmsMoney1 = Convert.ToInt32(lvi.SubItems[2].Text) * Convert.ToSingle(lvi.msCost);

                        try
                        {
                            BLLBillConsume.BLLBillConsumeInsertList(cbl, cm);

                        }
                        catch (Exception ex)
                        {
                            // MessageBox.Show(ex.Message);
                            MessageBox.Show("增加失败!(添加 按钮)"   ex.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }

                    }
                }
                this.EveNewBillListAndMoney();
                this.Close();
            }
            else
            {
                this.EveNewBillListAndMoney();
                 this.Close();
            }
           
          
        }

        /// <summary>
        /// 结账－－按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnPay_Click(object sender, EventArgs e)
        {
            MessageBox.Show(this.lvicMenu.SubItems[0].Text);
        }
        /// <summary>
        /// 取消
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnCancel_Click(object sender, EventArgs e)
        {
            this.Close();
            //MessageBox.Show(lvicMenu.Tag.ToString());

        }
        //折叠
        private void btnClose_Click(object sender, EventArgs e)
        {
            this.tvMenus.CollapseAll();//折叠所有树节点
        }
        //展开
        private void btnOpen_Click(object sender, EventArgs e)
        {
            this.tvMenus.ExpandAll();//展开所有树节点
        }
        /// <summary>
        /// 在菜单树控件上拖动项时发生
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tvMenus_ItemDrag(object sender, ItemDragEventArgs e)
        {
            lcMenu.Clear();
            lcMenu.Add((e.Item as TreeNode).Text);
            lcMenu.Add((e.Item as MyTreeNode).msCost.ToString());
            lcMenu.Add((e.Item as MyTreeNode).msScalar .ToString ());
            DoDragDrop(lcMenu, DragDropEffects.Copy);
        }
        /// <summary>
        /// 菜单选项卡的选择事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tcMenu_Selecting(object sender, TabControlCancelEventArgs e)
        {
            if (this.tcMenu.SelectedIndex == 0)
            {
                this.btnAdd.Enabled = true;//设置增加按钮为使用
            }
            if (this.tcMenu.SelectedIndex == 1)
            {
                this.btnAdd.Enabled = false;//设置增加按钮为不可使用
            }
        }
        /// <summary>
        /// 快捷菜单的顾客退菜
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsmiDelMenu_Click(object sender, EventArgs e)
        {
            if (this.lvBillLists.SelectedItems.Count != 0)
            {
                if (MessageBox.Show("确定退菜吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    foreach (ListViewItem lvi in this.lvMenus.Items)//循环读取菜品列表中的所有项
                    {
                        if (lvicbillMenu.Tag.ToString().Equals(lvi.SubItems[0].Text))
                        {
                            //修改库存数量
                            lvi.SubItems[3].Text = Convert.ToString(Convert.ToInt32(lvi.SubItems[3].Text)   Convert.ToInt32(lvicbillMenu.SubItems[2].Text));
                        }
                    }
                    //try
                    //{
                    //    BLLBillConsume.BLLBillConsumeDeleteList(UZhu.lvSelect.rtzdId, Convert.ToInt32(lvicbillMenu.Tag), Convert.ToDateTime(lvicbillMenu.SubItems[4].Text));

                    //}
                    //catch (Exception ex)
                    //{

                    //    MessageBox.Show("退菜失败!"   ex.ToString(), "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    //}
                    this.lvBillLists.Items.Remove(lvicbillMenu);//移除选中的项
                    money -= Convert.ToSingle(this.lvicbillMenu.SubItems[3].Text);
                    GetSumNumMoney();
                }
            }
            else
            {
                MessageBox.Show("请选中退菜的菜品!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
        /// <summary>
        /// 快捷菜单的菜品备注
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsmiAddMenuRemark_Click(object sender, EventArgs e)
        {
            if (this.lvBillLists.SelectedItems.Count != 0)
            {
                UBillListRemark ublr = new UBillListRemark(lvicbillMenu.Text, Zhu.lvSelect.rtzdId, Convert.ToInt32(lvicbillMenu.Tag), Convert.ToDateTime(lvicbillMenu.SubItems[4].Text));
                ublr.ShowDialog();
            }
            else {
                MessageBox.Show("请选中你需要增加备注的菜品!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }

        /// <summary>
        /// 在消费列表中拖放完成时发生
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void lvBillLists_DragDrop(object sender, DragEventArgs e)
        {
            if (this.txtShuLiang.Text.Equals(""))
            {
                MessageBox.Show("请输入菜品数量!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.txtShuLiang.Focus();
            }
            else
            {
                CBillConsume cbl = new CBillConsume();
                if (this.tcMenu.SelectedIndex == 0)//根据选择卡页的索引来判断
                {
                    if (Convert.ToInt32(this.txtShuLiang .Text) < Convert.ToInt32(lvicMenu.SubItems[3].Text) )
                    {
                        //修改库存数量
                         lvicMenu.SubItems[3].Text = Convert.ToString(Convert .ToInt32 (lvicMenu .SubItems [3].Text)-Convert .ToInt32 (this .txtShuLiang .Text ));
                           //获得泛型集合中各列的数据
                        int msId=Convert .ToInt32 ((e.Data .GetData (typeof (List <string>))as List <string >)[0]);
                        string msName = (e.Data.GetData(typeof(List<string>)) as List<string>)[1].ToString();
                        string msPrice = (e.Data.GetData(typeof(List<string>)) as List<string>)[2].ToString();
                        string msCost = (e.Data.GetData(typeof(List<string>)) as List<string>)[3].ToString();
                   
                        MyListViewItem lvi = new MyListViewItem();//声明一个列表视图项,存储所选菜品的信息
                        lvi.Text = msName;
                        lvi.Tag = msId;
                        lvi.msCost = Convert.ToSingle(msCost);
                        this.lvBillLists.Items.Add(lvi);
                        //在这个项中添加子项(单价,数量,金额,消费时间)
                        lvi.SubItems.AddRange(new string[] { msPrice, this.txtShuLiang.Text, Convert.ToString(Convert.ToInt32(this.txtShuLiang.Text) * Convert.ToSingle(msPrice)), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")});
                        lvi.ForeColor = Color.BlueViolet;//设置添加项的字体颜色
                        money  = Convert.ToInt32(this.txtShuLiang .Text) * Convert.ToSingle(msPrice);//累加金额值
                        GetSumNumMoney ();
                     }
                    else 
                    {
                     MessageBox.Show("库存数量不足!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                     this.txtShuLiang .Text = "";
                    this.txtShuLiang.Focus();
                     }
                }
                if (this.tcMenu.SelectedIndex == 1)
                {
                    if (Convert .ToInt32 (this .txtShuLiang .Text )<Convert .ToInt32((e.Data.GetData (typeof (List <string >))as List <string>)[2] ))
                    {
                    //获得拖动树节点的文本
                    string chooseTreeNode = (e.Data.GetData(typeof(List<string>)) as List<string>)[0].ToString();
                    string msCost=(e.Data.GetData(typeof(List<string>)) as List<string>)[1].ToString();
                    string msName = chooseTreeNode.Substring(0, chooseTreeNode.IndexOf("￥") - 1);//获得泛型集合中的数据,取出"￥"前面的菜品名称
                    int msId = BLLMenus.BLLMenusNameQueryID (0,msName ) ;//查询菜品名称的编号

                    MyListViewItem lvi = new MyListViewItem();//声明一个列表视图项,存储所选菜品的信息
                    lvi.Text = msName;
                    lvi.Tag = msId;
                    lvi.msCost = Convert.ToSingle(msCost);

                    this.lvBillLists.Items.Add(lvi);
                    //在这个项中添加子项(单价,数量,金额,消费时间)
                    lvi.SubItems.AddRange(new string[] { chooseTreeNode.Substring(chooseTreeNode.IndexOf("￥")   1, 2), this.txtShuLiang.Text, Convert.ToString(Convert.ToInt32(this.txtShuLiang.Text) * Convert.ToSingle(chooseTreeNode.Substring(chooseTreeNode.IndexOf("￥")   1, 2))), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")});
                    lvi.ForeColor = Color.BlueViolet;//设置选择项的字体颜色
                    //累加金额值
                    money  = Convert.ToInt32(this.txtShuLiang.Text) * Convert.ToSingle(chooseTreeNode.Substring(chooseTreeNode.IndexOf("￥") 1,2));
                    GetSumNumMoney();
                    }
                    else 
                    {
                          MessageBox.Show("库存数量不足!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                         this.txtShuLiang .Text = "";
                        this.txtShuLiang.Focus();
                    }
                    ////插入消费明细
                    //cbl.CobId1 = UZhu.lvSelect.rtzdId;
                    //cbl.CmsId1 = msId;
                    //cbl.CmsAmount1 = Convert.ToInt32(this.txtShuLiang.Text);
                    //cbl.CmsMoney1 = Convert.ToInt32(this.txtShuLiang.Text) * Convert.ToSingle(chooseTreeNode.Substring(chooseTreeNode.IndexOf("￥") 1,2));
                    //cbl.CmsTime1 = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                    //cbl.CmsRemark1 = "*";
                    //try
                    //{

                    //}
                    //catch (Exception)
                    //{
                    //    MessageBox.Show("1--增加失败(在消费列表中拖放完成时发生)!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    //}
                    //QueryBillId();
                }
            }

        }

        /// <summary>
        /// 当鼠标进入消费列表时发生
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void lvBillLists_DragEnter(object sender, DragEventArgs e)
        {
            //指定拖放效果(同时要设置相应的AllowDrop属性值为true)
            e.Effect = DragDropEffects.Copy;
        }

        /// <summary>
        /// 视图的双击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void lvBillLists_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            UBillListRemark ublr = new UBillListRemark(lvicbillMenu .Text ,Zhu .lvSelect .rtzdId ,Convert .ToInt32(lvicbillMenu .Tag ),Convert .ToDateTime (lvicbillMenu .SubItems [4].Text ) );
            ublr.ShowDialog();
        }
        /// <summary>
        /// 在消费列表中选中项的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void lvBillLists_MouseDown(object sender, MouseEventArgs e)
        {
            lvicbillMenu = this.lvBillLists.GetItemAt(e.X, e.Y) as MyListViewItem; //获得在消费列表中的选择项
            if (lvicbillMenu != null)
            {
                this.lblMRemark.Text = lvicbillMenu.Text   "备注："   lvicbillMenu.msRemark;

            }
            else
            {
                this.lblMRemark.Text = "";
            }
        }
        /// <summary>
        /// 在菜单列表中选中项的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void lvMenus_MouseDown(object sender, MouseEventArgs e)
        {
            lvicMenu = this.lvMenus.GetItemAt(e.X, e.Y);//获得在菜单列表中的选择项
        }
       /// <summary>
        /// 文本框获得焦点的事件
       /// </summary>
       /// <param name="sender"></param>
       /// <param name="e"></param>
        private void txtCaiPing_Enter(object sender, EventArgs e)
        {
            this.tcMenu.SelectedIndex = 0;//设置选择卡选中第一页
        }

        /// <summary>
        /// 在菜单列表中双击的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void lvMenus_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            if (this.txtShuLiang.Text.Equals(""))
            {
                MessageBox.Show("请输入菜品数量!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.txtShuLiang.Focus();
            }

            else if (Convert.ToInt32(this.txtShuLiang.Text) > Convert.ToInt32(lvicMenu.SubItems[3].Text))
            {
                MessageBox.Show("库存数量不足!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.txtShuLiang.Text = "";
                this.txtShuLiang.Focus();
            }

            else
            {

                AddBillList();
                GetSumNumMoney();
            }
        }






    }
}