internal virtual StringBuilder GetAutoPropertyFilterString()
        {
            var res = new StringBuilder();


            if (QtyAllocatedFilter.HasValue)
            {
                res.Append(" && " + string.Format("QtyAllocated == {0}", QtyAllocatedFilter.ToString()));
            }

            if (string.IsNullOrEmpty(StatusFilter) == false)
            {
                res.Append(" && " + string.Format("Status.Contains(\"{0}\")", StatusFilter));
            }
            return(res.ToString().StartsWith(" &&") || res.Length == 0 ? res:  res.Insert(0, " && "));
        }
        internal virtual StringBuilder GetAutoPropertyFilterString()
        {
            var res = new StringBuilder();


            if (ReceivedQtyFilter.HasValue)
            {
                res.Append(" && " + string.Format("ReceivedQty == {0}", ReceivedQtyFilter.ToString()));
            }

            if (string.IsNullOrEmpty(ItemNumberFilter) == false)
            {
                res.Append(" && " + string.Format("ItemNumber.Contains(\"{0}\")", ItemNumberFilter));
            }


            if (string.IsNullOrEmpty(ItemDescriptionFilter) == false)
            {
                res.Append(" && " + string.Format("ItemDescription.Contains(\"{0}\")", ItemDescriptionFilter));
            }


            if (CostFilter.HasValue)
            {
                res.Append(" && " + string.Format("Cost == {0}", CostFilter.ToString()));
            }

            if (InvoiceQtyFilter.HasValue)
            {
                res.Append(" && " + string.Format("InvoiceQty == {0}", InvoiceQtyFilter.ToString()));
            }

            if (string.IsNullOrEmpty(InvoiceNoFilter) == false)
            {
                res.Append(" && " + string.Format("InvoiceNo.Contains(\"{0}\")", InvoiceNoFilter));
            }



            if (Convert.ToDateTime(StartInvoiceDateFilter).Date != DateTime.MinValue &&
                Convert.ToDateTime(EndInvoiceDateFilter).Date != DateTime.MinValue)
            {
                res.Append(" && (");
            }

            if (Convert.ToDateTime(StartInvoiceDateFilter).Date != DateTime.MinValue)
            {
                if (StartInvoiceDateFilter.HasValue)
                {
                    res.Append(
                        (Convert.ToDateTime(EndInvoiceDateFilter).Date != DateTime.MinValue?"":" && ") +
                        string.Format("InvoiceDate >= \"{0}\"", Convert.ToDateTime(StartInvoiceDateFilter).Date.ToString("MM/dd/yyyy")));
                }
            }

            if (Convert.ToDateTime(EndInvoiceDateFilter).Date != DateTime.MinValue)
            {
                if (EndInvoiceDateFilter.HasValue)
                {
                    res.Append(" && " + string.Format("InvoiceDate <= \"{0}\"", Convert.ToDateTime(EndInvoiceDateFilter).Date.AddHours(23).ToString("MM/dd/yyyy HH:mm:ss")));
                }
            }

            if (Convert.ToDateTime(StartInvoiceDateFilter).Date != DateTime.MinValue &&
                Convert.ToDateTime(EndInvoiceDateFilter).Date != DateTime.MinValue)
            {
                res.Append(" )");
            }

            if (Convert.ToDateTime(_invoiceDateFilter).Date != DateTime.MinValue)
            {
                if (InvoiceDateFilter.HasValue)
                {
                    res.Append(" && " + string.Format("InvoiceDate == \"{0}\"", Convert.ToDateTime(InvoiceDateFilter).Date.ToString("MM/dd/yyyy")));
                }
            }


            if (string.IsNullOrEmpty(CNumberFilter) == false)
            {
                res.Append(" && " + string.Format("CNumber.Contains(\"{0}\")", CNumberFilter));
            }


            if (string.IsNullOrEmpty(RegistrationDateFilter) == false)
            {
                res.Append(" && " + string.Format("RegistrationDate.Contains(\"{0}\")", RegistrationDateFilter));
            }


            if (DurationFilter.HasValue)
            {
                res.Append(" && " + string.Format("Duration == {0}", DurationFilter.ToString()));
            }

            if (InvoiceMonthFilter.HasValue)
            {
                res.Append(" && " + string.Format("InvoiceMonth == {0}", InvoiceMonthFilter.ToString()));
            }

            if (AsycudaMonthFilter.HasValue)
            {
                res.Append(" && " + string.Format("AsycudaMonth == {0}", AsycudaMonthFilter.ToString()));
            }

            if (AllocatedValueFilter.HasValue)
            {
                res.Append(" && " + string.Format("AllocatedValue == {0}", AllocatedValueFilter.ToString()));
            }

            if (ReceivedValueFilter.HasValue)
            {
                res.Append(" && " + string.Format("ReceivedValue == {0}", ReceivedValueFilter.ToString()));
            }

            if (InvoiceValueFilter.HasValue)
            {
                res.Append(" && " + string.Format("InvoiceValue == {0}", InvoiceValueFilter.ToString()));
            }

            if (LineNumberFilter.HasValue)
            {
                res.Append(" && " + string.Format("LineNumber == {0}", LineNumberFilter.ToString()));
            }

            if (PiQuantityFilter.HasValue)
            {
                res.Append(" && " + string.Format("PiQuantity == {0}", PiQuantityFilter.ToString()));
            }

            if (string.IsNullOrEmpty(OverShortDetailStatusFilter) == false)
            {
                res.Append(" && " + string.Format("OverShortDetailStatus.Contains(\"{0}\")", OverShortDetailStatusFilter));
            }


            if (QtyAllocatedFilter.HasValue)
            {
                res.Append(" && " + string.Format("QtyAllocated == {0}", QtyAllocatedFilter.ToString()));
            }

            if (string.IsNullOrEmpty(AllocationStatusFilter) == false)
            {
                res.Append(" && " + string.Format("AllocationStatus.Contains(\"{0}\")", AllocationStatusFilter));
            }
            return(res.ToString().StartsWith(" &&") || res.Length == 0 ? res:  res.Insert(0, " && "));
        }
