异常时间：2025-12-10 14:52:00,518 [54]
异常级别：WARN
异 常 类：logerror_sql [(null)]
错误索引12
共计【20】条
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,,,347.00,0,1,,0,18970
Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,977366
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,,,310.00,0,1,,0,18971
Update WarehouseOutTicketDetail Set ReturnQuantity=@W14ReturnQuantity where 1=1 and ID=@WW14ID 1,977370
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,,,310.00,0,1,,0,18972
Update WarehouseOutTicketDetail Set ReturnQuantity=@W26ReturnQuantity where 1=1 and ID=@WW26ID 1,977372
Update WareHouseReturnTicketDetail Set CgXsFzNumNote=@Q37CgXsFzNumNote,CgRkNumNote=@Q37CgRkNumNote,SupplierName=@Q37SupplierName,CgXsFzNum=@Q37CgXsFzNum,CgTgNumNote=@Q37CgTgNumNote,CgBsNumNote=@Q37CgBsNumNote,DiscountAmount=@Q37DiscountAmount,CgBsNum=@Q37CgBsNum,CgRkNum=@Q37CgRkNum,SupplierNo=@Q37SupplierNo,CgTgNum=@Q37CgTgNum where 1=1 and ID=@WQ37ID ,,,0,,,205.00,0,1,,0,18973
Update WarehouseOutTicketDetail Set ReturnQuantity=@W38ReturnQuantity where 1=1 and ID=@WW38ID 1,977373
Update WarehouseOutTicket Set TotalReturnAmount=@T9TotalReturnAmount,TotalMoney=@T9TotalMoney where 1=1 and TicketCode=@WT9TicketCode and CustomerCode=@WT9CustomerCode 1172.00,795.50,PS20251113330,SYDP
Update DeliverTicketCodeTotalFee Set ReturnMoney=@Y10ReturnMoney,BalanceMoney=@Y10BalanceMoney where 1=1 and CustomerCode=@WY10CustomerCode and ClientNo=@WY10ClientNo and TicketCode=@WY10TicketCode 1172.00,795.00,SYDP,SYDPGK19857,PS20251113330
Update WareHouseReturnTicket Set CgConTime=@E11CgConTime,TotalDiscountAmount=@E11TotalDiscountAmount,TotalQty=@E11TotalQty,CgConUser=@E11CgConUser,Auditor1Result=@E11Auditor1Result,Auditor1=@E11Auditor1,Auditor1Time=@E11Auditor1Time where 1=1 and TicketCodeTic=@WE11TicketCodeTic 2025/12/10 14:51:56,1172.00,4,杨洋,Y：数据一致,杨洋,2025/12/10 14:51:56,RT2025111300007
Insert Into WarehouseInTrueTicket(AddDate,TicTicketCode,Auditor1Time,ConvertTicketCode,TicketCode,Auditor1Note,RecordTime,TotalQty,Auditor1,TotalAmount,Auditor1Result,CustomerCode,TrueName,TicketType) Values (@URK12AddDate,@URK12TicTicketCode,@URK12Auditor1Time,@URK12ConvertTicketCode,@URK12TicketCode,@URK12Auditor1Note,@URK12RecordTime,@URK12TotalQty,@URK12Auditor1,@URK12TotalAmount,@URK12Auditor1Result,@URK12CustomerCode,@URK12TrueName,@URK12TicketType) 2025/12/10 14:51:56,RK20251210013,2025/12/10 14:51:56,RT2025111300007,RK2025121000013,采购自动复核[手机],2025/12/10 14:51:56,4,杨洋,0,Y：数据一致,SYDP,杨洋,退货入库
Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O0RK13Unit,@O0RK13GoodsCode,@O0RK13GoodsName,@O0RK13TicTicketCode,@O0RK13CagegoryID,@O0RK13ParentCagegoryName,@O0RK13ParentCagegoryID,@O0RK13StoreID,@O0RK13CategoryName,@O0RK13DictContent,@O0RK13Quantity,@O0RK13Amount,@O0RK13LotNumber,@O0RK13TicketCode) ,SYDP003804,【中佳】单冻凤爪（30-35g）紫花,RK20251210013,SYDPEJ00047,鸡产品,SYDPYJ00005,2,鸡爪,9.5kg,1,0,20251210,RK2025121000013
Insert Into GoodsBuyBalancePriceInf(PriceTime,AddModifyTime,GoodsCode,GoodsName,LastNum,DictID,LastPrice,DictContent,RkTicketCode,BalancePrice,AddUserName,CustomerCode) Values (@S014PriceTime,@S014AddModifyTime,@S014GoodsCode,@S014GoodsName,@S014LastNum,@S014DictID,@S014LastPrice,@S014DictContent,@S014RkTicketCode,@S014BalancePrice,@S014AddUserName,@S014CustomerCode) 2025/12/10 14:51:56,2025/12/10 14:51:56,SYDP003804,【中佳】单冻凤爪（30-35g）紫花,0,19,340.000,9.5kg,RT2025111300007,347.000,杨洋,SYDP
Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O1RK15Unit,@O1RK15GoodsCode,@O1RK15GoodsName,@O1RK15TicTicketCode,@O1RK15CagegoryID,@O1RK15ParentCagegoryName,@O1RK15ParentCagegoryID,@O1RK15StoreID,@O1RK15CategoryName,@O1RK15DictContent,@O1RK15Quantity,@O1RK15Amount,@O1RK15LotNumber,@O1RK15TicketCode) ,SYDP000200,兔腰（兔肾）,RK20251210013,SYDPEJ00092,兔产品,SYDPYJ00011,2,兔副产品,10kg/件,1,0,20251210,RK2025121000013
Insert Into GoodsBuyBalancePriceInf(PriceTime,AddModifyTime,GoodsCode,GoodsName,LastNum,DictID,LastPrice,DictContent,RkTicketCode,BalancePrice,AddUserName,CustomerCode) Values (@S116PriceTime,@S116AddModifyTime,@S116GoodsCode,@S116GoodsName,@S116LastNum,@S116DictID,@S116LastPrice,@S116DictContent,@S116RkTicketCode,@S116BalancePrice,@S116AddUserName,@S116CustomerCode) 2025/12/10 14:51:56,2025/12/10 14:51:56,SYDP000200,兔腰（兔肾）,0,153,270.000,10kg/件,RT2025111300007,310.000,杨洋,SYDP
Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O2RK17Unit,@O2RK17GoodsCode,@O2RK17GoodsName,@O2RK17TicTicketCode,@O2RK17CagegoryID,@O2RK17ParentCagegoryName,@O2RK17ParentCagegoryID,@O2RK17StoreID,@O2RK17CategoryName,@O2RK17DictContent,@O2RK17Quantity,@O2RK17Amount,@O2RK17LotNumber,@O2RK17TicketCode) ,SYDP004530,【昊明】鸡脚筋/凤凰筋,RK20251210013,SYDPEJ00040,鸡产品,SYDPYJ00005,2,鸡副产,1kg*10,1,0,20251210,RK2025121000013
Insert Into GoodsBuyBalancePriceInf(PriceTime,AddModifyTime,GoodsCode,GoodsName,LastNum,DictID,LastPrice,DictContent,RkTicketCode,BalancePrice,AddUserName,CustomerCode) Values (@S218PriceTime,@S218AddModifyTime,@S218GoodsCode,@S218GoodsName,@S218LastNum,@S218DictID,@S218LastPrice,@S218DictContent,@S218RkTicketCode,@S218BalancePrice,@S218AddUserName,@S218CustomerCode) 2025/12/10 14:51:56,2025/12/10 14:51:56,SYDP004530,【昊明】鸡脚筋/凤凰筋,0,2144,288.000,1kg*10,RT2025111300007,310.000,杨洋,SYDP
Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O3RK19Unit,@O3RK19GoodsCode,@O3RK19GoodsName,@O3RK19TicTicketCode,@O3RK19CagegoryID,@O3RK19ParentCagegoryName,@O3RK19ParentCagegoryID,@O3RK19StoreID,@O3RK19CategoryName,@O3RK19DictContent,@O3RK19Quantity,@O3RK19Amount,@O3RK19LotNumber,@O3RK19TicketCode) ,SYDP007889,【雅士享】鸭食管/鸭食带,RK20251210013,SYDPEJ00114,鸭产品,SYDPYJ00012,2,鸭副产,1kg*12袋,1,0,20251210,RK2025121000013
Insert Into GoodsBuyBalancePriceInf(PriceTime,AddModifyTime,GoodsCode,GoodsName,LastNum,DictID,LastPrice,DictContent,RkTicketCode,BalancePrice,AddUserName,CustomerCode) Values (@S320PriceTime,@S320AddModifyTime,@S320GoodsCode,@S320GoodsName,@S320LastNum,@S320DictID,@S320LastPrice,@S320DictContent,@S320RkTicketCode,@S320BalancePrice,@S320AddUserName,@S320CustomerCode) 2025/12/10 14:51:56,2025/12/10 14:51:56,SYDP007889,【雅士享】鸭食管/鸭食带,0,2116,200.000,1kg*12袋,RT2025111300007,205.000,杨洋,SYDP
System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_WarehouseInTrueTicket”。不能在对象“dbo.WarehouseInTrueTicket”中插入重复键。重复键值为 (RK2025121000013)。
语句已终止。
在 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:d7561a09-896b-478d-aae0-9a4c6da39461
Error Number:2627,State:1,Class:14