2025/11/13 9:48:37 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 (8) and RuleName in (最新lxq_德国海托部分产品直接录单)
错误:System.Data.SqlClient.SqlException (0x80131904): 列名 '最新lxq_德国海托部分产品直接录单' 无效。
在 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:行号 214
ClientConnectionId:e3e964fa-6401-4f7f-a850-1c73807aa047
Error Number:207,State:1,Class:16
2025/11/13 9:52:02 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 (8) and RuleName in (最新lxq_海外仓/菜鸟仓申报)
错误:System.Data.SqlClient.SqlException (0x80131904): 列名 '最新lxq_海外仓' 无效。
列名 '菜鸟仓申报' 无效。
在 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:行号 214
ClientConnectionId:208170f2-ed98-4b35-91f2-f1ce379b7984
Error Number:207,State:1,Class:16
2025/11/13 9:53:33 F202510221028已均摊;
2025/11/13 9:53:33 均摊记录:{"ContentEncoding":null,"ContentType":null,"Data":{"Msg":"均摊成功","oas":[{"Instruction":"a344f549-c6d9-423c-9834-5e659ef7f913","PONO":"3064126700658736","COID":"F20251113375","Status":"1","CommitTime":"2025/11/13 9:53:32","CommitUserID":"1873","HandleTime":"2025/11/13 9:53:32"}]},"JsonRequestBehavior":1,"MaxJsonLength":null,"RecursionLimit":null}
2025/11/13 9:53:33 包裹号:8624015,SystemDataVersion:after20211231,订单类型:0
2025/11/13 9:53:33 AddOtherLogForCheck re:1
2025/11/13 9:53:33 包裹号:8624015 请求URL:http://192.168.0.101:18081/WebAPI/PackageSyncFromOMSToWMS
请求XML:
CB8624015
352.4600
Aliexpress
Ronnie holmer
Netherlands
Gelderland
LAREN GLD
banninksweg 1
7245BA
Ronnie holmer
0611864000
ronnieholmer@msn.com
L1295
68.2028
2.5000
2025/11/13 9:53:29
1873
1873
2025/11/13 9:53:32
.
GRL+PLDPDEU
3064126700658736
512.1600
ZFPLGRL02
2552
2025/11/13 2:12:01
1
Ronnie holmer
EUR
0.86
NL
0
8
0
1
2025/11/13 2:12:01
0
0
FBM
GERMANY_DPD_DE
0
CB8624015
1069949
3064126700658736
Creality Space Pi Plus 双卷3D打印机耗材干燥盒 欧规
1
352.46
2.50
2025/11/13 9:53:29
0
0
0
352.46
件
0
0
0.00
1873
1873
64.0200
0.0000
CB8624015
3D打印机零件
3D Printers Accessories
74.2261
1
2.5000
China
China
USD
8477900000
2025/11/13 9:53:33 F202511122707已均摊;
2025/11/13 9:53:33 包裹号:8624015 请求URL:http://192.168.0.101:18081/WebAPI/PackageSyncFromOMSToWMS
返回结果 200Success
2025/11/13 9:53:33 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 (8) and RuleName in (最新lxq_小于20申报)
错误:System.Data.SqlClient.SqlException (0x80131904): 列名 '最新lxq_小于20申报' 无效。
在 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:行号 214
ClientConnectionId:2bfe6724-c2ea-4642-8b97-a400b74f2f02
Error Number:207,State:1,Class:16
2025/11/13 9:54:47 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 (8) and RuleName in (最新lxq_海外仓/菜鸟仓申报)
错误:System.Data.SqlClient.SqlException (0x80131904): 列名 '最新lxq_海外仓' 无效。
列名 '菜鸟仓申报' 无效。
在 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:行号 214
ClientConnectionId:4aae47dd-d437-4894-91ca-024e33b04c06
Error Number:207,State:1,Class:16
2025/11/13 9:55:33 AddOtherLogForCheck re:1
2025/11/13 9:55:33 包裹号:8624046 请求URL:http://192.168.0.101:18081/WebAPI/PackageSyncFromOMSToWMS
请求XML:
CB8624046
2121.2500
Shopify
Sahab Soh
United States
California
San Diego
7415 Charmant Drive 2515
92122
Sahab Soh
8189409998
sahabsoheili@gmail.com
L1030
351.7344
31.9000
2025/11/13 9:55:30
2619
2619
2025/11/13 9:55:30
.
R+FEDEX
Ausom10295
3759.2435
US2RD25
1030
2025/11/13 6:08:53
2
Sahab Soh
USD
1.00
US
0
125
0
1
2025/11/13 6:08:53
0
0
FBM
Free Shipping
0
CB8624046
1241135
Ausom10295
Ausom L1 美规 48V15.6Ah 800W 电动滑板车
1
2121.25
27.60
2025/11/13 9:55:30
0
0
0
2121.25
件
0
0
0.00
2619
2619
0.0000
0.0000
CB8624046
电动滑板车
Electric Scooters
544.8179
1
31.9000
China
China
USD
2025/11/13 9:55:33 包裹号:8624046 请求URL:http://192.168.0.101:18081/WebAPI/PackageSyncFromOMSToWMS
返回结果 200Success
2025/11/13 9:55:33 conStr:server=192.168.0.104,20190;database=SinadealTradeDB;Connect Timeout=999999;uid=prdproduser;pwd=Kamda@9091xmm;Max Pool Size=2000
2025/11/13 9:55:33 订单:3063919076455319
请求报文:{"tdCODetailList":[{"BrandId":0,"HSCode":"","Img":null,"PTGAssociatedValue":null,"RowPrice":0.0,"SettlementPrice":0.0,"COSubID":null,"COID":"F20251113469","ProductCode":"840442","ProductName":"SCULPFUN 蜂窝板 400x400mm","Unit":"PCS","COQuantity":1,"Color":null,"UnitPrice":33.02,"Amount":0.0,"TotalPrice":225.0,"Remark":null,"COSTATE":null,"Id":0,"PProperty":null,"ActualPrice":225.0,"OrderWeight":0.0,"IsGift":0,"delayRemark":null,"celltype":null,"dygl":null,"ItemId":null,"MangoFlag":"198","IndividualFreight":0.0,"PreferentialAmount":0.0,"DepartureNO":"ZFEUDF","DepartureName":null,"Weight":2.549,"IsNewProduct":false,"MainSku":null,"ProductState":null,"ProductStateText":null,"Inventory":0,"weijin":null,"ptg":null,"count":0,"Declare_CName":null,"Declare_EName":null,"IsShowChangeProduct":0,"IsVirtual":0,"CategoryId":0,"AverageFreight":0.0,"AverageUnitPrice":0.0,"AverageAmountWithCount":0.0,"ShippingQuantity":1,"ShippedQuantity":0,"OriginalQuantity":1,"MiddleNumber":0,"MiddleNumberForPack":0,"SalePrice":0.0,"StandardId":null,"ProductTypeID":null,"SellerSKU":"840442","ReturnMoney":null}],"userID":"1873","tdCOMain":{"WarehouseID":null,"IsRelatedAdditional":false,"MainOrderId":null,"IsSubOrder":false,"FulfillmentChannel":null,"InputUser":null,"Tag":null,"PackageInfos":null,"ShipDate":"0001-01-01T00:00:00","Inprogress":null,"PackageIDs":null,"myPONO":null,"COID":"F20251113469","PONo":"3063919076455319","Oaid":null,"OrderDate":"2025-11-13T02:50:06","ExpectDate":"0001-01-01T00:00:00","Freight":0.0,"TotalPrice":33.02,"CurrencyCode":"0004","InputUserID":"1873","Creator":null,"StoreManager":null,"InputTime":"2025-11-13T02:49:57","PARecordID":2552,"PlatformAccountName":null,"OrderRemark":".","COLevel":"0","COState":"Ordering","COStateName":null,"SpecialFlag":null,"PrintFlag":null,"DissensionFlag":null,"CompleteFlag":null,"FormerlyOrder":null,"COType":null,"HaveMend":null,"CustomerID":null,"CCountry":"38","CProvince":"Springe","CCity":"Springe","CAddressLineOne":"Alte Töpferstraße 16","CAddressLineTwo":null,"AddressLine":null,"CPostalCode":"31832","Feedback":null,"Priority":null,"CContact":"Dennis Schüler","Ctel":"1715706888","CFax":null,"ShipVia":"0507","Spec":null,"TransactionNumber":null,"MangoFlag":"198","MangoNumber":null,"FreightForwardingNo":null,"StateTime":"2025-11-13T09:55:33","Stock":0,"Itemtype":"Aliexpress","TotalCost":225.0,"ShipCost":1.0000,"TotalWeight":2.549,"WmsState":"0","Name":"GERMANY_DHL_P_DE_EXP","FreightSide":null,"OrderType":"0","OrderTypeName":null,"RAccount":null,"RPayMethod":"Aliexpress","ProductBrandStr":null,"CusEmail":null,"BuyerID":null,"CanAutoDownLoad":false,"NewCoustomerId":null,"CurrentRate":0.8625000073312500623156255297,"TypeId":0,"TransactionID":null,"OrderSourceType":1,"OrderSourceTypeLabel":null,"LastModifier":"1873","CurrencyShorts":"EUR","CNYExchangeRate":0.0,"DropShopping":false,"OrderConfirmMode":0,"LocalTime":"2025-11-13T02:50:06","AllotType":0,"VATNO":null,"HouseNumber":null,"IsVirtual":0,"ShippingWHType":null,"AbnormalFlag":null,"OnLine":0,"OnLineName":null,"ContractNo":null,"GoodsTotalSalesAmount":33.02,"RelationPoNo":null,"PlatformChargeRate":0.0300,"CompanyOperatingRates":0.1550,"AdjustThePriceOfGoods":0.0,"AdjustTheShippingFee":0.0,"HoldOn":0,"HoldOnName":null,"SalesType":0,"CreatedDate":"2025-11-13T03:27:30.303","ApprovalStatus":0,"ApprovalFlag":0,"GrossProfit":3.7794,"GrossInterestRate":0.1145,"ShippingRemark":null,"WarehouseAddressID":null,"PlatformId":"8","PARecordAccount":null,"PARecordName":null,"InOrUpFlag":0,"ncw":0,"CountDProduct":0,"CNCountry":null,"TotalAllPrice":0.0,"AllNumber":0,"Content":null,"PackageId":null,"payment":null,"isdelay":null,"AutoDownLoadReson":null,"Onsaleflag":null,"CurrencyCNDesc":null,"LastModifyDate":"2025-11-13T09:55:33","Reason_Type":null,"WISHDeliveryConfirmation":null,"affiliatedSource":null,"SalesTypeName":null,"CheckIsPackShipped":null,"HoldonReason":null,"ApprovalStatusName":null,"ReUploadedPackId":null,"CauseOfAuditFailure":null,"ApprovalLevel":null,"PlatformOrderDetails":[{"Id":2976925,"PONo":"3063919076455319","COID":"F20251113469","PlatformName":null,"AccountId":0,"AccountName":null,"ProductId":"1005009718343748","SellerSKU":"840442","SellerSKUName":"SCULPFUN Laser Cutting Honeycomb Working Table Board Platform for CO2 or diode Laser Engraver Cutting Machine, 400x400x22mm","SellerSKUCount":1,"UnitPrice":0.0,"ErpProductId":null,"ProductCount":0,"DepartureNO":null,"CreateUser":"1873","CreateTime":"2025/11/13 3:27:30","VersionNumber":0,"ChildOrderId":null,"ChildOrderListId":null,"AlreadyTaxed":null,"OrderSortId":0,"AEPlusInfo":null,"ShipmentId":null,"Oaid":null,"deliveryDate":null}],"RemoteFee":0.0,"TaxOnAPI":0,"TotalAmountOfTax":0.0,"IsApplyInvoice":0,"IsDateCanBeInvoiced":false,"IsAfterSale":false,"transaction_id":null}}
2025/11/13 9:55:33 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 (8) and RuleName in (最新lxq_海外仓/菜鸟仓申报)
错误:System.Data.SqlClient.SqlException (0x80131904): 列名 '最新lxq_海外仓' 无效。
列名 '菜鸟仓申报' 无效。
在 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:行号 214
ClientConnectionId:208170f2-ed98-4b35-91f2-f1ce379b7984
Error Number:207,State:1,Class:16
2025/11/13 9:57:10 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 (8) and RuleName in (最新lxq_海外仓申报)
错误:System.Data.SqlClient.SqlException (0x80131904): 列名 '最新lxq_海外仓申报' 无效。
在 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:行号 214
ClientConnectionId:56d560e2-a9f2-4998-a5d4-45a95bea841b
Error Number:207,State:1,Class:16
2025/11/13 10:03:44 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 (8) and RuleName in (lxq毛利规则泛欧)
错误:System.Data.SqlClient.SqlException (0x80131904): 列名 'lxq毛利规则泛欧' 无效。
在 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:行号 214
ClientConnectionId:36484809-62c6-4f04-b503-d729303e5364
Error Number:207,State:1,Class:16
2025/11/13 18:08: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 (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:行号 214
ClientConnectionId:58a10168-f72c-4a66-ae43-2a9ad82b68e1
Error Number:207,State:1,Class:16
2025/11/13 18:13:58 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): “美东”附近有语法错误。
在 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:行号 214
ClientConnectionId:74710c22-59df-455d-86e9-be612b882bc3
Error Number:102,State:1,Class:15
2025/11/13 18:15:05 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 (代销USDX)
错误:System.Data.SqlClient.SqlException (0x80131904): 列名 '代销USDX' 无效。
在 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:行号 214
ClientConnectionId:6562e1c6-ae89-436d-8e62-996791060f55
Error Number:207,State:1,Class:16
2025/11/13 18:15:10 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:行号 214
ClientConnectionId:5cb9df12-00d7-48cc-bc32-8625ff312d23
Error Number:102,State:1,Class:15