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