• ASP.NET MVC RDLC-导出


            #region 导出
            /// <summary>
            /// 导出Excel或Pdf文件,通过文件扩展名自动识别
            /// </summary>
            /// <param name="name">文件路径及名称(包括扩展名)</param>
            /// <returns>导出成功返回true,否则返回false</returns>
            private bool ReportExport(string name)
            {
                bool result = false;

                string Name = name;
                string strFileName;//文件名
                string strExtend = ".xls";//扩展名
                string strFormat = "Excel";//文件格式
                bool validate = false;

                if (name != null || name.Trim() != String.Empty)
                {
                    Name = name.Trim();
                    strFileName = Path.GetFileName(Name);
                    if (strFileName.Trim() != String.Empty)
                    {
                        strExtend = Path.GetExtension(Name).Trim().ToLower();

                        switch (strExtend)
                        {
                            case ".xls":
                                strFormat = "EXcel";
                                break;
                            case ".pdf":
                                strFormat = "PDF";
                                break;
                            default:
                                strFormat = "Excel";
                                break;
                        }
                        validate = true;
                    }
                }

                if (validate)
                {
                    Warning[] Warnings;
                    string[] strStreamIds;
                    string strMimeType;
                    string strEncoding;
                    string strFileNameExtension;

                    byte[] bytes = this.rptView.LocalReport.Render(strFormat, null, out strMimeType,
       out strEncoding, out strFileNameExtension, out strStreamIds, out Warnings);

                    using (System.IO.FileStream fs = new FileStream(Name, FileMode.Create))
                    {
                        fs.Write(bytes, 0, bytes.Length);
                    }

                    result = true;
                }

                return result;
            }
            #endregion 导出

  • 相关阅读:
    Threejs学习 一
    Mapbox的表达式
    mapbox 不加载地图
    SQL Server将查询出数据进行列转行操作
    SQL Server 常用近百条SQL语句(收藏版)
    SQL Server DATEDIFF() 函数用法
    SQL Server 数据库开启日志CDC记录,导致SQL Server 数据库日志异常增大
    查询SQL Server数据库使用的版本号信息
    windows 无法启动 SQL Server (MSSQLSERVER) 服务(位于本地计算机上)。错误 1069由于登入失败而无法启动 。
    SQL Server 不同数据间建立链接服务器进行连接查询
  • 原文地址:https://www.cnblogs.com/xhety/p/3682739.html
Copyright © 2020-2023  润新知