27,579
社区成员
发帖
与我相关
我的任务
分享
ALTER PROCEDURE [dbo].[SelectArticlesAll]
(
@var1 varchar(50),--选择查询的类型
@var2 varchar(50)--选择查询的值
)
AS
SELECT
[ArticleID],
[ATitle],
[ACategoryID],
[Author],
[AClick],
[AIsTop],
[AIsRecommend],
[ATime],
[AIsShow],
[AIsExamine],
[AIsReview]
FROM
[dbo].[Article]
WHERE
@var1=@var2
ALTER PROCEDURE [dbo].[SelectArticlesAll]
(@startIndex int,
@endIndex int,
@var1 varchar(50),--选择查询的类型
@var2 varchar(50)--选择查询的值
)
AS
BEGIN
EXEC('
SELECT
[ArticleID],
[ATitle],
[ACategoryID],
[Author],
[AClick],
[AIsTop],
[AIsRecommend],
[ATime],
[AIsShow],
[AIsExamine],
[AIsReview]
FROM
[DBO].[ARTICLE]
WHERE '+ @VAR1 +'='''+@VAR2+''' AND ArticleID between '+@startIndex+' and '+ @endIndex+'')
END
ALTER PROCEDURE [dbo].[SelectArticlesAll]
(
@var1 varchar(50),--选择查询的类型
@var2 varchar(50)--选择查询的值
)
AS
begin
exec('
SELECT
[ArticleID],
[ATitle],
[ACategoryID],
[Author],
[AClick],
[AIsTop],
[AIsRecommend],
[ATime],
[AIsShow],
[AIsExamine],
[AIsReview]
FROM
[dbo].[Article]
WHERE '+
@var1+'='''+@var2+'''')
end
go
ALTER PROCEDURE [dbo].[SelectArticlesAll]
(
@var1 varchar(50),--选择查询的类型
@var2 varchar(50)--选择查询的值
)
AS
SELECT
[ArticleID],
[ATitle],
[ACategoryID],
[Author],
[AClick],
[AIsTop],
[AIsRecommend],
[ATime],
[AIsShow],
[AIsExamine],
[AIsReview]
FROM
[dbo].[Article]
WHERE
ACategoryID=@var1 and ATitle=@var2
string strsql="SELECT * FROM [dbo].[Article] WHERE 1=1 ";
if (下拉框选中1)
sql=sql+" AND 字段1=" +文本框的值;
elseif
......
然后将strsql丢给db执行就是了。
ALTER PROCEDURE [DBO].[SELECTARTICLESALL]
(
@VAR1 VARCHAR(50),--选择查询的类型
@VAR2 VARCHAR(50)--选择查询的值
)
AS
BEGIN
EXEC('
SELECT
[ARTICLEID],
[ATITLE],
[ACATEGORYID],
[AUTHOR],
[ACLICK],
[AISTOP],
[AISRECOMMEND],
[ATIME],
[AISSHOW],
[AISEXAMINE],
[AISREVIEW]
FROM
[DBO].[ARTICLE]
WHERE'+
@VAR1+'='''+@VAR2+''''
END