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