2025/7/8 9:42:41 InsertOrderRulesProcessed sql:insert into ServiceCenter..OrderRulesProcessed(RuleID,PlatformId,PlatformName,Priority,RuleType,RuleName,RuleDetails,RuleDetailsJson,RuleDescription,RuleActionCode,RuleActionJson,RuleActionDescription,[State],Comment,CreateUser,CreateTime,IsEnable,OpType)
select RuleID,PlatformId,PlatformName,Priority,RuleType,RuleName,RuleDetails,RuleDetailsJson,RuleDescription,RuleActionCode,RuleActionJson,RuleActionDescription,[State],Comment,CreateUser,CreateTime,IsEnable,'更新'
from ServiceCenter..OrderRules
where PlatformId in (55) and RuleName in (缺美中时-美东指定)
错误：System.Data.SqlClient.SqlException (0x80131904): 列名 '缺美中时' 无效。
列名 '美东指定' 无效。
   在 Vayava.Common.DBUtility.DbHelperSQL.ExecuteSql(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 151
   在 Vayava.Erp.Dal.OrderRulesDAL.InsertOrderRulesProcessed(String platformId, String ruleName, String opType) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\OrderRulesDAL.cs:行号 204
ClientConnectionId:8b1bc0a3-7f49-4e0a-b2be-433caa703141
Error Number:207,State:1,Class:16
2025/7/8 9:42:50 InsertOrderRulesProcessed sql:insert into ServiceCenter..OrderRulesProcessed(RuleID,PlatformId,PlatformName,Priority,RuleType,RuleName,RuleDetails,RuleDetailsJson,RuleDescription,RuleActionCode,RuleActionJson,RuleActionDescription,[State],Comment,CreateUser,CreateTime,IsEnable,OpType)
select RuleID,PlatformId,PlatformName,Priority,RuleType,RuleName,RuleDetails,RuleDetailsJson,RuleDescription,RuleActionCode,RuleActionJson,RuleActionDescription,[State],Comment,CreateUser,CreateTime,IsEnable,'更新'
from ServiceCenter..OrderRules
where PlatformId in (55) and RuleName in (缺美中时-美西指定)
错误：System.Data.SqlClient.SqlException (0x80131904): 列名 '缺美中时' 无效。
列名 '美西指定' 无效。
   在 Vayava.Common.DBUtility.DbHelperSQL.ExecuteSql(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 151
   在 Vayava.Erp.Dal.OrderRulesDAL.InsertOrderRulesProcessed(String platformId, String ruleName, String opType) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\OrderRulesDAL.cs:行号 204
ClientConnectionId:8b1bc0a3-7f49-4e0a-b2be-433caa703141
Error Number:207,State:1,Class:16
2025/7/8 9:43:07 InsertOrderRulesProcessed sql:insert into ServiceCenter..OrderRulesProcessed(RuleID,PlatformId,PlatformName,Priority,RuleType,RuleName,RuleDetails,RuleDetailsJson,RuleDescription,RuleActionCode,RuleActionJson,RuleActionDescription,[State],Comment,CreateUser,CreateTime,IsEnable,OpType)
select RuleID,PlatformId,PlatformName,Priority,RuleType,RuleName,RuleDetails,RuleDetailsJson,RuleDescription,RuleActionCode,RuleActionJson,RuleActionDescription,[State],Comment,CreateUser,CreateTime,IsEnable,'更新'
from ServiceCenter..OrderRules
where PlatformId in (55) and RuleName in (Only美西-指定)
错误：System.Data.SqlClient.SqlException (0x80131904): 列名 'Only美西' 无效。
列名 '指定' 无效。
   在 Vayava.Common.DBUtility.DbHelperSQL.ExecuteSql(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 151
   在 Vayava.Erp.Dal.OrderRulesDAL.InsertOrderRulesProcessed(String platformId, String ruleName, String opType) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\OrderRulesDAL.cs:行号 204
ClientConnectionId:d2c3105b-e309-487d-8153-86af381f0a17
Error Number:207,State:1,Class:16
2025/7/8 11:00:34 InsertOrderRulesProcessed sql:insert into ServiceCenter..OrderRulesProcessed(RuleID,PlatformId,PlatformName,Priority,RuleType,RuleName,RuleDetails,RuleDetailsJson,RuleDescription,RuleActionCode,RuleActionJson,RuleActionDescription,[State],Comment,CreateUser,CreateTime,IsEnable,OpType)
select RuleID,PlatformId,PlatformName,Priority,RuleType,RuleName,RuleDetails,RuleDetailsJson,RuleDescription,RuleActionCode,RuleActionJson,RuleActionDescription,[State],Comment,CreateUser,CreateTime,IsEnable,'更新'
from ServiceCenter..OrderRules
where PlatformId in (55) and RuleName in (Only美西-指定)
错误：System.Data.SqlClient.SqlException (0x80131904): 列名 'Only美西' 无效。
列名 '指定' 无效。
   在 Vayava.Common.DBUtility.DbHelperSQL.ExecuteSql(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 151
   在 Vayava.Erp.Dal.OrderRulesDAL.InsertOrderRulesProcessed(String platformId, String ruleName, String opType) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\OrderRulesDAL.cs:行号 204
ClientConnectionId:dd79df0a-8a86-43c4-8c87-fde6c6251ebd
Error Number:207,State:1,Class:16
2025/7/8 11:00:48 InsertOrderRulesProcessed sql:insert into ServiceCenter..OrderRulesProcessed(RuleID,PlatformId,PlatformName,Priority,RuleType,RuleName,RuleDetails,RuleDetailsJson,RuleDescription,RuleActionCode,RuleActionJson,RuleActionDescription,[State],Comment,CreateUser,CreateTime,IsEnable,OpType)
select RuleID,PlatformId,PlatformName,Priority,RuleType,RuleName,RuleDetails,RuleDetailsJson,RuleDescription,RuleActionCode,RuleActionJson,RuleActionDescription,[State],Comment,CreateUser,CreateTime,IsEnable,'更新'
from ServiceCenter..OrderRules
where PlatformId in (55) and RuleName in (Only美西-指定)
错误：System.Data.SqlClient.SqlException (0x80131904): 列名 'Only美西' 无效。
列名 '指定' 无效。
   在 Vayava.Common.DBUtility.DbHelperSQL.ExecuteSql(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 151
   在 Vayava.Erp.Dal.OrderRulesDAL.InsertOrderRulesProcessed(String platformId, String ruleName, String opType) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\OrderRulesDAL.cs:行号 204
ClientConnectionId:dd79df0a-8a86-43c4-8c87-fde6c6251ebd
Error Number:207,State:1,Class:16
2025/7/8 11:00:59 pono:Touroll1528补001,ShowShipVias:[{"Code":"0065","ForwarderByID":"Z+SELF","CNDesc":"自提","ActualWeight":26.5,"TotalPrice":1.0,"TotalPriceOriginalCurrency":0.0,"CurrencyENDesc":null,"CurrencyCode":null,"FreightSide":"0","IsTrackId":null,"IsTrack":"是","ContrabandBattery":"<td>可运</br></td><td id='weijin0' ids='普货，无电池的电子产品，小剪刀类，螺丝刀工具类，折刀类，管制刀具类，大剪刀类，强磁性产品，弱磁性产品，手表类，纽扣电池，蓝牙、小电池产品，内置电池，配套电池，柱状纯电池，≤2600MAH的纯电池，＞2600MAH的纯电池，粉末类，膏状类产品，清洁胶产品，液体类，轻抛类，带液体产品，平衡车类，配套电池可转内置，植物类花草树木种子类产品，电子烟，蜡烛，易燃易爆类，自行车类'><div>普货，无电池的电子产品，小剪刀类，螺丝刀工具类，折刀类，管制刀具类，大剪刀类，强磁性产品，弱磁性产品，手表类，纽扣电池，蓝牙、小电池产品，内置电池，配套电池，柱状纯电池，≤2600MAH的纯电池，＞2600MAH的纯电池，粉末类，膏状类产品，清洁胶产品，液体类，轻抛类，带液体产品，平衡车类，配套电池可转内置，植物类花草树木种子类产品，电子烟，蜡烛，易燃易爆类，自行车类</div></td><td>可运</br></td>","Weijinpin":"可运</br>","dianchileixing":"普货，无电池的电子产品，小剪刀类，螺丝刀工具类，折刀类，管制刀具类，大剪刀类，强磁性产品，弱磁性产品，手表类，纽扣电池，蓝牙、小电池产品，内置电池，配套电池，柱状纯电池，≤2600MAH的纯电池，＞2600MAH的纯电池，粉末类，膏状类产品，清洁胶产品，液体类，轻抛类，带液体产品，平衡车类，配套电池可转内置，植物类花草树木种子类产品，电子烟，蜡烛，易燃易爆类，自行车类","fangpai":"可运</br>","WLEmbargoTypes":null,"Contraband":null,"Fake":"-458807.800%","Remarks":"9.27增加KUGOO-徐璐确认，改起运地华沙天马，加华沙仓，加华沙保税仓，加taxon","IsPrompt":"1","oraioChecked":null,"MaxLimitPrice":0.00,"Declare_CName":"","Declare_EName":"","TrackAddress":null,"WeightFormula":null,"Zone":null,"StartPostcode":null,"EndPostCode":null,"CountryName":null,"ShipViaDynamicColumn":null,"RemoteFee":0.0,"collectingMethod":0},{"Code":"0327","ForwarderByID":"DE001+DEDHL","CNDesc":"德国仓DHL本地","ActualWeight":26.5,"TotalPrice":264.8800,"TotalPriceOriginalCurrency":0.0,"CurrencyENDesc":null,"CurrencyCode":null,"FreightSide":"1","IsTrackId":null,"IsTrack":"是","ContrabandBattery":"<td>不可运</br></td><td id='weijin1' ids='≤2600MAH的纯电池，平衡车类，普货，自行车类'><div>≤2600MAH的纯电池，平衡车类，普货，自行车类</div></td><td>不可运</br></td>","Weijinpin":"不可运</br>","dianchileixing":"≤2600MAH的纯电池，平衡车类，普货，自行车类","fangpai":"不可运</br>","WLEmbargoTypes":null,"Contraband":null,"Fake":"-458807.800%","Remarks":"AC德国仓","IsPrompt":"1","oraioChecked":null,"MaxLimitPrice":0.00,"Declare_CName":"","Declare_EName":"","TrackAddress":null,"WeightFormula":null,"Zone":null,"StartPostcode":null,"EndPostCode":null,"CountryName":null,"ShipViaDynamicColumn":null,"RemoteFee":0.0,"collectingMethod":0},{"Code":"1964","ForwarderByID":"D1+DEDPD","CNDesc":"德国本地DPD","ActualWeight":26.5,"TotalPrice":566.7508,"TotalPriceOriginalCurrency":0.0,"CurrencyENDesc":null,"CurrencyCode":null,"FreightSide":"1","IsTrackId":null,"IsTrack":"是","ContrabandBattery":"<td>不可运</br></td><td id='weijin3' ids='普货，小剪刀类，折刀类，大剪刀类，弱磁性产品，纽扣电池，内置电池，柱状纯电池，＞2600MAH的纯电池，膏状类产品，液体类，带液体产品，无电池的电子产品，管制刀具类，手表类，配套电池，粉末类，轻抛类，螺丝刀工具类，蓝牙、小电池产品，清洁胶产品，强磁性产品，平衡车类，配套电池可转内置，电子烟，易燃易爆类，植物类花草树木种子类产品，自行车类，蜡烛'><div>普货，小剪刀类，折刀类，大剪刀类，弱磁性产品，纽扣电池，内置电池，柱状纯电池，＞2600MAH的纯电池，膏状类产品，液体类，带液体产品，无电池的电子产品，管制刀具类，手表类，配套电池，粉末类，轻抛类，螺丝刀工具类，蓝牙、小电池产品，清洁胶产品，强磁性产品，平衡车类，配套电池可转内置，电子烟，易燃易爆类，植物类花草树木种子类产品，自行车类，蜡烛</div></td><td>不可运</br></td>","Weijinpin":"不可运</br>","dianchileixing":"普货，小剪刀类，折刀类，大剪刀类，弱磁性产品，纽扣电池，内置电池，柱状纯电池，＞2600MAH的纯电池，膏状类产品，液体类，带液体产品，无电池的电子产品，管制刀具类，手表类，配套电池，粉末类，轻抛类，螺丝刀工具类，蓝牙、小电池产品，清洁胶产品，强磁性产品，平衡车类，配套电池可转内置，电子烟，易燃易爆类，植物类花草树木种子类产品，自行车类，蜡烛","fangpai":"不可运</br>","WLEmbargoTypes":null,"Contraband":null,"Fake":"-458807.800%","Remarks":"","IsPrompt":"0","oraioChecked":null,"MaxLimitPrice":0.00,"Declare_CName":"","Declare_EName":"","TrackAddress":null,"WeightFormula":null,"Zone":null,"StartPostcode":null,"EndPostCode":null,"CountryName":null,"ShipViaDynamicColumn":null,"RemoteFee":0.0,"collectingMethod":0},{"Code":"1955","ForwarderByID":"DE001+DEGEL","CNDesc":"德国仓GEL本地","ActualWeight":47.272727272727272727272727273,"TotalPrice":625.6250,"TotalPriceOriginalCurrency":0.0,"CurrencyENDesc":null,"CurrencyCode":null,"FreightSide":"1","IsTrackId":null,"IsTrack":"是","ContrabandBattery":"<td>不可运</br></td><td id='weijin2' ids='普货，≤2600MAH的纯电池，平衡车类，自行车类'><div>普货，≤2600MAH的纯电池，平衡车类，自行车类</div></td><td>不可运</br></td>","Weijinpin":"不可运</br>","dianchileixing":"普货，≤2600MAH的纯电池，平衡车类，自行车类","fangpai":"不可运</br>","WLEmbargoTypes":null,"Contraband":null,"Fake":"-458807.800%","Remarks":"AC德国仓GEL  自行车渠道大件渠道非冲货渠道，不会不会因为尺寸重量问题退货。最大可以发500kg","IsPrompt":"1","oraioChecked":null,"MaxLimitPrice":0.00,"Declare_CName":"","Declare_EName":"","TrackAddress":null,"WeightFormula":null,"Zone":null,"StartPostcode":null,"EndPostCode":null,"CountryName":null,"ShipViaDynamicColumn":null,"RemoteFee":0.0,"collectingMethod":0}]
2025/7/8 11:00:59 InsertOrderRulesProcessed sql:insert into ServiceCenter..OrderRulesProcessed(RuleID,PlatformId,PlatformName,Priority,RuleType,RuleName,RuleDetails,RuleDetailsJson,RuleDescription,RuleActionCode,RuleActionJson,RuleActionDescription,[State],Comment,CreateUser,CreateTime,IsEnable,OpType)
select RuleID,PlatformId,PlatformName,Priority,RuleType,RuleName,RuleDetails,RuleDetailsJson,RuleDescription,RuleActionCode,RuleActionJson,RuleActionDescription,[State],Comment,CreateUser,CreateTime,IsEnable,'更新'
from ServiceCenter..OrderRules
where PlatformId in (55) and RuleName in (富皇仓)
错误：System.Data.SqlClient.SqlException (0x80131904): 列名 '富皇仓' 无效。
   在 Vayava.Common.DBUtility.DbHelperSQL.ExecuteSql(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 151
   在 Vayava.Erp.Dal.OrderRulesDAL.InsertOrderRulesProcessed(String platformId, String ruleName, String opType) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\OrderRulesDAL.cs:行号 204
ClientConnectionId:dd79df0a-8a86-43c4-8c87-fde6c6251ebd
Error Number:207,State:1,Class:16
2025/7/8 11:00:59 pono:Touroll1528补001,Fake:-458807.800%