2025-07-24 13:23:15 执行时长：7.25秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U'

2025-07-24 13:23:17 执行时长：9.85秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-495970' where (e.roleid in ('06') or b.operatorid='ISC-495970') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-495970')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-495970' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2025-07-24 13:23:21 执行时长：7.59秒 sql:SELECT  distinct ShortcutNo,BizEntityName ,a.BizEntityID  ,BizClass  FROM Base_Shortcut a LEFT JOIN Base_BizEntity b ON a.BizEntity = b.ID  WHERE(a.IsPrivate = 0 OR a.Createby = '王邦权')  order by ShortcutNo

2025-07-24 13:33:01 执行时长：5.27秒 sql:select * from Base_BizentityCustom where BizEntityID='006001' and UserID='' and propertyname='ListWithSubData'

2025-07-24 13:33:02 执行时长：5.55秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[CertiQty] AS [体系人数],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[AuditTeam] AS [审核组],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[CommitDate] AS [审核员交卷日期] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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 Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-456075') AND ([审核计划].BeginDate>='2025-07-01 00:00') ) as CurrentCount

2025-07-24 13:47:21 执行时长：6.11秒 sql:select count(*) from ( SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE (( [证书信息].org ='0001'  or [证书信息].org ='01'  or [证书信息].org ='02'  or [证书信息].org ='03'  or [证书信息].org ='04'  or [证书信息].org ='05'  or [证书信息].org ='20'  or [证书信息].org ='21'  or [证书信息].org ='22'  or [证书信息].org ='23'  or [证书信息].org ='25'  or [证书信息].org ='2501'  or [证书信息].org ='26'  or [证书信息].org ='27'  or [证书信息].org ='29'  or [证书信息].org ='30'  or [证书信息].org ='301'  or [证书信息].org ='302'  or [证书信息].org ='303'  or [证书信息].org ='304'  or [证书信息].org ='305'  or [证书信息].org ='306'  or [证书信息].org ='307'  or [证书信息].org ='308'  or [证书信息].org ='309'  or [证书信息].org ='31'  or [证书信息].org ='310'  or [证书信息].org ='311'  or [证书信息].org ='312'  or [证书信息].org ='313'  or [证书信息].org ='315'  or [证书信息].org ='316'  or [证书信息].org ='32'  or [证书信息].org ='40'  or [证书信息].org ='41'  or [证书信息].org ='42'  or [证书信息].org ='43'  or [证书信息].org ='4301'  or [证书信息].org ='4302'  or [证书信息].org ='4303'  or [证书信息].org ='44'  or [证书信息].org ='45'  or [证书信息].org ='46'  or [证书信息].org ='48'  or [证书信息].org ='49'  or [证书信息].org ='50' )) AND ((证书信息.StandardCode = '77') and ( [证书信息].CertiNo like '%6661%' and ([证书状态_证书状态].[StatusName] like '%有效%'))) ) as CurrentCount

