From 2d41b16e418da7ee8938ef12a5a17f369ae933dd Mon Sep 17 00:00:00 2001
From: zgq <519541279@qq.com>
Date: 星期四, 25 二月 2021 22:26:36 +0800
Subject: [PATCH] nothing

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

diff --git a/WebAPI/Controllers/LookingForBillController.cs b/WebAPI/Controllers/LookingForBillController.cs
index 89064a8..8bbba99 100644
--- a/WebAPI/Controllers/LookingForBillController.cs
+++ b/WebAPI/Controllers/LookingForBillController.cs
@@ -316,17 +316,16 @@
         }
 
         /// <summary>
-        /// 寰呭彂鍖烘壘璐ф牴鎹疄鐗╂潯鐮� 杩斿洖鐩稿叧淇℃伅
+        /// 寰呭彂鍖烘壘璐ф牴鎹簮鍗曞彿 杩斿洖鐩稿叧淇℃伅
         /// </summary>
         /// <returns></returns>
         [Route("LookingFor/getWaitingLookingFor")]
         [HttpGet]
-        public object GetWaitingLookingFor(string HBarCode)
+        public object GetWaitingLookingFor(string HBillType,string HBillNo,string HSourceBillNo,string HCreateBy,string BenginHCreateDate,string EndHCreateDate)
         {
             try
             {
-                string sWhere = " Where 婧愬崟鍙� = '" + HBarCode.Trim() + "'";
-                ds = GetWaitingLookingFor_s(sWhere);
+                ds = GetWaitingLookingFor_s(HBillType, HBillNo, HSourceBillNo, HCreateBy, BenginHCreateDate, EndHCreateDate);
                 if (ds == null || ds.Tables[0].Rows.Count <= 0)
                 {
                     objJsonResult.code = "0";
@@ -383,9 +382,9 @@
         {
             return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_StockPlace " + sWhere, "h_v_IF_StockPlace");
         }
-        public static DataSet GetWaitingLookingFor_s(string sWhere)
+        public static DataSet GetWaitingLookingFor_s(string HBillType, string HBillNo, string HSourceBillNo,string HCreateBy,string BenginHCreateDate,string EndHCreateDate)
         {
-            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_getWaitingLookingFor " + sWhere, "h_v_getWaitingLookingFor");
+            return new SQLHelper.ClsCN().RunProcReturn("EXEC h_p_lookForBillList " + "'" + HBillType + "','" + HBillNo + "','" + HSourceBillNo + "','" + HCreateBy + "','" + HCreateBy + "','" + HCreateBy + "','" + BenginHCreateDate + "','" + EndHCreateDate + "'", "h_p_lookForBillList");
         }
 
         #endregion
diff --git a/WebAPI/Properties/PublishProfiles/WEBAPI.pubxml.user b/WebAPI/Properties/PublishProfiles/WEBAPI.pubxml.user
index 5487634..617b0d2 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/25/2021 11:42:33</publishTime>
+      <publishTime>02/25/2021 22:10:11</publishTime>
     </File>
     <File Include="bin/WebAPI.pdb">
-      <publishTime>02/25/2021 11:42:33</publishTime>
+      <publishTime>02/25/2021 22:10:11</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/25/2021 11:42:44</publishTime>
+      <publishTime>02/25/2021 22:10:21</publishTime>
     </File>
   </ItemGroup>
 </Project>
\ No newline at end of file

--
Gitblit v1.9.1