读书人

初学者关于查询

发布时间: 2012-06-10 14:03:15 作者: rapoo

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

C# code
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);        }





[解决办法]
继续再like中增加你要查询的字段
[解决办法]
做外链:
var query= from p in persons
join s in Pbaseinfo on p.Usernam equals s.UserName
where ....

读书人网 >asp.net

热点推荐