Пример #1
0
        public void DoExport(string path)
        {
            try
            {
                // DataTable listtb1 = (dataGridView1.DataSource as DataTable);

                List <ReplenishDetail> list = CommonGlobalCache.ServerProxy.GetReplenishDetail(this.curReplenishOrder.ID);
                //  List<BoundDetail> list = CommonGlobalCache.ServerProxy.GetOutboundDetail(curReturnOrder.OutboundOrderID);
                // System.Collections.SortedList columns = new System.Collections.SortedList();
                List <String> keys   = new List <string>();
                List <String> values = new List <string>();
                int           ColNum = 0;
                foreach (DataGridViewColumn item in dataGridView1.Columns)
                {
                    ColNum++;
                    keys.Add(item.DataPropertyName);
                    if (item.HeaderText == "XL2")
                    {
                        item.HeaderText = "2XL";
                    }
                    if (item.HeaderText == "XL3")
                    {
                        item.HeaderText = "3XL";
                    }
                    if (item.HeaderText == "XL4")
                    {
                        item.HeaderText = "4XL";
                    }
                    if (item.HeaderText == "XL5")
                    {
                        item.HeaderText = "5XL";
                    }
                    if (item.HeaderText == "XL6")
                    {
                        item.HeaderText = "6XL";
                    }
                    values.Add(item.HeaderText);
                }

                foreach (ReplenishDetail cItem in list)
                {
                    cItem.CostumeName = CommonGlobalCache.GetCostumeName(cItem.CostumeID);
                }


                List <CellType> cellList = new List <CellType>();
                NPOIHelper.hsRowCount = 5;

                /*  CellType curCellI = new CellType();
                 * curCellI.RowIndex = 0;
                 * curCellI.CellName = "";
                 * if (ColNum % 2 == 0)
                 * {
                 *
                 *    curCellI.CellMergeNum = ColNum / 2 - 1;
                 * }
                 * else
                 * {
                 *    curCellI.CellMergeNum = ColNum / 2;
                 * }
                 * cellList.Add(curCellI);
                 */


                CellType curCell = new CellType();
                curCell.RowIndex = 0;

                curCell.CellName = "补货申请单";


                curCell.Title        = true;
                curCell.CellMergeNum = ColNum;

                // curCell.CellMergeIndex = 12;
                cellList.Add(curCell);

                CellType curCellOrder = new CellType();
                curCellOrder.RowIndex     = 1;
                curCellOrder.CellName     = "单号:";
                curCellOrder.CellMergeNum = 1;
                cellList.Add(curCellOrder);



                CellType curCellOrderValue = new CellType();
                curCellOrderValue.RowIndex     = 1;
                curCellOrderValue.CellName     = curReplenishOrder.ID;
                curCellOrderValue.CellMergeNum = 2;
                cellList.Add(curCellOrderValue);

                CellType curCellCreaterUser = new CellType();
                curCellCreaterUser.RowIndex     = 1;
                curCellCreaterUser.CellName     = "申请时间";
                curCellCreaterUser.CellMergeNum = 1;
                cellList.Add(curCellCreaterUser);

                CellType curCellCreaterUserValue = new CellType();
                curCellCreaterUserValue.RowIndex     = 1;
                curCellCreaterUserValue.CellName     = curReplenishOrder.CreateTime.GetDateTimeFormats('f')[0].ToString();
                curCellCreaterUserValue.CellMergeNum = 2;
                cellList.Add(curCellCreaterUserValue);


                CellType curCellTime = new CellType();
                curCellTime.RowIndex     = 2;
                curCellTime.CellName     = "申请店铺";
                curCellTime.CellMergeNum = 1;
                cellList.Add(curCellTime);

                CellType curCellTimeValue = new CellType();
                curCellTimeValue.RowIndex     = 2;
                curCellTimeValue.CellName     = curReplenishOrder.ShopName;
                curCellTimeValue.CellMergeNum = 2;
                cellList.Add(curCellTimeValue);



                CellType curCellSource = new CellType();
                curCellSource.RowIndex     = 2;
                curCellSource.CellName     = "申请人:";
                curCellSource.CellMergeNum = 1;
                cellList.Add(curCellSource);



                CellType curCellSourceValue = new CellType();
                curCellSourceValue.RowIndex     = 2;
                curCellSourceValue.CellName     = CommonGlobalCache.GetUserName(curReplenishOrder.RequestGuideID);
                curCellSourceValue.CellMergeNum = 2;
                cellList.Add(curCellSourceValue);


                CellType curCellTarget = new CellType();
                curCellTarget.RowIndex     = 3;
                curCellTarget.CellName     = "总数量:";
                curCellTarget.CellMergeNum = 1;
                cellList.Add(curCellTarget);



                CellType curCellTargetValue = new CellType();
                curCellTargetValue.RowIndex     = 3;
                curCellTargetValue.CellName     = curReplenishOrder.TotalCount.ToString();
                curCellTargetValue.CellMergeNum = 2;
                cellList.Add(curCellTargetValue);



                CellType curCellTotal = new CellType();
                curCellTotal.RowIndex     = 3;
                curCellTotal.CellName     = "金额:";
                curCellTotal.CellMergeNum = 1;
                cellList.Add(curCellTotal);



                CellType curCellTotalValue = new CellType();
                curCellTotalValue.RowIndex     = 3;
                curCellTotalValue.CellName     = curReplenishOrder.TotalPrice.ToString();
                curCellTotalValue.CellMergeNum = 2;
                cellList.Add(curCellTotalValue);



                CellType curCellRemark = new CellType();
                curCellRemark.RowIndex     = 4;
                curCellRemark.CellName     = "备注:";
                curCellRemark.CellMergeNum = 1;
                cellList.Add(curCellRemark);



                CellType curCellRemarkValue = new CellType();
                curCellRemarkValue.RowIndex     = 4;
                curCellRemarkValue.CellName     = curReplenishOrder.Remarks.ToString();
                curCellRemarkValue.CellMergeNum = 8;
                cellList.Add(curCellRemarkValue);



                NPOIHelper.CellValues = cellList;


                NPOIHelper.Keys   = keys.ToArray();
                NPOIHelper.Values = values.ToArray();
                NPOIHelper.ExportExcel(DataGridViewUtil.ToDataTable(list), path);

                GlobalMessageBox.Show("导出完毕!");
            }
            catch (Exception ex)
            { ShowError(ex); }
            finally
            {
                UnLockPage();
            }
        }
