这个SQL换成linq怎么写啊
string sql = "";
sql = "select * from Tasks where 1=1";
if (!string.IsNullOrEmpty(ddlpriority.SelectedValue))
{
sql += sql +"and id="+ Convert.ToInt32(ddlpriority.SelectedValue);
}
-------------------------------------------------------------------------------
NPMSLinqDataContext ctxt = new NPMSLinqDataContext();
string linqstring=string.Empty;
linqstring="";
int _priority = 0;
int _status = 0;
DateTime _objtime;
if (!string.IsNullOrEmpty(ddlpriority.SelectedValue))
{
_priority = Convert.ToInt32(ddlpriority.SelectedValue);
}
var q = from c in ctxt.Tasks
where 1=1
&& c.priority == (_priority == 0 ? : _priority) 这个地方怎么写啊
.........
select c;
repeaterReportInfo.DataSource = q;
repeaterReportInfo.DataBind();
}
第一次用LINQ 做项目 不要见笑