Example #1
0
        public static void ProcessExport(HttpContext context)
        {
            IList <string>      columnFields;
            IDataExportProvider provider;
            string extension;
            string portal  = context.Request["portal"];
            string columns = context.Request["columns"];

            //获取导出提供者
            switch (context.Request["exportFormat"] ?? "excel")
            {
            default:
            case "excel":
                provider  = new LocaledExcelExportProvider();
                extension = "xls";
                break;

            case "csv":
                provider  = new CsvExportProvider();
                extension = "csv";
                break;

            case "txt":
                provider  = new TextExportProvider();
                extension = "txt";
                break;
            }


            //获取列名
            // Regex reg = new Regex("^export_fields\\[\\d+\\]$", RegexOptions.IgnoreCase);
            columnFields = new List <string>();

//            foreach (string key in context.Request.QueryString.Keys)
//            {
//                if (reg.IsMatch(key))
//                {
//                    columnFields.Add(context.Request.QueryString[key]);
//                }
//            }


            IDataExportPortal _portal = ExportItemManager.GetPortal(context.Request.QueryString["portal"]);

            if (_portal == null)
            {
                throw new ArgumentNullException("_portal");
            }

            ExportParams parameter = DataExportDirector.GetExportParams(context.Request["params"], columnFields.ToArray());


            byte[] bytes = DataExportDirector.Export(_portal, parameter, provider);

            context.Response.BinaryWrite(bytes);
            context.Response.ContentType = "application/octet-stream";
            context.Response.AppendHeader("Content-Disposition", String.Format("attachment;filename=\"{0:yyyyMMdd-hhssfff}.{1}\"",
                                                                               DateTime.Now,
                                                                               extension));
        }
Example #2
0
        public static string GetExportData(HttpContext context)
        {
            IDataExportPortal portal    = ExportItemManager.GetPortal(context.Request.QueryString["portal"]);
            ExportParams      parameter = DataExportDirector.GetExportParams(
                context.Request["params"], null);
            int pageIndex, pageSize;

            if (context.Request["page"] != null)
            {
                int.TryParse(context.Request["page"], out pageIndex);
                parameter.Parameters.Add("pageIndex", pageIndex);
            }

            if (context.Request["rows"] != null)
            {
                int.TryParse(context.Request["rows"], out pageSize);
                parameter.Parameters.Add("pageSize", pageSize);
            }

            int       totalCount;
            DataTable dt = portal.GetShemalAndData(parameter.Parameters, out totalCount);

            return(JsonConvert.SerializeObject(new { total = totalCount, rows = dt }));
        }
Example #3
0
        public static string Setup(string portal)
        {
            IDataExportPortal dp = ExportItemManager.GetPortal(portal);

            return(WebExportOptionUIBuilder.BuildColumnCheckHtml(dp));
        }