예제 #1
0
        private void UpdateStockFullRefund()
        {
            List <int>    SkuList = new List <int>();
            List <int>    QtyList = new List <int>();
            List <string> Gift    = new List <string>();


            foreach (Label Labels in pnlItems.Controls.OfType <Label>())
            {
                if (Labels.Name.Contains("Sku"))
                {
                    SkuList.Add(Convert.ToInt32(Labels.Text));
                }

                if (Labels.Name.Contains("Gift"))
                {
                    Gift.Add(Labels.Text);
                }
            }

            foreach (ComboBox qty in pnlItems.Controls.OfType <ComboBox>())
            {
                if (qty.Name.Contains("Quantity"))
                {
                    QtyList.Add(Convert.ToInt32(qty.SelectedItem));
                }
            }

            for (int i = 0; i < SkuList.Count; i++)
            {
                DatabaseAssist.UpdateMaterialQty(SkuList[i], QtyList[i], "Add");
                DatabaseAssist.UpdateProductQtySold(SkuList[i], QtyList[i], "Remove");

                if (Gift[i] != "No ")
                {
                    DatabaseAssist.UpdateGiftBoxes(Gift[i], QtyList[i], "Add");
                }
            }
        }
예제 #2
0
        private void UpdateStockPartRefund()
        {
            List <int>    SkuList = new List <int>();
            List <int>    QtyList = new List <int>();
            List <string> Gift    = new List <string>();

            for (int i = 0; i < dgvRefunds.Rows.Count - 1; i++)
            {
                SkuList.Add((Convert.ToInt16(dgvRefunds.Rows[i].Cells[2].Value)));
                QtyList.Add((Convert.ToInt16(dgvRefunds.Rows[i].Cells[6].Value)));
                Gift.Add(dgvRefunds.Rows[i].Cells[8].Value.ToString());
            }

            for (int i = 0; i < SkuList.Count; i++)
            {
                DatabaseAssist.UpdateMaterialQty(SkuList[i], QtyList[i], "Add");
                DatabaseAssist.UpdateProductQtySold(SkuList[i], QtyList[i], "Remove");

                if (Gift[i] != "No " && chkGift.Checked == true)
                {
                    DatabaseAssist.UpdateGiftBoxes(Gift[i], QtyList[i], "Add");
                }
            }
        }