From ca089c3c0de722bdd1e4d49c40c8bff0d3a26fc2 Mon Sep 17 00:00:00 2001
From: zgq <519541279@qq.com>
Date: 星期四, 25 二月 2021 11:05:08 +0800
Subject: [PATCH] 22
---
WebAPI/Controllers/LookingForBillController.cs | 56 +++++++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 51 insertions(+), 5 deletions(-)
diff --git a/WebAPI/Controllers/LookingForBillController.cs b/WebAPI/Controllers/LookingForBillController.cs
index 620b90b..fff9cbf 100644
--- a/WebAPI/Controllers/LookingForBillController.cs
+++ b/WebAPI/Controllers/LookingForBillController.cs
@@ -14,6 +14,8 @@
private json objJsonResult = new json();
public DataSet ds = new DataSet();
public WebServer webserver = new WebServer();
+
+
/// <summary>
/// 鏍规嵁鍖呰鍗� 杩斿洖姝ゅ寘瑁呭崟鍐呯殑鐩稿叧淇℃伅
/// </summary>
@@ -91,7 +93,7 @@
}
/// <summary>
- /// 鏍规嵁閿�鍞鍗� 杩斿洖姝ら攢鍞鍗曞唴鐨勭浉鍏充俊鎭�
+ /// 涓嬫灦鎵捐揣鍗曟牴鎹攢鍞鍗� 杩斿洖姝ら攢鍞鍗曞唴鐨勭浉鍏充俊鎭�
/// </summary>
/// <returns></returns>
[Route("LookingFor/getSellOrderList")]
@@ -100,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";
@@ -130,7 +131,7 @@
}
/// <summary>
- /// 鏍规嵁瀹炵墿鏉＄爜 杩斿洖鐩稿叧淇℃伅
+ /// 涓婃灦褰掕繕鍗曟牴鎹疄鐗╂潯鐮� 杩斿洖鐩稿叧淇℃伅
/// </summary>
/// <returns></returns>
[Route("LookingFor/getBarCodeDetails")]
@@ -314,6 +315,45 @@
}
}
+ /// <summary>
+ /// 寰呭彂鍖烘壘璐ф牴鎹疄鐗╂潯鐮� 杩斿洖鐩稿叧淇℃伅
+ /// </summary>
+ /// <returns></returns>
+ [Route("LookingFor/getWaitingLookingFor")]
+ [HttpGet]
+ public object GetWaitingLookingFor(string HBarCode)
+ {
+ try
+ {
+ string sWhere = " Where HBarCode = '" + HBarCode.Trim() + "'";
+ ds = GetWaitingLookingFor_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;
+ }
+ }
+
#region sql璇彞
@@ -327,8 +367,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)
{
+ new SQLHelper.ClsCN().RunProcReturn("EXEC h_p_IFCLD_ERPSourceBillToLocal_SEOrderToICMO '" + HSourceBillNo+ "'", "h_p_IFCLD_ERPSourceBillToLocal_SEOrderToICMO");
+ string sWhere = " Where HSourceBillNo = '" + HSourceBillNo.Trim() + "'";
return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_getSellOrderList_s " + sWhere, "h_v_getSellOrderList_s");
}
@@ -341,6 +383,10 @@
{
return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_StockPlace " + sWhere, "h_v_IF_StockPlace");
}
+ public static DataSet GetWaitingLookingFor_s(string sWhere)
+ {
+ return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_getWaitingLookingFor " + sWhere, "h_v_getWaitingLookingFor");
+ }
#endregion
--
Gitblit v1.9.1