Ejemplo n.º 1
0
		/// <summary>
		/// Generates a Query string that should pull all the ledger items for a specific Guarantor.
		/// 
		/// If Guarantor = 0 then it will pull for all Guarantors which is a lot of data.
		/// So check for this condition.
		/// 
		/// <b>Note</b>: IsPulledFlag is currently depreciated 01-12-2008
		/// </summary>
		/// <param name="IsPulledFlag">indicates whether you want to pull items with the IsPulled status or not</param>
		/// <returns></returns>
		public static string PullAll_FromOD(long Guarantor,bool IsPulledFlag)
		{
			string rVal = "";
			L1_NegativeAdjustments L1 = new L1_NegativeAdjustments();
			L2_PositiveAdjustments L2 = new L2_PositiveAdjustments();
			L3_ClaimWriteOffAdjustments L3 = new L3_ClaimWriteOffAdjustments();
		//	L4_PaymentsFromPaySplit L4 = new L4_PaymentsFromPaySplit();
			// replaced with L4b_
			L4b_PaymentsFromPayment L4b = new L4b_PaymentsFromPayment();
			L5_PaymentsFromInsurance L5 = new L5_PaymentsFromInsurance();
			L6_Charges L6 = new L6_Charges();
			PP_ODSQLPullStrings_LedgerItem [] LArray = { L1, L2, L3, L4b, L5, L6 };
			for (int i = 0; i < LArray.Length; i++)
			{
				rVal += LArray[i].ODPullString(Guarantor, IsPulledFlag);
				if (i != LArray.Length - 1)
					rVal += "\n UNION ALL\n";
			}
			return rVal;
		}
        /// <summary>
        /// Generates a Query string that should pull all the ledger items for a specific Guarantor.
        ///
        /// If Guarantor = 0 then it will pull for all Guarantors which is a lot of data.
        /// So check for this condition.
        ///
        /// <b>Note</b>: IsPulledFlag is currently depreciated 01-12-2008
        /// </summary>
        /// <param name="IsPulledFlag">indicates whether you want to pull items with the IsPulled status or not</param>
        /// <returns></returns>
        public static string PullAll_FromOD(long Guarantor, bool IsPulledFlag)
        {
            string rVal = "";
            L1_NegativeAdjustments      L1 = new L1_NegativeAdjustments();
            L2_PositiveAdjustments      L2 = new L2_PositiveAdjustments();
            L3_ClaimWriteOffAdjustments L3 = new L3_ClaimWriteOffAdjustments();
            //	L4_PaymentsFromPaySplit L4 = new L4_PaymentsFromPaySplit();
            // replaced with L4b_
            L4b_PaymentsFromPayment  L4b = new L4b_PaymentsFromPayment();
            L5_PaymentsFromInsurance L5  = new L5_PaymentsFromInsurance();
            L6_Charges L6 = new L6_Charges();

            PP_ODSQLPullStrings_LedgerItem [] LArray = { L1, L2, L3, L4b, L5, L6 };
            for (int i = 0; i < LArray.Length; i++)
            {
                rVal += LArray[i].ODPullString(Guarantor, IsPulledFlag);
                if (i != LArray.Length - 1)
                {
                    rVal += "\n UNION ALL\n";
                }
            }
            return(rVal);
        }