Beispiel #3
0
        internal virtual StringBuilder GetAutoPropertyFilterString()
        {
            var res = new StringBuilder();


            if (string.IsNullOrEmpty(EntryDataIdFilter) == false)
            {
                res.Append(" && " + string.Format("EntryDataId.Contains(\"{0}\")", EntryDataIdFilter));
            }


            if (LineNumberFilter.HasValue)
            {
                res.Append(" && " + string.Format("LineNumber == {0}", LineNumberFilter.ToString()));
            }

            if (string.IsNullOrEmpty(ItemNumberFilter) == false)
            {
                res.Append(" && " + string.Format("ItemNumber.Contains(\"{0}\")", ItemNumberFilter));
            }


            if (QuantityFilter.HasValue)
            {
                res.Append(" && " + string.Format("Quantity == {0}", QuantityFilter.ToString()));
            }

            if (string.IsNullOrEmpty(UnitsFilter) == false)
            {
                res.Append(" && " + string.Format("Units.Contains(\"{0}\")", UnitsFilter));
            }


            if (string.IsNullOrEmpty(ItemDescriptionFilter) == false)
            {
                res.Append(" && " + string.Format("ItemDescription.Contains(\"{0}\")", ItemDescriptionFilter));
            }


            if (CostFilter.HasValue)
            {
                res.Append(" && " + string.Format("Cost == {0}", CostFilter.ToString()));
            }

            if (QtyAllocatedFilter.HasValue)
            {
                res.Append(" && " + string.Format("QtyAllocated == {0}", QtyAllocatedFilter.ToString()));
            }

            if (UnitWeightFilter.HasValue)
            {
                res.Append(" && " + string.Format("UnitWeight == {0}", UnitWeightFilter.ToString()));
            }

            if (DoNotAllocateFilter.HasValue)
            {
                res.Append(" && " + string.Format("DoNotAllocate == {0}", DoNotAllocateFilter));
            }


            if (string.IsNullOrEmpty(TariffCodeFilter) == false)
            {
                res.Append(" && " + string.Format("TariffCode.Contains(\"{0}\")", TariffCodeFilter));
            }


            if (string.IsNullOrEmpty(CNumberFilter) == false)
            {
                res.Append(" && " + string.Format("CNumber.Contains(\"{0}\")", CNumberFilter));
            }


            if (CLineNumberFilter.HasValue)
            {
                res.Append(" && " + string.Format("CLineNumber == {0}", CLineNumberFilter.ToString()));
            }

            if (DownloadedFilter.HasValue)
            {
                res.Append(" && " + string.Format("Downloaded == {0}", DownloadedFilter));
            }


            if (string.IsNullOrEmpty(DutyFreePaidFilter) == false)
            {
                res.Append(" && " + string.Format("DutyFreePaid.Contains(\"{0}\")", DutyFreePaidFilter));
            }


            if (TotalFilter.HasValue)
            {
                res.Append(" && " + string.Format("Total == {0}", TotalFilter.ToString()));
            }
            return(res.ToString().StartsWith(" &&") || res.Length == 0 ? res:  res.Insert(0, " && "));
        }
        internal virtual StringBuilder GetAutoPropertyFilterString()
        {
            var res = new StringBuilder();


            if (string.IsNullOrEmpty(Packages_numberFilter) == false)
            {
                res.Append(" && " + string.Format("Packages_number.Contains(\"{0}\")", Packages_numberFilter));
            }


            if (string.IsNullOrEmpty(Previous_Packages_numberFilter) == false)
            {
                res.Append(" && " + string.Format("Previous_Packages_number.Contains(\"{0}\")", Previous_Packages_numberFilter));
            }


            if (string.IsNullOrEmpty(Hs_codeFilter) == false)
            {
                res.Append(" && " + string.Format("Hs_code.Contains(\"{0}\")", Hs_codeFilter));
            }


            if (string.IsNullOrEmpty(Commodity_codeFilter) == false)
            {
                res.Append(" && " + string.Format("Commodity_code.Contains(\"{0}\")", Commodity_codeFilter));
            }


            if (string.IsNullOrEmpty(Previous_item_numberFilter) == false)
            {
                res.Append(" && " + string.Format("Previous_item_number.Contains(\"{0}\")", Previous_item_numberFilter));
            }


            if (string.IsNullOrEmpty(Goods_originFilter) == false)
            {
                res.Append(" && " + string.Format("Goods_origin.Contains(\"{0}\")", Goods_originFilter));
            }


            if (Net_weightFilter.HasValue)
            {
                res.Append(" && " + string.Format("Net_weight == {0}", Net_weightFilter.ToString()));
            }

            if (Prev_net_weightFilter.HasValue)
            {
                res.Append(" && " + string.Format("Prev_net_weight == {0}", Prev_net_weightFilter.ToString()));
            }

            if (string.IsNullOrEmpty(Prev_reg_serFilter) == false)
            {
                res.Append(" && " + string.Format("Prev_reg_ser.Contains(\"{0}\")", Prev_reg_serFilter));
            }


            if (string.IsNullOrEmpty(Prev_reg_nbrFilter) == false)
            {
                res.Append(" && " + string.Format("Prev_reg_nbr.Contains(\"{0}\")", Prev_reg_nbrFilter));
            }


            if (string.IsNullOrEmpty(Prev_reg_datFilter) == false)
            {
                res.Append(" && " + string.Format("Prev_reg_dat.Contains(\"{0}\")", Prev_reg_datFilter));
            }


            if (string.IsNullOrEmpty(Prev_reg_cuoFilter) == false)
            {
                res.Append(" && " + string.Format("Prev_reg_cuo.Contains(\"{0}\")", Prev_reg_cuoFilter));
            }


            if (Suplementary_QuantityFilter.HasValue)
            {
                res.Append(" && " + string.Format("Suplementary_Quantity == {0}", Suplementary_QuantityFilter.ToString()));
            }

            if (Preveious_suplementary_quantityFilter.HasValue)
            {
                res.Append(" && " + string.Format("Preveious_suplementary_quantity == {0}", Preveious_suplementary_quantityFilter.ToString()));
            }

            if (Current_valueFilter.HasValue)
            {
                res.Append(" && " + string.Format("Current_value == {0}", Current_valueFilter.ToString()));
            }

            if (Previous_valueFilter.HasValue)
            {
                res.Append(" && " + string.Format("Previous_value == {0}", Previous_valueFilter.ToString()));
            }

            if (string.IsNullOrEmpty(Current_item_numberFilter) == false)
            {
                res.Append(" && " + string.Format("Current_item_number.Contains(\"{0}\")", Current_item_numberFilter));
            }


            if (QtyAllocatedFilter.HasValue)
            {
                res.Append(" && " + string.Format("QtyAllocated == {0}", QtyAllocatedFilter.ToString()));
            }

            if (RndCurrent_ValueFilter.HasValue)
            {
                res.Append(" && " + string.Format("RndCurrent_Value == {0}", RndCurrent_ValueFilter.ToString()));
            }

            if (string.IsNullOrEmpty(CNumberFilter) == false)
            {
                res.Append(" && " + string.Format("CNumber.Contains(\"{0}\")", CNumberFilter));
            }



            if (Convert.ToDateTime(StartRegistrationDateFilter).Date != DateTime.MinValue &&
                Convert.ToDateTime(EndRegistrationDateFilter).Date != DateTime.MinValue)
            {
                res.Append(" && (");
            }

            if (Convert.ToDateTime(StartRegistrationDateFilter).Date != DateTime.MinValue)
            {
                if (StartRegistrationDateFilter.HasValue)
                {
                    res.Append(
                        (Convert.ToDateTime(EndRegistrationDateFilter).Date != DateTime.MinValue?"":" && ") +
                        string.Format("RegistrationDate >= \"{0}\"", Convert.ToDateTime(StartRegistrationDateFilter).Date.ToString("MM/dd/yyyy")));
                }
            }

            if (Convert.ToDateTime(EndRegistrationDateFilter).Date != DateTime.MinValue)
            {
                if (EndRegistrationDateFilter.HasValue)
                {
                    res.Append(" && " + string.Format("RegistrationDate <= \"{0}\"", Convert.ToDateTime(EndRegistrationDateFilter).Date.AddHours(23).ToString("MM/dd/yyyy HH:mm:ss")));
                }
            }

            if (Convert.ToDateTime(StartRegistrationDateFilter).Date != DateTime.MinValue &&
                Convert.ToDateTime(EndRegistrationDateFilter).Date != DateTime.MinValue)
            {
                res.Append(" )");
            }

            if (Convert.ToDateTime(_registrationDateFilter).Date != DateTime.MinValue)
            {
                if (RegistrationDateFilter.HasValue)
                {
                    res.Append(" && " + string.Format("RegistrationDate == \"{0}\"", Convert.ToDateTime(RegistrationDateFilter).Date.ToString("MM/dd/yyyy")));
                }
            }
            return(res.ToString().StartsWith(" &&") || res.Length == 0 ? res:  res.Insert(0, " && "));
        }
        internal virtual StringBuilder GetAutoPropertyFilterString()
        {
            var res = new StringBuilder();


            if (TotalValueFilter.HasValue)
            {
                res.Append(" && " + string.Format("TotalValue == {0}", TotalValueFilter.ToString()));
            }

            if (AllocatedValueFilter.HasValue)
            {
                res.Append(" && " + string.Format("AllocatedValue == {0}", AllocatedValueFilter.ToString()));
            }

            if (string.IsNullOrEmpty(StatusFilter) == false)
            {
                res.Append(" && " + string.Format("Status.Contains(\"{0}\")", StatusFilter));
            }


            if (QtyAllocatedFilter.HasValue)
            {
                res.Append(" && " + string.Format("QtyAllocated == {0}", QtyAllocatedFilter.ToString()));
            }



            if (Convert.ToDateTime(StartInvoiceDateFilter).Date != DateTime.MinValue &&
                Convert.ToDateTime(EndInvoiceDateFilter).Date != DateTime.MinValue)
            {
                res.Append(" && (");
            }

            if (Convert.ToDateTime(StartInvoiceDateFilter).Date != DateTime.MinValue)
            {
                if (StartInvoiceDateFilter.HasValue)
                {
                    res.Append(
                        (Convert.ToDateTime(EndInvoiceDateFilter).Date != DateTime.MinValue ? "" : " && ") +
                        string.Format("InvoiceDate >= \"{0}\"",
                                      Convert.ToDateTime(StartInvoiceDateFilter).Date.ToString("MM/dd/yyyy")));
                }
            }

            if (Convert.ToDateTime(EndInvoiceDateFilter).Date != DateTime.MinValue)
            {
                if (EndInvoiceDateFilter.HasValue)
                {
                    res.Append(" && " + string.Format("InvoiceDate <= \"{0}\"",
                                                      Convert.ToDateTime(EndInvoiceDateFilter).Date.AddHours(23).ToString("MM/dd/yyyy HH:mm:ss")));
                }
            }

            if (Convert.ToDateTime(StartInvoiceDateFilter).Date != DateTime.MinValue &&
                Convert.ToDateTime(EndInvoiceDateFilter).Date != DateTime.MinValue)
            {
                res.Append(" )");
            }

            if (Convert.ToDateTime(_invoiceDateFilter).Date != DateTime.MinValue)
            {
                if (InvoiceDateFilter.HasValue)
                {
                    res.Append(" && " + string.Format("InvoiceDate == \"{0}\"",
                                                      Convert.ToDateTime(InvoiceDateFilter).Date.ToString("MM/dd/yyyy")));
                }
            }


            if (SalesQuantityFilter.HasValue)
            {
                res.Append(" && " + string.Format("SalesQuantity == {0}", SalesQuantityFilter.ToString()));
            }

            if (SalesQtyAllocatedFilter.HasValue)
            {
                res.Append(" && " + string.Format("SalesQtyAllocated == {0}", SalesQtyAllocatedFilter.ToString()));
            }

            if (string.IsNullOrEmpty(InvoiceNoFilter) == false)
            {
                res.Append(" && " + string.Format("InvoiceNo.Contains(\"{0}\")", InvoiceNoFilter));
            }


            if (string.IsNullOrEmpty(ItemNumberFilter) == false)
            {
                res.Append(" && " + string.Format("ItemNumber.Contains(\"{0}\")", ItemNumberFilter));
            }


            if (string.IsNullOrEmpty(ItemDescriptionFilter) == false)
            {
                res.Append(" && " + string.Format("ItemDescription.Contains(\"{0}\")", ItemDescriptionFilter));
            }


            if (string.IsNullOrEmpty(DutyFreePaidFilter) == false)
            {
                res.Append(" && " + string.Format("DutyFreePaid.Contains(\"{0}\")", DutyFreePaidFilter));
            }


            if (TaxAmountFilter.HasValue)
            {
                res.Append(" && " + string.Format("TaxAmount == {0}", TaxAmountFilter.ToString()));
            }

            if (CostFilter.HasValue)
            {
                res.Append(" && " + string.Format("Cost == {0}", CostFilter.ToString()));
            }

            if (DoNotAllocateSalesFilter.HasValue)
            {
                res.Append(" && " + string.Format("DoNotAllocateSales == {0}", DoNotAllocateSalesFilter));
            }

            if (SANumberFilter.HasValue)
            {
                res.Append(" && " + string.Format("SANumber == {0}", SANumberFilter.ToString()));
            }



            if (string.IsNullOrEmpty(pCNumberFilter) == false)
            {
                res.Append(" && " + string.Format("pCNumber.Contains(\"{0}\")", pCNumberFilter));
            }

            if (Convert.ToDateTime(StartpRegistrationDateFilter).Date != DateTime.MinValue &&
                Convert.ToDateTime(EndpRegistrationDateFilter).Date != DateTime.MinValue)
            {
                res.Append(" && (");
            }

            if (Convert.ToDateTime(StartpRegistrationDateFilter).Date != DateTime.MinValue)
            {
                if (StartpRegistrationDateFilter.HasValue)
                {
                    res.Append(
                        (Convert.ToDateTime(EndpRegistrationDateFilter).Date != DateTime.MinValue ? "" : " && ") +
                        string.Format("pRegistrationDate >= \"{0}\"",
                                      Convert.ToDateTime(StartpRegistrationDateFilter).Date.ToString("MM/dd/yyyy")));
                }
            }

            if (Convert.ToDateTime(EndpRegistrationDateFilter).Date != DateTime.MinValue)
            {
                if (EndpRegistrationDateFilter.HasValue)
                {
                    res.Append(" && " + string.Format("pRegistrationDate <= \"{0}\"",
                                                      Convert.ToDateTime(EndpRegistrationDateFilter).Date.AddHours(23)
                                                      .ToString("MM/dd/yyyy")));
                }
            }

            if (Convert.ToDateTime(StartpRegistrationDateFilter).Date != DateTime.MinValue &&
                Convert.ToDateTime(EndpRegistrationDateFilter).Date != DateTime.MinValue)
            {
                res.Append(" )");
            }

            if (Convert.ToDateTime(_pRegistrationDateFilter).Date != DateTime.MinValue)
            {
                if (pRegistrationDateFilter.HasValue)
                {
                    res.Append(" && " + string.Format("pRegistrationDate == \"{0}\"",
                                                      Convert.ToDateTime(pRegistrationDateFilter).Date.ToString("MM/dd/yyyy")));
                }
            }


            if (pQuantityFilter.HasValue)
            {
                res.Append(" && " + string.Format("pQuantity == {0}", pQuantityFilter.ToString()));
            }

            if (pQtyAllocatedFilter.HasValue)
            {
                res.Append(" && " + string.Format("pQtyAllocated == {0}", pQtyAllocatedFilter.ToString()));
            }

            if (PiQuantityFilter.HasValue)
            {
                res.Append(" && " + string.Format("PiQuantity == {0}", PiQuantityFilter.ToString()));
            }

            if (string.IsNullOrEmpty(TariffCodeFilter) == false)
            {
                res.Append(" && " + string.Format("TariffCode.Contains(\"{0}\")", TariffCodeFilter));
            }


            if (InvalidFilter.HasValue)
            {
                res.Append(" && " + string.Format("Invalid == {0}", InvalidFilter));
            }
            if (pLineNumberFilter.HasValue)
            {
                res.Append(" && " + string.Format("pLineNumber == {0}", pLineNumberFilter.ToString()));
            }



            if (Convert.ToDateTime(StartpExpiryDateFilter).Date != DateTime.MinValue &&
                Convert.ToDateTime(EndpExpiryDateFilter).Date != DateTime.MinValue)
            {
                res.Append(" && (");
            }

            if (Convert.ToDateTime(StartpExpiryDateFilter).Date != DateTime.MinValue)
            {
                if (StartpExpiryDateFilter.HasValue)
                {
                    res.Append(
                        (Convert.ToDateTime(EndpExpiryDateFilter).Date != DateTime.MinValue ? "" : " && ") +
                        string.Format("pExpiryDate >= \"{0}\"",
                                      Convert.ToDateTime(StartpExpiryDateFilter).Date.ToString("MM/dd/yyyy")));
                }
            }

            if (Convert.ToDateTime(EndpExpiryDateFilter).Date != DateTime.MinValue)
            {
                if (EndpExpiryDateFilter.HasValue)
                {
                    res.Append(" && " + string.Format("pExpiryDate <= \"{0}\"",
                                                      Convert.ToDateTime(EndpExpiryDateFilter).Date.AddHours(23).ToString("MM/dd/yyyy HH:mm:ss")));
                }
            }

            if (Convert.ToDateTime(StartpExpiryDateFilter).Date != DateTime.MinValue &&
                Convert.ToDateTime(EndpExpiryDateFilter).Date != DateTime.MinValue)
            {
                res.Append(" )");
            }

            if (Convert.ToDateTime(_pExpiryDateFilter).Date != DateTime.MinValue)
            {
                if (pExpiryDateFilter.HasValue)
                {
                    res.Append(" && " + string.Format("pExpiryDate == \"{0}\"",
                                                      Convert.ToDateTime(pExpiryDateFilter).Date.ToString("MM/dd/yyyy")));
                }
            }


            if (string.IsNullOrEmpty(pReferenceNumberFilter) == false)
            {
                res.Append(" && " + string.Format("pReferenceNumber.Contains(\"{0}\")", pReferenceNumberFilter));
            }

            if (Total_CIF_itmFilter.HasValue)
            {
                res.Append(" && " + string.Format("Total_CIF_itm == {0}", Total_CIF_itmFilter.ToString()));
            }

            if (DutyLiabilityFilter.HasValue)
            {
                res.Append(" && " + string.Format("DutyLiability == {0}", DutyLiabilityFilter.ToString()));
            }

            if (pIsAssessedFilter.HasValue)
            {
                res.Append(" && " + string.Format("pIsAssessed == {0}", pIsAssessedFilter));
            }

            if (DoNotAllocatePreviousEntryFilter.HasValue)
            {
                res.Append(" && " + string.Format("DoNotAllocatePreviousEntry == {0}", DoNotAllocatePreviousEntryFilter));
            }



            if (string.IsNullOrEmpty(xCNumberFilter) == false)
            {
                res.Append(" && " + string.Format("xCNumber.Contains(\"{0}\")", xCNumberFilter));
            }


            if (xLineNumberFilter.HasValue)
            {
                res.Append(" && " + string.Format("xLineNumber == {0}", xLineNumberFilter.ToString()));
            }

            if (Convert.ToDateTime(StartxRegistrationDateFilter).Date != DateTime.MinValue &&
                Convert.ToDateTime(EndxRegistrationDateFilter).Date != DateTime.MinValue)
            {
                res.Append(" && (");
            }

            if (Convert.ToDateTime(StartxRegistrationDateFilter).Date != DateTime.MinValue)
            {
                if (StartxRegistrationDateFilter.HasValue)
                {
                    res.Append(
                        (Convert.ToDateTime(EndxRegistrationDateFilter).Date != DateTime.MinValue ? "" : " && ") +
                        string.Format("xRegistrationDate >= \"{0}\"",
                                      Convert.ToDateTime(StartxRegistrationDateFilter).Date.ToString("MM/dd/yyyy")));
                }
            }

            if (Convert.ToDateTime(EndxRegistrationDateFilter).Date != DateTime.MinValue)
            {
                if (EndxRegistrationDateFilter.HasValue)
                {
                    res.Append(" && " + string.Format("xRegistrationDate <= \"{0}\"",
                                                      Convert.ToDateTime(EndxRegistrationDateFilter).Date.AddHours(23)
                                                      .ToString("MM/dd/yyyy")));
                }
            }

            if (Convert.ToDateTime(StartxRegistrationDateFilter).Date != DateTime.MinValue &&
                Convert.ToDateTime(EndxRegistrationDateFilter).Date != DateTime.MinValue)
            {
                res.Append(" )");
            }

            if (Convert.ToDateTime(_xRegistrationDateFilter).Date != DateTime.MinValue)
            {
                if (xRegistrationDateFilter.HasValue)
                {
                    res.Append(" && " + string.Format("xRegistrationDate == \"{0}\"",
                                                      Convert.ToDateTime(xRegistrationDateFilter).Date.ToString("MM/dd/yyyy")));
                }
            }

            if (string.IsNullOrEmpty(xReferenceNumberFilter) == false)
            {
                res.Append(" && " + string.Format("xReferenceNumber.Contains(\"{0}\")", xReferenceNumberFilter));
            }


            return(res.ToString().StartsWith(" &&") || res.Length == 0 ? res : res.Insert(0, " && "));
        }