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