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 | 27 +++++++++++++++++++++++++--
1 files changed, 25 insertions(+), 2 deletions(-)
diff --git a/WebAPI/Controllers/NewApiController.cs b/WebAPI/Controllers/NewApiController.cs
index eff6c61..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>
@@ -110,5 +110,28 @@
{
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