public bool DeleteSingleOrderDetails(DeletedOrderDetails deletedOrderDetails) { int result = ExecuteUpdate("DeleteSingleOrderDetails", deletedOrderDetails); return result > 0; }
private void btnCancel_Click(object sender, EventArgs e) { if (dgvGoodsOrder.CurrentRow != null) { int selectIndex = dgvGoodsOrder.CurrentRow.Index; if (dgvGoodsOrder.Rows[selectIndex].Cells["OrderDetailsID"].Value != null) { int itemType = Convert.ToInt32(dgvGoodsOrder.Rows[selectIndex].Cells["ItemType"].Value); if (itemType == (int)OrderItemType.Details) { MessageBox.Show("细项不能单独删除!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (itemType == (int)OrderItemType.SetMeal) { MessageBox.Show("套餐项不能单独删除!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } Guid orderDetailsId = new Guid(dgvGoodsOrder.Rows[selectIndex].Cells["OrderDetailsID"].Value.ToString()); decimal goodsNum = Convert.ToDecimal(dgvGoodsOrder.Rows[selectIndex].Cells["GoodsNum"].Value); string goodsName = dgvGoodsOrder.Rows[selectIndex].Cells["GoodsName"].Value.ToString(); decimal goodsPrice = Convert.ToDecimal(dgvGoodsOrder.Rows[selectIndex].Cells["GoodsPrice"].Value); if (!RightsItemCode.FindRights(RightsItemCode.CANCELGOODS)) { decimal singleItemPriceSum = goodsPrice / goodsNum; if (itemType == (int)OrderItemType.Goods && selectIndex < dgvGoodsOrder.Rows.Count - 1) { for (int index = selectIndex + 1; index < dgvGoodsOrder.RowCount; index++) { if (Convert.ToInt32(dgvGoodsOrder.Rows[index].Cells["ItemType"].Value) == (int)OrderItemType.Goods) { break; } singleItemPriceSum += Convert.ToDecimal(dgvGoodsOrder.Rows[index].Cells["GoodsPrice"].Value) / Convert.ToDecimal(dgvGoodsOrder.Rows[index].Cells["GoodsNum"].Value); } if (singleItemPriceSum > ConstantValuePool.CurrentEmployee.LimitMoney) { if (DialogResult.Yes == MessageBox.Show("当前用户不具备该权限,并且超过最高退菜限额,是否更换用户?", "信息提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { //权限验证 bool hasRights = false; FormRightsCode formRightsCode = new FormRightsCode(); formRightsCode.ShowDialog(); if (formRightsCode.ReturnValue) { IList<string> rightsCodeList = formRightsCode.RightsCodeList; if (RightsItemCode.FindRights(rightsCodeList, RightsItemCode.CANCELGOODS)) { hasRights = true; } } if (!hasRights) { return; } } else { return; } } } } FormCancelOrder form = new FormCancelOrder(goodsName, goodsNum); form.ShowDialog(); if (form.DelItemNum > 0 && form.CurrentReason != null) { if (form.DelItemNum < goodsNum) { //Key:Index, Value:RemainNum Dictionary<int, decimal> dicRemainNum = new Dictionary<int, decimal>(); List<DeletedOrderDetails> deletedOrderDetailsList = new List<DeletedOrderDetails>(); //主项 decimal remainNum = goodsNum - form.DelItemNum; dicRemainNum.Add(selectIndex, remainNum); decimal originalDetailsNum = Convert.ToDecimal(dgvGoodsOrder.Rows[selectIndex].Cells["GoodsNum"].Value); decimal originalDetailsDiscount = Convert.ToDecimal(dgvGoodsOrder.Rows[selectIndex].Cells["GoodsDiscount"].Value); DeletedOrderDetails orderDetails = new DeletedOrderDetails(); orderDetails.OrderDetailsID = orderDetailsId; orderDetails.DeletedQuantity = -form.DelItemNum; orderDetails.RemainQuantity = remainNum; orderDetails.OffPay = Math.Round(-originalDetailsDiscount / originalDetailsNum * remainNum, 4); orderDetails.AuthorisedManager = ConstantValuePool.CurrentEmployee.EmployeeID; orderDetails.CancelEmployeeNo = ConstantValuePool.CurrentEmployee.EmployeeNo; orderDetails.CancelReasonName = form.CurrentReason.ReasonName; deletedOrderDetailsList.Add(orderDetails); //细项 if (selectIndex < dgvGoodsOrder.Rows.Count - 1) { for (int index = selectIndex + 1; index < dgvGoodsOrder.RowCount; index++) { if (Convert.ToInt32(dgvGoodsOrder.Rows[index].Cells["ItemType"].Value) == (int)OrderItemType.Goods) { break; } orderDetailsId = new Guid(dgvGoodsOrder.Rows[index].Cells["OrderDetailsID"].Value.ToString()); originalDetailsNum = Convert.ToDecimal(dgvGoodsOrder.Rows[index].Cells["GoodsNum"].Value); originalDetailsDiscount = Convert.ToDecimal(dgvGoodsOrder.Rows[index].Cells["GoodsDiscount"].Value); decimal delItemNum = originalDetailsNum / goodsNum * form.DelItemNum; remainNum = originalDetailsNum - delItemNum; dicRemainNum.Add(index, remainNum); DeletedOrderDetails item = new DeletedOrderDetails(); item.OrderDetailsID = orderDetailsId; item.DeletedQuantity = -delItemNum; item.RemainQuantity = remainNum; item.OffPay = Math.Round(-originalDetailsDiscount / originalDetailsNum * remainNum, 4); item.AuthorisedManager = ConstantValuePool.CurrentEmployee.EmployeeID; item.CancelEmployeeNo = ConstantValuePool.CurrentEmployee.EmployeeNo; item.CancelReasonName = form.CurrentReason.ReasonName; deletedOrderDetailsList.Add(item); } } //计算价格信息 decimal totalPrice = 0, totalDiscount = 0; for (int i = 0; i < dgvGoodsOrder.RowCount; i++) { if (dgvGoodsOrder.Rows[i].Cells["OrderDetailsID"].Value != null) { if (dicRemainNum.ContainsKey(i)) { decimal originalDetailsPrice = Convert.ToDecimal(dgvGoodsOrder.Rows[i].Cells["GoodsPrice"].Value); originalDetailsNum = Convert.ToDecimal(dgvGoodsOrder.Rows[i].Cells["GoodsNum"].Value); originalDetailsDiscount = Convert.ToDecimal(dgvGoodsOrder.Rows[i].Cells["GoodsDiscount"].Value); totalPrice += originalDetailsPrice / originalDetailsNum * dicRemainNum[i]; totalDiscount += originalDetailsDiscount / originalDetailsNum * dicRemainNum[i]; } else { totalPrice += Convert.ToDecimal(dgvGoodsOrder.Rows[i].Cells["GoodsPrice"].Value); totalDiscount += Convert.ToDecimal(dgvGoodsOrder.Rows[i].Cells["GoodsDiscount"].Value); } } } decimal wholePayMoney = totalPrice + totalDiscount; decimal actualPayMoney = CutOffDecimal.HandleCutOff(wholePayMoney, ConstantValuePool.SysConfig.IsCutTail, ConstantValuePool.SysConfig.CutTailType, ConstantValuePool.SysConfig.CutTailDigit); //构造DeletedSingleOrder对象 DeletedSingleOrder deletedSingleOrder = new DeletedSingleOrder(); deletedSingleOrder.OrderID = _salesOrder.order.OrderID; deletedSingleOrder.TotalSellPrice = totalPrice; deletedSingleOrder.ActualSellPrice = actualPayMoney; deletedSingleOrder.DiscountPrice = totalDiscount; deletedSingleOrder.CutOffPrice = wholePayMoney - actualPayMoney; deletedSingleOrder.deletedOrderDetailsList = deletedOrderDetailsList; if (DeletedOrderService.GetInstance().DeleteSingleOrder(deletedSingleOrder)) { foreach (KeyValuePair<int, decimal> item in dicRemainNum) { int index = item.Key; decimal remainsNum = item.Value; decimal detailsNum = Convert.ToDecimal(dgvGoodsOrder.Rows[index].Cells["GoodsNum"].Value); decimal detailsPrice = Convert.ToDecimal(dgvGoodsOrder.Rows[index].Cells["GoodsPrice"].Value); decimal detailsDiscount = Convert.ToDecimal(dgvGoodsOrder.Rows[index].Cells["GoodsDiscount"].Value); dgvGoodsOrder.Rows[index].Cells["GoodsNum"].Value = remainsNum; dgvGoodsOrder.Rows[index].Cells["GoodsPrice"].Value = detailsPrice / detailsNum * remainsNum; dgvGoodsOrder.Rows[index].Cells["GoodsDiscount"].Value = detailsDiscount / detailsNum * remainsNum; } } else { MessageBox.Show("删除品项失败!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } else { List<int> deletedIndexList = new List<int>(); List<DeletedOrderDetails> deletedOrderDetailsList = new List<DeletedOrderDetails>(); //主项 deletedIndexList.Add(selectIndex); DeletedOrderDetails orderDetails = new DeletedOrderDetails(); orderDetails.OrderDetailsID = orderDetailsId; orderDetails.DeletedQuantity = -Convert.ToDecimal(dgvGoodsOrder.Rows[selectIndex].Cells["GoodsNum"].Value); orderDetails.RemainQuantity = 0; orderDetails.OffPay = 0; orderDetails.AuthorisedManager = ConstantValuePool.CurrentEmployee.EmployeeID; orderDetails.CancelEmployeeNo = ConstantValuePool.CurrentEmployee.EmployeeNo; orderDetails.CancelReasonName = form.CurrentReason.ReasonName; deletedOrderDetailsList.Add(orderDetails); //细项 if (selectIndex < dgvGoodsOrder.RowCount - 1) { for (int index = selectIndex + 1; index < dgvGoodsOrder.RowCount; index++) { if (Convert.ToInt32(dgvGoodsOrder.Rows[index].Cells["ItemType"].Value) == (int)OrderItemType.Goods) { break; } deletedIndexList.Add(index); orderDetailsId = new Guid(dgvGoodsOrder.Rows[index].Cells["OrderDetailsID"].Value.ToString()); DeletedOrderDetails item = new DeletedOrderDetails(); item.OrderDetailsID = orderDetailsId; item.DeletedQuantity = -Convert.ToDecimal(dgvGoodsOrder.Rows[index].Cells["GoodsNum"].Value); item.RemainQuantity = 0; item.OffPay = 0; item.AuthorisedManager = ConstantValuePool.CurrentEmployee.EmployeeID; item.CancelEmployeeNo = ConstantValuePool.CurrentEmployee.EmployeeNo; item.CancelReasonName = form.CurrentReason.ReasonName; deletedOrderDetailsList.Add(item); } } //计算价格信息 decimal totalPrice = 0, totalDiscount = 0; for (int i = 0; i < dgvGoodsOrder.RowCount; i++) { if (dgvGoodsOrder.Rows[i].Cells["OrderDetailsID"].Value != null) { bool hasDeleted = false; foreach (int deletedIndex in deletedIndexList) { if (i == deletedIndex) { hasDeleted = true; break; } } if (hasDeleted) continue; totalPrice += Convert.ToDecimal(dgvGoodsOrder.Rows[i].Cells["GoodsPrice"].Value); totalDiscount += Convert.ToDecimal(dgvGoodsOrder.Rows[i].Cells["GoodsDiscount"].Value); } } decimal wholePayMoney = totalPrice + totalDiscount; decimal actualPayMoney = CutOffDecimal.HandleCutOff(wholePayMoney, ConstantValuePool.SysConfig.IsCutTail, ConstantValuePool.SysConfig.CutTailType, ConstantValuePool.SysConfig.CutTailDigit); //构造DeletedSingleOrder对象 DeletedSingleOrder deletedSingleOrder = new DeletedSingleOrder(); deletedSingleOrder.OrderID = _salesOrder.order.OrderID; deletedSingleOrder.TotalSellPrice = totalPrice; deletedSingleOrder.ActualSellPrice = actualPayMoney; deletedSingleOrder.DiscountPrice = totalDiscount; deletedSingleOrder.CutOffPrice = wholePayMoney - actualPayMoney; deletedSingleOrder.deletedOrderDetailsList = deletedOrderDetailsList; if (DeletedOrderService.GetInstance().DeleteSingleOrder(deletedSingleOrder)) { for (int i = deletedIndexList.Count - 1; i >= 0; i--) { dgvGoodsOrder.Rows.RemoveAt(deletedIndexList[i]); } } else { MessageBox.Show("删除品项失败!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } } } else { if (Convert.ToInt32(dgvGoodsOrder.Rows[selectIndex].Cells["ItemType"].Value) == (int)OrderItemType.Details) { dgvGoodsOrder.Rows.RemoveAt(selectIndex); } else if (Convert.ToInt32(dgvGoodsOrder.Rows[selectIndex].Cells["ItemType"].Value) == (int)OrderItemType.SetMeal) { MessageBox.Show("套餐项不能单独删除!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { dgvGoodsOrder.Rows.RemoveAt(selectIndex); if (selectIndex < dgvGoodsOrder.RowCount - 1) { for (int i = selectIndex; i < dgvGoodsOrder.RowCount; i++) { if (Convert.ToInt32(dgvGoodsOrder.Rows[i].Cells["ItemType"].Value) == (int)OrderItemType.Goods) { break; } dgvGoodsOrder.Rows.RemoveAt(i); i--; } } } } //统计 BindOrderInfoSum(); //更新第二屏信息 if (Screen.AllScreens.Length > 1 && ConstantValuePool.BizSettingConfig.SecondScreenEnabled) { if (ConstantValuePool.SecondScreenForm != null && ConstantValuePool.SecondScreenForm is FormSecondScreen) { ((FormSecondScreen)ConstantValuePool.SecondScreenForm).BindGoodsOrderInfo(dgvGoodsOrder); } } } }
private void btnCheckOut_Click(object sender, EventArgs e) { decimal refundAmount = decimal.Parse(txtRefundAmount.Text); decimal realReturnAmount = 0; if (!string.IsNullOrEmpty(txtRealReturnAmount.Text)) { realReturnAmount = decimal.Parse(txtRealReturnAmount.Text); } if (refundAmount == realReturnAmount) { //判断支付方式是否正确 bool IsPayoffWayRight = true; IList<OrderPayoff> _orderPayoffList = new List<OrderPayoff>(); foreach (KeyValuePair<string, OrderPayoff> item in dic) { if (item.Value.Quantity > 0) { _orderPayoffList.Add(item.Value); } } foreach (OrderPayoff orderPayoff in _orderPayoffList) { bool IsContains = false; OrderPayoff temp = null; foreach (OrderPayoff item in m_SalesOrder.orderPayoffList) { if (item.PayoffID.Equals(orderPayoff.PayoffID)) { IsContains = true; temp = item; break; } } if (IsContains) { decimal tempAmount = temp.AsPay * temp.Quantity - temp.NeedChangePay; decimal payAmount = orderPayoff.AsPay * orderPayoff.Quantity - orderPayoff.NeedChangePay; if (tempAmount < payAmount) { IsPayoffWayRight = false; break; } } else { IsPayoffWayRight = false; break; } } if (IsPayoffWayRight) { IList<OrderPayoff> orderPayoffList = new List<OrderPayoff>(); foreach (OrderPayoff item in m_SalesOrder.orderPayoffList) { bool IsContains = false; foreach (OrderPayoff orderPayoff in _orderPayoffList) { if (item.PayoffID.Equals(orderPayoff.PayoffID)) { decimal remainQty = ((item.AsPay * item.Quantity - item.NeedChangePay) - (orderPayoff.AsPay * orderPayoff.Quantity - orderPayoff.NeedChangePay)) / orderPayoff.AsPay; if (remainQty > 0) { OrderPayoff temp = new OrderPayoff(); temp.OrderPayoffID = Guid.NewGuid(); temp.OrderID = m_SalesOrder.order.OrderID; temp.PayoffID = item.PayoffID; temp.PayoffName = item.PayoffName; temp.PayoffType = item.PayoffType; temp.AsPay = item.AsPay; temp.Quantity = remainQty; temp.NeedChangePay = 0; temp.CardNo = item.CardNo; temp.EmployeeID = ConstantValuePool.CurrentEmployee.EmployeeID; orderPayoffList.Add(temp); } IsContains = true; break; } } if (!IsContains) { OrderPayoff temp = CopyExtension.Clone<OrderPayoff>(item); temp.OrderID = m_SalesOrder.order.OrderID; temp.OrderPayoffID = Guid.NewGuid(); temp.EmployeeID = ConstantValuePool.CurrentEmployee.EmployeeID; orderPayoffList.Add(temp); } } List<DeletedOrderDetails> deletedOrderDetailsList = new List<DeletedOrderDetails>(); for (int i = 0; i < dgvGoodsOrder.RowCount; i++) { OrderDetails tempOrderDetails = dgvGoodsOrder.Rows[i].Cells["OrderDetailsID"].Tag as OrderDetails; decimal tempGoodsNum = Convert.ToDecimal(dgvGoodsOrder.Rows[i].Cells["GoodsNum"].Value); decimal tempGoodsDiscount = Convert.ToDecimal(dgvGoodsOrder.Rows[i].Cells["GoodsDiscount"].Value); decimal tempDeletedNum = Convert.ToDecimal(dgvGoodsOrder.Rows[i].Cells["DelFlag"].Value); if (Math.Abs(tempDeletedNum) > 0) { decimal remainQty = tempGoodsNum - Math.Abs(tempDeletedNum); DeletedOrderDetails orderDetails = new DeletedOrderDetails(); orderDetails.OrderDetailsID = tempOrderDetails.OrderDetailsID; orderDetails.DeletedQuantity = tempDeletedNum; orderDetails.RemainQuantity = remainQty; orderDetails.OffPay = Math.Round(-tempGoodsDiscount / tempGoodsNum * remainQty, 4); orderDetails.AuthorisedManager = ConstantValuePool.CurrentEmployee.EmployeeID; orderDetails.CancelEmployeeNo = ConstantValuePool.CurrentEmployee.EmployeeNo; orderDetails.CancelReasonName = dgvGoodsOrder.Rows[i].Cells["DelReasonName"].Value.ToString(); ; deletedOrderDetailsList.Add(orderDetails); } } //构造DeletedPaidOrder对象 decimal paymentMoney = 0; foreach (OrderPayoff item in orderPayoffList) { paymentMoney += item.AsPay * item.Quantity; } Order order = new Order(); order.OrderID = m_SalesOrder.order.OrderID; order.TotalSellPrice = m_TotalPrice; order.ActualSellPrice = m_ActualPayMoney; order.DiscountPrice = m_Discount; order.CutOffPrice = m_CutOff; order.ServiceFee = m_ServiceFee; order.PaymentMoney = paymentMoney; order.NeedChangePay = 0; order.EmployeeID = ConstantValuePool.CurrentEmployee.EmployeeID; DeletedPaidOrder deletedPaidOrder = new DeletedPaidOrder(); deletedPaidOrder.order = order; deletedPaidOrder.deletedOrderDetailsList = deletedOrderDetailsList; deletedPaidOrder.orderPayoffList = orderPayoffList; if (DeletedOrderService.GetInstance().DeletePaidSingleOrder(deletedPaidOrder)) { m_IsChanged = true; this.Close(); } else { MessageBox.Show("单品删除失败,请重新操作!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } else { MessageBox.Show("退款支付方式不属于原结账支付方式,请重新支付!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } else { MessageBox.Show("应退金额与实退金额不一致,请重新支付!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }