其它收款单：子表选择基础资料，在文本框输入值，可以查询数据，并通过按键或鼠标选择获取数据

duhe

2024-09-11 a01d10d7daee1a6253b042323748979ad45225d5

其它收款单：子表选择基础资料，在文本框输入值，可以查询数据，并通过按键或鼠标选择获取数据

 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));//获取到DataColumn列对象的列名
                }

                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
    }
}

 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>

 sdk_dingding/TopSdk/bin/Debug/TopSdk.dll

Binary files differ

 sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb

Binary files differ

 sdk_dingding/TopSdk/obj/Debug/TopSdk.dll

Binary files differ

 sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb

Binary files differ