username@email.com
2025-04-22 277cffdd657197fbd72444ef24a99dde7a469011
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),
@@ -111,7 +123,8 @@
                    new SqlParameter("@PaperWeightId",trueModel.PaperWeightId),
                   new SqlParameter("@tanPrice",trueModel.TanPrice??0),
                   new SqlParameter("@ReceiveMoney",trueModel.ReceiveMoney),
                    new SqlParameter("@Commodityid",trueModel.Commodityid)
                    new SqlParameter("@Commodityid",trueModel.Commodityid),
                     new SqlParameter("@WarehouseName",string.IsNullOrEmpty(trueModel.WarehouseName)?"":trueModel.WarehouseName),
            };
            try
            {