TXT Discuz.Web/upgrade/sqlscript/sqlserver/mall1.txt

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_creategoodstags]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_creategoodstags]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getgoodscount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getgoodscount]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getgoodscountbycid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getgoodscountbycid]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getgoodslist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getgoodslist]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getgoodslistbycid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getgoodslistbycid]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_updategoodstags]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updategoodstags]
GO




CREATE PROCEDURE [dnt_creategoodstags]
@tags nvarchar(55),
@goodsid int,
@userid int,
@postdatetime datetime
AS
BEGIN
	exec [dnt_createtags] @tags, @userid, @postdatetime

	UPDATE [dnt_tags] SET [gcount]=[gcount]+1,[count]=[count]+1
	WHERE EXISTS (SELECT [item] FROM [dnt_split](@tags, ' ') AS [newtags] WHERE [newtags].[item] = [tagname])

	INSERT INTO [dnt_goodstags] (tagid, goodsid)
	SELECT tagid, @goodsid FROM [dnt_tags] WHERE EXISTS (SELECT * FROM [dnt_split](@tags, ' ') WHERE [item] = [dnt_tags].[tagname])
END

GO





CREATE PROCEDURE [dnt_getgoodscount]
@condition varchar(500)
AS
DECLARE @strSQL varchar(5000)
SET @strSQL = 'SELECT count(goodsid) FROM [dnt_goods] WHERE '+ @condition
EXEC(@strSQL)

GO