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