internal virtual StringBuilder GetAutoPropertyFilterString()
{
var res = new StringBuilder();
if (string.IsNullOrEmpty(PO_NOFilter) == false)
{
res.Append(" && " + string.Format("PO_NO.Contains(\"{0}\")", PO_NOFilter));
}
if (SEQ_NOFilter.HasValue)
{
res.Append(" && " + string.Format("SEQ_NO == {0}", SEQ_NOFilter.ToString()));
}
if (string.IsNullOrEmpty(ITEM_NOFilter) == false)
{
res.Append(" && " + string.Format("ITEM_NO.Contains(\"{0}\")", ITEM_NOFilter));
}
if (ORD_QTYFilter.HasValue)
{
res.Append(" && " + string.Format("ORD_QTY == {0}", ORD_QTYFilter.ToString()));
}
if (string.IsNullOrEmpty(ORD_UNITFilter) == false)
{
res.Append(" && " + string.Format("ORD_UNIT.Contains(\"{0}\")", ORD_UNITFilter));
}
if (string.IsNullOrEmpty(ITEM_DESCRFilter) == false)
{
res.Append(" && " + string.Format("ITEM_DESCR.Contains(\"{0}\")", ITEM_DESCRFilter));
}
if (ORD_COSTFilter.HasValue)
{
res.Append(" && " + string.Format("ORD_COST == {0}", ORD_COSTFilter.ToString()));
}
if (UNIT_WEIGHTFilter.HasValue)
{
res.Append(" && " + string.Format("UNIT_WEIGHT == {0}", UNIT_WEIGHTFilter.ToString()));
}
return(res.ToString().StartsWith(" &&") || res.Length == 0 ? res: res.Insert(0, " && "));
}
internal virtual StringBuilder GetAutoPropertyFilterString()
{
var res = new StringBuilder();
if (string.IsNullOrEmpty(INVNOFilter) == false)
{
res.Append(" && " + string.Format("INVNO.Contains(\"{0}\")", INVNOFilter));
}
if (SEQ_NOFilter.HasValue)
{
res.Append(" && " + string.Format("SEQ_NO == {0}", SEQ_NOFilter.ToString()));
}
if (string.IsNullOrEmpty(ITEM_NOFilter) == false)
{
res.Append(" && " + string.Format("ITEM_NO.Contains(\"{0}\")", ITEM_NOFilter));
}
if (string.IsNullOrEmpty(ITEM_DESCRFilter) == false)
{
res.Append(" && " + string.Format("ITEM_DESCR.Contains(\"{0}\")", ITEM_DESCRFilter));
}
if (QUANTITYFilter.HasValue)
{
res.Append(" && " + string.Format("QUANTITY == {0}", QUANTITYFilter.ToString()));
}
if (COSTFilter.HasValue)
{
res.Append(" && " + string.Format("COST == {0}", COSTFilter.ToString()));
}
if (string.IsNullOrEmpty(ACCT_NOFilter) == false)
{
res.Append(" && " + string.Format("ACCT_NO.Contains(\"{0}\")", ACCT_NOFilter));
}
if (string.IsNullOrEmpty(CUSTOMER_NAMEFilter) == false)
{
res.Append(" && " + string.Format("CUSTOMER_NAME.Contains(\"{0}\")", CUSTOMER_NAMEFilter));
}
if (Convert.ToDateTime(StartDATEFilter).Date != DateTime.MinValue &&
Convert.ToDateTime(EndDATEFilter).Date != DateTime.MinValue)
{
res.Append(" && (");
}
if (Convert.ToDateTime(StartDATEFilter).Date != DateTime.MinValue)
{
if (StartDATEFilter.HasValue)
{
res.Append(
(Convert.ToDateTime(EndDATEFilter).Date != DateTime.MinValue?"":" && ") +
string.Format("DATE >= \"{0}\"", Convert.ToDateTime(StartDATEFilter).Date.ToString("MM/dd/yyyy")));
}
}
if (Convert.ToDateTime(EndDATEFilter).Date != DateTime.MinValue)
{
if (EndDATEFilter.HasValue)
{
res.Append(" && " + string.Format("DATE <= \"{0}\"", Convert.ToDateTime(EndDATEFilter).Date.AddHours(23).ToString("MM/dd/yyyy HH:mm:ss")));
}
}
if (Convert.ToDateTime(StartDATEFilter).Date != DateTime.MinValue &&
Convert.ToDateTime(EndDATEFilter).Date != DateTime.MinValue)
{
res.Append(" )");
}
if (Convert.ToDateTime(_dATEFilter).Date != DateTime.MinValue)
{
if (DATEFilter.HasValue)
{
res.Append(" && " + string.Format("DATE == \"{0}\"", Convert.ToDateTime(DATEFilter).Date.ToString("MM/dd/yyyy")));
}
}
if (TAX_AMTFilter.HasValue)
{
res.Append(" && " + string.Format("TAX_AMT == {0}", TAX_AMTFilter.ToString()));
}
if (UNIT_WEIGHTFilter.HasValue)
{
res.Append(" && " + string.Format("UNIT_WEIGHT == {0}", UNIT_WEIGHTFilter.ToString()));
}
if (string.IsNullOrEmpty(QTY_UNITFilter) == false)
{
res.Append(" && " + string.Format("QTY_UNIT.Contains(\"{0}\")", QTY_UNITFilter));
}
return(res.ToString().StartsWith(" &&") || res.Length == 0 ? res: res.Insert(0, " && "));
}
