Example #1
0
        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()));
        }