异常时间:2026-03-24 14:33:13,261 [56]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引6
共计【8】条
Update WareHouseReturnTicketDetail Set CgXsFzNumNote=@Q01CgXsFzNumNote,CgRkNumNote=@Q01CgRkNumNote,SupplierName=@Q01SupplierName,CgXsFzNum=@Q01CgXsFzNum,CgTgNumNote=@Q01CgTgNumNote,CgBsNumNote=@Q01CgBsNumNote,DiscountAmount=@Q01DiscountAmount,CgBsNum=@Q01CgBsNum,CgRkNum=@Q01CgRkNum,SupplierNo=@Q01SupplierNo,CgTgNum=@Q01CgTgNum where 1=1 and ID=@WQ01ID ,,,0,,,226.00,0,1,,0,20246
Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,1086885
Update WarehouseOutTicket Set TotalReturnAmount=@T3TotalReturnAmount,TotalMoney=@T3TotalMoney where 1=1 and TicketCode=@WT3TicketCode and CustomerCode=@WT3CustomerCode 226.00,783.00,PS20260319254,SYDP
Update DeliverTicketCodeTotalFee Set ReturnMoney=@Y4ReturnMoney,BalanceMoney=@Y4BalanceMoney where 1=1 and CustomerCode=@WY4CustomerCode and ClientNo=@WY4ClientNo and TicketCode=@WY4TicketCode 226.00,0.00,SYDP,SYDPGK17874,PS20260319254
Update WareHouseReturnTicket Set CgConTime=@E5CgConTime,TotalDiscountAmount=@E5TotalDiscountAmount,TotalQty=@E5TotalQty,CgConUser=@E5CgConUser,Auditor1Result=@E5Auditor1Result,Auditor1=@E5Auditor1,Auditor1Time=@E5Auditor1Time where 1=1 and TicketCodeTic=@WE5TicketCodeTic 2026/3/24 14:33:01,226.00,1,栾海威,Y:数据一致,栾海威,2026/3/24 14:33:01,RT2026032000018
Insert Into WarehouseInTrueTicket(AddDate,TicTicketCode,Auditor1Time,ConvertTicketCode,TicketCode,Auditor1Note,RecordTime,TotalQty,Auditor1,TotalAmount,Auditor1Result,CustomerCode,TrueName,TicketType) Values (@URK6AddDate,@URK6TicTicketCode,@URK6Auditor1Time,@URK6ConvertTicketCode,@URK6TicketCode,@URK6Auditor1Note,@URK6RecordTime,@URK6TotalQty,@URK6Auditor1,@URK6TotalAmount,@URK6Auditor1Result,@URK6CustomerCode,@URK6TrueName,@URK6TicketType) 2026/3/24 14:33:01,RK20260324017,2026/3/24 14:33:01,RT2026032000018,RK2026032400017,采购自动复核[手机],2026/3/24 14:33:01,1,栾海威,0,Y:数据一致,SYDP,栾海威,退货入库
Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O0RK7Unit,@O0RK7GoodsCode,@O0RK7GoodsName,@O0RK7TicTicketCode,@O0RK7CagegoryID,@O0RK7ParentCagegoryName,@O0RK7ParentCagegoryID,@O0RK7StoreID,@O0RK7CategoryName,@O0RK7DictContent,@O0RK7Quantity,@O0RK7Amount,@O0RK7LotNumber,@O0RK7TicketCode) ,SYDP003053,【荣旺】鸭肫(M肫),RK20260324017,SYDPEJ00114,鸭产品,SYDPYJ00012,2,鸭副产,1kg*12袋,1,0,20260324,RK2026032400017
Insert Into GoodsBuyBalancePriceInf(PriceTime,AddModifyTime,GoodsCode,GoodsName,LastNum,DictID,LastPrice,DictContent,RkTicketCode,BalancePrice,AddUserName,CustomerCode) Values (@S08PriceTime,@S08AddModifyTime,@S08GoodsCode,@S08GoodsName,@S08LastNum,@S08DictID,@S08LastPrice,@S08DictContent,@S08RkTicketCode,@S08BalancePrice,@S08AddUserName,@S08CustomerCode) 2026/3/24 14:33:01,2026/3/24 14:33:01,SYDP003053,【荣旺】鸭肫(M肫),0,2116,222.000,1kg*12袋,RT2026032000018,226.000,栾海威,SYDP
System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_WarehouseInTrueTicket”。不能在对象“dbo.WarehouseInTrueTicket”中插入重复键。重复键值为 (RK2026032400017)。
语句已终止。
在 System.Data.SqlClient.SqlConnection.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()
在 MySqlDAL.MySqlHelper.ExecuteTransSqlPar(IList`1 SqlList) 位置 D:\WorkSpaceByXbx\冷链供应链正式库\溯源冻品网正式版\gylErpWebservice2023-09-12\MySqlDAL\Tools\MySqlHelper.cs:行号 281
ClientConnectionId:b330e2df-47b0-4ba5-980e-7b39d1c2e369
Error Number:2627,State:1,Class:14