或条件不在where子句中... [英] Or condition is not working in where clause...

问题描述

public List< settingsviewmodel> ActivemoduleList（十进制OrgID）

{

返回（来自db.lookupmodules中的模块

其中module.OrganizationId == OrgID || module.OrganizationId == OrgID&& module.IsActive == false || module.OrganizationId == OrgID&& module.IsActive == false

选择新的SettingsViewModel

{

ModuleId = module.ModuleID，

ModuleName = module.ModuleName，

DateCreated = module.DateCreated，

DateModified = module.DateModified，

statusName = module.IsActive，

SetDefault = module.IsDefault，

}）。ToList（）;

}



我的尝试：



i我试图解决哪里只有第一个价值的情况我选择了ed .i希望每个条件选择我们的值。

public List<settingsviewmodel> ActivemoduleList(decimal OrgID)
{
return (from module in db.lookupmodules
where module.OrganizationId == OrgID || module.OrganizationId == OrgID && module.IsActive == false || module.OrganizationId == OrgID && module.IsActive == false
select new SettingsViewModel
{
ModuleId = module.ModuleID,
ModuleName = module.ModuleName,
DateCreated = module.DateCreated,
DateModified = module.DateModified,
statusName = module.IsActive,
SetDefault = module.IsDefault,
}).ToList();
}

What I have tried:

i am tried to solve where condition where only first value is i have picked .i want every condition pick our value.

推荐答案

尝试将表达式括起来，明确说出你想要的内容：&& 的优先级高于 || 所以

Try bracketing the expression so it explicitly says what you want: && has a higher precedence than || so

A || b && c

被评估为

a || (b && c)

不是

(a || b) && c

没有括号来明确说出你想要的东西，你可能得不到它！

Without brackets to explicitly say what you want, you may not get it!

这篇关于或条件不在where子句中...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！