private void frmExport_Load(object sender, EventArgs e) { //Excel文件过滤器 ctlExportFilePicker.FileFilter = Utility.ExcelFilter; _exportType = EnumMgr.ExportType.Excel; ctlExportFilePicker.InitFileName = RuntimeMongoDbContext.GetCurrentCollection().Name; optExcel.CheckedChanged += optExportType_CheckedChanged; optText.CheckedChanged += optExportType_CheckedChanged; optXML.CheckedChanged += optExportType_CheckedChanged; GuiConfig.Translateform(this); }
private void frmExport_Load(object sender, EventArgs e) { //Excel文件过滤器 ctlExportFilePicker.FileFilter = Utility.ExcelFilter; _exportType = EnumMgr.ExportType.Excel; ctlExportFilePicker.FileName = RuntimeMongoDbContext.GetCurrentCollection().Name; optExcel.CheckedChanged += optExportType_CheckedChanged; optText.CheckedChanged += optExportType_CheckedChanged; optXML.CheckedChanged += optExportType_CheckedChanged; GuiConfig.Translateform(this); }
/// <summary> /// 导出类型更改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void optExportType_CheckedChanged(object sender, EventArgs e) { if (optExcel.Checked) { ctlExportFilePicker.FileFilter = Utility.ExcelFilter; _exportType = EnumMgr.ExportType.Excel; } if (optText.Checked) { ctlExportFilePicker.FileFilter = Utility.TxtFilter; _exportType = EnumMgr.ExportType.Text; } if (!optXML.Checked) return; ctlExportFilePicker.FileFilter = Utility.XmlFilter; _exportType = EnumMgr.ExportType.Xml; }
/// <summary> /// 导出类型更改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void optExportType_CheckedChanged(object sender, EventArgs e) { if (optExcel.Checked) { ctlExportFilePicker.FileFilter = Utility.ExcelFilter; _exportType = EnumMgr.ExportType.Excel; } if (optText.Checked) { ctlExportFilePicker.FileFilter = Utility.TxtFilter; _exportType = EnumMgr.ExportType.Text; } if (!optXML.Checked) { return; } ctlExportFilePicker.FileFilter = Utility.XmlFilter; _exportType = EnumMgr.ExportType.Xml; }
/// <summary> /// ExportToFile /// </summary> /// <param name="currentDataViewInfo"></param> /// <param name="excelFileName"></param> /// <param name="exportType"></param> /// <param name="mongoCol"></param> public static void ExportToFile(DataViewInfo currentDataViewInfo, string excelFileName, EnumMgr.ExportType exportType, MongoCollection mongoCol) { MongoCursor <BsonDocument> cursor; cursor = mongoCol.FindAllAs <BsonDocument>(); var dataList = cursor.ToList(); switch (exportType) { case EnumMgr.ExportType.Text: ExportToJson(dataList, excelFileName, MongoHelper.JsonWriterSettings); break; case EnumMgr.ExportType.Excel: case EnumMgr.ExportType.Xml: break; } MongoHelper.OnActionDone(new ActionDoneEventArgs(" Completed ")); }
/// <summary> /// ExportToFile /// </summary> /// <param name="currentDataViewInfo"></param> /// <param name="excelFileName"></param> /// <param name="exportType"></param> /// <param name="mongoCol"></param> public static void ExportToFile(DataViewInfo currentDataViewInfo, string excelFileName, EnumMgr.ExportType exportType, MongoCollection mongoCol) { MongoCursor <BsonDocument> cursor; //Query condition: if (currentDataViewInfo != null && currentDataViewInfo.IsUseFilter) { cursor = mongoCol.FindAs <BsonDocument>( QueryHelper.GetQuery(currentDataViewInfo.MDataFilter.QueryConditionList)) .SetFields(QueryHelper.GetOutputFields(currentDataViewInfo.MDataFilter.QueryFieldList)) .SetSortOrder(QueryHelper.GetSort(currentDataViewInfo.MDataFilter.QueryFieldList)); } else { cursor = mongoCol.FindAllAs <BsonDocument>(); } var dataList = cursor.ToList(); switch (exportType) { case EnumMgr.ExportType.Excel: //ExportToExcel(dataList, ExcelFileName); GC.Collect(); break; case EnumMgr.ExportType.Text: ExportToJson(dataList, excelFileName, MongoHelper.JsonWriterSettings); break; case EnumMgr.ExportType.Xml: break; } MongoHelper.OnActionDone(new ActionDoneEventArgs(" Completed ")); }