From e8e3122fdc4844202fb9e05477d47139e47a8aae Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 12 十二月 2025 08:59:47 +0800
Subject: [PATCH] 作业本送货变二级菜单
---
CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs | 75 ++++++++++++++++++++++++++++++++++++-
1 files changed, 73 insertions(+), 2 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs
index b8b6f62..ddef49d 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
{
@@ -431,12 +476,38 @@
/// <param name="SurplusPrintNum"></param>
/// <param name="Operator"></param>
/// <returns></returns>
- public bool UpShejiStatus(int Keyid, int ShejiStatus, string Operator)
+ public bool UpShejiStatus(int Keyid, int ShejiStatus, string Operator, int XiadanKeyid)
{
try
{
- var sqlStr = "UPDATE [EC_OrderExtend] SET [ShejiStatus]="+ ShejiStatus + " WHERE Keyid=@Keyid ";
+ var sqlStr = "UPDATE [EC_OrderExtend] SET [ShejiStatus]="+ ShejiStatus + " ,[XiadanKeyid]=" + XiadanKeyid + " WHERE Keyid=@Keyid ";
+ SqlParameter par = new SqlParameter("@Keyid", Keyid);
+ _dataBase.ExecuteSql(sqlStr, par);
+
+ return true;
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
+
+
+ /// <summary>
+ /// 鏇存柊璁㈠崟鎵╁睍琛ㄥ墿浣欏嵃鍒锋暟閲�
+ /// </summary>
+ /// <param name="Keyid"></param>
+ /// <param name="SurplusPrintNum"></param>
+ /// <param name="Operator"></param>
+ /// <returns></returns>
+ public bool UpShejijiesuanStatus(int Keyid, int ShejiStatus, string Operator)
+ {
+
+ try
+ {
+ var sqlStr = "UPDATE [EC_OrderExtend] SET [shifoujiesuan]=" + ShejiStatus + " WHERE Keyid=@Keyid ";
SqlParameter par = new SqlParameter("@Keyid", Keyid);
_dataBase.ExecuteSql(sqlStr, par);
--
Gitblit v1.9.1