public bool AddOrderDetail(T_OrderDetail model) { using (var db = new cakedbEntities()) { db.Set <T_OrderDetail>().Add(model); return(db.SaveChanges() > 0); } }
private void GetOrder() { string ordercode = ""; if (Request["code"] != null) { ordercode = Request["code"].ToString(); } if (ordercode != "") { T_Order model = new T_Order(); T_OrderDetail detail = new T_OrderDetail(); OrderBll bll = new OrderBll(); model = bll.GetOrder(ordercode); detail = bll.GetOrderDetailByCode(ordercode); if (model != null) { //商户订单号,商户网站订单系统中唯一订单号,必填 out_trade_no = model.OrderCode; //订单名称,必填 subject = detail.ProductName.Trim(); //付款金额,必填 total_fee = model.OrderPrice.ToString(); //收银台页面上,商品展示的超链接,必填 show_url = "http://m.makacake.com/productdetail.aspx?wd=" + detail.ProductId; //商品描述,可空 body = detail.ProductName; //把请求参数打包成数组 Config config = new Config(); SortedDictionary <string, string> sParaTemp = new SortedDictionary <string, string>(); sParaTemp.Add("partner", config.partner); sParaTemp.Add("seller_id", config.seller_id); sParaTemp.Add("_input_charset", config.input_charset.ToLower()); sParaTemp.Add("service", config.service); sParaTemp.Add("payment_type", config.payment_type); sParaTemp.Add("notify_url", config.notify_url); sParaTemp.Add("return_url", config.return_url); sParaTemp.Add("out_trade_no", out_trade_no); sParaTemp.Add("subject", subject); sParaTemp.Add("total_fee", total_fee); sParaTemp.Add("show_url", show_url); sParaTemp.Add("body", body); //其他业务参数根据在线开发文档,添加参数.文档地址:https://doc.open.alipay.com/doc2/detail.htm?spm=a219a.7629140.0.0.2Z6TSk&treeId=60&articleId=103693&docType=1 //如sParaTemp.Add("参数名","参数值"); //建立请求 string sHtmlText = Submit.BuildRequest(sParaTemp, "get", "确认"); Response.Write(sHtmlText); } } }
// 詳細データ更新 // in : T_OrderDetailデータ // out : エラーメッセージ public string PutOrderDetail(T_OrderDetail regOrderDetail) { using (var db = new SalesManagement_DevContext()) { T_OrderDetail orderdetail; try { orderdetail = db.T_OrderDetails.Single(x => x.OrDetailID == regOrderDetail.OrDetailID); } catch { return(_msc.GetMessage(110)); } orderdetail.OrDetailID = regOrderDetail.OrDetailID; orderdetail.OrID = regOrderDetail.OrID; orderdetail.PrID = regOrderDetail.PrID; orderdetail.OrQuantity = regOrderDetail.OrQuantity; orderdetail.OrTotalPrice = regOrderDetail.OrTotalPrice; db.Entry(orderdetail).State = EntityState.Modified; try { db.SaveChanges(); } catch { // throw new Exception(Messages.errorConflict, ex); // throw new Exception(_cm.GetMessage(100), ex); return(_msc.GetMessage(100)); } // ログ出力 var operationLog = new OperationLog() { EventRaisingTime = DateTime.Now, Operator = _logonUser, Table = "OrderDetail", Command = "Put", //Data = ProductLogData(regProduct), }; //StaticCommon.PostOperationLog(operationLog); return(string.Empty); } }
// データ追加 // in : T_OrderDetailデータ public string PostT_OrderDetail(T_OrderDetail regOrderDetail) { using (var db1 = new SalesManagement_DevContext()) { db1.T_OrderDetails.Add(regOrderDetail); db1.Entry(regOrderDetail).State = EntityState.Added; db1.SaveChanges(); } //// ログ出力 //var operationLog = new OperationLog() //{ // EventRaisingTime = DateTime.Now, // Operator = _logonUser, // Table = "Order", // Command = "Post", // Data = T_OrderLogData(regOrder), // Comments = string.Empty //}; //StaticCommon.PostOperationLog(operationLog); return(string.Empty); }
public bool AddOrderByUserId(string card, string bastdate, string paytype, string remark, string ordercode) { UserBll userbll = new UserBll(); // int csum = Convert.ToInt32(sum); int userid = 0; userid = userbll.GetUserIdByToken(); bool orderres = false; if (userid > 0) { T_Order order = new T_Order(); CartBll cartbll = new CartBll(); OrderDal orderdal = new OrderDal(); List <T_Cart> cartlist = new List <T_Cart>(); cartlist = cartbll.GetCartListByUserId(userid); AddressBll addressbll = new AddressBll(); T_Address address = new T_Address(); // UserBll userbll = new UserBll(); T_User user = new T_User(); user = userbll.GerUserByUserId(userid); address = addressbll.GetAddressByUserId(); order.OrderCode = ordercode; order.CreateDate = DateTime.Now; order.Adress = address.Adress + address.Area + "_" + address.Name; order.Mobile = address.Mobile; order.OrderStatus = "待付款"; order.PayType = paytype; order.bastdate = bastdate; order.card_birthday = card; order.Remark = remark; order.UserId = userid; string makabi = ""; decimal?sumprice = 0; int makaprice = 0; bool res = false; if (cartlist != null) { foreach (T_Cart cart in cartlist) { T_OrderDetail orderdetail = new T_OrderDetail(); orderdetail.CreateDate = DateTime.Now; orderdetail.OrderCode = order.OrderCode; orderdetail.ProductId = cart.ProductId; orderdetail.ProductName = cart.ProductName; orderdetail.ProductNumber = cart.ProductNumber; orderdetail.ProductPrice = cart.ProductPrice; orderdetail.Specification = cart.Specification; res = orderdal.AddOrderDetail(orderdetail); if (res) { cartbll.DelCartById(cart.Id); } sumprice = sumprice + cart.ProductPrice; } } if (user != null) { makabi = user.MaKaCurrency.ToString(); makaprice = (int)user.MaKaCurrency / 10; if (makaprice >= sumprice) { sumprice = 0; } else { sumprice = (int)sumprice - makaprice; } order.makabi = user.MaKaCurrency; } if (sumprice <= 230) { sumprice = sumprice + 18; order.fare = 18; } else { order.fare = 0; } order.OrderPrice = sumprice; orderres = orderdal.AddOrder(order); if (orderres) { userbll.UpdateUser(userid, (int)user.MaKaCurrency); } return(orderres); } else { return(false); } }