异常时间:2024-08-27 10:26:20,536 [12]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引:1

共计【3】条

Insert Into WarehouseOutTrueTicketDetail(Unit,SpecificationID,ConvetQty,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,PsDetailID,Quantity,Amount,TicketCode,PcsWgt) Values ('','22','1.000','SYDP001750','【中佳】精修鸡胸','CK20240827005','SYDPEJ00045','鸡产品','SYDPYJ00005','2','鸡胸','9.7kg','595877','1.000','0','CK2024082700005','0')

Insert Into WarehouseOutTrueTicketDetail(Unit,SpecificationID,ConvetQty,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,PsDetailID,Quantity,Amount,TicketCode,PcsWgt) Values ('','8','1.000','SYDP001412','推荐【欢冰】蝴蝶虾300个(31/40)','CK20240827005','SYDPEJ00207','海鲜水产','SYDPYJ00004','2','虾仁/蝴蝶虾','5kg','595878','1.000','0','CK2024082700005','0')

update WarehouseOutTicket set Auditor5='公司号',Auditor5Time='2024/8/27 10:26:20',Auditor5Result='已处理',Auditor5Note='CK2024082700005' where TicketID='240243'



System.Data.SqlClient.SqlException (0x80131904): 列名 'StoreID' 无效。 在 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:09842c74-6809-4d14-899c-3c6e26b7dffb Error Number:207,State:1,Class:16
异常时间:2024-08-27 10:49:29,985 [14]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引6

共计【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,,,190.00,0,1,,0,14036

Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,595101

Insert Into ReturnTicketInfFee(TicketType,AddDate,CustomerCode,ClientName,ReturnNeedMoney,ClientNo,ClientArea,ResponsiblePersonName,TicketCodeTic,TicketCode) Values (@R3TicketType,@R3AddDate,@R3CustomerCode,@R3ClientName,@R3ReturnNeedMoney,@R3ClientNo,@R3ClientArea,@R3ResponsiblePersonName,@R3TicketCodeTic,@R3TicketCode) 配送退货,2024/8/27 10:49:29,SYDP,红光乐山美食甜皮鸭公园1号,190.00,SYDPGK05011,郫都区线路1,陈中美,RT2024082700016,RT20240827016

Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2024/8/27 10:49:29,190.00,1,公司号,Y:数据一致,公司号,2024/8/27 10:49:29,RT2024082700016

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) 2024/8/27 10:49:29,RK20240827001,2024/8/27 10:49:29,RT2024082700016,RK2024082700001,采购自动复核,2024/8/27 10:49:29,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) ,SYDP004553,缺货退款,RK20240827001,SYDPEJ00206,其他,SYDPYJ00008,2,其他,无,1,0,20240827,RK2024082700001

Insert Into GoodsBuyBalancePriceInf(PriceTime,CustomerCode,BalancePrice,AddUserName,DictContent,LastNum,DictID,RkTicketCode,LastPrice,GoodsCode,AddModifyTime,GoodsName) Values (@S07PriceTime,@S07CustomerCode,@S07BalancePrice,@S07AddUserName,@S07DictContent,@S07LastNum,@S07DictID,@S07RkTicketCode,@S07LastPrice,@S07GoodsCode,@S07AddModifyTime,@S07GoodsName) 2024/8/27 10:49:29,SYDP,190.00,公司号,无,0,,RT2024082700016,0,SYDP004553,2024/8/27 10:49:29,缺货退款



System.Data.SqlClient.SqlException (0x80131904): 列名 'StoreID' 无效。 在 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:行号 275 ClientConnectionId:2ad90190-d1d2-4b2a-a3b9-944b153d6e76 Error Number:207,State:1,Class:16
异常时间:2024-08-27 10:50:06,409 [23]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引6

共计【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,,,190.00,0,1,,0,14036

Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,595101

