异常时间：2024-08-30 05:00:05,192 [35]
异常级别：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 ('18280503163','2024/8/30 5:00:00','7.00','GK01335S001','成华','栾海威','客户自下单','7.000','已支付','2024/8/30 5:00:05','7.00','336.00','329.00','0.00','新都泰兴镇农贸市场','刘亮','0.00','PS20240830026','2024/8/29 12:55:42','新都泰兴镇','0',''上午送货','PG20240830001','2024/8/30 0:00:00','SYDP','336.00','GK01335','XS202408290141')
Update DeliverTicketCodeTotalFee set TicketCode='PS20240830026',TicketCodeDate='2024/8/30 5:00:00',PackTicketCode='PG20240830001' where ID='258571'
Update DeliverTicketCodeDetailFee set TicketCode='PS20240830026' where ID='249335'
Insert Into PackTicketRelationInfo(OrderTicketCode,CustomerCode,CKTicketCode,PackTicketCode) Values ('XS202408290141','SYDP','PS20240830026','PG20240830001')
Insert Into WarehouseOutTicketDetail(SaleAmount,SpecificationID,ConvetQty,GoodsCode,GoodsName,CagegoryID,ParentCagegoryName,ParentCagegoryID,IsAuto,CategoryName,DictContent,TrueQuantity,SalePrice,ReturnQuantity,Quantity,Buyprice,DiscountAmount,TicketCode,Note,DiscountPrice) Values ('336.00','17','7.000','SYDP001173','【精英】鸭肝','SYDPEJ00104','鸭产品','SYDPYJ00012','是','鸭肝','1kg*12袋','0','48.00','0','7.000','43.00','336.00','PS20240830026','','48.00')
update WareHouseOrderTicket set State='已处理',PackTicketCode='PG20240830001' where TicketCode='XS202408290141'
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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
在 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.ExecuteTransSql(IList`1 SqlList) 位置 D:\WorkSpaceByXbx\冷链供应链正式库\溯源冻品网正式版\gylErpWebservice2023-09-12\MySqlDAL\Tools\MySqlHelper.cs:行号 229
ClientConnectionId:b6dbf6a6-fca9-4219-9adb-2a7ef6259f6e
Error Number:102,State:1,Class:15
异常时间：2024-08-30 06:37:09,142 [43]
异常级别：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 ('18280503163','2024/8/30 6:37:05','7.00','GK01335S001','成华','公司号','客户自下单','7.000','已支付','2024/8/30 6:37:09','7.00','336.00','329.00','0.00','新都泰兴镇农贸市场','刘亮','0.00','PS20240830320','2024/8/29 12:55:42','新都泰兴镇','0',''上午送货','PG20240830002','2024/8/30 0:00:00','SYDP','336.00','GK01335','XS202408290141')
Update DeliverTicketCodeTotalFee set TicketCode='PS20240830320',TicketCodeDate='2024/8/30 6:37:05',PackTicketCode='PG20240830002' where ID='258571'
Update DeliverTicketCodeDetailFee set TicketCode='PS20240830320' where ID='249335'
Insert Into PackTicketRelationInfo(OrderTicketCode,CustomerCode,CKTicketCode,PackTicketCode) Values ('XS202408290141','SYDP','PS20240830320','PG20240830002')
Insert Into WarehouseOutTicketDetail(SaleAmount,SpecificationID,ConvetQty,GoodsCode,GoodsName,CagegoryID,ParentCagegoryName,ParentCagegoryID,IsAuto,CategoryName,DictContent,TrueQuantity,SalePrice,ReturnQuantity,Quantity,Buyprice,DiscountAmount,TicketCode,Note,DiscountPrice) Values ('336.00','17','7.000','SYDP001173','【精英】鸭肝','SYDPEJ00104','鸭产品','SYDPYJ00012','是','鸭肝','1kg*12袋','0','48.00','0','7.000','43.00','336.00','PS20240830320','','48.00')
update WareHouseOrderTicket set State='已处理',PackTicketCode='PG20240830002' where TicketCode='XS202408290141'
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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
在 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.ExecuteTransSql(IList`1 SqlList) 位置 D:\WorkSpaceByXbx\冷链供应链正式库\溯源冻品网正式版\gylErpWebservice2023-09-12\MySqlDAL\Tools\MySqlHelper.cs:行号 229
ClientConnectionId:89b01409-df50-4663-b061-3edf315656f3
Error Number:102,State:1,Class:15
异常时间：2024-08-30 07:31:01,611 [21]
异常级别：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 ('18280503163','2024/8/30 7:31:00','7.00','GK01335S001','成华','栾海威','客户自下单','7.000','已支付','2024/8/30 7:31:01','7.00','336.00','329.00','0.00','新都泰兴镇农贸市场','刘亮','0.00','PS20240830338','2024/8/29 12:55:42','新都泰兴镇','0',''上午送货','PG20240830003','2024/8/30 0:00:00','SYDP','336.00','GK01335','XS202408290141')
Update DeliverTicketCodeTotalFee set TicketCode='PS20240830338',TicketCodeDate='2024/8/30 7:31:00',PackTicketCode='PG20240830003' where ID='258571'
Update DeliverTicketCodeDetailFee set TicketCode='PS20240830338' where ID='249335'
Insert Into PackTicketRelationInfo(OrderTicketCode,CustomerCode,CKTicketCode,PackTicketCode) Values ('XS202408290141','SYDP','PS20240830338','PG20240830003')
Insert Into WarehouseOutTicketDetail(SaleAmount,SpecificationID,ConvetQty,GoodsCode,GoodsName,CagegoryID,ParentCagegoryName,ParentCagegoryID,IsAuto,CategoryName,DictContent,TrueQuantity,SalePrice,ReturnQuantity,Quantity,Buyprice,DiscountAmount,TicketCode,Note,DiscountPrice) Values ('336.00','17','7.000','SYDP001173','【精英】鸭肝','SYDPEJ00104','鸭产品','SYDPYJ00012','是','鸭肝','1kg*12袋','0','48.00','0','7.000','43.00','336.00','PS20240830338','','48.00')
update WareHouseOrderTicket set State='已处理',PackTicketCode='PG20240830003' where TicketCode='XS202408290141'
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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
在 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.ExecuteTransSql(IList`1 SqlList) 位置 D:\WorkSpaceByXbx\冷链供应链正式库\溯源冻品网正式版\gylErpWebservice2023-09-12\MySqlDAL\Tools\MySqlHelper.cs:行号 229
ClientConnectionId:aad85e02-5921-4ad4-94e7-26fd07f33900
Error Number:102,State:1,Class:15
异常时间：2024-08-30 07:31:26,891 [46]
异常级别：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 ('18280503163','2024/8/30 7:31:25','7.00','GK01335S001','成华','栾海威','客户自下单','7.000','已支付','2024/8/30 7:31:26','7.00','336.00','329.00','0.00','新都泰兴镇农贸市场','刘亮','0.00','PS20240830337','2024/8/29 12:55:42','新都泰兴镇','0',''上午送货','PG20240830003','2024/8/30 0:00:00','SYDP','336.00','GK01335','XS202408290141')
Update DeliverTicketCodeTotalFee set TicketCode='PS20240830337',TicketCodeDate='2024/8/30 7:31:25',PackTicketCode='PG20240830003' where ID='258571'
Update DeliverTicketCodeDetailFee set TicketCode='PS20240830337' where ID='249335'
Insert Into PackTicketRelationInfo(OrderTicketCode,CustomerCode,CKTicketCode,PackTicketCode) Values ('XS202408290141','SYDP','PS20240830337','PG20240830003')
Insert Into WarehouseOutTicketDetail(SaleAmount,SpecificationID,ConvetQty,GoodsCode,GoodsName,CagegoryID,ParentCagegoryName,ParentCagegoryID,IsAuto,CategoryName,DictContent,TrueQuantity,SalePrice,ReturnQuantity,Quantity,Buyprice,DiscountAmount,TicketCode,Note,DiscountPrice) Values ('336.00','17','7.000','SYDP001173','【精英】鸭肝','SYDPEJ00104','鸭产品','SYDPYJ00012','是','鸭肝','1kg*12袋','0','48.00','0','7.000','43.00','336.00','PS20240830337','','48.00')
update WareHouseOrderTicket set State='已处理',PackTicketCode='PG20240830003' where TicketCode='XS202408290141'
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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
在 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.ExecuteTransSql(IList`1 SqlList) 位置 D:\WorkSpaceByXbx\冷链供应链正式库\溯源冻品网正式版\gylErpWebservice2023-09-12\MySqlDAL\Tools\MySqlHelper.cs:行号 229
ClientConnectionId:89b01409-df50-4663-b061-3edf315656f3
Error Number:102,State:1,Class:15
异常时间：2024-08-30 07:53:42,704 [53]
异常级别：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 ('18280503163','2024/8/30 7:53:40','7.00','GK01335S001','成华','栾海威','客户自下单','7.000','已支付','2024/8/30 7:53:42','7.00','336.00','329.00','0.00','新都泰兴镇农贸市场','刘亮','0.00','PS20240830339','2024/8/29 12:55:42','新都泰兴镇','0',''上午送货','PG20240830005','2024/8/30 0:00:00','SYDP','336.00','GK01335','XS202408290141')
Update DeliverTicketCodeTotalFee set TicketCode='PS20240830339',TicketCodeDate='2024/8/30 7:53:40',PackTicketCode='PG20240830005' where ID='258571'
Update DeliverTicketCodeDetailFee set TicketCode='PS20240830339' where ID='249335'
Insert Into PackTicketRelationInfo(OrderTicketCode,CustomerCode,CKTicketCode,PackTicketCode) Values ('XS202408290141','SYDP','PS20240830339','PG20240830005')
Insert Into WarehouseOutTicketDetail(SaleAmount,SpecificationID,ConvetQty,GoodsCode,GoodsName,CagegoryID,ParentCagegoryName,ParentCagegoryID,IsAuto,CategoryName,DictContent,TrueQuantity,SalePrice,ReturnQuantity,Quantity,Buyprice,DiscountAmount,TicketCode,Note,DiscountPrice) Values ('336.00','17','7.000','SYDP001173','【精英】鸭肝','SYDPEJ00104','鸭产品','SYDPYJ00012','是','鸭肝','1kg*12袋','0','48.00','0','7.000','43.00','336.00','PS20240830339','','48.00')
update WareHouseOrderTicket set State='已处理',PackTicketCode='PG20240830005' where TicketCode='XS202408290141'
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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
在 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.ExecuteTransSql(IList`1 SqlList) 位置 D:\WorkSpaceByXbx\冷链供应链正式库\溯源冻品网正式版\gylErpWebservice2023-09-12\MySqlDAL\Tools\MySqlHelper.cs:行号 229
ClientConnectionId:694378a7-8e8c-48a8-8e1c-f5be797be877
Error Number:102,State:1,Class:15