|
/**
|
** 子任务查询 视图
|
**/
|
IF EXISTS(SELECT 1 FROM sys.views WHERE name='TaskView')
|
DROP VIEW TaskView
|
GO
|
CREATE VIEW TaskView
|
AS
|
|
SELECT dbo.PartTask.id, dbo.PartTask.maintaskid, dbo.MainTask.sendtime, dbo.MainTask.status, dbo.MainTask.tasktype,
|
dbo.MainTask.finishstatus, dbo.PartTask.sourceplace, dbo.PartTask.type, dbo.PartTask.toplace,
|
dbo.PartTask.status AS partstatus, dbo.PartTask.updatetime, dbo.PartTask.eqname, dbo.PartTask.eqid,
|
dbo.PartTask.iscurrent,
|
case dbo.PartTask.iscurrent
|
when 1 then '是'
|
else '否' end as iscurrentText,-- 是否当前任务
|
dbo.PartTask.ishandled,
|
case dbo.PartTask.ishandled
|
when 1 then '已处理'
|
else '未处理' end as ishandledText,-- 是否处理
|
dbo.PartTask.isreleased,
|
case dbo.PartTask.isreleased
|
when 1 then '已下发'
|
else '未下发' end as isreleasedText,-- 是否下发
|
dbo.PartTask.isfinished,
|
case dbo.PartTask.isfinished
|
when 1 then '已完成'
|
else '未完成' end as isfinishedText,-- 是否完成
|
dbo.PartTask.taskcode,
|
dbo.PartTask.containertype,
|
|
dbo.PartTask.targetplace, dbo.PartTask.nexthandel,
|
dbo.PartTask.heighttype, dbo.PartTask.storageno, dbo.MainTask.taskno, dbo.PartTask.containername,
|
dbo.PartTask.filereason, dbo.PartTask.issueTime, dbo.PartTask.finishTime, dbo.PartTask.plcReceiveTime,
|
dbo.PartTask.isPersonHandler,
|
case dbo.PartTask.isPersonHandler
|
when 1 then '是'
|
else '否' end as isPersonHandlerText,-- 是否人工处理
|
|
dbo.PartTask.createtime,
|
'' as containertypeText,'' as nexthandelText
|
FROM dbo.PartTask LEFT OUTER JOIN
|
dbo.MainTask ON dbo.PartTask.maintaskid = dbo.MainTask.id
|
|
Go
|
|
|
/**
|
** 主任务查询 视图
|
**/
|
IF EXISTS(SELECT 1 FROM sys.views WHERE name='MainTaskView')
|
DROP VIEW MainTaskView
|
GO
|
CREATE VIEW MainTaskView
|
AS
|
|
SELECT dbo.MainTask.*,
|
'' as isfinishedText,-- 是否完成
|
|
'' as containertypeText,'' as tasktypeText,'' as statusText
|
FROM dbo.MainTask WITH(NOLOCK)
|
|
Go
|
