From 6b4e4aef421cc4fc69d3f021694782f937074cb1 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期三, 11 十二月 2024 09:47:22 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs | 39 +++++++++++++++++++++++++++++++++++++++ 1 files changed, 39 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs b/WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs index 53b6023..099c900 100644 --- a/WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs +++ b/WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs @@ -2259,5 +2259,44 @@ } } #endregion + + + #region 鍙戣揣閫氱煡鍗曟煡璇㈠嵆鏃跺簱瀛� + [Route("Xs_SeOutStockBill/GetICInventory")] + [HttpGet] + public object GetICInventory(int HMaterID, int HWHID, int HORGID) + { + try + { + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + + //if (!DBUtility.ClsPub.Security_Log("Xs_SeOutStockBillQuery", 1, false, user)) + //{ + // objJsonResult.code = CodeConstant.FAIL; + // objJsonResult.count = CountConstant.FAIL; + // objJsonResult.Message = "鏃犳潈闄愭煡鐪�!"; + // objJsonResult.data = null; + // return objJsonResult; + //} + string sql = "exec h_p_Xs_SeOutStockBillGetICInventory " + HMaterID + "," + HWHID + "," + HORGID; + + ds = oCN.RunProcReturn(sql, "h_p_Xs_SeOutStockBillGetICInventory"); + + objJsonResult.code = CodeConstant.SUCCEED; + objJsonResult.count = CountConstant.SUCCEED; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0].Rows[0]["HBack"]; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = CodeConstant.FAIL; + objJsonResult.count = CountConstant.FAIL; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } \ No newline at end of file -- Gitblit v1.9.1