and t1.Layer=t2.Layer                  

                         and t2.IsInSC <> 1                  

                         and t1.Qnty>0

                         and  t1.ProcCode not in(''''990'''',''''000'''')

                         and (( t1.PartNum >= @InBPartnum or @InBPartnum='''''''')

                                  and (t1.PartNum <= @InEPartnum or @InEPartnum=''''''''))

                         and ((t1.Revision = @InBRevision or @InBRevision ='''''''')

                                  and (t1.Revision = @InERevision or @InERevision =''''''''))

  End

/*生成出货状态时间格式以及完整性生成*/

Declare @Partnum varchar(20) , @Revision varchar(5) , @Count int , @DateCount int

Declare @WeekDate datetime , @Com varchar(200)

Select @Com =''''A''''

 DECLARE AddDateList INSENSITIVE CURSOR                                                                            

    FOR                      

          Select Partnum, Revision  From #WeekConfig

              Group by Partnum, Revision                             

  OPEN AddDateList                     

 << 上一页  [11] [12] [13] [14] [15] [16] [17] [18] [19] [20]  ...  下一页 >>