From 5ab307b540f0dcf562642a05df0d67f01e3168e7 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期一, 16 十二月 2024 11:06:17 +0800 Subject: [PATCH] 器具领用退库单 的列表 分页改为 数据库分页; --- WebAPI/Controllers/MJGL/Sc_MouldDotCheckRuleBillController.cs | 39 +++++++++++++++++++++++++++++++++++++++ 1 files changed, 39 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/MJGL/Sc_MouldDotCheckRuleBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldDotCheckRuleBillController.cs index d17c116..9e1745f 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldDotCheckRuleBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldDotCheckRuleBillController.cs @@ -392,5 +392,44 @@ } } #endregion + + #region[鍣ㄥ叿鐐规璁板綍琛紝閫夌偣妫�璁″垝鑾峰彇鐐规璁″垝娓呭崟淇℃伅] + [Route("Sc_MouldDotCheckPlanBill/Sc_MouldDotCheckPlanBill_PlanList")] + [HttpGet] + public object Sc_MouldDotCheckPlanBill_PlanList(string HInterID, string HDate) + { + DataSet ds; + try + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + + ds = oCN.RunProcReturn("exec h_p_Sc_MouldDotCheck_GetPlanList " + HInterID + ",'" + HDate + "'", "h_p_Sc_MouldDotCheck_GetPlanList"); + + if (ds.Tables[0].Rows.Count != 0 || ds != null) + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; + objJsonResult.data = ds.Tables[0]; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁鏌ヨ鍒版暟鎹俊鎭紒"; + objJsonResult.data = ds.Tables[0]; + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍙戠敓寮傚父锛屾病鏈夎繑鍥炰换浣曡鍒掞紒" + e.ToString(); + objJsonResult.data = null; + } + return objJsonResult; + } + #endregion + } } \ No newline at end of file -- Gitblit v1.9.1