晒晒我的通用数据访问层

发表于：2011-7-07 10:05

作者：李奇峰来源：51Testing软件测试网采编

　　C#调用代码

　　存储过程-获取商品列表，支持分页

create procedure [dbo].[GetProductByCategoryId](
@CategoryID int,
@PageIndex int = 0,
@PageSize int = 20,
@TotalRecords int output
)
as
begin
declare @ResultTable table
(
RowIndex int,
ProductID int,
ProductName nvarchar(50),
CategoryID int,
Unit nvarchar(10),
UnitPrice money,
Quantity int
);
insert into @ResultTable
select row_number() over (order by ProductID asc) as RowIndex,
p.ProductID, p.ProductName, p.CategoryID, p.Unit, p.UnitPrice, p.Quantity
from Products as p
where CategoryID = @CategoryID;
select @TotalRecords = count(*) from @ResultTable;
select *
from @ResultTable
where RowIndex > (@PageSize * @PageIndex) and RowIndex <= (@PageSize * (@PageIndex+1));
end;

　　C#调用代码

public List<Product> GetProductByCategoryId(int categoryId, ref int pageIndex, int pageSize, out int recCount)
{
return FishBLLHelper.CallSpGetDataItemListPaged<Product>("GetProductByCategoryId",
ref pageIndex, pageSize, out recCount, categoryId);
}

42/4<123 4 >

测试技术了解

2023测试行业调查报告

挣点稿费

AI与软件测试

文章资料精选