| 合计在制品数量*/
Select Partnum, Revision , Qnty = sum(Qnty) ,
DelDate , UPP , ProcCode = Name , Id
Into #Stknwip
From #tmpStknwip
Group By Partnum, Revision , DelDate , UPP , Id , Name
Order By ID
/*判断完整性*/
IF (( Not Exists( Select * from #WeekConfig )) and (Not Exists( Select * from #Stknwip )) )
Begin
Insert Into #Stknwip( Partnum, Revision , Qnty, ProcCode , Id)
Select ''''not data'''' , ''''no'''' , 0 , ProcCode = Name , Id
From PDL_ProcGroup
Insert Into #WeekConfig(PartNum , Revision , Qnty ,WeekDate , Com)
Select ''''not data'''' , ''''no'''' , 0 , @BDateTime, ''''A9''''
End
Else
Begin
IF Not Exists( Select * from #Stknwip )
Insert Into #Stknwip( Partnum, Revision , Qnty, ProcCode , Id)
Select ''''not data'''' , ''''no'''' , 0 , ProcCode = Name , Id
From PDL_ProcGroup
IF Not Exists ( Select * From #WeekConfig )
Insert Into #WeekConfig(PartNum , Revision , Qnty ,WeekDate, Com)
Select Top 1 t1.Partnum, t1.Revision , Qnty = 0 , @BDateTime , ''''A9''''
From Stknwip t1(nolock), LotInfo t2(nolock)
Where t1.LotNum=t2.LotNum &nb << 上一页 [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] ... 下一页 >> |
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 