From 33de192bcd396abf708fcbc29861482b17b549a2 Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期五, 01 四月 2022 17:42:56 +0800
Subject: [PATCH] 已上传单据搜索功能页签
---
DAL/WMS/ClsKF_PonderationBillMain_Temp_View.cs | 16 +++++++++++++++-
WebAPI/Controllers/SellOutController.cs | 36 ++++++++++++++++++++++++++++++++++++
WebAPI/WebServer.cs | 7 +++++++
3 files changed, 58 insertions(+), 1 deletions(-)
diff --git a/DAL/WMS/ClsKF_PonderationBillMain_Temp_View.cs b/DAL/WMS/ClsKF_PonderationBillMain_Temp_View.cs
index 3a02151..768cd97 100644
--- a/DAL/WMS/ClsKF_PonderationBillMain_Temp_View.cs
+++ b/DAL/WMS/ClsKF_PonderationBillMain_Temp_View.cs
@@ -89,7 +89,7 @@
return Ds;
}
}
-
+ //缂撳瓨鍒楄〃宸蹭笂浼犲垪琛�
public DataSet GetKf_ICStockBillList(string sHBillType, string sHMaker, Int64 sHOWNERID)
{
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
@@ -103,6 +103,20 @@
return Ds;
}
}
+ //缂撳瓨鍒楄〃宸蹭笂浼犳煡璇�
+ public DataSet GetKf_ICStockBillQueryList(string BillType,string HBillNo, string HSourceBillNo)
+ {
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+ DataSet Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBillQueryList '" + BillType + "','" + HBillNo + "','" + HSourceBillNo+"'", "h_p_Kf_ICStockBillQueryList");
+ if (Ds == null || Ds.Tables[0].Rows.Count == 0)
+ {
+ return null;
+ }
+ else
+ {
+ return Ds;
+ }
+ }
//鎵弿鏉＄爜杩斿洖鍑哄叆搴撴潯鐮佷复鏃惰〃淇℃伅
public DataSet GetInfoByID_View(long HInterID, string sBillType, string sWhere)
diff --git a/WebAPI/Controllers/SellOutController.cs b/WebAPI/Controllers/SellOutController.cs
index 93914fa..2dfde99 100644
--- a/WebAPI/Controllers/SellOutController.cs
+++ b/WebAPI/Controllers/SellOutController.cs
@@ -146,7 +146,43 @@
return objJsonResult;
}
}
+ //宸蹭笂浼犳煡璇�
+ [Route("Web/QueryBillUpdateLoad_Json")]
+ [HttpGet]
+ public object QueryBillUpdateLoad_Json(string BillType, string HBillNo, string HSourceBillNo)
+ {
+ try
+ {
+ ds = webserver.GetQueryBillUpdateLoad_Json(BillType, HBillNo, HSourceBillNo);
+ if (ds == null || ds.Tables[0].Rows.Count <= 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
+ }
+ else
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�";
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+ }
+ catch (Exception e)
+ {
+
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
[Route("SellOut/GetMAXNum")]
diff --git a/WebAPI/WebServer.cs b/WebAPI/WebServer.cs
index 042e936..9e2f5af 100644
--- a/WebAPI/WebServer.cs
+++ b/WebAPI/WebServer.cs
@@ -7994,5 +7994,12 @@
return dal.GetKf_ICStockBillList(sHBillType, HMaker, HOrgID);
}
+ //杩斿洖缂撳瓨鍒楄〃鏌ヨ宸蹭笂浼犲垪琛ㄤ俊鎭�
+ public DataSet GetQueryBillUpdateLoad_Json(string BillType, string HBillNo, string HSourceBillNo)
+ {
+ DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
+ return dal.GetKf_ICStockBillQueryList(BillType, HBillNo, HSourceBillNo);
+ }
+
}
}
\ No newline at end of file
--
Gitblit v1.9.1