2025-07-24 13:47:23 执行时长：17.18秒 sql:SELECT DISTINCT 审核计划.ID  FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode 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 LEFT JOIN GB_ProjectPlanTeam [审核组组成] ON 审核计划.TaskNo = [审核组组成].TaskNo LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_AuditorContactRecord [审核员联系记录] ON 审核计划.TaskNo = [审核员联系记录].TaskNo WHERE ([审核计划].[PlanStatus] > '02' AND [审核类型_审核类型].[TypeName] <> '变更') AND ( 1=2  or 审核计划.[BizAddress] like '%王冰%'  or 审核计划.[AcceptDate] like '%王冰%'  or 审核计划.[CheckDate] like '%王冰%'  or 审核计划.[SuperNoticeDate] like '%王冰%'  or 审核计划.[SuperCommitDate] like '%王冰%'  or [计划状态_计划状态].StatusName like '%王冰%' or [评定状态_评定状态].StatusName like '%王冰%' or [组织名称_组织信息].CorpName like '%王冰%' or 审核计划.[PlanNo] like '%王冰%'  or [标准代码_认证标准].StandardCode like '%王冰%' or [审核类型_审核类型].TypeName like '%王冰%' or [审核类别_审核类别].ClassName like '%王冰%' or 审核计划.[BeginDate] like '%王冰%'  or 审核计划.[EndDate] like '%王冰%'  or 审核计划.[ApproveDays] like '%王冰%'  or 审核计划.[AuditTeam] like '%王冰%'  or [审核方式_审核方式].ApproveMode like '%王冰%' or [合同来源_合同来源].OrgName like '%王冰%' or [省份_省份].Province like '%王冰%' or 审核计划.[ProfessionalCode] like '%王冰%'  or 审核计划.[CertiQty] like '%王冰%'  or [风险等级_代码表].CodeName like '%王冰%' or 审核计划.[IssuesToBeNoted] like '%王冰%'  or 审核计划.[PlanRemarks] like '%王冰%'  or 审核计划.[StandardName] like '%王冰%'  or 审核计划.[BasicDays] like '%王冰%'  or 审核计划.[FirstOffSiteHumanDays] like '%王冰%'  or 审核计划.[FirstStageOnsiteDays] like '%王冰%'  or 审核计划.[SecondStageDays] like '%王冰%'  or 审核计划.[SupervisoryDays] like '%王冰%'  or 审核计划.[ReexaminationDays] like '%王冰%'  or 审核计划.[TotalDays] like '%王冰%'  or [申请单号_认证申请].ApplyNo like '%王冰%' or [项目编号_认证项目].ProjectNo like '%王冰%' or 审核计划.[ContractNo] like '%王冰%'  or 审核计划.[TaskNo] like '%王冰%'  or 审核计划.[ApproveRange] like '%王冰%'  or 审核计划.[ReportDate] like '%王冰%'  or 审核计划.[CertiFee] like '%王冰%'  or 审核计划.[ReturnDate] like '%王冰%'  or 审核计划.[ReasonForReturn] like '%王冰%'  or 审核计划.[DispatchBy] like '%王冰%'  or 审核计划.[DispatchDate] like '%王冰%'  or 审核计划.[Approver] like '%王冰%'  or 审核计划.[ApproveDate] like '%王冰%'  or 审核计划.[PlanApproveDate] like '%王冰%'  or [联系结果_联系结果].ResultName like '%王冰%' or 审核计划.[ToScheduleDate] like '%王冰%'  or 审核计划.[ProjectLeader] like '%王冰%'  or 审核计划.[PlanReturnReason] like '%王冰%'  or 审核计划.[ToScheduleInfo] like '%王冰%'  or [认可标志_认可标志].RecogName like '%王冰%' or [认证领域_认证领域].FieldName like '%王冰%' or 审核计划.[FeeDate] like '%王冰%'  or 审核计划.[ChangeInfo] like '%王冰%'  or 审核计划.[SuperQty] like '%王冰%'  or 审核计划.[ReviewRemarks] like '%王冰%'  or 审核计划.[ReCertiQty] like '%王冰%'  or [阅卷人员_登录用户].UserName like '%王冰%' or 审核计划.[SupportBy] like '%王冰%'  or [评定人员_登录用户].UserName like '%王冰%' or 审核计划.[RetrivalDate] like '%王冰%'  or 审核计划.[ReceiveDate] like '%王冰%'  or 审核计划.[DocReceiveBy] like '%王冰%'  or 审核计划.[DistributeOn] like '%王冰%'  or 审核计划.[ReasonsForAuditFailure] like '%王冰%'  or 审核计划.[UrgentReason] like '%王冰%'  or 审核计划.[AcceptanceEvaluationTime] like '%王冰%'  or 审核计划.[PlanCommitDate] like '%王冰%'  or 审核计划.[CommitDate] like '%王冰%'  or 审核计划.[ScopeOfEvaluation] like '%王冰%'  or [项目分级_案卷质量].LevelName like '%王冰%' or [组长分级_案卷质量].LevelName like '%王冰%' or [案卷质量_案卷质量].LevelName like '%王冰%' or 审核计划.[ProfessionalEvaluation] like '%王冰%'  or 审核计划.[ReviewDate] like '%王冰%'  or 审核计划.[DocReturnDate] like '%王冰%'  or 审核计划.[ReturnContractQty] like '%王冰%'  or 审核计划.[DocReceiveRemark] like '%王冰%'  or 审核计划.[DecideOn] like '%王冰%'  or [批准结论_批准结论].ResultName like '%王冰%' or 审核计划.[ReturnReason] like '%王冰%'  or 审核计划.[UnPassReason] like '%王冰%'  or 审核计划.[ProcessResult] like '%王冰%'  or 审核计划.[SuperviseEndDate] like '%王冰%'  or 审核计划.[NextApproveType] like '%王冰%'  or 审核计划.[NextApproveDate] like '%王冰%'  or 审核计划.[CertiInfo] like '%王冰%'  or 审核计划.[CertiAcceptanceDate] like '%王冰%'  or 审核计划.[CertiCompletionDate] like '%王冰%'  or 审核计划.[NonCompliantTerms] like '%王冰%'  or 审核计划.[NextAuditAdvice] like '%王冰%'  or 审核计划.[NextAuditFocus] like '%王冰%'  or 审核计划.[ReformDate] like '%王冰%'  or 审核计划.[FromChangeNo] like '%王冰%'  or 审核计划.[ReceiveDateI] like '%王冰%'  or [合同申请接收人_登录用户].UserName like '%王冰%' or 审核计划.[MoveDate] like '%王冰%'  or 审核计划.[HandOverBy] like '%王冰%'  or 审核计划.[MailingInformation] like '%王冰%'  or 审核计划.[FollowUpTracking] like '%王冰%'  or [跟踪结果_跟踪结果].StatusName like '%王冰%')

2025-07-24 13:47:28 执行时长：5.35秒 sql:SELECT DISTINCT 审核计划.ID  FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode 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 LEFT JOIN GB_ProjectPlanTeam [审核组组成] ON 审核计划.TaskNo = [审核组组成].TaskNo LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_AuditorContactRecord [审核员联系记录] ON 审核计划.TaskNo = [审核员联系记录].TaskNo WHERE ([审核计划].[PlanStatus] > '02' AND [审核类型_审核类型].[TypeName] <> '变更') AND ( 1=2  or 审核组组成.[AuditorName] like '%王冰%'  or 审核组组成.[StandardCode] like '%王冰%'  or 审核组组成.[Duty] like '%王冰%'  or 审核组组成.[ApproveMode] like '%王冰%'  or 审核组组成.[WitnessSituation] like '%王冰%'  or 审核组组成.[TechLevel] like '%王冰%'  or 审核组组成.[Org] like '%王冰%'  or 审核组组成.[ProfessionalCode] like '%王冰%'  or 审核组组成.[AuditorCode] like '%王冰%'  or 审核组组成.[Gender] like '%王冰%'  or 审核组组成.[RegCertiNo] like '%王冰%'  or 审核组组成.[TaskNo] like '%王冰%' )