public SellerOrderRun GetModel(int sellerId, int OrderId, string connectionString, out string errMsg) { SellerOrderRun model = null; errMsg = string.Empty; try { PredicateGroup pdg = new PredicateGroup(); pdg.Predicates = new List <IPredicate>(); pdg.Predicates.Add(Predicates.Field <SellerOrderRun>(o => o.SellerId, Operator.Eq, sellerId)); pdg.Predicates.Add(Predicates.Field <SellerOrderRun>(o => o.OrderId, Operator.Eq, OrderId)); model = GetModel(pdg, connectionString, out errMsg); } catch (Exception ex) { Logger.LogError4Exception(ex, "AppLogger"); } return(model); }
public bool Insert(SellerOrderRun model, string connectionString, out int orderId, out string orderCode, out string errMsg) { var ret = false; errMsg = string.Empty; orderId = 0; orderCode = String.Empty; try { var p = new DynamicParameters(); p.Add("@SellerId", model.SellerId, DbType.Int32); p.Add("@BuyerId", model.BuyerId, DbType.Int32); p.Add("@OrderDate", model.OrderDate, DbType.DateTime); p.Add("@ProductType", model.ProductType, DbType.Int16); p.Add("@ProductQuantity", model.ProductQuantity, DbType.Int32); p.Add("@Amount", model.Amount, DbType.Decimal); p.Add("@OrderState", model.OrderState, DbType.Int16); p.Add("@PayState", model.PayState, DbType.Int16); p.Add("@PayAmount", model.PayAmount, DbType.Decimal); p.Add("@LogisticsState", model.LogisticsState, DbType.Int16); p.Add("@Config", model.Config, DbType.String); p.Add("@Notes", model.Notes, DbType.String); p.Add("@OrderId", 0, DbType.Int32, ParameterDirection.Output); /*返回订单号*/ p.Add("@OrderCode", "", DbType.String, ParameterDirection.Output); /*返回订单代码*/ using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); connection.Execute("proc_Insert_SellerOrderRun", p, null, null, CommandType.StoredProcedure); orderId = p.Get <int>("OrderId"); orderCode = p.Get <string>("OrderCode"); return(orderId > 0); } } catch (Exception ex) { errMsg = ex.Message; Logger.LogError4Exception(ex, "AppLogger"); } return(ret); }
public SellerOrderRunViewModel(SellerOrderRun run) { Amount = run.Amount; BuyerId = run.BuyerId; OrderDate = run.OrderDate; OrderState = run.OrderState; Code = run.Code; Config = run.Config; LDate = run.LDate; RDate = run.RDate; LMan = run.LMan; RMan = run.RMan; ProductQuantity = run.ProductQuantity; OrderId = run.OrderId; string msg = ""; details = SellerOrderDetailBll.GetList(run.SellerId, run.OrderId, out msg); Message = msg; SellerId = run.SellerId; OrderStateString = ((ESellerOrderState)run.OrderState).ToDescription(); }
public JsonResult AddSellerOrdersToDb(string orderdetail) { if (Session["IsGuest"] != null) { bool isGuest = (bool)Session["IsGuest"]; if (isGuest) { return(new JsonResult() { Data = new JsonResponseData() { IsSuccess = false, Msg = "该功能暂未开通" } }); } } JsonResponseData result = new JsonResponseData(); var user = GetUser(); if (user == null) { result.IsSuccess = false; result.Msg = "请重新登陆"; return(new JsonResult() { Data = result }); } var models = JsonConvert.DeserializeObject <List <SellerOrderDetailTinyViewModel> >(orderdetail); if (models == null) { result.IsSuccess = false; result.Msg = "订单无效,无法提交"; return(new JsonResult() { Data = result }); } models = models.Where(m => m.ProductQuantity > 0).ToList(); if (models.Count == 0) { result.IsSuccess = false; result.Msg = "什么也没有买~"; return(new JsonResult() { Data = result }); } SellerOrderRun run = new SellerOrderRun() { Amount = models.Sum(m => m.ProductQuantity * m.Price), BuyerId = user.BuyerId, SellerId = models.First().SellerId, OrderDate = DateTime.Now, Code = "", Config = "", LDate = DateTime.Now, RDate = DateTime.Now, LMan = user.BuyerId, RMan = user.BuyerId, ProductQuantity = models.Sum(m => m.ProductQuantity) }; int orderId; string code; string msg; if (SellerOrderRunBll.Insert(run, out orderId, out code, out msg)) { int index = 0; foreach (SellerOrderDetailTinyViewModel detailTinyViewModel in models) { SellerOrderDetail detail = new SellerOrderDetail() { SellerId = detailTinyViewModel.SellerId, BuyerId = user.BuyerId, LMan = user.BuyerId, RMan = user.BuyerId, LDate = DateTime.Now, RDate = DateTime.Now, Index = index++, OrderId = orderId, ProductId = detailTinyViewModel.ProductId, ProductQuantity = detailTinyViewModel.ProductQuantity, ProductName = detailTinyViewModel.ProductName, ProductPrice = detailTinyViewModel.Price, TotalPrice = detailTinyViewModel.Price * detailTinyViewModel.ProductQuantity, ProductUnit = detailTinyViewModel.ProductUnit }; SellerOrderDetailBll.Insert(detail); BuyerShoppingCartBll.Delete(detail.SellerId, detail.BuyerId, detail.ProductId, out msg); } result.Msg = "订单生成成功"; result.IsSuccess = true; } else { result.Msg = "通讯异常,订单创建失败"; } return(new JsonResult() { Data = result }); }