public RevenueLossOrchestrator(IRevenueLossService service, IExcelHelper excelHelper,
IOptions <AppSettings> appSettings)
{
this.service = service;
this.excelHelper = excelHelper;
this.appSettings = appSettings.Value;
}
public void CreateExcel(IQueryable query, IExcelHelper excelHelper)
{
//this model come from ui list requested model
if (query is IQueryable <DocumentInfoModel> q)
{
var list = q.ToList();
excelHelper.CreateExcel <DocumentInfoModel>("sheet1", list);
}
}
public MainController(SampleController sample
, WpfInteractionController wpfInteraction
, IExcelHelper helper
, IZenrinModule zenrin
, IIndustrialModule industrial)
{
Sample = sample;
WpfInteraction = wpfInteraction;
_Helper = helper;
_ZenrinModule = zenrin;
_IndustrialModule = industrial;
}
public ZenrinModule(IExcelHelper excelHelper)
{
_ExcelHelper = excelHelper;
}
public FileHandle()
{
_mapper = ServiceContext.Resolve <IMapper>();
_excelHelper = ServiceContext.Resolve <IExcelHelper>();
}
public CategoryRelativiesController(ICategoryRelativiesRepository categoryRelativiesRepository, IExcelHelper excelHelper)
{
_categoryRelativiesRepository = categoryRelativiesRepository;
_excelHelper = excelHelper;
}
public TransactionsController(ITransactionService transactionService, IExcelHelper excelHelper, ICSVHelper csvHelper)
{
_transactionService = transactionService;
_excelHelper = excelHelper;
_icsvHelper = csvHelper;
}
private void NewMethod(IExcelHelper excel, int row, int column, string sql)
{
string temp = "";
DataTable dt = odbc.ExecuteDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
excel.InsertCell("Sheet1", row, column, dt.Rows.Count.ToString());
}
temp += dt.Rows[i][0].ToString() + @" \ ";
if (i == dt.Rows.Count - 1)
{
excel.InsertCell("Sheet1", row, column + 1, temp);
}
}
}
public ExcelService(IStats stats, IExcelHelper excel, IDirectoryHelper directory)
{
_stats = stats;
_excel = excel;
_directory = directory;
}
/// <summary>
/// 设置具体算法
/// 通过接口编程+方法的注入的方式来保证程序的扩展性
/// </summary>
/// <param name="helper"></param>
public void SetImplementStrategy(IExcelHelper helper)
{
excelHelper = helper;
}
public ExcelFilterAction(IQueryHandler queryHandler, IExcelHelper excelHelper)
{
this._queryHandler = queryHandler;
this._excelHelper = excelHelper;
this._query = null;
}
public HomeController(ILogger <HomeController> logger, IConfiguration configuration, IExcelHelper excelHelper)
{
_logger = logger;
db = new KeremetDbContext(configuration["ConnectionString"]);
_excelHelper = excelHelper;
}
public CovidStatisticsEmailNotifier(ILogger <CovidStatisticsEmailNotifier> logger, IEmailSender emailSender, IExcelHelper excelHelper)
{
_logger = logger;
_emailSender = emailSender;
_excelHelper = excelHelper;
}