username@email.com
2025-10-22 0de684b2cd131f9801ca96abdb9028f7e30cd31b
CY_ECommercePlatform/CY.SQLDAL/OA/OA_CorporateClientsDAL.cs
@@ -265,6 +265,64 @@
            return true;
        }
        /// <summary>
        /// 修改完结
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateWanjie(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.OA_CorporateClients trueModel = model as Model.OA_CorporateClients;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter par = null;
            if (trueModel.LastOrderTime.HasValue)
            {
                par = new SqlParameter("@LastOrderTime", trueModel.LastOrderTime.Value);
            }
            else
            {
                par = new SqlParameter("@LastOrderTime", DBNull.Value);
            }
            SqlParameter par1 = null;
            if (trueModel.WanjieTime.HasValue)
            {
                par1 = new SqlParameter("@WanjieTime", trueModel.WanjieTime.Value);
            }
            else
            {
                par1 = new SqlParameter("@WanjieTime", DBNull.Value);
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                    new SqlParameter("@Keyid",trueModel.Keyid),
                    par,
                       par1,
                            new SqlParameter("@Shifouwanjie",trueModel.Shifouwanjie??0) ,
            };
            string sql = "Update [OA_CorporateClients] Set [Shifouwanjie]=@Shifouwanjie,[WanjieTime]=@WanjieTime,[LastOrderTime]=@LastOrderTime  where [Keyid] =@Keyid ";
            try
            {
                _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }
        /// <summary>
        /// 转移客户
        /// </summary>