Insert Into ReturnTicketInfFee(TicketType,AddDate,CustomerCode,ClientName,ReturnNeedMoney,ClientNo,ClientArea,ResponsiblePersonName,TicketCodeTic,TicketCode) Values (@R3TicketType,@R3AddDate,@R3CustomerCode,@R3ClientName,@R3ReturnNeedMoney,@R3ClientNo,@R3ClientArea,@R3ResponsiblePersonName,@R3TicketCodeTic,@R3TicketCode) 配送退货,2024/8/27 10:50:06,SYDP,红光乐山美食甜皮鸭公园1号,190.00,SYDPGK05011,郫都区线路1,陈中美,RT2024082700016,RT20240827016

Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2024/8/27 10:50:06,190.00,1,公司号,Y:数据一致,公司号,2024/8/27 10:50:06,RT2024082700016

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) 2024/8/27 10:50:06,RK20240827001,2024/8/27 10:50:06,RT2024082700016,RK2024082700001,采购自动复核,2024/8/27 10:50:06,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) ,SYDP004553,缺货退款,RK20240827001,SYDPEJ00206,其他,SYDPYJ00008,2,其他,无,1,0,20240827,RK2024082700001

Insert Into GoodsBuyBalancePriceInf(PriceTime,CustomerCode,BalancePrice,AddUserName,DictContent,LastNum,DictID,RkTicketCode,LastPrice,GoodsCode,AddModifyTime,GoodsName) Values (@S07PriceTime,@S07CustomerCode,@S07BalancePrice,@S07AddUserName,@S07DictContent,@S07LastNum,@S07DictID,@S07RkTicketCode,@S07LastPrice,@S07GoodsCode,@S07AddModifyTime,@S07GoodsName) 2024/8/27 10:50:06,SYDP,190.00,公司号,无,0,,RT2024082700016,0,SYDP004553,2024/8/27 10:50:06,缺货退款



System.Data.SqlClient.SqlException (0x80131904): 列名 'StoreID' 无效。 在 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:行号 275 ClientConnectionId:56404247-de5a-4020-b8fc-54d45b71eb4f Error Number:207,State:1,Class:16
异常时间:2024-08-27 10:50:25,647 [11]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引6

共计【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,,,450.00,0,1,,0,14035

Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,595099

Insert Into ReturnTicketInfFee(TicketType,AddDate,CustomerCode,ClientName,ReturnNeedMoney,ClientNo,ClientArea,ResponsiblePersonName,TicketCodeTic,TicketCode) Values (@R3TicketType,@R3AddDate,@R3CustomerCode,@R3ClientName,@R3ReturnNeedMoney,@R3ClientNo,@R3ClientArea,@R3ResponsiblePersonName,@R3TicketCodeTic,@R3TicketCode) 配送退货,2024/8/27 10:50:25,SYDP,温江手撕烤鸭(合能珍宝),450.00,SYDPGK01950,温江,陈万强,RT2024082700015,RT20240827015

Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2024/8/27 10:50:25,450.00,1,公司号,Y:数据一致,公司号,2024/8/27 10:50:25,RT2024082700015

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) 2024/8/27 10:50:25,RK20240827001,2024/8/27 10:50:25,RT2024082700015,RK2024082700001,采购自动复核,2024/8/27 10:50:25,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) ,SYDP004553,缺货退款,RK20240827001,SYDPEJ00206,其他,SYDPYJ00008,2,其他,无,1,0,20240827,RK2024082700001

Insert Into GoodsBuyBalancePriceInf(PriceTime,CustomerCode,BalancePrice,AddUserName,DictContent,LastNum,DictID,RkTicketCode,LastPrice,GoodsCode,AddModifyTime,GoodsName) Values (@S07PriceTime,@S07CustomerCode,@S07BalancePrice,@S07AddUserName,@S07DictContent,@S07LastNum,@S07DictID,@S07RkTicketCode,@S07LastPrice,@S07GoodsCode,@S07AddModifyTime,@S07GoodsName) 2024/8/27 10:50:25,SYDP,450.00,公司号,无,0,,RT2024082700015,0,SYDP004553,2024/8/27 10:50:25,缺货退款



System.Data.SqlClient.SqlException (0x80131904): 列名 'StoreID' 无效。 在 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:行号 275 ClientConnectionId:56404247-de5a-4020-b8fc-54d45b71eb4f Error Number:207,State:1,Class:16
异常时间:2024-08-27 10:50:45,697 [14]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引6

共计【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,,,190.00,0,1,,0,14036

Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,595101

