public ActionResult SelectRoom(Models.Room.SelectRoom vm) { return(Code.MvcHelper.Post(null, Url.Action("SelectRoom", new { searchText = vm.SearchText, BuildId = vm.BuildId, roomTypeId = vm.RoomTypeId, pageIndex = vm.Page.PageIndex, pageSize = vm.Page.PageSize }))); }
public ActionResult SelectRoom() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.Room.SelectRoom(); vm.BuildList = BuildController.SelectList(); vm.RoomTypeList = RoomTypeController.SelectList(); var tb = from p in db.Table <Basis.Entity.tbRoom>() select p; if (string.IsNullOrEmpty(vm.SearchText) == false) { tb = tb.Where(d => d.RoomName.Contains(vm.SearchText)); } if (vm.BuildId != 0) { tb = tb.Where(d => d.tbBuild.Id == vm.BuildId); } if (vm.RoomTypeId != 0) { tb = tb.Where(d => d.tbRoomType.Id == vm.RoomTypeId); } vm.SelectRoomList = (from p in tb orderby p.tbBuild.No, p.tbBuild.BuildName, p.RoomName select new Dto.Room.SelectRoom { Id = p.Id, No = p.No, RoomName = p.RoomName, BuildName = p.tbBuild.BuildName, RoomTypeName = p.tbRoomType.RoomTypeName, MaxUser = p.MaxUser }).ToPageList(vm.Page); return(View(vm)); } }