34,838
社区成员




CREATE Procedure Plant_FIN_TA_GetViewByTANO
@TANO nvarchar(50),
@User nvarchar(50),
@Fdate nvarchar(50),
@Edate nvarchar(50)
as
exec('select AppDate,Name,Data,User,Status,TANO,Department,Amount from worklist
where (Name like ''%'+@User+'%'' or TANO like ''%'+ @TANO + '%'')
and AppDate between '+ @Fdate +' and '+ @Edate)
CREATE Procedure Plant_FIN_TA_GetViewByTANO (
@TANO nvarchar(50)
,@User nvarchar(50)
,@Fdate nvarchar(50)
,@Edate nvarchar(50)
) as
select
AppDate
,Name
,Data
,User
,Status
,TANO
,Department
,Amount
from worklist
where 1=1
and (isnull(@User,'') = '' or Name like '%'+@User+'%')
and (isnull(@TANO,'') = '' or TANO like '%'+@TANO+'%')
and (isnull(@Fdate,'') = '' or AppDate >= @Fdate)
and (isnull(@Edate,'') = '' or AppDate <= @Edate)
CREATE Procedure Plant_FIN_TA_GetViewByTANO(
@TANO nvarchar(50),
@User nvarchar(50),
@Fdate nvarchar(50),
@Edate nvarchar(50)
)
as
exec('select AppDate, Name,Data,User,Status,TANO,Department,Amount from worklist
where
Name like ''%'+@User+'%''
or TANO like ''%'+@TANO +'%''
and AppDate between '''+@Fdate +''' and '''+ @Edate+'''')
go
CREATE Procedure Plant_FIN_TA_GetViewByTANO(
@TANO nvarchar(50),
@User nvarchar(50),
@Fdate nvarchar(50),
@Edate nvarchar(50)
)
as
select
AppDate
,Name
,Data
,User
,Status
,TANO
,Department
,Amount
from worklist
where 1=1
and (@User = '' or Name like '%'+@User+'%')
and (@TANO = '' or TANO like '%'+@TANO+'%')
and (@Fdate = '' or AppDate >= @Fdate)
and (@Edate = '' or AppDate <= @Edate)
CREATE Procedure Plant_FIN_TA_GetViewByTANO(
@TANO nvarchar(50),
@User nvarchar(50),
@Fdate nvarchar(50),
@Edate nvarchar(50)
)
as
exec('select AppDate, Name,Data,User,Status,TANO,Department,Amount from worklist
where
Name like ''%'''+@User+'''%''
or TANO like ''%'''+@TANO +'''%''
and AppDate between '''+@Fdate +''' and '''+ @Edate+'''')