From 4142cf95cc3d543a3273d96b87fa041310cfff3a Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 12 八月 2025 12:23:18 +0800 Subject: [PATCH] 设计订单其他要加上 --- CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs | 45 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 45 insertions(+), 0 deletions(-) diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs index b8b6f62..2d963fa 100644 --- a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs +++ b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs @@ -119,6 +119,28 @@ new SqlParameter("@ShejiSumPriceneiye",trueModel.ShejiSumPriceneiye.HasValue?trueModel.ShejiSumPriceneiye.Value:0), new SqlParameter("@Shejicount",trueModel.Shejicount.HasValue?trueModel.Shejicount.Value:0), new SqlParameter("@Shejicountneiye",trueModel.Shejicountneiye.HasValue?trueModel.Shejicountneiye.Value:0), + new SqlParameter("@ShejiUnitPriceneiye1",trueModel.ShejiUnitPriceneiye1.HasValue?trueModel.ShejiUnitPriceneiye1.Value:0), + new SqlParameter("@ShejiSumPriceneiye1",trueModel.ShejiSumPriceneiye1.HasValue?trueModel.ShejiSumPriceneiye1.Value:0), + new SqlParameter("@Shejicountneiye1",trueModel.Shejicountneiye1.HasValue?trueModel.Shejicountneiye1.Value:0), + new SqlParameter("@ShejiUnitPriceneiye2",trueModel.ShejiUnitPriceneiye2.HasValue?trueModel.ShejiUnitPriceneiye2.Value:0), + new SqlParameter("@ShejiSumPriceneiye2",trueModel.ShejiSumPriceneiye2.HasValue?trueModel.ShejiSumPriceneiye2.Value:0), + new SqlParameter("@Shejicountneiye2",trueModel.Shejicountneiye2.HasValue?trueModel.Shejicountneiye2.Value:0), + + new SqlParameter("@Shejirenyuanneiye1",trueModel.Shejirenyuanneiye1.HasValue?trueModel.Shejirenyuanneiye1.Value:0), + new SqlParameter("@ShejirenyuanNameneiye1",string.IsNullOrEmpty(trueModel.ShejirenyuanNameneiye1)?"":trueModel.ShejirenyuanNameneiye1), + new SqlParameter("@Shejileixingneiye1",trueModel.Shejileixingneiye1.HasValue?trueModel.Shejileixingneiye1.Value:0), + new SqlParameter("@ShejileixingNameneiye1",string.IsNullOrEmpty(trueModel.ShejileixingNameneiye1)?"":trueModel.ShejileixingNameneiye1), + new SqlParameter("@Danshuangmianneiye1",string.IsNullOrEmpty(trueModel.Danshuangmianneiye1)?"":trueModel.Danshuangmianneiye1), + new SqlParameter("@Shejiyaoqiuneiye1",string.IsNullOrEmpty(trueModel.Shejiyaoqiuneiye1)?"":trueModel.Shejiyaoqiuneiye1), + + + + new SqlParameter("@Shejirenyuanneiye2",trueModel.Shejirenyuanneiye2.HasValue?trueModel.Shejirenyuanneiye2.Value:0), + new SqlParameter("@ShejirenyuanNameneiye2",string.IsNullOrEmpty(trueModel.ShejirenyuanNameneiye2)?"":trueModel.ShejirenyuanNameneiye2), + new SqlParameter("@Shejileixingneiye2",trueModel.Shejileixingneiye2.HasValue?trueModel.Shejileixingneiye2.Value:0), + new SqlParameter("@ShejileixingNameneiye2",string.IsNullOrEmpty(trueModel.ShejileixingNameneiye2)?"":trueModel.ShejileixingNameneiye2), + new SqlParameter("@Danshuangmianneiye2",string.IsNullOrEmpty(trueModel.Danshuangmianneiye2)?"":trueModel.Danshuangmianneiye2), + new SqlParameter("@Shejiyaoqiuneiye2",string.IsNullOrEmpty(trueModel.Shejiyaoqiuneiye2)?"":trueModel.Shejiyaoqiuneiye2), }; int i = -1; @@ -201,6 +223,29 @@ new SqlParameter("@ShejiSumPriceneiye",trueModel.ShejiSumPriceneiye.HasValue?trueModel.ShejiSumPriceneiye.Value:0), new SqlParameter("@Shejicount",trueModel.Shejicount.HasValue?trueModel.Shejicount.Value:0), new SqlParameter("@Shejicountneiye",trueModel.Shejicountneiye.HasValue?trueModel.Shejicountneiye.Value:0), + new SqlParameter("@ShejiUnitPriceneiye1",trueModel.ShejiUnitPriceneiye1.HasValue?trueModel.ShejiUnitPriceneiye1.Value:0), + new SqlParameter("@ShejiSumPriceneiye1",trueModel.ShejiSumPriceneiye1.HasValue?trueModel.ShejiSumPriceneiye1.Value:0), + new SqlParameter("@Shejicountneiye1",trueModel.Shejicountneiye1.HasValue?trueModel.Shejicountneiye1.Value:0), + new SqlParameter("@ShejiUnitPriceneiye2",trueModel.ShejiUnitPriceneiye2.HasValue?trueModel.ShejiUnitPriceneiye2.Value:0), + new SqlParameter("@ShejiSumPriceneiye2",trueModel.ShejiSumPriceneiye2.HasValue?trueModel.ShejiSumPriceneiye2.Value:0), + new SqlParameter("@Shejicountneiye2",trueModel.Shejicountneiye2.HasValue?trueModel.Shejicountneiye2.Value:0), + + + new SqlParameter("@Shejirenyuanneiye1",trueModel.Shejirenyuanneiye1.HasValue?trueModel.Shejirenyuanneiye1.Value:0), + new SqlParameter("@ShejirenyuanNameneiye1",string.IsNullOrEmpty(trueModel.ShejirenyuanNameneiye1)?"":trueModel.ShejirenyuanNameneiye1), + new SqlParameter("@Shejileixingneiye1",trueModel.Shejileixingneiye1.HasValue?trueModel.Shejileixingneiye1.Value:0), + new SqlParameter("@ShejileixingNameneiye1",string.IsNullOrEmpty(trueModel.ShejileixingNameneiye1)?"":trueModel.ShejileixingNameneiye1), + new SqlParameter("@Danshuangmianneiye1",string.IsNullOrEmpty(trueModel.Danshuangmianneiye1)?"":trueModel.Danshuangmianneiye1), + new SqlParameter("@Shejiyaoqiuneiye1",string.IsNullOrEmpty(trueModel.Shejiyaoqiuneiye1)?"":trueModel.Shejiyaoqiuneiye1), + + + + new SqlParameter("@Shejirenyuanneiye2",trueModel.Shejirenyuanneiye2.HasValue?trueModel.Shejirenyuanneiye2.Value:0), + new SqlParameter("@ShejirenyuanNameneiye2",string.IsNullOrEmpty(trueModel.ShejirenyuanNameneiye2)?"":trueModel.ShejirenyuanNameneiye2), + new SqlParameter("@Shejileixingneiye2",trueModel.Shejileixingneiye2.HasValue?trueModel.Shejileixingneiye2.Value:0), + new SqlParameter("@ShejileixingNameneiye2",string.IsNullOrEmpty(trueModel.ShejileixingNameneiye2)?"":trueModel.ShejileixingNameneiye2), + new SqlParameter("@Danshuangmianneiye2",string.IsNullOrEmpty(trueModel.Danshuangmianneiye2)?"":trueModel.Danshuangmianneiye2), + new SqlParameter("@Shejiyaoqiuneiye2",string.IsNullOrEmpty(trueModel.Shejiyaoqiuneiye2)?"":trueModel.Shejiyaoqiuneiye2), }; try { -- Gitblit v1.9.1