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