Пример #1
0
        public void Export()
        {
            MDataTable dt = Select(GridConfig.SelectType.Export);

            dt.TableName   = ObjName;
            dt.DynamicData = GridConfig.GetList(ObjName, GridConfig.SelectType.All);
            Dictionary <string, string> formatParas = GridConfig.SetHeaderDescription(dt);                                                                              //格式化列头(描述)(需要修改列头的数据格式)

            KeyValueConfig.FormatNameValue(dt, formatParas, true);                                                                                                      //格式化配置项
            WebHelper.SendFile(KeyValueConfig.GetTableDescription(ObjName, TableName) + "_" + DateTime.Now.ToString("yyyyMMdd") + ".xls", ExcelHelper.CreateExcel(dt)); //ExcelHelper.CreateExcel(dt)
        }
Пример #2
0
        public virtual void Export()
        {
            MDataTable dt = Select(GridConfig.SelectType.Export);

            dt.TableName   = ObjName;
            dt.DynamicData = GridConfig.GetList(ObjName, GridConfig.SelectType.Export);
            Dictionary <string, string> formatParas = GridConfig.GetFormatter(dt); //格式化列头(描述)(需要修改列头的数据格式)

            KeyValueConfig.FormatNameValue(dt, formatParas, true);                 //格式化配置项
            string fix = ExcelHelper.BookType == ExcelHelper.WorkBookType.High ? ".xlsx" : ".xls";

            WebHelper.SendFile(KeyValueConfig.GetTableDescription(ObjName, TableName) + "_" + DateTime.Now.ToString("yyyyMMdd") + fix, ExcelHelper.CreateExcel(dt));//ExcelHelper.CreateExcel(dt)
        }