Пример #2
0
        //点击出库按钮
        private void Save(bool isHang)
        {
            try
            {
                if (skinComboBoxShopID.DataSource == null || (skinComboBoxShopID.DataSource as List <Shop>).Count == 0)
                {
                    GlobalMessageBox.Show("没有店铺可以调拨");
                    return;
                }

                /*  if (this.guideComboBox1.SelectedIndex == 0 && IsPos)
                 * {
                 *    GlobalMessageBox.Show("操作人不能为空!");
                 *    return;
                 * }*/
                bool isSuperLen = false;
                foreach (BoundDetail detail in this.curDetailList)
                {
                    if ((detail.Price > 0 && detail.Price > Convert.ToDecimal(99999999.99)) || (detail.SalePrice > 0 && detail.SalePrice > Convert.ToDecimal(99999999.99)) ||
                        (detail.SumMoney > 0 && detail.SumMoney > Convert.ToDecimal(99999999.99)))
                    {
                        isSuperLen = true;
                        break;
                    }
                }
                if (isSuperLen)
                {
                    GlobalMessageBox.Show("列表中吊牌价、售价或每款总金额不能大于99999999.99");
                    return;
                }
                AllocateOutboundPara item = this.Build();
                if (item == null || item.OutboundOrder.TotalCount == 0)
                {
                    GlobalMessageBox.Show("调拨单为空,不能出库!");
                    return;
                }

                if (action == OperationEnum.Send)
                {
                    item.ReplenishOrderID = order.ID;
                }
                else
                {
                    item.ReplenishOrderID = null;
                }

                if (GlobalMessageBox.Show("是否确认操作?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
                {
                    return;
                }
                //检查库存信息

                if (CommonGlobalUtil.EngineUnconnectioned(this))
                {
                    return;
                }

                InteractResult result = null;
                if (isHang)
                {
                    result = CommonGlobalCache.ServerProxy.HangUpAllocateOrder(item);
                }
                else
                {
                    result = CommonGlobalCache.ServerProxy.AllocateOutbound(item);
                }


                switch (result.ExeResult)
                {
                case ExeResult.Success:
                    if (isHang)
                    {
                        GlobalMessageBox.Show("挂单成功!");
                    }
                    else
                    {
                        GlobalMessageBox.Show("调拨成功!");
                        //增加打印功能,先给后台使用
                        if (this.skinCheckBoxPrint.Checked)
                        {
                            //   AllocateOrderPrinter.ExcelTemplatePrint(item, curDetailList);
                            //Column2.Visible = false;
                            //SumMoney.Visible = false;
                            //Column2.Tag = AllocateOrderPrintUtil.PrinterNoCount;
                            //SumMoney.Tag = AllocateOrderPrintUtil.PrinterNoCount;
                            DataGridView dgv = deepCopyDataGridView();
                            AllocateOrderPrintUtil.Print(item.AllocateOrder, dgv);
                            //SumMoney.Visible = true;
                            //Column2.Visible = true;
                        }

                        //if (CommonGlobalCache.GetParameter(ParameterConfigKey.AllocateInDirectly)?.ParaValue == "1")
                        //{
                        //    if (InboundConfirmCtrl.AutoInbound(item.AllocateOrder))
                        //    {

                        //    }
                        //}
                    }
                    ResetAll(true);

                    if (!IsShowOnePage)
                    {
                        TabPageClose(this.CurrentTabPage, this.SourceCtrlType);
                    }
                    break;

                case ExeResult.Error:
                    GlobalMessageBox.Show(result.Msg);
                    break;

                default:
                    break;
                }
            }
            catch (Exception ex)
            {
                CommonGlobalUtil.ShowError(ex);
            }
            finally
            {
                CommonGlobalUtil.UnLockPage(this);
            }
        }
Пример #3
0
        private void BaseButton_OK_Click(object sender, EventArgs e)
        {
            RechargeResult result = RechargeResult.Error;

            try
            {
                /* if (this.guideComboBox1.SelectedIndex == 0)
                 * {
                 *   GlobalMessageBox.Show("操作人不能为空");
                 *   return;
                 * }*/
                if (this.member == null)
                {
                    GlobalMessageBox.Show("充值会员不能为空!");
                    return;
                }
                //if (this.member.CardType != 1)
                //{
                //    GlobalMessageBox.Show("该会员不是充值卡会员!");
                //    return;
                //}
                //  int rechargeMoney = int.Parse(this.skinTextBox_RechargeMoney.SkinTxt.Text);
                int moneyCash     = Decimal.ToInt32(this.skinTextBox_MoneyCash.Value);
                int moneyBankCard = Decimal.ToInt32(this.skinTextBox_MoneyBankCard.Value);
                int moneyAlipay   = Decimal.ToInt32(this.skinTextBox_MoneyAlipay.Value);
                int moneyWeiXin   = Decimal.ToInt32(this.skinTextBox_MoneyWeiXin.Value);
                int rechargeMoney = moneyCash + moneyBankCard + moneyAlipay + moneyWeiXin;
                if (rechargeMoney <= 0)
                {
                    GlobalMessageBox.Show("充值金额应为正整数,充值失败");
                    return;
                }

                if (CommonGlobalUtil.EngineUnconnectioned(this))
                {
                    return;
                }

                int     donateMoney = int.Parse(this.skinLabel_GiveMoney.Text);
                decimal balanceNew  = this.member.Balance + donateMoney + rechargeMoney;
                result = CommonGlobalCache.ServerProxy.Recharge(new RechargeRecord()
                {
                    ID            = IDHelper.GetID(OrderPrefix.RechargeRecordOrder, shop.AutoCode),
                    BalanceOld    = this.member.Balance,
                    BalanceNew    = balanceNew,
                    DonateMoney   = donateMoney,
                    MemberID      = this.member.PhoneNumber,
                    GuideID       = this.guideID,
                    MoneyAlipay   = moneyAlipay,
                    MoneyBankCard = moneyBankCard,
                    MoneyCash     = moneyCash,
                    MoneyWeiXin   = moneyWeiXin,
                    RechargeMoney = rechargeMoney,
                    CreateTime    = DateTime.Now,
                    Remarks       = this.skinTextBox_Remark.Text,
                    MemberName    = this.member.Name,
                    ShopID        = shop.ID
                }
                                                                );
                UnLockPage();
                switch (result)
                {
                case RechargeResult.Success:
                    RechargeDialogForm form = new RechargeDialogForm(member, rechargeMoney, donateMoney, balanceNew);
                    if (form.ShowDialog() == DialogResult.OK)
                    {
                    }
                    this.member = CommonGlobalCache.ServerProxy.GetOneMember(this.member.PhoneNumber);
                    this.SetMemberLabel();
                    this.CleanRechargeTextBox();
                    //20180616充值完成自动关闭!
                    //  if (isClose) {
                    //只给POS端收银充值用
                    TabPageClose(this.CurrentTabPage, this);
                    break;

                case RechargeResult.MemberIsNotExist:
                    GlobalMessageBox.Show("会员不存在!");
                    break;

                case RechargeResult.Error:
                    GlobalMessageBox.Show("内部错误!");
                    break;

                default:
                    break;
                }
            }
            catch (Exception ee)
            {
                WriteLog(ee);
            }
            finally
            {
                UnLockPage();
            }
        }
Пример #4
0
        private void baseButton3_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.guideComboBox1.SelectedIndex == 0)
                {
                    GlobalMessageBox.Show("该笔单的导购员不能为空!");
                    return;
                }

                string id = IDHelper.GetID(OrderPrefix.RefundOrder, CommonGlobalCache.GetShop(shopID).AutoCode);

                bool isNoHasGuidFlag = false;
                bool isSuperlen      = false;
                if (this.retailDetailList != null && this.retailDetailList.Count > 0)
                {
                    foreach (RetailDetail detail in this.retailDetailList)
                    {
                        if (detail.GuideID == null || detail.GuideID == "")
                        {
                            isNoHasGuidFlag = true;
                            break;
                        }
                        if (Math.Abs(detail.SumMoney) > 0 && Math.Abs(detail.SumMoney) > Convert.ToDecimal(99999999.99))
                        {
                            isSuperlen = true;
                            break;
                        }
                    }
                }

                if (isNoHasGuidFlag)
                {
                    GlobalMessageBox.Show("导购员不能为空,请检查列表里所有款号的导购员!");
                    return;
                }
                if (isSuperlen)
                {
                    GlobalMessageBox.Show("请检查列表里所有款号的金额是否大于99999999.99!");
                    return;
                }


                #region 创建RefundCostume对象


                RefundCostume costume = new RefundCostume()
                {
                    RefundOrder      = null,
                    RefundDetailList = new List <RetailDetail>()
                };
                int     totalCount = 0;
                decimal totalPrice = 0;
                decimal totalCost  = 0;
                decimal moneyCash  = 0;
                foreach (RetailDetail detail in this.
                         retailDetailList)
                {
                    if (detail.IsRefund && detail.RefundCount > 0)
                    {
                        detail.Refunded  = true;
                        totalCount      += detail.RefundCount;
                        totalPrice      += detail.RefundCount * detail.Price;
                        totalCost       += detail.RefundCount * detail.CostPrice;
                        moneyCash       += detail.SumMoney;
                        detail.SalePrice = detail.Price;
                        costume.RefundDetailList.Add(this.RetailDetailToRefundDetail(detail, id));
                    }
                }

                List <String> costumeIds = new List <string>();
                foreach (var item in costume.RefundDetailList)
                {
                    if (!costumeIds.Contains(item.CostumeID))
                    {
                        costumeIds.Add(item.CostumeID);
                    }
                }

                if (costumeIds != null && costumeIds.Count > 0)
                {
                    //判断是否又禁用的商品,并提示返回
                    InteractResult interactResult = GlobalCache.ServerProxy.IsCostumeValid(costumeIds);
                    if (interactResult.ExeResult == ExeResult.Error)
                    {
                        GlobalMessageBox.Show(interactResult.Msg);
                        return;
                    }
                }

                RetailOrder refundOrder = new RetailOrder()
                {
                    ID            = id,
                    IsRefundOrder = true,
                    OriginOrderID = string.Empty,
                    //GuideID = (string)("-1".Equals(this.guideComboBox2.SelectedValue) ? string.Empty : this.guideComboBox2.SelectedValue),
                    //  OperateGuideID = (string)this.guideComboBox1.SelectedValue,
                    GuideID          = (string)this.guideComboBox1.SelectedValue,
                    ShopID           = shopID,
                    MemeberID        = this.memberIDTextBox2.Text,
                    SalesPromotionID = string.Empty,
                    PromotionText    = string.Empty,
                    //   TotalMoneyReceived = this.currentRetailCostume.RetailOrder.TotalMoneyReceived,
                    // TotalMoneyReceivedActual = this.currentRetailCostume.RetailOrder.TotalMoneyReceivedActual,
                    MoneyBankCard     = 0,
                    MoneyWeiXin       = 0,
                    MoneyOther        = 0,
                    MoneyAlipay       = 0,
                    SmallMoneyRemoved = 0,
                    MoneyChange       = 0,
                    TotalCount        = totalCount * -1,
                    TotalCost         = totalCost * -1,
                    TotalPrice        = totalPrice * -1,
                    EntryUserID       = CommonGlobalCache.CurrentUserID,
                    MoneyDiscounted   = 0,//若是全部退款,折扣金额为原始折扣金额,否则为0
                    Remarks           = this.skinTextBox_RefundReason.SkinTxt.Text.Trim(),
                    CreateTime        = DateTime.Now,
                };
                costume.RefundOrder = refundOrder;


                #endregion
                costume.RefundOrder.MoneyCash          = moneyCash * -1;
                costume.RefundOrder.MoneyCash2         = costume.RefundOrder.MoneyCash;
                costume.RefundOrder.MoneyIntegration   = 0;
                costume.RefundOrder.MoneyVipCard       = 0;
                costume.RefundOrder.MoneyVipCardMain   = 0;
                costume.RefundOrder.MoneyVipCardDonate = 0;
                costume.RefundOrder.CreateTime         = dateTimePicker_Start.Value;
                costume.RefundOrder.EntryTime          = DateTime.Now;
                //总计=现金+积分+VIP卡+优惠券
                //这笔单的应收金额 - (不退的那几件以原价* 数量 -满减金额) - (退的那几件)优惠券
                costume.RefundOrder.TotalMoneyReceived       = costume.RefundOrder.MoneyCash + costume.RefundOrder.MoneyIntegration + costume.RefundOrder.MoneyVipCard;
                costume.RefundOrder.TotalMoneyReceivedActual = costume.RefundOrder.MoneyCash + costume.RefundOrder.MoneyVipCardMain;
                costume.RefundOrder.Benefit = costume.RefundOrder.TotalMoneyReceivedActual - costume.RefundOrder.TotalCost;

                //     this.moneyDiscounted = costume.RefundOrder.to- costume.RefundOrder ;
                costume.IsNotHaveRetailOrder = true;
                if (Math.Abs(costume.RefundOrder.TotalCount) < 1)
                {
                    GlobalMessageBox.Show("退货数量不能小于1");
                    return;
                }
                ConfirmRefundForm confirmRefundForm = new ConfirmRefundForm(costume, shopID, dataGridView1);
                DialogResult      result            = confirmRefundForm.ShowDialog();
                if (result == DialogResult.Cancel)
                {
                    return;
                }
                this.ResetForm();
            }
            catch (Exception ee)
            {
                GlobalUtil.ShowError(ee);
            }
        }
