From 617bb206dca60967dfd04e2bdcc2303714f6b665 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 05 三月 2024 09:34:04 +0800
Subject: [PATCH] 收料通知单的 源单类型的下拉框, 改为 根据 Xt_BillSourceSet 表来 动态加载; 注意 源单类型 的名称 根据字段 HSourceBillType varchar(10) 的源单类型编码 到 xt_BillType表 来 获取 源单名称; 并且测试 点击 选 源单,是否会 跳转 至对应的源单列表; 注意 始终以 单据类型编码为准, 单据类型名称 每个客户都有可能会修改; 程序里 以 编码为判断依据

---
 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