ASP.NET MVC2.0实现数据的增、删、改、查

 

 1.在model目录内新建类：

public class Product
    {
        public int ProductID { get; set; }

        private string _ProductName;

        public string ProductName
        {
            get { return _ProductName; }
            set { _ProductName = value; }
        }
        private double _ProductPrice;
       
        public double ProductPrice
        {
            get { return _ProductPrice; }
            set { _ProductPrice = value; }
        }
        private DateTime _ProductDate;

        public DateTime ProductDate
        {
            get { return _ProductDate; }
            set { _ProductDate = value; }
        }

        public string ProductDateStr
        {
            get
            {
                return this.ProductDate.ToString("yyyy/MM/dd"); //注意此处要这样转换时间格式，
                                                                //否则界面上会是另外一种时间表示法
            }
            set
            {
                ProductDate = Convert.ToDateTime(value);
            }
        }
    }

2.在Controls中创建ProductControl，命名约定就是模型名称+Control。在Control里面是写业务逻辑和访问数据。严格地说访问数据应该放到Model里面

static List<Product> _productList = null;
        static ProductController()//构造数据
        {
            _productList = new List<Product> { new Product{ ProductID=1, ProductName="施乐相机", ProductPrice=500.00, ProductDate=Convert.ToDateTime("2010-1-1")} ,
                                                             new Product{ProductID=2, ProductName="三星手机", ProductPrice=600.00, ProductDate=Convert.ToDateTime("2010-2-2")},
                                                             new Product{ ProductID=3, ProductName="KFC", ProductPrice=50.00, ProductDate=Convert.ToDateTime("2011-11-11")} ,
                                                             new Product{ProductID=4, ProductName="花茶", ProductPrice=400.00, ProductDate=Convert.ToDateTime("2010-3-3")}};
        }

        public ActionResult Index()
        {
            ViewData["ProductList"] = _productList;//ViewData是control向视图传送数据的容器
            return View();
        }

        public ActionResult Delete(int id)
        {
            Product delObj = _productList.FirstOrDefault(c => c.ProductID == id);
            _productList.Remove(delObj);
            ViewData["ProductList"] = _productList;
            //将数据转换成json对象返回到界面
            //这时界面使用的是Get请求方式
            return Json("",JsonRequestBehavior.AllowGet);
        }

        public ActionResult Detail(int? id)//查看详细
        {
            Product product = _productList.FirstOrDefault(c => c.ProductID == id);
            //ViewData["Product"] = Json(delObj);
            //return View();
            //返回json对象
            return this.Json(product);
        }

        public ActionResult AddProduct(Product product)
        {
            _productList.Add(product);
            ViewData["ProductList"] = _productList;
            return this.Json(product);
        }

        public ActionResult Modify(Product product)
        {
            Product tmp = _productList.FirstOrDefault(c => c.ProductID == product.ProductID);
            tmp.ProductName = product.ProductName;
            tmp.ProductPrice = product.ProductPrice;
            tmp.ProductDate = product.ProductDate;
            return this.Json(product);
        }