2025-08-27 10:00:07 执行时长：6.25秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],审核计划.[BeginDate] AS [审核开始日期],审核计划.[ContractNo] AS [合同编号],[审核类别_审核类别].ClassName AS [审核类别],[标准代码_认证标准].StandardCode AS [标准代码],[认可标志_认可标志].RecogName AS [认可标志],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanRemarks] AS [计划备注],审核计划.[EndDate] AS [审核结束日期],[合同来源_合同来源].OrgName AS [合同来源],审核计划.[ChangeInfo] AS [变更描述],审核计划.[PlanNo] AS [计划编号],审核计划.[CertiInfo] AS [证书信息],[评定状态_评定状态].StatusName AS [评定状态],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK) LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'') AND ( [计划状态_计划状态].[StatusCode] >= ''10'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[组织名称] DESC,[审核开始日期] DESC,[审核类别] DESC,[申请单号] ASC,[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK) LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'') AND ( [计划状态_计划状态].[StatusCode] >= ''10'')' 2025-08-27 10:01:31 执行时长：6.67秒 sql:exec GB_PartnerBizStatistics '2025','ISC[S]0044' concreteDbConn状态:Open 2025-08-27 10:03:01 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[EmploymentDate] AS [聘用日期],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] AS [解聘日期],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN GB_AuditorRegister [注册与保持] WITH(NOLOCK) ON 人员信息表.AuditorCode = [注册与保持].AuditorCode WHERE ((([注册与保持].[Org] = '30' OR [人员信息表].[IsPublic] =1 ))) AND (([人员归属_领域归属].[OSName] like '%测量人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 concreteDbConn状态:Open 2025-08-27 10:03:12 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[EmploymentDate] AS [聘用日期],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] AS [解聘日期],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN GB_AuditorRegister [注册与保持] WITH(NOLOCK) ON 人员信息表.AuditorCode = [注册与保持].AuditorCode WHERE ((([注册与保持].[Org] = '30' OR [人员信息表].[IsPublic] =1 ))) AND (([人员归属_领域归属].[OSName] like '%测量人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%广东省%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 concreteDbConn状态:Open 2025-08-27 10:03:14 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[EmploymentDate] AS [聘用日期],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] AS [解聘日期],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN GB_AuditorRegister [注册与保持] WITH(NOLOCK) ON 人员信息表.AuditorCode = [注册与保持].AuditorCode WHERE ((([注册与保持].[Org] = '30' OR [人员信息表].[IsPublic] =1 ))) AND (([人员归属_领域归属].[OSName] like '%测量人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%广东省%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 concreteDbConn状态:Open 2025-08-27 10:03:15 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[EmploymentDate] AS [聘用日期],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] AS [解聘日期],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN GB_AuditorRegister [注册与保持] WITH(NOLOCK) ON 人员信息表.AuditorCode = [注册与保持].AuditorCode WHERE ((([注册与保持].[Org] = '30' OR [人员信息表].[IsPublic] =1 ))) AND (([人员归属_领域归属].[OSName] like '%测量人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%广东省%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 concreteDbConn状态:Open 2025-08-27 10:03:19 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[EmploymentDate] AS [聘用日期],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] AS [解聘日期],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN GB_AuditorRegister [注册与保持] WITH(NOLOCK) ON 人员信息表.AuditorCode = [注册与保持].AuditorCode WHERE ((([注册与保持].[Org] = '30' OR [人员信息表].[IsPublic] =1 ))) AND (([人员归属_领域归属].[OSName] like '%测量人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%广东省%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 2025-08-27 10:04:44 执行时长：11.14秒 sql:exec [GB_AuditorSchedule] '','','','','','','','','ISC-418501' concreteDbConn状态:Open 2025-08-27 10:07:06 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[EmploymentDate] AS [聘用日期],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] AS [解聘日期],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode WHERE ([人员归属_领域归属].[OSName] like '%测量人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 concreteDbConn状态:Open 2025-08-27 10:07:11 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[EmploymentDate] AS [聘用日期],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] AS [解聘日期],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode WHERE ([人员归属_领域归属].[OSName] like '%测量人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%广东省%') ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 concreteDbConn状态:Open 2025-08-27 10:07:20 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[EmploymentDate] AS [聘用日期],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] AS [解聘日期],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode WHERE ([人员归属_领域归属].[OSName] like '%测量人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%广东省%') ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 concreteDbConn状态:Open 2025-08-27 10:07:30 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[EmploymentDate] AS [聘用日期],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] AS [解聘日期],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode WHERE (EXISTS (SELECT 1 FROM GB_AuditorRegister WHERE [人员信息表].auditorcode = GB_AuditorRegister.auditorcode AND standardcode = '60') AND EXISTS (SELECT 1 FROM GB_AuditorRegister WHERE [人员信息表].auditorcode = GB_AuditorRegister.auditorcode AND standardcode = '65')) and (([人员归属_领域归属].[OSName] like '%测量人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%广东省%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 concreteDbConn状态:Open 2025-08-27 10:07:48 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[EmploymentDate] AS [聘用日期],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] AS [解聘日期],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode WHERE (EXISTS (SELECT 1 FROM GB_AuditorRegister WHERE [人员信息表].auditorcode = GB_AuditorRegister.auditorcode AND standardcode = '60') AND EXISTS (SELECT 1 FROM GB_AuditorRegister WHERE [人员信息表].auditorcode = GB_AuditorRegister.auditorcode AND standardcode = '65')) and (([人员归属_领域归属].[OSName] like '%测量人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 concreteDbConn状态:Open 2025-08-27 10:10:02 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[EmploymentDate] AS [聘用日期],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] AS [解聘日期],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode WHERE (EXISTS (SELECT 1 FROM GB_AuditorRegister WHERE [人员信息表].auditorcode = GB_AuditorRegister.auditorcode AND standardcode = '60') AND EXISTS (SELECT 1 FROM GB_AuditorRegister WHERE [人员信息表].auditorcode = GB_AuditorRegister.auditorcode AND standardcode = '65')) and (([人员归属_领域归属].[OSName] like '%测量人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%广东省%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 concreteDbConn状态:Open 2025-08-27 10:10:07 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[EmploymentDate] AS [聘用日期],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] AS [解聘日期],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode WHERE (EXISTS (SELECT 1 FROM GB_AuditorRegister WHERE [人员信息表].auditorcode = GB_AuditorRegister.auditorcode AND standardcode = '60') AND EXISTS (SELECT 1 FROM GB_AuditorRegister WHERE [人员信息表].auditorcode = GB_AuditorRegister.auditorcode AND standardcode = '65')) and (([人员归属_领域归属].[OSName] like '%测量人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%广东省%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 2025-08-27 10:19:05 执行时长：9.89秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'0352-2022-Q-Q_11469') delete from GB_ProjectPlanCerti where ProjectNo = N'0352-2022-Q-Q_11469' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'0352-2022-Q-Q_11469') delete from GB_ProjectPlanCerti where ProjectNo = N'0352-2022-Q-Q_11469' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'0352-2022-Q-Q_11469') delete from GB_CertiDoc where ProjectNo = N'0352-2022-Q-Q_11469' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'0352-2022-Q-Q_11469-500') delete from GB_ProjectPlanEnergy where PlanNo = N'0352-2022-Q-Q_11469-500' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_AuditProblem where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_AuditProblem where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_InvalidDoc where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_AuditorContactRecord where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_AuditProblem where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_AuditorContactRecord where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanCombine where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f') delete from GB_ProjectPlanTeam where TaskNo = N'd989c3c654ac4fddb94014eb0f4da18f' DELETE FROM GB_ProjectPlan WHERE ID='508001457' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='508001457' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='508001457' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='508001457' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='508001457') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='508001457' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='508001457') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='508001457' 2025-08-27 10:19:06 执行时长：9.48秒 sql:delete from base_bizcolumnattach where AccessPath='GB_PlanDoc' and KeyValue='508014177' and DataColumnID='002202' insert into base_bizcolumnattach (id,bizentityid,keyvalue,DataColumnID,filename,createby,accesspath) values ('200bbe4397c5510bca7','000020008','508014177','002202','附件：职业病体检报告.pdf','单迎珍','GB_PlanDoc') 2025-08-27 10:24:28 执行时长：7.64秒 sql:exec [GB_AuditorSchedule] '2025-08-01','','','','','','123','0.5','ISC[S]0044' 2025-08-27 10:33:36 执行时长：12.36秒 sql:exec [GB_AuditorSchedule] '2025-08-01','2025-09-08','','','','','','0.5','ISC0601'