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