数据库篇之存储过程[bsp_getuserorderlist]-BrnShop1.9升级至2.1升级说明（非官方版本）

最新推荐文章于 2020-07-08 21:45:34 发布

大伟先生

最新推荐文章于 2020-07-08 21:45:34 发布

阅读量696

点赞数

分类专栏： BrnShop

本文链接：https://blog.csdn.net/wenviwu/article/details/43048039

版权

BrnShop 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

差异如下图

根据差异图片可以到数据库执行语句中找不到图片二的内容

是创建一个存储过程

处理方式

1.删除原先的存储过程[bsp_getuserorderlist]

2.新建存储过程[bsp_getuserorderlist]

GO 
DROP PROCEDURE [bsp_getuserorderlist]
GO
CREATE PROCEDURE [bsp_getuserorderlist]
@uid int,
@pagesize int,
@pagenumber int,
@startaddtime varchar(30),
@endaddtime varchar(30),
@orderstate tinyint
AS
BEGIN
	SET NOCOUNT ON;
	DECLARE @condition nvarchar(1000);
	SET @condition = '';
	
	IF @orderstate > 0
	SET @condition = ' AND [orderstate]=' + STR(@orderstate);
	
	IF @startaddtime <> ''
	SET @condition = @condition + ' AND [addtime]>=''' + @startaddtime + '''';
	
	IF @endaddtime <> ''
	SET @condition = @condition + ' AND [addtime]<=''' + @endaddtime + '''';
	
	IF @pagenumber=1
	BEGIN
		EXEC('SELECT TOP ' + @pagesize + ' [oid],[osn],[uid],[orderstate],[orderamount],[parentid],[isreview],[addtime],[shipfriendname],[payfriendname],[paymode],[consignee] FROM [bsp_orders] WHERE [uid]=' + @uid + @condition + ' ORDER BY [oid] DESC');
	END
	ELSE
	BEGIN
	    DECLARE @count int;
	    SET @count = @pagesize*(@pagenumber-1);
		EXEC('SELECT TOP ' + @pagesize + ' [oid],[osn],[uid],[orderstate],[orderamount],[parentid],[isreview],[addtime],[shipfriendname],[payfriendname],[paymode],[consignee] FROM [bsp_orders] WHERE [uid]=' + @uid + @condition + ' AND [oid]<(SELECT MIN([oid]) FROM (SELECT TOP ' + @count + ' [oid] FROM [bsp_orders] WHERE [uid]=' + @uid + @condition + ' ORDER BY [oid] DESC) AS [temp]) ORDER BY [oid] DESC');
	END
END
GO