读书人

MVC3.0数据插入有关问题求指教插入

发布时间: 2012-09-03 09:48:39 作者: rapoo

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();            }        } 


view页面上
HTML code
<form id="form1" enableviewstate="false" method="post" action="Address/Index">
页面上的脚本就没贴全,我的目的是向三个表中添加数据,我跟踪了代码,上面的代码都没有错误,而且能从view页面的input里面读取到数据,但是我在数据库中查不到,就是没插入成功,请问这种插入数据的方法有错吗?

[解决办法]
怎么解决的?可以分享一下不

读书人网 >asp.net

热点推荐