异常时间:2026-06-27 07:34:06,892 [34]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引1
共计【1】条
Update PackListInfo Set CertTime=@B01CertTime,CertName=@B01CertName,kfchtrue=@B01kfchtrue where 1=1 and CustomerCode=@WB01CustomerCode and ID=@WB01ID 2026/6/27 7:34:06,刘翱铭,4..3,SYDP,708347
System.Data.SqlClient.SqlException (0x80131904): 从数据类型 nvarchar 转换为 numeric 时出错。
在 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:df3fe179-711b-403c-875a-1ebfa275b016
Error Number:8114,State:5,Class:16
异常时间:2026-06-27 07:34:12,433 [38]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引1
共计【1】条
Update PackListInfo Set CertTime=@B01CertTime,CertName=@B01CertName,kfchtrue=@B01kfchtrue where 1=1 and CustomerCode=@WB01CustomerCode and ID=@WB01ID 2026/6/27 7:34:12,刘翱铭,4..3,SYDP,708347
System.Data.SqlClient.SqlException (0x80131904): 从数据类型 nvarchar 转换为 numeric 时出错。
在 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:df3fe179-711b-403c-875a-1ebfa275b016
Error Number:8114,State:5,Class:16
异常时间:2026-06-27 07:34:13,930 [38]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引1
共计【1】条
Update PackListInfo Set CertTime=@B01CertTime,CertName=@B01CertName,kfchtrue=@B01kfchtrue where 1=1 and CustomerCode=@WB01CustomerCode and ID=@WB01ID 2026/6/27 7:34:13,刘翱铭,4..3,SYDP,708347
System.Data.SqlClient.SqlException (0x80131904): 从数据类型 nvarchar 转换为 numeric 时出错。
在 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:df3fe179-711b-403c-875a-1ebfa275b016
Error Number:8114,State:5,Class:16
异常时间:2026-06-27 14:31:38,013 [34]
异常级别: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,,,311.00,0,1,,0,21546
Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,1194878
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/6/27 14:31:35,SYDP,郫都区鲜轩烧烤(和平街),311.00,SYDPGK15785,郫都区线路1,陈中美,RT2026062700009,RT20260627009
Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2026/6/27 14:31:35,311.00,1,王春凤,Y:数据一致,王春凤,2026/6/27 14:31:35,RT2026062700009
Insert Into WarehouseInTrueTicket(AddDate,TicTicketCode,Auditor1Time,ConvertTicketCode,TicketCode,Auditor1Note,RecordTime,TotalQty,Auditor1,TotalAmount,Auditor1Result,CustomerCode,TrueName,TicketType) Values (@URK5AddDate,@URK5TicTicketCode,@URK5Auditor1Time,@URK5ConvertTicketCode,@URK5TicketCode,@URK5Auditor1Note,@URK5RecordTime,@URK5TotalQty,@URK5Auditor1,@URK5TotalAmount,@URK5Auditor1Result,@URK5CustomerCode,@URK5TrueName,@URK5TicketType) 2026/6/27 14:31:35,RK20260627008,2026/6/27 14:31:35,RT2026062700009,RK2026062700008,采购自动复核[手机],2026/6/27 14:31:35,1,王春凤,0,Y:数据一致,SYDP,王春凤,退货入库
Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O0RK6Unit,@O0RK6GoodsCode,@O0RK6GoodsName,@O0RK6TicTicketCode,@O0RK6CagegoryID,@O0RK6ParentCagegoryName,@O0RK6ParentCagegoryID,@O0RK6StoreID,@O0RK6CategoryName,@O0RK6DictContent,@O0RK6Quantity,@O0RK6Amount,@O0RK6LotNumber,@O0RK6TicketCode) ,SYDP002971,换货差价,RK20260627008,SYDPEJ00206,其他,SYDPYJ00008,2,其他,无,1,0,20260627,RK2026062700008
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/6/27 14:31:35,2026/6/27 14:31:35,SYDP002971,换货差价,0,,27.000,无,RT2026062700009,311.000,王春凤,SYDP
System.Data.SqlClient.SqlException (0x80131904): 违反了 PRIMARY KEY 约束“PK_WarehouseInTrueTicket”。不能在对象“dbo.WarehouseInTrueTicket”中插入重复键。重复键值为 (RK2026062700008)。
语句已终止。
在 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:c84bc2d5-c1ca-4592-9c38-7c286b8edf85
Error Number:2627,State:1,Class:14