public void MaybeFast(ReportExecution reportExecution, DetailView view, XafApplication applciation, bool showMeResult = false) { var objectSpace = applciation.CreateObjectSpace() as XPObjectSpace; var report = objectSpace.Session.Query <DoSoReport>().FirstOrDefault(); var xml = report?.Xml; if (!string.IsNullOrEmpty(xml)) { Workbook outDocument = null; var control = reportExecution.SpreadsheetControl; if (control.Document.MailMergeDataSource is SqlDataSource) { outDocument = ExportFromSqlDataSource(control.Document.MailMergeDataSource as SqlDataSource, control); } if (control.Document.MailMergeDataSource is ExcelDataSource) { outDocument = ExportFromExcelDataSource(control.Document.MailMergeDataSource as ExcelDataSource, control); } outDocument.Worksheets.RemoveAt(0); var fullName = Path.Combine(@"C:\Users\Beka\Desktop\New folder", HS.MyTempName + ".Xlsx"); outDocument.SaveDocument(fullName); if (showMeResult) { using (var sheetForm = new DoSoSheetFrom(false)) { sheetForm.spreadsheetControl1.LoadDocument(fullName); sheetForm.ShowDialog(); } } } }
public static DoSoSheetFrom CreateSheetForm() { var sheetForm = new DoSoSheetFrom(true); sheetForm.spreadsheetControl1.Options.DataSourceWizard.EnableCustomSql = true; ISpreadsheetCommandFactoryService service = sheetForm.spreadsheetControl1.GetService(typeof(ISpreadsheetCommandFactoryService)) as ISpreadsheetCommandFactoryService; sheetForm.spreadsheetControl1.ReplaceService <ISpreadsheetCommandFactoryService>(new CustomCommandFactoryServise(service, sheetForm.spreadsheetControl1)); return(sheetForm); }
private void A_ItemDrag(object sender, ItemDragEventArgs e, DoSoSheetFrom form) { var sheet = form.spreadsheetControl1; var aaa = e.Button; var activeCell = sheet.ActiveCell; var view = sender as DevExpress.XtraSpreadsheet.SpreadsheetFieldListTreeView; var selectedItems = view.Selection; foreach (var selectedItem in selectedItems) { var item = selectedItem as DevExpress.XtraReports.Native.DataMemberListNode; var a = item.ToString(); } //var item = e.Item as DevExpress.XtraReports.Native.DataMemberListNode; }
private void SimpleAction_OpenWorkBook_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e) { var form = new DoSoSheetFrom(false); form.Show(); }