public QueryResult QueryECCategoryMapping(ECCategoryMappingQueryFilter filter)
{
int totalCount;
var dataTable = ObjectFactory<IECCategoryQueryDA>.Instance.QueryECCategoryMapping(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)
{
ECCategoryMappingQueryFilter filter = new ECCategoryMappingQueryFilter
{
CompanyCode = CPApplication.Current.CompanyCode,
ECCategorySysNo = categorySysNo,
PagingInfo = new PagingInfo {
PageIndex = pageIndex, PageSize = pageSize, SortBy = sortBy
}
};
string relativeUrl = "/MKTService/ECCategory/QueryMapping";
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
public DataTable QueryECCategoryMapping(ECCategoryMappingQueryFilter 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_QueryECCategoryProductMapping");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingInfo, "m.SysNo DESC"))
{
//状态
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"m.ECCategorySysNo",
DbType.Int32,
"@ECCategorySysNo",
QueryConditionOperatorType.Equal,
filter.ECCategorySysNo);
//只查询有效的
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);
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);
}
}
