private void dashboardControl_AsyncDataLoading(object sender, DataLoadingEventArgs e) { if (e.DataSourceName == "MyDataSource") { e.Data = Data.CreateData(); } }
protected virtual void OnDataLoading(DataLoadingEventArgs args) { if (DataLoading != null) { DataLoading(this, args); } }
private void DashboardViewer1_DataLoading(object sender, DataLoadingEventArgs e) { if (e.DataSourceName == "EnergyConsumptionBySector") { e.Data = GetData(dataFileName); } }
private void dashboardViewer1_DataLoading(object sender, DataLoadingEventArgs e) { if (e.DataSourceComponentName == "dataSource1") { e.Data = nwindDataSet.SalesPerson; } }
// Handles the DashboardViewer.DataLoading event to provide the dashboard with new data. private void dashboardViewer1_DataLoading(object sender, DataLoadingEventArgs e) { if (e.DataSourceName == "Data Source 1") { e.Data = Data.CreateData(); } }
private void dashboardViewer1_DataLoading(object sender, DataLoadingEventArgs e) { if (e.DataSourceName.StartsWith("ods|")) { string[] names = e.DataSourceName.Split("|".ToCharArray()); DashboardSqlDataSource dataSource = dataSources.First(ds => ds.ComponentName == names[1]); SqlQuery query = dataSource.Queries.First(q => q.Name == names[2]); XElement dsXML = dataSource.SaveToXml(); SqlDataSource sqlDS = new SqlDataSource(); sqlDS.LoadFromXml(dsXML); sqlDS.ConnectionName = "Connection"; sqlDS.Fill(query.Name); ResultSet rSet = ((IListSource)sqlDS).GetList() as ResultSet; ResultTable rTable = rSet.Tables.First(t => t.TableName == query.Name); if (query.Name == "Invoices") { var dt = ConvertResultTableToDataTable(rTable); for (int i = dt.Rows.Count - 1; i >= 0; i--) { if (((DateTime)dt.Rows[i]["OrderDate"]).Year < 2016) { dt.Rows.RemoveAt(i); } } e.Data = dt; } else { e.Data = rTable; } } }
void smMaster_DataLoading(object sender, DataLoadingEventArgs e) { e.Cancel = true; ISearchExpression searchExpression = e.SearchExpression; IList <ISearchOrder> searchOrders = e.SearchOrders; ReportGenerator.SetParameter(this.ReportViewer.CrystalHelper, searchExpression); this.ReportViewer.OpenReport(); }
void smMaster_DataLoading(object sender, DataLoadingEventArgs e) { e.Cancel = true; ISearchExpression searchExpression = e.SearchExpression; IList <ISearchOrder> searchOrders = e.SearchOrders; if (this.SearchManager != null) { for (int i = 0; i < m_reportDataInfos.Count; ++i) { m_sms[i].EnablePage = this.SearchManager.EnablePage; m_sms[i].FirstResult = this.SearchManager.FirstResult; m_sms[i].MaxResult = this.SearchManager.MaxResult; m_sms[i].IsResultDistinct = this.SearchManager.IsResultDistinct; } } bool haveSetMasterSearchManager = false; for (int i = 0; i < m_reportDataInfos.Count; ++i) { object data = m_sms[i].GetData(searchExpression, searchOrders); System.Collections.IEnumerable dataList = data as System.Collections.IEnumerable; if (dataList == null) { dataList = (data as System.Data.DataTable).DefaultView; } System.Data.DataTable dt = this.ReportViewer.TemplateDataSet.Tables[m_reportDataInfos[i].DatasetTableName]; dt.Rows.Clear(); GenerateReportData.Generate(dt, dataList, m_reportDataInfos[i].GridName); if (!haveSetMasterSearchManager) { this.SearchManager.Count = m_sms[i].GetCount(searchExpression); haveSetMasterSearchManager = true; this.SearchManager.OnDataLoaded(new DataLoadedEventArgs(m_sms[i].Result, m_sms[i].Count)); } } // Set Parameter ReportGenerator.SetParameter(this.ReportViewer.CrystalHelper, searchExpression); if (m_reportInfo.AfterProcess != null) { ProcessInfoHelper.ExecuteProcess(ADInfoBll.Instance.GetProcessInfo(m_reportInfo.AfterProcess.Name), new Dictionary <string, object> { { "masterForm", this } }); } this.ReportViewer.OpenReport(); }
void searchManager_DataLoading(object sender, DataLoadingEventArgs e) { if (e.Cancel) { return; } if (!m_sm.UseStreamLoad) { this.StartLoadData(); } }
private void searchManager_DataLoading(object sender, DataLoadingEventArgs e) { if (e.Cancel) { return; } ISearchManager sm = sender as ISearchManager; if (progressForm == null) { progressForm = new ProgressForm(); progressForm.ProgressStopped += new EventHandler(progressForm_ProgressStopped); } System.Threading.Interlocked.Increment(ref m_progressDoings); if (!progressForm.IsActive) { progressForm.Start(this, "查找"); } }
void searchManager_DataLoading(object sender, DataLoadingEventArgs e) { if (e.Cancel) return; if (!m_sm.UseStreamLoad) { this.StartLoadData(); } }
private void dashboardViewer1_DataLoading(object sender, DataLoadingEventArgs e) { List <MyClass> list = CreateDataSource(); e.Data = list; }
private void dashboardViewerUniconta_AsyncDataLoading(object sender, DataLoadingEventArgs e) { try { var dashboard = _dashboard?.DataSources?.FirstOrDefault(x => x.ComponentName == e.DataSourceComponentName); var fixedComp = fixedCompanies?.FirstOrDefault(x => x.DatasourceName == e.DataSourceComponentName); var compId = fixedComp != null ? fixedComp.CompanyId : this.company.CompanyId; var typeofTable = GetTypeAssociatedWithDashBoardDataSource(e.DataSourceName, e.DataSourceComponentName, compId); if (typeofTable == null && dataSourceAndTypeMap.ContainsKey(e.DataSourceComponentName)) { typeofTable = dataSourceAndTypeMap[e.DataSourceComponentName]; } if (typeofTable != null) { if (dashboard != null) { UpdateServerFilter(e.DataSourceComponentName, typeofTable); if (lstOfFilters.ContainsKey(e.DataSourceComponentName)) { filterValues = lstOfFilters[e.DataSourceComponentName]; } else { filterValues = null; } if (!LoadOnOpen) { e.Data = Activator.CreateInstance(typeofTable); } else { if (dataSourceLoadingParams.Contains(e.DataSourceComponentName) && LoadOnOpen) { UnicontaBaseEntity[] data; if (fixedComp == null || this.company.CompanyId == fixedComp.CompanyId) { data = Query(typeofTable, api, filterValues).GetAwaiter().GetResult(); } else { var comp = CWDefaultCompany.loadedCompanies.FirstOrDefault(x => x.CompanyId == fixedComp.CompanyId); var compApi = new CrudAPI(BasePage.session, comp); data = Query(typeofTable, compApi, filterValues).GetAwaiter().GetResult(); } if (lstOfSorters != null && lstOfSorters.ContainsKey(e.DataSourceComponentName)) { Array.Sort(data.ToArray(), lstOfSorters[e.DataSourceComponentName]); } e.Data = data; } else { e.Data = Activator.CreateInstance(typeofTable); } } } if (TableContainLoginIdProp(typeofTable)) { var filter = "[" + UserIdPropName + "] =" + "'" + BasePage.session.LoginId + "'"; dashboard.Filter = filter; } } } catch (Exception ex) { MessageBox.Show(ex.Message, Uniconta.ClientTools.Localization.lookup("Exception")); } }
void smMaster_DataLoading(object sender, DataLoadingEventArgs e) { e.Cancel = true; ISearchExpression searchExpression = e.SearchExpression; IList<ISearchOrder> searchOrders = e.SearchOrders; ReportGenerator.SetParameter(this.ReportViewer.CrystalHelper, searchExpression); this.ReportViewer.OpenReport(); }
void smMaster_DataLoading(object sender, DataLoadingEventArgs e) { e.Cancel = true; ISearchExpression searchExpression = e.SearchExpression; IList<ISearchOrder> searchOrders = e.SearchOrders; if (this.SearchManager != null) { for (int i = 0; i < m_reportDataInfos.Count; ++i) { m_sms[i].EnablePage = this.SearchManager.EnablePage; m_sms[i].FirstResult = this.SearchManager.FirstResult; m_sms[i].MaxResult = this.SearchManager.MaxResult; m_sms[i].IsResultDistinct = this.SearchManager.IsResultDistinct; } } bool haveSetMasterSearchManager = false; for (int i = 0; i < m_reportDataInfos.Count; ++i) { object data = m_sms[i].GetData(searchExpression, searchOrders); System.Collections.IEnumerable dataList = data as System.Collections.IEnumerable; if (dataList == null) { dataList = (data as System.Data.DataTable).DefaultView; } System.Data.DataTable dt = this.ReportViewer.TemplateDataSet.Tables[m_reportDataInfos[i].DatasetTableName]; dt.Rows.Clear(); GenerateReportData.Generate(dt, dataList, m_reportDataInfos[i].GridName); if (!haveSetMasterSearchManager) { this.SearchManager.Count = m_sms[i].GetCount(searchExpression); haveSetMasterSearchManager = true; this.SearchManager.OnDataLoaded(new DataLoadedEventArgs(m_sms[i].Result, m_sms[i].Count)); } } // Set Parameter ReportGenerator.SetParameter(this.ReportViewer.CrystalHelper, searchExpression); if (m_reportInfo.AfterProcess != null) { ProcessInfoHelper.ExecuteProcess(ADInfoBll.Instance.GetProcessInfo(m_reportInfo.AfterProcess.Name), new Dictionary<string, object> { { "masterForm", this } }); } this.ReportViewer.OpenReport(); }