本文整理汇总了C#中ProductRepository.GetProductList方法的典型用法代码示例。如果您正苦于以下问题：C# ProductRepository.GetProductList方法的具体用法？C# ProductRepository.GetProductList怎么用？C# ProductRepository.GetProductList使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ProductRepository的用法示例。
在下文中一共展示了ProductRepository.GetProductList方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: BuildJQGridResults
private string BuildJQGridResults(int numberOfRows, int pageIndex)
{
using (ProductRepository repo = new ProductRepository())
{
List<Product> allProducts = repo.GetProductList();
int FirstRecordID = ((pageIndex - 1) * numberOfRows) + 1;
int LastRecordID = pageIndex * numberOfRows;
//Filtering recordset using LINQ
List<Product> resultset = (from p in allProducts where p.ProductID >= FirstRecordID && p.ProductID <= LastRecordID select p).ToList<Product>();
JQGridResults result = new JQGridResults();
List<JQGridRow> rows = new List<JQGridRow>();
foreach (Product prod in resultset)
{
JQGridRow row = new JQGridRow();
row.id = prod.ProductID;
row.cell = new string[6];
row.cell[0] = prod.ProductID.ToString();
row.cell[1] = prod.ProductName;
row.cell[2] = prod.SupplierID.ToString();
row.cell[3] = prod.UnitPrice.ToString();
row.cell[4] = prod.UnitsInStock.ToString();
row.cell[5] = prod.UnitsOnOrder.ToString();
rows.Add(row);
}
result.rows = rows.ToArray();
result.page = pageIndex;
result.total = (allProducts.Count + numberOfRows - 1) / numberOfRows;
result.records = allProducts.Count;
String jsonResult = new JavaScriptSerializer().Serialize(result);
return jsonResult;
}
}示例2: BuildJQGridAllResults
private string BuildJQGridAllResults(int numberOfRows, int pageIndex)
{
using (ProductRepository repo = new ProductRepository())
{
List<Product> allProducts = repo.GetProductList();
JQGridResults result = new JQGridResults();
List<JQGridRow> rows = new List<JQGridRow>();
foreach (Product prod in allProducts)
{
JQGridRow row = new JQGridRow();
row.id = prod.ProductID;
row.cell = new string[6];
row.cell[0] = prod.ProductID.ToString();
row.cell[1] = prod.ProductName;
row.cell[2] = prod.SupplierID.ToString();
row.cell[3] = prod.UnitPrice.ToString();
row.cell[4] = prod.UnitsInStock.ToString();
row.cell[5] = prod.UnitsOnOrder.ToString();
rows.Add(row);
}
result.rows = rows.ToArray();
result.page = pageIndex;
result.total = (allProducts.Count + numberOfRows - 1) / numberOfRows;
result.records = allProducts.Count;
String jsonResult = new JavaScriptSerializer().Serialize(result);
return jsonResult;
}
}