2025/5/9 0:01:06 sql:INSERT INTO SinadealTradeDB..[tdCOMain]([COID],[PONo],[OrderDate],[ExpectDate],[Freight],[TotalPrice],[CurrencyCode],[InputUserID],[InputTime],[PARecordID],[OrderRemark],[COLevel],[COState],[SpecialFlag],[PrintFlag],[DissensionFlag],[CompleteFlag],[FormerlyOrder],[COType] ,[HaveMend],[CustomerID],[CCountry],[CProvince],[CCity],[CAddressLineOne],[CAddressLineTwo],[CPostalCode],[CContact],[Ctel],[CFax],[ShipVia],[Spec],[TransactionNumber],[MangoFlag],[MangoNumber],[StateTime],[Stock],[Itemtype],[TotalCost],[ShipCost],[TotalWeight],[WmsState],[FreightSide],[Name],RPayMethod,RAccount,CurrentRate,CanAutoDownLoad,BuyerId,TransactionID,Email,OrderSourceType,CurrencyShorts,CNYExchangeRate,LastModifier,LasModifyDate,OrderType,DropShopping,OrderConfirmMode,LocalTime,AllotType,VATNO,HouseNumber,IsVirtual,ShippingWHType,[OnLine],ContractNo,GoodsTotalSalesAmount,RelationPoNo,PlatformChargeRate,CompanyOperatingRates,AdjustThePriceOfGoods,AdjustTheShippingFee,HoldOn,SalesType,ShippingRemark,ApprovalStatus,ApprovalFlag,GrossProfit,GrossInterestRate,WarehouseAddressID,payment,NewCoustomerId,ApprovalLevel,Creator,StoreManager,RemoteFee,TaxOnAPI,FulfillmentChannel,MainOrderId,IsSubOrder)values(@COID,@PONo,@OrderDate,@ExpectDate,@Freight,@TotalPrice,@CurrencyCode,@InputUserID,@InputTime,@PARecordID,@OrderRemark,@COLevel,@COState,@SpecialFlag,@PrintFlag,@DissensionFlag,@CompleteFlag,@FormerlyOrder,@COType,@HaveMend,@CustomerID,@CCountry,@CProvince,@CCity,@CAddressLineOne,@CAddressLineTwo,@CPostalCode,@CContact,N'506174084',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'DPD',@RPayMethod,@RAccount,@CurrentRate,@CanAutoDownLoad,@BuyerId,@TransactionID,@Email,@OrderSourceType,@CurrencyShorts,@CNYExchangeRate,@LastModifier,GETDATE(),@OrderType,@DropShopping,@OrderConfirmMode,@LocalTime,@AllotType,@VATNO,@HouseNumber,@IsVirtual,@ShippingWHType,@OnLine,@ContractNo,@GoodsTotalSalesAmount,@RelationPoNo,@PlatformChargeRate,@CompanyOperatingRates,@AdjustThePriceOfGoods,@AdjustTheShippingFee,@HoldOn,@SalesType,@ShippingRemark,@ApprovalStatus,@ApprovalFlag,@GrossProfit,@GrossInterestRate,@WarehouseAddressID,@payment,@NewCoustomerId,@ApprovalLevel,@Creator,@StoreManager,@RemoteFee,@TaxOnAPI,@FulfillmentChannel,@MainOrderId,@IsSubOrder) 错误信息:System.Data.SqlClient.SqlException (0x80131904): 不能在具有唯一索引“ix_PONo”的对象“dbo.tdCOMain”中插入重复键的行。重复键值为 (G15348105)。 语句已终止。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 在 Vayava.Erp.Dal.InputOrderService.ExecuteSqlTran(List`1 SQLStringList, IDictionary`2 Dict) ClientConnectionId:e853aa60-ff1b-4b03-9243-ea9a8aaf4d9d Error Number:2601,State:1,Class:14 2025/5/9 18:47:00 sql:INSERT INTO SinadealTradeDB..[tdCOMain]([COID],[PONo],[OrderDate],[ExpectDate],[Freight],[TotalPrice],[CurrencyCode],[InputUserID],[InputTime],[PARecordID],[OrderRemark],[COLevel],[COState],[SpecialFlag],[PrintFlag],[DissensionFlag],[CompleteFlag],[FormerlyOrder],[COType] ,[HaveMend],[CustomerID],[CCountry],[CProvince],[CCity],[CAddressLineOne],[CAddressLineTwo],[CPostalCode],[CContact],[Ctel],[CFax],[ShipVia],[Spec],[TransactionNumber],[MangoFlag],[MangoNumber],[StateTime],[Stock],[Itemtype],[TotalCost],[ShipCost],[TotalWeight],[WmsState],[FreightSide],[Name],RPayMethod,RAccount,CurrentRate,CanAutoDownLoad,BuyerId,TransactionID,Email,OrderSourceType,CurrencyShorts,CNYExchangeRate,LastModifier,LasModifyDate,OrderType,DropShopping,OrderConfirmMode,LocalTime,AllotType,VATNO,HouseNumber,IsVirtual,ShippingWHType,[OnLine],ContractNo,GoodsTotalSalesAmount,RelationPoNo,PlatformChargeRate,CompanyOperatingRates,AdjustThePriceOfGoods,AdjustTheShippingFee,HoldOn,SalesType,ShippingRemark,ApprovalStatus,ApprovalFlag,GrossProfit,GrossInterestRate,WarehouseAddressID,payment,NewCoustomerId,ApprovalLevel,Creator,StoreManager,RemoteFee,TaxOnAPI,FulfillmentChannel,MainOrderId,IsSubOrder)values(@COID,@PONo,@OrderDate,@ExpectDate,@Freight,@TotalPrice,@CurrencyCode,@InputUserID,@InputTime,@PARecordID,@OrderRemark,@COLevel,@COState,@SpecialFlag,@PrintFlag,@DissensionFlag,@CompleteFlag,@FormerlyOrder,@COType,@HaveMend,@CustomerID,@CCountry,@CProvince,@CCity,@CAddressLineOne,@CAddressLineTwo,@CPostalCode,@CContact,N'+34 666305322',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'',@RPayMethod,@RAccount,@CurrentRate,@CanAutoDownLoad,@BuyerId,@TransactionID,@Email,@OrderSourceType,@CurrencyShorts,@CNYExchangeRate,@LastModifier,GETDATE(),@OrderType,@DropShopping,@OrderConfirmMode,@LocalTime,@AllotType,@VATNO,@HouseNumber,@IsVirtual,@ShippingWHType,@OnLine,@ContractNo,@GoodsTotalSalesAmount,@RelationPoNo,@PlatformChargeRate,@CompanyOperatingRates,@AdjustThePriceOfGoods,@AdjustTheShippingFee,@HoldOn,@SalesType,@ShippingRemark,@ApprovalStatus,@ApprovalFlag,@GrossProfit,@GrossInterestRate,@WarehouseAddressID,@payment,@NewCoustomerId,@ApprovalLevel,@Creator,@StoreManager,@RemoteFee,@TaxOnAPI,@FulfillmentChannel,@MainOrderId,@IsSubOrder) 错误信息:System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_tdCOMain”。不能在对象“dbo.tdCOMain”中插入重复键。重复键值为 (F202505092072)。 语句已终止。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 在 Vayava.Erp.Dal.InputOrderService.ExecuteSqlTran(List`1 SQLStringList, IDictionary`2 Dict) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\InputOrderService.cs:行号 8515 ClientConnectionId:83b6031a-d073-471c-89cf-aab219f927f5 Error Number:2627,State:1,Class:14 2025/5/9 18:47:00 sql:INSERT INTO SinadealTradeDB..[tdCOMain]([COID],[PONo],[OrderDate],[ExpectDate],[Freight],[TotalPrice],[CurrencyCode],[InputUserID],[InputTime],[PARecordID],[OrderRemark],[COLevel],[COState],[SpecialFlag],[PrintFlag],[DissensionFlag],[CompleteFlag],[FormerlyOrder],[COType] ,[HaveMend],[CustomerID],[CCountry],[CProvince],[CCity],[CAddressLineOne],[CAddressLineTwo],[CPostalCode],[CContact],[Ctel],[CFax],[ShipVia],[Spec],[TransactionNumber],[MangoFlag],[MangoNumber],[StateTime],[Stock],[Itemtype],[TotalCost],[ShipCost],[TotalWeight],[WmsState],[FreightSide],[Name],RPayMethod,RAccount,CurrentRate,CanAutoDownLoad,BuyerId,TransactionID,Email,OrderSourceType,CurrencyShorts,CNYExchangeRate,LastModifier,LasModifyDate,OrderType,DropShopping,OrderConfirmMode,LocalTime,AllotType,VATNO,HouseNumber,IsVirtual,ShippingWHType,[OnLine],ContractNo,GoodsTotalSalesAmount,RelationPoNo,PlatformChargeRate,CompanyOperatingRates,AdjustThePriceOfGoods,AdjustTheShippingFee,HoldOn,SalesType,ShippingRemark,ApprovalStatus,ApprovalFlag,GrossProfit,GrossInterestRate,WarehouseAddressID,payment,NewCoustomerId,ApprovalLevel,Creator,StoreManager,RemoteFee,TaxOnAPI,FulfillmentChannel,MainOrderId,IsSubOrder)values(@COID,@PONo,@OrderDate,@ExpectDate,@Freight,@TotalPrice,@CurrencyCode,@InputUserID,@InputTime,@PARecordID,@OrderRemark,@COLevel,@COState,@SpecialFlag,@PrintFlag,@DissensionFlag,@CompleteFlag,@FormerlyOrder,@COType,@HaveMend,@CustomerID,@CCountry,@CProvince,@CCity,@CAddressLineOne,@CAddressLineTwo,@CPostalCode,@CContact,N'+49 1577 9229037',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'',@RPayMethod,@RAccount,@CurrentRate,@CanAutoDownLoad,@BuyerId,@TransactionID,@Email,@OrderSourceType,@CurrencyShorts,@CNYExchangeRate,@LastModifier,GETDATE(),@OrderType,@DropShopping,@OrderConfirmMode,@LocalTime,@AllotType,@VATNO,@HouseNumber,@IsVirtual,@ShippingWHType,@OnLine,@ContractNo,@GoodsTotalSalesAmount,@RelationPoNo,@PlatformChargeRate,@CompanyOperatingRates,@AdjustThePriceOfGoods,@AdjustTheShippingFee,@HoldOn,@SalesType,@ShippingRemark,@ApprovalStatus,@ApprovalFlag,@GrossProfit,@GrossInterestRate,@WarehouseAddressID,@payment,@NewCoustomerId,@ApprovalLevel,@Creator,@StoreManager,@RemoteFee,@TaxOnAPI,@FulfillmentChannel,@MainOrderId,@IsSubOrder) 错误信息:System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_tdCOMain”。不能在对象“dbo.tdCOMain”中插入重复键。重复键值为 (F202505092078)。 语句已终止。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 在 Vayava.Erp.Dal.InputOrderService.ExecuteSqlTran(List`1 SQLStringList, IDictionary`2 Dict) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\InputOrderService.cs:行号 8515 ClientConnectionId:6f5fb8db-76d7-4a38-b7e0-3ebe4bc82b3b Error Number:2627,State:1,Class:14 2025/5/9 18:47:00 sql:INSERT INTO SinadealTradeDB..[tdCOMain]([COID],[PONo],[OrderDate],[ExpectDate],[Freight],[TotalPrice],[CurrencyCode],[InputUserID],[InputTime],[PARecordID],[OrderRemark],[COLevel],[COState],[SpecialFlag],[PrintFlag],[DissensionFlag],[CompleteFlag],[FormerlyOrder],[COType] ,[HaveMend],[CustomerID],[CCountry],[CProvince],[CCity],[CAddressLineOne],[CAddressLineTwo],[CPostalCode],[CContact],[Ctel],[CFax],[ShipVia],[Spec],[TransactionNumber],[MangoFlag],[MangoNumber],[StateTime],[Stock],[Itemtype],[TotalCost],[ShipCost],[TotalWeight],[WmsState],[FreightSide],[Name],RPayMethod,RAccount,CurrentRate,CanAutoDownLoad,BuyerId,TransactionID,Email,OrderSourceType,CurrencyShorts,CNYExchangeRate,LastModifier,LasModifyDate,OrderType,DropShopping,OrderConfirmMode,LocalTime,AllotType,VATNO,HouseNumber,IsVirtual,ShippingWHType,[OnLine],ContractNo,GoodsTotalSalesAmount,RelationPoNo,PlatformChargeRate,CompanyOperatingRates,AdjustThePriceOfGoods,AdjustTheShippingFee,HoldOn,SalesType,ShippingRemark,ApprovalStatus,ApprovalFlag,GrossProfit,GrossInterestRate,WarehouseAddressID,payment,NewCoustomerId,ApprovalLevel,Creator,StoreManager,RemoteFee,TaxOnAPI,FulfillmentChannel,MainOrderId,IsSubOrder)values(@COID,@PONo,@OrderDate,@ExpectDate,@Freight,@TotalPrice,@CurrencyCode,@InputUserID,@InputTime,@PARecordID,@OrderRemark,@COLevel,@COState,@SpecialFlag,@PrintFlag,@DissensionFlag,@CompleteFlag,@FormerlyOrder,@COType,@HaveMend,@CustomerID,@CCountry,@CProvince,@CCity,@CAddressLineOne,@CAddressLineTwo,@CPostalCode,@CContact,N'713-344-5768',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'',@RPayMethod,@RAccount,@CurrentRate,@CanAutoDownLoad,@BuyerId,@TransactionID,@Email,@OrderSourceType,@CurrencyShorts,@CNYExchangeRate,@LastModifier,GETDATE(),@OrderType,@DropShopping,@OrderConfirmMode,@LocalTime,@AllotType,@VATNO,@HouseNumber,@IsVirtual,@ShippingWHType,@OnLine,@ContractNo,@GoodsTotalSalesAmount,@RelationPoNo,@PlatformChargeRate,@CompanyOperatingRates,@AdjustThePriceOfGoods,@AdjustTheShippingFee,@HoldOn,@SalesType,@ShippingRemark,@ApprovalStatus,@ApprovalFlag,@GrossProfit,@GrossInterestRate,@WarehouseAddressID,@payment,@NewCoustomerId,@ApprovalLevel,@Creator,@StoreManager,@RemoteFee,@TaxOnAPI,@FulfillmentChannel,@MainOrderId,@IsSubOrder) 错误信息:System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_tdCOMain”。不能在对象“dbo.tdCOMain”中插入重复键。重复键值为 (F202505092074)。 语句已终止。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 在 Vayava.Erp.Dal.InputOrderService.ExecuteSqlTran(List`1 SQLStringList, IDictionary`2 Dict) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\InputOrderService.cs:行号 8515 ClientConnectionId:6673ed43-5297-4f27-9868-d3e9347e49a0 Error Number:2627,State:1,Class:14 2025/5/9 18:47:00 sql:INSERT INTO SinadealTradeDB..[tdCOMain]([COID],[PONo],[OrderDate],[ExpectDate],[Freight],[TotalPrice],[CurrencyCode],[InputUserID],[InputTime],[PARecordID],[OrderRemark],[COLevel],[COState],[SpecialFlag],[PrintFlag],[DissensionFlag],[CompleteFlag],[FormerlyOrder],[COType] ,[HaveMend],[CustomerID],[CCountry],[CProvince],[CCity],[CAddressLineOne],[CAddressLineTwo],[CPostalCode],[CContact],[Ctel],[CFax],[ShipVia],[Spec],[TransactionNumber],[MangoFlag],[MangoNumber],[StateTime],[Stock],[Itemtype],[TotalCost],[ShipCost],[TotalWeight],[WmsState],[FreightSide],[Name],RPayMethod,RAccount,CurrentRate,CanAutoDownLoad,BuyerId,TransactionID,Email,OrderSourceType,CurrencyShorts,CNYExchangeRate,LastModifier,LasModifyDate,OrderType,DropShopping,OrderConfirmMode,LocalTime,AllotType,VATNO,HouseNumber,IsVirtual,ShippingWHType,[OnLine],ContractNo,GoodsTotalSalesAmount,RelationPoNo,PlatformChargeRate,CompanyOperatingRates,AdjustThePriceOfGoods,AdjustTheShippingFee,HoldOn,SalesType,ShippingRemark,ApprovalStatus,ApprovalFlag,GrossProfit,GrossInterestRate,WarehouseAddressID,payment,NewCoustomerId,ApprovalLevel,Creator,StoreManager,RemoteFee,TaxOnAPI,FulfillmentChannel,MainOrderId,IsSubOrder)values(@COID,@PONo,@OrderDate,@ExpectDate,@Freight,@TotalPrice,@CurrencyCode,@InputUserID,@InputTime,@PARecordID,@OrderRemark,@COLevel,@COState,@SpecialFlag,@PrintFlag,@DissensionFlag,@CompleteFlag,@FormerlyOrder,@COType,@HaveMend,@CustomerID,@CCountry,@CProvince,@CCity,@CAddressLineOne,@CAddressLineTwo,@CPostalCode,@CContact,N'3384441631',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'',@RPayMethod,@RAccount,@CurrentRate,@CanAutoDownLoad,@BuyerId,@TransactionID,@Email,@OrderSourceType,@CurrencyShorts,@CNYExchangeRate,@LastModifier,GETDATE(),@OrderType,@DropShopping,@OrderConfirmMode,@LocalTime,@AllotType,@VATNO,@HouseNumber,@IsVirtual,@ShippingWHType,@OnLine,@ContractNo,@GoodsTotalSalesAmount,@RelationPoNo,@PlatformChargeRate,@CompanyOperatingRates,@AdjustThePriceOfGoods,@AdjustTheShippingFee,@HoldOn,@SalesType,@ShippingRemark,@ApprovalStatus,@ApprovalFlag,@GrossProfit,@GrossInterestRate,@WarehouseAddressID,@payment,@NewCoustomerId,@ApprovalLevel,@Creator,@StoreManager,@RemoteFee,@TaxOnAPI,@FulfillmentChannel,@MainOrderId,@IsSubOrder) 错误信息:System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_tdCOMain”。不能在对象“dbo.tdCOMain”中插入重复键。重复键值为 (F202505092081)。 语句已终止。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 在 Vayava.Erp.Dal.InputOrderService.ExecuteSqlTran(List`1 SQLStringList, IDictionary`2 Dict) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\InputOrderService.cs:行号 8515 ClientConnectionId:6673ed43-5297-4f27-9868-d3e9347e49a0 Error Number:2627,State:1,Class:14 2025/5/9 18:47:01 sql:INSERT INTO SinadealTradeDB..[tdCOMain]([COID],[PONo],[OrderDate],[ExpectDate],[Freight],[TotalPrice],[CurrencyCode],[InputUserID],[InputTime],[PARecordID],[OrderRemark],[COLevel],[COState],[SpecialFlag],[PrintFlag],[DissensionFlag],[CompleteFlag],[FormerlyOrder],[COType] ,[HaveMend],[CustomerID],[CCountry],[CProvince],[CCity],[CAddressLineOne],[CAddressLineTwo],[CPostalCode],[CContact],[Ctel],[CFax],[ShipVia],[Spec],[TransactionNumber],[MangoFlag],[MangoNumber],[StateTime],[Stock],[Itemtype],[TotalCost],[ShipCost],[TotalWeight],[WmsState],[FreightSide],[Name],RPayMethod,RAccount,CurrentRate,CanAutoDownLoad,BuyerId,TransactionID,Email,OrderSourceType,CurrencyShorts,CNYExchangeRate,LastModifier,LasModifyDate,OrderType,DropShopping,OrderConfirmMode,LocalTime,AllotType,VATNO,HouseNumber,IsVirtual,ShippingWHType,[OnLine],ContractNo,GoodsTotalSalesAmount,RelationPoNo,PlatformChargeRate,CompanyOperatingRates,AdjustThePriceOfGoods,AdjustTheShippingFee,HoldOn,SalesType,ShippingRemark,ApprovalStatus,ApprovalFlag,GrossProfit,GrossInterestRate,WarehouseAddressID,payment,NewCoustomerId,ApprovalLevel,Creator,StoreManager,RemoteFee,TaxOnAPI,FulfillmentChannel,MainOrderId,IsSubOrder)values(@COID,@PONo,@OrderDate,@ExpectDate,@Freight,@TotalPrice,@CurrencyCode,@InputUserID,@InputTime,@PARecordID,@OrderRemark,@COLevel,@COState,@SpecialFlag,@PrintFlag,@DissensionFlag,@CompleteFlag,@FormerlyOrder,@COType,@HaveMend,@CustomerID,@CCountry,@CProvince,@CCity,@CAddressLineOne,@CAddressLineTwo,@CPostalCode,@CContact,N'214-470-0107',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'',@RPayMethod,@RAccount,@CurrentRate,@CanAutoDownLoad,@BuyerId,@TransactionID,@Email,@OrderSourceType,@CurrencyShorts,@CNYExchangeRate,@LastModifier,GETDATE(),@OrderType,@DropShopping,@OrderConfirmMode,@LocalTime,@AllotType,@VATNO,@HouseNumber,@IsVirtual,@ShippingWHType,@OnLine,@ContractNo,@GoodsTotalSalesAmount,@RelationPoNo,@PlatformChargeRate,@CompanyOperatingRates,@AdjustThePriceOfGoods,@AdjustTheShippingFee,@HoldOn,@SalesType,@ShippingRemark,@ApprovalStatus,@ApprovalFlag,@GrossProfit,@GrossInterestRate,@WarehouseAddressID,@payment,@NewCoustomerId,@ApprovalLevel,@Creator,@StoreManager,@RemoteFee,@TaxOnAPI,@FulfillmentChannel,@MainOrderId,@IsSubOrder) 错误信息:System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_tdCOMain”。不能在对象“dbo.tdCOMain”中插入重复键。重复键值为 (F202505092084)。 语句已终止。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 在 Vayava.Erp.Dal.InputOrderService.ExecuteSqlTran(List`1 SQLStringList, IDictionary`2 Dict) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\InputOrderService.cs:行号 8515 ClientConnectionId:684317b1-2568-408a-8a90-a604b381223d Error Number:2627,State:1,Class:14 2025/5/9 18:47:01 sql:INSERT INTO SinadealTradeDB..[tdCOMain]([COID],[PONo],[OrderDate],[ExpectDate],[Freight],[TotalPrice],[CurrencyCode],[InputUserID],[InputTime],[PARecordID],[OrderRemark],[COLevel],[COState],[SpecialFlag],[PrintFlag],[DissensionFlag],[CompleteFlag],[FormerlyOrder],[COType] ,[HaveMend],[CustomerID],[CCountry],[CProvince],[CCity],[CAddressLineOne],[CAddressLineTwo],[CPostalCode],[CContact],[Ctel],[CFax],[ShipVia],[Spec],[TransactionNumber],[MangoFlag],[MangoNumber],[StateTime],[Stock],[Itemtype],[TotalCost],[ShipCost],[TotalWeight],[WmsState],[FreightSide],[Name],RPayMethod,RAccount,CurrentRate,CanAutoDownLoad,BuyerId,TransactionID,Email,OrderSourceType,CurrencyShorts,CNYExchangeRate,LastModifier,LasModifyDate,OrderType,DropShopping,OrderConfirmMode,LocalTime,AllotType,VATNO,HouseNumber,IsVirtual,ShippingWHType,[OnLine],ContractNo,GoodsTotalSalesAmount,RelationPoNo,PlatformChargeRate,CompanyOperatingRates,AdjustThePriceOfGoods,AdjustTheShippingFee,HoldOn,SalesType,ShippingRemark,ApprovalStatus,ApprovalFlag,GrossProfit,GrossInterestRate,WarehouseAddressID,payment,NewCoustomerId,ApprovalLevel,Creator,StoreManager,RemoteFee,TaxOnAPI,FulfillmentChannel,MainOrderId,IsSubOrder)values(@COID,@PONo,@OrderDate,@ExpectDate,@Freight,@TotalPrice,@CurrencyCode,@InputUserID,@InputTime,@PARecordID,@OrderRemark,@COLevel,@COState,@SpecialFlag,@PrintFlag,@DissensionFlag,@CompleteFlag,@FormerlyOrder,@COType,@HaveMend,@CustomerID,@CCountry,@CProvince,@CCity,@CAddressLineOne,@CAddressLineTwo,@CPostalCode,@CContact,N'06.99.43.75.56',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'',@RPayMethod,@RAccount,@CurrentRate,@CanAutoDownLoad,@BuyerId,@TransactionID,@Email,@OrderSourceType,@CurrencyShorts,@CNYExchangeRate,@LastModifier,GETDATE(),@OrderType,@DropShopping,@OrderConfirmMode,@LocalTime,@AllotType,@VATNO,@HouseNumber,@IsVirtual,@ShippingWHType,@OnLine,@ContractNo,@GoodsTotalSalesAmount,@RelationPoNo,@PlatformChargeRate,@CompanyOperatingRates,@AdjustThePriceOfGoods,@AdjustTheShippingFee,@HoldOn,@SalesType,@ShippingRemark,@ApprovalStatus,@ApprovalFlag,@GrossProfit,@GrossInterestRate,@WarehouseAddressID,@payment,@NewCoustomerId,@ApprovalLevel,@Creator,@StoreManager,@RemoteFee,@TaxOnAPI,@FulfillmentChannel,@MainOrderId,@IsSubOrder) 错误信息:System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_tdCOMain”。不能在对象“dbo.tdCOMain”中插入重复键。重复键值为 (F202505092088)。 语句已终止。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 在 Vayava.Erp.Dal.InputOrderService.ExecuteSqlTran(List`1 SQLStringList, IDictionary`2 Dict) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\InputOrderService.cs:行号 8515 ClientConnectionId:f6b13e59-e364-4d29-a524-79dfa3955003 Error Number:2627,State:1,Class:14 2025/5/9 18:47:02 sql:INSERT INTO SinadealTradeDB..[tdCOMain]([COID],[PONo],[OrderDate],[ExpectDate],[Freight],[TotalPrice],[CurrencyCode],[InputUserID],[InputTime],[PARecordID],[OrderRemark],[COLevel],[COState],[SpecialFlag],[PrintFlag],[DissensionFlag],[CompleteFlag],[FormerlyOrder],[COType] ,[HaveMend],[CustomerID],[CCountry],[CProvince],[CCity],[CAddressLineOne],[CAddressLineTwo],[CPostalCode],[CContact],[Ctel],[CFax],[ShipVia],[Spec],[TransactionNumber],[MangoFlag],[MangoNumber],[StateTime],[Stock],[Itemtype],[TotalCost],[ShipCost],[TotalWeight],[WmsState],[FreightSide],[Name],RPayMethod,RAccount,CurrentRate,CanAutoDownLoad,BuyerId,TransactionID,Email,OrderSourceType,CurrencyShorts,CNYExchangeRate,LastModifier,LasModifyDate,OrderType,DropShopping,OrderConfirmMode,LocalTime,AllotType,VATNO,HouseNumber,IsVirtual,ShippingWHType,[OnLine],ContractNo,GoodsTotalSalesAmount,RelationPoNo,PlatformChargeRate,CompanyOperatingRates,AdjustThePriceOfGoods,AdjustTheShippingFee,HoldOn,SalesType,ShippingRemark,ApprovalStatus,ApprovalFlag,GrossProfit,GrossInterestRate,WarehouseAddressID,payment,NewCoustomerId,ApprovalLevel,Creator,StoreManager,RemoteFee,TaxOnAPI,FulfillmentChannel,MainOrderId,IsSubOrder)values(@COID,@PONo,@OrderDate,@ExpectDate,@Freight,@TotalPrice,@CurrencyCode,@InputUserID,@InputTime,@PARecordID,@OrderRemark,@COLevel,@COState,@SpecialFlag,@PrintFlag,@DissensionFlag,@CompleteFlag,@FormerlyOrder,@COType,@HaveMend,@CustomerID,@CCountry,@CProvince,@CCity,@CAddressLineOne,@CAddressLineTwo,@CPostalCode,@CContact,N'+393807405752',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'',@RPayMethod,@RAccount,@CurrentRate,@CanAutoDownLoad,@BuyerId,@TransactionID,@Email,@OrderSourceType,@CurrencyShorts,@CNYExchangeRate,@LastModifier,GETDATE(),@OrderType,@DropShopping,@OrderConfirmMode,@LocalTime,@AllotType,@VATNO,@HouseNumber,@IsVirtual,@ShippingWHType,@OnLine,@ContractNo,@GoodsTotalSalesAmount,@RelationPoNo,@PlatformChargeRate,@CompanyOperatingRates,@AdjustThePriceOfGoods,@AdjustTheShippingFee,@HoldOn,@SalesType,@ShippingRemark,@ApprovalStatus,@ApprovalFlag,@GrossProfit,@GrossInterestRate,@WarehouseAddressID,@payment,@NewCoustomerId,@ApprovalLevel,@Creator,@StoreManager,@RemoteFee,@TaxOnAPI,@FulfillmentChannel,@MainOrderId,@IsSubOrder) 错误信息:System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_tdCOMain”。不能在对象“dbo.tdCOMain”中插入重复键。重复键值为 (F202505092090)。 语句已终止。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 在 Vayava.Erp.Dal.InputOrderService.ExecuteSqlTran(List`1 SQLStringList, IDictionary`2 Dict) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\InputOrderService.cs:行号 8515 ClientConnectionId:f6b13e59-e364-4d29-a524-79dfa3955003 Error Number:2627,State:1,Class:14