Пример #5
0
        //当单元格中的金额或折扣值发生变化时,对应修改另一项的值
        private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex > -1 && e.ColumnIndex > -1)
            {
                try
                {
                    RetailDetail detail = this.retailDetailList[e.RowIndex];

                    if (e.ColumnIndex == GuideName.Index)
                    {
                        detail.GuideID = this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
                    }


                    switch (this.dataGridView1.Columns[e.ColumnIndex].HeaderText)
                    {
                    case "折扣":
                        if (balanceRound)
                        {
                            detail.SumMoney       = detail.RefundCount * Math.Round(detail.Price * detail.Discount * (decimal)0.01, MidpointRounding.AwayFromZero);
                            detail.SumMoneyActual = detail.SumMoney;
                        }
                        else
                        {
                            detail.SumMoney       = detail.Price * detail.Discount * detail.RefundCount * (decimal)0.01;
                            detail.SumMoneyActual = detail.SumMoney;
                        }


                        break;

                    case "金额":

                        detail.Discount = (Math.Round((detail.SumMoney * 100) / (detail.Price * detail.RefundCount), 1, MidpointRounding.AwayFromZero));
                        break;

                    case "数量":
                        if (balanceRound)
                        {
                            detail.SumMoney       = detail.RefundCount * Math.Round(detail.Price * detail.Discount * (decimal)0.01, MidpointRounding.AwayFromZero);
                            detail.SumMoneyActual = detail.SumMoney;
                        }
                        else
                        {
                            detail.SumMoney       = detail.Price * detail.Discount * detail.RefundCount * (decimal)0.01;
                            detail.SumMoneyActual = detail.SumMoney;
                        }
                        //268 畅滞排行榜:商品退货后,零售金额变成0
                        detail.SumCost = detail.CostPrice * detail.RefundCount;
                        break;

                    case "使用优惠券":
                        detail.IsUseTickets = (bool)this.dataGridView1[e.ColumnIndex, e.RowIndex].Value;

                        break;
                    }

                    this.dataGridView1.Refresh();
                }
                catch (Exception ex)
                {
                    GlobalUtil.WriteLog(ex);
                    GlobalMessageBox.Show("内部错误,金额与折扣转化出错!");
                }
            }
        }
