批量删除物料报 cloud7.1

source:INSERT INTO T_ENG_BBEBOM (FID, FMASTERID, FYIELDRATE, FBILLTYPE, FISDEFAULT, FBASEUNITID, FUNITID, FMODIFIERID, FCREATORID, FUSEORGID, FFORBIDDERID, FMODIFYDATE, FCREATEDATE, FFORBIDSTATUS, FDOCUMENTSTATUS, FCREATEORGID, FNUMBER, FAPPROVERID, FBOMCATEGORY, FAPPROVEDATE, FFORBIDDATE, FMATERIALID, FBOMUSE, FMDLID, FGROUP, FBASEQTY, FQTY, FCFGBOMID, FAUXPROPID, FBOMSRC, FPLMBOMID, FCOMPUTEID) SELECT T1.FID, T1.FMASTERID, T1.FYIELDRATE, T1.FBILLTYPE, T1.FISDEFAULT, T1.FBASEUNITID, T1.FUNITID, T1.FMODIFIERID, T1.FCREATORID, T1.FUSEORGID, T1.FFORBIDDERID, T1.FMODIFYDATE, T1.FCREATEDATE, T1.FFORBIDSTATUS, T1.FDOCUMENTSTATUS, T1.FCREATEORGID, T1.FNUMBER, T1.FAPPROVERID, T1.FBOMCATEGORY, T1.FAPPROVEDATE, T1.FFORBIDDATE, T1.FMATERIALID, T1.FBOMUSE, T1.FMDLID, T1.FGROUP, T1.FBASEQTY, T1.FQTY, T1.FCFGBOMID, T1.FAUXPROPID, T1.FBOMSRC, T1.FPLMBOMID, '0a94ef60-b475-8b29-11e8-5ab1b3529c4e' FROM T_ENG_BOM T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID
INSERT INTO T_ENG_BBEBOM_L (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION) SELECT T1.FPKID, T1.FID, T1.FLOCALEID, T1.FNAME, T1.FDESCRIPTION FROM T_ENG_BOM_L T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID
INSERT INTO T_ENG_BBEBOMCHILD (FID, FENTRYID, FSEQ, FOPTQUEUE, FCHILDSUPPLYORGID, FISMINISSUEQTY, FRECORDDATA, FAUXPROPID, FOPERID, FOWNERID, FENTRYROWID, FUNITID, FBOMID, FISGETSCRAP, FOFFSETTIME, FOWNERTYPEID, FDENOMINATOR, FNUMERATOR, FBASEUNITID, FREPLACEGROUP, FBASEDENOMINATOR, FBASEFIXSCRAPQTY, FBASENUMERATOR, FOVERCONTROLMODE, FACTUALQTY, FQTY, FDISASSMBLERATE, FMATERIALTYPE, FFIXSCRAPQTY, FPROCESSID, FDOSAGETYPE, FEFFECTDATE, FISKEYCOMPONENT, FTIMEUNIT, FBACKFLUSHTYPE, FSCRAPRATE, FPOSITIONNO, FMATERIALID, FSUPPLYORG, FISSUETYPE, FEXPIREDATE, FALLOWOVER, FSTOCKLOCID, FSTOCKID, FBBESTATUS) SELECT T1.FID, T1.FENTRYID, T1.FSEQ, T1.FOPTQUEUE, T1.FCHILDSUPPLYORGID, T1.FISMINISSUEQTY, T1.FRECORDDATA, T1.FAUXPROPID, T1.FOPERID, T1.FOWNERID, T1.FENTRYROWID, T1.FUNITID, T1.FBOMID, T1.FISGETSCRAP, T1.FOFFSETTIME, T1.FOWNERTYPEID, T1.FDENOMINATOR, T1.FNUMERATOR, T1.FBASEUNITID, T1.FREPLACEGROUP, T1.FBASEDENOMINATOR, T1.FBASEFIXSCRAPQTY, T1.FBASENUMERATOR, T1.FOVERCONTROLMODE, T1.FACTUALQTY, T1.FQTY, T1.FDISASSMBLERATE, T1.FMATERIALTYPE, T1.FFIXSCRAPQTY, T1.FPROCESSID, T1.FDOSAGETYPE, T1.FEFFECTDATE, T1.FISKEYCOMPONENT, T1.FTIMEUNIT, T1.FBACKFLUSHTYPE, T1.FSCRAPRATE, T1.FPOSITIONNO, T1.FMATERIALID, T1.FSUPPLYORG, T1.FISSUETYPE, T1.FEXPIREDATE, T1.FALLOWOVER, T1.FSTOCKLOCID, T1.FSTOCKID, '1' FROM T_ENG_BOMCHILD T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID
INSERT INTO T_ENG_BBEBOMCHILD_A (FENTRYID, FID, FPLMBOMENTRYID, FTREEENTRYIDBAK, FISSKIP, FBOMENTRYSRC, FCFGBOMENTRYID, FISCANREPLACE, FISCANEDIT, FCFGFEATUREENTRYID, FECNROWTYPE, FECNBILLNO, FCHANGETIME, FCHANGETYPE, FSUPPLYMODE, FECNCHGDATE, FECNCHGTYPE, FISCANCHOOSE, FREPLACETYPE, FREPLACEPOLICY, FISKEYITEM, FMRPPRIORITY, FREPLACEPRIORITY, FISMRPRUN, FPARENTROWID, FROWID, FROWEXPANDTYPE) SELECT T1.FENTRYID, T1.FID, T1.FPLMBOMENTRYID, T1.FTREEENTRYIDBAK, T1.FISSKIP, T1.FBOMENTRYSRC, T1.FCFGBOMENTRYID, T1.FISCANREPLACE, T1.FISCANEDIT, T1.FCFGFEATUREENTRYID, T1.FECNROWTYPE, T1.FECNBILLNO, T1.FCHANGETIME, T1.FCHANGETYPE, T1.FSUPPLYMODE, T1.FECNCHGDATE, T1.FECNCHGTYPE, T1.FISCANCHOOSE, T1.FREPLACETYPE, T1.FREPLACEPOLICY, T1.FISKEYITEM, T1.FMRPPRIORITY, T1.FREPLACEPRIORITY, T1.FISMRPRUN, T1.FPARENTROWID, T1.FROWID, T1.FROWEXPANDTYPE FROM T_ENG_BOMCHILD_A T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID
INSERT INTO T_ENG_BBEBOMCHILD_L (FPKID, FENTRYID, FLOCALEID, FMEMO) SELECT T1.FPKID, T1.FENTRYID, T1.FLOCALEID, T1.FMEMO FROM T_ENG_BOMCHILD_L T1 INNER JOIN T_ENG_BOMCHILD T2 ON T1.FENTRYID = T2.FENTRYID INNER JOIN @FID_udt1 TMPB ON T2.FID = TMPB.FID
INSERT INTO T_ENG_BBEBOMCHILDLOTBASEDQTY (FENTRYID, FDETAILID, FSEQ, FNUMERATOR, FSCRAPRATE, FNOTE, FBASEUNITID, FUNITID, FDENOMINATOR, FMATERIALID, FFIXSCRAPQTY, FENDQTY, FSTARTQTY, FBASENUMERATOR, FBASEFIXSCRAPQTY, FBASEENDQTY, FBASESTARTQTY, FBASEDENOMINATOR) SELECT T1.FENTRYID, T1.FDETAILID, T1.FSEQ, T1.FNUMERATOR, T1.FSCRAPRATE, T1.FNOTE, T1.FBASEUNITID, T1.FUNITID, T1.FDENOMINATOR, T1.FMATERIALID, T1.FFIXSCRAPQTY, T1.FENDQTY, T1.FSTARTQTY, T1.FBASENUMERATOR, T1.FBASEFIXSCRAPQTY, T1.FBASEENDQTY, T1.FBASESTARTQTY, T1.FBASEDENOMINATOR FROM T_ENG_BOMCHILDLOTBASEDQTY T1 INNER JOIN T_ENG_BOMCHILD T2 ON T1.FENTRYID = T2.FENTRYID INNER JOIN @FID_udt1 TMPB ON T2.FID = TMPB.FID
INSERT INTO T_ENG_BBEBOMCOBY (FID, FENTRYID, FSEQ, FISBACKFLUSH, FBOMID, FOUTPUTOPTQUEUE, FBASEUNITID, FBASEQTY, FNOTE, FAUXPROPID, FUNITID, FTASKID, FEXPIREDATE, FQTY, FEFFECTDATE, FPPROCESSID, FCOSTRATE, FMATERIALID, FCOBYTYPE, FBBESTATUS) SELECT T1.FID, T1.FENTRYID, T1.FSEQ, T1.FISBACKFLUSH, T1.FBOMID, T1.FOUTPUTOPTQUEUE, T1.FBASEUNITID, T1.FBASEQTY, T1.FNOTE, T1.FAUXPROPID, T1.FUNITID, T1.FTASKID, T1.FEXPIREDATE, T1.FQTY, T1.FEFFECTDATE, T1.FPPROCESSID, T1.FCOSTRATE, T1.FMATERIALID, T1.FCOBYTYPE, '1' FROM T_ENG_BOMCOBY T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID
INSERT INTO T_ENG_BBEBOMBOPENTRY (FID, FENTRYID, FSEQ, FPRODUCTLINE, FREPLACEGROUPBOP, FPRDLINELOCID, FBOPBASEUNITID, FBOPDENOMINATOR, FBOPNUMERATOR, FTREEENTRYID, FBASEBOPDENOMINATOR, FBASEBOPNUMERATOR, FBOPMATERIALID, FBOPDOSAGETYPE, FBOPUNITID) SELECT T1.FID, T1.FENTRYID, T1.FSEQ, T1.FPRODUCTLINE, T1.FREPLACEGROUPBOP, T1.FPRDLINELOCID, T1.FBOPBASEUNITID, T1.FBOPDENOMINATOR, T1.FBOPNUMERATOR, T1.FTREEENTRYID, T1.FBASEBOPDENOMINATOR, T1.FBASEBOPNUMERATOR, T1.FBOPMATERIALID, T1.FBOPDOSAGETYPE, T1.FBOPUNITID FROM T_ENG_BOMBOPENTRY T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID

