菜鸟求助，关于查询

[lszdwdavid]

菜鸟求助，如何在关键字查询中加入姓名和身份证号查询？

public ActionResult Search(int? page, string keywords)
        {
            AppendTitle("个人会员-搜索结果");

            var q = QueryBuilder.Create<Persons>()
                .Like(x => x.UserName, keywords ?? string.Empty);
            var query1 = QueryBuilder.Create<Persons>() //多字段查询
                .Like(x => x.PersonNum, keywords ?? string.Empty);

            q.Expression = q.Expression.Or(query1.Expression);

            int currentPageIndex = page.HasValue ? page.Value - 1 : 0;
            var persons = personsRepository.Find(q, currentPageIndex, BaseControllerService.PageSize, "PersonID", false);

            var viewModel = new PersonsIndexViewModel
            {
                Persons = persons,
                Keywords = keywords
            };
            return View("Index", viewModel);
        }

[zhangdaowu5]

再加连接条件查询，你先把sql方在查询分析器中去执行一下，没有问题的话就再放到代码中去执行。

[尼古拉特斯拉]

这不是MVC3么

[bdmh]

继续再like中增加你要查询的字段

[Mirror然]

做外链：
var query= from p in persons
join s in Pbaseinfo on p.Usernam equals s.UserName
where ....