From b5f6b1d17bb14233e5f629ed0ef7376bf767d971 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期五, 10 一月 2025 16:20:43 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs | 49 ++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 48 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs b/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs index 4af70c3..395d944 100644 --- a/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs +++ b/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs @@ -33,7 +33,7 @@ { try { - if (!DBUtility.ClsPub.Security_Log("Gy_EquipFileList", 1, false, user)) + if (!DBUtility.ClsPub.Security_Log("Gy_EquipFileBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -71,6 +71,53 @@ #endregion + #region 涓嬫帹鏍规嵁璁惧id鏌ヨ鍥炴樉 + [Route("Gy_EquipFileMain/get锘縎b_EquipList")] + [HttpGet] + public object getSb_EquipBeginBillList(int HInterID, string user) + { + try + { + List<object> columnNameList = new List<object>(); + + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_EquipFileBill_Query", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏌ヨ澶辫触锛佹棤鏉冮檺锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + ds = oCN.RunProcReturn("select * from h_v_Gy_EquipFileMainList where hmainid=" + HInterID, " h_v_Gy_EquipFileMainList"); + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + #region [璁惧妗f鍒犻櫎鍔熻兘] [Route("Gy_EquipFileMain/Delete_EquipFile")] [HttpGet] -- Gitblit v1.9.1