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) }
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) }