From be8cd03bf8df8e63f92ab035fc527aab15226d52 Mon Sep 17 00:00:00 2001 From: zgq <519541279@qq.com> Date: 星期一, 05 七月 2021 14:04:41 +0800 Subject: [PATCH] 增加扫码记录删除缓存功能-调拨单 --- WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user | 6 +- WebAPI/Controllers/MoveStockBillController.cs | 8 ---- WebAPI/Controllers/WebAPIController.cs | 70 +++++++++++++++++++++++++++++++++++ WebAPI/Controllers/Sc_MouldOtherInBillController.cs | 2 4 files changed, 74 insertions(+), 12 deletions(-) diff --git a/WebAPI/Controllers/MoveStockBillController.cs b/WebAPI/Controllers/MoveStockBillController.cs index eea5b23..4e1c452 100644 --- a/WebAPI/Controllers/MoveStockBillController.cs +++ b/WebAPI/Controllers/MoveStockBillController.cs @@ -364,14 +364,6 @@ objJsonResult.data = null; return objJsonResult; } - //else - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "2-搴撳瓨涓嶈冻锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} if (oWebs.set_SavePonderationBillMain_Temp_Qty(model, sQty, ref DBUtility.ClsPub.sErrInfo)) { diff --git a/WebAPI/Controllers/Sc_MouldOtherInBillController.cs b/WebAPI/Controllers/Sc_MouldOtherInBillController.cs index a862f37..94e4da7 100644 --- a/WebAPI/Controllers/Sc_MouldOtherInBillController.cs +++ b/WebAPI/Controllers/Sc_MouldOtherInBillController.cs @@ -182,7 +182,7 @@ if (oMould.DeleteBill(HItemID, ref DBUtility.ClsPub.sExeReturnInfo)) { //鍐欏叆鏃ュ織 - ClsPub.Add_Log("", "鍒犻櫎椤圭洰锛屼唬鐮侊細" + oMould.omodel.HNumber + ",鍚嶇О锛�" + oMould.omodel.HName, ClsPub.CurUserName); + //ClsPub.Add_Log("", "鍒犻櫎椤圭洰锛屼唬鐮侊細" + oMould.omodel.HNumber + ",鍚嶇О锛�" + oMould.omodel.HName, ClsPub.CurUserName); //鏇存柊涓婄骇涓� 鏈骇 objJsonResult.code = "1"; objJsonResult.count = 1; diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index c1d9ee8..10e9ecf 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -1884,6 +1884,76 @@ } } + /// <summary> + /// 鑾峰彇鎵爜璇︽儏鍒楄〃 + /// </summary> + /// <returns></returns> + [Route("Web/GetWMSBarCodeDetailsList")] + [HttpGet] + public object GetWMSBarCodeDetailsList(int HInterID,string HBillType) + { + try + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + + ds = oCN.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Temp_Sum where HInterID=" + HInterID + " and HBillType='" + HBillType + "' Order by HItemID ", "h_v_KF_PonderationBillMain_Temp_Sum"); + //ds = oCN.RunProcReturn("Select top 10 * from h_v_KF_PonderationBillMain_Temp_Sum Order by HInterID ", "h_v_KF_PonderationBillMain_Temp_Sum"); + if (ds == null || ds.Tables[0].Rows.Count <= 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + DBUtility.ClsPub.sErrInfo; + objjson.data = null; + return objjson; + } + else + { + objjson.code = "0"; + objjson.count = 1; + objjson.Message = "鑾峰彇鎴愬姛!"; + objjson.data = ds.Tables[0]; + return objjson; + } + } + catch (Exception ex) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + ex.ToString(); + objjson.data = null; + return objjson; + } + } + + + /// <summary> + /// 鏍规嵁ID鍒犻櫎缂撳瓨琛ㄤ腑鎵爜璁板綍 + /// </summary> + /// <param name="sHitemID">缂撳瓨琛↖D</param> + /// <returns>object</returns> + [Route("Web/DelCacheList")] + [HttpGet] + public object DelCacheList(long sHitemID) + { + try + { + SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); + oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HitemID = " + sHitemID); + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍒犻櫎鎴愬姛锛�"; + objJsonResult.data = null; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍒犻櫎澶辫触锛�"; + objJsonResult.data = e.ToString(); + return objJsonResult; + } + } } diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user index 9151e30..69fdffb 100644 --- a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user +++ b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user @@ -153,10 +153,10 @@ <publishTime>11/24/2014 11:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> - <publishTime>06/30/2021 16:44:16</publishTime> + <publishTime>07/05/2021 13:46:25</publishTime> </File> <File Include="bin/WebAPI.pdb"> - <publishTime>06/30/2021 16:44:16</publishTime> + <publishTime>07/05/2021 13:46:25</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/17/2013 17:03:52</publishTime> @@ -324,7 +324,7 @@ <publishTime>02/22/2021 09:25:20</publishTime> </File> <File Include="Web.config"> - <publishTime>06/30/2021 16:44:26</publishTime> + <publishTime>07/05/2021 13:46:40</publishTime> </File> </ItemGroup> </Project> \ No newline at end of file -- Gitblit v1.9.1