From 9a75f7db9431032c0f1ecc64be4966a25c74bafa Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期二, 05 十一月 2024 16:48:12 +0800 Subject: [PATCH] 1 --- WebAPI/Service/LuBaoSevice.cs | 25 +++++++++++++++++++++++++ 1 files changed, 25 insertions(+), 0 deletions(-) diff --git a/WebAPI/Service/LuBaoSevice.cs b/WebAPI/Service/LuBaoSevice.cs index 7305810..5960303 100644 --- a/WebAPI/Service/LuBaoSevice.cs +++ b/WebAPI/Service/LuBaoSevice.cs @@ -807,6 +807,31 @@ return new ApiResult<DataSet> { code = -1, msg = "涓嶅瓨鍦ㄥ鎴峰垎绫绘暟鎹�" }; return new ApiResult<DataSet> { code = 1, msg = "鏌ヨ鎴愬姛", data = dataSet }; } + + /// <summary> + ///宸ヨ壓鍝佸弬鏁板垎绫绘牴鎹甶d鑾峰彇淇℃伅 + /// </summary> + public static ApiResult<DataSet> GetGy_TechnologyType(string HID) + { + if (string.IsNullOrEmpty(HID)) + return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" }; + var dataSet = GetGy_TechnologyTypeDb(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 }; + } + + /// <summary> + ///宸ヨ壓鍝佸弬鏁板垎绫绘牴鎹甶d鑾峰彇淇℃伅璋冪敤鎸佷箙灞� + /// </summary> + public static DataSet GetGy_TechnologyTypeDb(string HID) + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_Technology where HItemID= " + HID + " ", "h_v_Gy_Technology"); + return dataSet; + } + + public static DataSet GetGy_CusTypeDb(string HID) { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); -- Gitblit v1.9.1