2025/11/16 0:00: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'+48538568280',@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): 违反了 PRIMARY KEY 约束“PK_tdCOMain”。不能在对象“dbo.tdCOMain”中插入重复键。重复键值为 (F20251116001)。
语句已终止。
   在 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:9d31c046-4cdb-4d85-b610-e16b52030732
Error Number:2627,State:1,Class:14
2025/11/16 0:00: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'+393277024478',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'Corriere Espresso',@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”中插入重复键。重复键值为 (F20251116001)。
语句已终止。
   在 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:8c0243bc-aaae-4880-b24d-f0583717db29
Error Number:2627,State:1,Class:14
2025/11/16 0: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'4915173023541',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'DHLEU',@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”中插入重复键的行。重复键值为 (D2511151526324)。
语句已终止。
   在 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:8e852f6d-6342-4104-bd5e-5ae1bdfb3097
Error Number:2601,State:1,Class:14
2025/11/16 1:01:30  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'+48538568280',@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”中插入重复键的行。重复键值为 (G19202737)。
语句已终止。
   在 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:6a6efa47-5e67-4ffb-ac93-1df8d0498fbe
Error Number:2601,State:1,Class:14
2025/11/16 5: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'696284717',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'GLS',@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”中插入重复键的行。重复键值为 (G19205619)。
语句已终止。
   在 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:635e4d1a-3002-432d-8c51-1fd6d900cdf2
Error Number:2601,State:1,Class:14
2025/11/16 6:00:04  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'00393511057553',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'Corriere Espresso',@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”中插入重复键。重复键值为 (F20251116162)。
语句已终止。
   在 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:89f7e742-7c71-4d36-9786-e9fce4f44148
Error Number:2627,State:1,Class:14
2025/11/16 6:01:38  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'+37064805170',@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”中插入重复键的行。重复键值为 (S2511152136903)。
语句已终止。
   在 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:89f7e742-7c71-4d36-9786-e9fce4f44148
Error Number:2601,State:1,Class:14