From 2925dd8e5456fab545751ff6941a15de66b2ba42 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期二, 08 四月 2025 13:09:36 +0800 Subject: [PATCH] 销售订单:编辑页面 增加 产品类型 字段 --- WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs | 41 ++++++++++++++++++++++++++++++++++++++++- 1 files changed, 40 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs b/WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs index 4e44a8d..099c900 100644 --- a/WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs +++ b/WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs @@ -37,7 +37,7 @@ try { - ds = oCN.RunProcReturn("select * from h_v_IF_SeOutStockBillList where hmainid=" + HInterID, "h_v_IF_SeOutStockBillList"); + ds = oCN.RunProcReturn("select * from h_v_IF_SeOutStockBillEdit where hmainid=" + HInterID, "h_v_IF_SeOutStockBillList"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; @@ -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