多行数据一次性删除方法In

时间:2021-10-26 20:11:10
       CTEBudgetView ebView = new CTEBudgetView();

        CTEBudgetBillOfQuantitiesView ebboqView = new CTEBudgetBillOfQuantitiesView();

        CTEBudgetMaterialEquipmentQuotedPriceView ebmeqpView = new CTEBudgetMaterialEquipmentQuotedPriceView();

        CTEBudgetQuotaQuantitiesView ebqqView = new CTEBudgetQuotaQuantitiesView();
        string strContextID = CGeneral.GetIDValue();  //上下文ID
        WhereClip where = CTEBudget._.EBID.In(strIDs.Split(','));
        CTEBudget[] list_Wait = ebView.GetArray(where);

        DbTransaction trans = ebView.BeginTransaction();

        ebboqView.Delete(CTEBudgetBillOfQuantities._.EBID.In(strIDs.Split(',')), trans);

        ebmeqpView.Delete(CTEBudgetMaterialEquipmentQuotedPrice._.EBID.In(strIDs.Split(',')), trans);

        ebqqView.Delete(CTEBudgetQuotaQuantities._.EBID.In(strIDs.Split(',')), trans);

        ebView.Delete(where, trans);