From 5135080c72fb70c98af17d5e27dcf6e9bbfe54e2 Mon Sep 17 00:00:00 2001
From: zgq <519541279@qq.com>
Date: 星期二, 23 二月 2021 21:17:53 +0800
Subject: [PATCH] 新增找货单列表查询功能

---
 WebAPI/Controllers/LookingForBillController.cs       |   11 ++++++-----
 WebAPI/Properties/PublishProfiles/WEBAPI.pubxml.user |    6 +++---
 2 files changed, 9 insertions(+), 8 deletions(-)

diff --git a/WebAPI/Controllers/LookingForBillController.cs b/WebAPI/Controllers/LookingForBillController.cs
index f54add5..3e6c8a9 100644
--- a/WebAPI/Controllers/LookingForBillController.cs
+++ b/WebAPI/Controllers/LookingForBillController.cs
@@ -93,7 +93,7 @@
         }
 
         /// <summary>
-        /// 鏍规嵁閿�鍞鍗� 杩斿洖姝ら攢鍞鍗曞唴鐨勭浉鍏充俊鎭�
+        /// 涓嬫灦鎵捐揣鍗曟牴鎹攢鍞鍗� 杩斿洖姝ら攢鍞鍗曞唴鐨勭浉鍏充俊鎭�
         /// </summary>
         /// <returns></returns>
         [Route("LookingFor/getSellOrderList")]
@@ -102,8 +102,7 @@
         {
             try
             {
-                string sWhere = " Where HSourceBillNo = '" + HSourceBillNo.Trim() + "'";
-                ds = getSellOrderList_s(sWhere);
+                ds = getSellOrderList_s(HSourceBillNo);
                 if (ds == null || ds.Tables[0].Rows.Count <= 0)
                 {
                     objJsonResult.code = "0";
@@ -132,7 +131,7 @@
         }
 
         /// <summary>
-        /// 鏍规嵁瀹炵墿鏉$爜 杩斿洖鐩稿叧淇℃伅
+        /// 涓婃灦褰掕繕鍗曟牴鎹疄鐗╂潯鐮� 杩斿洖鐩稿叧淇℃伅
         /// </summary>
         /// <returns></returns>
         [Route("LookingFor/getBarCodeDetails")]
@@ -329,8 +328,10 @@
             return new SQLHelper.ClsCN().RunProcReturn("EXEC h_p_Kf_getPackUnionBillListDetailed " + "'" + HBarCode + "'", "h_p_Kf_getPackUnionBillListDetailed");
         }
 
-        public static DataSet getSellOrderList_s(string sWhere)
+        public static DataSet getSellOrderList_s(string HSourceBillNo)
         {
+            string sWhere = " Where HSourceBillNo = '" + HSourceBillNo.Trim() + "'";
+            new SQLHelper.ClsCN().RunProcReturn("exec h_p_IFCLD_ERPSourceBillToLocal_SEOrderToICMO '" + HSourceBillNo + "'", "h_p_IFCLD_ERPSourceBillToLocal_SEOrderToICMO");
             return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_getSellOrderList_s " + sWhere, "h_v_getSellOrderList_s");
         }
 
diff --git a/WebAPI/Properties/PublishProfiles/WEBAPI.pubxml.user b/WebAPI/Properties/PublishProfiles/WEBAPI.pubxml.user
index 21d9385..fad37e3 100644
--- a/WebAPI/Properties/PublishProfiles/WEBAPI.pubxml.user
+++ b/WebAPI/Properties/PublishProfiles/WEBAPI.pubxml.user
@@ -157,10 +157,10 @@
       <publishTime>11/24/2014 11:18:48</publishTime>
     </File>
     <File Include="bin/WebAPI.dll">
-      <publishTime>02/22/2021 22:22:40</publishTime>
+      <publishTime>02/23/2021 12:16:39</publishTime>
     </File>
     <File Include="bin/WebAPI.pdb">
-      <publishTime>02/22/2021 22:22:40</publishTime>
+      <publishTime>02/23/2021 12:16:39</publishTime>
     </File>
     <File Include="bin/WebAPI.XmlSerializers.dll">
       <publishTime>02/04/2021 21:35:21</publishTime>
@@ -334,7 +334,7 @@
       <publishTime>02/22/2021 09:25:20</publishTime>
     </File>
     <File Include="Web.config">
-      <publishTime>02/22/2021 22:22:51</publishTime>
+      <publishTime>02/23/2021 12:16:57</publishTime>
     </File>
   </ItemGroup>
 </Project>
\ No newline at end of file

--
Gitblit v1.9.1