From 0034934486fcf6166cea4652e91b11a1b0dc3fce Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期三, 19 二月 2025 17:02:22 +0800 Subject: [PATCH] 生产质量汇报单,增加微瑕品录入方法 --- WebAPI/Controllers/LMESController.cs | 35 ++++++++++++++++++++++++++++++++++- 1 files changed, 34 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/LMESController.cs b/WebAPI/Controllers/LMESController.cs index e6e1b31..7d0c01f 100644 --- a/WebAPI/Controllers/LMESController.cs +++ b/WebAPI/Controllers/LMESController.cs @@ -192,7 +192,7 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); - ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillList_Query where 1 = 1 " + sWhere + " order by 鍗曟嵁鍙� desc ", "h_v_Sc_ProcessExchangeBillList_Query"); + ds = oCN.RunProcReturn("select top 1000 * from h_v_Sc_ProcessExchangeBillList_Query where 1 = 1 " + sWhere + " order by 鍗曟嵁鍙� desc ", "h_v_Sc_ProcessExchangeBillList_Query"); //娣诲姞鍒楀悕 @@ -1777,6 +1777,39 @@ #endregion + #region 宸ヨ壓璺嚎鎵规敼灏忔椂浜ц兘 + [Route("Gy_RoutingBill/BulkWorkQty")] + [HttpGet] + public object BulkWorkQty(string HMaterNumber1, string HMaterNumber2,string HProcID, string HWorkQty) + { + try + { + oCN.BeginTran(); + + string sql = $"update b set b.HWorkQty = {HWorkQty} from Gy_RoutingBillMain a left join Gy_RoutingBillSub b on a.HInterID = b.HInterID left join Gy_Material m on a.HMaterID = m.HItemID where m.HNumber between '{HMaterNumber1}' and '{HMaterNumber2}' and b.HProcID = {HProcID} and a.HCloseMan = ''"; + + //鎵ц鏇存柊涓婄彮宸ユ椂璇彞 + oCN.RunProc(sql); + + oCN.Commit(); + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鎵规敼鎴愬姛锛�"; + objJsonResult.data = null; + return objJsonResult; + } + catch (Exception e) + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + #endregion /// <summary> -- Gitblit v1.9.1