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);
});
}
