|
if not (@PlanEndDateF is null)
SET @WhereClause = @WhereClause 'AND
(([PlanEndDate] is null) or ([PlanEndDate] >= CAST(''' CAST(@PlanEndDateF as nvarchar) ''' AS datetime)))'
if not (@PlanEndDateL is null)
SET @WhereClause = @WhereClause 'AND
(([PlanEndDate] is null) or ([PlanEndDate] <= CAST(''' CAST(@PlanEndDateL as nvarchar) ''' AS datetime)))'
if not (@CompletedDateF is null)
SET @WhereClause = @WhereClause 'AND
(([CompletedDate] is null) or ([CompletedDate] >= CAST(''' CAST(@CompletedDateF as nvarchar) ''' AS datetime)))'
if not (@CompletedDateL is null)
SET @WhereClause = @WhereClause 'AND
(([CompletedDate] is null) or ([CompletedDate] <= CAST(''' CAST(@CompletedDateL as nvarchar) ''' AS datetime)))'
if (@WhereClause = 'WHERE --')
SET @WhereClause = ''
SET @sql = '
SELECT
Task.[TaskID],
[TaskSQN],
[TaskName],
[DepartmentID],
[ChangerID],
[CreatedDate],
(SELECT FullName FROM dbo.UserInfo AS CreatorUser WHERE (dbo.Task.CreatorID = UserID)) AS
Creator,
[CreatorID],
[Triage],
(SELECT DepartmentName FROM dbo.Department WHERE (dbo.Task.DepartmentID = DepartmentID)) AS
Department,
[ChiefID],
(SELECT FullName FROM dbo.UserInfo AS ChiefUser WHERE (dbo.Task.ChiefID = UserID)) AS
Chief,
[ProjectID],
(SELECT ProjectName FROM dbo.Project WHERE (dbo.Task.ProjectID = ProjectID)) AS
Project,
[PlanEndDate],
[PlanStartDate],
[CompletedDate],
[Priority],
[State],
[WorkLoad],
(SELECT TaskName FROM dbo.Task AS ParentTask WHERE (dbo.Task.ParentID = TaskID)) AS
ParentTask,
[ParentID],
(SELECT ProjectAreaName FROM dbo.ProjectArea WHERE (dbo.Task.ProjectAreaID = ProjectAreaID)) AS
ProjectArea,
[ProjectAreaID],
[Description],
[Rev],
[ChangedDate],
(SELECT FullName FROM dbo.UserInfo AS ChangerUser WHERE (dbo.Task.ChangerID = UserID)) AS
Changer
FROM Task,
(SELECT
[TaskID],
ROW_NUMBER() OVER (ORDER BY ' @FSortExpression ') AS RowRank
FROM [Task]
' @WhereClause '
) AS RankTask
WHERE (Task.TaskID = RankTask.TaskID)
AND (RankTask.RowRank >= ' CONVERT(nvarchar(10), @FStartRowIndex) ')
AND (RankTask.RowRank < ' CONVERT(nvarchar(10), @FEndRowIndex) ')
'SET @ViewSql = '
SELECT
ViewTask.[TaskID],
[TaskSQN],
[TaskName],
[DepartmentID],
[ChangerID],
[CreatedDate],
[Creator],
[CreatorID],
[Triage],
[Department],
[ChiefID],
[Chief],
[ProjectID],
[Project],
[PlanEndDate],
[PlanStartDate],
[CompletedDate],
[Priority],
[State],
|
| 共7页: 上一页 [1] 2 [3] [4] [5] [6] [7] 下一页 |
评论加载中…