Insert Into ReturnTicketInfFee(TicketType,AddDate,CustomerCode,ClientName,ReturnNeedMoney,ClientNo,ClientArea,ResponsiblePersonName,TicketCodeTic,TicketCode) Values (@R3TicketType,@R3AddDate,@R3CustomerCode,@R3ClientName,@R3ReturnNeedMoney,@R3ClientNo,@R3ClientArea,@R3ResponsiblePersonName,@R3TicketCodeTic,@R3TicketCode) 配送退货,2024/8/27 10:50:45,SYDP,红光乐山美食甜皮鸭公园1号,190.00,SYDPGK05011,郫都区线路1,陈中美,RT2024082700016,RT20240827016

Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2024/8/27 10:50:45,190.00,1,公司号,Y:数据一致,公司号,2024/8/27 10:50:45,RT2024082700016

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) 2024/8/27 10:50:45,RK20240827001,2024/8/27 10:50:45,RT2024082700016,RK2024082700001,采购自动复核,2024/8/27 10:50:45,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) ,SYDP004553,缺货退款,RK20240827001,SYDPEJ00206,其他,SYDPYJ00008,2,其他,无,1,0,20240827,RK2024082700001

Insert Into GoodsBuyBalancePriceInf(PriceTime,CustomerCode,BalancePrice,AddUserName,DictContent,LastNum,DictID,RkTicketCode,LastPrice,GoodsCode,AddModifyTime,GoodsName) Values (@S07PriceTime,@S07CustomerCode,@S07BalancePrice,@S07AddUserName,@S07DictContent,@S07LastNum,@S07DictID,@S07RkTicketCode,@S07LastPrice,@S07GoodsCode,@S07AddModifyTime,@S07GoodsName) 2024/8/27 10:50:45,SYDP,190.00,公司号,无,0,,RT2024082700016,0,SYDP004553,2024/8/27 10:50:45,缺货退款



System.Data.SqlClient.SqlException (0x80131904): 列名 'StoreID' 无效。 在 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:行号 275 ClientConnectionId:7aa8cd16-06c2-4ddb-9386-f3b4809644ff Error Number:207,State:1,Class:16
异常时间:2024-08-27 10:51:16,922 [13]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引6

共计【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,,,190.00,0,1,,0,14036

Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,595101

Insert Into ReturnTicketInfFee(TicketType,AddDate,CustomerCode,ClientName,ReturnNeedMoney,ClientNo,ClientArea,ResponsiblePersonName,TicketCodeTic,TicketCode) Values (@R3TicketType,@R3AddDate,@R3CustomerCode,@R3ClientName,@R3ReturnNeedMoney,@R3ClientNo,@R3ClientArea,@R3ResponsiblePersonName,@R3TicketCodeTic,@R3TicketCode) 配送退货,2024/8/27 10:51:16,SYDP,红光乐山美食甜皮鸭公园1号,190.00,SYDPGK05011,郫都区线路1,陈中美,RT2024082700016,RT20240827016

Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2024/8/27 10:51:16,190.00,1,公司号,Y:数据一致,公司号,2024/8/27 10:51:16,RT2024082700016

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) 2024/8/27 10:51:16,RK20240827001,2024/8/27 10:51:16,RT2024082700016,RK2024082700001,采购自动复核,2024/8/27 10:51:16,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) ,SYDP004553,缺货退款,RK20240827001,SYDPEJ00206,其他,SYDPYJ00008,2,其他,无,1,0,20240827,RK2024082700001

Insert Into GoodsBuyBalancePriceInf(PriceTime,CustomerCode,BalancePrice,AddUserName,DictContent,LastNum,DictID,RkTicketCode,LastPrice,GoodsCode,AddModifyTime,GoodsName) Values (@S07PriceTime,@S07CustomerCode,@S07BalancePrice,@S07AddUserName,@S07DictContent,@S07LastNum,@S07DictID,@S07RkTicketCode,@S07LastPrice,@S07GoodsCode,@S07AddModifyTime,@S07GoodsName) 2024/8/27 10:51:16,SYDP,190.00,公司号,无,0,,RT2024082700016,0,SYDP004553,2024/8/27 10:51:16,缺货退款



System.Data.SqlClient.SqlException (0x80131904): 列名 'StoreID' 无效。 在 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:行号 275 ClientConnectionId:7aa8cd16-06c2-4ddb-9386-f3b4809644ff Error Number:207,State:1,Class:16
异常时间:2024-08-27 10:51:30,149 [23]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引6

