public QueryResult GetProductAccessoriesByQuery(ProductAccessoriesQueryFilter query)
{
int totalCount;
var dataTable = ObjectFactory <IProductAccessoriesDA> .Instance.GetProductAccessoriesByQuery(query, out totalCount);
return(new QueryResult
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 根据query得到配件查询信息
/// </summary>
/// <param name="query"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetProductAccessoriesByQuery(ProductAccessoriesQueryFilter query, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetProductAccessoriesByQuery");
cmd.SetParameterValue("@AccessoriesQueryName", query.AccessoriesQueryName);
cmd.SetParameterValue("@Status", query.Status);
cmd.SetParameterValue("@CreateUser", query.CreateUserName);
cmd.SetParameterValue("@BeginCreateDate", query.CreateDateFrom);
cmd.SetParameterValue("@EndCreateDate", query.CreateDateTo);
cmd.SetParameterValue("@PageSize", query.PagingInfo.PageSize);
cmd.SetParameterValue("@PageCurrent", query.PagingInfo.PageIndex);
cmd.SetParameterValue("@SortField", query.PagingInfo.SortBy);
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable(3, typeof(ValidStatus));
totalCount = (int)cmd.GetParameterValue("@TotalCount");
return(dt);
}