예제 #1
0
        // OLD signature notice the case, this did NOT work with the deserialise
        //   public String batch_id, myinterface, voucher_type, trans_type, client, account, dim_1, dim_2, dim_3, dim_4,
        //    dim_5, dim_6, dim_7, tax_code, tax_system, currency, dc_flag, cur_amount, amount, number_1,
        //    value_1, value_2, value_3, description, trans_date, voucher_date, voucher_no, period, tax_flag, ext_inv_ref,
        //    ext_ref, due_date, disc_date, discount, commitment, order_id, kid, pay_transfer, status, apar_type,
        //    apar_id, pay_flag, voucher_ref, sequence_ref, intrule_id, factor_short, responsible, apar_name, address, province,
        //    place, bank_account, pay_method, vat_reg_no, zip_code, curr_licence, account2, base_amount, base_curr, pay_temp_id,
        //    allocation_key, period_no, clearing_code, swift, arrive_id, bank_acc_type
        //;

        public String beautifyGL07()
        {
            // this function will process the NULL values and return a GL07 fixed width line
            // ? allows null to not give a runtime error
            // ?? is effectively a coalesce.  do the right side of the ?? if the left side is null else do the left side
            PayMethod     = PayMethod?.Trim().PadRight(2).Substring(0, 2) ?? "".PadRight(2);
            BatchId       = BatchId?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            Interface     = Interface?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            VoucherType   = VoucherType?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            TransType     = TransType?.Trim().PadRight(2).Substring(0, 2) ?? "".PadRight(2);
            Client        = Client?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            Account       = Account?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            Cat1          = Cat1?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            Cat2          = Cat2?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            Cat3          = Cat3?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            Cat4          = Cat4?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            Cat5          = Cat5?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            Cat6          = Cat6?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            Cat7          = Cat7?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            TaxCode       = TaxCode?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            TaxSystem     = TaxSystem?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            Currency      = Currency?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            DcFlag        = DcFlag?.Trim().PadRight(2).Substring(0, 2) ?? "".PadRight(2);
            CurAmount     = CurAmount.Trim().PadLeft(20);
            Amount        = Amount.Trim().PadLeft(20);
            Number1       = Number1.Trim().PadLeft(11);
            Value1        = Value1.Trim().PadLeft(20);
            Value2        = Value2.Trim().PadLeft(20);
            Value3        = Value3.Trim().PadLeft(20);
            Description   = Description?.Trim().PadRight(255).Substring(0, 255) ?? "".PadRight(255);
            TransDate     = TransDate?.Trim().PadRight(8).Substring(0, 8) ?? "".PadRight(8);
            VoucherDate   = VoucherDate?.Trim().PadRight(8).Substring(0, 8) ?? "".PadRight(8);
            VoucherNo     = VoucherNo?.Trim().PadRight(15).Substring(0, 15) ?? "".PadRight(15);
            Period        = Period?.Trim().PadRight(6).Substring(0, 6) ?? "".PadRight(6);
            TaxFlag       = TaxFlag?.Trim().PadRight(1).Substring(0, 1) ?? "".PadRight(1);
            ExtInvRef     = ExtInvRef?.Trim().PadRight(100).Substring(0, 100) ?? "".PadRight(100);
            ExtRef        = ExtRef?.Trim().PadRight(255).Substring(0, 255) ?? "".PadRight(255);
            DueDate       = DueDate?.Trim().PadRight(8).Substring(0, 8) ?? "".PadRight(8);
            DiscDate      = DiscDate?.Trim().PadRight(8).Substring(0, 8) ?? "".PadRight(8);
            Discount      = Discount?.Trim().PadRight(20).Substring(0, 20) ?? "".PadRight(20);
            Commitment    = Commitment?.Trim().PadLeft(25).Substring(0, 25) ?? "".PadRight(25);
            OrderId       = OrderId?.Trim().PadRight(15).Substring(0, 15) ?? "".PadRight(15);
            Kid           = Kid?.Trim().PadRight(27).Substring(0, 27) ?? "".PadRight(27);
            PayTransfer   = PayTransfer?.Trim().PadRight(2).Substring(0, 2) ?? "".PadRight(2);
            Status        = Status?.Trim().PadRight(1).Substring(0, 1) ?? "".PadRight(1);
            AparType      = AparType?.Trim().PadRight(1).Substring(0, 1) ?? "".PadRight(1);
            AparId        = AparId?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            PayFlag       = PayFlag?.Trim().PadRight(1).Substring(0, 1) ?? "".PadRight(1);
            VoucherRef    = VoucherRef?.Trim().PadRight(15).Substring(0, 15) ?? "".PadRight(15);
            SequenceRef   = SequenceRef?.Trim().PadRight(9).Substring(0, 9) ?? "".PadRight(9);
            IntruleId     = IntruleId?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            FactorShort   = FactorShort?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            Responsible   = Responsible?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            AparName      = AparName?.Trim().PadRight(255).Substring(0, 255) ?? "".PadRight(255);
            Address       = Address?.Trim().PadRight(160).Substring(0, 160) ?? "".PadRight(160);
            Province      = Province?.Trim().PadRight(40).Substring(0, 40) ?? "".PadRight(40);
            Place         = Place?.Trim().PadRight(40).Substring(0, 40) ?? "".PadRight(40);
            BankAccount   = BankAccount?.Trim().PadRight(35).Substring(0, 35) ?? "".PadRight(35);
            PayMethod     = PayMethod?.Trim().PadRight(2).Substring(0, 2) ?? "".PadRight(2);
            VatRegNo      = VatRegNo?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            ZipCode       = ZipCode?.Trim().PadRight(15).Substring(0, 15) ?? "".PadRight(15);
            CurrLicence   = CurrLicence?.Trim().PadRight(3).Substring(0, 3) ?? "".PadRight(3);
            Account2      = Account2?.Trim().PadRight(25).Substring(0, 25) ?? "".PadRight(25);
            BaseAmount    = BaseAmount?.Trim().PadLeft(20).Substring(0, 20) ?? "".PadRight(20);
            BaseCurr      = BaseCurr?.Trim().PadLeft(20).Substring(0, 20) ?? "".PadRight(20);
            PayTempId     = PayTempId?.Trim().PadRight(4).Substring(0, 4) ?? "".PadRight(4);
            AllocationKey = AllocationKey?.Trim().PadRight(2).Substring(0, 2) ?? "".PadRight(2);
            PeriodNo      = PeriodNo?.Trim().PadRight(2).Substring(0, 2) ?? "".PadRight(2);
            Clearingcode  = Clearingcode?.Trim().PadRight(13).Substring(0, 13) ?? "".PadRight(13);
            Swift         = Swift?.Trim().PadRight(11).Substring(0, 11) ?? "".PadRight(11);
            Arriveid      = Arriveid?.Trim().PadRight(15).Substring(0, 15) ?? "".PadRight(15);
            BankAccType   = BankAccType?.Trim().PadRight(2).Substring(0, 2) ?? "".PadRight(2);

            return(BatchId + Interface + VoucherType + TransType + Client
                   + Account + Cat1 + Cat2 + Cat3 + Cat4
                   + Cat5 + Cat6 + Cat7 + TaxCode + TaxSystem + Currency
                   + DcFlag + CurAmount + Amount + Number1 + Value1 + Value2
                   + Value3 + Description + TransDate + VoucherDate + VoucherNo
                   + Period + TaxFlag + ExtInvRef + ExtRef + DueDate + DiscDate
                   + Discount + Commitment + OrderId + Kid + PayTransfer + Status
                   + AparType + AparId + PayFlag + VoucherRef + SequenceRef + IntruleId
                   + FactorShort + Responsible + AparName + Address + Province + Place
                   + BankAccount + PayMethod + VatRegNo + ZipCode + CurrLicence + Account2
                   + BaseAmount + BaseCurr + PayTempId + AllocationKey + PeriodNo + Clearingcode
                   + Swift + Arriveid + BankAccType
                   );


            //       String GL07Line = fw.BatchId.Trim().PadRight(25) + fw.Interface?.Trim().PadRight(25) + fw.VoucherType.Trim().PadRight(25) + fw.TransType.Trim().PadRight(2) + fw.Client.Trim().PadRight(25)
            //+ fw.Account.Trim().PadRight(25) + fw.Cat1.Trim().PadRight(25) + fw.Cat2.Trim().PadRight(25) + fw.Cat3.Trim().PadRight(25) + fw.Cat4.Trim().PadRight(25)
            //+ fw.Cat5.Trim().PadRight(25) + fw.Cat6.Trim().PadRight(25) + fw.Cat7.Trim().PadRight(25) + fw.TaxCode.Trim().PadRight(25) + fw.TaxSystem.Trim().PadRight(25) + fw.Currency.Trim().PadRight(25)
            //+ fw.DcFlag.Trim().PadRight(2) + fw.CurAmount.Trim().PadLeft(20) + fw.Amount.Trim().PadLeft(20) + fw.Number1.Trim().PadLeft(11) + fw.Value1.Trim().PadLeft(20) + fw.Value2.Trim().PadLeft(20)
            //+ fw.Value3.Trim().PadLeft(20) + fw.Description.Trim().PadRight(255) + fw.TransDate.Trim().PadRight(8) + fw.VoucherDate.Trim().PadRight(8) + fw.VoucherNo.Trim().PadRight(15)
            //+ fw.Period.Trim().PadRight(6) + fw.TaxFlag.Trim().PadRight(1) + fw.ExtInvRef.Trim().PadRight(100) + fw.ExtRef.Trim().PadRight(255) + fw.DueDate.Trim().PadRight(8) + fw.DiscDate.Trim().PadRight(8)
            //+ fw.Discount.Trim().PadRight(20) + fw.Commitment.Trim().PadLeft(25) + fw.OrderId.Trim().PadRight(15) + fw.Kid.Trim().PadRight(27) + fw.PayTransfer.Trim().PadRight(2) + fw.PayTransfer.Trim().PadRight(1)
            //+ fw.AparType.Trim().PadRight(1) + fw.AparId.Trim().PadRight(25) + fw.PayFlag.Trim().PadRight(1) + fw.VoucherRef.Trim().PadRight(15) + fw.SequenceRef.Trim().PadRight(9) + fw.IntruleId.Trim().PadRight(25)
            //+ fw.FactorShort.Trim().PadRight(25) + fw.Responsible.Trim().PadRight(25) + fw.AparName.Trim().PadRight(255) + fw.Address.Trim().PadRight(160) + fw.Province.Trim().PadRight(40) + fw.Place.Trim().PadRight(40)
            //+ fw.BankAccount.Trim().PadRight(35) + fw.PayMethod + fw.VatRegNo.Trim().PadRight(25) + fw.ZipCode.Trim().PadRight(15) + fw.CurrLicence.Trim().PadRight(3) + fw.Account2.Trim().PadRight(25)
            //+ fw.BaseAmount.Trim().PadLeft(20) + fw.BaseCurr.Trim().PadLeft(20) + fw.PayTempId.Trim().PadRight(4) + fw.AllocationKey.Trim().PadRight(2) + fw.PeriodNo.Trim().PadRight(2) + fw.Clearingcode.Trim().PadRight(13)
            //+ fw.Swift.Trim().PadRight(11) + fw.Arriveid.Trim().PadRight(15) + fw.BankAccType.Trim().PadRight(2)
            // ;
        }