2025-10-17 20:29:00 执行时长：5.5秒 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-459792' where (e.roleid in ('06') or b.operatorid='ISC-459792') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-459792')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-459792' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2025-10-17 20:30:19 执行时长：5.69秒 sql:SELECT 审核计划.ID as [~ID~] ,审核计划.[BizAddress] AS [003799],审核计划.[AcceptDate] AS [003703],审核计划.[FeeDays] AS [003800],审核计划.[CheckDate] AS [003798],审核计划.[PauseNotice] AS [003509],审核计划.[SuperNoticeDate] AS [003664],审核计划.[SuperCommitDate] AS [003665],[计划状态_计划状态].StatusName AS [001819_text],审核计划.[PlanStatus] AS [001819],[评定状态_评定状态].StatusName AS [001914_text],审核计划.[AssessStatus] AS [001914],[组织名称_组织信息].CorpName AS [001833_text],审核计划.[Corp] AS [001833],审核计划.[PlanNo] AS [001784],[标准代码_认证标准].StandardCode AS [001786_text],审核计划.[StandardCode] AS [001786],[审核类型_审核类型].TypeName AS [001787_text],审核计划.[ApproveType] AS [001787],[审核类别_审核类别].ClassName AS [001818_text],审核计划.[ApproveClass] AS [001818],审核计划.[BeginDate] AS [001804],审核计划.[EndDate] AS [001805],审核计划.[ApproveDays] AS [002525],审核计划.[AuditTeam] AS [001803],[审核方式_审核方式].ApproveMode AS [001806_text],审核计划.[AuditForm] AS [001806],[合同来源_合同来源].OrgName AS [002990_text],审核计划.[Org] AS [002990],[省份_省份].Province AS [001993_text],审核计划.[Province] AS [001993],审核计划.[ProfessionalCode] AS [001792],审核计划.[CertiQty] AS [003702],[风险等级_代码表].CodeName AS [003505_text],审核计划.[RiskLevel] AS [003505],审核计划.[IssuesToBeNoted] AS [001807],审核计划.[PlanRemarks] AS [001808],审核计划.[StandardName] AS [001802],审核计划.[BasicDays] AS [001811],审核计划.[FirstOffSiteHumanDays] AS [001812],审核计划.[FirstStageOnsiteDays] AS [001813],审核计划.[SecondStageDays] AS [001814],审核计划.[SupervisoryDays] AS [001815],审核计划.[ReexaminationDays] AS [001816],审核计划.[TotalDays] AS [001817],[申请单号_认证申请].ApplyNo AS [002205_text],审核计划.[ApplyNo] AS [002205],[项目编号_认证项目].ProjectNo AS [001809_text],审核计划.[ProjectNo] AS [001809],审核计划.[ContractNo] AS [003504],审核计划.[TaskNo] AS [003454],审核计划.[ApproveRange] AS [001793],审核计划.[ReportDate] AS [002846],审核计划.[CertiFee] AS [002709],审核计划.[ReturnDate] AS [001855],审核计划.[ReasonForReturn] AS [001856],审核计划.[DispatchBy] AS [001857],审核计划.[DispatchDate] AS [001858],审核计划.[Approver] AS [001859],审核计划.[ApproveDate] AS [001860],审核计划.[PlanApproveDate] AS [002283],[联系结果_联系结果].ResultName AS [002284_text],审核计划.[ContactResults] AS [002284],审核计划.[ToScheduleDate] AS [002285],审核计划.[ToSchedule] AS [002286],审核计划.[ProjectLeader] AS [002287],审核计划.[PlanReturnReason] AS [002288],审核计划.[ToScheduleInfo] AS [002289],[认可标志_认可标志].RecogName AS [001785_text],审核计划.[RecognitionMark] AS [001785],[认证领域_认证领域].FieldName AS [003163_text],审核计划.[FieldCode] AS [003163],审核计划.[FeeDate] AS [002004],审核计划.[ChangeInfo] AS [002579],审核计划.[SuperQty] AS [001789],审核计划.[ReviewRemarks] AS [002008],审核计划.[ReCertiQty] AS [001790],[阅卷人员_登录用户].UserName AS [001994_text],审核计划.[ReviewBy] AS [001994],审核计划.[SupportBy] AS [001995],[评定人员_登录用户].UserName AS [001996_text],审核计划.[DecideBy] AS [001996],审核计划.[RetrivalDate] AS [002638],审核计划.[ReceiveDate] AS [002002],审核计划.[DocReceiveBy] AS [001861],审核计划.[DistributeOn] AS [001865],审核计划.[ReasonsForAuditFailure] AS [001866],审核计划.[CertificateUrgent] AS [001868],审核计划.[UrgentReason] AS [001869],审核计划.[AcceptanceEvaluationTime] AS [001908],审核计划.[PlanCommitDate] AS [002636],审核计划.[CommitDate] AS [002003],审核计划.[ScopeOfEvaluation] AS [001909],[项目分级_案卷质量].LevelName AS [001910_text],审核计划.[ProjectClassification] AS [001910],[组长分级_案卷质量].LevelName AS [001911_text],审核计划.[GroupLeaderGrading] AS [001911],[案卷质量_案卷质量].LevelName AS [001912_text],审核计划.[QualityOfCaseFiles] AS [001912],审核计划.[ProfessionalEvaluation] AS [001913],审核计划.[ReviewDate] AS [002007],审核计划.[DocReturnDate] AS [002637],审核计划.[ReturnContractQty] AS [002806],审核计划.[ReturnDoc] AS [002807],审核计划.[ReturnContract] AS [002808],审核计划.[ReturnApply] AS [002809],审核计划.[ReturnContractTransfer] AS [002811],审核计划.[DocReceiveRemark] AS [001867],审核计划.[DecideOn] AS [001915],[批准结论_批准结论].ResultName AS [001916_text],审核计划.[DecideResult] AS [001916],审核计划.[ReturnReason] AS [001918],审核计划.[UnPassReason] AS [001919],审核计划.[ProcessResult] AS [001920],审核计划.[SuperviseEndDate] AS [002378],审核计划.[SuperNoticeSent] AS [002379],审核计划.[NextApproveType] AS [001921],审核计划.[NextApproveDate] AS [001922],审核计划.[NextPlanCreated] AS [001923],审核计划.[CertiInfo] AS [001924],审核计划.[CertiAcceptanceDate] AS [001925],审核计划.[CertiCompletionDate] AS [001926],审核计划.[NonCompliantTerms] AS [002172],审核计划.[NextAuditAdvice] AS [002173],审核计划.[NextAuditFocus] AS [002174],审核计划.[DocUploaded] AS [002175],审核计划.[IsReform] AS [002190],审核计划.[ReformDate] AS [002191],审核计划.[FromChangeNo] AS [002556],审核计划.[ReceiveDateI] AS [002891],[合同申请接收人_登录用户].UserName AS [002892_text],审核计划.[Receiver] AS [002892],审核计划.[MoveDate] AS [002893],审核计划.[HandOverBy] AS [002894],审核计划.[MailingInformation] AS [002895],审核计划.[FollowUpTracking] AS [003277],[跟踪结果_跟踪结果].StatusName AS [003278_text],审核计划.[TrackingResults] AS [003278],审核计划.[HasPause] AS [003289],审核计划.[ID] AS [001776],审核计划.[UpdateVersion] AS [001777],审核计划.[Createby] AS [001778],审核计划.[CreateOn] AS [001779],审核计划.[Updateby] AS [001780],审核计划.[UpdateOn] AS [001781],审核计划.[ApproveBy] AS [001782],审核计划.[ApproveOn] AS [001783] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiField [认证领域_认证领域] ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode where 审核计划.id='507000381'

