1.执行脚本 并升级相关补丁
If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = 'SF' And ParmKey = 'RevParser')
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue, ParmAssign, Ex1)
Select 'SF', 'RevParser', '收件人解密(默认为空)', 'oaid', '*', '*|仓库'
End
2.检查
select AppKey,AppSecret,ApiTaskAddr from TSysWmsApiConfig
是否有这3个字段 没有的话需要执行下面的语句
AppKey,AppSecret的值需要去对应的奇门接口apiconfig里查找
IF NOT EXISTS (SELECT * FROM dbo.syscolumns WHERE id = object_id('[dbo].[TSysWmsApiConfig]')
AND OBJECTPROPERTY(id, N'IsUserTable') = 1 AND name = 'AppKey')
ALTER TABLE [dbo].[TSysWmsApiConfig] ADD AppKey VARCHAR(30) NOT NULL DEFAULT ''
IF NOT EXISTS (SELECT * FROM dbo.syscolumns WHERE id = object_id('[dbo].[TSysWmsApiConfig]')
AND OBJECTPROPERTY(id, N'IsUserTable') = 1 AND name = 'AppSecret')
ALTER TABLE [dbo].[TSysWmsApiConfig] ADD AppSecret VARCHAR(255) NOT NULL DEFAULT ''
IF NOT EXISTS (SELECT * FROM dbo.syscolumns WHERE id = object_id('[dbo].[TSysWmsApiConfig]')
AND OBJECTPROPERTY(id, N'IsUserTable') = 1 AND name = 'ApiTaskAddr')
ALTER TABLE [dbo].[TSysWmsApiConfig] ADD ApiTaskAddr VARCHAR(255) NOT NULL DEFAULT ''
