1. 执行以下脚本报错，调用EnableDiffLogEvent方法报错，原因：生成的查询脚本，有问题

res = db.Deleteable<RecipeEntity>().Where(e =>

            dbRecipeIds.Contains(e.RecipeId) && SqlFunc.Subqueryable<RecipeDetailEntity>()

                .Where(d => d.RecipeId == e.RecipeId).NotAny())

                .EnableDiffLogEvent()

                .ExecuteCommand();

调用的EnableDiffLogEvent方法会生成如下查询脚本：

SELECT [RecipeId],[ClinicId],[ReceiveId],[PatientId],[PatientName],[DataType],[RecipeType],[SpecialRecipeSign],[RecipeTypeName],[TotalPairCount],[DayPairCount],[DosageFormId],[DosageFormName],[CMDrugCategory],[UseDoseFormId],[UseDoseFormName],[UsageId],[UsageName],[Status],[DrDeptId],[DrDeptName],[DrEmployeeId],[DrEmployeeName],[InputOrgId],[InputDeptId],[InputDeptName],[InputEmployeeId],[InputEmployeeName],[InputTime],[IsNeedAudit],[DiagCode],[DiagName],[BatchId],[Memo],[IsPrint],[SpecialRecipeAgent],[SpecialRecipeAgentIdCard],[ZgwMainID],[DecoctingDosage],[DecoctPairCount],[PEISSettlementId],[RecipeName],[IsDeliveryRecipe],[BeginTime],[HerbalTypeId],[HerbalTypeName],[TagId],[SettlementTypeId],[SettlementTypeName],[DiseId],[DiseName],[PayCompanyId],[PayCompanyName],[AuditStatus],[AuditTime],[AuditResult],[RuleId],[PrescriptionType],[IsSignIn],[SignInLogo],[DrugSort],[ExtendedMedicationDescription],[DecoctingDosageUnitId],[DecoctingDosageUnitName],[IsAgreedParty],[SpecialDrugDailySerialNum],[IsResearchRecipe],[AgreedPartyIsCanEdit],[DiscountTypeId],[DiscountTypeName],[IsDualChannelRecipe],[ElectronicPrescriptionStatus],[MedTraceCode],[MedRecipeNo],[PreVerificationEmployeeId],[PreVerificationEmployeeName],[PreVerificationTime],[SignEmployeeId],[SignEmployeeName],[SignTime],[UploadEmployeeId],[UploadEmployeeName],[UploadTime],[UnUploadEmployeeId],[UnUploadEmployeeName],[UnUploadTime] FROM [CT_Recipe] WITH(NOLOCK)   WHERE ( [RecipeId] = [CT_Recipe].[RecipeId] ) )))

这个查询脚本是有问题的。。。所以执行查询就报错误了

2. 去掉这个子查询条件

SqlFunc.Subqueryable<RecipeDetailEntity>()

                .Where(d => d.RecipeId == e.RecipeId).NotAny()

执行以下脚本

res = db.Deleteable<RecipeEntity>().Where(e =>

            dbRecipeIds.Contains(e.RecipeId))

                .EnableDiffLogEvent()

                .ExecuteCommand();

是不报错的，能够正确执行，审计功能生成的sql是正确的

启用EnableDiffLogEvent时，执行Delete报错.zip