印特支持中心
【脚本】二代程序，调整门店的耗材扩展信息
2018-08-27 易林江
1220
0
二代程序通过数据库脚本，调整门店的耗材扩展信息，并同步至总部。
-
执行脚本
INSERT INTO
INM_MaterialExtend
Select
NewId() as Id,
Code,
0 as CurrentMarketPrice,
0 as LastPurchasePrice,
0 as AverageCostPrice,
0 as LowestStockNumber,
0 as HighestStockNumber,
*** as ShopCode,
10 as Sys4Version
from INM_Material Where Code NOT In (Select Code From INM_MaterialExtend)EXEC SYS_SYncPushToBase_Insert
'INM_MaterialExtend',
'Id',
'*',
10000,
'Insert',
'Sys4Version = 10','',
'',
10
GO
------------------总部执行，同步扩展信息到门店。
exec SYS_SyncPushToShop_InsertToAShop 门店编号,'INM_MaterialExtend','id','id值',0,'insert','','','',10
--------------------门店执行，同步耗材扩展信息至总部
exec SYS_SyncPushToBase_Insert 'INM_MaterialExtend','Id','*',10,'Insert','','','',10