共计【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,,,455.00,0,1,,0,14033

Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,595100

Insert Into ReturnTicketInfFee(TicketType,AddDate,CustomerCode,ClientName,ReturnNeedMoney,ClientNo,ClientArea,ResponsiblePersonName,TicketCodeTic,TicketCode) Values (@R3TicketType,@R3AddDate,@R3CustomerCode,@R3ClientName,@R3ReturnNeedMoney,@R3ClientNo,@R3ClientArea,@R3ResponsiblePersonName,@R3TicketCodeTic,@R3TicketCode) 配送退货,2024/8/27 10:51:29,SYDP,成华菜巷深处生鲜超市(剑阁土鸡),455.00,SYDPGK14489,成华,何丹,RT2024082700013,RT20240827013

Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2024/8/27 10:51:29,455.00,1,公司号,Y:数据一致,公司号,2024/8/27 10:51:29,RT2024082700013

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) 2024/8/27 10:51:29,RK20240827001,2024/8/27 10:51:29,RT2024082700013,RK2024082700001,采购自动复核,2024/8/27 10:51:29,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) ,SYDP004553,缺货退款,RK20240827001,SYDPEJ00206,其他,SYDPYJ00008,2,其他,无,1,0,20240827,RK2024082700001

Insert Into GoodsBuyBalancePriceInf(PriceTime,CustomerCode,BalancePrice,AddUserName,DictContent,LastNum,DictID,RkTicketCode,LastPrice,GoodsCode,AddModifyTime,GoodsName) Values (@S07PriceTime,@S07CustomerCode,@S07BalancePrice,@S07AddUserName,@S07DictContent,@S07LastNum,@S07DictID,@S07RkTicketCode,@S07LastPrice,@S07GoodsCode,@S07AddModifyTime,@S07GoodsName) 2024/8/27 10:51:29,SYDP,455.00,公司号,无,0,,RT2024082700013,0,SYDP004553,2024/8/27 10:51:29,缺货退款



System.Data.SqlClient.SqlException (0x80131904): 列名 'StoreID' 无效。 在 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:行号 275 ClientConnectionId:56404247-de5a-4020-b8fc-54d45b71eb4f Error Number:207,State:1,Class:16
异常时间:2024-08-27 10:51:54,193 [21]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引6

共计【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,,,190.00,0,1,,0,14036

Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,595101

Insert Into ReturnTicketInfFee(TicketType,AddDate,CustomerCode,ClientName,ReturnNeedMoney,ClientNo,ClientArea,ResponsiblePersonName,TicketCodeTic,TicketCode) Values (@R3TicketType,@R3AddDate,@R3CustomerCode,@R3ClientName,@R3ReturnNeedMoney,@R3ClientNo,@R3ClientArea,@R3ResponsiblePersonName,@R3TicketCodeTic,@R3TicketCode) 配送退货,2024/8/27 10:51:53,SYDP,红光乐山美食甜皮鸭公园1号,190.00,SYDPGK05011,郫都区线路1,陈中美,RT2024082700016,RT20240827016

Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2024/8/27 10:51:53,190.00,1,陈万强,Y:数据一致,陈万强,2024/8/27 10:51:53,RT2024082700016

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) 2024/8/27 10:51:53,RK20240827001,2024/8/27 10:51:53,RT2024082700016,RK2024082700001,采购自动复核,2024/8/27 10:51:53,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) ,SYDP004553,缺货退款,RK20240827001,SYDPEJ00206,其他,SYDPYJ00008,2,其他,无,1,0,20240827,RK2024082700001

Insert Into GoodsBuyBalancePriceInf(PriceTime,CustomerCode,BalancePrice,AddUserName,DictContent,LastNum,DictID,RkTicketCode,LastPrice,GoodsCode,AddModifyTime,GoodsName) Values (@S07PriceTime,@S07CustomerCode,@S07BalancePrice,@S07AddUserName,@S07DictContent,@S07LastNum,@S07DictID,@S07RkTicketCode,@S07LastPrice,@S07GoodsCode,@S07AddModifyTime,@S07GoodsName) 2024/8/27 10:51:53,SYDP,190.00,陈万强,无,0,,RT2024082700016,0,SYDP004553,2024/8/27 10:51:53,缺货退款



