2025-11-25 15:29:57
Sql：insert into GB_ProjectPlan (ID,UpdateVersion,Createby,CreateOn,ApproveBy,ApproveOn,PlanNo,RecognitionMark,StandardCode,ApproveType,SuperQty,ReCertiQty,ProfessionalCode,ApproveRange,StandardName,AuditTeam,BeginDate,EndDate,AuditForm,IssuesToBeNoted,PlanRemarks,ProjectNo,BasicDays,FirstOffSiteHumanDays,FirstStageOnsiteDays,SecondStageDays,SupervisoryDays,ReexaminationDays,TotalDays,ApproveClass,PlanStatus,Corp,ReturnDate,ReasonForReturn,DispatchBy,DispatchDate,Approver,ApproveDate,DocReceiveBy,DistributeOn,ReasonsForAuditFailure,DocReceiveRemark,CertificateUrgent,UrgentReason,AcceptanceEvaluationTime,ScopeOfEvaluation,ProjectClassification,GroupLeaderGrading,QualityOfCaseFiles,ProfessionalEvaluation,AssessStatus,DecideOn,DecideResult,ReturnReason,UnPassReason,ProcessResult,NextApproveType,NextApproveDate,NextPlanCreated,CertiInfo,CertiAcceptanceDate,CertiCompletionDate,Province,ReviewBy,SupportBy,DecideBy,ReceiveDate,CommitDate,FeeDate,ReviewDate,ReviewRemarks,NonCompliantTerms,NextAuditAdvice,NextAuditFocus,DocUploaded,IsReform,ReformDate,ApplyNo,PlanApproveDate,ContactResults,ToScheduleDate,ToSchedule,ProjectLeader,PlanReturnReason,ToScheduleInfo,SuperviseEndDate,SuperNoticeSent,ApproveDays,FromChangeNo,ChangeInfo,PlanCommitDate,DocReturnDate,RetrivalDate,CertiFee,ReturnContractQty,ReturnDoc,ReturnContract,ReturnApply,ReturnContractTransfer,ReportDate,ReceiveDateI,Receiver,MoveDate,HandOverBy,MailingInformation,Org,FieldCode,FollowUpTracking,TrackingResults,HasPause,TaskNo,ContractNo,RiskLevel,PauseNotice,SuperNoticeDate,SuperCommitDate,CertiQty,AcceptDate,CheckDate,BizAddress,FeeDays) values (N'511001982',N'12',N'罗玄天',N'2025-11-18 09:22:30',N'',N'',N'21888-2025-FH-F-200',N'0',N'73',N'01',0,0,N'FI-2 ',N'位于上海市奉贤区望园路1698弄28号19幢6层622A室的上海大围尚阁农业发展有限公司的预包装食品销售(含冷藏冷冻食品销售)',N'ISO 22000:2018',N'',N'2025-11-18 08:30',N'',N'FS01',N'',N'',N'21888-2025-FH-F',2.0,0.0,0.0,0.0,1.0,1.3,2.0,N'20',N'03',N'202511180002',N'',N'',N'',N'',N'',N'',N'',N'',N'',N'',0,N'',N'',N'',N'',N'',N'',N'',N'',N'',N'',N'',N'',N'',N'',N'',0,N'',N'',N'',N'SH',N'',N'',N'',N'',N'',N'',N'',N'',N'',N'',N'',0,0,N'',N'2025110235',N'',N'',N'2025-11-25 15:29',1,N'',N'',N'',N'',0,0,N'',N'',N'',N'',N'',0,0,0,0,0,0,N'',N'',N'',N'',N'',N'',N'25',N'F',N'',N'',0,N'ec322315374f4b2e81e6f5db8149947a',N'21888-2025-FH',N'R2',0,N'',N'',10,N'2025-11-18',N'2025-11-25 15:29:57',N'',0) 
Error：违反了 PRIMARY KEY 约束“PK__GB_Proje__3213E83F7E0DA1C4”。不能在对象“dbo.GB_ProjectPlan”中插入重复键。重复键值为 (511001982)。
语句已终止。
   在 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-11-25 15:44:23 执行时长：6.66秒 sql:exec GB_PartnerBizStatistics '2025','ISC[S]0044'