From 5049d1b4b5d74092f69aa3b3e4aa2fcfa8de808b Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期二, 16 四月 2024 17:17:05 +0800 Subject: [PATCH] 1.组织架构模块,增加 用户编码 字段; (非必录) 2.网页版:供应商 增加 字段 材料类别 下拉框(主材,辅材) HMaterClass varchar(20) 网页版: 付款单 表头 增加 字段 发票编号 ,大写金额 (大写金额 在输入 金额后 自动 带出,可以网上找下 小写金额 转 大写 的 代码 ),付款事由; 网页版: 直接调拨单 增加 字段 项目编号 HProjectID (界面显示 项目编码,项目名称), 以及 可选择 工程项目 为 基础资料,表头 增加 字段 发票编号; 选择 表头 调入 调出 仓库后, 表体调入 调出 仓库为空的 也自动填充。 --- WebAPI/Controllers/LookingForBillController.cs | 46 ++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 46 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/LookingForBillController.cs b/WebAPI/Controllers/LookingForBillController.cs index 119212f..1118a59 100644 --- a/WebAPI/Controllers/LookingForBillController.cs +++ b/WebAPI/Controllers/LookingForBillController.cs @@ -339,6 +339,46 @@ } /// <summary> + /// 鏍规嵁浠撳簱浜岀淮鐮佷粨搴撶浉鍏充俊鎭� + /// </summary> + /// <returns></returns> + [Route("LookingFor/getWHName_Json")] + [HttpGet] + public object getWHName_Json(string HBarCode) + { + try + { + long HWHID = int.Parse(HBarCode.Remove(0, 3)); + string sWhere = " Where HItemID = " + HWHID + ""; + ds = getWhName_Json_s(sWhere); + if (ds == null || ds.Tables[0].Rows.Count <= 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "杩斿洖璁板綍鎴愬姛锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + } + catch (Exception ex) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + + /// <summary> /// 鍚敤mes浠撲綅锛屾牴鎹�佷粨搴撹浆鎹㈡垚鏂颁粨搴� /// </summary> /// <returns></returns> @@ -530,6 +570,12 @@ return new SQLHelper.ClsCN().RunProcReturn("select HWHID,* from h_v_IF_StockPlace " + sWhere, "h_v_IF_StockPlace"); } + //鏍规嵁浠撳簱浜岀淮鐮佸甫鍑轰粨搴撶浉鍏充俊鎭� + public static DataSet getWhName_Json_s(string sWhere) + { + return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_Warehouse " + sWhere, "h_v_IF_Warehouse"); + } + //鍚敤mes浠撲綅锛屾牴鎹�佷粨搴撹浆鎹㈡垚鏂颁粨搴� public static DataSet GetSpNameMES_Json_s(string HERPWHID) { -- Gitblit v1.9.1