From 34f71b13b15fb5002f61569aa8940c7b6d26bbb5 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期二, 28 十一月 2023 16:16:46 +0800 Subject: [PATCH] 生产日记报表里, 增加 业务员 列, 和增加 业务员过滤(根据名称模糊过滤即可) 功能以及 自定义过滤功能; --- WebAPI/Controllers/CJGL/ProductionPlanReportController.cs | 9 +++++++-- 1 files changed, 7 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/CJGL/ProductionPlanReportController.cs b/WebAPI/Controllers/CJGL/ProductionPlanReportController.cs index 81dd391..49fccb7 100644 --- a/WebAPI/Controllers/CJGL/ProductionPlanReportController.cs +++ b/WebAPI/Controllers/CJGL/ProductionPlanReportController.cs @@ -27,8 +27,13 @@ public DateTime HEndDate; public string HICMOBillNo; public string HWorkShopID; - public string HSeOrderBillNo; + public string F_BSV_WYID; + public string HBillNo; public string HMaterNumber; + public int IsTrue; + public int HState; + public int HSTATUS; + public string sWhere1; } [Route("ProductionPlanReport/ProductionPlanReportList")] [HttpGet] @@ -40,7 +45,7 @@ ProductionPlanReport com = JsonConvert.DeserializeObject<ProductionPlanReport>(sWhere.ToString()); ds = oCN.RunProcReturn($"exec h_p_Cj_ProductionPlanReportList {com.HOrgID},'{com.HBeginDate}','{com.HEndDate}'" + - $",'{com.HICMOBillNo}',{com.HWorkShopID},'{com.HSeOrderBillNo}','{com.HMaterNumber}'", "h_p_Cj_ProductionPlanReportList"); + $",'{com.HICMOBillNo}',{com.HWorkShopID},'{com.F_BSV_WYID}','{com.HMaterNumber}','{com.HBillNo}',{com.IsTrue},'{com.HState}','{com.HSTATUS}','{com.sWhere1}'", "h_p_Cj_ProductionPlanReportList"); objJsonResult.code = "1"; objJsonResult.count = 1; -- Gitblit v1.9.1