2025/5/5 0:01:21  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'881230967',@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”中插入重复键的行。重复键值为 (G15207945)。
语句已终止。
   在 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:416a0875-9683-46ee-bcbd-d987e285e1af
Error Number:2601,State:1,Class:14
2025/5/5 1:01: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'602726520',@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”中插入重复键的行。重复键值为 (G15214525)。
语句已终止。
   在 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:60a95144-ea7f-4beb-b1d9-5db35847f402
Error Number:2601,State:1,Class:14
2025/5/5 7:00:00  sql:delete from PDSYS..RecordProductReplace where InfoID in (
select pr.InfoID 
from PDSYS..RecordProductReplace pr
inner join SinadealTradeDB..FMS_Package p on p.PackageID=pr.InfoID
where p.Coids='F20250505750' and p.WmsState<>'5' and pr.[status] <> 1
)
错误信息：System.Data.SqlClient.SqlException (0x80131904): 无法继续执行，因为会话处于终止状态。
当前命令发生了严重错误。应放弃任何可能产生的结果。
   在 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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   在 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:29142625-0bc3-4947-9d1c-442df237621f
Error Number:596,State:1,Class:21
2025/5/5 18:00: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'491621363309',@CFax,@ShipVia,@Spec,@TransactionNumber,@MangoFlag,@MangoNumber,@StateTime,@Stock,@Itemtype,@TotalCost,@ShipCost,@TotalWeight,0,@FreightSide,N'EU-Express2',@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”中插入重复键。重复键值为 (F202505052488)。
语句已终止。
   在 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:2b9e9245-9a72-43b0-bda2-f6e90f8effc2
Error Number:2627,State:1,Class:14