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 +++++------
1 files changed, 5 insertions(+), 6 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
--
Gitblit v1.9.1