/// <summary> /// 生成订单 /// </summary> /// <param name="orInfo">订单信息实体</param> /// <returns>true 成功 false 失败</returns> public Boolean GenerOrder(OrderInfo orInfo) { lock (obj) { orInfo.OrderID = 1232; orInfo.OrderStateID = 0; orInfo.PayMentStatusID = 0; return orInfoDal.AddOrderInfo(orInfo) > 0; } }
public ContentResult GenerOrderPost(decimal totalMoney,int orBuisnessID) { if (totalMoney <= 0 && orBuisnessID <= 0) { return Content("-1"); } OrderInfo orInfo = new OrderInfo(); orInfo.TotalMoney = totalMoney; orInfo.OrderBuinessID = orBuisnessID; bool resultBool = orInfoBll.GenerOrder(orInfo); return Content(resultBool?"1":"0"); }
/// <summary> /// 添加订单信息 /// </summary> /// <param name="orInfo">订单信息实体</param> /// <returns>-1 失败 1成功</returns> public int AddOrderInfo(OrderInfo orInfo) { int resultInt = -1; #region - sql qy- string insertOrInfoQy = @"INSERT INTO `order`.`orderinfo`( `OrderID`, `OrderBusinessID`, `TotalMoney`, `MeberID`, `OrderStateID`, `PaymentStatusID`, `OrderDate`, `OrderUpdateDate`, `avg1`, `avg2`) VALUES ( @OrderID, @OrderBusinessID, @TotalMoney, @MeberID, @OrderStateID, @PaymentStatusID, @OrderDate, @OrderUpdateDate, @avg1, @avg2);"; #endregion #region - paras - MySqlParameter[] paras = { new MySqlParameter("@OrderID",orInfo.OrderID), new MySqlParameter("@OrderBusinessID",orInfo.OrderID), new MySqlParameter("@TotalMoney",orInfo.TotalMoney), new MySqlParameter("@MeberID",orInfo.MemberID), new MySqlParameter("@OrderStateID",orInfo.OrderStateID), new MySqlParameter("@PaymentStatusID",orInfo.PayMentStatusID), new MySqlParameter("@OrderDate",DateTime.Now), new MySqlParameter("@OrderUpdateDate",DateTime.Now), new MySqlParameter("@avg1",string.Empty), new MySqlParameter("@avg2",string.Empty), }; #endregion #region - excute - try { resultInt = Convert.ToInt32(DbHelperMySql.ExecuteNonQuery(DbHelperMySql.connectionStringManager, System.Data.CommandType.Text, insertOrInfoQy, paras)); } catch (Exception ex) { //记录生成订单错误信息 throw; } #endregion return resultInt; }