message:违反了 PRIMARY KEY 约束“PK_ENG_BBEBOMCHILD”。不能在对象“dbo.T_ENG_BBEBOMCHILD”中插入重复键。重复键值为 (100753)。
违反了 PRIMARY KEY 约束“PK_ENG_BBEBOMCHILD_A”。不能在对象“dbo.T_ENG_BBEBOMCHILD_A”中插入重复键。重复键值为 (100753)。
语句已终止。
语句已终止。
stacktrace:
Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList)

Exception rethrown at [0]:
在 Kingdee.K3.MFG.ENG.App.Core.BomBatchEditService.RunSimulationBom(Context ctx, DynamicObject editDataObject, BomBatchEditOption option)
在 Kingdee.K3.MFG.ServiceHelper.ENG.BomBatchEditServiceHelper.RunSimulationBom(Context ctx, DynamicObject editDataObject, BomBatchEditOption option)
在 Kingdee.K3.MFG.ENG.Business.PlugIn.DynamicForm.WizardForm.BomBatchEditWizardPlugIn.RunSimulationBom()
在 System.Threading.Tasks.Task.Execute()

inner exception:
source:.Net SqlClient Data Provider
message:违反了 PRIMARY KEY 约束“PK_ENG_BBEBOMCHILD”。不能在对象“dbo.T_ENG_BBEBOMCHILD”中插入重复键。重复键值为 (100753)。
违反了 PRIMARY KEY 约束“PK_ENG_BBEBOMCHILD_A”。不能在对象“dbo.T_ENG_BBEBOMCHILD_A”中插入重复键。重复键值为 (100753)。
语句已终止。
语句已终止。
stacktrace: 在 System.Data.SqlClient.SqlConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 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()
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)