异常时间：2026-03-20 13:40:50,148 [23]
异常级别：WARN
异 常 类：logerror_sql [(null)]
错误索引10
共计【16】条
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,已退,,105.00,0,0,GYS0040,1,20233
Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,1086100
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,已退,,115.00,0,0,GYS0040,1,20234
Update WarehouseOutTicketDetail Set ReturnQuantity=@W14ReturnQuantity where 1=1 and ID=@WW14ID 1,1086101
Update WareHouseReturnTicketDetail Set CgXsFzNumNote=@Q25CgXsFzNumNote,CgRkNumNote=@Q25CgRkNumNote,SupplierName=@Q25SupplierName,CgXsFzNum=@Q25CgXsFzNum,CgTgNumNote=@Q25CgTgNumNote,CgBsNumNote=@Q25CgBsNumNote,DiscountAmount=@Q25DiscountAmount,CgBsNum=@Q25CgBsNum,CgRkNum=@Q25CgRkNum,SupplierNo=@Q25SupplierNo,CgTgNum=@Q25CgTgNum where 1=1 and ID=@WQ25ID ,,皓月水产,0,已退,,300.00,0,0,GYS0040,2,20235
Update WarehouseOutTicketDetail Set ReturnQuantity=@W26ReturnQuantity where 1=1 and ID=@WW26ID 2,1086102
Update WarehouseOutTicket Set TotalReturnAmount=@T7TotalReturnAmount,TotalMoney=@T7TotalMoney where 1=1 and TicketCode=@WT7TicketCode and CustomerCode=@WT7CustomerCode 520.00,1600.90,PS20260318314,SYDP
Update DeliverTicketCodeTotalFee Set ReturnMoney=@Y8ReturnMoney,BalanceMoney=@Y8BalanceMoney where 1=1 and CustomerCode=@WY8CustomerCode and ClientNo=@WY8ClientNo and TicketCode=@WY8TicketCode 520.00,1600.90,SYDP,SYDPGK20907,PS20260318314
Update WareHouseReturnTicket Set CgConTime=@E9CgConTime,TotalDiscountAmount=@E9TotalDiscountAmount,TotalQty=@E9TotalQty,CgConUser=@E9CgConUser,Auditor1Result=@E9Auditor1Result,Auditor1=@E9Auditor1,Auditor1Time=@E9Auditor1Time where 1=1 and TicketCodeTic=@WE9TicketCodeTic 2026/3/20 13:40:46,520.00,4,陈万强,Y：数据一致,陈万强,2026/3/20 13:40:46,RT2026032000008
Insert Into WarehouseInTrueTicket(AddDate,TicTicketCode,Auditor1Time,ConvertTicketCode,TicketCode,Auditor1Note,RecordTime,TotalQty,Auditor1,TotalAmount,Auditor1Result,CustomerCode,TrueName,TicketType) Values (@UTG10AddDate,@UTG10TicTicketCode,@UTG10Auditor1Time,@UTG10ConvertTicketCode,@UTG10TicketCode,@UTG10Auditor1Note,@UTG10RecordTime,@UTG10TotalQty,@UTG10Auditor1,@UTG10TotalAmount,@UTG10Auditor1Result,@UTG10CustomerCode,@UTG10TrueName,@UTG10TicketType) 2026/3/20 13:40:46,RK20260320012,2026/3/20 13:40:46,RT2026032000008,RK2026032000012,采购自动复核[手机],2026/3/20 13:40:46,4,陈万强,0,Y：数据一致,SYDP,陈万强,退货入库
Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O0TG11Unit,@O0TG11GoodsCode,@O0TG11GoodsName,@O0TG11TicTicketCode,@O0TG11CagegoryID,@O0TG11ParentCagegoryName,@O0TG11ParentCagegoryID,@O0TG11StoreID,@O0TG11CategoryName,@O0TG11DictContent,@O0TG11Quantity,@O0TG11Amount,@O0TG11LotNumber,@O0TG11TicketCode) ,SYDP001735,【皓月】黑千层A,RK20260320012,SYDPEJ00230,水发产品,SYDPYJ00019,5,水发牛副,2.5kg,1,0,20260320,RK2026032000012
Insert Into GoodsBuyBalancePriceInf(PriceTime,AddModifyTime,GoodsCode,GoodsName,LastNum,DictID,LastPrice,DictContent,RkTicketCode,BalancePrice,AddUserName,CustomerCode) Values (@S012PriceTime,@S012AddModifyTime,@S012GoodsCode,@S012GoodsName,@S012LastNum,@S012DictID,@S012LastPrice,@S012DictContent,@S012RkTicketCode,@S012BalancePrice,@S012AddUserName,@S012CustomerCode) 2026/3/20 13:40:46,2026/3/20 13:40:46,SYDP001735,【皓月】黑千层A,0,625,95.000,2.5kg,RT2026032000008,105.000,陈万强,SYDP
Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O1TG13Unit,@O1TG13GoodsCode,@O1TG13GoodsName,@O1TG13TicTicketCode,@O1TG13CagegoryID,@O1TG13ParentCagegoryName,@O1TG13ParentCagegoryID,@O1TG13StoreID,@O1TG13CategoryName,@O1TG13DictContent,@O1TG13Quantity,@O1TG13Amount,@O1TG13LotNumber,@O1TG13TicketCode) ,SYDP002003,【皓月】水煮白色精千层,RK20260320012,SYDPEJ00230,水发产品,SYDPYJ00019,5,水发牛副,2.5kg,1,0,20260320,RK2026032000012
Insert Into GoodsBuyBalancePriceInf(PriceTime,AddModifyTime,GoodsCode,GoodsName,LastNum,DictID,LastPrice,DictContent,RkTicketCode,BalancePrice,AddUserName,CustomerCode) Values (@S114PriceTime,@S114AddModifyTime,@S114GoodsCode,@S114GoodsName,@S114LastNum,@S114DictID,@S114LastPrice,@S114DictContent,@S114RkTicketCode,@S114BalancePrice,@S114AddUserName,@S114CustomerCode) 2026/3/20 13:40:46,2026/3/20 13:40:46,SYDP002003,【皓月】水煮白色精千层,0,625,110.000,2.5kg,RT2026032000008,115.000,陈万强,SYDP
Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O2TG15Unit,@O2TG15GoodsCode,@O2TG15GoodsName,@O2TG15TicTicketCode,@O2TG15CagegoryID,@O2TG15ParentCagegoryName,@O2TG15ParentCagegoryID,@O2TG15StoreID,@O2TG15CategoryName,@O2TG15DictContent,@O2TG15Quantity,@O2TG15Amount,@O2TG15LotNumber,@O2TG15TicketCode) ,SYDP004056,【皓月】水发大叶毛肚,RK20260320012,SYDPEJ00230,水发产品,SYDPYJ00019,5,水发牛副,2.5kg,2,0,20260320,RK2026032000012
Insert Into GoodsBuyBalancePriceInf(PriceTime,AddModifyTime,GoodsCode,GoodsName,LastNum,DictID,LastPrice,DictContent,RkTicketCode,BalancePrice,AddUserName,CustomerCode) Values (@S216PriceTime,@S216AddModifyTime,@S216GoodsCode,@S216GoodsName,@S216LastNum,@S216DictID,@S216LastPrice,@S216DictContent,@S216RkTicketCode,@S216BalancePrice,@S216AddUserName,@S216CustomerCode) 2026/3/20 13:40:46,2026/3/20 13:40:46,SYDP004056,【皓月】水发大叶毛肚,0,625,140.000,2.5kg,RT2026032000008,150.000,陈万强,SYDP
System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_WarehouseInTrueTicket”。不能在对象“dbo.WarehouseInTrueTicket”中插入重复键。重复键值为 (RK2026032000012)。
语句已终止。
在 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:c297f633-9ebf-46e3-b83b-a95e836c3bf2
Error Number:2627,State:1,Class:14