C519更改交付方式后TMS无法抓取数据，TMS网站无法刷新出交付单号

原因：

C519交付方式由以前的6个一张交付单，更改为20个为一张交付单，导致TMS数据无法抓取

解决方法：

1、在TMS 中转数据库（服务器：10.125.138.151，数据库：TMS_MID）表YFJS_PACKAGE
建立对应的C519数据

2、更改存储过程：GetDataFromC346，更改如下：
USE [TMS_MID]
GO
/****** Object: StoredProcedure [dbo].[GetDataFromC346] Script Date: 2019/10/23 15:11:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[GetDataFromC346]
AS
BEGIN
declare @mydate datetime
set @mydate=dateadd(HOUR,-1,getdate())

 

/*346:Deliverycode*/
insert into [YFJS_EDI_ORDER]([DeliveryCodeAll],[SendFrom],[ReceiveBy],[ReceiveAddress],[SendTime],[Project],[BoxNum],[Status],[mesGetTime])

select [Deliverycode],'HMP','FORD','FORD CQ2 Plant',[CompleteTime],'C519','1','0',CONVERT(varchar, getdate(), 120 ) from C519.[ADNT_HMPJIT_C519].[dbo].[RecordDeliveryCode]
where not [PrintStation] like '%TMS%' and [CompleteTime] > @mydate and not [Deliverycode] in (select [DeliverycodeAll] from [TMS_MID].[dbo].[YFJS_EDI_ORDER])

update C519.[ADNT_HMPJIT_C519].[dbo].[RecordDeliveryCode] set [PrintStation] = [PrintStation]+ '@TMS@,'
where not [PrintStation] like '%TMS%' and [Deliverycode] in (select [DeliveryCodeAll] from [TMS_MID].[dbo].[YFJS_EDI_ORDER])

END

3、更新TMS网站，包装模块里增加YFJS_PACKAGE表对应的C519数据