送货费用

username@email.com

昨天 eb07d0be014b11568d4263b470d46b5cd427fe9b

 CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs

@@ -1761,6 +1761,44 @@
            }
        }




        /// <summary>
        /// 修改订单送货金额
        /// </summary>
        /// <param name="orderOperate">订单操作</param>
        /// <returns></returns>
        internal bool UpdateOrderSonghuoJine(int OrderId,decimal? SonghuoJine)
        {
           
            
            _eC_OrderOperateDAL = null == _eC_OrderOperateDAL ? new EC_OrderOperateDAL(_dataBase) : _eC_OrderOperateDAL;
            try
            {

                bool isWin = false;
               

                IList<SqlParameter> sqlParms = new List<SqlParameter>()
                    {
                            new SqlParameter("@orderId",OrderId),
                            new SqlParameter("@SonghuoJine",SonghuoJine.HasValue?SonghuoJine.Value:0),
                            
                    };
                string sql = "Update [EC_OrderExtend] Set [SonghuoJine]=@SonghuoJine  where [Keyid] =@orderId ";

               
                    _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
   
                return true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根据新增订单操作，并修改订单状态
        /// </summary>
@@ -2626,7 +2664,8 @@
                        new SqlParameter(){ParameterName="@AppointCourierCompany",Value=awbInfo.AppointCourierCompany,SqlDbType=SqlDbType.VarChar,Size=50},
                        new SqlParameter(){ParameterName="@FetchAddress",Value=awbInfo.FetchAddress,SqlDbType=SqlDbType.VarChar,Size=200},
                        new SqlParameter(){ParameterName="@FetchContacts",Value=awbInfo.FetchContacts,SqlDbType=SqlDbType.VarChar,Size=50},
                        new SqlParameter(){ParameterName="@FetchPhoneNum",Value=awbInfo.FetchPhoneNum,SqlDbType=SqlDbType.VarChar,Size=20}
                        new SqlParameter(){ParameterName="@FetchPhoneNum",Value=awbInfo.FetchPhoneNum,SqlDbType=SqlDbType.VarChar,Size=20},
                         new SqlParameter(){ParameterName="@SonghuoJine",Value=awbInfo.SonghuoJine.HasValue?awbInfo.SonghuoJine.Value:0,SqlDbType=SqlDbType.Money}
                    };
                    _dataBase.Query("sp_EC_AwbInfo_DeliverPresswork", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
                    isWin = 1.Equals(sqlParms[0].Value);
@@ -2647,6 +2686,17 @@
                            return false;
                        else
                            ;

                        if(awbInfo.Operate.OperateType == 5)
                            isWin = this.UpdateOrderSonghuoJine(awbInfo.Keyid.Value, awbInfo.SonghuoJine);//修改订单状态
                        else
                        {
                            isWin = this.UpdateOrderSonghuoJine(awbInfo.Keyid.Value, 0);//修改订单状态
                        }
                        if (!isWin)
                            return false;
                        else
                            ;
                    }
                    else
                    {