protected override void BeforeReadIDOs() { base.BeforeReadIDOs(); IDOPurchaseOrders Orders = (IDOPurchaseOrders)PrimaryBusinessObject; Orders.parm.PropertyList = ""; AdapterList adptList = new AdapterList() { KeyName = "PoNum" }; adptList.Add("PoNum"); adptList.Add("OrderDate", AdapterListItem.ValueTypes.Date); adptList.Add("Stat"); adptList.Add("Type"); adptList.Add("VendNum"); adptList.Add("VendorName"); adptList.Add("Whse"); SetAdapterLists(0, adptList); if (QueryString == "") { //QueryString = "%"; Orders.BuilderFilterByPoNum("%"); } else { Orders.BuilderFilterByPoNumOrVendNumOrVendorName(QueryString); } if (LastKey != "") { Orders.BuilderAdditionalFilter(string.Format("PoNum > N'{0}'", LastKey)); } if (DateQueryString != "") { Orders.BuilderAdditionalFilter(DateQueryString); } Orders.BuilderAdditionalFilter(string.Format("Stat IN (N'P', N'O') AND Whse = N'{0}'", DefaultWhse())); }