2025-09-25 15:16:41
Sql：insert into GB_PlanDoc (ID,UpdateVersion,Createby,CreateOn,ApproveBy,ApproveOn,TaskNo,DocumentType,FileName,UploadBy,UploadOn,IsHistry) values (N'509014494',N'0',N'',N'2025-09-25 15:16:41',N'',N'',N'1cc00518a58f498c8e7d9046f21ff404',N'212',N'ISC-S-I-02 申请受理决定书.doc',N'ISC-263722',N'2025-09-25 15:16:41',0) 
Error：违反了 PRIMARY KEY 约束“PK__GB_PlanD__3213E83F42B7D1CC”。不能在对象“dbo.GB_PlanDoc”中插入重复键。重复键值为 (509014494)。
语句已终止。
   在 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, ArrayList paraList) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 745
2025-09-25 15:16:42
Sql：insert into GB_PlanDoc (ID,UpdateVersion,Createby,CreateOn,ApproveBy,ApproveOn,TaskNo,DocumentType,FileName,UploadBy,UploadOn,IsHistry) values (N'509014498',N'0',N'',N'2025-09-25 15:16:42',N'',N'',N'c160bd0965f24b859ea60bb05870f830',N'214',N'2万用表.pdf',N'ISC-304083',N'2025-09-25 15:16:42',0) 
Error：违反了 PRIMARY KEY 约束“PK__GB_PlanD__3213E83F42B7D1CC”。不能在对象“dbo.GB_PlanDoc”中插入重复键。重复键值为 (509014498)。
语句已终止。
   在 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, ArrayList paraList) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 745
2025-09-25 15:16:43
Sql：insert into GB_PlanDoc (ID,UpdateVersion,Createby,CreateOn,ApproveBy,ApproveOn,TaskNo,DocumentType,FileName,UploadBy,UploadOn,IsHistry) values (N'509014499',N'0',N'',N'2025-09-25 15:16:43',N'',N'',N'c160bd0965f24b859ea60bb05870f830',N'214',N'3示波器.pdf',N'ISC-304083',N'2025-09-25 15:16:43',0) 
Error：违反了 PRIMARY KEY 约束“PK__GB_PlanD__3213E83F42B7D1CC”。不能在对象“dbo.GB_PlanDoc”中插入重复键。重复键值为 (509014499)。
语句已终止。
   在 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, ArrayList paraList) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 745

2025-09-25 15:33:42 执行时长：5.62秒 sql:select count(*) from ( SELECT DISTINCT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] AS [通过日期] FROM GB_AuditorProfessional 人员专业能力 WITH(NOLOCK)  LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员专业能力.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员专业能力.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员专业能力.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ProfessionalCode [专业代码_专业代码库] WITH(NOLOCK) ON 人员专业能力.ProfessionalCode = [专业代码_专业代码库].ID LEFT JOIN Pub_MediumClass [中类编码_专业中类] WITH(NOLOCK) ON 人员专业能力.MediumClassEncoding = [中类编码_专业中类].MediumClassEncoding LEFT JOIN Pub_MajorCategories [大类编码_专业大类] WITH(NOLOCK) ON 人员专业能力.CategoryEncoding = [大类编码_专业大类].CategoryEncoding LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 人员专业能力.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Code [能力来源_代码表] WITH(NOLOCK) ON 人员专业能力.SourceOfAbility = [能力来源_代码表].CodeID WHERE [人员编号_人员信息表].[StaffStatus] = '127' ) as CurrentCount

2025-09-25 15:33:48 执行时长：5.36秒 sql:exec [GB_AuditorSchedule] '2025-09-01','','','','','','123','0.5','ISC0901'

2025-09-25 15:55:44 执行时长：5.84秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID 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 =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  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'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[邮寄日期] desc',@OnlyID = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[UpdateOn] AS [修改时间],快递登记.[SendOn] AS [邮寄日期]  FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID 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 =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  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'' )'