From dd651f9ce0156fc7db869da04e0c2004a1811c52 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 25 十月 2022 21:00:36 +0800
Subject: [PATCH] 安灯报表开发
---
VueWebApi/Controllers/ReportManagerController.cs | 150 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 150 insertions(+), 0 deletions(-)
diff --git a/VueWebApi/Controllers/ReportManagerController.cs b/VueWebApi/Controllers/ReportManagerController.cs
index 0f60425..462eb8c 100644
--- a/VueWebApi/Controllers/ReportManagerController.cs
+++ b/VueWebApi/Controllers/ReportManagerController.cs
@@ -377,5 +377,155 @@
return TJson.toJson(mes);
}
#endregion
+
+
+ #region[瀹夌伅鎶ヨ〃鏄庣粏]
+ /// <summary>
+ /// 瀹夌伅鎶ヨ〃鏄庣粏
+ /// </summary>
+ /// <param name="page">椤电爜</param>
+ /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+ /// <param name="prop">鎺掑簭瀛楁</param>
+ /// <param name="order">鎺掑簭瑙勫垯</param>
+ /// <param name="wkshopcode">杞﹂棿缂栫爜</param>
+ /// <param name="calltypecode">鍛煎彨绫诲瀷缂栫爜</param>
+ /// <param name="calluser">鍛煎彨浜哄憳</param>
+ /// <param name="calldate">鍛煎彨鏃堕棿</param>
+ /// <param name="eqpcode">璁惧缂栫爜</param>
+ /// <param name="eqpname">璁惧鍚嶇О</param>
+ /// <param name="responduser">鍝嶅簲浜哄憳</param>
+ /// <param name="responddate">鍝嶅簲鏃堕棿</param>
+ /// <returns></returns>
+ [Route(template: "AnDonReportDefinitSearch")]
+ [HttpGet]
+ public HttpResponseMessage AnDonReportDefinitSearch(int page, int rows, string prop, string order, string wkshopcode = null, string calltypecode = null, string calluser = null, string calldate = null, string eqpcode = null, string eqpname = null, string responduser = null, string responddate = null)
+ {
+ string callopendate = ""; //鍛煎彨寮�濮嬫椂闂�
+ string callclosedate = ""; //鍛煎彨缁撴潫鏃堕棿
+ string respondopendate = ""; //鍝嶅簲寮�濮嬫椂闂�
+ string respondclosedate = ""; //鍝嶅簲缁撴潫鏃堕棿
+ if (calldate != "" && calldate != null)
+ {
+ callopendate = calldate.Split('~')[0].ToString();
+ callclosedate = calldate.Split('~')[1].ToString();
+ }
+ if (responddate != "" && responddate != null)
+ {
+ respondopendate = responddate.Split('~')[0].ToString();
+ respondclosedate = responddate.Split('~')[1].ToString();
+ }
+ int startNum = rows * (page - 1) + 1; //璧峰璁板綍rowNum
+ int endNum = rows * page; //缁撴潫璁板綍 rowNum
+ mes = ReportManagerBLL.AnDonReportDefinitSearch(wkshopcode, calltypecode, calluser, callopendate, callclosedate, eqpcode, eqpname, responduser,respondopendate, respondclosedate, startNum, endNum, prop, order);
+ return TJson.toJson(mes);
+ }
+ #endregion
+
+ #region[瀹夌伅鎶ヨ〃鏄庣粏瀵煎嚭]
+ /// <summary>
+ /// 瀹夌伅鎶ヨ〃鏄庣粏瀵煎嚭
+ /// </summary>
+ /// <param name="wkshopcode">杞﹂棿缂栫爜</param>
+ /// <param name="calltypecode">鍛煎彨绫诲瀷缂栫爜</param>
+ /// <param name="calluser">鍛煎彨浜哄憳</param>
+ /// <param name="calldate">鍛煎彨鏃堕棿</param>
+ /// <param name="eqpcode">璁惧缂栫爜</param>
+ /// <param name="eqpname">璁惧鍚嶇О</param>
+ /// <param name="responduser">鍝嶅簲浜哄憳</param>
+ /// <param name="responddate">鍝嶅簲鏃堕棿</param>
+ /// <returns></returns>
+ [Route(template: "AnDonReportDefinitExcelSearch")]
+ [HttpGet]
+ public HttpResponseMessage AnDonReportDefinitExcelSearch(string wkshopcode = null, string calltypecode = null, string calluser = null, string calldate = null, string eqpcode = null, string eqpname = null, string responduser = null, string responddate = null)
+ {
+ string callopendate = ""; //鍛煎彨寮�濮嬫椂闂�
+ string callclosedate = ""; //鍛煎彨缁撴潫鏃堕棿
+ string respondopendate = ""; //鍝嶅簲寮�濮嬫椂闂�
+ string respondclosedate = ""; //鍝嶅簲缁撴潫鏃堕棿
+ if (calldate != "" && calldate != null)
+ {
+ callopendate = calldate.Split('~')[0].ToString();
+ callclosedate = calldate.Split('~')[1].ToString();
+ }
+ if (responddate != "" && responddate != null)
+ {
+ respondopendate = responddate.Split('~')[0].ToString();
+ respondclosedate = responddate.Split('~')[1].ToString();
+ }
+ mes = ReportManagerBLL.AnDonReportDefinitExcelSearch(wkshopcode, calltypecode, calluser, callopendate, callclosedate, eqpcode, eqpname, responduser, respondopendate, respondclosedate);
+ return TJson.toJson(mes);
+ }
+ #endregion
+
+
+ #region[瀹夌伅鎶ヨ〃姹囨�籡
+ /// <summary>
+ /// 瀹夌伅鎶ヨ〃姹囨��
+ /// </summary>
+ /// <param name="page">椤电爜</param>
+ /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+ /// <param name="prop">鎺掑簭瀛楁</param>
+ /// <param name="order">鎺掑簭瑙勫垯</param>
+ /// <param name="wkshopcode">杞﹂棿缂栫爜</param>
+ /// <param name="calltypecode">鍛煎彨绫诲瀷缂栫爜</param>
+ /// <param name="calldate">鍛煎彨鏃堕棿</param>
+ /// <param name="responddate">鍝嶅簲鏃堕棿</param>
+ /// <returns></returns>
+ [Route(template: "AnDonReportSumSearch")]
+ [HttpGet]
+ public HttpResponseMessage AnDonReportSumSearch(int page, int rows, string prop, string order, string wkshopcode = null, string calltypecode = null, string calldate = null, string responddate = null)
+ {
+ string callopendate = ""; //鍛煎彨寮�濮嬫椂闂�
+ string callclosedate = ""; //鍛煎彨缁撴潫鏃堕棿
+ string respondopendate = ""; //鍝嶅簲寮�濮嬫椂闂�
+ string respondclosedate = ""; //鍝嶅簲缁撴潫鏃堕棿
+ if (calldate != "" && calldate != null)
+ {
+ callopendate = calldate.Split('~')[0].ToString();
+ callclosedate = calldate.Split('~')[1].ToString();
+ }
+ if (responddate != "" && responddate != null)
+ {
+ respondopendate = responddate.Split('~')[0].ToString();
+ respondclosedate = responddate.Split('~')[1].ToString();
+ }
+ int startNum = rows * (page - 1) + 1; //璧峰璁板綍rowNum
+ int endNum = rows * page; //缁撴潫璁板綍 rowNum
+ mes = ReportManagerBLL.AnDonReportSumSearch(wkshopcode, calltypecode, callopendate, callclosedate, respondopendate, respondclosedate, startNum, endNum, prop, order);
+ return TJson.toJson(mes);
+ }
+ #endregion
+
+ #region[瀹夌伅鎶ヨ〃姹囨�诲鍑篯
+ /// <summary>
+ /// 瀹夌伅鎶ヨ〃姹囨�诲鍑�
+ /// </summary>
+ /// <param name="wkshopcode">杞﹂棿缂栫爜</param>
+ /// <param name="calltypecode">鍛煎彨绫诲瀷缂栫爜</param>
+ /// <param name="calldate">鍛煎彨鏃堕棿</param>
+ /// <param name="responddate">鍝嶅簲鏃堕棿</param>
+ /// <returns></returns>
+ [Route(template: "AnDonReportSumExcelSearch")]
+ [HttpGet]
+ public HttpResponseMessage AnDonReportSumExcelSearch(string wkshopcode = null, string calltypecode = null, string calldate = null, string responddate = null)
+ {
+ string callopendate = ""; //鍛煎彨寮�濮嬫椂闂�
+ string callclosedate = ""; //鍛煎彨缁撴潫鏃堕棿
+ string respondopendate = ""; //鍝嶅簲寮�濮嬫椂闂�
+ string respondclosedate = ""; //鍝嶅簲缁撴潫鏃堕棿
+ if (calldate != "" && calldate != null)
+ {
+ callopendate = calldate.Split('~')[0].ToString();
+ callclosedate = calldate.Split('~')[1].ToString();
+ }
+ if (responddate != "" && responddate != null)
+ {
+ respondopendate = responddate.Split('~')[0].ToString();
+ respondclosedate = responddate.Split('~')[1].ToString();
+ }
+ mes = ReportManagerBLL.AnDonReportSumExcelSearch(wkshopcode, calltypecode, callopendate, callclosedate, respondopendate, respondclosedate);
+ return TJson.toJson(mes);
+ }
+ #endregion
}
}
--
Gitblit v1.9.3