/// <summary>
/// 商品存储过程分页显示
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="Name"></param>
/// <param name="Brand"></param>
/// <param name="Types"></param>
/// <returns></returns>
public GoodsInfo_PageList GetGoodsInfosPage(int PageIndex, int PageSize, string Name, string Brand, string Types)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter()
{
ParameterName = "@Name", DbType = DbType.String, Value = Name
},
new SqlParameter()
{
ParameterName = "@Brand", DbType = DbType.String, Value = Brand
},
new SqlParameter()
{
ParameterName = "@Types", DbType = DbType.String, Value = Types
},
new SqlParameter()
{
ParameterName = "@PageIndex", DbType = DbType.Int32, Value = PageIndex
},
new SqlParameter()
{
ParameterName = "@PageSize", DbType = DbType.Int32, Value = PageSize
},
new SqlParameter()
{
ParameterName = "@PageCount", DbType = DbType.Int32, Direction = ParameterDirection.Output
},
new SqlParameter()
{
ParameterName = "@c", DbType = DbType.Int32, Direction = ParameterDirection.Output
}
};
GoodsInfo_PageList list = new GoodsInfo_PageList()
{
GoodsInfos = DBHelper.GetGoodsInfosPage("GoodsInfo_Page", parameters),
Count = Convert.ToInt32(parameters[5].Value),
GoodsCon = Convert.ToInt32(parameters[6].Value)
};
return(list);
}