增删改

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Net;
using System.Web;
using System.Web.Mvc;
using WebApplication1.Models;

namespace WebApplication1.Controllers
{
public class aController : Controller
{
private Model1 db = new Model1();

// GET: a
public ActionResult Index(string AssetName, string AssetTypeID)
{
var b = db.AssetInfo.Select(x => new Class1()
{
AssetID = x.AssetID,
AssetName = x.AssetName,
AssetTypeID = x.AssetTypeID,
AssetModel = x.AssetModel,
AssetCompany = x.AssetCompany,
AssetReMark = x.AssetReMark,
Names = x.AssetTypeInfo.TypeName
}).ToList();
ViewBag.AssetTypeID = List();
ViewBag.name = AssetName;
if (!string.IsNullOrEmpty(AssetName))
{
b = b.Where(x => x.AssetName == AssetName).ToList();
}
if (!string.IsNullOrEmpty(AssetTypeID))
{
b = b.Where(x => x.AssetTypeID ==Convert.ToInt32(AssetName)).ToList();
}
return View(b.ToList());
}

public List List() {
var a = db.AssetTypeInfo.ToList().Select(x => new SelectListItem()
{
Text = x.TypeName,
Value = x.TypeID.ToString()
}).ToList();
return a;
}


// GET: a/Details/5
public ActionResult Details(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
AssetInfo assetInfo = db.AssetInfo.Find(id);
if (assetInfo == null)
{
return HttpNotFound();
}
return View(assetInfo);
}

// GET: a/Create
public ActionResult Create()
{
ViewBag.AssetTypeID = List();
return View();
}

// POST: a/Create
// 为了防止“过多发布”攻击，请启用要绑定到的特定属性，有关 
// 详细信息，请参阅 go.microsoft.com/fwlink/?Lin…         [HttpPost]

public ActionResult Create( AssetInfo a)
{
ViewBag.AssetTypeID = List();
if (ModelState.IsValid)
{
db.AssetInfo.Add(a);
db.SaveChanges();
ViewBag.info = "添加成功";
}         
return View(a);
}

// GET: a/Edit/5
public ActionResult Edit(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
AssetInfo assetInfo = db.AssetInfo.Find(id);
if (assetInfo == null)
{
return HttpNotFound();
}
ViewBag.AssetTypeID = new SelectList(db.AssetTypeInfo, "TypeID", "TypeName", assetInfo.AssetTypeID);
return View(assetInfo);
}

// POST: a/Edit/5
// 为了防止“过多发布”攻击，请启用要绑定到的特定属性，有关 
// 详细信息，请参阅 go.microsoft.com/fwlink/?Lin…         [HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Edit([Bind(Include = "AssetID,AssetName,AssetTypeID,AssetModel,AssetCompany,AssetReMark")] AssetInfo assetInfo)
{
if (ModelState.IsValid)
{
db.Entry(assetInfo).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.AssetTypeID = new SelectList(db.AssetTypeInfo, "TypeID", "TypeName", assetInfo.AssetTypeID);
return View(assetInfo);
}


[HttpPost]
public ActionResult Delete(int? id)
{
var a = db.AssetInfo.FirstOrDefault(x =>x.AssetID== id);
if (a!= null)
{
db.AssetInfo.Remove(a);
db.SaveChanges();
}
return Json(new {Flag=1,Msg="删除成功！"});
}


protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
}
}\