コード例 #1
0
 public ActionResult List(Models.Room.List vm)
 {
     return(Code.MvcHelper.Post(null, Url.Action("List", new
     {
         searchText = vm.SearchText,
         BuildId = vm.BuildId,
         roomTypeId = vm.RoomTypeId,
         pageIndex = vm.Page.PageIndex,
         pageSize = vm.Page.PageSize
     })));
 }
コード例 #2
0
        public ActionResult List()
        {
            using (var db = new XkSystem.Models.DbContext())
            {
                var vm = new Models.Room.List();
                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.RoomList = (from p in tb
                               orderby p.RoomName, p.No
                               select new Dto.Room.List
                {
                    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));
            }
        }