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, " && ")); }
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, " && ")); }