From 69f3ee1b7f46a7f680002d10e6b39cf8d664a4f4 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期一, 08 七月 2024 09:00:16 +0800 Subject: [PATCH] 1 --- WebAPI/Service/LuBaoSevice.cs | 21 ++++++++++++++++++++- 1 files changed, 20 insertions(+), 1 deletions(-) diff --git a/WebAPI/Service/LuBaoSevice.cs b/WebAPI/Service/LuBaoSevice.cs index b566298..c1d3017 100644 --- a/WebAPI/Service/LuBaoSevice.cs +++ b/WebAPI/Service/LuBaoSevice.cs @@ -326,7 +326,7 @@ public static DataSet GetGy_UserProcessDb(string HID) { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); - var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_UserProcess where HItemID= " + HID + " ", "h_v_Gy_UserProcess"); + var dataSet = oCN.RunProcReturn("select * from h_v_Gy_InspectBasis_Edit where HItemID= " + HID + " ", "h_v_Gy_InspectBasis_Edit"); return dataSet; } @@ -680,6 +680,25 @@ return dataSet; } + /// <summary> + /// 鍚姩妫�鏌ラ」鐩牴鎹甶d鑾峰彇淇℃伅 + /// </summary> + public static ApiResult<DataSet> GetGy_CheckNoteItemDetail(string HID) + { + if (string.IsNullOrEmpty(HID)) + return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" }; + var dataSet = GetGy_CheckNoteItemDb(HID); + 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 }; + } + public static DataSet GetGy_CheckNoteItemDb(string HID) + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_CheckNoteItem where HItemID= " + HID + " ", "h_v_Gy_CheckNoteItem"); + return dataSet; + } + /// <summary> /// 椤圭洰绫诲埆鏍规嵁id鑾峰彇淇℃伅 -- Gitblit v1.9.1