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));
}
}
