From f3406b5d603b0b8ac026cda734739262207d6065 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期二, 20 十二月 2022 16:27:11 +0800 Subject: [PATCH] 器具维修记录单 源单类型 (手工录入 维修派工单 故障登记单 ) 根据类型去选择相对应的单据 带出数据 器具维修记录单 子表两个 页签 (维修信息 配件信息)--参考设备维修记录单 --- WebAPI/Controllers/BaseSet/Gy_PackTypeController.cs | 12 +++++++++++- 1 files changed, 11 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_PackTypeController.cs b/WebAPI/Controllers/BaseSet/Gy_PackTypeController.cs index a82d52b..6f03971 100644 --- a/WebAPI/Controllers/BaseSet/Gy_PackTypeController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_PackTypeController.cs @@ -1,4 +1,5 @@ -锘縰sing Newtonsoft.Json.Linq; +锘縰sing Newtonsoft.Json; +using Newtonsoft.Json.Linq; using Pub_Class; using System; using System.Collections; @@ -30,6 +31,7 @@ { try { + List<object> columnNameList = new List<object>(); //缂栬緫鏉冮檺 //if (!DBUtility.ClsPub.Security_Log_second("Gy_PackType", 1, false, user)) //{ @@ -50,11 +52,19 @@ ds = oCN.RunProcReturn(sql, "h_v_Gy_PackTypeList"); } + //娣诲姞鍒楀悕 + 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) -- Gitblit v1.9.1