Exemplo n.º 1
0
        /// <summary>
        /// Calcs the total RPL qty.
        /// </summary>
        private void CalcTotalRplQty()
        {
            decimal totalQty = 0;

            string query = "HeaderId = '" + this.HeaderId.ToString() + "'";
            InvtBatchRPL_DetailsCollection oDetailList = InvtBatchRPL_Details.LoadCollection(query);

            foreach (InvtBatchRPL_Details oDetail in oDetailList)
            {
                totalQty += oDetail.QtyRequested;
            }

            txtTotalReplenishQty.Text = totalQty.ToString("n0");
        }
Exemplo n.º 2
0
        /// <summary>
        /// Saves the detail info.
        /// </summary>
        private void SaveDetailInfo()
        {
            for (int i = 0; i < listView.Items.Count; i++)
            {
                ListViewItem oItem = listView.Items[i];

                if (!oItem.SubItems[1].Text.Contains("D"))
                {
                    string  query    = "STKCODE = '" + oItem.SubItems[2].Text + "' AND APPENDIX1 = '" + oItem.SubItems[3].Text + @"'
                        AND APPENDIX2 = '" + oItem.SubItems[4].Text + "' AND APPENDIX3 = '" + oItem.SubItems[5].Text + "'";
                    Product oProduct = Product.LoadWhere(query);
                    if (oProduct != null)
                    {
                        productId = oProduct.ProductId;

                        query = "ProductId = '" + productId.ToString() + "' AND DetailsId = '" + oItem.SubItems[0].Text + "'";
                        InvtBatchRPL_Details oDetail = InvtBatchRPL_Details.LoadWhere(query);
                        if (oDetail == null)
                        {
                            oDetail = new InvtBatchRPL_Details();

                            oDetail.HeaderId   = this.HeaderId;
                            oDetail.TxNumber   = txNumber;
                            oDetail.LineNumber = i + 1;
                            oDetail.ProductId  = productId;
                        }
                        oDetail.QtyRequested = Convert.ToDecimal(oItem.SubItems[8].Text);

                        oDetail.Save();
                    }
                }
                else
                {
                    if (RT2020.DAL.Common.Utility.IsGUID(oItem.SubItems[0].Text))
                    {
                        InvtBatchRPL_Details oDetail = InvtBatchRPL_Details.Load(new Guid(oItem.SubItems[0].Text));
                        if (oDetail != null)
                        {
                            oDetail.Delete();
                        }
                    }
                }
            }
        }
Exemplo n.º 3
0
        /// <summary>
        /// Saves this instance.
        /// </summary>
        private void Save(bool bConfirmed)
        {
            string sheaderid = string.Empty;

            for (int i = 0; i < dgvConfirmationList.Rows.Count; i++)
            {
                DataGridViewRow oRow = dgvConfirmationList.Rows[i];
                if (RT2020.DAL.Common.Utility.IsGUID(oRow.Cells[0].Value.ToString()))
                {
                    System.Guid detailId = new Guid(oRow.Cells[0].Value.ToString());

                    InvtBatchRPL_Details oDetail = InvtBatchRPL_Details.Load(detailId);
                    if (oDetail != null)
                    {
                        oDetail.QtyIssued = Convert.ToDecimal(oRow.Cells[9].Value);
                        oDetail.Save();
                    }
                }
            }

            InvtBatchRPL_Header oHeader = InvtBatchRPL_Header.Load(this.HeaderId);

            if (oHeader != null)
            {
                if (bConfirmed)
                {
                    oHeader.Confirmed   = true;
                    oHeader.ConfirmedBy = Common.Utility.CurrentUserId;
                    oHeader.ConfirmedOn = DateTime.Now;
                }

                oHeader.ModifiedBy = Common.Utility.CurrentUserId;
                oHeader.ModifiedOn = DateTime.Now;
                oHeader.Save();
            }
        }