Пример #6
0
        private void BaseButton_AddCostume_Click(object sender, EventArgs e)
        {
            try
            {
                int buyCount = int.Parse(this.skinTextBox_bugCount.SkinTxt.Text);
                if (buyCount <= 0)
                {
                    GlobalMessageBox.Show("退货数量必须大于0!");
                    return;
                }
                string       selectShopid = ValidateUtil.CheckEmptyValue(this.skinComboBoxShopID.SelectedValue);
                List <Guide> guideList    = CommonGlobalCache.GuideList.FindAll(t => t.State == 0 && t.ShopID == selectShopid);

                this.GuideName.DataSource    = guideList;
                this.GuideName.DisplayMember = "Name";
                this.GuideName.ValueMember   = "ID";
                string defaultGuid = string.Empty;
                if (this.guideComboBox1.SelectedIndex > 0)
                {
                    defaultGuid = ValidateUtil.CheckEmptyValue(this.guideComboBox1.SelectedValue);
                }

                RetailDetail detail = new RetailDetail()
                {
                    Costume     = this.currentSelectedItem.Costume,
                    CostumeID   = this.currentSelectedItem.Costume.ID,
                    CostumeName = this.currentSelectedItem.Costume.Name,
                    ColorName   = this.skinComboBox_Color.Text,
                    SizeName    = ValidateUtil.CheckEmptyValue(this.skinComboBox_Size.SelectedValue),
                    GuideID     = defaultGuid,
                    // 显示自己设置的尺码组和对应的尺码列表
                    SizeDisplayName = CostumeStoreHelper.GetCostumeSizeName(ValidateUtil.CheckEmptyValue(this.skinComboBox_Size.SelectedValue), CommonGlobalCache.GetSizeGroup(this.currentSelectedItem.Costume.SizeGroupName)),
                    IsRefund        = true,
                    RefundCount     = buyCount,
                    BuyCount        = buyCount,
                    Price           = this.currentSelectedItem.Costume.Price,
                    SumMoney        = this.currentSelectedItem.Costume.Price * buyCount,
                    SumMoneyActual  = this.currentSelectedItem.Costume.Price * buyCount,
                    BrandName       = ValidateUtil.CheckNotNullValue(currentSelectedItem.Costume.BrandName),
                    //  SinglePrice = this.currentSelectedItem.Costume.Price,
                    IsUseTickets = false,
                    ///288 收银时,商品的备注显示的是商品的备注
                    //Remarks = this.currentSelectedItem.Costume.Remarks,
                    Discount            = 100,
                    DiscountOrigin      = 100,
                    AllowReviseDiscount = true,//this.currentSelectedStore.AllowReviseDiscount,
                    CostPrice           = this.currentSelectedItem.Costume.CostPrice,
                    SumCost             = this.currentSelectedItem.Costume.CostPrice * buyCount,
                };

                if (!this.AddSelectedCostumeToList(detail))
                {
                    return;
                }
                dataGridViewPagingSumCtrl.BindingDataSource(DataGridViewUtil.ListToBindingList(this.retailDetailList));
                this.skinTextBox_bugCount.SkinTxt.Text = "1";
            }
            catch (Exception ee)
            {
                CommonGlobalUtil.WriteLog(ee);
                GlobalMessageBox.Show("添加失败!");
            }
        }
        private void DoExport()
        {
            try
            {
                DataTable     list   = null;
                List <String> keys   = new List <string>();
                List <String> values = new List <string>();
                if (this.skinTextBox_costumeID.SkinTxt.Text.Trim() != "" && ValidateUtil.CheckEmptyValue(this.skinComboBox_PfCustomer.SelectedValue) == "")
                {
                    var dt = new DataTable(typeof(PfCustomerInvoicing).Name);
                    foreach (DataGridViewColumn p in view.Columns)
                    {
                        if (!p.DataPropertyName.Contains("PfCustomerID"))
                        {
                            keys.Add(p.DataPropertyName);

                            if (p.DataPropertyName == "Delivery" || p.DataPropertyName == "Retail" || p.DataPropertyName == "PfCustomerStore")
                            {
                                values.Add("小计" + p.HeaderText);
                            }
                            else if ((p.DataPropertyName.Contains("Delivery") && p.DataPropertyName != "Delivery") ||
                                     (p.DataPropertyName.Contains("Retail") && p.DataPropertyName != "Retail") ||
                                     p.DataPropertyName.Contains("PfCustomerStore") && p.DataPropertyName != "PfCustomerStore")
                            {
                                /*   int CurColumnindex = -1;
                                 * if (p.DataPropertyName.Contains("Delivery"))
                                 * {
                                 *     CurColumnindex= p.Index + 1;
                                 * }*/

                                DataTable curdt = p.DataGridView.DataSource as DataTable;

                                string pfcustomerId = curdt.Rows[0]["PfCustomerID" + p.DataPropertyName.Replace("PfCustomerStore", "").Replace("Retail", "").Replace("Delivery", "")].ToString();
                                if (pfcustomerId == "0")
                                {
                                    for (int i = 0; i < curdt.Rows.Count; i++)
                                    {
                                        if (curdt.Rows[i]["PfCustomerID" + p.DataPropertyName.Replace("PfCustomerStore", "").Replace("Retail", "").Replace("Delivery", "")].ToString() != "0")
                                        {
                                            pfcustomerId = curdt.Rows[i]["PfCustomerID" + p.DataPropertyName.Replace("PfCustomerStore", "").Replace("Retail", "").Replace("Delivery", "")].ToString();
                                            break;
                                        }
                                    }
                                }
                                string CName = PfCustomerCache.PfCustomerList.Find(t => t.ID.Equals(pfcustomerId)).Name;
                                values.Add(CName + p.HeaderText);
                            }
                            else
                            {
                                values.Add(p.HeaderText);
                            }
                        }
                    }
                    list = (DataTable)view.DataSource;
                }
                else
                {
                    if (dataGridView1.DataSource != null && dataGridView1.Rows.Count > 0)
                    {
                        list = (DataTable)this.dataGridView1.DataSource;
                        foreach (DataGridViewColumn item in dataGridView1.Columns)
                        {
                            if (item.Visible)
                            {
                                keys.Add(item.DataPropertyName);
                                values.Add(item.HeaderText);
                            }
                        }
                    }
                }

                NPOIHelper.Keys   = keys.ToArray();
                NPOIHelper.Values = values.ToArray();
                NPOIHelper.ExportExcel(list, path);

                GlobalMessageBox.Show("导出完毕!");
            }
            catch (Exception ex)
            { ShowError(ex); }
            finally
            {
                UnLockPage();
            }
        }