2025-10-17 20:31:04 执行时长：5.12秒 sql:SELECT DISTINCT 受理及评审文档.ID as [~ID~] ,[申请单号_认证申请].ApplyNo AS [申请单号],[组织名称_组织信息].CorpName AS [组织名称],受理及评审文档.[SerialNo] AS [文档序号],[文档类型_受理及评审文档类型].DocumentType AS [文档类型],(case 受理及评审文档.[IsMust] when 1 then '√' else '' end) AS [必须上传],受理及评审文档.[FileName] AS [文件名称],[上传人_用户].UserName AS [上传人],受理及评审文档.[UploadOn] AS [上传时间],(case 受理及评审文档.[NotAddPackage] when 1 then '√' else '' end) AS [不加入文件包] FROM GB_CertiApplyApproveDoc 受理及评审文档 WITH(NOLOCK)  LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 受理及评审文档.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 受理及评审文档.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 受理及评审文档.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ProjectDocType [文档类型_受理及评审文档类型] WITH(NOLOCK) ON 受理及评审文档.DocumentType = [文档类型_受理及评审文档类型].ClassCode LEFT JOIN Base_User [上传人_用户] WITH(NOLOCK) ON 受理及评审文档.UploadBy = [上传人_用户].UserID WHERE [受理及评审文档].ApplyNo='2025070046' order by [受理及评审文档].[SerialNo] ASC