Example #1
0
        /// </summary>
        /// 测试数据: Reports/GetQualityDailyReport?DataTime=2018-05-11&lineid=1
        public FileStreamResult GetQualityDailyReport(string DataTime, int lineid = 1)
        {
            //模板路径
            string strPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory,
                                          "ExcelFiles\\华宝硫化鞋生产线质量日报表模板.xls");
            //服务器生成路径
            string strServerPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory,
                                                "ExcelFiles\\日报表\\" + "华宝硫化鞋生产线质量日报表" + DataTime) + ".xls";
            ReportServer reportServer = new ReportServer();
            DateTime     starttime    = Convert.ToDateTime(DataTime);
            string       StartDate    = starttime.ToString("yyyy-MM-dd HH:mm:ss");

            DateTime endtime = Convert.ToDateTime(DataTime).AddDays(1);
            string   EndDate = endtime.ToString("yyyy-MM-dd HH:mm:ss");

            reportServer.GetQualityDailyReport(strPath, strServerPath, StartDate, EndDate, lineid);
            return(File(new FileStream(strServerPath, FileMode.Open), "application/octet-stream", Server.UrlEncode("华宝硫化鞋生产线质量日报表" + "ExcelFiles\\日报表\\" + "华宝硫化鞋生产线质量日报表" + DataTime) + ".xls"));
        }