MVC2_001_增删改查

以订单为例子

在Models--创建OrdersData

protected EFDataClasses1DataContext db = new EFDataClasses1DataContext();

public void Add(Orders model)--添加订单

{

  if(model.OrderId==0)

  {

    //db.Orders.InsertAllOnSubmit(实体集合);--批量添加

     db.Orders.InsertOnSubmit(model);

  }

 db.SubmitChanges();//必须要调用提交的变化【为了减少运算和数据库的连接】

}

//获取订单列表

public List<Orders> GetAllOrders()

{

   return db.Orders.ToList();

}

 //获取单个订单

public Orders GetModel(int id)

{

   try

   {

    //lambda://db.Orders.Where(n => n.OrderId == id).First();

     return db.Order.Single(n=>n.OrderId==id);

   }

   catch(Exception)

   {

    return null;

   }

}

//删除

public void Delete(int OrderId)

{

  Orders order=GetModel(OrderId);

  if(order!=null){db.Orders.DeleteOnSubmit(order);}

  db.SubmitChanges();

}

  public void Save()
   {
            db.SubmitChanges();
     }

//Controller-->OrdersController.cs

OrdersData oData=new OrdersData();

public ActionResult Index()

{

   List<Orders> orders=oData.GetAllOrders();

   return View(orders);//ViewData["list"]=orders;

}

//GET

public ActionResult Create(){return View();}

//Post

[HttpPost]

public ActionResult Create(Orders model) //FormCollection form

{

   Orders order=new Orders();

   order.OrderTitle=model.OrderTtle;//form["OrderTitle"]

   order.CustomerName=model.CustomerName;

   ...

  oData.Add(order);

  return RedirectToAction("Index");

}

public ActionResult Edit(int id)

{

  ViewData.Model=oData.GetModel(id);

  return View();

}

public ActionResult Delete(int id){oData.Delete(id);return RedirectToAction("Index");}

public ActionResult Details(int id)

{

  var data=oData.GetModel(id); return View(data);

}

[HttpPost]

public ActionResult Edit(int id,Orders model)

{

   var oldStu=oData.GetModel(id);

   if(oldStu!=null)

   {

     oldStu.CustomerName=model.CustomerName;

     oldStu.OrderTitle=model.OrderTitle;

     oData.Save();

     return RedirectToAction("Index");

  }

return View();

}