/// <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); }