From 6ced0cff2123105422ec0d66d6e5f3c5b7dba8e0 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期三, 01 九月 2021 15:23:42 +0800 Subject: [PATCH] 不良原因修改页面完善以及列表完善 --- WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user | 146 ++++++++++++++++++++++++------------------------ WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs | 6 +- WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs | 1 WebAPI/WebAPI.csproj.user | 2 WebAPI/Controllers/WebAPIController.cs | 24 ++++---- 5 files changed, 89 insertions(+), 90 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs index c8fe01b..650b243 100644 --- a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs @@ -31,12 +31,12 @@ { if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList " + sWhere, "h_v_IF_BadReasonList"); + ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList " + sWhere+ " order by HItemID desc", "h_v_IF_BadReasonList"); } else { - string sql1 = "select * from h_v_IF_BadReasonList where 1 = 1 "; - string sql = sql1 + sWhere; + string sql1 = "select * from h_v_IF_BadReasonList where 1 = 1"; + string sql = sql1 + sWhere+ " order by HItemID desc"; ds = oCN.RunProcReturn(sql, "h_v_IF_BadReasonList"); } if (ds == null || ds.Tables[0].Rows.Count == 0) diff --git a/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs b/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs index 9434b26..dedfd6e 100644 --- a/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs +++ b/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs @@ -491,7 +491,6 @@ { try { - ds = Sc_MouldRepairCheckBillList_s(sWhere); objJsonResult.code = "1"; objJsonResult.count = 1; diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 73bf700..b6c0485 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -1237,22 +1237,22 @@ objJsonResult.data = null; return objJsonResult; ; } - var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); - if (HStopflag) - { - oCN.RollBack();//鍥炴粴浜嬪姟 - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鏁版嵁宸插垹闄ゆ棤娉曞啀娆″垹闄わ紒"; - objJsonResult.data = null; - return objJsonResult; - } + //var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); + //if (HStopflag) + //{ + // oCN.RollBack();//鍥炴粴浜嬪姟 + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "鏁版嵁宸插垹闄ゆ棤娉曞啀娆″垹闄わ紒"; + // objJsonResult.data = null; + // return objJsonResult; + //} - oCN.RunProc("update Gy_BadReason set HStopflag=1 where HItemID=" + HItemID); + oCN.RunProc("delete Gy_BadReason where HItemID=" + HItemID); oCN.Commit();//鎻愪氦浜嬪姟 objJsonResult.code = "0"; objJsonResult.count = 1; - objJsonResult.Message = "* 鏁版嵁鍒犻櫎鎴愬姛锛�"; + objJsonResult.Message = "鏁版嵁鍒犻櫎鎴愬姛锛�"; objJsonResult.data = null; return objJsonResult; ; diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user index 5643afb..b729f90 100644 --- a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user +++ b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user @@ -9,7 +9,7 @@ </PropertyGroup> <ItemGroup> <File Include="apiapp.json"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="bin/Antlr3.Runtime.dll"> <publishTime>02/22/2013 08:43:40</publishTime> @@ -18,31 +18,31 @@ <publishTime>02/22/2013 08:43:40</publishTime> </File> <File Include="bin/BLL.dll"> - <publishTime>08/31/2021 16:28:48</publishTime> + <publishTime>09/01/2021 14:30:57</publishTime> </File> <File Include="bin/BLL.pdb"> - <publishTime>08/31/2021 16:28:48</publishTime> + <publishTime>09/01/2021 14:30:57</publishTime> </File> <File Include="bin/DAL.dll"> - <publishTime>08/31/2021 16:28:46</publishTime> + <publishTime>09/01/2021 14:30:55</publishTime> </File> <File Include="bin/DAL.pdb"> - <publishTime>08/31/2021 16:28:46</publishTime> + <publishTime>09/01/2021 14:30:55</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 14:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> - <publishTime>08/31/2021 16:28:44</publishTime> + <publishTime>09/01/2021 14:30:52</publishTime> </File> <File Include="bin/DBUtility.pdb"> - <publishTime>08/31/2021 16:28:44</publishTime> + <publishTime>09/01/2021 14:30:52</publishTime> </File> <File Include="bin/Interop.gregn6Lib.dll"> <publishTime>08/25/2021 10:28:25</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> - <publishTime>08/09/2021 09:06:25</publishTime> + <publishTime>08/16/2021 17:23:13</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.FormService.dll"> <publishTime>09/20/2018 19:23:20</publishTime> @@ -60,34 +60,34 @@ <publishTime>07/25/2012 11:48:56</publishTime> </File> <File Include="bin/Model.dll"> - <publishTime>08/31/2021 16:28:45</publishTime> + <publishTime>09/01/2021 14:30:52</publishTime> </File> <File Include="bin/Model.pdb"> - <publishTime>08/31/2021 16:28:45</publishTime> + <publishTime>09/01/2021 14:30:52</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="bin/Newtonsoft.Json.dll"> <publishTime>08/03/2014 20:33:56</publishTime> </File> <File Include="bin/Pub_Class.dll"> - <publishTime>08/31/2021 16:28:42</publishTime> + <publishTime>09/01/2021 14:30:50</publishTime> </File> <File Include="bin/Pub_Class.pdb"> - <publishTime>08/31/2021 16:28:42</publishTime> + <publishTime>09/01/2021 14:30:50</publishTime> </File> <File Include="bin/Pub_Control.dll"> - <publishTime>08/31/2021 16:28:43</publishTime> + <publishTime>09/01/2021 14:30:51</publishTime> </File> <File Include="bin/Pub_Control.pdb"> - <publishTime>08/31/2021 16:28:43</publishTime> + <publishTime>09/01/2021 14:30:51</publishTime> </File> <File Include="bin/SQLHelper.dll"> - <publishTime>08/31/2021 16:28:43</publishTime> + <publishTime>09/01/2021 14:30:51</publishTime> </File> <File Include="bin/SQLHelper.pdb"> - <publishTime>08/31/2021 16:28:43</publishTime> + <publishTime>09/01/2021 14:30:51</publishTime> </File> <File Include="bin/stdole.dll"> <publishTime>05/09/2021 13:35:37</publishTime> @@ -156,7 +156,7 @@ <publishTime>11/28/2018 13:01:00</publishTime> </File> <File Include="bin/System.Web.Http.WebHost.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="bin/System.Web.Mvc.dll"> <publishTime>01/28/2015 04:02:18</publishTime> @@ -189,10 +189,10 @@ <publishTime>11/24/2014 11:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> - <publishTime>08/31/2021 16:28:49</publishTime> + <publishTime>09/01/2021 14:31:00</publishTime> </File> <File Include="bin/WebAPI.pdb"> - <publishTime>08/31/2021 16:28:49</publishTime> + <publishTime>09/01/2021 14:31:00</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/17/2013 17:03:52</publishTime> @@ -204,166 +204,166 @@ <publishTime>11/29/2018 13:26:30</publishTime> </File> <File Include="Content/bootstrap.css"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Content/bootstrap.min.css"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Content/Site.css"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/BLL.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/DAL.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/DBUtility.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Model.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Newtonsoft.Json.Net35.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Pub_Class.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Pub_Control.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/SQLHelper.dll"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.eot"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.svg"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.ttf"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.woff"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="Global.asax"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Index.html"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="packages.config"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="Views/Scripts/bootstrap.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/bootstrap.min.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.map"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery.validate.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery.validate.min.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/modernizr-2.6.2.js"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Shared/Error.cshtml"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Shared/_Layout.cshtml"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/web.config"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/_ViewStart.cshtml"> - <publishTime>08/09/2021 09:06:27</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> - <publishTime>08/10/2021 08:30:51</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> - <publishTime>08/10/2021 08:30:52</publishTime> + <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/Reference.map"> <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web.config"> - <publishTime>08/31/2021 16:28:55</publishTime> + <publishTime>09/01/2021 14:31:07</publishTime> </File> </ItemGroup> </Project> \ No newline at end of file diff --git a/WebAPI/WebAPI.csproj.user b/WebAPI/WebAPI.csproj.user index 8d7bb3f..c934955 100644 --- a/WebAPI/WebAPI.csproj.user +++ b/WebAPI/WebAPI.csproj.user @@ -7,7 +7,7 @@ <WebStackScaffolding_IsReferencingScriptLibrariesSelected>True</WebStackScaffolding_IsReferencingScriptLibrariesSelected> <WebStackScaffolding_LayoutPageFile /> <WebStackScaffolding_IsAsyncSelected>False</WebStackScaffolding_IsAsyncSelected> - <NameOfLastUsedPublishProfile>D:\Git浠撳簱\MESWMS\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> + <NameOfLastUsedPublishProfile>FolderProfile</NameOfLastUsedPublishProfile> <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> <UseIISExpress>false</UseIISExpress> <Use64BitIISExpress /> -- Gitblit v1.9.1