sql 优化

ouyangqing

2021-01-26 4458b932fa0fdb5dfbda8416a30a12620b33b5d9

 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);
            
        }
    }
}