2025-03-24 11:19:33,372 [92] 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-03-24 11:19:33,374 [92] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list'
2025-03-24 11:19:33,374 [92] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'wagecommis0_.StaffSellerType' in 'field list'
2025-03-24 11:19:33,374 [92] 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.<GetList>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_method660(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.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)