05条码完成工序报表

原始版本

DECLARE @qlot varchar(255)
set @qlot= '{LOT}'
IF @qlot = ''
BEGIN
    SET @qlot = (SELECT top 1 [LOT_NAME]  FROM [Udit.SFC].[dbo].[QS_LOTS] where [CREATE_USER] not in ('pms','WG') and [INIT_QTY] > 0 order by CREATE_TIME desc );
END
SELECT  [工单],[条码] 条码,[操作时间],[操作员],[排序],[完成工序]
FROM [Udit.CSR].[dbo].[呆滞条码]
where [工单] = @qlot
order by [工单],[排序],[操作时间]
-- AND [完成工序] <> '丝印字符'

新修改的

DECLARE @qlot varchar(255)
DECLARE @stime varchar(255)
DECLARE @etime varchar(255)
set @qlot= '{LOT}'
IF @qlot = ''
BEGIN
    SET @qlot = (SELECT top 1 [LOT_NAME]  FROM [Udit.SFC].[dbo].[QS_LOTS] where [CREATE_USER] not in ('pms','WG') and [INIT_QTY] > 0 order by CREATE_TIME desc );
END
set @stime= '{stime}'
IF @stime = ''
BEGIN
    SET @stime =  DATEADD(HOUR, -24, GETDATE())
END
set @etime= '{etime}'
IF @etime = ''
BEGIN
    SET @etime =  GETDATE()
END
SELECT  [工单],[条码] 条码,[操作时间],[操作员],[排序],[完成工序]
FROM [Udit.CSR].[dbo].[呆滞条码]
where [工单] = @qlot
and [操作时间] >=@stime
and  [操作时间] <=@etime
and [操作员] like '%'+'{userid}'+'%'
and [完成工序] like '%'+'{step}'+'%'
order by [工单],[排序],[操作时间]
-- AND [完成工序] <> '丝印字符'