public void ExportReportsToExcel()
{
List <TransactionReport> reports = TestDataFactory.GetMonthReports();
ExcelOutput excel = new ExcelOutput();
excel.InsertReportToNewSheet(reports, null);
}
/// <summary>
/// 导出SAP订单工艺及外协信息到Excel文件，并返回文件Token
/// </summary>
public async Task <FileDto> GetSapOrderProcessWithCooperaterExcel(GetSapOrderProcessWithCooperaterInput input)
{
var processList = await this.getSapOrderProcessWithCooperQuery(input).ToListAsync();
var resultList = processList.Select(this.mapToSapProcessOutput).ToList();
var fileStream = ExcelOutput.RenderToStream(resultList, new Dictionary <string, DataTableExtension.PropertyConventer>
{
//订单
{ "OrderNumber", new DataTableExtension.PropertyConventer("订单号", null) },
{ "MRPController", new DataTableExtension.PropertyConventer("MRP控制者", null) },
{ "MaterialNumber", new DataTableExtension.PropertyConventer("物料编码", null) },
{ "MaterialDescription", new DataTableExtension.PropertyConventer("物料名称", null) },
{ "TargetQuantity", new DataTableExtension.PropertyConventer("订单总计数量", null) },
{ "WBSElement", new DataTableExtension.PropertyConventer("WBS元素", null) },
//工艺
{ "OperationNumber", new DataTableExtension.PropertyConventer("工序号", null) },
{ "OperationCtrlCode", new DataTableExtension.PropertyConventer("控制码", null) },
{ "WorkCenterCode", new DataTableExtension.PropertyConventer("工作中心", null) },
{ "WorkCenterName", new DataTableExtension.PropertyConventer("工作中心描述", null) },
{ "VGW01", new DataTableExtension.PropertyConventer("准备工时", null) },
{ "VGW02", new DataTableExtension.PropertyConventer("机器工时", null) },
{ "VGW03", new DataTableExtension.PropertyConventer("人工工时", null) },
//外协
{ "CooperateType", new DataTableExtension.PropertyConventer("外协类型", p => ((int?)(SapMOrderProcessCooperateType?)p)?.ToString()) },
{ "CooperaterCode", new DataTableExtension.PropertyConventer("供方代码", null) },
{ "CooperaterName", new DataTableExtension.PropertyConventer("供方名称", null) },
{ "CooperaterPrice", new DataTableExtension.PropertyConventer("外协价格", null) },
});
return(this.SaveToTempFolder(fileStream, "SAP工艺列表.xlsx", "application/x-excel"));
}
public void ExportSingleReportToExcel()
{
List <TransactionReport> reports = TestDataFactory.GetMonthReports();
List <TransactionReport> single = reports.GetRange(3, 1);
ExcelOutput excel = new ExcelOutput();
excel.InsertReportToNewSheet(single, null);
}
public void RefreshPivotTable()
{
ExcelOutput excel = new ExcelOutput();
RefreshPivotTableAction.Data actionData = new RefreshPivotTableAction.Data {
Excel = excel
};
RefreshPivotTableAction action = new RefreshPivotTableAction();
action.Execute(actionData);
}
public void AttachPivotTable()
{
ExcelOutput excel = new ExcelOutput();
InsertPivotTableAction.Data actionData = new InsertPivotTableAction.Data {
Excel = excel
};
InsertPivotTableAction action = new InsertPivotTableAction();
action.Execute(actionData);
}
public static IViewData GetViewDataController(string outputMedia, string operation, string study)
{
IViewData viewData = null;
switch (outputMedia)
{
case "Excel":
viewData = new ExcelOutput(operation, study);
break;
case "Spotfire":
viewData = new SpotfireOutput(operation, study);
break;
}
return viewData;
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
EventAggregator eventAggregator = new EventAggregator();
FormReportMain reportForm = new FormReportMain(eventAggregator, null);
OutputLogger logger = new OutputLogger();
ExcelOutput excelOutput = new ExcelOutput(eventAggregator, logger);
excelOutput.Connect();
ImportImpl import = new ImportImpl();
IFileDialog fileDialog = new WinFormDialog();
var categoryJsonSerializer = new JsonSerializer <CategoryCollection>();
var categoryFileSerializer = new FileSerializer <CategoryCollection>(categoryJsonSerializer);
var optionsJsonSerializer = new JsonSerializer <Options>();
var optionsFileSerializer = new FileSerializer <Options>(optionsJsonSerializer);
TransactionReportCollection reports = new TransactionReportCollection();
var reportsJsonSerializer = new JsonSerializer <TransactionReportCollection>();
var reportsFileSerializer = new FileSerializer <TransactionReportCollection>(reportsJsonSerializer);
Options options = new Options()
{
CategoryPath = @"..\..\..\Budget.UnitTests\Resources\categories_new_16.bgt"/*,
* DocumentPath = @"..\..\..\Budget.UnitTests\Resources\Raport_Listopad_2016.rpt"*/
};
IBudgetRepository fileData = new BudgetRepository();
fileData.Categories = new FileRepository <CategoryCollection>(categoryFileSerializer, fileDialog);
fileData.Options = new FileRepository <Options>(options, optionsFileSerializer, fileDialog);
fileData.Reports = new FileRepository <TransactionReportCollection>(reports, reportsFileSerializer,
fileDialog);
AppEngine engine = new AppEngine(excelOutput, eventAggregator, reportForm, import, fileData);
Application.Run(reportForm);
}
public void ParseExcelTransactions()
{
ExcelOutput excel = new ExcelOutput();
excel.Connect();
List <string> names = excel.GetSheetNames();
List <string> checkedNames = names.First().AsList();
if (false)
{
WinFormDialog dialog = new WinFormDialog();
SelectEntitiesDialogOptions options = new SelectEntitiesDialogOptions()
{
Caption = "Arkusze",
Description = "Wybierz arkusze",
Options = names,
Checked = checkedNames
};
List <string> selectedNames;
bool isOk = dialog.ShowSelectEntitiesDialog(options, out selectedNames);
if (!isOk)
{
return;
}
}
List <ITransactionParser> parsers = new List <ITransactionParser>();
parsers.Add(new ExcelSheetParser());
GetExcelTransactionsAction.Data getExcelData = new GetExcelTransactionsAction.Data()
{
SheetFileNames = checkedNames,
Excel = excel,
Parsers = parsers
};
GetExcelTransactionsAction getExcelAction = new GetExcelTransactionsAction();
GetTransactionsAction.Result result = getExcelAction.Execute(getExcelData);
}
public ExcelTable()
{
// create new excel-application and so on..
//initialize xlWorkbook and xlWorksheet
Output = new ExcelOutput(xlWorkbook, xlWorksheet);
}
