public void QueryECCCategory(ECCCategoryManagerVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { ECCManageCategoryQueryFilter filter = new ECCManageCategoryQueryFilter { Type = model.Type, Category1SysNo = model.Category1SysNo, Category2SysNo = model.Category2SysNo, Status = model.Status, CategoryName = model.CategoryName }; filter.PagingInfo = new PagingInfo { PageSize = PageSize, PageIndex = PageIndex, SortBy = SortField }; const string relativeUrl = "/MKTService/ECCategory/QueryECCCategory"; restClient.QueryDynamicData(relativeUrl, filter, (obj, args) => { if (args.FaultsHandle()) { return; } callback(obj, args); } ); }
public QueryResult QueryECCCategory(ECCManageCategoryQueryFilter queryFilter) { int totalCount; var dataTable = ObjectFactory<IECCategoryQueryDA>.Instance.QueryECCCategory(queryFilter, out totalCount); return new QueryResult { Data = dataTable, TotalCount = totalCount }; }
public DataTable QueryECCCategory(ECCManageCategoryQueryFilter query, out int totalCount) { DataCommand cmd = null; switch (query.Type) { case ECCCategoryManagerType.ECCCategoryType1: cmd = DataCommandManager.GetDataCommand("GetECCManageCategory1List"); break; case ECCCategoryManagerType.ECCCategoryType2: cmd = DataCommandManager.GetDataCommand("GetECCManageCategory2List"); cmd.SetParameterValue("@Category1SysNo", query.Category1SysNo); break; case ECCCategoryManagerType.ECCCategoryType3: cmd = DataCommandManager.GetDataCommand("GetECCManageCategory3List"); cmd.SetParameterValue("@Category1SysNo", query.Category1SysNo); cmd.SetParameterValue("@Category2SysNo", query.Category2SysNo); break; default: cmd = DataCommandManager.GetDataCommand("GetCategory1List"); break; } cmd.SetParameterValue("@PageCurrent", query.PagingInfo.PageIndex); cmd.SetParameterValue("@PageSize", query.PagingInfo.PageSize); cmd.SetParameterValue("@SortField", query.PagingInfo.SortBy); cmd.SetParameterValue("@Status", query.Status); cmd.SetParameterValue("@CategoryName", query.CategoryName); EnumColumnList enumList = new EnumColumnList { { "CategoryStatus", typeof(ECCCategoryManagerStatus) }, }; DataTable dt = new DataTable(); dt = cmd.ExecuteDataTable(enumList); totalCount = (int)cmd.GetParameterValue("@TotalCount"); return(dt); }