Пример #8
0
        private void dataGridView_MonthTask_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            DataGridView view = sender as DataGridView;

            if (e.ColumnIndex < 0 || e.RowIndex < 0)
            {
                return;
            }

            try
            {
                if (CommonGlobalUtil.EngineUnconnectioned(this))
                {
                    return;
                }

                //当前更改的列
                DataGridViewCell cell = view.CurrentCell;
                //当前绑定数据
                MonthTaskSearch item = cell.OwningRow.DataBoundItem as MonthTaskSearch;
                MonthTask       task = item.MonthTasks[e.ColumnIndex - 1];
                task.ShopID = item.Shop.ID;


                int monthIndex = e.ColumnIndex;
                switch (monthIndex)
                {//增加了序号
                case 1:
                    task.MoneyOfSale = Decimal.ToInt32(item.Target1);
                    task.AutoID      = item.AutoID1;
                    break;

                case 2:
                    task.MoneyOfSale = Decimal.ToInt32(item.Target2); task.AutoID = item.AutoID2;
                    break;

                case 3:
                    task.MoneyOfSale = Decimal.ToInt32(item.Target3); task.AutoID = item.AutoID3;
                    break;

                case 4:
                    task.MoneyOfSale = Decimal.ToInt32(item.Target4); task.AutoID = item.AutoID4;
                    break;

                case 5:
                    task.MoneyOfSale = Decimal.ToInt32(item.Target5); task.AutoID = item.AutoID5;
                    break;

                case 6:
                    task.MoneyOfSale = Decimal.ToInt32(item.Target6); task.AutoID = item.AutoID6;
                    break;

                case 7:
                    task.MoneyOfSale = Decimal.ToInt32(item.Target7); task.AutoID = item.AutoID7;
                    break;

                case 8:
                    task.MoneyOfSale = Decimal.ToInt32(item.Target8); task.AutoID = item.AutoID8;
                    break;

                case 9:
                    task.MoneyOfSale = Decimal.ToInt32(item.Target9); task.AutoID = item.AutoID9;
                    break;

                case 10:
                    task.MoneyOfSale = Decimal.ToInt32(item.Target10); task.AutoID = item.AutoID10;
                    break;

                case 11:
                    task.MoneyOfSale = Decimal.ToInt32(item.Target11); task.AutoID = item.AutoID11;
                    break;

                case 12:
                    task.MoneyOfSale = Decimal.ToInt32(item.Target12); task.AutoID = item.AutoID12;
                    break;

                default:
                    break;
                }


                //if (task.MoneyOfSale == 0) {
                //    GlobalMessageBox.Show(this.FindForm(), "不能设置为0!");
                //    dataGridView_RefundDetail.CellValueChanged -= dataGridView_RefundDetail_CellValueChanged;
                //    dataGridView_MonthTask.CellValueChanged -= dataGridView_MonthTask_CellValueChanged;
                //    view.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = clickValue;
                //    view.Rows[e.RowIndex].Cells[e.ColumnIndex].Selected = true;
                //    dataGridView_RefundDetail.CellValueChanged += dataGridView_RefundDetail_CellValueChanged;
                //    dataGridView_MonthTask.CellValueChanged += dataGridView_MonthTask_CellValueChanged;
                //    //view.CancelEdit();
                //    //view.RefreshEdit(); view.Refresh();
                //    return;
                //}
                task.Month   = item.Year * 100 + monthIndex;
                task.GuideID = "";
                UpdateMonthTaskResult result = CommonGlobalCache.ServerProxy.UpdateMonthTask(task);
                switch (result)
                {
                case UpdateMonthTaskResult.Success:
                    //平摊
                    AvgDetail(task);

                    break;

                case UpdateMonthTaskResult.IsLessCurrentMonth:
                    view.CancelEdit();
                    break;

                case UpdateMonthTaskResult.Error:
                    view.CancelEdit();
                    GlobalMessageBox.Show("内部错误!");
                    break;

                default:
                    break;
                }
            }
            catch (Exception ee)
            {
                ShowError(ee);
            }
            finally
            {
                UnLockPage();
            }
        }
