public ActionResult InserOrder(T_OrderHeaderModel T_Orderheader, List <T_OrderDetailModel> T_OrderDetail) { Order_InputBL oib = new Order_InputBL(); DataTable dtorderdetail = new DataTable(); using (var reader = ObjectReader.Create(T_OrderDetail, "OrderID", "AdminCD", "OrderItem", "StockItem", "SalePrice", "TotalAmount", "Memo", "AvailableShippingDate")) { dtorderdetail.Load(reader); } if (dtorderdetail.Rows.Count > 0) { if (Session["CompanyCD"] != null) { string CompanyCD = Session["CompanyCD"].ToString(); T_Orderheader.UpdateOperator = CompanyCD; } T_Orderheader.AccessPC = System.Environment.MachineName; if (oib.Order_Input_Insert(T_Orderheader, dtorderdetail)) { Session["Error"] = null; return(Json(new { orderid = T_Orderheader.OrderID }, JsonRequestBehavior.AllowGet)); //return View();//RedirectToAction("../Order/Order_History/" + T_Orderheader.OrderID); } else { Session["Error"] = "Error"; return(Json(new { msg = "Error" })); } } else { Session["Error"] = "Error"; return(Json(new { msg = "Error" })); } }
public Boolean Order_Input_Insert(T_OrderHeaderModel toh, DataTable dtorder) { try { BaseDL dl = new BaseDL(); SqlParameter[] prms = new SqlParameter[13]; prms[0] = new SqlParameter("@OrderID", SqlDbType.VarChar) { Value = toh.OrderID }; prms[1] = new SqlParameter("@ShippingID", SqlDbType.VarChar) { Value = toh.ShippingID }; if (toh.ShippingName == null) { prms[2] = new SqlParameter("@ShippingName", SqlDbType.VarChar) { Value = DBNull.Value }; } else { prms[2] = new SqlParameter("@ShippingName", SqlDbType.VarChar) { Value = toh.ShippingName }; } if (toh.ZipCD1 == null) { prms[3] = new SqlParameter("@ZipCD1", SqlDbType.VarChar) { Value = DBNull.Value }; } else { prms[3] = new SqlParameter("@ZipCD1", SqlDbType.VarChar) { Value = toh.ZipCD1 }; } if (toh.ZipCD2 == null) { prms[4] = new SqlParameter("@ZipCD2", SqlDbType.VarChar) { Value = DBNull.Value }; } else { prms[4] = new SqlParameter("@ZipCD2", SqlDbType.VarChar) { Value = toh.ZipCD2 }; } if (toh.Address1 == null) { prms[5] = new SqlParameter("@Address1", SqlDbType.VarChar) { Value = DBNull.Value }; } else { prms[5] = new SqlParameter("@Address1", SqlDbType.VarChar) { Value = toh.Address1 }; } if (toh.Address2 == null) { prms[6] = new SqlParameter("@Address2", SqlDbType.VarChar) { Value = DBNull.Value }; } else { prms[6] = new SqlParameter("@Address2", SqlDbType.VarChar) { Value = toh.Address2 }; } if (toh.TelephoneNO == null) { prms[7] = new SqlParameter("@PhoneNo", SqlDbType.VarChar) { Value = DBNull.Value }; } else { prms[7] = new SqlParameter("@PhoneNo", SqlDbType.VarChar) { Value = toh.TelephoneNO }; } prms[8] = new SqlParameter("@TotalAmount", SqlDbType.VarChar) { Value = toh.TotalAmount }; if (toh.Memo == null) { prms[9] = new SqlParameter("@Memo", SqlDbType.VarChar) { Value = DBNull.Value }; } else { prms[9] = new SqlParameter("@Memo", SqlDbType.VarChar) { Value = toh.Memo }; } prms[10] = new SqlParameter("@UpdateOperator", SqlDbType.VarChar) { Value = toh.UpdateOperator }; prms[11] = new SqlParameter("@AccessPC", SqlDbType.VarChar) { Value = toh.AccessPC }; dtorder.TableName = "order"; System.IO.StringWriter writer = new System.IO.StringWriter(); dtorder.WriteXml(writer, XmlWriteMode.WriteSchema, false); string result = writer.ToString(); prms[12] = new SqlParameter("@xml", SqlDbType.Xml) { Value = result }; var option = new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted, Timeout = TimeSpan.MaxValue }; using (TransactionScope scopt = new TransactionScope(TransactionScopeOption.Required, option)) { dl.InsertUpdateDeleteData("Order_Input_Insert", prms); scopt.Complete(); return(true); } } catch (Exception ex) { return(false); } }