private void RevealView1_DataSourcesRequested(
object sender, DataSourcesRequestedEventArgs e)
{
List <object> datasources = new List <object>();
List <object> datasourceItems = new List <object>();
// インメモリデータがデータソースの場合
var inMemoryDSI1 = new RVInMemoryDataSourceItem("SalesRecords");
inMemoryDSI1.Title = "案件情報";
inMemoryDSI1.Description = "SalesRecords";
datasourceItems.Add(inMemoryDSI1);
var inMemoryDSI2 = new RVInMemoryDataSourceItem(
"SalesAmountByProductData");
inMemoryDSI2.Title = "商品別_売上合計";
inMemoryDSI2.Description = "SalesAmountByProductData";
datasourceItems.Add(inMemoryDSI2);
var inMemoryDSI3 = new RVInMemoryDataSourceItem("Top30LargeDeals");
inMemoryDSI3.Title = "大規模案件_Top30";
inMemoryDSI3.Description = "Top30LargeDeals";
datasourceItems.Add(inMemoryDSI3);
var inMemoryDSI4 = new RVInMemoryDataSourceItem("MonthlySalesAmount");
inMemoryDSI4.Title = "月別_売上合計";
inMemoryDSI4.Description = "MonthlySalesAmount";
datasourceItems.Add(inMemoryDSI4);
// Excelファイルがデータソースの場合
RVLocalFileDataSourceItem localExcelDatasource = new RVLocalFileDataSourceItem();
localExcelDatasource.Uri = "local:/SampleData.xlsx";
RVExcelDataSourceItem excelDatasourceItem = new RVExcelDataSourceItem(localExcelDatasource);
excelDatasourceItem.Title = "Excelデータ";
datasourceItems.Add(excelDatasourceItem);
// CSVファイルがデータソースの場合
RVLocalFileDataSourceItem localCsvDatasource = new RVLocalFileDataSourceItem();
localCsvDatasource.Uri = "local:/SampleData.csv";
RVExcelDataSourceItem csvDatasourceItem = new RVExcelDataSourceItem(localCsvDatasource);
csvDatasourceItem.Title = "CSVデータ";
datasourceItems.Add(csvDatasourceItem);
e.Callback(new RevealDataSources(
null,
datasourceItems,
false));
}
private RVDataSourceItem CreateLocalSamplesDataSourceItem(RVDataSourceItem dataSourceItem)
{
if (dataSourceItem is RVExcelDataSourceItem excelItem)
{
var localItem = new RVLocalFileDataSourceItem();
localItem.Uri = "local:/Samples.xlsx";
excelItem.ResourceItem = localItem;
return(excelItem);
}
return(dataSourceItem);
}
private RVDataSourceItem ChangeDataSourceItem(RVDataSourceItem dataSourceItem)
{
var excelItem = dataSourceItem as RVExcelDataSourceItem;
var wrItem = excelItem?.ResourceItem as RVWebResourceDataSourceItem;
if (wrItem != null && wrItem.Url.EndsWith("Samples.xlsx"))
{
var localItem = new RVLocalFileDataSourceItem();
localItem.Uri = "local:/Marketing.xlsx";
excelItem.ResourceItem = localItem;
return(excelItem);
}
else
{
return(null);
}
}
