当前位置: 代码迷 >> ASP.NET >> MVC3.0数据插入有关问题,求指教,插入数据不成功
  详细解决方案

MVC3.0数据插入有关问题,求指教,插入数据不成功

热度:8174   发布时间:2013-02-25 00:00:00.0
MVC3.0数据插入问题,求指教,插入数据不成功
ActionResult代码:
C# code
 [HttpPost]        public ActionResult Index(Orders order, FormCollection formcollection)        {            OrderLines orderline = new OrderLines();            OrderLineDetails orderlinedetail = new OrderLineDetails();            order.OrderId = System.DateTime.Now.ToString("yyMMddHHmmssffff");            orderline.OrderLineId = System.DateTime.Now.ToString("yyMMddHHmmssffff");            orderlinedetail.OrderLineDetailId = System.DateTime.Now.ToString("yyMMddHHmmssffff");            order.ShippingConsignee = Request.Form["consignee"].ToString();            order.ShippingPostCode = Request.Form["postcode"].ToString();            order.ShippingTel = Request.Form["tel"].ToString();            order.ShippingMobile = Request.Form["mobile"].ToString();            order.ShippingAddressInfo = Request.Form["address"].ToString();            order.ShippingProvince = Request.Form["province"];            order.ShippingCity = Request.Form["city"];            order.ShippingDistrict = Request.Form["district"];            order.ShippingMobile = Request.Form["mobile"].ToString();            order.ShippingPostCode = Request.Form["postcode"].ToString();            order.MemberEmail = Request.Form["email"];            order.Remark = Request.Form["fq"] + ",";            ViewData["oid"] = order.OrderId;            ViewProductDetail product = datacontext.GetProduct(Request.Form["productid"]);            orderline.Price = product.DetailPrice;            orderline.OrderId = order.OrderId;            orderlinedetail.OrderId = order.OrderId;            orderlinedetail.OrderLineId = orderline.OrderLineId;            orderlinedetail.ProductDetailCode = product.DetailCode;            orderlinedetail.ProductDetailName = product.DetailName;            orderlinedetail.Size = Request.Form["ringsize"];            if (Request.Form["Message1"] != "")            {                order.Remark += Request.Form["Message1"];            }            order.OrderFrom = "工行商城";            if (Request.Form["invoice_title"] != "")            {                order.InvoiceContent = Request.Form["invoice_title"];            }            UpdateModel(order);            datacontext.Add(order);            UpdateModel(orderline);            datacontext.Add(orderline);            UpdateModel(orderlinedetail);            datacontext.Add(orderlinedetail);            datacontext.Save();            return RedirectToAction("Details", "Order", new { orderid = order.OrderId });        }

插入数据和保存数据的方法代码:
C# code
 //添加订单        public void Add(Orders order)        {            using (DavidnileDataContext datacontext = new DavidnileDataContext())            {                datacontext.Orders.InsertOnSubmit(order);            }        }        //添加订单信息        public void Add(OrderLines orderline)        {            using (DavidnileDataContext datacontext = new DavidnileDataContext())            {                datacontext.OrderLines.InsertOnSubmit(orderline);            }        }        //添加详细订单信息        public void Add(OrderLineDetails orderlinedetail)        {            using (DavidnileDataContext datacontext = new DavidnileDataContext())            {                datacontext.OrderLineDetails.InsertOnSubmit(orderlinedetail);            }        }        //信息保存        public void Save()        {            using (DavidnileDataContext datacontext = new DavidnileDataContext())            {                datacontext.SubmitChanges();            }        }
  相关解决方案