Пример #9
0
        public void DoExport(string path)
        {
            try
            {
                // DataTable listtb1 = (dataGridView1.DataSource as DataTable);

                List <PfOrderDetail> list = CommonGlobalCache.ServerProxy.GetPfOrderDetails(this.curReturnOrder.ID);
                //  List<BoundDetail> list = CommonGlobalCache.ServerProxy.GetOutboundDetail(curReturnOrder.OutboundOrderID);
                // System.Collections.SortedList columns = new System.Collections.SortedList();
                List <String> keys   = new List <string>();
                List <String> values = new List <string>();
                int           ColNum = 0;
                foreach (DataGridViewColumn item in dataGridView1.Columns)
                {
                    if (item.Visible)
                    {
                        ColNum++;
                        keys.Add(item.DataPropertyName);
                        if (item.HeaderText == "XL2")
                        {
                            item.HeaderText = "2XL";
                        }
                        if (item.HeaderText == "XL3")
                        {
                            item.HeaderText = "3XL";
                        }
                        if (item.HeaderText == "XL4")
                        {
                            item.HeaderText = "4XL";
                        }
                        if (item.HeaderText == "XL5")
                        {
                            item.HeaderText = "5XL";
                        }
                        if (item.HeaderText == "XL6")
                        {
                            item.HeaderText = "6XL";
                        }
                        values.Add(item.HeaderText);
                    }
                }

                foreach (PfOrderDetail cItem in list)
                {
                    // cItem.CostumeName = CommonGlobalCache.GetCostumeName(cItem.CostumeID);
                }


                List <CellType> cellList = new List <CellType>();
                NPOIHelper.hsRowCount = 5;

                /*  CellType curCellI = new CellType();
                 * curCellI.RowIndex = 0;
                 * curCellI.CellName = "";
                 * if (ColNum % 2 == 0)
                 * {
                 *
                 *   curCellI.CellMergeNum = ColNum / 2 - 1;
                 * }
                 * else
                 * {
                 *   curCellI.CellMergeNum = ColNum / 2;
                 * }
                 * cellList.Add(curCellI);
                 */


                CellType curCell = new CellType();
                curCell.RowIndex = 0;
                if (curReturnOrder.IsRefundOrder)
                {
                    curCell.CellName = "批发退货单";
                }
                else
                {
                    curCell.CellName = "批发发货单";
                }

                if (ColNum % 2 == 0)
                {
                    curCell.CellMergeNum = ColNum;
                }
                else
                {
                    curCell.CellMergeNum = ColNum;
                }
                // curCell.CellMergeIndex = 12;
                curCell.Title = true;
                cellList.Add(curCell);

                CellType curCellOrder = new CellType();
                curCellOrder.RowIndex     = 1;
                curCellOrder.CellName     = "单号:";
                curCellOrder.CellMergeNum = 1;
                cellList.Add(curCellOrder);



                CellType curCellOrderValue = new CellType();
                curCellOrderValue.RowIndex     = 1;
                curCellOrderValue.CellName     = curReturnOrder.ID;
                curCellOrderValue.CellMergeNum = 2;
                cellList.Add(curCellOrderValue);

                CellType curCellCreaterUser = new CellType();
                curCellCreaterUser.RowIndex     = 1;
                curCellCreaterUser.CellName     = "客户";
                curCellCreaterUser.CellMergeNum = 1;
                cellList.Add(curCellCreaterUser);

                CellType curCellCreaterUserValue = new CellType();
                curCellCreaterUserValue.RowIndex     = 1;
                curCellCreaterUserValue.CellName     = curReturnOrder.PfCustomerName;
                curCellCreaterUserValue.CellMergeNum = 2;
                cellList.Add(curCellCreaterUserValue);



                CellType curCellTime = new CellType();
                curCellTime.RowIndex     = 1;
                curCellTime.CellName     = "开单时间";
                curCellTime.CellMergeNum = 1;
                cellList.Add(curCellTime);

                CellType curCellTimeValue = new CellType();
                curCellTimeValue.RowIndex     = 1;
                curCellTimeValue.CellName     = curReturnOrder.CreateTime.GetDateTimeFormats('f')[0].ToString();;
                curCellTimeValue.CellMergeNum = 2;
                cellList.Add(curCellTimeValue);



                CellType curCellSource = new CellType();
                curCellSource.RowIndex     = 2;
                curCellSource.CellName     = "操作人:";
                curCellSource.CellMergeNum = 1;
                cellList.Add(curCellSource);



                CellType curCellSourceValue = new CellType();
                curCellSourceValue.RowIndex     = 2;
                curCellSourceValue.CellName     = curReturnOrder.AdminUserName;
                curCellSourceValue.CellMergeNum = 2;
                cellList.Add(curCellSourceValue);


                CellType curCellTarget = new CellType();
                curCellTarget.RowIndex     = 2;
                curCellTarget.CellName     = "付款方式:";
                curCellTarget.CellMergeNum = 1;
                cellList.Add(curCellTarget);



                CellType curCellTargetValue = new CellType();
                curCellTargetValue.RowIndex = 2;
                if (curReturnOrder.PayType == 0)
                {
                    curCellTargetValue.CellName = "记账";
                }
                if (curReturnOrder.PayType == 1)
                {
                    curCellTargetValue.CellName = "余额";
                }
                if (curReturnOrder.PayType == 2)
                {
                    curCellTargetValue.CellName = "现金";
                }
                curCellTargetValue.CellMergeNum = 2;
                cellList.Add(curCellTargetValue);



                CellType curCellTotal = new CellType();
                curCellTotal.RowIndex     = 2;
                curCellTotal.CellName     = "总数量:";
                curCellTotal.CellMergeNum = 1;
                cellList.Add(curCellTotal);



                CellType curCellTotalValue = new CellType();
                curCellTotalValue.RowIndex     = 2;
                curCellTotalValue.CellName     = curReturnOrder.TotalCount.ToString();
                curCellTotalValue.CellMergeNum = 2;
                cellList.Add(curCellTotalValue);



                CellType curCellBalanceOld = new CellType();
                curCellBalanceOld.RowIndex     = 3;
                curCellBalanceOld.CellName     = "上欠金额:";
                curCellBalanceOld.CellMergeNum = 1;
                cellList.Add(curCellBalanceOld);



                CellType curCellBalanceValueOld = new CellType();
                curCellBalanceValueOld.RowIndex     = 3;
                curCellBalanceValueOld.CellName     = curReturnOrder.PaymentBalanceOld.ToString();
                curCellBalanceValueOld.CellMergeNum = 2;
                cellList.Add(curCellBalanceValueOld);



                CellType curCellCurPay = new CellType();
                curCellCurPay.RowIndex     = 3;
                curCellCurPay.CellName     = "本次应收金额:";
                curCellCurPay.CellMergeNum = 1;
                cellList.Add(curCellCurPay);



                CellType curCellCurPayValue = new CellType();
                curCellCurPayValue.RowIndex     = 3;
                curCellCurPayValue.CellName     = curReturnOrder.TotalPfPrice.ToString();
                curCellCurPayValue.CellMergeNum = 2;
                cellList.Add(curCellCurPayValue);


                CellType curCellBalance = new CellType();
                curCellBalance.RowIndex     = 3;
                curCellBalance.CellName     = "应收总额:";
                curCellBalance.CellMergeNum = 1;
                cellList.Add(curCellBalance);



                CellType curCellBalanceValue = new CellType();
                curCellBalanceValue.RowIndex     = 3;
                curCellBalanceValue.CellName     = curReturnOrder.PaymentBalance.ToString();
                curCellBalanceValue.CellMergeNum = 2;
                cellList.Add(curCellBalanceValue);


                CellType curCellRemark = new CellType();
                curCellRemark.RowIndex     = 4;
                curCellRemark.CellName     = "备注:";
                curCellRemark.CellMergeNum = 1;
                cellList.Add(curCellRemark);



                CellType curCellRemarkValue = new CellType();
                curCellRemarkValue.RowIndex     = 4;
                curCellRemarkValue.CellName     = curReturnOrder.Remarks.ToString();
                curCellRemarkValue.CellMergeNum = 8;
                cellList.Add(curCellRemarkValue);



                NPOIHelper.CellValues = cellList;


                NPOIHelper.Keys   = keys.ToArray();
                NPOIHelper.Values = values.ToArray();
                NPOIHelper.ExportExcel(DataGridViewUtil.ToDataTable(list), path);

                GlobalMessageBox.Show("导出完毕!");
            }
            catch (Exception ex)
            { ShowError(ex); }
            finally
            {
                UnLockPage();
            }
        }
