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 | 29 +++++++++++++++++++++++++++++ 1 files changed, 29 insertions(+), 0 deletions(-) diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs index 0759fca..9c0b71b 100644 --- a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs +++ b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderExtendDAL.cs @@ -97,6 +97,8 @@ delayTime, new SqlParameter("@Productionprogress",trueModel.Productionprogress), new SqlParameter("@PrintPackDeliveryRequir",trueModel.PrintPackDeliveryRequir), + new SqlParameter("@printunit",trueModel.printunit), + new SqlParameter("@Duiyinghetongbianhao",trueModel.Duiyinghetongbianhao) }; int i = -1; @@ -158,6 +160,8 @@ new SqlParameter("@NumPerBag",trueModel.NumPerBag), new SqlParameter("@BagNum",trueModel.BagNum), new SqlParameter("@PrintPackDeliveryRequir",trueModel.PrintPackDeliveryRequir), + new SqlParameter("@printunit",trueModel.printunit), + new SqlParameter("@Duiyinghetongbianhao",trueModel.Duiyinghetongbianhao) }; try { @@ -354,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