2025/6/16 0:01: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'504088487',@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”中插入重复键的行。重复键值为 (G16649615)。 语句已终止。 在 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:6e9675f6-d254-49d4-95cc-36fc81c899e6 Error Number:2601,State:1,Class:14 2025/6/16 4:01:03 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'608479951',@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”中插入重复键的行。重复键值为 (G16674589)。 语句已终止。 在 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:91499318-d8f3-4cec-88cd-20e41e2aa64b Error Number:2601,State:1,Class:14 2025/6/16 5:01:31 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'517266311',@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”中插入重复键的行。重复键值为 (G16680508)。 语句已终止。 在 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:d45d385a-ebe3-4b13-bb5a-37eeabe08493 Error Number:2601,State:1,Class:14 2025/6/16 11:02:18 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'09625/1689',@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”中插入重复键。重复键值为 (F202506161903)。 语句已终止。 在 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:7bb47d5c-01c1-48a3-b6a1-bc96a2995595 Error Number:2627,State:1,Class:14