Example #1
0
        public override void ReadData()
        {
            List <Allowance> B0101 = new List <Allowance>();
            var Value = SQLMethod.Count_B0101();

            if (Value != null)//檢查開立發票數量
            {
                Form1.B0101Num = Value.Count;
                var Item = SQLMethod.Count_B0101_detail();
                if (Item != null)//檢查開立發票細項
                {
                    foreach (var B0101Data in Value)
                    {
                        Allowance data = new Allowance();
                        data.Main.AllowanceNumber   = B0101Data.AllowanceNumber.Trim();
                        data.Main.AllowanceDate     = B0101Data.AllowanceDate.Trim();
                        data.Main.Seller.Identifier = B0101Data.SellerID.Trim();
                        data.Main.Seller.Name       = B0101Data.SellerName.Trim();
                        data.Main.Buyer.Identifier  = B0101Data.BuyerID.Trim();
                        data.Main.Buyer.Name        = B0101Data.BuyerName.Trim();
                        data.Main.AllowanceType     = B0101Data.AllowanceType.Trim();
                        foreach (var b0101Data in Item)
                        {
                            if (b0101Data.AllowanceNumber == B0101Data.AllowanceNumber)
                            {
                                ProductItem ProductItem = new ProductItem();
                                ProductItem.OriginalInvoiceDate   = b0101Data.OriginalInvoiceDate.Trim();
                                ProductItem.OriginalInvoiceNumber = b0101Data.OriginalInvoiceNumber.Trim();
                                ProductItem.OriginalDescription   = b0101Data.OriginalDescription.Trim();
                                ProductItem.Quantity  = Convert.ToDecimal(b0101Data.Quantity);
                                ProductItem.Unit      = b0101Data.Unit.Trim();
                                ProductItem.UnitPrice = Convert.ToDecimal(b0101Data.UnitPrice);
                                ProductItem.Amount    = Convert.ToDecimal(b0101Data.Amount);
                                ProductItem.Tax       = Convert.ToDecimal(b0101Data.Tax);
                                ProductItem.AllowanceSequenceNumber = b0101Data.AllowanceSequenceNumber.Trim();
                                ProductItem.TaxType = b0101Data.TaxType.Trim();
                                data.Details.Add(ProductItem);
                            }
                        }
                        data.Amount.TaxAmount   = Convert.ToDecimal(B0101Data.taxamount);
                        data.Amount.TotalAmount = Convert.ToDecimal(B0101Data.Totalamount);
                        B0101.Add(data);
                    }
                    Allowance = B0101;
                    if (Value.Count > 0)
                    {
                        XMLMethod.Save_B0101(Allowance);
                    }
                }
            }
            else
            {
                Form1.B0101Num = 0;
            }
        }