From 2fee7b9b90c1acf7a17aef84ee22c2a31b801fe2 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 07 三月 2025 08:34:42 +0800
Subject: [PATCH] 送货管理 增加查询 业务经理 客户名称 完成 查询送货安排的历史 完成
---
CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs | 31 +++++++++++++++++++++++++++++--
1 files changed, 29 insertions(+), 2 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs
index 6df952b..9c0b71b 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs
@@ -97,7 +97,8 @@
delayTime,
new SqlParameter("@Productionprogress",trueModel.Productionprogress),
new SqlParameter("@PrintPackDeliveryRequir",trueModel.PrintPackDeliveryRequir),
- new SqlParameter("@printunit",trueModel.printunit)
+ new SqlParameter("@printunit",trueModel.printunit),
+ new SqlParameter("@Duiyinghetongbianhao",trueModel.Duiyinghetongbianhao)
};
int i = -1;
@@ -159,7 +160,8 @@
new SqlParameter("@NumPerBag",trueModel.NumPerBag),
new SqlParameter("@BagNum",trueModel.BagNum),
new SqlParameter("@PrintPackDeliveryRequir",trueModel.PrintPackDeliveryRequir),
- new SqlParameter("@printunit",trueModel.printunit)
+ new SqlParameter("@printunit",trueModel.printunit),
+ new SqlParameter("@Duiyinghetongbianhao",trueModel.Duiyinghetongbianhao)
};
try
{
@@ -356,6 +358,31 @@
}
}
+
+ /// <summary>
+ /// 鏇存柊璁㈠崟鎵╁睍琛ㄥ墿浣欏嵃鍒锋暟閲�
+ /// </summary>
+ /// <param name="Keyid"></param>
+ /// <param name="SurplusPrintNum"></param>
+ /// <param name="Operator"></param>
+ /// <returns></returns>
+ public bool UpSurplusPrintNumsql(int? Keyid, int? SurplusPrintNum, string Operator)
+ {
+
+ try
+ {
+ var sqlStr = "UPDATE [EC_OrderExtend] SET [SurplusPrintNum]=[PrintNum] WHERE Keyid=@Keyid ";
+ SqlParameter par = new SqlParameter("@Keyid", Keyid);
+ _dataBase.ExecuteSql(sqlStr, par);
+
+ return true;
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
{
throw new NotImplementedException();
--
Gitblit v1.9.1