异常时间：2026-05-16 13:53:46,421 [38]
异常级别：WARN
异 常 类：logerror_sql [(null)]
错误索引1
共计【6】条
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 (@8OrderAcount,@8AddDate,@8TotalServiceCharge,@8StoreNo,@8ClientArea,@8TrueName,@8TicketType,@8TotalQty,@8IsPay,@8RecordTime,@8TotalTrueServiceCharge,@8TotalDiscountAmount,@8TotalMoney,@8BalanceOffsetMoney,@8ClientName,@8ResponsiblePersonName,@8DeductionVolumeMoney,@8TicketCode,@8OrderTicketTime,@8Address,@8TotalReturnAmount,@8Note,@8PackTicketCode,@8ConvertAddDate,@8CustomerCode,@8TotalSaleAmount,@8ClientNo,@8OrderTicket) tangyadong,2026/5/16 13:53:46,0.00,SYDPGK21431S001,绵阳西,王春凤,销售代下单,2.000,,2026/5/16 13:53:46,0.00,900.00,900.00,0.00,绵阳拌菜（三河街）,唐亚东,0.00,PS20260516513,2026/5/16 13:49:59,配送日期 顾客名字 应交金额 2026/4/27 6:00 绵阳城市学院水果捞 220 2026/4/28 6:00 绵阳城市学院水果捞 220 2026/4/29 6:00 绵阳城市学院水果捞 220 2026/4/30 6:00 绵阳城市学院水果捞 220 2026/5/1 ,0,,PG20260516009,2026/5/16 0:00:00,SYDP,900.00,SYDPGK21431,XS202605160164
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 (@9TelNo,@9ClientName,@9ReturnMoney,@9TotalSalePrice,@9ModTotalMoney,@9TotalDiscountAmount,@9OrderTicket,@9ResponsiblePersonName,@9BalanceOffsetMoney,@9TicketCodeDate,@9ClientArea,@9OrderTicketTime,@9AddPerson,@9DeductionVolumeMoney,@9ClientNo,@9PackTicketCode,@9AddDate,@9TicketType,@9TotalTrueMoney,@9BalanceMoney,@9TicketCode,@9CustomerCode,@9OldTotalDiscountAmount,@9Address) 18384584059,绵阳拌菜（三河街）,0,900.00,900.00,900.00,XS202605160164,唐亚东,0.00,2026/5/16 13:53:46,绵阳西,2026/5/16 13:49:59,王春凤,0.00,SYDPGK21431,PG20260516009,2026/5/16 13:53:46,销售代下单,0,900.00,PS20260516513,SYDP,900.00,配送日期 顾客名字 应交金额 2026/4/27 6:00 绵阳城市学院水果捞 220 2026/4/28 6:00 绵阳城市学院水果捞 220 2026/4/29 6:00 绵阳城市学院水果捞 220 2026/4/30 6:00 绵阳城市学院水果捞 220 2026/5/1
Insert Into PackTicketRelationInfo(OrderTicketCode,CustomerCode,CKTicketCode,PackTicketCode) Values (@10OrderTicketCode,@10CustomerCode,@10CKTicketCode,@10PackTicketCode) XS202605160164,SYDP,PS20260516513,PG20260516009
Insert Into WarehouseOutTicketDetail(SaleAmount,SpecificationID,ConvetQty,GoodsCode,GoodsName,CagegoryID,ParentCagegoryName,ParentCagegoryID,IsAuto,CategoryName,DictContent,TrueQuantity,SalePrice,ReturnQuantity,Quantity,Buyprice,DiscountAmount,TicketCode,Note,DiscountPrice) Values (@11SaleAmount,@11SpecificationID,@11ConvetQty,@11GoodsCode,@11GoodsName,@11CagegoryID,@11ParentCagegoryName,@11ParentCagegoryID,@11IsAuto,@11CategoryName,@11DictContent,@11TrueQuantity,@11SalePrice,@11ReturnQuantity,@11Quantity,@11Buyprice,@11DiscountAmount,@11TicketCode,@11Note,@11DiscountPrice) 450.00,2144,1.000,SYDP008436,【食吉上】原味郡肝片-周转箱,SYDPEJ00241,熟食冷吃,SYDPYJ00022,是,鸭产品,1kg*10,0,450.00,0,1.000,410.00,450.00,PS20260516513,,450.00
Insert Into WarehouseOutTicketDetail(SaleAmount,SpecificationID,ConvetQty,GoodsCode,GoodsName,CagegoryID,ParentCagegoryName,ParentCagegoryID,IsAuto,CategoryName,DictContent,TrueQuantity,SalePrice,ReturnQuantity,Quantity,Buyprice,DiscountAmount,TicketCode,Note,DiscountPrice) Values (@12SaleAmount,@12SpecificationID,@12ConvetQty,@12GoodsCode,@12GoodsName,@12CagegoryID,@12ParentCagegoryName,@12ParentCagegoryID,@12IsAuto,@12CategoryName,@12DictContent,@12TrueQuantity,@12SalePrice,@12ReturnQuantity,@12Quantity,@12Buyprice,@12DiscountAmount,@12TicketCode,@12Note,@12DiscountPrice) 450.00,1155,1.000,SYDP008409,【食吉上】原味肚条-周转箱,SYDPEJ00002,调理产品,SYDPYJ00001,是,调理猪肉,1kg*10袋,0,450.00,0,1.000,400.00,450.00,PS20260516513,,450.00
Update WareHouseOrderTicket Set PackTicketCode=@13PackTicketCode,State=@13State where 1=1 and TicketCode=@W13TicketCode PG20260516009,已处理,XS202605160164
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:f1e38c03-ece1-4200-8d6e-06273cd2af42
Error Number:8152,State:13,Class:16