From 22a7922be8d234c04bdf894b48d9f57fe97c857f Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 15 十月 2024 15:55:30 +0800 Subject: [PATCH] 作业本显示修改 --- CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs | 25 ++++++++++++++++++++++--- 1 files changed, 22 insertions(+), 3 deletions(-) diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs index f9b77bf..4795903 100644 --- a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs +++ b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs @@ -124,6 +124,15 @@ { unitPricePar = new SqlParameter("@UnitPrice", DBNull.Value); } + SqlParameter DeliveryTime = null; + if (trueModel.DeliveryTime.HasValue) + { + DeliveryTime = new SqlParameter("@DeliveryTime", trueModel.DeliveryTime); + } + else + { + DeliveryTime = new SqlParameter("@DeliveryTime", DBNull.Value); + } IList<SqlParameter> sqlParms = new List<SqlParameter>() { new SqlParameter(){ ParameterName ="@Keyid", SqlDbType=System.Data.SqlDbType.Int, DbType=System.Data.DbType.Int32, Direction=ParameterDirection.Output}, @@ -131,7 +140,7 @@ new SqlParameter("@OrderTypeId",trueModel.OrderTypeId), new SqlParameter("@PrintTypeId",trueModel.PrintTypeId), new SqlParameter("@DocumentName",trueModel.DocumentName), - new SqlParameter("@DeliveryTime",trueModel.DeliveryTime), + DeliveryTime,//new SqlParameter("@DeliveryTime",trueModel.DeliveryTime), new SqlParameter("@SellerId",trueModel.SellerId), new SqlParameter("@BuyerId",trueModel.BuyerId), new SqlParameter("@SellerName",trueModel.SellerName){SqlDbType=SqlDbType.VarChar,Size=200}, @@ -178,6 +187,16 @@ { unitPricePar = new SqlParameter("@UnitPrice", DBNull.Value); } + SqlParameter DeliveryTime = null; + if (trueModel.DeliveryTime.HasValue) + { + DeliveryTime = new SqlParameter("@DeliveryTime", trueModel.DeliveryTime); + } + else + { + DeliveryTime = new SqlParameter("@DeliveryTime", DBNull.Value); + } + IList<SqlParameter> sqlParms = new List<SqlParameter>() { @@ -187,8 +206,8 @@ new SqlParameter("@SellerId",trueModel.SellerId), new SqlParameter("@SellerName",trueModel.SellerName), new SqlParameter("@DocumentName",trueModel.DocumentName), - new SqlParameter("@DeliveryTime",trueModel.DeliveryTime), - unitPricePar, + DeliveryTime,//new SqlParameter("@DeliveryTime",trueModel.DeliveryTime), + unitPricePar, new SqlParameter("@SumPrice",trueModel.SumPrice), new SqlParameter("@PayState",trueModel.PayState), new SqlParameter("@Operator",trueModel.Operator), -- Gitblit v1.9.1