System.Data.SqlClient.SqlException (0x80131904): 列名 'StoreID' 无效。 在 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:行号 275 ClientConnectionId:efc23fc8-1cd2-442a-991d-93442983a63b Error Number:207,State:1,Class:16
异常时间:2024-08-27 10:57:04,331 [27]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引6

共计【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,,,190.00,0,1,,0,14036

Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,595101

Insert Into ReturnTicketInfFee(TicketType,AddDate,CustomerCode,ClientName,ReturnNeedMoney,ClientNo,ClientArea,ResponsiblePersonName,TicketCodeTic,TicketCode) Values (@R3TicketType,@R3AddDate,@R3CustomerCode,@R3ClientName,@R3ReturnNeedMoney,@R3ClientNo,@R3ClientArea,@R3ResponsiblePersonName,@R3TicketCodeTic,@R3TicketCode) 配送退货,2024/8/27 10:57:04,SYDP,红光乐山美食甜皮鸭公园1号,190.00,SYDPGK05011,郫都区线路1,陈中美,RT2024082700016,RT20240827016

Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2024/8/27 10:57:04,190.00,1,公司号,Y:数据一致,公司号,2024/8/27 10:57:04,RT2024082700016

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) 2024/8/27 10:57:04,RK20240827001,2024/8/27 10:57:04,RT2024082700016,RK2024082700001,采购自动复核,2024/8/27 10:57:04,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) ,SYDP004553,缺货退款,RK20240827001,SYDPEJ00206,其他,SYDPYJ00008,2,其他,无,1,0,20240827,RK2024082700001

Insert Into GoodsBuyBalancePriceInf(PriceTime,CustomerCode,BalancePrice,AddUserName,DictContent,LastNum,DictID,RkTicketCode,LastPrice,GoodsCode,AddModifyTime,GoodsName) Values (@S07PriceTime,@S07CustomerCode,@S07BalancePrice,@S07AddUserName,@S07DictContent,@S07LastNum,@S07DictID,@S07RkTicketCode,@S07LastPrice,@S07GoodsCode,@S07AddModifyTime,@S07GoodsName) 2024/8/27 10:57:04,SYDP,190.00,公司号,无,0,,RT2024082700016,0,SYDP004553,2024/8/27 10:57:04,缺货退款



System.Data.SqlClient.SqlException (0x80131904): 列名 'StoreID' 无效。 在 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:行号 275 ClientConnectionId:2ad90190-d1d2-4b2a-a3b9-944b153d6e76 Error Number:207,State:1,Class:16
异常时间:2024-08-27 10:57:24,761 [27]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引6

共计【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,,,190.00,0,1,,0,14036

Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,595101

Insert Into ReturnTicketInfFee(TicketType,AddDate,CustomerCode,ClientName,ReturnNeedMoney,ClientNo,ClientArea,ResponsiblePersonName,TicketCodeTic,TicketCode) Values (@R3TicketType,@R3AddDate,@R3CustomerCode,@R3ClientName,@R3ReturnNeedMoney,@R3ClientNo,@R3ClientArea,@R3ResponsiblePersonName,@R3TicketCodeTic,@R3TicketCode) 配送退货,2024/8/27 10:57:24,SYDP,红光乐山美食甜皮鸭公园1号,190.00,SYDPGK05011,郫都区线路1,陈中美,RT2024082700016,RT20240827016

Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2024/8/27 10:57:24,190.00,1,公司号,Y:数据一致,公司号,2024/8/27 10:57:24,RT2024082700016

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) 2024/8/27 10:57:24,RK20240827001,2024/8/27 10:57:24,RT2024082700016,RK2024082700001,采购自动复核,2024/8/27 10:57:24,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) ,SYDP004553,缺货退款,RK20240827001,SYDPEJ00206,其他,SYDPYJ00008,2,其他,无,1,0,20240827,RK2024082700001

Insert Into GoodsBuyBalancePriceInf(PriceTime,CustomerCode,BalancePrice,AddUserName,DictContent,LastNum,DictID,RkTicketCode,LastPrice,GoodsCode,AddModifyTime,GoodsName) Values (@S07PriceTime,@S07CustomerCode,@S07BalancePrice,@S07AddUserName,@S07DictContent,@S07LastNum,@S07DictID,@S07RkTicketCode,@S07LastPrice,@S07GoodsCode,@S07AddModifyTime,@S07GoodsName) 2024/8/27 10:57:24,SYDP,190.00,公司号,无,0,,RT2024082700016,0,SYDP004553,2024/8/27 10:57:24,缺货退款



