private void btnOK_Click(object sender, EventArgs e) { //选择会员 if (dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[4].Value.ToString() == "可用") { //会员名称 lblName.Text = dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[0].Value.ToString(); //会员级别 lblTop.Text = dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[2].Value.ToString(); //折扣比率 lblBL.Text = dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[3].Value.ToString(); //会员编号 txtNo.Text = dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[5].Value.ToString(); ConsumerBillModel cbm2 = new ConsumerBillModel(); cbm2.CBID1 = cbm.CBID1; cbm2.VipID1 = dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[5].Value.ToString(); cbm2.CBDiscount1 = dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[3].Value.ToString(); int result = ConsumerBillBLL.getUpdateVip(cbm2); if (result > 0) { this.panel1.Visible = false; AccountsForm1_Load(null, null); } } else { MessageBox.Show("会员不可用!"); } }
//本月 private void 本月ToolStripMenuItem_Click(object sender, EventArgs e) { int time = Convert.ToInt32(DateTime.Now.ToString("MM")); DataTable dt = ConsumerBillBLL.getZDMM(time); dataGridView1.DataSource = dt; DataTable dt2 = ConsumerDetailsBLL.getXFMM(time); dataGridView2.DataSource = dt2; }
//今天 private void 今天ToolStripMenuItem_Click(object sender, EventArgs e) { int day = Convert.ToInt32(DateTime.Now.ToString("dd")); DataTable dt = ConsumerBillBLL.getZDDay(day); dataGridView1.DataSource = dt; DataTable dt2 = ConsumerDetailsBLL.getXFDay(day); dataGridView2.DataSource = dt2; }
//所有时间 private void 所有时间ToolStripMenuItem_Click(object sender, EventArgs e) { DataTable dt = ConsumerBillBLL.getZD(); dataGridView1.DataSource = dt; dataGridView1.Columns[2].Width = 150; //消费详情 DataTable dt2 = ConsumerDetailsBLL.getXF(); dataGridView2.DataSource = dt2; }
private void dateTimePicker1_ValueChanged(object sender, EventArgs e) { DateTime dt = dateTimePicker1.Value; //日 label10.Text = ConsumerBillBLL.billYY(dt.ToString("yyyyMMdd")) + "元"; //月 label11.Text = ConsumerBillBLL.billYY(dt.ToString("yyyyMM")) + "元"; //年 label12.Text = ConsumerBillBLL.billYY(dt.ToString("yyyy")) + "元"; }
private void button1_Click(object sender, EventArgs e) { if (txt_Count.Text.Trim().Length <= 0) { new Warning("人数不能为空", 图标.Erro).Show(); return; } try { #region 获取单号 string MaxCB = ConsumerBillBLL.GetMaxDT(); if (MaxCB == "") { MaxCB = "ZD" + DateTime.Now.ToString("yyyyMMdd") + "0000"; } int day = int.Parse(MaxCB.Substring(MaxCB.Length - 4, 4)) + 1; string dayCB = "ZD" + DateTime.Now.ToString("yyyyMMdd") + day.ToString().PadLeft(4, '0'); #endregion #region 开单消费 ConsumerBills c = new ConsumerBills(); c.CBID = dayCB; c.TableID = int.Parse(TableID); c.CBAmount = txt_Count.Text; c.CBStartDate = DateTime.Now.ToString(); c.CBClose = 0; //添加餐桌插入单号 if (ConsumerBillBLL.AddCB(c) > 0) { CBState.isTrue = true; //开单成功修改桌子状态 TablesBLL.UpdateTables(Convert.ToInt32(TableID), 1); if (checkBox1.Checked) { CBState.isCheknd = true; } this.Close(); } #endregion } catch (Exception) { MessageBox.Show("发生未只的异常,请联系开发者", "未知异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//条件查询 private void button2_Click(object sender, EventArgs e) { string startTime = txtStartTime.Text.Trim(); string endTime = txtEndTime.Text.Trim(); startTime += " " + mtbStartTime.Text.Trim(); endTime += " " + mtbEndTime.Text.Trim(); int index = id; int No = Convert.ToInt32(txtNo.Text.Trim()); //MessageBox.Show(startTime+" "+endTime+" "+index+" "+No); DataTable dt = ConsumerBillBLL.getZDTJ(startTime, endTime, index, No); dataGridView1.DataSource = dt; DataTable dt2 = ConsumerDetailsBLL.getXFTJ(startTime, endTime, index, No); dataGridView2.DataSource = dt2; }
private void BillForm_Load(object sender, EventArgs e) { //标题 this.Text = "账单查询"; //房间类型 //背景 dataGridView1.BackgroundColor = Color.White; //禁止添加 dataGridView1.AllowUserToAddRows = false; //禁止调整列 dataGridView1.AllowUserToResizeColumns = false; //禁止调整行 dataGridView1.AllowUserToResizeRows = false; //取消头列 dataGridView1.RowHeadersVisible = false; //禁止多选 dataGridView1.MultiSelect = false; //背景 dataGridView2.BackgroundColor = Color.White; //禁止添加 dataGridView2.AllowUserToAddRows = false; //禁止调整列 dataGridView2.AllowUserToResizeColumns = false; //禁止调整行 dataGridView2.AllowUserToResizeRows = false; //取消头列 dataGridView2.RowHeadersVisible = false; //禁止多选 dataGridView2.MultiSelect = false; //加载数据 DataTable dt = ConsumerBillBLL.getZD(); dataGridView1.DataSource = dt; dataGridView1.Columns[2].Width = 150; //消费详情 DataTable dt2 = ConsumerDetailsBLL.getXF(); dataGridView2.DataSource = dt2; //查询操作员 DataTable dt3 = adminsBLL.getTableAdmin(); cmbRen.DataSource = dt3; cmbRen.ValueMember = dt3.Columns["操作员编号"].ToString(); cmbRen.DisplayMember = dt3.Columns["操作员姓名"].ToString(); }
//结账 private void 宾客结账ToolStripMenuItem_Click(object sender, EventArgs e) { TablesModel tables = new TablesModel(); tables.TableID1 = id; tables.TableName1 = name; //查询出当前餐桌得编号 ConsumerBillModel cbm = new ConsumerBillModel(); cbm.TableID1 = id; cbm.CBClose1 = 0; DataTable dt = ConsumerBillBLL.getNo(cbm); cbm.CBID1 = dt.Rows[0]["账单编号"].ToString(); AccountsForm1 af = new AccountsForm1(cbm, tables); af.Show(); }
private void button1_Click(object sender, EventArgs e) { //获取订单编号 string CBID = TablesBLL.GetCBID(Convert.ToInt32(TBID)); //根据订单编号修改桌子 int c = ConsumerBillBLL.UpTable(CBID, Convert.ToInt32(comboBox1.SelectedValue)); if (c > 0) { UptableHelp.isTrue = true; //修改目标桌子状态 TablesBLL.UpdateTables(Convert.ToInt32(comboBox1.SelectedValue), 1); //修改当前餐桌状态 TablesBLL.UpdateTables(Convert.ToInt32(TBID), 0); new Warning("换桌成功", 图标.Yes).Show(); this.Close(); } }
//增加消费 private void Insert_Click(object sender, EventArgs e) { TablesModel tables = new TablesModel(); tables.TableID1 = id; tables.TableName1 = name; //查询出当前餐桌得编号 ConsumerBillModel cbm = new ConsumerBillModel(); cbm.TableID1 = id; cbm.CBClose1 = 0; DataTable dt = ConsumerBillBLL.getNo(cbm); cbm.CBID1 = dt.Rows[0]["账单编号"].ToString(); AddForm af = new AddForm(tables, cbm); af.Show(); }
private void textBox1_TextChanged(object sender, EventArgs e) { string name = textBox1.Text; ProductsModel pm = new ProductsModel(); pm.ProductJP1 = name; for (int i = 0; i < tv.Nodes.Count; i++) { if (tv.Nodes[i].Name.Contains(name)) { tv.Nodes[i].ImageIndex = 1; } } if (tabControl1.TabPages[0].Text == "项目清单") { DataTable dt = ConsumerBillBLL.getTableSS(pm); dataGridView1.DataSource = dt; } if (tabControl1.TabPages[1].Text == "项目列表") { tv.Nodes.Clear(); //列表 DataTable dt2 = ConsumerBillBLL.getTableLB(); for (int i = 0; i < dt2.Rows.Count; i++) { TreeNode root = new TreeNode(dt2.Rows[i]["PTName"].ToString()); root.Name = dt2.Rows[i]["PTName"].ToString(); root.ImageIndex = 1; tv.Nodes.Add(root); ProductTypeModel ptype = new ProductTypeModel(); ptype.PTName1 = dt2.Rows[i]["PTName"].ToString(); DataTable dt3 = ConsumerBillBLL.getTableSSLB(ptype, pm); for (int j = 0; j < dt3.Rows.Count; j++) { TreeNode node = new TreeNode(dt3.Rows[j]["项目名称"].ToString()); node.Name = dt3.Rows[j]["项目名称"].ToString(); root.Nodes.Add(node); } } //tabPage2.Controls.Add(tv2); } }
private void FrmSelectBill_Load(object sender, EventArgs e) { DataTable dt = ConsumerBillBLL.GetBill(); chart1.Series[0].YValueMembers = "CDprice"; chart1.Series[0].XValueMember = "CDDate"; chart1.DataSource = dt; DataTable dt_p = ProductsBLL.GetPT(); chart2.Series[0].YValueMembers = "销量"; chart2.Series[0].XValueMember = "商品名字"; chart2.DataSource = dt_p; DateTime dtt = dateTimePicker1.Value; //日 label10.Text = ConsumerBillBLL.billYY(dtt.ToString("yyyyMMdd")) + "元"; //月 label11.Text = ConsumerBillBLL.billYY(dtt.ToString("yyyyMM")) + "元"; //年 label12.Text = ConsumerBillBLL.billYY(dtt.ToString("yyyy")) + "元"; }
private void AddYD_Load(object sender, EventArgs e) { string MaxCB = ConsumerBillBLL.GetMaxDT(); if (MaxCB == "") { MaxCB = "ZD" + DateTime.Now.ToString("yyyyMMdd") + "0000"; } int day = int.Parse(MaxCB.Substring(MaxCB.Length - 4, 4)) + 1; string dayCB = "YD" + DateTime.Now.ToString("yyyyMMdd") + day.ToString().PadLeft(4, '0'); label9.Text = dayCB; List <RoomTypeMDL> list_rt = RoomTypeBLL.selectRoom(); foreach (RoomTypeMDL item in list_rt) { TreeNode tr_r = new TreeNode(); tr_r.Text = item.RTName; tr_r.Tag = item.RTID; List <TablesMDL> list_tb = TablesBLL.selectTable(item.RTID); foreach (TablesMDL item_tb in list_tb) { //只添加可用桌子 if (item_tb.TableState == 0) { TreeNode tr_t = new TreeNode(); tr_t.Text = item_tb.TableName; tr_t.Tag = item_tb.TableID; tr_r.Nodes.Add(tr_t); } } treeView1.Nodes.Add(tr_r); } }
private void brnOK_Click(object sender, EventArgs e) { TablesModel tables2 = new TablesModel(); tables2.TableName1 = tables.TableName1; tables2.TableState1 = 1; int result = RommBLL.getUpdateZT(tables2); string count = txtCount.Text.Trim(); if (result > 0) { MessageBox.Show("OK"); if (cb.Checked) { string no = "ZD" + DateTime.Now.ToString("yyyyMMddhhmm"); string time = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); ConsumerBillModel cbm = new ConsumerBillModel(no, tables.TableID1, count, "-1", "1", time, "", admin, Convert.ToDouble("0"), 0); ConsumerBillBLL.getInsert(cbm); AddForm af = new AddForm(tables, cbm); af.Show(); } else { string no = "ZD" + DateTime.Now.ToString("yyyyMMddhhmm"); string time = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); ConsumerBillModel cbm = new ConsumerBillModel(no, tables.TableID1, count, "-1", "1", time, "", admin, Convert.ToDouble("0"), 0); ConsumerBillBLL.getInsert(cbm); } FunctionForm ff = new FunctionForm(); ff.FunctionForm_Load(null, null); this.Close(); } else { MessageBox.Show("NO"); } }
//本周 private void 本周ToolStripMenuItem_Click(object sender, EventArgs e) { int startTime = 0; int endTime = 0; int year = Convert.ToInt32(DateTime.Now.ToString("yyyy")); int mm = Convert.ToInt32(DateTime.Now.ToString("MM")); string time = DateTime.Now.DayOfWeek.ToString(); switch (time) { case "Monday": startTime = Convert.ToInt32(DateTime.Now.ToString("dd")) - 0; endTime = startTime + 6; MessageBox.Show(startTime.ToString()); break; case "Tuesday": startTime = Convert.ToInt32(DateTime.Now.ToString("dd")) - 1; endTime = startTime + 6; MessageBox.Show(startTime.ToString()); break; case "Wednesday": startTime = Convert.ToInt32(DateTime.Now.ToString("dd")) - 2; endTime = startTime + 6; MessageBox.Show(startTime.ToString()); break; case "Thursday": startTime = Convert.ToInt32(DateTime.Now.ToString("dd")) - 3; endTime = startTime + 6; MessageBox.Show(startTime.ToString()); break; case "Friday": startTime = Convert.ToInt32(DateTime.Now.ToString("dd")) - 4; endTime = startTime + 6; MessageBox.Show(startTime.ToString()); MessageBox.Show(endTime.ToString()); break; case "Saturday": startTime = Convert.ToInt32(DateTime.Now.ToString("dd")) - 5; endTime = startTime + 6; MessageBox.Show(startTime.ToString()); break; case "Sunday": startTime = Convert.ToInt32(DateTime.Now.ToString("dd")) - 6; endTime = startTime + 6; MessageBox.Show(startTime.ToString()); break; default: break; } DataTable dt = ConsumerBillBLL.getZDWeek(year, mm, startTime, endTime); dataGridView1.DataSource = dt; DataTable dt2 = ConsumerDetailsBLL.getXFWeek(year, mm, startTime, endTime); dataGridView2.DataSource = dt2; }
private void button1_Click(object sender, EventArgs e) { if (textBox2.Text.Length <= 0) { new Warning("结账失败,请输入金额", 图标.Erro).Show(); return; } try { if ((double.Parse(textBox2.Text) - (price * VGDiscount)) >= 0) { //获取数据 ConsumerBills c = new ConsumerBills(); c.CBID = label2.Text; c.VipID = textBox1.Text; c.CBDiscount = label17.Text; c.AdminID = admins.UserId; c.CBSale = double.Parse(label10.Text); //修改支付状态 if (ConsumerBillBLL.UPCB(c) > 0) { ZD.cg = 1; if (checkBox1.Checked) { FileStream fs = new FileStream(label2.Text + ".txt", FileMode.Create); StreamWriter sw = new StreamWriter(fs, Encoding.Default); string tt = "餐饮系统标题"; #region 获取发票抬头 FileStream fsr = new FileStream("配置文件.ini", FileMode.Open); StreamReader rd = new StreamReader(fsr, Encoding.Default); while (!rd.EndOfStream) { string r = rd.ReadLine(); string r1 = r.Split(':')[0]; switch (r1) { case "发票打印抬头": tt = r.Split(':')[1]; break; default: break; } } rd.Close(); fsr.Close(); #endregion sw.WriteLine("====" + tt + "===="); sw.WriteLine("订单号:" + label2.Text); sw.WriteLine("菜名\t数量\t价格"); sw.WriteLine("===\t===\t==="); if (dataGridView1.Rows.Count > 0) { foreach (DataGridViewRow item in dataGridView1.Rows) { sw.WriteLine(item.Cells[0].Value + "\t" + item.Cells[1].Value + "\t" + item.Cells[2].Value); } } else { sw.WriteLine("====无====="); } sw.WriteLine("================"); sw.WriteLine("实收金额:" + label10.Text); sw.WriteLine("会员优惠:" + label22.Text); sw.Close(); fs.Close(); System.Diagnostics.Process.Start(label2.Text + ".txt"); } this.Close(); } } else { new Warning("支付余额不足", 图标.Erro).Show(); } } catch (Exception) { MessageBox.Show("发生未只的异常,请联系开发者", "未知异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void AddForm_Load(object sender, EventArgs e) { //标题 this.Text = "增加消费"; //桌号 lblNo.Text = tables.TableName1; //背景 dataGridView1.BackgroundColor = Color.White; //禁止添加 dataGridView1.AllowUserToAddRows = false; //禁止调整列 dataGridView1.AllowUserToResizeColumns = false; //禁止调整行 dataGridView1.AllowUserToResizeRows = false; //取消头列 dataGridView1.RowHeadersVisible = false; //禁止多选 dataGridView1.MultiSelect = false; //加载数据 DataTable dt = ConsumerBillBLL.getTableZD(); dataGridView1.DataSource = dt; dataGridView1.Columns[0].Visible = false; //禁止编辑 dataGridView1.ReadOnly = true; //选中突出 listView1.FullRowSelect = true; tv = new TreeView(); tv.Dock = DockStyle.Fill; tv.ImageList = imageList1; //列表 DataTable dt2 = ConsumerBillBLL.getTableLB(); for (int i = 0; i < dt2.Rows.Count; i++) { TreeNode root = new TreeNode(dt2.Rows[i]["PTName"].ToString()); root.Name = dt2.Rows[i]["PTName"].ToString(); root.ImageIndex = 0; tv.Nodes.Add(root); ProductTypeModel ptype = new ProductTypeModel(); ptype.PTName1 = dt2.Rows[i]["PTName"].ToString(); DataTable dt3 = ConsumerBillBLL.getTableLB(ptype); for (int j = 0; j < dt3.Rows.Count; j++) { TreeNode node = new TreeNode(dt3.Rows[j]["项目名称"].ToString()); node.Name = dt3.Rows[j]["项目名称"].ToString(); node.ImageIndex = 1; root.Nodes.Add(node); } } tabPage2.Controls.Add(tv); //数量 txtCount.Text = "1"; //加载消费列表 DataTable dt4 = ConsumerDetailsBLL.getTableXF(tables.TableID1); for (int i = 0; i < dt4.Rows.Count; i++) { ListViewItem lvi = new ListViewItem(dt4.Rows[i]["商品编号"].ToString()); lvi.SubItems.Add(dt4.Rows[i]["单价"].ToString()); lvi.SubItems.Add(dt4.Rows[i]["数量"].ToString()); lvi.SubItems.Add(dt4.Rows[i]["金额"].ToString()); lvi.SubItems.Add(dt4.Rows[i]["点单时间"].ToString()); lvi.SubItems.Add(dt4.Rows[i]["项目类别"].ToString()); lvi.SubItems.Add(dt4.Rows[i]["CDID"].ToString()); listView1.Items.Add(lvi); } //金额和数量 getMoneyANDCount(); //最后隐藏 listView1.Columns[6].Width = 0; }
private void FrmMain_Load(object sender, EventArgs e) { try { if (!File.Exists("配置文件.ini")) { MessageBox.Show("文件不存在", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } FileStream fs = new FileStream("配置文件.ini", FileMode.Open); StreamReader rd = new StreamReader(fs, Encoding.Default); while (!rd.EndOfStream) { string r = rd.ReadLine(); string r1 = r.Split(':')[0]; switch (r1) { case "系统名称": label3.Text = r.Split(':')[1]; break; default: break; } } rd.Close(); fs.Close(); label4.Text = admins.UserCompellation; label1.Text = DateTime.Now.ToString("yyyy年MM月dd日"); label2.Text = DateTime.Now.ToString("hh:mm:ss"); label14.Text = "日营业额" + ConsumerBillBLL.billYY(DateTime.Now.ToString("yyyyMMdd")) + "元"; pictureBox8.Image = WaySTwo(admins.id); dataGridView1.Columns[3].Visible = false; dataGridView1.Columns[4].Visible = false; #region 动态生成 List <RoomTypeMDL> list = RoomTypeBLL.selectRoom(); foreach (RoomTypeMDL item in list) { //动态添加tabpage TabPage t = new TabPage(); t.Text = item.RTName; t.Tag = item.RTID; //准备listview ListView lview = new ListView(); lview.Dock = DockStyle.Fill; lview.LargeImageList = imageList1; lview.View = View.LargeIcon; lview.Font = new Font("微软雅黑", 12); lview.MouseClick += new MouseEventHandler(lview_MouseClick); t.Controls.Add(lview); this.tabControl1.TabPages.Add(t); List <TablesMDL> list_t = TablesBLL.selectTable(item.RTID); foreach (TablesMDL items in list_t) { TableCount += 1; ListViewItem lvi = new ListViewItem(); lvi.Text = items.TableName; lvi.ImageIndex = items.TableState; if (items.TableState == 1) { kaicount += 1; } if (items.TableState == 0) { nullcount += 1; } lvi.Tag = items.TableID; lview.Items.Add(lvi); } } #endregion label10.Text = "总台:" + TableCount.ToString(); label11.Text = "空台:" + nullcount.ToString(); label12.Text = "开台:" + kaicount.ToString(); double sz = kaicount / (TableCount + 0.0); string bf = (sz * 100).ToString(); string bf1 = ""; if (bf.Length > 4) { bf1 = bf.Substring(0, 4); } label13.Text = "上桌率:" + bf1 + "%"; } catch (Exception) { MessageBox.Show("发生未只的异常,请联系开发者", "未知异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//结账 private void button1_Click(object sender, EventArgs e) { //读取XML文件 //创建XML文件流 XmlDocument doc = new XmlDocument(); //加载xml doc.Load(@"setup.xml"); //获得根节点 XmlElement root = doc.DocumentElement; //获得子节点 XmlNodeList xnl = root.ChildNodes; //标题 string name = xnl[0].InnerText; //创建文件 MessageBox.Show(string.Format("{0}.txt", lblNo.Text.Trim())); File.Create(@"" + lblNo.Text.Trim() + ".txt").Close(); //创建文本 string text = "---------" + name + "-----------\n"; text += string.Format("账单编号:{0}", lblNo.Text); text += string.Format("\n餐桌编号:{0}", lblTableName.Text); text += string.Format("\n打印时间:{0}", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); text += string.Format("\n--------------------------------------"); for (int i = 0; i < dataGridView1.Rows.Count; i++) { text += string.Format("\n消费项目@单价@数量@应收金额@优惠额度"); text += string.Format("\n{0}@{1}@{2}@{3}@{4}", dataGridView1.Rows[i].Cells[1].Value.ToString(), dataGridView1.Rows[i].Cells[2].Value.ToString(), dataGridView1.Rows[i].Cells[6].Value.ToString(), dataGridView1.Rows[i].Cells[7].Value.ToString(), dataGridView1.Rows[i].Cells[5].Value.ToString()); } text += string.Format("\n--------------------------------------"); text += string.Format("\n消费总额{0}", lblMoney.Text.Trim()); text += string.Format("\n优惠总额{0}", lblYMoney.Text.Trim()); MessageBox.Show(text); //创建文件流 FileStream fs = new FileStream(@"" + lblNo.Text.Trim() + ".txt", FileMode.Open); //创建读取对象,调用读取方法 StreamWriter sw = new StreamWriter(fs); sw.WriteLine(text); //关闭资源 sw.Close(); fs.Close(); //修改消费金额和优惠额度 for (int j = 0; j < dataGridView1.Rows.Count; j++) { MessageBox.Show(dataGridView1.Rows[j].Cells[5].Value.ToString()); ConsumerDetailsModel cdm = new ConsumerDetailsModel(); cdm.CBID1 = lblNo.Text.Trim(); cdm.CDSale1 = Convert.ToDouble(dataGridView1.Rows[j].Cells[5].Value.ToString()); cdm.CDMoney1 = Convert.ToDouble(dataGridView1.Rows[j].Cells[7].Value.ToString()); ProductsModel pm = new ProductsModel(); pm.ProductName1 = dataGridView1.Rows[j].Cells[1].Value.ToString(); DataTable dt = ProductsBLL.getTableID(pm); pm.ProductID1 = Convert.ToInt32(dt.Rows[0]["ProductID"].ToString()); ConsumerDetailsBLL.getUpdateXF(cdm, pm); } //修改餐桌状态以及 string endTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); string money = lblMoney2.Text.Trim(); string no = lblNo.Text.Trim(); ConsumerBillModel cbm = new ConsumerBillModel(); cbm.CBID1 = no; cbm.CBEndDate1 = endTime; cbm.CBSale1 = Convert.ToDouble(money); MessageBox.Show(cbm.CBSale1.ToString()); ConsumerBillBLL.getUpdateJZ(cbm); //餐桌状态 TablesModel tables = new TablesModel(); tables.TableName1 = lblTableName.Text.Trim(); tables.TableState1 = 0; int result = RommBLL.getUpdateZT(tables); if (result > 0) { //new FunctionForm().FunctionForm_Load(null,null); } }