EF引入数据库
这里的名称写【Order】就行
引入的时间可能很长,多等一会。完毕后会多出两个包,以及对应的模型文件。
创建控制器
初始化函数——Index
public ActionResult Index() { using (OrdersDBEntities db = new OrdersDBEntities()) { List<OrderInfo> list = db.OrderInfo.OrderBy(o => o.OrderState).ToList(); ViewBag.list = list; return View(); } } 初始化视图——Index.cshtml @{ ViewBag.Title = "Index"; } <h2 align="center">简易订单管理系统</h2> <hr /> <a href="~/Order/AddOrderPage">添加订单</a> <table class="table table-bordered table-hover"> <tr> <th>订单编号</th> <th>下单人</th> <th>订单日期</th> <th>订单状态</th> <th>操作</th> </tr> @foreach (var item in ViewBag.list) { <tr> <td>@item.OrderID</td> <td>@item.UserName</td> <td>@item.OrderDate</td> @if (item.OrderState == 0) { <td style="background-color:red">未发货</td> } else { <td>已发货</td> } <td> @if (item.OrderState == 0) { <a href="~/Order/UpdateById?id=@item.OrderID">发货</a> } </td> </tr> } </table>
创建视图——AddOrderPage
public ActionResult AddOrderPage() { return View(); }
添加视图编码——AddOrderPage
@{ ViewBag.Title = "AddOrderPage"; } <h2>添加订单</h2> <hr/> <form action="~/Order/AddOrder"> <p> 下单人:<input type="text" name="UserName" required/> </p> <p> 订单日期<input type="date" name="OrderDate" required/> </p> <p> <input type="submit" value="提交"/> </p> </form>
创建函数
AddOrder
public ActionResult AddOrder(string UserName, DateTime OrderDate) { using (OrdersDBEntities db = new OrdersDBEntities()) { OrderInfo info = new OrderInfo(); info.OrderID = 0; info.UserName = UserName; info.OrderDate = OrderDate; info.OrderState = 0; db.OrderInfo.Add(info); //一定要保存 db.SaveChanges(); return Redirect("~/Order/Index"); } }
UpdateById
public ActionResult UpdateById(int id) { using (OrdersDBEntities db = new OrdersDBEntities()) { OrderInfo orderInfo = db.OrderInfo.Where(o => o.OrderID == id).FirstOrDefault(); orderInfo.OrderState = 1; //保存 db.SaveChanges(); return Redirect("~/Order/Index"); }
}
运行效果
按钮提示
<a href="~/Order/UpdateById?id=@item.OrderID" onclick="return confirm('是否修改此行?')">发货</a>









