From 883bc24b2af63f2b5cadf7576e7892720c7ed9b7 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 16 二月 2023 07:54:46 +0800
Subject: [PATCH] 报工人员、班组合并
---
VueWebApi/Controllers/ReportManagerController.cs | 423 ++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 418 insertions(+), 5 deletions(-)
diff --git a/VueWebApi/Controllers/ReportManagerController.cs b/VueWebApi/Controllers/ReportManagerController.cs
index 8be455e..fbc8c54 100644
--- a/VueWebApi/Controllers/ReportManagerController.cs
+++ b/VueWebApi/Controllers/ReportManagerController.cs
@@ -11,7 +11,7 @@
{
[RoutePrefix(prefix: "api/ReportManager")]
[ControllerGroup("鎶ヨ〃绠＄悊", "鍦ㄧ嚎鎺ュ彛")]
- [ChannelActionFilter]
+ //[ChannelActionFilter]
public class ReportManagerController : ApiController
{
//瀹氫箟鍏ㄥ眬淇℃伅杩斿洖鍙橀噺
@@ -89,6 +89,7 @@
/// <summary>
/// 鐝粍宸ヨ祫鎶ヨ〃璁板綍鏌ヨ
/// </summary>
+ /// <param name="compute">璁＄畻鏂瑰紡(閫愰亾/鏈亾)</param>
/// <param name="wocode">宸ュ崟缂栧彿</param>
/// <param name="partcode">浜у搧缂栫爜</param>
/// <param name="partname">浜у搧鍚嶇О</param>
@@ -104,10 +105,10 @@
/// <returns></returns>
[Route(template: "GroupSalaryReportSearch")]
[HttpGet]
- public HttpResponseMessage GroupSalaryReportSearch(int page, int rows, string prop, string order, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string username = null, string operdate = null)
+ public HttpResponseMessage GroupSalaryReportSearch(int page, int rows, string prop, string order,string compute, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string username = null, string operdate = null)
{
- string operopendate = ""; //鏀舵枡寮�濮嬫椂闂�
- string operclosedate = ""; //鏀舵枡缁撴潫鏃堕棿
+ string operopendate = ""; //鎶ュ伐寮�濮嬫椂闂�
+ string operclosedate = ""; //鎶ュ伐缁撴潫鏃堕棿
if (operdate != "" && operdate != null)
{
operopendate = operdate.Split('~')[0].ToString();
@@ -115,10 +116,422 @@
}
int startNum = rows * (page - 1) + 1; //璧峰璁板綍rowNum
int endNum = rows * page; //缁撴潫璁板綍 rowNum
- mes = ReportManagerBLL.GroupSalaryReportSearch(wocode, partcode, partname, partspec, stepname, groupcode, username, operopendate, operclosedate, startNum, endNum, prop, order);
+ mes = ReportManagerBLL.GroupSalaryReportSearch(compute,wocode, partcode, partname, partspec, stepname, groupcode, username, operopendate, operclosedate, startNum, endNum, prop, order);
return TJson.toJson(mes);
}
#endregion
+ #region[鐝粍宸ヨ祫鎶ヨ〃璁板綍鏌ョ湅鎶ュ伐浜哄憳]
+ /// <summary>
+ /// 鐝粍宸ヨ祫鎶ヨ〃璁板綍鏌ョ湅鎶ュ伐浜哄憳
+ /// </summary>
+ /// <param name="id">鎶ュ伐璁板綍涓昏〃id</param>
+ /// <returns></returns>
+ [Route(template: "GroupSalaryReportSearchUser")]
+ [HttpGet]
+ public HttpResponseMessage GroupSalaryReportSearchUser(string id)
+ {
+ mes = ReportManagerBLL.GroupSalaryReportSearchUser(id);
+ return TJson.toJson(mes);
+ }
+ #endregion
+
+ #region[鐝粍宸ヨ祫鎶ヨ〃璁板綍瀵煎嚭]
+ /// <summary>
+ /// 鐝粍宸ヨ祫鎶ヨ〃璁板綍鏌ヨ
+ /// </summary>
+ /// <param name="compute">璁＄畻鏂瑰紡(閫愰亾/鏈亾)</param>
+ /// <param name="wocode">宸ュ崟缂栧彿</param>
+ /// <param name="partcode">浜у搧缂栫爜</param>
+ /// <param name="partname">浜у搧鍚嶇О</param>
+ /// <param name="partspec">瑙勬牸鍨嬪彿</param>
+ /// <param name="stepname">宸ュ簭鍚嶇О</param>
+ /// <param name="groupcode">鐢熶骇鐝粍</param>
+ /// <param name="username">鎿嶄綔浜哄憳</param>
+ /// <param name="operdate">鎿嶄綔鏃堕棿</param>
+ /// <returns></returns>
+ [Route(template: "GroupSalaryReportExcelSearch")]
+ [HttpGet]
+ public HttpResponseMessage GroupSalaryReportExcelSearch(string compute, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string username = null, string operdate = null)
+ {
+ string operopendate = ""; //鎶ュ伐寮�濮嬫椂闂�
+ string operclosedate = ""; //鎶ュ伐缁撴潫鏃堕棿
+ if (operdate != "" && operdate != null)
+ {
+ operopendate = operdate.Split('~')[0].ToString();
+ operclosedate = operdate.Split('~')[1].ToString();
+ }
+ mes = ReportManagerBLL.GroupSalaryReportExcelSearch(compute,wocode, partcode, partname, partspec, stepname, groupcode, username, operopendate, operclosedate);
+ return TJson.toJson(mes);
+ }
+ #endregion
+
+
+ #region[浜哄憳宸ヨ祫鏄庣粏鎶ヨ〃]
+ /// <summary>
+ /// 浜哄憳宸ヨ祫鏄庣粏鎶ヨ〃
+ /// </summary>
+ /// <param name="compute">璁＄畻鏂瑰紡(閫愰亾/鏈亾)</param>
+ /// <param name="wocode">宸ュ崟缂栧彿</param>
+ /// <param name="partcode">浜у搧缂栫爜</param>
+ /// <param name="partname">浜у搧鍚嶇О</param>
+ /// <param name="partspec">瑙勬牸鍨嬪彿</param>
+ /// <param name="stepname">宸ュ簭鍚嶇О</param>
+ /// <param name="groupcode">鐢熶骇鐝粍</param>
+ /// <param name="reportname">鎶ュ伐浜哄憳</param>
+ /// <param name="reportdate">鎶ュ伐鏃堕棿</param>
+ /// <param name="page">椤电爜</param>
+ /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+ /// <param name="prop">鎺掑簭瀛楁</param>
+ /// <param name="order">鎺掑簭瑙勫垯</param>
+ /// <returns></returns>
+ [Route(template: "PeopleSalaryReportSearch")]
+ [HttpGet]
+ public HttpResponseMessage PeopleSalaryReportSearch(int page, int rows, string prop, string order,string compute, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string reportname = null, string reportdate = null)
+ {
+ string reportopendate = ""; //鎶ュ伐寮�濮嬫椂闂�
+ string reportclosedate = ""; //鎶ュ伐缁撴潫鏃堕棿
+ if (reportdate != "" && reportdate != null)
+ {
+ reportopendate = reportdate.Split('~')[0].ToString();
+ reportclosedate = reportdate.Split('~')[1].ToString();
+ }
+ int startNum = rows * (page - 1) + 1; //璧峰璁板綍rowNum
+ int endNum = rows * page; //缁撴潫璁板綍 rowNum
+ mes = ReportManagerBLL.PeopleSalaryReportSearch(compute,wocode, partcode, partname, partspec, stepname, groupcode, reportname, reportopendate, reportclosedate, startNum, endNum, prop, order);
+ return TJson.toJson(mes);
+ }
+ #endregion
+
+ #region[浜哄憳宸ヨ祫鏄庣粏鎶ヨ〃瀵煎嚭]
+ /// <summary>
+ /// 浜哄憳宸ヨ祫鏄庣粏鎶ヨ〃瀵煎嚭
+ /// </summary>
+ /// <param name="compute">璁＄畻鏂瑰紡(閫愰亾/鏈亾)</param>
+ /// <param name="wocode">宸ュ崟缂栧彿</param>
+ /// <param name="partcode">浜у搧缂栫爜</param>
+ /// <param name="partname">浜у搧鍚嶇О</param>
+ /// <param name="partspec">瑙勬牸鍨嬪彿</param>
+ /// <param name="stepname">宸ュ簭鍚嶇О</param>
+ /// <param name="groupcode">鐢熶骇鐝粍</param>
+ /// <param name="reportname">鎶ュ伐浜哄憳</param>
+ /// <param name="reportdate">鎶ュ伐鏃堕棿</param>
+ /// <returns></returns>
+ [Route(template: "PeopleSalaryReportExcelSearch")]
+ [HttpGet]
+ public HttpResponseMessage PeopleSalaryReportExcelSearch(string compute, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string groupcode = null, string reportname = null, string reportdate = null)
+ {
+ string reportopendate = ""; //鎶ュ伐寮�濮嬫椂闂�
+ string reportclosedate = ""; //鎶ュ伐缁撴潫鏃堕棿
+ if (reportdate != "" && reportdate != null)
+ {
+ reportopendate = reportdate.Split('~')[0].ToString();
+ reportclosedate = reportdate.Split('~')[1].ToString();
+ }
+ mes = ReportManagerBLL.PeopleSalaryReportExcelSearch(compute,wocode, partcode, partname, partspec, stepname, groupcode, reportname, reportopendate, reportclosedate);
+ return TJson.toJson(mes);
+ }
+ #endregion
+
+
+ #region[涓嶈壇鏄庣粏鎶ヨ〃]
+ /// <summary>
+ /// 涓嶈壇鏄庣粏鎶ヨ〃
+ /// </summary>
+ /// <param name="wocode">宸ュ崟缂栧彿</param>
+ /// <param name="partcode">浜у搧缂栫爜</param>
+ /// <param name="partname">浜у搧鍚嶇О</param>
+ /// <param name="partspec">瑙勬牸鍨嬪彿</param>
+ /// <param name="stepname">宸ュ簭鍚嶇О</param>
+ /// <param name="defectcode">缂洪櫡浠ｇ爜</param>
+ /// <param name="defectname">缂洪櫡鍚嶇О</param>
+ /// <param name="reportname">鎶ュ伐浜哄憳</param>
+ /// <param name="reportdate">鎶ュ伐鏃堕棿</param>
+ /// <param name="page">椤电爜</param>
+ /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+ /// <param name="prop">鎺掑簭瀛楁</param>
+ /// <param name="order">鎺掑簭瑙勫垯</param>
+ /// <returns></returns>
+ [Route(template: "DefectDetailsReportSearch")]
+ [HttpGet]
+ public HttpResponseMessage DefectDetailsReportSearch(int page, int rows, string prop, string order, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null,string defectcode=null,string defectname=null, string reportname = null, string reportdate = null)
+ {
+ string reportopendate = ""; //鎶ュ伐寮�濮嬫椂闂�
+ string reportclosedate = ""; //鎶ュ伐缁撴潫鏃堕棿
+ if (reportdate != "" && reportdate != null)
+ {
+ reportopendate = reportdate.Split('~')[0].ToString();
+ reportclosedate = reportdate.Split('~')[1].ToString();
+ }
+ int startNum = rows * (page - 1) + 1; //璧峰璁板綍rowNum
+ int endNum = rows * page; //缁撴潫璁板綍 rowNum
+ mes = ReportManagerBLL.DefectDetailsReportSearch(wocode, partcode, partname, partspec, stepname, defectcode, defectname, reportname, reportopendate, reportclosedate, startNum, endNum, prop, order);
+ return TJson.toJson(mes);
+ }
+ #endregion
+
+ #region[涓嶈壇鏄庣粏鎶ヨ〃瀵煎嚭]
+ /// <summary>
+ /// 涓嶈壇鏄庣粏鎶ヨ〃瀵煎嚭
+ /// </summary>
+ /// <param name="wocode">宸ュ崟缂栧彿</param>
+ /// <param name="partcode">浜у搧缂栫爜</param>
+ /// <param name="partname">浜у搧鍚嶇О</param>
+ /// <param name="partspec">瑙勬牸鍨嬪彿</param>
+ /// <param name="stepname">宸ュ簭鍚嶇О</param>
+ /// <param name="defectcode">缂洪櫡浠ｇ爜</param>
+ /// <param name="defectname">缂洪櫡鍚嶇О</param>
+ /// <param name="reportname">鎶ュ伐浜哄憳</param>
+ /// <param name="reportdate">鎶ュ伐鏃堕棿</param>
+ /// <returns></returns>
+ [Route(template: "DefectDetailsReportExcelSearch")]
+ [HttpGet]
+ public HttpResponseMessage DefectDetailsReportExcelSearch(string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string defectcode = null, string defectname = null, string reportname = null, string reportdate = null)
+ {
+ string reportopendate = ""; //鎶ュ伐寮�濮嬫椂闂�
+ string reportclosedate = ""; //鎶ュ伐缁撴潫鏃堕棿
+ if (reportdate != "" && reportdate != null)
+ {
+ reportopendate = reportdate.Split('~')[0].ToString();
+ reportclosedate = reportdate.Split('~')[1].ToString();
+ }
+ mes = ReportManagerBLL.DefectDetailsReportExcelSearch(wocode, partcode, partname, partspec, stepname, defectcode, defectname, reportname, reportopendate, reportclosedate);
+ return TJson.toJson(mes);
+ }
+ #endregion
+
+
+ #region[鍝佽川寮傚父鎺掕鎶ヨ〃(鍙栨姤宸ヤ笉鑹褰曠己闄峰垎缁勬眹鎬绘潯鏁�)]
+ /// <summary>
+ /// 鍝佽川寮傚父鎺掕鎶ヨ〃
+ /// </summary>
+ /// <returns></returns>
+ [Route(template: "QuaneryDefectReportSearch")]
+ [HttpGet]
+ public HttpResponseMessage QuaneryDefectReportSearch()
+ {
+ mes = ReportManagerBLL.QuaneryDefectReportSearch();
+ return TJson.toJson(mes);
+ }
+ #endregion
+
+
+ #region[缁翠慨鏄庣粏鎶ヨ〃]
+ /// <summary>
+ /// 缁翠慨鏄庣粏鎶ヨ〃
+ /// </summary>
+ /// <param name="wocode">宸ュ崟缂栧彿</param>
+ /// <param name="partcode">浜у搧缂栫爜</param>
+ /// <param name="partname">浜у搧鍚嶇О</param>
+ /// <param name="partspec">瑙勬牸鍨嬪彿</param>
+ /// <param name="stepname">宸ュ簭鍚嶇О</param>
+ /// <param name="style">鎿嶄綔绫诲瀷</param>
+ /// <param name="defectname">缂洪櫡鍚嶇О</param>
+ /// <param name="repairname">缁翠慨浜哄憳</param>
+ /// <param name="repairdate">缁翠慨鏃堕棿</param>
+ /// <param name="page">椤电爜</param>
+ /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+ /// <param name="prop">鎺掑簭瀛楁</param>
+ /// <param name="order">鎺掑簭瑙勫垯</param>
+ /// <returns></returns>
+ [Route(template: "MaintenanceDetailsReportSearch")]
+ [HttpGet]
+ public HttpResponseMessage MaintenanceDetailsReportSearch(int page, int rows, string prop, string order, string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string style = null, string defectname = null, string repairname = null, string repairdate = null)
+ {
+ string repairopendate = ""; //缁翠慨寮�濮嬫椂闂�
+ string repairclosedate = ""; //缁翠慨缁撴潫鏃堕棿
+ if (repairdate != "" && repairdate != null)
+ {
+ repairopendate = repairdate.Split('~')[0].ToString();
+ repairclosedate = repairdate.Split('~')[1].ToString();
+ }
+ int startNum = rows * (page - 1) + 1; //璧峰璁板綍rowNum
+ int endNum = rows * page; //缁撴潫璁板綍 rowNum
+ mes = ReportManagerBLL.MaintenanceDetailsReportSearch(wocode, partcode, partname, partspec, stepname, style, defectname, repairname, repairopendate, repairclosedate, startNum, endNum, prop, order);
+ return TJson.toJson(mes);
+ }
+ #endregion
+
+ #region[缁翠慨鏄庣粏鎶ヨ〃瀵煎嚭]
+ /// <summary>
+ /// 缁翠慨鏄庣粏鎶ヨ〃瀵煎嚭
+ /// </summary>
+ /// <param name="wocode">宸ュ崟缂栧彿</param>
+ /// <param name="partcode">浜у搧缂栫爜</param>
+ /// <param name="partname">浜у搧鍚嶇О</param>
+ /// <param name="partspec">瑙勬牸鍨嬪彿</param>
+ /// <param name="stepname">宸ュ簭鍚嶇О</param>
+ /// <param name="style">鎿嶄綔绫诲瀷</param>
+ /// <param name="defectname">缂洪櫡鍚嶇О</param>
+ /// <param name="repairname">缁翠慨浜哄憳</param>
+ /// <param name="repairdate">缁翠慨鏃堕棿</param>
+ /// <returns></returns>
+ [Route(template: "MaintenanceDetailsReportExcelSearch")]
+ [HttpGet]
+ public HttpResponseMessage MaintenanceDetailsReportExcelSearch(string wocode = null, string partcode = null, string partname = null, string partspec = null, string stepname = null, string style = null, string defectname = null, string repairname = null, string repairdate = null)
+ {
+ string repairopendate = ""; //缁翠慨寮�濮嬫椂闂�
+ string repairclosedate = ""; //缁翠慨缁撴潫鏃堕棿
+ if (repairdate != "" && repairdate != null)
+ {
+ repairopendate = repairdate.Split('~')[0].ToString();
+ repairclosedate = repairdate.Split('~')[1].ToString();
+ }
+ mes = ReportManagerBLL.MaintenanceDetailsReportExcelSearch(wocode, partcode, partname, partspec, stepname, style, defectname, repairname, repairopendate, repairclosedate);
+ 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="eqpcode">璁惧缂栫爜</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 eqpcode=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, eqpcode, calltypecode, callopendate, callclosedate, respondopendate, respondclosedate, startNum, endNum, prop, order);
+ return TJson.toJson(mes);
+ }
+ #endregion
+
+ #region[瀹夌伅鎶ヨ〃姹囨�诲鍑篯
+ /// <summary>
+ /// 瀹夌伅鎶ヨ〃姹囨�诲鍑�
+ /// </summary>
+ /// <param name="wkshopcode">杞﹂棿缂栫爜</param>
+ /// <param name="eqpcode">璁惧缂栫爜</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 eqpcode=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, eqpcode, calltypecode, callopendate, callclosedate, respondopendate, respondclosedate);
+ return TJson.toJson(mes);
+ }
+ #endregion
}
}
--
Gitblit v1.9.3