2025-08-27 14:13:22,657 [120] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9) MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:13:22,661 [120] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:13:22,661 [120] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:13:22,668 [120] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:13:26,523 [266] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9) MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:13:26,524 [266] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:13:26,524 [266] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:13:26,525 [266] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:13:27,650 [73] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9) MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:13:27,653 [73] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:13:27,653 [73] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:13:27,654 [73] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:13:44,167 [375] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId`=?p0 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:13:44,168 [375] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:13:44,168 [375] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:13:44,169 [375] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId`=?] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:13:52,437 [111] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: INSERT INTO `WageCommissionDetail` (`DepartmentId`, `DepartmentName`, `StaffId`, `StaffName`, `StaffMobilePhone`, `StaffNumber`, `StaffStatus`, `NormalOrderTotal`, `AttachOrderTotal`, `NormalOrderCommission`, `PieceWage`, `ManageWage`, `SpecialWage`, `AttachOrderCommission`, `OtherIncome`, `ValidTotalNew`, `ValidTotalCommission`, `InvalidTotal`, `InvalidTotalCommission`, `ExtraCommission`, `OtherDeduction`, `PayWage`, `OrderCount`, `ClueCount`, `FGCount`, `OrderClueRate`, `FGTotal`, `AllOrderNumber`, `FGOrderNumber`, `FGProduct`, `StaffSellerType`, `SecondCount`, `SecondOrderTotal`, `SecondMainOrderTotal`, `SecondOrderNumber`, `Note`, `NoticeStatus`, `NoticeNote`, `NoticeTime`, `WageCommissionId`) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11, ?p12, ?p13, ?p14, ?p15, ?p16, ?p17, ?p18, ?p19, ?p20, ?p21, ?p22, ?p23, ?p24, ?p25, ?p26, ?p27, ?p28, ?p29, ?p30, ?p31, ?p32, ?p33, ?p34, ?p35, ?p36, ?p37, ?p38, ?p39);SELECT LAST_INSERT_ID() MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:13:52,439 [111] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'StaffSellerType' in 'field list' 2025-08-27 14:13:52,467 [111] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/CreateWageCommission;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not insert: [MCMS.Finance.Entities.WageCommissionDetail][SQL: INSERT INTO `WageCommissionDetail` (`DepartmentId`, `DepartmentName`, `StaffId`, `StaffName`, `StaffMobilePhone`, `StaffNumber`, `StaffStatus`, `NormalOrderTotal`, `AttachOrderTotal`, `NormalOrderCommission`, `PieceWage`, `ManageWage`, `SpecialWage`, `AttachOrderCommission`, `OtherIncome`, `ValidTotalNew`, `ValidTotalCommission`, `InvalidTotal`, `InvalidTotalCommission`, `ExtraCommission`, `OtherDeduction`, `PayWage`, `OrderCount`, `ClueCount`, `FGCount`, `OrderClueRate`, `FGTotal`, `AllOrderNumber`, `FGOrderNumber`, `FGProduct`, `StaffSellerType`, `SecondCount`, `SecondOrderTotal`, `SecondMainOrderTotal`, `SecondOrderNumber`, `Note`, `NoticeStatus`, `NoticeNote`, `NoticeTime`, `WageCommissionId`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);SELECT LAST_INSERT_ID()] at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session) at NHibernate.Action.EntityIdentityInsertAction.Execute() at NHibernate.Engine.ActionQueue.InnerExecute(IExecutable executable) at NHibernate.Engine.ActionQueue.Execute(IExecutable executable) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSave(Object entity, Object id, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.FireSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.SaveOrUpdate(String entityName, Object obj) at NHibernate.Engine.CascadingAction.SaveUpdateCascadingAction.Cascade(IEventSource session, Object child, String entityName, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeToOne(Object parent, Object child, IType type, CascadeStyle style, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeAssociation(Object parent, Object child, IType type, CascadeStyle style, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeProperty(Object parent, Object child, IType type, CascadeStyle style, String propertyName, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeCollectionElements(Object parent, Object child, CollectionType collectionType, CascadeStyle style, IType elemType, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeCollection(Object parent, Object child, CascadeStyle style, Object anything, CollectionType type) at NHibernate.Engine.Cascade.CascadeAssociation(Object parent, Object child, IType type, CascadeStyle style, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeProperty(Object parent, Object child, IType type, CascadeStyle style, String propertyName, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeOn(IEntityPersister persister, Object parent, Object anything) at NHibernate.Event.Default.AbstractSaveEventListener.CascadeAfterSave(IEventSource source, IEntityPersister persister, Object entity, Object anything) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSave(Object entity, Object id, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.FireSave(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.Save(Object obj) at MCMS.Finance.DAO.Hibernate.GenericHibernateDAO`2.Insert(T entity) in E:\agent\_work\5\s\MCMS.Finance.DAO.Hibernate\Common\GenericHibernateDAO.cs:line 183 at MCMS.Finance.Service.Impl.WageCommissionService.Add(WageCommission entity) in E:\agent\_work\5\s\MCMS.Finance.Service.Impl\WageCommissionService.cs:line 177 at MCMS.Finance.Service.Impl.WageCommissionService.CreateWageCommission(DateTime month, Int32 opUserId, String opUserName, Nullable`1 useDepartmentId, IList`1 orderInfos, String& msg) in E:\agent\_work\5\s\MCMS.Finance.Service.Impl\WageCommissionService.cs:line 608 at _dynamic_MCMS.Finance.Service.Impl.WageCommissionService.CreateWageCommission(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_b6c4a3de0e064908a40f7b07747ce987.CreateWageCommission(DateTime month, Int32 opUserId, String opUserName, Nullable`1 useDepartmentId, IList`1 orderInfos, String& msg) at MCMS.Finance.Controllers.WageCommissionController.CreateWageCommission(WageCommissionPostDto pars) at lambda_method661(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:00,401 [375] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId`=?p0 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:00,403 [375] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:00,403 [375] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:00,404 [375] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId`=?] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:07,354 [111] INFO MCMS.Finance.Service.Impl.WageCommissionService - 提成线索系数：[{"PromotionChannelType":0,"PromotionClueNum":1.0,"PromotionProtectDay":2,"PromotionCustomerNum":0.0},{"PromotionChannelType":1,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":2,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":3,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":4,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":5,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":6,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":7,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":8,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":9,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":10,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":11,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":12,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":13,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":14,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":15,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":16,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":17,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":18,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":19,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":20,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":21,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":22,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":23,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":30,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":31,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":32,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":33,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":40,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":41,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":42,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":43,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0},{"PromotionChannelType":44,"PromotionClueNum":0.0,"PromotionProtectDay":0,"PromotionCustomerNum":0.0}] 2025-08-27 14:14:07,686 [193] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId`=?p0 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:07,687 [193] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:07,687 [193] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:07,688 [193] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId`=?] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:09,170 [375] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId`=?p0 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:09,173 [375] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:09,173 [375] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:09,174 [375] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId`=?] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:09,996 [231] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId`=?p0 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:09,998 [231] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:09,998 [231] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:09,998 [231] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId`=?] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:10,878 [120] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId`=?p0 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:10,879 [120] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:10,879 [120] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:10,880 [120] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId`=?] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:13,489 [306] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9) MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:13,490 [306] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:13,491 [306] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:13,491 [306] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:22,359 [306] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9) MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:22,361 [306] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:22,361 [306] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:22,362 [306] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:23,059 [193] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9) MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:23,061 [193] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:23,061 [193] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:23,062 [193] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:23,727 [306] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9) MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:23,729 [306] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:23,729 [306] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:23,729 [306] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:24,870 [306] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9) MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:24,872 [306] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:24,872 [306] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:24,873 [306] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:27,650 [231] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9) MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:27,652 [231] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:27,653 [231] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:27,654 [231] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:37,058 [193] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9) MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:37,059 [193] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:37,059 [193] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:37,060 [193] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:38,541 [266] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9) MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:38,543 [266] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:38,543 [266] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 14:14:38,543 [266] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 14:14:40,744 [111] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: INSERT INTO `WageCommissionDetail` (`DepartmentId`, `DepartmentName`, `StaffId`, `StaffName`, `StaffMobilePhone`, `StaffNumber`, `StaffStatus`, `NormalOrderTotal`, `AttachOrderTotal`, `NormalOrderCommission`, `PieceWage`, `ManageWage`, `SpecialWage`, `AttachOrderCommission`, `OtherIncome`, `ValidTotalNew`, `ValidTotalCommission`, `InvalidTotal`, `InvalidTotalCommission`, `ExtraCommission`, `OtherDeduction`, `PayWage`, `OrderCount`, `ClueCount`, `FGCount`, `OrderClueRate`, `FGTotal`, `AllOrderNumber`, `FGOrderNumber`, `FGProduct`, `StaffSellerType`, `SecondCount`, `SecondOrderTotal`, `SecondMainOrderTotal`, `SecondOrderNumber`, `Note`, `NoticeStatus`, `NoticeNote`, `NoticeTime`, `WageCommissionId`) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11, ?p12, ?p13, ?p14, ?p15, ?p16, ?p17, ?p18, ?p19, ?p20, ?p21, ?p22, ?p23, ?p24, ?p25, ?p26, ?p27, ?p28, ?p29, ?p30, ?p31, ?p32, ?p33, ?p34, ?p35, ?p36, ?p37, ?p38, ?p39);SELECT LAST_INSERT_ID() MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 14:14:40,746 [111] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'StaffSellerType' in 'field list' 2025-08-27 14:14:40,753 [111] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/CreateWageCommissionNew;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not insert: [MCMS.Finance.Entities.WageCommissionDetail][SQL: INSERT INTO `WageCommissionDetail` (`DepartmentId`, `DepartmentName`, `StaffId`, `StaffName`, `StaffMobilePhone`, `StaffNumber`, `StaffStatus`, `NormalOrderTotal`, `AttachOrderTotal`, `NormalOrderCommission`, `PieceWage`, `ManageWage`, `SpecialWage`, `AttachOrderCommission`, `OtherIncome`, `ValidTotalNew`, `ValidTotalCommission`, `InvalidTotal`, `InvalidTotalCommission`, `ExtraCommission`, `OtherDeduction`, `PayWage`, `OrderCount`, `ClueCount`, `FGCount`, `OrderClueRate`, `FGTotal`, `AllOrderNumber`, `FGOrderNumber`, `FGProduct`, `StaffSellerType`, `SecondCount`, `SecondOrderTotal`, `SecondMainOrderTotal`, `SecondOrderNumber`, `Note`, `NoticeStatus`, `NoticeNote`, `NoticeTime`, `WageCommissionId`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);SELECT LAST_INSERT_ID()] at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session) at NHibernate.Action.EntityIdentityInsertAction.Execute() at NHibernate.Engine.ActionQueue.InnerExecute(IExecutable executable) at NHibernate.Engine.ActionQueue.Execute(IExecutable executable) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSave(Object entity, Object id, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.FireSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.SaveOrUpdate(String entityName, Object obj) at NHibernate.Engine.CascadingAction.SaveUpdateCascadingAction.Cascade(IEventSource session, Object child, String entityName, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeToOne(Object parent, Object child, IType type, CascadeStyle style, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeAssociation(Object parent, Object child, IType type, CascadeStyle style, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeProperty(Object parent, Object child, IType type, CascadeStyle style, String propertyName, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeCollectionElements(Object parent, Object child, CollectionType collectionType, CascadeStyle style, IType elemType, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeCollection(Object parent, Object child, CascadeStyle style, Object anything, CollectionType type) at NHibernate.Engine.Cascade.CascadeAssociation(Object parent, Object child, IType type, CascadeStyle style, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeProperty(Object parent, Object child, IType type, CascadeStyle style, String propertyName, Object anything, Boolean isCascadeDeleteEnabled) at NHibernate.Engine.Cascade.CascadeOn(IEntityPersister persister, Object parent, Object anything) at NHibernate.Event.Default.AbstractSaveEventListener.CascadeAfterSave(IEventSource source, IEntityPersister persister, Object entity, Object anything) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSave(Object entity, Object id, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.FireSave(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.Save(Object obj) at MCMS.Finance.DAO.Hibernate.GenericHibernateDAO`2.Insert(T entity) in E:\agent\_work\5\s\MCMS.Finance.DAO.Hibernate\Common\GenericHibernateDAO.cs:line 183 at MCMS.Finance.Service.Impl.WageCommissionService.Add(WageCommission entity) in E:\agent\_work\5\s\MCMS.Finance.Service.Impl\WageCommissionService.cs:line 177 at MCMS.Finance.Service.Impl.WageCommissionService.CreateWageCommissionNew(DateTime month, Int32 opUserId, String opUserName, Nullable`1 useDepartmentId, IList`1 orderInfos, String& msg) in E:\agent\_work\5\s\MCMS.Finance.Service.Impl\WageCommissionService.cs:line 1213 at _dynamic_MCMS.Finance.Service.Impl.WageCommissionService.CreateWageCommissionNew(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_b6c4a3de0e064908a40f7b07747ce987.CreateWageCommissionNew(DateTime month, Int32 opUserId, String opUserName, Nullable`1 useDepartmentId, IList`1 orderInfos, String& msg) at MCMS.Finance.Controllers.WageCommissionController.CreateWageCommissionNew(WageCommissionPostDto pars) at lambda_method903(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-08-27 15:51:28,522 [187] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9) MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'wagecommis0_.StaffSellerType' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-08-27 15:51:28,524 [187] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 15:51:28,524 [187] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list' 2025-08-27 15:51:28,525 [187] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WageCommission/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not initialize a collection batch: [MCMS.Finance.Entities.WageCommission.WageCommissionDetails#System.Object[]][SQL: SELECT wagecommis0_.`WageCommissionId` as WageCommissionId41_25_1_, wagecommis0_.Id as id1_25_1_, wagecommis0_.Id as id1_25_0_, wagecommis0_.`DepartmentId` as DepartmentId2_25_0_, wagecommis0_.`DepartmentName` as DepartmentName3_25_0_, wagecommis0_.`StaffId` as StaffId4_25_0_, wagecommis0_.`StaffName` as StaffName5_25_0_, wagecommis0_.`StaffMobilePhone` as StaffMobilePhone6_25_0_, wagecommis0_.`StaffNumber` as StaffNumber7_25_0_, wagecommis0_.`StaffStatus` as StaffStatus8_25_0_, wagecommis0_.`NormalOrderTotal` as NormalOrderTotal9_25_0_, wagecommis0_.`AttachOrderTotal` as AttachOrderTotal10_25_0_, wagecommis0_.`NormalOrderCommission` as NormalOrderCommission11_25_0_, wagecommis0_.`PieceWage` as PieceWage12_25_0_, wagecommis0_.`ManageWage` as ManageWage13_25_0_, wagecommis0_.`SpecialWage` as SpecialWage14_25_0_, wagecommis0_.`AttachOrderCommission` as AttachOrderCommission15_25_0_, wagecommis0_.`OtherIncome` as OtherIncome16_25_0_, wagecommis0_.`ValidTotalNew` as ValidTotalNew17_25_0_, wagecommis0_.`ValidTotalCommission` as ValidTotalCommission18_25_0_, wagecommis0_.`InvalidTotal` as InvalidTotal19_25_0_, wagecommis0_.`InvalidTotalCommission` as InvalidTotalCommission20_25_0_, wagecommis0_.`ExtraCommission` as ExtraCommission21_25_0_, wagecommis0_.`OtherDeduction` as OtherDeduction22_25_0_, wagecommis0_.`PayWage` as PayWage23_25_0_, wagecommis0_.`OrderCount` as OrderCount24_25_0_, wagecommis0_.`ClueCount` as ClueCount25_25_0_, wagecommis0_.`FGCount` as FGCount26_25_0_, wagecommis0_.`OrderClueRate` as OrderClueRate27_25_0_, wagecommis0_.`FGTotal` as FGTotal28_25_0_, wagecommis0_.`AllOrderNumber` as AllOrderNumber29_25_0_, wagecommis0_.`FGOrderNumber` as FGOrderNumber30_25_0_, wagecommis0_.`FGProduct` as FGProduct31_25_0_, wagecommis0_.`StaffSellerType` as StaffSellerType32_25_0_, wagecommis0_.`SecondCount` as SecondCount33_25_0_, wagecommis0_.`SecondOrderTotal` as SecondOrderTotal34_25_0_, wagecommis0_.`SecondMainOrderTotal` as SecondMainOrderTotal35_25_0_, wagecommis0_.`SecondOrderNumber` as SecondOrderNumber36_25_0_, wagecommis0_.`Note` as Note37_25_0_, wagecommis0_.`NoticeStatus` as NoticeStatus38_25_0_, wagecommis0_.`NoticeNote` as NoticeNote39_25_0_, wagecommis0_.`NoticeTime` as NoticeTime40_25_0_, wagecommis0_.`WageCommissionId` as WageCommissionId41_25_0_ FROM `WageCommissionDetail` wagecommis0_ WHERE wagecommis0_.`WageCommissionId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at NHibernate.Loader.Loader.LoadCollectionBatch(ISessionImplementor session, Object[] ids, IType type) at NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) at NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) at NHibernate.Collection.AbstractPersistentCollection.ReadSize() at NHibernate.Collection.Generic.PersistentGenericBag`1.get_Count() at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source) at MCMS.Finance.Controllers.WageCommissionController.<>c.b__5_0(WageCommission w) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 152 at System.Linq.Enumerable.SelectListIterator`2.ToList() at MCMS.Finance.Controllers.WageCommissionController.GetList(WagePrimarySearchDto pars) in E:\agent\_work\5\s\MCMS.Finance\Controllers\WageCommissionController.cs:line 131 at lambda_method122(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)