public virtual QueryResult GetCategoryRelatedByQuery(CategoryRelatedQueryFilter query) { int totalCount; var dataTable = ObjectFactory <ICategoryRelatedDA> .Instance.GetCategoryRelatedByQuery(query, out totalCount); return(new QueryResult { Data = dataTable, TotalCount = totalCount }); }
public DataTable GetCategoryRelatedByQuery(CategoryRelatedQueryFilter query, out int totalCount) { DataCommand dc = DataCommandManager.GetDataCommand("GetCategoryRelatedList"); dc.SetParameterValue("@C1SysNo1", query.C1SysNo1); dc.SetParameterValue("@C2SysNo1", query.C2SysNo1); dc.SetParameterValue("@C3SysNo1", query.C3SysNo1); dc.SetParameterValue("@C1SysNo2", query.C1SysNo2); dc.SetParameterValue("@C2SysNo2", query.C2SysNo2); dc.SetParameterValue("@C3SysNo2", query.C3SysNo2); dc.SetParameterValue("@PageSize", query.PageInfo.PageSize); dc.SetParameterValue("@PageCurrent", query.PageInfo.PageIndex); dc.SetParameterValue("@SortField", query.PageInfo.SortBy); DataTable dt = new DataTable(); dt = dc.ExecuteDataTable(); totalCount = (int)dc.GetParameterValue("@TotalCount"); return(dt); }
public void GetCategoryRelatedByQuery(CategoryRelatedQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { CategoryRelatedQueryFilter query = new CategoryRelatedQueryFilter(); query = model.ConvertVM <CategoryRelatedQueryVM, CategoryRelatedQueryFilter>(); query.PageInfo = new PagingInfo { PageSize = PageSize, PageIndex = PageIndex, SortBy = SortField }; restClient.QueryDynamicData(GetCategoryRelatedUrl, query, (obj, args) => { if (args.FaultsHandle()) { return; } callback(obj, args); }); }