System.Data.SqlClient.SqlException (0x80131904): 列名 'StoreID' 无效。 在 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:行号 275 ClientConnectionId:56404247-de5a-4020-b8fc-54d45b71eb4f Error Number:207,State:1,Class:16
异常时间:2024-08-27 11:55:38,988 [19]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引6

共计【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,黄,,130.00,0,0,SYDPGYS0358,1,13971

Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,591030

Insert Into ReturnTicketInfFee(TicketType,AddDate,CustomerCode,ClientName,ReturnNeedMoney,ClientNo,ClientArea,ResponsiblePersonName,TicketCodeTic,TicketCode) Values (@R3TicketType,@R3AddDate,@R3CustomerCode,@R3ClientName,@R3ReturnNeedMoney,@R3ClientNo,@R3ClientArea,@R3ResponsiblePersonName,@R3TicketCodeTic,@R3TicketCode) 配送退货,2024/8/27 11:55:38,SYDP,成华奥园九号院老火锅,130.00,SYDPGK13227,成华,何丹,RT2024082100008,RT20240821008

Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2024/8/27 11:55:38,130.00,1,陈万强,Y:数据一致,陈万强,2024/8/27 11:55:38,RT2024082100008

Insert Into WarehouseInTrueTicket(AddDate,TicTicketCode,Auditor1Time,ConvertTicketCode,TicketCode,Auditor1Note,RecordTime,TotalQty,Auditor1,TotalAmount,Auditor1Result,CustomerCode,TrueName,TicketType) Values (@UTG5AddDate,@UTG5TicTicketCode,@UTG5Auditor1Time,@UTG5ConvertTicketCode,@UTG5TicketCode,@UTG5Auditor1Note,@UTG5RecordTime,@UTG5TotalQty,@UTG5Auditor1,@UTG5TotalAmount,@UTG5Auditor1Result,@UTG5CustomerCode,@UTG5TrueName,@UTG5TicketType) 2024/8/27 11:55:38,RK20240827012,2024/8/27 11:55:38,RT2024082100008,RK2024082700012,采购自动复核,2024/8/27 11:55:38,1,陈万强,0,Y:数据一致,SYDP,陈万强,退货入库

Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O0TG6Unit,@O0TG6GoodsCode,@O0TG6GoodsName,@O0TG6TicTicketCode,@O0TG6CagegoryID,@O0TG6ParentCagegoryName,@O0TG6ParentCagegoryID,@O0TG6StoreID,@O0TG6CategoryName,@O0TG6DictContent,@O0TG6Quantity,@O0TG6Amount,@O0TG6LotNumber,@O0TG6TicketCode) ,SYDP002591,干贡菜(绿箱),RK20240827012,SYDPEJ00022,干杂水发,SYDPYJ00003,5,其他干杂,1.5kg/箱,1,0,20240827,RK2024082700012

Insert Into GoodsBuyBalancePriceInf(PriceTime,CustomerCode,BalancePrice,AddUserName,DictContent,LastNum,DictID,RkTicketCode,LastPrice,GoodsCode,AddModifyTime,GoodsName) Values (@S07PriceTime,@S07CustomerCode,@S07BalancePrice,@S07AddUserName,@S07DictContent,@S07LastNum,@S07DictID,@S07RkTicketCode,@S07LastPrice,@S07GoodsCode,@S07AddModifyTime,@S07GoodsName) 2024/8/27 11:55:38,SYDP,130.00,陈万强,1.5kg/箱,0,,RT2024082100008,0,SYDP002591,2024/8/27 11:55:38,干贡菜(绿箱)



System.Data.SqlClient.SqlException (0x80131904): 列名 'StoreID' 无效。 在 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:行号 275 ClientConnectionId:66635414-e8b0-45f3-aa6b-d6b98b8f1124 Error Number:207,State:1,Class:16
异常时间:2024-08-27 11:56:24,847 [4]
异常级别:WARN
异 常 类:logerror_sql [(null)]
错误索引6

共计【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,发黄,,130.00,0,0,SYDPGYS0358,1,13971

