public DataTable QueryStorePageInfo(StorePageQueryFilter filter, out int totalCount)
{
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryStorePageInfo");
PagingInfoEntity pagingInfo = new PagingInfoEntity()
{
SortField = filter.PageInfo.SortBy,
StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize,
MaximumRows = filter.PageInfo.PageSize
};
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "sp.SysNo desc"))
{
if (filter.MerchantSysNo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sp.SellerSysNo",
DbType.Int32, "@SellerSysNo", QueryConditionOperatorType.Equal, filter.MerchantSysNo.Value);
}
if (!string.IsNullOrEmpty(filter.PageType))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sp.PageTypeKey",
DbType.String, "@PageTypeKey", QueryConditionOperatorType.Equal, filter.PageType);
}
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
DataTable dt = dataCommand.ExecuteDataTable();
totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount"));
return(dt);
}
}
public QueryResult QueryStorePageInfo(StorePageQueryFilter filter)
{
int totalCount = 0;
QueryResult result = new QueryResult()
{
Data = ObjectFactory <IVendorQueryDA> .Instance.QueryStorePageInfo(filter, out totalCount)
};
result.TotalCount = totalCount;
return(result);
}
/// <summary>
/// 查询商家页面
/// </summary>
/// <param name="vendorSysNo"></param>
/// <param name="callback"></param>
public void QueryStorePageInfo(StorePageQueryFilter filter, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string relativeUrl = string.Format("/POService/Vendor/QueryStorePageInfo");
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
