From 2605af51ca4787434c8c5f2b10dc0adc78a2fdb0 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期五, 14 三月 2025 17:17:45 +0800 Subject: [PATCH] 外协管理,外协订单,你列表操作后面增加一个完工点,完工就进行。就是说,已完工处理好,前面呢,有个批量完工,好检索查询条件,也加个完工。 --- CY_ECommercePlatform/CY.SQLDAL/OA/OA_ProcurementDAL.cs | 16 ++++++++++++++-- 1 files changed, 14 insertions(+), 2 deletions(-) diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ProcurementDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ProcurementDAL.cs index e4d3e5a..da944f6 100644 --- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ProcurementDAL.cs +++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ProcurementDAL.cs @@ -66,7 +66,9 @@ new SqlParameter("@PaperWeightId",trueModel.PaperWeightId), new SqlParameter("@tanPrice",trueModel.TanPrice??0), new SqlParameter("@ReceiveMoney",decimal.Parse("0")), - new SqlParameter("@Commodityid",trueModel.Commodityid) + new SqlParameter("@Commodityid",trueModel.Commodityid), + new SqlParameter("@orderId",trueModel.orderId.HasValue?trueModel.orderId.Value:0), + new SqlParameter("@DocumentName",string.IsNullOrEmpty(trueModel.DocumentName)?"":trueModel.DocumentName) }; try { @@ -91,11 +93,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