目录

效果图

实现过程 

控制器代码

DAL

 BLL

Index 

效果图

实现过程 

控制器代码

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
 
namespace MvcApplication1.Controllers
{
    public class HomeController : Controller
    {
        //
        // GET: /Home/
 
        public ActionResult Index()
        {
            ViewData["Show"] = BLL.BllManager.Show();
            return View();
        }
        public ActionResult delect(int id)
        {
 
          
            BLL.BllManager.Delect(id);
            return RedirectToAction("Index");
        }
        public ActionResult order(int id) {
            BLL.BllManager.order(id);
            return RedirectToAction("Index");
        }
    }
}

DAL

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using MvcApplication1.Model;
namespace MvcApplication1.DAL
{
    public class DalService
    {
        public static List Show() {
            HotelEntities db = new HotelEntities();
            return db.Rooms.ToList();
        }
 
 
        public static bool Delect(int id)
        {
            Room room = findroom(id);
            HotelEntities db = new HotelEntities();
            db.Entry(room).State = System.Data.EntityState.Deleted;
            return db.SaveChanges() > 0;
        }
        public static bool order(int id)
        {
            Room room = findroom(id);
            HotelEntities db = new HotelEntities();
            db.Entry(room).State = System.Data.EntityState.Modified;
            room.statu = room.statu == 0 ? 1 : 0;
            return db.SaveChanges() > 0;
        }
        public static Room findroom(int id)
        {
            HotelEntities db = new HotelEntities();
 
            return db.Rooms.SingleOrDefault(x => x.TID == id);
 
 
        }
 
    }
}

 BLL

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using MvcApplication1.Model;
namespace MvcApplication1.BLL
{
    public class BllManager
    {
 
        public static List Show()
        {
            return DAL.DalService.Show();
        }
         
        public static bool Delect(int id)
        {
            return DAL.DalService.Delect(id);
        }
        public static bool order(int id)
        {
            return DAL.DalService.order(id);
        }
       
 
 
    }
}

Index 

@{
    Layout = null;
}
 
 
    "viewport" content="width=device-width" />
    
    
        
酒店管理
        "1">
            
"background-color:aqua">
                
                
                
                
                
                
                
            
           @{
               foreach (var item in ViewData["Show"] as List )
               {
                   
                       
                       
                        
                        
                        
                       @if (item.statu==0)
                       {
                           
                       }else{
                      
                       }      
 
 
 
                        
                        
 
                   
               }
               }
        
编号
房间类型
房间号
单价
内线电话
状态
删除
@item.TID
@item.TypeName
@item.Name
@item.Price
@item.Phone
"color:red">未入住@Html.ActionLink("入住", "order", new {id=@item.TID })
"color:green">已入住@Html.ActionLink("退房", "order", new {id=@item.TID })
 
@Html.ActionLink("删除", "delect", new {id=@item.TID})