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 | 62 +++++++++++++++++++++++++++++--
1 files changed, 58 insertions(+), 4 deletions(-)
diff --git a/WebAPI/Controllers/NewApiController.cs b/WebAPI/Controllers/NewApiController.cs
index 7b20871..333d6b7 100644
--- a/WebAPI/Controllers/NewApiController.cs
+++ b/WebAPI/Controllers/NewApiController.cs
@@ -2,8 +2,6 @@
using System.Collections.Generic;
using System.Data;
using System.Linq;
-using System.Net;
-using System.Net.Http;
using System.Web.Http;
using WebAPI.Models;
using WebAPI.Service;
@@ -19,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>
@@ -79,5 +77,61 @@
{
return YqnQbService.SetStationInBill(oMain);
}
+ /// <summary>
+ /// 鑾峰彇杩涚珯鍗曞垪琛�
+ /// </summary>
+ /// <param name="sWhere"></param>
+ /// <returns></returns>
+ [Route("api/newBill/getStationInBillList")]
+ [HttpGet]
+ public ApiResult<DataSet> GetStationInBillList(string sWhere)
+ {
+ return YqnQbService.GetStationInBillList(sWhere);
+ }
+ /// <summary>
+ /// 鑾峰彇鍑虹珯鍗曞垪琛�
+ /// </summary>
+ /// <param name="sWhere"></param>
+ /// <returns></returns>
+ [Route("api/newBill/getStationOutBillList")]
+ [HttpGet]
+ public ApiResult<DataSet> GetStationOutBillList(string sWhere)
+ {
+ return YqnQbService.GetStationOutBillList(sWhere);
+ }
+ /// <summary>
+ /// 鍑虹珯绔欐帴鏀跺崟
+ /// </summary>
+ /// <param name="oMain"></param>
+ /// <returns></returns>
+ [Route("api/newBill/setStationOutBill")]
+ [HttpPost]
+ 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