Update WarehouseOutTicketDetail Set ReturnQuantity=@W02ReturnQuantity where 1=1 and ID=@WW02ID 1,591030

Insert Into ReturnTicketInfFee(TicketType,AddDate,CustomerCode,ClientName,ReturnNeedMoney,ClientNo,ClientArea,ResponsiblePersonName,TicketCodeTic,TicketCode) Values (@R3TicketType,@R3AddDate,@R3CustomerCode,@R3ClientName,@R3ReturnNeedMoney,@R3ClientNo,@R3ClientArea,@R3ResponsiblePersonName,@R3TicketCodeTic,@R3TicketCode) 配送退货,2024/8/27 11:56:24,SYDP,成华奥园九号院老火锅,130.00,SYDPGK13227,成华,何丹,RT2024082100008,RT20240821008

Update WareHouseReturnTicket Set CgConTime=@E4CgConTime,TotalDiscountAmount=@E4TotalDiscountAmount,TotalQty=@E4TotalQty,CgConUser=@E4CgConUser,Auditor1Result=@E4Auditor1Result,Auditor1=@E4Auditor1,Auditor1Time=@E4Auditor1Time where 1=1 and TicketCodeTic=@WE4TicketCodeTic 2024/8/27 11:56:24,130.00,1,陈万强,Y:数据一致,陈万强,2024/8/27 11:56:24,RT2024082100008

Insert Into WarehouseInTrueTicket(AddDate,TicTicketCode,Auditor1Time,ConvertTicketCode,TicketCode,Auditor1Note,RecordTime,TotalQty,Auditor1,TotalAmount,Auditor1Result,CustomerCode,TrueName,TicketType) Values (@UTG5AddDate,@UTG5TicTicketCode,@UTG5Auditor1Time,@UTG5ConvertTicketCode,@UTG5TicketCode,@UTG5Auditor1Note,@UTG5RecordTime,@UTG5TotalQty,@UTG5Auditor1,@UTG5TotalAmount,@UTG5Auditor1Result,@UTG5CustomerCode,@UTG5TrueName,@UTG5TicketType) 2024/8/27 11:56:24,RK20240827012,2024/8/27 11:56:24,RT2024082100008,RK2024082700012,采购自动复核,2024/8/27 11:56:24,1,陈万强,0,Y:数据一致,SYDP,陈万强,退货入库

Insert Into WarehouseInTrueTicketDetail(Unit,GoodsCode,GoodsName,TicTicketCode,CagegoryID,ParentCagegoryName,ParentCagegoryID,StoreID,CategoryName,DictContent,Quantity,Amount,LotNumber,TicketCode) Values (@O0TG6Unit,@O0TG6GoodsCode,@O0TG6GoodsName,@O0TG6TicTicketCode,@O0TG6CagegoryID,@O0TG6ParentCagegoryName,@O0TG6ParentCagegoryID,@O0TG6StoreID,@O0TG6CategoryName,@O0TG6DictContent,@O0TG6Quantity,@O0TG6Amount,@O0TG6LotNumber,@O0TG6TicketCode) ,SYDP002591,干贡菜(绿箱),RK20240827012,SYDPEJ00022,干杂水发,SYDPYJ00003,5,其他干杂,1.5kg/箱,1,0,20240827,RK2024082700012

Insert Into GoodsBuyBalancePriceInf(PriceTime,CustomerCode,BalancePrice,AddUserName,DictContent,LastNum,DictID,RkTicketCode,LastPrice,GoodsCode,AddModifyTime,GoodsName) Values (@S07PriceTime,@S07CustomerCode,@S07BalancePrice,@S07AddUserName,@S07DictContent,@S07LastNum,@S07DictID,@S07RkTicketCode,@S07LastPrice,@S07GoodsCode,@S07AddModifyTime,@S07GoodsName) 2024/8/27 11:56:24,SYDP,130.00,陈万强,1.5kg/箱,0,,RT2024082100008,0,SYDP002591,2024/8/27 11:56:24,干贡菜(绿箱)



System.Data.SqlClient.SqlException (0x80131904): 列名 'StoreID' 无效。 在 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:行号 275 ClientConnectionId:25ad3716-b227-4184-a213-8ba266bfe064 Error Number:207,State:1,Class:16