void reconcileForecastDialog_Accepting(object sender, DevExpress.ExpressApp.SystemModule.DialogControllerAcceptingEventArgs e) { var reconciler = new BankStmtForecastReconciler((XPObjectSpace)View.ObjectSpace); // Record the Cash Flow Forecast that was reconciled with the Bank Stmt reconciler.ReconcileItem((BankStmt)View.CurrentObject, (CashFlow)e.AcceptActionArgs.CurrentObject); }
void dialog_Accepting(object sender, DevExpress.ExpressApp.SystemModule.DialogControllerAcceptingEventArgs e) { var session = _ParamObj.Session; var sortProps = new SortingCollection(null); var cop = CriteriaOperator.Parse("TranDate Between(?,?)", _ParamObj.FromDate, _ParamObj.ToDate); var cashFlows = session.GetObjects(session.GetClassInfo(typeof(CashFlow)), cop, sortProps, 0, false, true); ExcelWorksheet ws = Package.Workbook.Worksheets["Data"]; ExcelReportHelper.CopyObjectsToWorksheet(session, cashFlows, ws); var reportSheet = Package.Workbook.Worksheets["Report"]; session.CommitTransaction(); }
void dialog_Accepting(object sender, DevExpress.ExpressApp.SystemModule.DialogControllerAcceptingEventArgs e) { var session = _ParamObj.Session; var jnlGroupKeysInParams = _ParamObj.JournalGroupParams.Select(p => p.JournalGroup.Oid); var sortProps = new SortingCollection(null); sortProps.Add(new SortProperty("SrcDate", DevExpress.Xpo.DB.SortingDirection.Ascending)); var cop = CriteriaOperator.Parse("SrcDate Between(?,?)", _ParamObj.FromDate, _ParamObj.ToDate); var copGenLedgerInJnlGroups = new InOperator("JournalGroup.Oid", jnlGroupKeysInParams); cop = GroupOperator.And(cop, copGenLedgerInJnlGroups); var genLedgers = session.GetObjects(session.GetClassInfo(typeof(GenLedger)), cop, sortProps, 0, false, true); ExcelWorksheet ws = Package.Workbook.Worksheets["Data"]; ExcelReportHelper.CopyObjectsToWorksheet(session, genLedgers, ws); session.CommitTransaction(); }