public ActionResult SelectUser()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.SysMessage.SelectUser();
if (Request["UserType"] != null)
{
Code.EnumHelper.SysUserType userType;
Enum.TryParse(Request["UserType"], out userType);
vm.UserType = userType;
}
var tb = from p in db.Table <Sys.Entity.tbSysUser>()
select p;
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => d.UserCode.Contains(vm.SearchText) || d.UserName.Contains(vm.SearchText) || d.Mobile.Contains(vm.SearchText));
}
if (vm.UserType != null)
{
tb = tb.Where(d => d.UserType == vm.UserType);
}
vm.SelectUserList = (from p in tb
orderby p.UserCode, p.UserName
select new Dto.SysMessage.SelectUser
{
Id = p.Id,
UserCode = p.UserCode,
UserName = p.UserName,
SexName = p.tbSex.SexName,
Mobile = p.Mobile,
UserType = p.UserType
}).ToPageList(vm.Page);
return(View(vm));
}
}
public ActionResult SelectUser(Models.SysMessage.SelectUser vm)
{
return(Code.MvcHelper.Post(null, Url.Action("SelectUser", new { searchText = vm.SearchText, userType = vm.UserType, pageSize = vm.Page.PageSize, pageCount = vm.Page.PageCount, pageIndex = vm.Page.PageIndex })));
}