110,499
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE [dbo].[G1_GetRecruitListByAllItems]
-- Add the parameters for the stored procedure here
(
@Dept varchar(50),
@Statues int,
@StartTime datetime,
@EndTime datetime
)
AS
BEGIN
SET NOCOUNT ON;
declare @sql varchar(1000)
set @sql = '
SELECT re.Id,
de.DepartmentName,
re.CreateTime,
us.UserName,
re.Sate
FROM
G1_Recruit as re JOIN G1_Department as de ON re.DeptId=de.DepartmentId
LEFT JOIN G1_User as us ON re.CreateUserId=us.UserId where 1=1
'
if(@Dept !='==请选择==')
BEGIN
--print '到达Dept判断 '
SET @sql = @sql + ' and de.DepartmentName = ''' + @Dept + ''''
END
if(@Statues !=4)
BEGIN
--print '到达Statues判断'
SET @sql = @sql + ' and re.Sate =' + cast(@Statues as varchar(2))
--print '状态判断完成'
END
if(@StartTime!=null)
BEGIN
--print '到达时间判断'
SET @sql = @sql + ' and re.CreateTime >= ''' +@StartTime+''''
--print '时间判断完成'
END
if(@EndTime!=null)
BEGIN
--print '到达时间判断'
SET @sql = @sql +' and re.CreateTime <='''+@EndTime +''''
--print '时间判断完成'
END
SET @sql = @sql + ' ORDER By re.CreateTime DESC'
PRINT @sql
EXEC (@sql)
END