From eb0ba055c5ba730c5ce9e205d38578114d57ac44 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期五, 17 九月 2021 17:22:51 +0800 Subject: [PATCH] 编辑器具改制入库(编辑获取表头信息) --- WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs | 23 ++++++++++++++++++++--- 1 files changed, 20 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs b/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs index 31ccfda..4e87e69 100644 --- a/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs +++ b/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs @@ -4209,7 +4209,7 @@ #region 鍣ㄥ叿鏀瑰埗鍏ュ簱鍗曟嵁缁存姢鍒楄〃 - [Route("Sc_MouldRepairInBillList/GetMouldRepairInBillList")] + [Route("Sc_CheckToolsRepairWorkBillList/GetMouldRepairInBillList")] [HttpGet] public object GetMouldRepairInBillList(string sWhere) { @@ -4526,6 +4526,23 @@ objJsonResult.data = null; return objJsonResult; } + } + #endregion + + #region[妯″叿鏀瑰埗鍏ュ簱鍗曠紪杈戞椂鑾峰彇琛ㄥご鏁版嵁] + [Route("Sc_CheckToolsRepairWorkBillList/Sc_MouldRepairInHouseBillListCheckDetai")] + [HttpGet] + public ApiResult<DataSet> Sc_MouldRepairInHouseBillListCheckDetai(string HID) + { + if (string.IsNullOrEmpty(HID)) + return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" }; + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + + var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldProdInHouseBillList where hmainid= " + HID + " ", "h_v_Sc_MouldProdInHouseBillList"); + if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) + return new ApiResult<DataSet> { code = -1, msg = "涓嶅瓨鍦ㄥ崟鍙�" }; + + return new ApiResult<DataSet> { code = 1, msg = "鏌ヨ鎴愬姛", data = dataSet }; } #endregion @@ -4936,7 +4953,7 @@ // HSecUnitID, 杈呭姪璁¢噺鍗曚綅浠g爜 HSecUnitCode, 杈呭姪璁¢噺鍗曚綅 HSecUnitName,鎹㈢畻鐜� HSecUnitRate, // HUnitID, 璁¢噺鍗曚綅浠g爜 HUnitCode, 璁¢噺鍗曚綅 HUnitName, // 璁捐瀵垮懡 HDesignLife, 鍘熷墿浣欏鍛� HLeaveLife, 鏂板墿浣欏鍛� HNewLife,琛ㄤ綋澶囨敞 HRemark - // FROM h_v_Sc_MouldLifeChangeBillList_Edit"), "h_v_Sc_MouldLifeChangeBillList_Edit"); + // FROM h_v_Sc_MouldLifeChangeBillList_Edit"), "h_v_Sc_MouldLifeChangeBillList_Edit"); // objJsonResult.code = "0"; // objJsonResult.count = 1; @@ -4951,7 +4968,7 @@ // HSecUnitID, 杈呭姪璁¢噺鍗曚綅浠g爜 HSecUnitCode, 杈呭姪璁¢噺鍗曚綅 HSecUnitName,鎹㈢畻鐜� HSecUnitRate, // HUnitID, 璁¢噺鍗曚綅浠g爜 HUnitCode, 璁¢噺鍗曚綅 HUnitName, // 璁捐瀵垮懡 HDesignLife, 鍘熷墿浣欏鍛� HLeaveLife, 鏂板墿浣欏鍛� HNewLife,琛ㄤ綋澶囨敞 HRemark - // FROM h_v_Sc_MouldLifeChangeBillList_Edit where 1 = 1 "); + // FROM h_v_Sc_MouldLifeChangeBillList_Edit where 1 = 1 "); // string sql = sql1 + sqlWhere; // ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldLifeChangeBillList_Edit"); -- Gitblit v1.9.1