From a4bcd77a358483d6de0b2e766d7f6223e0df1784 Mon Sep 17 00:00:00 2001 From: zgq <519541279@qq.com> Date: 星期四, 24 六月 2021 13:35:08 +0800 Subject: [PATCH] 包装单缓存列表 --- WebAPI/Controllers/ReportController.cs | 41 +++++++++++++++++++++++++++++++++++++++++ 1 files changed, 41 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/ReportController.cs b/WebAPI/Controllers/ReportController.cs index a8294e9..a60ca4b 100644 --- a/WebAPI/Controllers/ReportController.cs +++ b/WebAPI/Controllers/ReportController.cs @@ -73,6 +73,47 @@ } } + /// <summary> + /// 杩斿洖宸ュ簭鍦ㄥ埗鍝佹姤琛� + /// </summary> + /// <param name="EdDate">鎴鏃堕棿</param> + /// <param name="sWhere">鎷兼帴鐨凷QL</param> + /// <returns>object</returns> + [Route("Report/ProcessWIPReport")] + [HttpGet] + public object ProcessWIPReport(DateTime EdDate, string sWhere) + { + DataSet ds; + try + { + ds = oCN.RunProcReturn("exec h_p_K3_Sc_WIPSumReportDateReport '" + EdDate + "','" + sWhere + "'", "h_p_K3_Sc_WIPSumReportDateReport"); + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳暟鎹紒"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + // } } \ No newline at end of file -- Gitblit v1.9.1