예제 #1
0
        private static string GetResult(NameValueCollection queryString,
                                        int page, MDataTable result, string colName)
        {
            if (page != 0 || queryString["page"].IsNullOrEmpty())
            {
                return(result.ToJson().Replace(" 00:00:00", ""));
            }

            //更改列名为中文名
            var colNames             = colName.Split('~');
            var shouldRemoveColNames = new List <string>();

            foreach (var column in result.Columns)
            {
                var dtColName = column.ColumnName;
                var index     = colNames.IndexOf(dtColName);
                if (index >= 0)
                {
                    column.ColumnName = colNames[index + 1];
                    continue;
                }
                shouldRemoveColNames.Add(dtColName);
            }

            //移除无需导出的列
            foreach (var removeColName in shouldRemoveColNames)
            {
                result.Columns.Remove(removeColName);
            }
            var tablename = result.TableName;
            var filename  = SAction.GetOneValue <string>("SysTableFilename", "tablename".ToWhere(tablename), "Filename");

            filename = filename.IsNullOrEmpty() ? tablename : filename;
            var workbook = result.ToWorkbook();

            workbook.SetSheetName(0, filename);
            ExportExcel.WriteExcel(workbook, filename);
            return(null);
        }