From 58758cab891e0a1cbe060f2ce8fda0805cdfc99a Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期五, 03 一月 2025 08:44:40 +0800 Subject: [PATCH] 保证金 --- CY_ECommercePlatform/CY.SQLDAL/OA/OA_ProcurementDAL.cs | 12 +++++++++++- 1 files changed, 11 insertions(+), 1 deletions(-) diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ProcurementDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ProcurementDAL.cs index e4d3e5a..45cc514 100644 --- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ProcurementDAL.cs +++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ProcurementDAL.cs @@ -91,11 +91,21 @@ { return false; } + + SqlParameter SuppliersId = null; + if (trueModel.SuppliersId.HasValue) + { + SuppliersId = new SqlParameter("@SuppliersId", trueModel.SuppliersId); + } + else + { + SuppliersId = new SqlParameter("@SuppliersId", DBNull.Value); + } IList<SqlParameter> sqlParms = new List<SqlParameter>() { new SqlParameter("@Keyid",trueModel.Keyid), new SqlParameter("@FirmId",trueModel.FirmId), - new SqlParameter("@SuppliersId",trueModel.SuppliersId), + SuppliersId, new SqlParameter("@GoodsId",trueModel.GoodsId), new SqlParameter("@ClearingStatusId",trueModel.ClearingStatusId), new SqlParameter("@Price",trueModel.Price), -- Gitblit v1.9.1