public QueryResult QueryDynamicCategoryMapping(ECDynamicCategoryMappingQueryFilter filter)
{
int totalCount;
var dataTable = ObjectFactory <IECDynamicCategoryQueryDA> .Instance.QueryECDynamicCategoryMapping(filter, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
public void QueryProductMapping(int categorySysNo, int pageIndex, int pageSize, string sortBy, EventHandler <RestClientEventArgs <dynamic> > callback)
{
ECDynamicCategoryMappingQueryFilter filter = new ECDynamicCategoryMappingQueryFilter
{
CompanyCode = CPApplication.Current.CompanyCode,
DynamicCategorySysNo = categorySysNo,
PagingInfo = new PagingInfo {
PageIndex = pageIndex, PageSize = pageSize, SortBy = sortBy
}
};
string relativeUrl = "/MKTService/ECDynamicCategory/QueryMapping";
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
public DataTable QueryECDynamicCategoryMapping(ECDynamicCategoryMappingQueryFilter filter, out int totalCount)
{
var pagingInfo = new PagingInfoEntity
{
SortField = filter.PagingInfo.SortBy,
StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize,
MaximumRows = filter.PagingInfo.PageSize
};
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("MKT_GetECDynamicCategoryMapping");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingInfo, "m.SysNo DESC"))
{
//状态
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"m.DynamicCategorySysNo",
DbType.Int32,
"@DynamicCategorySysNo",
QueryConditionOperatorType.Equal,
filter.DynamicCategorySysNo);
//只查询有效的
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"m.Status",
DbType.Int32,
"@Status",
QueryConditionOperatorType.Equal,
0);
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"m.CompanyCode",
DbType.AnsiStringFixedLength,
"@CompanyCode",
QueryConditionOperatorType.Equal,
filter.CompanyCode);
//TODO:添加渠道过滤条件
cmd.CommandText = sqlBuilder.BuildQuerySql();
EnumColumnList list = new EnumColumnList();
list.Add("ProductStatus", typeof(ProductStatus));
var dt = cmd.ExecuteDataTable(list);
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
