From f6ac9b9bc3c3feea605202923f7f0a49f284f21a Mon Sep 17 00:00:00 2001 From: zgq <519541279@qq.com> Date: 星期四, 21 一月 2021 16:39:19 +0800 Subject: [PATCH] 增加工艺路线列表和生产任务单列表 --- WebAPI/Properties/PublishProfiles/PDAWeb.pubxml.user | 13 ++++++++----- WebAPI/WebAPI.csproj.user | 2 +- WebAPI/Controllers/LMESController.cs | 9 ++++++--- 3 files changed, 15 insertions(+), 9 deletions(-) diff --git a/WebAPI/Controllers/LMESController.cs b/WebAPI/Controllers/LMESController.cs index 55f51ae..698ffe6 100644 --- a/WebAPI/Controllers/LMESController.cs +++ b/WebAPI/Controllers/LMESController.cs @@ -216,7 +216,7 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList ", "h_v_IF_ICMOBillList"); + ds = oCN.RunProcReturn("select top 500 * from h_v_IF_ICMOBillList ", "h_v_IF_ICMOBillList"); } else { @@ -224,11 +224,14 @@ string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillList"); } - } catch (Exception e) { - ds = null; + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; } return GetObjectJson(ds); } diff --git a/WebAPI/Properties/PublishProfiles/PDAWeb.pubxml.user b/WebAPI/Properties/PublishProfiles/PDAWeb.pubxml.user index 3846eae..d7ef21e 100644 --- a/WebAPI/Properties/PublishProfiles/PDAWeb.pubxml.user +++ b/WebAPI/Properties/PublishProfiles/PDAWeb.pubxml.user @@ -27,6 +27,9 @@ <File Include="bin/DAL.dll"> <publishTime>01/13/2021 21:47:30</publishTime> </File> + <File Include="bin/Dapper.dll"> + <publishTime>07/22/2016 14:52:40</publishTime> + </File> <File Include="bin/DBUtility.dll"> <publishTime>01/13/2021 21:47:30</publishTime> </File> @@ -172,13 +175,13 @@ <publishTime>11/24/2014 11:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> - <publishTime>01/21/2021 11:31:26</publishTime> + <publishTime>01/21/2021 15:10:47</publishTime> </File> <File Include="bin/WebAPI.pdb"> - <publishTime>01/21/2021 11:31:26</publishTime> + <publishTime>01/21/2021 15:10:47</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> - <publishTime>01/21/2021 11:31:29</publishTime> + <publishTime>01/21/2021 15:10:51</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/17/2013 17:03:52</publishTime> @@ -250,7 +253,7 @@ <publishTime>01/13/2021 21:47:30</publishTime> </File> <File Include="packages.config"> - <publishTime>01/19/2021 15:58:45</publishTime> + <publishTime>01/21/2021 13:19:40</publishTime> </File> <File Include="Scripts/bootstrap.js"> <publishTime>03/16/2020 13:09:50</publishTime> @@ -382,7 +385,7 @@ <publishTime>11/16/2020 15:22:37</publishTime> </File> <File Include="Web.config"> - <publishTime>01/19/2021 16:03:42</publishTime> + <publishTime>01/21/2021 13:33:19</publishTime> </File> </ItemGroup> </Project> \ No newline at end of file diff --git a/WebAPI/WebAPI.csproj.user b/WebAPI/WebAPI.csproj.user index 795b1e4..27721ad 100644 --- a/WebAPI/WebAPI.csproj.user +++ b/WebAPI/WebAPI.csproj.user @@ -8,7 +8,7 @@ <WebStackScaffolding_LayoutPageFile /> <WebStackScaffolding_IsAsyncSelected>False</WebStackScaffolding_IsAsyncSelected> <NameOfLastUsedPublishProfile>PDAWeb</NameOfLastUsedPublishProfile> - <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> + <LastActiveSolutionConfig>Release|Any CPU</LastActiveSolutionConfig> <UseIISExpress>false</UseIISExpress> <Use64BitIISExpress /> <IISExpressSSLPort /> -- Gitblit v1.9.1