From 894e4e2856d5dcf4ac8a3b7be79db7aeb9704ba7 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期三, 03 八月 2022 09:20:39 +0800 Subject: [PATCH] 工序 进站 出站 退出功能 齐套报表 --- WebAPI/Controllers/SCGL/日计划管理/JIT_CompleteController..cs | 43 +++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 43 insertions(+), 0 deletions(-) diff --git "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_CompleteController..cs" "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_CompleteController..cs" index fc8ad92..f3e8764 100644 --- "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_CompleteController..cs" +++ "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_CompleteController..cs" @@ -1,4 +1,5 @@ 锘縰sing DBUtility; +using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; @@ -115,5 +116,47 @@ } } #endregion + + #region 榻愬鍒嗘瀽鎶ヨ〃 + public class ReportMOMaterReadysBill + { + public int? HORGID;//缁勭粐 + public int? HMATERIALID;//鐗╂枡 + public int? HDeptID;//鐢熶骇杞﹂棿 + public int? HSCZYID;//鐢熶骇璧勬簮 + public string HXQD;//闇�姹傚崟鍙� + public string HMOBILLNO;//鐢熶骇璁㈠崟鍙� + } + /// <summary> + /// + /// </summary> + /// <returns></returns> + [Route("JIT_Complete/ReportMOMaterReadysBillList")] + [HttpGet] + public object ReportMOMaterReadysBillList(string sWhere) + { + try + { + + ReportMOMaterReadysBill Report = JsonConvert.DeserializeObject<ReportMOMaterReadysBill>(sWhere); + + ds = oCN.RunProcReturn($"exec PR_Complete_Report '{Report.HXQD}','{Report.HMOBILLNO}',{Report.HORGID},{Report.HDeptID},{Report.HSCZYID},{Report.HMATERIALID}", "PR_Complete_Report"); + + 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 = e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } \ No newline at end of file -- Gitblit v1.9.1