public IEnumerable detailsView()
{
List <object> result = new List <object>();
var currentSearchPeriod = ((LumINItemCostFilter)this.Caches[typeof(LumINItemCostFilter)].Current)?.FinPeriodID;
if (currentSearchPeriod != null)
{
var pars = new List <PXSPParameter>();
PXSPParameter period = new PXSPInParameter("@period", PXDbType.Int, currentSearchPeriod);
PXSPParameter companyID = new PXSPInParameter("@companyID", PXDbType.Int, PX.Data.Update.PXInstanceHelper.CurrentCompany);
pars.Add(period);
pars.Add(companyID);
using (new PXConnectionScope())
{
using (PXTransactionScope ts = new PXTransactionScope())
{
PXDatabase.Execute("SP_GenerateLumINItemCostHist", pars.ToArray());
ts.Complete();
}
}
PXView select = new PXView(this, true, DetailsView.View.BqlSelect);
int totalrow = 0;
int startrow = PXView.StartRow;
result = select.Select(PXView.Currents, PXView.Parameters, PXView.Searches, PXView.SortColumns, PXView.Descendings, PXView.Filters, ref startrow, PXView.MaximumRows, ref totalrow);
PXView.StartRow = 0;
return(result);
}
return(result);
}
