public QueryResult QueryAccessoriesQueryConditionBind(ProductAccessoriesQueryConditionPreViewQueryFilter query)
{
int totalCount;
var dataTable = ObjectFactory <IProductAccessoriesDA> .Instance.QueryAccessoriesQueryConditionBind(query, out totalCount);
return(new QueryResult
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 查询
/// </summary>
/// <param name="model"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="SortField"></param>
/// <param name="callback"></param>
public void QueryAccessoriesQueryConditionBind(ProductAccessoriesQueryConditionPreViewQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
ProductAccessoriesQueryConditionPreViewQueryFilter query = model.ConvertVM <ProductAccessoriesQueryConditionPreViewQueryVM, ProductAccessoriesQueryConditionPreViewQueryFilter>();
query.PagingInfo = new PagingInfo()
{
PageIndex = PageIndex,
PageSize = PageSize,
SortBy = SortField
};
restClient.QueryDynamicData(QueryAccessoriesQueryConditionBindUrl, query, callback);
}
/// <summary>
/// 得到商品和条件选项值bing的信息
/// </summary>
/// <param name="query"></param>
/// <param name="totalCoutn"></param>
/// <returns></returns>
public DataTable QueryAccessoriesQueryConditionBind(ProductAccessoriesQueryConditionPreViewQueryFilter query, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("QueryAccessoriesQueryConditionBind");
cmd.SetParameterValue("@MasterSysNo", query.MasterSysNo);
cmd.SetParameterValue("@ProductID", query.ProductID);
cmd.SetParameterValue("@ConditionValueSysNo1", query.ConditionValueSysNo1);
cmd.SetParameterValue("@ConditionValueSysNo2", query.ConditionValueSysNo2);
cmd.SetParameterValue("@ConditionValueSysNo3", query.ConditionValueSysNo3);
cmd.SetParameterValue("@ConditionValueSysNo4", query.ConditionValueSysNo4);
cmd.SetParameterValue("@Category1SysNo", query.Category1SysNo);
cmd.SetParameterValue("@Category2SysNo", query.Category2SysNo);
cmd.SetParameterValue("@Category3SysNo", query.Category3SysNo);
cmd.SetParameterValue("@SortField", query.PagingInfo.SortBy);
cmd.SetParameterValue("@PageSize", query.PagingInfo.PageSize);
cmd.SetParameterValue("@PageCurrent", query.PagingInfo.PageIndex);
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable();
totalCount = (int)cmd.GetParameterValue("@TotalCount");
return(dt);
}
