private void LoadProductCountAndSumPrice()
{
DataTable table = new R_Order_ProductBLL().GetProductCountAndSumPriceByOrderId(orderId);
labCount.Text = table.Rows[0]["ProductCount"].ToString();
labSumMoney.Text = string.IsNullOrEmpty(table.Rows[0]["SumPrice"].ToString()) ? "0" : table.Rows[0]["SumPrice"].ToString();
}
private void LoadAddProByOrder(int p)
{
R_Order_ProductBLL ropbll = new R_Order_ProductBLL();
dgvROrderProduct.AutoGenerateColumns = false;
dgvROrderProduct.DataSource = ropbll.GetProductByOrderId(p);
dgvROrderProduct.ClearSelection();
}
//退菜操作
private void btnDeleteRorderPro_Click(object sender, EventArgs e)
{
if (dgvROrderProduct.SelectedRows.Count <= 0)
{
md.MsgDivShow("请选择要删除的商品", 1);
return;
}
if (MessageBox.Show("确定移除吗?", "移除", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)
{
R_Order_ProductBLL ropbll = new R_Order_ProductBLL();
int ropId = ((R_Order_Product)(dgvROrderProduct.SelectedRows[0].DataBoundItem)).ROrderProId;
md.MsgDivShow(ropbll.SoftDeleteR_Order_ProByRpoId(ropId) ? "操作成功" : "操作失败", 1, Bind);
}
else
{
md.MsgDivShow("你已经取消删除", 1);
return;
}
}
private void btnAccounts_Click(object sender, EventArgs e)
{
//更新餐桌状态
DeskInfoBLL dbll = new DeskInfoBLL();
bool dkResult = dbll.UpdateDeskInfoStateByDeskId(Convert.ToInt32(labdkId.Text), 0);
//订单状态改变
OrderInfoBLL ordlbll = new OrderInfoBLL();
OrderInfo order = new OrderInfo();
order.EndTime = System.DateTime.Now;
order.OrderMoney = Convert.ToDouble(lblMoney.Text);
order.OrderState = 2;
order.OrderId = Convert.ToInt32(labOrderId.Text);
if (cmbMember.SelectedIndex != 0)//是会员
{
MemberInfo mem = (MemberInfo)cmbMember.SelectedItem;
order.OrderMemberId = mem.MemberId;
order.DisCount = mem.MemDiscount;//状态
//根据会员的id更新会员的金额
double money = Convert.ToDouble(labyuMoney.Text) - Convert.ToDouble(lblMoney.Text);
MemberInfoBLL membll = new MemberInfoBLL();
membll.UpdateMoneyByMemId(mem.MemberId, money);
}
bool ordResult = ordlbll.UpdateOrderInfo(order);
//改变订单对应订单和菜单的中间表中的菜的状态
R_Order_ProductBLL ropbll = new R_Order_ProductBLL();
bool ropResult = ropbll.UpdateR_Order_ProductByOrderId(Convert.ToInt32(labOrderId.Text));
if (dkResult && ordResult && ropResult)
{
md.MsgDivShow("结账成功", 1, Bind);
}
else
{
md.MsgDivShow("结账失败了", 1);
}
}
//双击单元格时发生
private void dgvProduct_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvProduct.SelectedRows.Count <= 0)
{
md.MsgDivShow("请选择要点的菜", 1);
return;
}
int tCount;
if (txtCount.Text == "0" || txtCount.Text == "1" || string.IsNullOrEmpty(txtCount.Text))
{
txtCount.Text = "1";
}
if (!int.TryParse(txtCount.Text, out tCount))//如果转换成功，将值给tCount
{
md.MsgDivShow("输入的不是数字", 1);
return;
}
R_Order_Product rop = new R_Order_Product();
rop.DelFlag = 0;
rop.OrderId = Convert.ToInt32(labOrderId.Text);
rop.ProId = ((ProductInfo)dgvProduct.SelectedRows[0].DataBoundItem).ProId;
rop.SubTime = DateTime.Now;
rop.UnitCount = Convert.ToInt32(txtCount.Text);
R_Order_ProductBLL ropbll = new R_Order_ProductBLL();
md.MsgDivShow(ropbll.AddR_Order_Product(rop) ? "添加成功" : "添加失败", 1);
//刷新
//显示点的菜
LoadProductByOrderId(Convert.ToInt32(labOrderId.Text));
//坑啊
}
