8,497
社区成员
发帖
与我相关
我的任务
分享
from dstu in DB.t_imsstudent
join dsign in DB.t_imsignups
on dstu.OBJ_ID equals dsign.studentID
select new
{
OBJ_ID = dsign.objID,
name = dstu.name,
CSRQ = dstu.CSRQ,
XBM = dstu.XBM,
manuallabornumber = dsign.manuallabornumber,
trainingofoccupation = dsign.trainingofoccupation,
tfdegree = dsign.tfdegree,
};
List<Expression<Func<LinqToSql.Orm.t_imsignup, bool>>> exlist = new List<Expression<Func<LinqToSql.Orm.t_imsignup, bool>>>();
var list = DataList.Where(IMSROOT.App_Code.DynamicLinq.AddWhere<LinqToSql.Orm.t_imsignup>(exlist));
QueryContext query = new QueryContext();
var q = from u in query.Users
select u;
if (!string.IsNullOrEmpty(a))
{
q = q.Where(p => p.name == a);
}
if (!string.IsNullOrEmpty(b))
{
q = q.Where(p => p.age == b);
}
if (!string.IsNullOrEmpty(c))
{
q = q.Where(p => p.sex == c);
}
if (!string.IsNullOrEmpty(d))
{
q = q.Where(p => p.address == d);
}
q.ToList(); //上边的所有if,只有到此处才会执行
http://blog.csdn.net/q107770540/article/details/5724013
string sql = "select * from t where 1=1";
//姓名不为空就把姓名加入where条件
if (!string.IsNullOrEmpty(this.txtName.Text.Trim()))
{
sql = sql + string.Format(" and name like '%{0}%'", this.txtName.Text.Trim());
}
//身份证号不为空就把身份证号加入where条件
if (!string.IsNullOrEmpty(this.txtID.Text.Trim()))
{
sql = sql + string.Format(" and id like '%{0}%'", this.txtID.Text.Trim());
}