异常时间:2026-04-14 13:52:54,777 [33]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引5

共计【7】条

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,1,,224.000,0,0,GYS0162,0.8,20525

Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 0.8,1086310

Insert Into ReturnTicketInfFee(TicketType,AddDate,CustomerCode,ClientName,ReturnNeedMoney,ClientNo,ClientArea,ResponsiblePersonName,TicketCodeTic,TicketCode) Values (@R3TicketType,@R3AddDate,@R3CustomerCode,@R3ClientName,@R3ReturnNeedMoney,@R3ClientNo,@R3ClientArea,@R3ResponsiblePersonName,@R3TicketCodeTic,@R3TicketCode) 配送退货,2026/4/14 13:52:50,SYDP,温江钟勇红油拌菜,224.000,SYDPGK20795,温江,温琴琴,RT2026041000002,RT20260410002

Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2026/4/14 13:52:50,224.000,0.8,李静雯,Y:数据一致,李静雯,2026/4/14 13:52:50,RT2026041000002

Insert Into WarehouseInTrueTicket(AddDate,TicTicketCode,Auditor1Time,ConvertTicketCode,TicketCode,Auditor1Note,RecordTime,TotalQty,Auditor1,TotalAmount,Auditor1Result,CustomerCode,TrueName,TicketType) Values (@UTG5AddDate,@UTG5TicTicketCode,@UTG5Auditor1Time,@UTG5ConvertTicketCode,@UTG5TicketCode,@UTG5Auditor1Note,@UTG5RecordTime,@UTG5TotalQty,@UTG5Auditor1,@UTG5TotalAmount,@UTG5Auditor1Result,@UTG5CustomerCode,@UTG5TrueName,@UTG5TicketType) 2026/4/14 13:52:50,RK20260414003,2026/4/14 13:52:50,RT2026041000002,RK2026041400003,采购自动复核[手机],2026/4/14 13:52:50,0.8,李静雯,0,Y:数据一致,SYDP,李静雯,退货入库

Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O0TG6Unit,@O0TG6GoodsCode,@O0TG6GoodsName,@O0TG6TicTicketCode,@O0TG6CagegoryID,@O0TG6ParentCagegoryName,@O0TG6ParentCagegoryID,@O0TG6StoreID,@O0TG6CategoryName,@O0TG6DictContent,@O0TG6Quantity,@O0TG6Amount,@O0TG6LotNumber,@O0TG6TicketCode) ,SYDP008233,【港之蓉】全熟白味猪蹄粒,RK20260414003,SYDPEJ00134,猪产品,SYDPYJ00014,5,猪蹄,0.5kg*10,0.8,0,20260414,RK2026041400003

Insert Into GoodsBuyBalancePriceInf(PriceTime,AddModifyTime,GoodsCode,GoodsName,LastNum,DictID,LastPrice,DictContent,RkTicketCode,BalancePrice,AddUserName,CustomerCode) Values (@S07PriceTime,@S07AddModifyTime,@S07GoodsCode,@S07GoodsName,@S07LastNum,@S07DictID,@S07LastPrice,@S07DictContent,@S07RkTicketCode,@S07BalancePrice,@S07AddUserName,@S07CustomerCode) 2026/4/14 13:52:50,2026/4/14 13:52:50,SYDP008233,【港之蓉】全熟白味猪蹄粒,0,,260.000,0.5kg*10,RT2026041000002,280.00,李静雯,SYDP



System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_WarehouseInTrueTicket”。不能在对象“dbo.WarehouseInTrueTicket”中插入重复键。重复键值为 (RK2026041400003)。 语句已终止。 在 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:acaea675-4d94-4e4f-af08-5f9b194fe05e Error Number:2627,State:1,Class:14