异常时间：2025-07-29 06:00:07,090 [69]
异常级别：WARN
异 常 类：logerror_sql [(null)]
错误索引1
共计【5】条
Insert Into WarehouseOutTicket(OrderAcount,AddDate,TotalServiceCharge,StoreNo,ClientArea,TrueName,TicketType,TotalQty,IsPay,RecordTime,TotalTrueServiceCharge,TotalDiscountAmount,TotalMoney,BalanceOffsetMoney,ClientName,ResponsiblePersonName,DeductionVolumeMoney,TicketCode,OrderTicketTime,Address,TotalReturnAmount,Note,PackTicketCode,ConvertAddDate,CustomerCode,TotalSaleAmount,ClientNo,OrderTicket) Values (@330OrderAcount,@330AddDate,@330TotalServiceCharge,@330StoreNo,@330ClientArea,@330TrueName,@330TicketType,@330TotalQty,@330IsPay,@330RecordTime,@330TotalTrueServiceCharge,@330TotalDiscountAmount,@330TotalMoney,@330BalanceOffsetMoney,@330ClientName,@330ResponsiblePersonName,@330DeductionVolumeMoney,@330TicketCode,@330OrderTicketTime,@330Address,@330TotalReturnAmount,@330Note,@330PackTicketCode,@330ConvertAddDate,@330CustomerCode,@330TotalSaleAmount,@330ClientNo,@330OrderTicket) liudan,2025/7/29 6:00:00,0.00,SYDPGK01629S001,锦江,栾海威,销售代下单,1.000,,2025/7/29 6:00:07,13.00,265.00,252.00,0.00,锦江味之绝（华熙528店）,刘丹,0.00,PS20250729041,2025/7/28 21:37:08,锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
,0,,PG20250729001,2025/7/29 0:00:00,SYDP,265.00,SYDPGK01629,XS202507280278
Insert Into DeliverTicketCodeTotalFee(TelNo,ClientName,ReturnMoney,TotalSalePrice,ModTotalMoney,TotalDiscountAmount,OrderTicket,ResponsiblePersonName,BalanceOffsetMoney,TicketCodeDate,ClientArea,OrderTicketTime,AddPerson,DeductionVolumeMoney,ClientNo,PackTicketCode,AddDate,TicketType,TotalTrueMoney,BalanceMoney,TicketCode,CustomerCode,OldTotalDiscountAmount,Address) Values (@331TelNo,@331ClientName,@331ReturnMoney,@331TotalSalePrice,@331ModTotalMoney,@331TotalDiscountAmount,@331OrderTicket,@331ResponsiblePersonName,@331BalanceOffsetMoney,@331TicketCodeDate,@331ClientArea,@331OrderTicketTime,@331AddPerson,@331DeductionVolumeMoney,@331ClientNo,@331PackTicketCode,@331AddDate,@331TicketType,@331TotalTrueMoney,@331BalanceMoney,@331TicketCode,@331CustomerCode,@331OldTotalDiscountAmount,@331Address) 13882234510,锦江味之绝（华熙528店）,0,265.00,252.00,252.00,XS202507280278,刘丹,0.00,2025/7/29 6:00:00,锦江,2025/7/28 21:37:08,栾海威,0.00,SYDPGK01629,PG20250729001,2025/7/29 6:00:00,销售代下单,0,252.00,PS20250729041,SYDP,252.00,锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
Insert Into PackTicketRelationInfo(OrderTicketCode,CustomerCode,CKTicketCode,PackTicketCode) Values (@332OrderTicketCode,@332CustomerCode,@332CKTicketCode,@332PackTicketCode) XS202507280278,SYDP,PS20250729041,PG20250729001
Insert Into WarehouseOutTicketDetail(SaleAmount,SpecificationID,ConvetQty,GoodsCode,GoodsName,CagegoryID,ParentCagegoryName,ParentCagegoryID,IsAuto,CategoryName,DictContent,TrueQuantity,SalePrice,ReturnQuantity,Quantity,Buyprice,DiscountAmount,TicketCode,Note,DiscountPrice) Values (@333SaleAmount,@333SpecificationID,@333ConvetQty,@333GoodsCode,@333GoodsName,@333CagegoryID,@333ParentCagegoryName,@333ParentCagegoryID,@333IsAuto,@333CategoryName,@333DictContent,@333TrueQuantity,@333SalePrice,@333ReturnQuantity,@333Quantity,@333Buyprice,@333DiscountAmount,@333TicketCode,@333Note,@333DiscountPrice) 265.00,4575,1.000,SYDP006381,【海石丽人】特干耗儿鱼（50/100）,SYDPEJ00030,海鲜水产,SYDPYJ00004,是,耗儿鱼/马面鱼系列,4.5KG/,0,265.00,0,1.000,235.00,265.00,PS20250729041,,265.00
Update WareHouseOrderTicket Set PackTicketCode=@334PackTicketCode,State=@334State where 1=1 and TicketCode=@W334TicketCode PG20250729001,已处理,XS202507280278
System.Data.SqlClient.SqlException (0x80131904): 将截断字符串或二进制数据。
语句已终止。
在 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:cf0f26dd-2ece-4439-bd0b-2e36b74022f0
Error Number:8152,State:13,Class:16
异常时间：2025-07-29 06:21:31,081 [78]
异常级别：WARN
异 常 类：logerror_sql [(null)]
错误索引1
共计【5】条
Insert Into WarehouseOutTicket(OrderAcount,AddDate,TotalServiceCharge,StoreNo,ClientArea,TrueName,TicketType,TotalQty,IsPay,RecordTime,TotalTrueServiceCharge,TotalDiscountAmount,TotalMoney,BalanceOffsetMoney,ClientName,ResponsiblePersonName,DeductionVolumeMoney,TicketCode,OrderTicketTime,Address,TotalReturnAmount,Note,PackTicketCode,ConvertAddDate,CustomerCode,TotalSaleAmount,ClientNo,OrderTicket) Values (@31OrderAcount,@31AddDate,@31TotalServiceCharge,@31StoreNo,@31ClientArea,@31TrueName,@31TicketType,@31TotalQty,@31IsPay,@31RecordTime,@31TotalTrueServiceCharge,@31TotalDiscountAmount,@31TotalMoney,@31BalanceOffsetMoney,@31ClientName,@31ResponsiblePersonName,@31DeductionVolumeMoney,@31TicketCode,@31OrderTicketTime,@31Address,@31TotalReturnAmount,@31Note,@31PackTicketCode,@31ConvertAddDate,@31CustomerCode,@31TotalSaleAmount,@31ClientNo,@31OrderTicket) liudan,2025/7/29 6:21:30,0.00,SYDPGK01629S001,锦江,栾海威,销售代下单,1.000,,2025/7/29 6:21:31,13.00,265.00,252.00,0.00,锦江味之绝（华熙528店）,刘丹,0.00,PS20250729332,2025/7/28 21:37:08,锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
,0,,PG20250729002,2025/7/29 0:00:00,SYDP,265.00,SYDPGK01629,XS202507280278
Insert Into DeliverTicketCodeTotalFee(TelNo,ClientName,ReturnMoney,TotalSalePrice,ModTotalMoney,TotalDiscountAmount,OrderTicket,ResponsiblePersonName,BalanceOffsetMoney,TicketCodeDate,ClientArea,OrderTicketTime,AddPerson,DeductionVolumeMoney,ClientNo,PackTicketCode,AddDate,TicketType,TotalTrueMoney,BalanceMoney,TicketCode,CustomerCode,OldTotalDiscountAmount,Address) Values (@32TelNo,@32ClientName,@32ReturnMoney,@32TotalSalePrice,@32ModTotalMoney,@32TotalDiscountAmount,@32OrderTicket,@32ResponsiblePersonName,@32BalanceOffsetMoney,@32TicketCodeDate,@32ClientArea,@32OrderTicketTime,@32AddPerson,@32DeductionVolumeMoney,@32ClientNo,@32PackTicketCode,@32AddDate,@32TicketType,@32TotalTrueMoney,@32BalanceMoney,@32TicketCode,@32CustomerCode,@32OldTotalDiscountAmount,@32Address) 13882234510,锦江味之绝（华熙528店）,0,265.00,252.00,252.00,XS202507280278,刘丹,0.00,2025/7/29 6:21:30,锦江,2025/7/28 21:37:08,栾海威,0.00,SYDPGK01629,PG20250729002,2025/7/29 6:21:30,销售代下单,0,252.00,PS20250729332,SYDP,252.00,锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
Insert Into PackTicketRelationInfo(OrderTicketCode,CustomerCode,CKTicketCode,PackTicketCode) Values (@33OrderTicketCode,@33CustomerCode,@33CKTicketCode,@33PackTicketCode) XS202507280278,SYDP,PS20250729332,PG20250729002
Insert Into WarehouseOutTicketDetail(SaleAmount,SpecificationID,ConvetQty,GoodsCode,GoodsName,CagegoryID,ParentCagegoryName,ParentCagegoryID,IsAuto,CategoryName,DictContent,TrueQuantity,SalePrice,ReturnQuantity,Quantity,Buyprice,DiscountAmount,TicketCode,Note,DiscountPrice) Values (@34SaleAmount,@34SpecificationID,@34ConvetQty,@34GoodsCode,@34GoodsName,@34CagegoryID,@34ParentCagegoryName,@34ParentCagegoryID,@34IsAuto,@34CategoryName,@34DictContent,@34TrueQuantity,@34SalePrice,@34ReturnQuantity,@34Quantity,@34Buyprice,@34DiscountAmount,@34TicketCode,@34Note,@34DiscountPrice) 265.00,4575,1.000,SYDP006381,【海石丽人】特干耗儿鱼（50/100）,SYDPEJ00030,海鲜水产,SYDPYJ00004,是,耗儿鱼/马面鱼系列,4.5KG/,0,265.00,0,1.000,235.00,265.00,PS20250729332,,265.00
Update WareHouseOrderTicket Set PackTicketCode=@35PackTicketCode,State=@35State where 1=1 and TicketCode=@W35TicketCode PG20250729002,已处理,XS202507280278
System.Data.SqlClient.SqlException (0x80131904): 将截断字符串或二进制数据。
语句已终止。
在 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:6392c46a-c321-4543-8cb3-b3f362a2a8d6
Error Number:8152,State:13,Class:16
异常时间：2025-07-29 06:51:03,225 [71]
异常级别：WARN
异 常 类：logerror_sql [(null)]
错误索引1
共计【5】条
Insert Into WarehouseOutTicket(OrderAcount,AddDate,TotalServiceCharge,StoreNo,ClientArea,TrueName,TicketType,TotalQty,IsPay,RecordTime,TotalTrueServiceCharge,TotalDiscountAmount,TotalMoney,BalanceOffsetMoney,ClientName,ResponsiblePersonName,DeductionVolumeMoney,TicketCode,OrderTicketTime,Address,TotalReturnAmount,Note,PackTicketCode,ConvertAddDate,CustomerCode,TotalSaleAmount,ClientNo,OrderTicket) Values (@32OrderAcount,@32AddDate,@32TotalServiceCharge,@32StoreNo,@32ClientArea,@32TrueName,@32TicketType,@32TotalQty,@32IsPay,@32RecordTime,@32TotalTrueServiceCharge,@32TotalDiscountAmount,@32TotalMoney,@32BalanceOffsetMoney,@32ClientName,@32ResponsiblePersonName,@32DeductionVolumeMoney,@32TicketCode,@32OrderTicketTime,@32Address,@32TotalReturnAmount,@32Note,@32PackTicketCode,@32ConvertAddDate,@32CustomerCode,@32TotalSaleAmount,@32ClientNo,@32OrderTicket) liudan,2025/7/29 6:51:02,0.00,SYDPGK01629S001,锦江,栾海威,销售代下单,1.000,,2025/7/29 6:51:03,13.00,265.00,252.00,0.00,锦江味之绝（华熙528店）,刘丹,0.00,PS20250729339,2025/7/28 21:37:08,锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
,0,,PG20250729003,2025/7/29 0:00:00,SYDP,265.00,SYDPGK01629,XS202507280278
Insert Into DeliverTicketCodeTotalFee(TelNo,ClientName,ReturnMoney,TotalSalePrice,ModTotalMoney,TotalDiscountAmount,OrderTicket,ResponsiblePersonName,BalanceOffsetMoney,TicketCodeDate,ClientArea,OrderTicketTime,AddPerson,DeductionVolumeMoney,ClientNo,PackTicketCode,AddDate,TicketType,TotalTrueMoney,BalanceMoney,TicketCode,CustomerCode,OldTotalDiscountAmount,Address) Values (@33TelNo,@33ClientName,@33ReturnMoney,@33TotalSalePrice,@33ModTotalMoney,@33TotalDiscountAmount,@33OrderTicket,@33ResponsiblePersonName,@33BalanceOffsetMoney,@33TicketCodeDate,@33ClientArea,@33OrderTicketTime,@33AddPerson,@33DeductionVolumeMoney,@33ClientNo,@33PackTicketCode,@33AddDate,@33TicketType,@33TotalTrueMoney,@33BalanceMoney,@33TicketCode,@33CustomerCode,@33OldTotalDiscountAmount,@33Address) 13882234510,锦江味之绝（华熙528店）,0,265.00,252.00,252.00,XS202507280278,刘丹,0.00,2025/7/29 6:51:02,锦江,2025/7/28 21:37:08,栾海威,0.00,SYDPGK01629,PG20250729003,2025/7/29 6:51:02,销售代下单,0,252.00,PS20250729339,SYDP,252.00,锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
锦江区雨树巷27号华熙Live528A区L3-4101味之绝华熙528店
Insert Into PackTicketRelationInfo(OrderTicketCode,CustomerCode,CKTicketCode,PackTicketCode) Values (@34OrderTicketCode,@34CustomerCode,@34CKTicketCode,@34PackTicketCode) XS202507280278,SYDP,PS20250729339,PG20250729003
Insert Into WarehouseOutTicketDetail(SaleAmount,SpecificationID,ConvetQty,GoodsCode,GoodsName,CagegoryID,ParentCagegoryName,ParentCagegoryID,IsAuto,CategoryName,DictContent,TrueQuantity,SalePrice,ReturnQuantity,Quantity,Buyprice,DiscountAmount,TicketCode,Note,DiscountPrice) Values (@35SaleAmount,@35SpecificationID,@35ConvetQty,@35GoodsCode,@35GoodsName,@35CagegoryID,@35ParentCagegoryName,@35ParentCagegoryID,@35IsAuto,@35CategoryName,@35DictContent,@35TrueQuantity,@35SalePrice,@35ReturnQuantity,@35Quantity,@35Buyprice,@35DiscountAmount,@35TicketCode,@35Note,@35DiscountPrice) 265.00,4575,1.000,SYDP006381,【海石丽人】特干耗儿鱼（50/100）,SYDPEJ00030,海鲜水产,SYDPYJ00004,是,耗儿鱼/马面鱼系列,4.5KG/,0,265.00,0,1.000,235.00,265.00,PS20250729339,,265.00
Update WareHouseOrderTicket Set PackTicketCode=@36PackTicketCode,State=@36State where 1=1 and TicketCode=@W36TicketCode PG20250729003,已处理,XS202507280278
System.Data.SqlClient.SqlException (0x80131904): 将截断字符串或二进制数据。
语句已终止。
在 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:e29d3376-feff-4e69-b2da-b543091c875c
Error Number:8152,State:13,Class:16