public QueryResult GetProductLineByQuery(ProductLineQueryFilter query)
{
int totalCount;
var dataTable = ObjectFactory <IProductLineDA> .Instance.GetProductLineByQuery(query, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 根据query得到产品线信息
/// </summary>
/// <param name="query"></param>
/// <returns>DataTable</returns>
public DataTable GetProductLineByQuery(ProductLineQueryFilter query, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetProductLineByQuery");
cmd.SetParameterValue("@ProductLineName", query.ProductLineName);
cmd.SetParameterValue("@PageIndex", query.PageInfo.PageIndex);
cmd.SetParameterValue("@PageSize", query.PageInfo.PageSize);
cmd.SetParameterValue("@SortFiled", query.PageInfo.SortBy);
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable();
totalCount = (int)cmd.GetParameterValue("@TotalCount");
return(dt);
}
/// <summary>
/// 获取产品线信息
/// </summary>
/// <param name="model"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="SortField"></param>
/// <param name="callback"></param>
public void GetProductLineByQuery(ProductLineQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string GetProductLineByQueryUrl = "ExternalSYSService/ProductLine/GetProductLineByQuery";
ProductLineQueryFilter query = new ProductLineQueryFilter()
{
ProductLineName = model.ProductLineName,
PageInfo = new QueryFilter.Common.PagingInfo()
{
SortBy = SortField,
PageSize = PageSize,
PageIndex = PageIndex
}
};
restClient.QueryDynamicData(GetProductLineByQueryUrl, query, callback);
}
