From 95fde02469c2709544649aa73ea380abb65b6daa Mon Sep 17 00:00:00 2001 From: chenhaozhe <cgz@hz-kingdee.com> Date: 星期四, 12 六月 2025 13:56:17 +0800 Subject: [PATCH] 添加模具状态分析API --- WebAPI/Controllers/WebAPIController.cs | 54 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 54 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 1bcc961..338f5dd 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -19220,6 +19220,60 @@ } /// <summary> + /// 鏍规嵁妯″叿浠撳簱缂栧彿鑾峰彇妯″叿鏁版嵁 + /// </summary> + /// <param name="sWhere">绛涢�夋潯浠�</param> + /// <param name="user">鎿嶄綔鐢ㄦ埛</param> + /// <param name="Organization">缁勭粐</param> + /// <returns>妯″叿鏁版嵁娓呭崟</returns> + [Route("Web/Get_Sc_MouldStatusAnalysisList")] + [HttpGet] + public object Get_Sc_MouldStatusAnalysisList(string sWhere, string user, string Organization) + { + try + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + if (sWhere == null || sWhere.Equals("")) + { + ds = oCN.RunProcReturn("Select * from h_v_Sc_MouldStatusAnalysisList where 1=1 Order by HInterID DESC", "h_v_Sc_MouldStatusAnalysisList"); + } + else + { + string sql1 = "Select * from h_v_Sc_MouldStatusAnalysisList where 1=1 "; + string sql = sql1 + sWhere + " Order by HInterID DESC"; + ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldStatusAnalysisList"); + } + + + if (ds == null || ds.Tables[0].Rows.Count <= 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + DBUtility.ClsPub.sErrInfo; + objjson.data = null; + return objjson; + } + else + { + objjson.code = "0"; + objjson.count = 1; + objjson.Message = "鑾峰彇鎴愬姛!"; + objjson.data = ds.Tables[0]; + return objjson; + } + } + catch (Exception ex) + { + + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + ex.ToString(); + objjson.data = null; + return objjson; + } + } + + /// <summary> /// 鑾峰彇鍣ㄥ叿鍒楄〃 /// </summary> /// <returns></returns> -- Gitblit v1.9.1