private DataTable RetrieveData() { DataTable lcDataTable; QueryClass lcQueryClass; GridFilterController lcGridFilterController; String lcFilterOption; String lcSortOption; lcGridFilterController = new GridFilterController(SC_FilterMetaData); lcFilterOption = lcGridFilterController.GetMultiFilterStr(clFilterInfo); lcSortOption = lcGridFilterController.GetMultiSortKeyStr(clSortInfo); lcQueryClass = DynamicQueryManager.GetInstance().GetQueryClass(ctRetrieveGridData); lcQueryClass.ReplacePlaceHolder("$FILTEROPTION", lcFilterOption, false); lcQueryClass.ReplacePlaceHolder("$SORTOPTION", lcSortOption, false); lcQueryClass.ReplacePlaceHolder("$PAGEINDEX", clPageIndex.ToString(), false); lcQueryClass.ReplacePlaceHolder("$PAGESIZE", SC_PageSize.ToString(), false); lcDataTable = lcQueryClass.RunQuery(); if (lcDataTable.Rows.Count > 0) { clTotalRows = Convert.ToInt32(lcDataTable.Rows[0][ctCOLTotalRows]); clTotalPages = Convert.ToInt32(lcDataTable.Rows[0][ctCOLTotalPages]); clFetchedRows = lcDataTable.Rows.Count; } else { clTotalRows = 0; clTotalPages = 0; clFetchedRows = 0; } return(lcDataTable); }
private void RenderItemGrid(ComponentController paComponentController) { SubControlMobileStoreFrontGridItem lcGridItem; lcGridItem = new SubControlMobileStoreFrontGridItem(); lcGridItem.IncludeExternalLinkFiles(paComponentController); lcGridItem.SC_LocalImagePath = SC_LocalImagePath; lcGridItem.SC_UniversalImagePath = SC_UniversalImagePath; paComponentController.AddElementType(ComponentController.ElementType.Container); paComponentController.AddAttribute(HtmlAttribute.Class, ctCLSItemContainer); paComponentController.RenderBeginTag(HtmlTag.Div); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_TotalRows, clTotalRows.ToString()); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_TotalPages, clTotalPages.ToString()); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_PageIndex, "0"); paComponentController.AddElementAttribute(ComponentController.ElementAttribute.ea_PageSize, SC_PageSize.ToString()); paComponentController.AddElementType(ComponentController.ElementType.Grid); paComponentController.AddAttribute(HtmlAttribute.Class, ctCLSItemGridPanel); paComponentController.RenderBeginTag(HtmlTag.Div); foreach (DataRow lcRow in clDataTable.Rows) { lcGridItem.SetData(lcRow); lcGridItem.RenderChildMode(paComponentController); } paComponentController.RenderEndTag(); RenderAjaxLoaderDiv(paComponentController); RenderDetailOverlayDiv(paComponentController); paComponentController.RenderEndTag(); }