2025-11-03 09:37:00 执行时长：5.28秒 sql:select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类  from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID   left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode   left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode   left join Pub_Province e on a.Province=e.ProvinceCode   left join Base_Org f on a.Org=f.OrgID   left join Pub_Code g on a.WorkType=g.CodeID  left join  GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-11-03' and IsEffective='27'   left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode   left join Pub_ProfessionalCode j on i.professionalcode=j.id   where 1=1  and a.AuditorCode in (SELECT AuditorCode  FROM GB_AuditorRegister  WHERE StandardCode IN('57','58','72') and IsEffective = '27'  GROUP BY AuditorCode  HAVING COUNT(DISTINCT StandardCode) >= 3)  and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join   Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) and a.auditorcode in  (  SELECT auditorcode  FROM GB_AuditorProfessional a left join Pub_ProfessionalCode b on a.ProfessionalCode=b.id  WHERE b.ProfessionalCode IN( '12.03.00' ) and b.FieldCode='E'  GROUP BY auditorcode  HAVING COUNT(DISTINCT b.ProfessionalCode) >= 1) and a.auditorcode in  (  SELECT auditorcode  FROM GB_AuditorProfessional a left join Pub_ProfessionalCode b on a.ProfessionalCode=b.id  WHERE b.ProfessionalCode IN( '12.03.00' ) and b.FieldCode='Q'  GROUP BY auditorcode  HAVING COUNT(DISTINCT b.ProfessionalCode) >= 1) and a.auditorcode in  (  SELECT auditorcode  FROM GB_AuditorProfessional a left join Pub_ProfessionalCode b on a.ProfessionalCode=b.id  WHERE b.ProfessionalCode IN( '12.03.00' ) and b.FieldCode='O'  GROUP BY auditorcode  HAVING COUNT(DISTINCT b.ProfessionalCode) >= 1)  group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName,  a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount

2025-11-03 09:51:34 执行时长：7.27秒 sql:exec [GB_AuditorSchedule] '2025-11-01','','','','','','123','0.5','ISC0001'
2025-11-03 09:52:07
Sql：delete from base_bizcolumnattach where AccessPath='GB_PlanDoc' and KeyValue='511000820' and DataColumnID='002202'
Error：事务(进程 ID 67)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。
   在 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   在 Redsoft.DatabaseProvider.DbAccess.Execute(String[] sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 667
2025-11-03 09:52:12
Sql：delete from base_bizcolumnattach where AccessPath='GB_PlanDoc' and KeyValue='511000821' and DataColumnID='002202'
Error：事务(进程 ID 67)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。
   在 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   在 Redsoft.DatabaseProvider.DbAccess.Execute(String[] sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 667