Пример #10
0
        private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
        {
            if (e.ColumnIndex < 0 || e.RowIndex < 0)
            {
                return;
            }
            DataGridView dataGridView = (DataGridView)sender;

            try
            {
                //检查现有的列表是否有重复名称
                List <SizeGroup> sizeGroups = DataGridViewUtil.BindingListToList <SizeGroup>(dataGridView1.DataSource);
                SizeGroup        group      = dataGridView1.Rows[e.RowIndex].DataBoundItem as SizeGroup;
                if (e.ColumnIndex == sizeGroupNameDataGridViewTextBoxColumn.Index)
                {
                    if (e.FormattedValue == null || String.IsNullOrEmpty(e.FormattedValue.ToString()))
                    {
                        GlobalMessageBox.Show("尺码组名称不能为空!");
                        dataGridView.CancelEdit();
                        return;
                    }
                    if (sizeGroups != null)
                    {
                        int index = sizeGroups.FindIndex(t => e.FormattedValue?.ToString() == t.ShowName);
                        if (e.RowIndex != index)
                        {
                            if (index > -1)
                            {
                                GlobalMessageBox.Show("尺码组名称已存在!");
                                dataGridView.CancelEdit();
                                return;
                            }
                        }
                    }
                }
                else if (e.ColumnIndex >= nameOfFDataGridViewTextBoxColumn.Index && e.ColumnIndex <= nameOfXL6DataGridViewTextBoxColumn.Index)
                {
                    if (e.FormattedValue == null || String.IsNullOrEmpty(e.FormattedValue.ToString()))
                    {
                        GlobalMessageBox.Show("尺码名称不能为空!");
                        dataGridView.CancelEdit();
                        return;
                    }
                    else
                    {
                        //不能重复
                        string currertKeyValue = e.FormattedValue.ToString();
                        //排除这一个单元格的判断
                        foreach (SizeGroup sizeGroup in sizeGroups)
                        {
                            bool checkBool = false;
                            //如果是同一个group,那么只检查不是同个属性的值
                            if (group == sizeGroup)
                            {
                                if (e.ColumnIndex != nameOfFDataGridViewTextBoxColumn.Index)
                                {
                                    checkBool = checkBool || sizeGroup.NameOfF == currertKeyValue;
                                }
                                if (e.ColumnIndex != nameOfXSDataGridViewTextBoxColumn.Index)
                                {
                                    checkBool = checkBool || sizeGroup.NameOfXS == currertKeyValue;
                                }
                                if (e.ColumnIndex != nameOfSDataGridViewTextBoxColumn.Index)
                                {
                                    checkBool = checkBool || sizeGroup.NameOfS == currertKeyValue;
                                }
                                if (e.ColumnIndex != nameOfMDataGridViewTextBoxColumn.Index)
                                {
                                    checkBool = checkBool || sizeGroup.NameOfM == currertKeyValue;
                                }
                                if (e.ColumnIndex != nameOfLDataGridViewTextBoxColumn.Index)
                                {
                                    checkBool = checkBool || sizeGroup.NameOfL == currertKeyValue;
                                }
                                if (e.ColumnIndex != nameOfXLDataGridViewTextBoxColumn.Index)
                                {
                                    checkBool = checkBool || sizeGroup.NameOfXL == currertKeyValue;
                                }
                                if (e.ColumnIndex != nameOfXL2DataGridViewTextBoxColumn.Index)
                                {
                                    checkBool = checkBool || sizeGroup.NameOfXL2 == currertKeyValue;
                                }
                                if (e.ColumnIndex != nameOfXL3DataGridViewTextBoxColumn.Index)
                                {
                                    checkBool = checkBool || sizeGroup.NameOfXL3 == currertKeyValue;
                                }
                                if (e.ColumnIndex != nameOfXL4DataGridViewTextBoxColumn.Index)
                                {
                                    checkBool = checkBool || sizeGroup.NameOfXL4 == currertKeyValue;
                                }
                                if (e.ColumnIndex != nameOfXL5DataGridViewTextBoxColumn.Index)
                                {
                                    checkBool = checkBool || sizeGroup.NameOfXL5 == currertKeyValue;
                                }
                                if (e.ColumnIndex != nameOfXL6DataGridViewTextBoxColumn.Index)
                                {
                                    checkBool = checkBool || sizeGroup.NameOfXL6 == currertKeyValue;
                                }
                            }
                            else
                            {
                                //不是同一个GROUP,那么检查所有字段
                                checkBool = sizeGroup.NameOfF == currertKeyValue ||
                                            sizeGroup.NameOfS == currertKeyValue ||
                                            sizeGroup.NameOfM == currertKeyValue ||
                                            sizeGroup.NameOfL == currertKeyValue ||
                                            sizeGroup.NameOfXL == currertKeyValue ||
                                            sizeGroup.NameOfXL2 == currertKeyValue ||
                                            sizeGroup.NameOfXL3 == currertKeyValue ||
                                            sizeGroup.NameOfXL4 == currertKeyValue ||
                                            sizeGroup.NameOfXL5 == currertKeyValue ||
                                            sizeGroup.NameOfXL6 == currertKeyValue;
                            }

                            if (checkBool)
                            {
                                GlobalMessageBox.Show("尺码名称已存在!");
                                dataGridView.CancelEdit();
                                return;
                            }
                        }
                    }
                }
            }
            catch (Exception)
            {
                GlobalMessageBox.Show("输入格式错误!");
                dataGridView.CancelEdit();
            }
        }