异常时间：2026-05-26 10:28:01,989 [53]
异常级别：WARN
异 常 类：logerror_sql [(null)]
错误索引8
共计【12】条
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,2323,,75.00,0,0,GYS0053,1,21124
Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,1149408
Update WareHouseReturnTicketDetail Set CgXsFzNumNote=@Q13CgXsFzNumNote,CgRkNumNote=@Q13CgRkNumNote,SupplierName=@Q13SupplierName,CgXsFzNum=@Q13CgXsFzNum,CgTgNumNote=@Q13CgTgNumNote,CgBsNumNote=@Q13CgBsNumNote,DiscountAmount=@Q13DiscountAmount,CgBsNum=@Q13CgBsNum,CgRkNum=@Q13CgRkNum,SupplierNo=@Q13SupplierNo,CgTgNum=@Q13CgTgNum where 1=1 and ID=@WQ13ID ,,冯氏海鲜,0,ddd,,70.00,0,0,GYS0053,2,21125
Update WarehouseOutTicketDetail Set ReturnQuantity=@W14ReturnQuantity where 1=1 and ID=@WW14ID 2,1149409
Update WarehouseOutTicket Set TotalReturnAmount=@T5TotalReturnAmount,TotalMoney=@T5TotalMoney where 1=1 and TicketCode=@WT5TicketCode and CustomerCode=@WT5CustomerCode 145.00,91.00,PS20260516446,SYDP
Update DeliverTicketCodeTotalFee Set ReturnMoney=@Y6ReturnMoney,BalanceMoney=@Y6BalanceMoney where 1=1 and CustomerCode=@WY6CustomerCode and ClientNo=@WY6ClientNo and TicketCode=@WY6TicketCode 145.00,91.00,SYDP,SYDPGK12821,PS20260516446
Update WareHouseReturnTicket Set CgConTime=@E7CgConTime,TotalDiscountAmount=@E7TotalDiscountAmount,TotalQty=@E7TotalQty,CgConUser=@E7CgConUser,Auditor1Result=@E7Auditor1Result,Auditor1=@E7Auditor1,Auditor1Time=@E7Auditor1Time where 1=1 and TicketCodeTic=@WE7TicketCodeTic 2026/5/26 10:27:54,145.00,3,李静雯,Y：数据一致,李静雯,2026/5/26 10:27:54,RT2026052200007
Insert Into WarehouseInTrueTicket(AddDate,TicTicketCode,Auditor1Time,ConvertTicketCode,TicketCode,Auditor1Note,RecordTime,TotalQty,Auditor1,TotalAmount,Auditor1Result,CustomerCode,TrueName,TicketType) Values (@UTG8AddDate,@UTG8TicTicketCode,@UTG8Auditor1Time,@UTG8ConvertTicketCode,@UTG8TicketCode,@UTG8Auditor1Note,@UTG8RecordTime,@UTG8TotalQty,@UTG8Auditor1,@UTG8TotalAmount,@UTG8Auditor1Result,@UTG8CustomerCode,@UTG8TrueName,@UTG8TicketType) 2026/5/26 10:27:54,RK20260526008,2026/5/26 10:27:54,RT2026052200007,RK2026052600008,采购自动复核[手机],2026/5/26 10:27:54,3,李静雯,0,Y：数据一致,SYDP,李静雯,退货入库
Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O0TG9Unit,@O0TG9GoodsCode,@O0TG9GoodsName,@O0TG9TicTicketCode,@O0TG9CagegoryID,@O0TG9ParentCagegoryName,@O0TG9ParentCagegoryID,@O0TG9StoreID,@O0TG9CategoryName,@O0TG9DictContent,@O0TG9Quantity,@O0TG9Amount,@O0TG9LotNumber,@O0TG9TicketCode) ,SYDP002922,【享口福】黑糖糍粑,RK20260526008,SYDPEJ00239,油炸小吃,SYDPYJ00021,5,小吃面点,320g*10根*20袋,1,0,20260526,RK2026052600008
Insert Into GoodsBuyBalancePriceInf(PriceTime,AddModifyTime,GoodsCode,GoodsName,LastNum,DictID,LastPrice,DictContent,RkTicketCode,BalancePrice,AddUserName,CustomerCode) Values (@S010PriceTime,@S010AddModifyTime,@S010GoodsCode,@S010GoodsName,@S010LastNum,@S010DictID,@S010LastPrice,@S010DictContent,@S010RkTicketCode,@S010BalancePrice,@S010AddUserName,@S010CustomerCode) 2026/5/26 10:27:54,2026/5/26 10:27:54,SYDP002922,【享口福】黑糖糍粑,0,,70.000,320g*10根*20袋,RT2026052200007,75.000,李静雯,SYDP
Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O1TG11Unit,@O1TG11GoodsCode,@O1TG11GoodsName,@O1TG11TicTicketCode,@O1TG11CagegoryID,@O1TG11ParentCagegoryName,@O1TG11ParentCagegoryID,@O1TG11StoreID,@O1TG11CategoryName,@O1TG11DictContent,@O1TG11Quantity,@O1TG11Amount,@O1TG11LotNumber,@O1TG11TicketCode) ,SYDP000367,【享口福】南瓜饼,RK20260526008,SYDPEJ00239,油炸小吃,SYDPYJ00021,5,小吃面点,180g×20袋/件,2,0,20260526,RK2026052600008
Insert Into GoodsBuyBalancePriceInf(PriceTime,AddModifyTime,GoodsCode,GoodsName,LastNum,DictID,LastPrice,DictContent,RkTicketCode,BalancePrice,AddUserName,CustomerCode) Values (@S112PriceTime,@S112AddModifyTime,@S112GoodsCode,@S112GoodsName,@S112LastNum,@S112DictID,@S112LastPrice,@S112DictContent,@S112RkTicketCode,@S112BalancePrice,@S112AddUserName,@S112CustomerCode) 2026/5/26 10:27:54,2026/5/26 10:27:54,SYDP000367,【享口福】南瓜饼,0,216,27.362,180g×20袋/件,RT2026052200007,35.000,李静雯,SYDP
System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_WarehouseInTrueTicket”。不能在对象“dbo.WarehouseInTrueTicket”中插入重复键。重复键值为 (RK2026052600008)。
语句已终止。
在 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:73433c5e-cd82-4c89-add2-746ccb8f1bb1
Error Number:2627,State:1,Class:14