MVC Demo 增删查改

本实例使用Linq to sql.

DB所需要的表:1.Product,2.Category 如下图

1.先创建列表页面

先创建Index 的Control,在Control文件夹下创建ProductControl 文件(在这之前你要使用Linq to sql 创建TestDB文件与DB通信,我这里使用的数据库是Test,并将Product,category 添加到TestDB.dbml文件中)

    public class ProductController : Controller
    {
        //
        // GET: /Product/
        //TESTEntities dbConnect = new TESTEntities();
        TestDBDataContext context = new TestDBDataContext();
        ProductModelView productView = new ProductModelView();

        public ActionResult Index(string searchString)
        {
            var products = from product in context.Products
                           select product;
            if (!string.IsNullOrEmpty(searchString))
            {
                products = products.Where(p => p.ProductName == searchString);
            }
            return View(products.ToList());
        }
    }

在Model 文件夹中创建ProductModelView文件

    public class ProductModelView
    {
        public Product productList { get; set; }
    }

在View文件夹中创建Product文件夹,然后在创建Index.cshtml

@model List<MusicStore.Product>

@{
    ViewBag.Title = "Index";
}

<h2>Index</h2>
@Html.ActionLink("New Create", "Create")

@using (Html.BeginForm("Index","Product","Index"))
{
    <p>ProductName:@Html.TextBox("searchString")
    <input type="submit" value ="search" />
    </p>
}

<table>
<tr>
<td>Id</td>
<td>ProductName</td>
<td>CreateTime</td>
<td>Price</td>
<td></td>
</tr>
@foreach (var item in Model)
{
    <tr>
    <td>@item.Id</td>
    <td>@item.ProductName</td>
    <td>@item.CreateTime</td>
    <td>@item.Price</td>
    <td>
    @Html.ActionLink("Edit", "Edit", new { id = item.Id })
    @Html.ActionLink("Delete", "Delete", new { id = item.Id})
    </td>
    </tr>
}
</table>

此时列表页面已经完成

2.创建添加页面

进入ProductControl文件,添加如下代码

        public ActionResult Create()
        {
            ViewBag.categoryList = GetCategoryitems();
            return View();
        }
        [HttpPost]
        public ActionResult AddProduct(Product product)
        {
            context.Products.InsertOnSubmit(product);
            context.SubmitChanges();
            return RedirectToAction("Index");
        }

        public List<SelectListItem> GetCategoryitems()
        {
            var categorys = from category in context.Categories.ToList()
                            select new SelectListItem()
                            {
                                Text = category.CategoryName,
                                Value = category.Id.ToString()
                            };
            List<SelectListItem> items = new List<SelectListItem>();
            items.Add(new SelectListItem() { Text = "Choose an option" });
            items.AddRange(categorys);
            return items;
        }

然后鼠标放在Create上面创建View

@model MusicStore.Product

@{
    ViewBag.Title = "Create";
}

<h2>Create</h2>


@using (Html.BeginForm("AddProduct","Product"))
{
    <fieldset>
    <div>
    @Html.Label("Product")
    </div>
    <div>
    @Html.EditorFor(p =>p.ProductName)
    </div>

    <div>
    @Html.Label("Price")
    </div>
    <div>
    @Html.EditorFor(p =>p.Price)
    </div>

    <div>
    @Html.Label("CreateTime")
    </div>
    <div>
    @Html.EditorFor(p =>p.CreateTime)
    </div>

    <div>
    @Html.Label("ProductCategory")
    </div>
    <div>
    @Html.DropDownListFor(m =>m.ParentId,ViewBag.categoryList as List<SelectListItem>)
    </div>
    <input type="submit" value="Save" />
    </fieldset>
}

3.创建编辑界面

进入ProductControl文件,添加如下代码

        public ActionResult Edit(int Id)
        {
            productView.productList = (from p in context.Products
                                       select p).First(c => c.Id == Id);
            ViewBag.categoryList = GetCategoryitems();
            return View(productView);
        }
        [HttpPost]
        public ActionResult Update(ProductModelView productModel)
        {
            Product product = context.Products.First(p => p.Id == productModel.productList.Id);
            product.ProductName = productModel.productList.ProductName;
            product.Price = productModel.productList.Price;
            product.CreateTime = productModel.productList.CreateTime;
            product.ParentId = productModel.productList.ParentId;
            context.SubmitChanges();

            return RedirectToAction("Index");
        }

然后添加Edit 的View

@model MusicStore.Models.ProductModelView

@{
    ViewBag.Title = "Edit";
}

<h2>Edit</h2>

@using (Html.BeginForm("Update", "Product"))
{
    <fieldset>
    <legend>Product</legend>
       @Html.HiddenFor(p =>p.productList.Id)
    <p>
        <div>
    @Html.LabelFor(p => p.productList.ProductName)
    </div>
    <div>
    @Html.EditorFor(p => p.productList.ProductName)
    </div>
    </p>

<p>
    <div>
    @Html.LabelFor(p => p.productList.Price)
    </div>
    <div>
    @Html.EditorFor(p => p.productList.Price)
    </div>
</p>

<p>
    <div>
    @Html.LabelFor(p => p.productList.CreateTime)
    </div>
    <div>
    @Html.EditorFor(p => p.productList.CreateTime)
    </div>

    <div>
    @Html.Label("ProductCategory")
    </div>
    <div>
    @Html.DropDownListFor(m => m.productList.ParentId, ViewBag.categoryList as List<SelectListItem>)
    </div>
</p>
    <input type="submit" value="submit" />
    </fieldset>
}

4.添加删除功能

进入ProductControl添加如下代码即可

        public ActionResult Delete(int id)
        {
            Product produt = context.Products.First(p => p.Id == id);
            context.Products.DeleteOnSubmit(produt);
            context.SubmitChanges();
            return RedirectToAction("Index");
        }

此 Demo下载地址请点击here