From 4458b932fa0fdb5dfbda8416a30a12620b33b5d9 Mon Sep 17 00:00:00 2001
From: ouyangqing <ouyangqing@DESKTOP-B85SG1D>
Date: 星期二, 26 一月 2021 11:18:21 +0800
Subject: [PATCH] sql 优化
---
WebAPI/Controllers/NewApiController.cs | 52 +++++++++++++++++++++++++++++++++++++---------------
1 files changed, 37 insertions(+), 15 deletions(-)
diff --git a/WebAPI/Controllers/NewApiController.cs b/WebAPI/Controllers/NewApiController.cs
index 970c4f4..333d6b7 100644
--- a/WebAPI/Controllers/NewApiController.cs
+++ b/WebAPI/Controllers/NewApiController.cs
@@ -17,9 +17,9 @@
/// <returns></returns>
[Route("api/newBill/getNewInterBillNo")]
[HttpGet]
- public ApiResult<DocumentsView> GetNewInterBillNo()
+ public ApiResult<DocumentsView> GetNewInterBillNo(string billType)
{
- var model = YqnQbService.GetInterBillNo();
+ var model = YqnQbService.GetInterBillNo(billType);
return model;
}
/// <summary>
@@ -67,6 +67,17 @@
return YqnQbService.GetWorkCenterList(sWhere);
}
/// <summary>
+ /// 杩涚珯鎺ユ敹鍗�
+ /// </summary>
+ /// <param name="oMain"></param>
+ /// <returns></returns>
+ [Route("api/newBill/setStationInBill")]
+ [HttpPost]
+ public ApiResult SetStationInBill(ClsSc_StationInBillMain oMain)
+ {
+ return YqnQbService.SetStationInBill(oMain);
+ }
+ /// <summary>
/// 鑾峰彇杩涚珯鍗曞垪琛�
/// </summary>
/// <param name="sWhere"></param>
@@ -89,27 +100,38 @@
return YqnQbService.GetStationOutBillList(sWhere);
}
/// <summary>
- /// 杩涚珯鎺ユ敹鍗�
- /// </summary>
- /// <param name="oMain"></param>
- /// <returns></returns>
- [Route("api/newBill/setStationInBill")]
- [HttpPost]
- public ApiResult SetStationInBill(ClsSc_StationInBillMain oMain)
- {
- return YqnQbService.SetStationInBill(oMain);
- }
-
- /// <summary>
/// 鍑虹珯绔欐帴鏀跺崟
/// </summary>
/// <param name="oMain"></param>
/// <returns></returns>
[Route("api/newBill/setStationOutBill")]
[HttpPost]
- public ApiResult SetStationOutBill(Model.ClsSc_StationOutBillMain oMain)
+ public ApiResult SetStationOutBill(StationOutBillView oMain)
{
return YqnQbService.SetStationOutBill(oMain);
}
+ /// <summary>
+ /// 鑾峰彇娴佽浆鍗″垪琛�
+ /// </summary>
+ /// <param name="sWhere"></param>
+ /// <returns></returns>
+ [Route("api/newBill/getStationMainList")]
+ [HttpGet]
+ public static ApiResult<DataSet> GetPorcessMainList(string sWhere)
+ {
+ return YqnQbService.GetPorcessMainList(sWhere);
+ }
+ /// <summary>
+ /// 鑾峰彇娴佽浆鍗″瓙琛ㄥ垪琛�
+ /// </summary>
+ /// <param name="sWhere"></param>
+ /// <returns></returns>
+ [Route("api/newBill/getPorcessSubList")]
+ [HttpGet]
+ public static ApiResult<DataSet> GetPorcessSubList(int hInterId)
+ {
+ return YqnQbService.GetPorcessSubList(hInterId);
+
+ }
}
}
--
Gitblit v1.9.1