From a01d10d7daee1a6253b042323748979ad45225d5 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期三, 11 九月 2024 10:30:40 +0800
Subject: [PATCH] 其它收款单：子表选择基础资料，在文本框输入值，可以查询数据，并通过按键或鼠标选择获取数据
---
sdk_dingding/TopSdk/bin/Debug/TopSdk.dll | 0
WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs | 40 ++++++++++++++++++++++++++++++++++++++++
sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb | 0
sdk_dingding/TopSdk/obj/Debug/TopSdk.dll | 0
WebAPI/Properties/PublishProfiles/FolderProfile10.pubxml.user | 10 +++++-----
sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb | 0
6 files changed, 45 insertions(+), 5 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs b/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs
index 628d7d6..46227c1 100644
--- a/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs
+++ b/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs
@@ -691,5 +691,45 @@
}
}
#endregion
+
+
+
+ #region 鍩虹璧勬枡 鑾峰彇鏁版嵁
+ [Route("Gy_GetBaseData/Gy_GetBaseData")]
+ [HttpGet]
+ public object Gy_GetBaseData(string sql,string tableView, string user)
+ {
+ try
+ {
+ List<object> columnNameList = new List<object>();
+
+
+ ds = oCN.RunProcReturn(sql, tableView);
+
+ //娣诲姞鍒楀悕
+ 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
}
}
\ No newline at end of file
diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile10.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfile10.pubxml.user
index 604cf5e..45f4b91 100644
--- a/WebAPI/Properties/PublishProfiles/FolderProfile10.pubxml.user
+++ b/WebAPI/Properties/PublishProfiles/FolderProfile10.pubxml.user
@@ -4,7 +4,7 @@
-->
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<PropertyGroup>
- <History>True|2024-09-09T06:32:59.6183288Z;True|2024-09-09T14:08:01.6074290+08:00;True|2024-09-09T13:54:27.4220669+08:00;True|2024-09-09T13:45:55.2546949+08:00;True|2024-09-09T13:37:40.5854460+08:00;False|2024-09-09T13:37:17.6050041+08:00;True|2024-09-09T11:25:16.9437875+08:00;True|2024-09-09T11:00:21.4309667+08:00;False|2024-09-09T11:00:03.7538487+08:00;True|2024-09-06T16:03:20.5336832+08:00;True|2024-09-06T15:56:58.0813460+08:00;True|2024-09-06T15:51:03.8776434+08:00;True|2024-09-06T15:48:03.3439216+08:00;True|2024-09-06T15:42:33.9935396+08:00;True|2024-09-06T15:39:30.6273014+08:00;True|2024-09-06T13:09:39.8344141+08:00;False|2024-09-06T13:09:21.9582097+08:00;True|2024-09-06T11:29:27.1262524+08:00;False|2024-09-06T11:28:55.9593146+08:00;True|2024-09-05T11:19:46.2265051+08:00;True|2024-09-05T10:18:44.1188785+08:00;True|2024-09-05T10:14:40.0505783+08:00;False|2024-09-05T10:14:13.7760616+08:00;True|2024-09-04T14:57:38.8862572+08:00;True|2024-09-04T14:36:47.2514960+08:00;True|2024-09-04T14:36:13.9753492+08:00;True|2024-09-04T13:35:39.0678735+08:00;True|2024-09-04T13:18:03.5880629+08:00;True|2024-09-04T10:22:05.9546376+08:00;False|2024-09-04T10:21:36.0127685+08:00;True|2024-09-04T10:08:32.0259963+08:00;False|2024-09-04T10:08:09.9323713+08:00;True|2024-08-29T16:18:43.7085548+08:00;True|2024-08-29T14:43:01.6752088+08:00;False|2024-08-29T14:42:40.1350706+08:00;True|2024-08-28T21:59:53.4221652+08:00;True|2024-08-28T21:22:29.9693901+08:00;True|2024-08-28T20:03:40.6232218+08:00;False|2024-08-28T20:03:22.6322413+08:00;True|2024-08-28T13:06:07.4432568+08:00;False|2024-08-28T13:04:04.1198464+08:00;True|2024-08-21T16:09:41.0487181+08:00;True|2024-08-21T15:42:13.7474317+08:00;True|2024-08-21T15:10:24.6912112+08:00;True|2024-08-21T14:56:51.3255866+08:00;True|2024-08-21T14:50:12.3359730+08:00;True|2024-08-19T15:43:16.1549663+08:00;True|2024-08-19T15:27:26.4219971+08:00;True|2024-08-19T09:41:45.7449029+08:00;True|2024-06-08T12:38:30.4153773+08:00;True|2024-06-07T21:22:19.4545597+08:00;True|2024-06-07T21:05:53.1963741+08:00;True|2024-06-07T21:00:57.2568708+08:00;True|2024-06-07T14:39:19.6618679+08:00;True|2024-06-07T14:21:51.5169962+08:00;True|2024-06-07T11:29:08.0690999+08:00;True|2024-06-07T11:26:29.1494329+08:00;True|2024-06-07T11:20:41.2024309+08:00;True|2024-06-07T10:12:26.5905597+08:00;False|2024-06-07T10:11:35.3679434+08:00;</History>
+ <History>True|2024-09-10T06:57:00.4557261Z;True|2024-09-10T10:30:28.1344265+08:00;False|2024-09-10T10:29:59.2239150+08:00;True|2024-09-09T14:32:59.6183288+08:00;True|2024-09-09T14:08:01.6074290+08:00;True|2024-09-09T13:54:27.4220669+08:00;True|2024-09-09T13:45:55.2546949+08:00;True|2024-09-09T13:37:40.5854460+08:00;False|2024-09-09T13:37:17.6050041+08:00;True|2024-09-09T11:25:16.9437875+08:00;True|2024-09-09T11:00:21.4309667+08:00;False|2024-09-09T11:00:03.7538487+08:00;True|2024-09-06T16:03:20.5336832+08:00;True|2024-09-06T15:56:58.0813460+08:00;True|2024-09-06T15:51:03.8776434+08:00;True|2024-09-06T15:48:03.3439216+08:00;True|2024-09-06T15:42:33.9935396+08:00;True|2024-09-06T15:39:30.6273014+08:00;True|2024-09-06T13:09:39.8344141+08:00;False|2024-09-06T13:09:21.9582097+08:00;True|2024-09-06T11:29:27.1262524+08:00;False|2024-09-06T11:28:55.9593146+08:00;True|2024-09-05T11:19:46.2265051+08:00;True|2024-09-05T10:18:44.1188785+08:00;True|2024-09-05T10:14:40.0505783+08:00;False|2024-09-05T10:14:13.7760616+08:00;True|2024-09-04T14:57:38.8862572+08:00;True|2024-09-04T14:36:47.2514960+08:00;True|2024-09-04T14:36:13.9753492+08:00;True|2024-09-04T13:35:39.0678735+08:00;True|2024-09-04T13:18:03.5880629+08:00;True|2024-09-04T10:22:05.9546376+08:00;False|2024-09-04T10:21:36.0127685+08:00;True|2024-09-04T10:08:32.0259963+08:00;False|2024-09-04T10:08:09.9323713+08:00;True|2024-08-29T16:18:43.7085548+08:00;True|2024-08-29T14:43:01.6752088+08:00;False|2024-08-29T14:42:40.1350706+08:00;True|2024-08-28T21:59:53.4221652+08:00;True|2024-08-28T21:22:29.9693901+08:00;True|2024-08-28T20:03:40.6232218+08:00;False|2024-08-28T20:03:22.6322413+08:00;True|2024-08-28T13:06:07.4432568+08:00;False|2024-08-28T13:04:04.1198464+08:00;True|2024-08-21T16:09:41.0487181+08:00;True|2024-08-21T15:42:13.7474317+08:00;True|2024-08-21T15:10:24.6912112+08:00;True|2024-08-21T14:56:51.3255866+08:00;True|2024-08-21T14:50:12.3359730+08:00;True|2024-08-19T15:43:16.1549663+08:00;True|2024-08-19T15:27:26.4219971+08:00;True|2024-08-19T09:41:45.7449029+08:00;True|2024-06-08T12:38:30.4153773+08:00;True|2024-06-07T21:22:19.4545597+08:00;True|2024-06-07T21:05:53.1963741+08:00;True|2024-06-07T21:00:57.2568708+08:00;True|2024-06-07T14:39:19.6618679+08:00;True|2024-06-07T14:21:51.5169962+08:00;True|2024-06-07T11:29:08.0690999+08:00;True|2024-06-07T11:26:29.1494329+08:00;True|2024-06-07T11:20:41.2024309+08:00;True|2024-06-07T10:12:26.5905597+08:00;False|2024-06-07T10:11:35.3679434+08:00;</History>
<_PublishTargetUrl>D:\缃戠珯鍙戝竷\鏅轰簯MESWMS\API</_PublishTargetUrl>
</PropertyGroup>
<ItemGroup>
@@ -279,19 +279,19 @@
<publishTime>05/09/2023 10:43:40</publishTime>
</File>
<File Include="bin/TopSdk.dll">
- <publishTime>09/09/2024 14:31:16</publishTime>
+ <publishTime>09/10/2024 14:53:09</publishTime>
</File>
<File Include="bin/TopSdk.pdb">
- <publishTime>09/09/2024 14:31:16</publishTime>
+ <publishTime>09/10/2024 14:53:09</publishTime>
</File>
<File Include="bin/WebActivatorEx.dll">
<publishTime>11/24/2014 19:18:48</publishTime>
</File>
<File Include="bin/WebAPI.dll">
- <publishTime>09/09/2024 14:32:56</publishTime>
+ <publishTime>09/10/2024 14:56:55</publishTime>
</File>
<File Include="bin/WebAPI.pdb">
- <publishTime>09/09/2024 14:32:56</publishTime>
+ <publishTime>09/10/2024 14:56:55</publishTime>
</File>
<File Include="bin/WebGrease.dll">
<publishTime>07/18/2013 01:03:52</publishTime>
diff --git a/sdk_dingding/TopSdk/bin/Debug/TopSdk.dll b/sdk_dingding/TopSdk/bin/Debug/TopSdk.dll
index 4c46d5a..e4f43db 100644
--- a/sdk_dingding/TopSdk/bin/Debug/TopSdk.dll
+++ b/sdk_dingding/TopSdk/bin/Debug/TopSdk.dll
Binary files differ
diff --git a/sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb b/sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb
index f660f22..7f775cb 100644
--- a/sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb
+++ b/sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb
Binary files differ
diff --git a/sdk_dingding/TopSdk/obj/Debug/TopSdk.dll b/sdk_dingding/TopSdk/obj/Debug/TopSdk.dll
index 4c46d5a..e4f43db 100644
--- a/sdk_dingding/TopSdk/obj/Debug/TopSdk.dll
+++ b/sdk_dingding/TopSdk/obj/Debug/TopSdk.dll
Binary files differ
diff --git a/sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb b/sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb
index f660f22..7f775cb 100644
--- a/sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb
+++ b/sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb
Binary files differ
--
Gitblit v1.9.1