From 529d8cb61421eb65d86559d3d2636ad405b87b41 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 22 七月 2025 08:50:06 +0800 Subject: [PATCH] 专版 四色 八色 自翻印刷的时候 ctp 4张 扣版 8张 --- CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs | 52 +++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 51 insertions(+), 1 deletions(-) diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs index ad4b9c5..7ce51d2 100644 --- a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs +++ b/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 { -- Gitblit v1.9.1