From 34f71b13b15fb5002f61569aa8940c7b6d26bbb5 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 28 十一月 2023 16:16:46 +0800
Subject: [PATCH] 生产日记报表里， 增加 业务员 列， 和增加 业务员过滤（根据名称模糊过滤即可） 功能以及 自定义过滤功能；
---
WebAPI/Controllers/MateOutController.cs | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Controllers/MateOutController.cs b/WebAPI/Controllers/MateOutController.cs
index f5f8a03..858190a 100644
--- a/WebAPI/Controllers/MateOutController.cs
+++ b/WebAPI/Controllers/MateOutController.cs
@@ -2076,6 +2076,7 @@
public string HProductName { get; set; }
public string HOtherSearch { get; set; }
public string HEmpName { get; set; }
+ public string sWheres { get; set; }
}
[Route("MaterOutEntryReport/SC_DayRkReport")]
[HttpGet]
@@ -2086,7 +2087,7 @@
DayRkReport DayRkReportList = JsonConvert.DeserializeObject<DayRkReport>(sWhere);
string sql = $"exec h_p_Gy_DayRkReport '{DayRkReportList.HBeginDate}','{DayRkReportList.HEndDate}','{DayRkReportList.HMaterNumber}'" +
- $",'{DayRkReportList.HProductName}','{DayRkReportList.HCustomerName}','{DayRkReportList.HOtherSearch}'";
+ $",'{DayRkReportList.HProductName}','{DayRkReportList.HCustomerName}','{DayRkReportList.HOtherSearch}','{DayRkReportList.HEmpName}','{DayRkReportList.sWheres}'";
//string sql = $"exec h_p_Gy_DayRkReport '{DayRkReportList.HBeginDate}','{DayRkReportList.HEndDate}','{DayRkReportList.HMaterNumber}'" +
// $",'{DayRkReportList.HProductName}','{DayRkReportList.HCustomerName}'";
--
Gitblit v1.9.1