安灯报表开发

yl

2022-10-25 dd651f9ce0156fc7db869da04e0c2004a1811c52

 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
    }
}