public ActionResult SelectUser() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.Sms.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)); } vm.SelectUserList = (from p in tb where p.UserType == vm.UserType orderby p.UserCode select new Dto.Sms.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.Sms.SelectUser vm) { return(Code.MvcHelper.Post(null, Url.Action("SelectUser", new { searchText = vm.SearchText, userType = vm.UserType, pageIndex = vm.Page.PageIndex, pageSize = vm.Page.PageSize }))); }
public ActionResult SelectUserJson(List <int> ids) { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.Sms.SelectUser(); var tb = (from p in db.Table <Sys.Entity.tbSysUser>() where ids.Contains(p.Id) select new Dto.Sms.SelectUser { Id = p.Id, UserCode = p.UserCode, UserName = p.UserName, SexName = p.tbSex.SexName, Mobile = p.Mobile, UserType = p.UserType }).ToList(); return(Json(tb, JsonRequestBehavior.AllowGet)); } }