Author Name : lyf

    Date : 01/18/2005

*/

 --  exec Pdl_WeekDeliveryProcedure '''''''','''''''','''''''','''''''','''''''',''''''''

Alter  Procedure Pdl_WeekDeliveryProcedure

  @InBPartnum varchar(20) ='''''''', --''''DH024-030'''', -- '''''''', MH075-013

  @InEPartnum varchar(20) ='''''''', --''''DH024-030'''', -- '''''''', MH075-013

  @InBRevision varchar(5)='''''''',

  @InERevision varchar(5)='''''''',

  @BDate varchar(100), --datetime, --=''''01/18/2005''''  ,

  @EDate varchar(100), --datetime -- =''''01/21/2005''''

  @Flage int

  As

Declare @BDateTime datetime , @EDateTime datetime

--Set @BDate = isnull(@BDate, getdate())

--Set @EDate = isnull(@EDate, getdate()+6)

-------------调用更新维护纪录表数据存储过程-------------------

Exec Pdl_WeekProcDateUpdate

Select @BDateTime = convert(datetime,Convert(varchar , Getdate() , 101))

Select @EDateTime = convert(datetime,Convert(varchar , @BDateTime +7 , 101))

/*取周出货状态数据表结构*/

Select top 0 PartNum , Revision , Qnty= 0 , WeekDate=DateId , Com= ''''A9''''  -- = Convert(varchar(5), WeekDate , 101)

into #WeekConfig

 From Pdl_WeekProcedure(nolock)

/*在制品数据*/

select  t1.Partnum, t1.Revision ,

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ...  下一页 >>