public EnviarPontoInteractor(IPontoRepository pontoRepository, IExcelService excelService, IPlanilhaRepository planilhaRepository, IADService aDService)
{
_pontoRepository = pontoRepository;
_excelService = excelService;
_planilhaRepository = planilhaRepository;
_aDService = aDService;
}
public CompanyController(ICompanyService companyService, IExcelService excelService, IRightService rightService, IStateProvinceService stateProvinceService)
{
_companyService = companyService;
_excelService = excelService;
_rightService = rightService;
_stateProvinceService = stateProvinceService;
}
public ProjectTasksController(
IMapper mapper,
IProjectTaskRepository projectTaskRepository,
IProjectRepository projectRepository,
IProjectTaskTypeRepository projectTaskTypeRepository,
ITaskTypeRepository taskTypeRepository,
IProjectTaskStatusRepository projectTaskStatusRepository,
IProjectTaskPerformerRepository projectTaskPerformerRepository,
IGroupRepository groupRepository,
IUserRepository userRepository,
IBlockRepository blockRepository,
IUserService userService,
IMailRepository mailRepository,
IExcelService excelService)
{
_mapper = mapper;
_projectTaskRepository = projectTaskRepository;
_projectRepository = projectRepository;
_projectTaskTypeRepository = projectTaskTypeRepository;
_taskTypeRepository = taskTypeRepository;
_projectTaskStatusRepository = projectTaskStatusRepository;
_projectTaskPerformerRepository = projectTaskPerformerRepository;
_groupRepository = groupRepository;
_userRepository = userRepository;
_userService = userService;
_blockRepository = blockRepository;
_excelService = excelService;
_mailRepository = mailRepository;
}
public HomeController(
IPermissionService permissionService,
IWorkContext workContext,
ITreatmentRecordServices TreatmentRecordServices,
ITreatmentServices TreatmentServices,
IReportService ReportService,
IEncryptionService encryptionService,
INurseServices NurseServices,
IHospitalServices HospitalServices,
ICompanyProfileService CompanyProfileService,
IAppointmentServices AppointmentServices,
IExcelService excelService
)
{
this._permissionService = permissionService;
this._treatmentRecordServices = TreatmentRecordServices;
this._treatmentServices = TreatmentServices;
this._workContext = workContext;
this._reportService = ReportService;
this._encryptionService = encryptionService;
this._nurseServices = NurseServices;
this._hospitalServices = HospitalServices;
this._appointmentServices = AppointmentServices;
this._companyProfileService = CompanyProfileService;
this.excelService = excelService;
}
public GeneratorService(IEProtecAPIService eProtecAPIService, ISettingsService settingsService, IExcelService excelService, IPdfService pdfService)
{
_eProtecAPIService = eProtecAPIService ?? throw new ArgumentNullException(nameof(eProtecAPIService));
_settingsService = settingsService ?? throw new ArgumentNullException(nameof(settingsService));
_excelService = excelService ?? throw new ArgumentNullException(nameof(excelService));
_pdfService = pdfService ?? throw new ArgumentNullException(nameof(pdfService));
}
public HomeController(IIntervalDataRepository intervalDataRepository, IOptions <AppSettings> appSettings, ILogger <HomeController> logger, IExcelService excelService)
{
_intervalRepository = intervalDataRepository;
_logger = logger;
_excelService = excelService;
_settings = appSettings;
}
public RealEstateListViewModel(IRealEstateService <T> service, IMessageService messageService,
IDistrictService districtService, IRealtorService realtorService,
IOwnershipService ownershipService, IDealVariantService dealVariantService,
IConditionService conditionService,
IExcelService excelService, IWordService wordService, IServiceLocator serviceLocator)
{
_RealEstateService = service;
_MessageService = messageService;
_DistrictService = districtService;
_RealtorService = realtorService;
_OwnershipService = ownershipService;
_DealVariantService = dealVariantService;
_ConditionService = conditionService;
_ServiceLocator = serviceLocator;
_excelService = excelService;
_wordService = wordService;
AddCommand = new DelegateCommand(Add);
ChangeCommand = new DelegateCommand(Change);
DeleteCommand = new DelegateCommand(Delete);
UpdateCommand = new DelegateCommand(Update);
ClearFilterCommand = new DelegateCommand(ClearFilter);
ApplyFilterCommand = new DelegateCommand(ApplyFilter);
ExportToExcelCommand = new DelegateCommand(ExportToExcel);
ExportToWordCommand = new DelegateCommand(ExportToWord);
ExportToWordSelectedCommand = new DelegateCommand(ExportToWordSelected);
ChangeInGridCommand = new DelegateCommand <RealEstateViewModel <T> >(ChangeInGrid);
DeleteInGridCommand = new DelegateCommand <RealEstateViewModel <T> >(DeleteInGrid);
SelectedEntities = new List <RealEstateViewModel <T> >();
}
public ExcelController(ISqlConnectionService dbContext, IExcelService excelService, IConfigurationRoot configuration)
{
_dbContext = dbContext;
_excelService = excelService;
_path = configuration["ExcelPath"];
_procedureName = configuration["ProcedureName"];
}
public void ReadExcelTest()
{
excelService = Mvx.IoCProvider.Resolve <IExcelService>();
var assembly = Assembly.GetExecutingAssembly();
string resourceName = assembly.GetManifestResourceNames()
.Single(str => str.EndsWith("Klasse3a.xlsx"));
using (Stream stream = assembly.GetManifestResourceStream(resourceName))
{
excelService.OpenFile(stream);
}
excelService.ReadTables();
mathe = excelService.GetMathe();
deutsch = excelService.GetDeutsch();
sachkunde = excelService.GetSachkunde();
englisch = excelService.GetEnglisch();
kunst = excelService.GetKunst();
werken = excelService.GetWerken();
musik = excelService.GetMusik();
sport = excelService.GetSport();
ethik = excelService.GetEthik();
religion = excelService.GetReligion();
gesamtHj = excelService.GetGesamtHj();
gesamtEj = excelService.GetGesamtEj();
lehrer = excelService.GetLehrer();
}
/// <summary>
/// 将回路数据写入指定的EXCEL工作表
/// </summary>
/// <param name="excelService"></param>
/// <param name="models"></param>
/// <param name="sheetName"></param>
/// <returns></returns>
public bool ExportLoopDataToExcel(ref IExcelService excelService, List <LoopModel> models, string sheetName)
{
try
{
if (models.Count > 0)
{
IControllerConfig config = ControllerConfigManager.GetConfigObject(ControllerType.FT8000);
ColumnConfigInfo[] deviceColumnDefinitionArray = config.GetDeviceColumns(); //取得器件的列定义信息
List <MergeCellRange> lstMergeCellRange = new List <MergeCellRange>();
int startRowIndex = 0;
int currentRowIndex = 0;
foreach (var loop in models)
{
startRowIndex = currentRowIndex;
currentRowIndex++;
//回路标题
excelService.SetCellValue(sheetName, startRowIndex, 0, "回路:" + loop.Name, CellStyleType.SubCaption);
for (int devColumnCount = 0; devColumnCount < deviceColumnDefinitionArray.Length; devColumnCount++)
{
excelService.SetCellValue(sheetName, currentRowIndex, devColumnCount, deviceColumnDefinitionArray[devColumnCount].ColumnName, CellStyleType.TableHead);
}
//回路标题行合并
MergeCellRange mergeCellRange = new MergeCellRange();
mergeCellRange.FirstRowIndex = startRowIndex;
mergeCellRange.LastRowIndex = startRowIndex;
mergeCellRange.FirstColumnIndex = 0;
mergeCellRange.LastColumnIndex = deviceColumnDefinitionArray.Length - 1;
lstMergeCellRange.Add(mergeCellRange);
//写入器件信息
foreach (var device in loop.GetDevices <DeviceInfo8000>())
{
currentRowIndex++;
excelService.SetCellValue(sheetName, currentRowIndex, 0, device.Code, CellStyleType.Data); //器件编码
excelService.SetCellValue(sheetName, currentRowIndex, 1, config.GetDeviceTypeViaDeviceCode(device.TypeCode).Name, CellStyleType.Data); //器件类型
excelService.SetCellValue(sheetName, currentRowIndex, 2, device.Feature == null?null:device.Feature.ToString(), CellStyleType.Data); //特性
excelService.SetCellValue(sheetName, currentRowIndex, 3, device.Disable == null?null:device.Disable.ToString(), CellStyleType.Data); //屏蔽
excelService.SetCellValue(sheetName, currentRowIndex, 4, device.SensitiveLevel == null?null:device.SensitiveLevel.ToString(), CellStyleType.Data); //灵敏度
excelService.SetCellValue(sheetName, currentRowIndex, 5, device.LinkageGroup1, CellStyleType.Data); //输出组1
excelService.SetCellValue(sheetName, currentRowIndex, 6, device.LinkageGroup2, CellStyleType.Data); //输出组2
excelService.SetCellValue(sheetName, currentRowIndex, 7, device.LinkageGroup3, CellStyleType.Data); //输出组3
excelService.SetCellValue(sheetName, currentRowIndex, 8, device.DelayValue == null?null:device.DelayValue.ToString(), CellStyleType.Data); //延时
excelService.SetCellValue(sheetName, currentRowIndex, 9, device.sdpKey, CellStyleType.Data); //手操号
excelService.SetCellValue(sheetName, currentRowIndex, 10, device.ZoneNo == null?null:device.ZoneNo.ToString(), CellStyleType.Data); //分区
excelService.SetCellValue(sheetName, currentRowIndex, 11, device.BroadcastZone, CellStyleType.Data); //广播分区
excelService.SetCellValue(sheetName, currentRowIndex, 12, device.Location, CellStyleType.Data); //安装地点
}
currentRowIndex++;
}
excelService.SetMergeCells(sheetName, lstMergeCellRange);//设置"回路页签"合并单元格
excelService.SetColumnWidth(sheetName, 1, 15f);
excelService.SetColumnWidth(sheetName, 12, 50f);
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public ExportProductsQueryHandler(IExcelService excelService
, IUnitOfWork <int> unitOfWork
, IStringLocalizer <ExportProductsQueryHandler> localizer)
{
_excelService = excelService;
_unitOfWork = unitOfWork;
_localizer = localizer;
}
public AdminController(IUnitOfWork unitOfWork, UserManager <AppUser> userManager, IExcelService excelService,
IMapper mapper)
{
_unitOfWork = unitOfWork;
_userManager = userManager;
_excelService = excelService;
_mapper = mapper;
}
public ProductCategoryService(IProductCategoryRepository productCategoryRepository, ISupplierService supplierService,
IExcelService <ProductCategoryResponseModel> excelService, INotificationService notificationService)
{
_productCategoryRepository = productCategoryRepository;
_supplierService = supplierService;
_excelService = excelService;
_notificationService = notificationService;
}
public ReportController(
IReportService reportService,
IExcelService excelService
)
{
_excelService = excelService;
_reportService = reportService;
}
public ImportacaoAssociadosAppService(
IUnitOfWork unitOfWork,
IExcelService excelService,
IMapper mapper,
IImportacaoServiceConfiguration importacaoConfiguration,
IProgressoImportacaoEvent progressoEvent) : base(unitOfWork, excelService, mapper, importacaoConfiguration, progressoEvent)
{
}
public static IExcelService GetInstance()
{
if (INSTANCE == null)
{
INSTANCE = new ExcelServiceImpl();
}
return(INSTANCE);
}
public ExportExtendedAttributesQueryHandler(IExcelService excelService
, IUnitOfWork <TId> unitOfWork
, IStringLocalizer <ExportExtendedAttributesQueryLocalization> localizer)
{
_excelService = excelService;
_unitOfWork = unitOfWork;
_localizer = localizer;
}
public ClassroomController(IClassroomService classroomService
, IExcelService excelService
, IClassroomTypeService classroomTypeService)
{
_classroomService = classroomService;
_excelService = excelService;
_classroomTypeService = classroomTypeService;
}
/// <summary>
/// 注入
/// </summary>
/// <param name="TestService"></param>
/// <param name="httpContext"></param>
/// <param name="sendService"></param>
/// <param name="BaseService"></param>
/// <param name="excelService"></param>
public LoginController(ITestService TestService, IHttpContextAccessor httpContext, ISendService sendService, IEFBaseService BaseService, IExcelService excelService)
{
this._TestService = TestService;
this._httpContext = httpContext;
this._SendService = sendService;
this._BaseService = BaseService;
this._excelService = excelService;
}
public EventController(IEventService eventService
, IExcelService excelService
, IGameService gameService)
{
_eventService = eventService;
_excelService = excelService;
_gameService = gameService;
}
public WareHouseController(IConfiguration config, IWebHostEnvironment webHostEnvironment, ILogger <WareHouseController> logger, IWarehouseDAO warehouseDao, ISamPartBDAO samPartBDAO,
IExcelService excelService)
: base(config, webHostEnvironment, logger)
{
_excelService = excelService;
_warehouseDao = warehouseDao;
_samPartBDAO = samPartBDAO;
}
public ProductLineServiceTest()
{
_productLineRepository = Substitute.For <IProductLineRepository>();
_productCategoryService = Substitute.For <IProductCategoryService>();
_excelService = Substitute.For <IExcelService <ProductLineResponseModel> >();
_notificationContext = Substitute.For <INotificationService>();
_productLineService = new ProductLineService(_productLineRepository, _productCategoryService, _excelService, _notificationContext);
}
public TeamController(ITeamService teamService
, IExcelService excelService
, IGameService gameService)
{
_teamService = teamService;
_excelService = excelService;
_gameService = gameService;
}
public ProductCategoryServicesTests()
{
_productRepository = Substitute.For <IProductCategoryRepository>();
_supplierService = Substitute.For <ISupplierService>();
_excelService = Substitute.For <IExcelService <ProductCategoryResponseModel> >();
_notificationService = Substitute.For <INotificationService>();
_productService = new ProductCategoryService(_productRepository, _supplierService, _excelService, _notificationService);
}
public AttendeesController(IAttendeeService attendeeService,
IAgencyService agencyService,
IExcelService excelService)
{
_attendeeService = attendeeService;
_agencyService = agencyService;
_excelService = excelService;
}
public FundingSummaryReport(IFundingSummaryReportBuilder builder, IStreamProviderService streamProviderService, ILogger logger, IExcelService excelService, IFilenameService filenameService)
{
_builder = builder;
_streamProviderService = streamProviderService;
_logger = logger;
_excelService = excelService;
_filenameService = filenameService;
}
public PlmController(IConfiguration config, IWebHostEnvironment webHostEnvironment, ILogger <WareHouseController> logger,
IDevPlmPartDAO devPlmPartDAO, IDKSDAO dksDao,
IExcelService excelService)
: base(config, webHostEnvironment, logger)
{
_excelService = excelService;
_devPlmPartDAO = devPlmPartDAO;
_dksDao = dksDao;
}
private FundingSummaryReport NewService(
IFundingSummaryReportBuilder builder = null,
IStreamProviderService streamProviderService = null,
ILogger logger = null,
IExcelService excelService = null,
IFilenameService filenameService = null)
{
return(new FundingSummaryReport(builder, streamProviderService, logger, excelService, filenameService));
}
public HouseListViewModel(IHouseService service, IMessageService messageService,
IDistrictService districtService, IRealtorService realtorService,
IOwnershipService ownershipService, IDealVariantService dealVariantService, IConditionService conditionService,
IExcelService excelService, IWordService wordService,
IServiceLocator serviceLocator)
: base(service, messageService, districtService, realtorService, ownershipService, dealVariantService, conditionService, excelService,
wordService, serviceLocator)
{
}
public GeneratorService(DatabaseContext context, IMapper mapper, IUtilsService utils, ILoggerService logger, IExcelService excelService, IPDFService pdfService)
{
this._context = context;
this._mapper = mapper;
this._utils = utils;
this._logger = logger;
this._excelService = excelService;
this._pdfService = pdfService;
}
public MainPageViewModel()
{
_employeeService = new EmployeeService();
_excelService = new ExcelService();
_rootPasswordService = new RootPasswordService();
Employees = new ObservableCollection <Employee>();
GetEmployee();
}
public void ExportBibleNotesToExcel(
BackupFile backupFile, string bibleNotesExportFilePath, IExcelService excelService)
{
File.Delete(bibleNotesExportFilePath);
if (File.Exists(bibleNotesExportFilePath))
{
throw new BackupFileServicesException(
$"Could not delete existing Excel file: {bibleNotesExportFilePath}");
}
var notesToWrite = new List <ExcelServices.Models.BibleNote>();
var tags = backupFile.Database.TagMaps.Where(x => x.NoteId != null).ToLookup(map => map.NoteId, map => map);
foreach (var note in backupFile.Database.Notes)
{
if (note.LocationId == null)
{
continue;
}
var location = backupFile.Database.FindLocation(note.LocationId.Value);
if (location?.BookNumber == null)
{
continue;
}
int?colorCode = null;
if (note.UserMarkId != null)
{
var userMark = backupFile.Database.FindUserMark(note.UserMarkId.Value);
if (userMark != null)
{
colorCode = userMark.ColorIndex;
}
}
notesToWrite.Add(new ExcelServices.Models.BibleNote
{
BookNumber = location.BookNumber.Value,
BookName = BibleBookNames.GetName(location.BookNumber.Value),
ChapterNumber = location.ChapterNumber,
VerseNumber = note.BlockIdentifier,
NoteTitle = note.Title?.Trim(),
NoteContent = note.Content?.Trim(),
PubSymbol = location.KeySymbol,
ColorCode = colorCode,
TagsCsv = GetTagsAsCsv(tags, note.NoteId, backupFile.Database),
});
}
notesToWrite.Sort(SortBibleNotes);
excelService.AppendToBibleNotesFile(bibleNotesExportFilePath, notesToWrite, 0, bibleNotesExportFilePath);
}
public RoundController(IRoundService roundService
, IExcelService excelService
, IMatchService matchService
, ITeamService teamService)
{
_roundService = roundService;
_excelService = excelService;
_matchService = matchService;
_teamService = teamService;
}
public MainWindow()
{
InitializeComponent();
this.excelService = ExcelServiceImpl.GetInstance();
this.databaseService = DatabaseServiceImpl.GetInstance();
this.checkService = CheckServiceImpl.GetInstance();
this.listBox_log.ItemsSource = this.logList;
}
public TeamBetTeamXController(ITeamBetTeamXService teambetteamxService
, IExcelService excelService
, IBetTeamService betTeamService
, ITeamService teamService)
{
_teambetteamxService = teambetteamxService;
_excelService = excelService;
_betTeamService = betTeamService;
_teamService = teamService;
}
public Form1(ISharepointService sharepointService, IExcelService excelService)
{
_sharepointService = sharepointService;
_excelService = excelService;
InitializeComponent();
txtSite.TextChanged += ChangeGuiState;
cbList.SelectedIndexChanged += ChangeGuiState;
Shown += ChangeGuiState;
}
public ImportSectionViewModel(IExcelService excelService)
{
DisplayName = "Import";
Order = 50;
context = new GenesisContext();
this.excelService = excelService;
Sheets = new ObservableCollection<string>();
Columns = new ObservableCollection<ColumnViewModel>();
}
public UserController(
ICompanyService companyService
, IExcelService excelService
, IRightService rightService
, IRoleService roleService
, IUserService userService
, ICacheProvider cacheService
)
{
_companyService = companyService;
_excelService = excelService;
_rightService = rightService;
_roleService = roleService;
_userService = userService;
_cacheService = cacheService;
}
public UserLogController(IExcelService excelService, IRightService rightService, IUserLogService userLogService)
{
_excelService = excelService;
_rightService = rightService;
_userLogService = userLogService;
}
public AssetsExporter()
{
_excelService = new AvevaExcelService();
_ftpSender = new AvevaFTPSender();
}
public SystemLoggingController(IExcelService excelService, ILoggingService loggingService, IRightService rightService)
{
_excelService = excelService;
_loggingService = loggingService;
_rightService = rightService;
}
public ScenarioExporter()
{
_excelService = new AvevaExcelService();
_ftpSender = new AvevaFTPSender();
}
public TimeRegistrationModule(IProjectRepository projectRepository,
IClientRepository clientRepository,
ITimeRegistrationRepository timeRegistrationRepository,
IIdGenerator idGenerator,
IAggregateRootRepository aggregateRootRepository,
IRootPathProvider rootPathProvider,
IExcelService excelService)
: base("/timeregistration")
{
this.RequiresAuthentication();
Get["/"] = _ => View["Index"];
Get["/overview"] = _ => View["Overview"];
Get["/report"] = _ => View["Report"];
Get["/import"] = _ => View["Import"];
Post["/importupload"] = _ =>
{
var fileName = Guid.NewGuid().ToString("N").Substring(0, 4) + "_" + Path.GetFileName((string)Request.Files.First().Name);
var path = Path.Combine(rootPathProvider.GetRootPath(), "App_Data", "Uploads", fileName);
using (var fileStream = new FileStream(path, FileMode.Create))
{
Request.Files.First().Value.CopyTo(fileStream);
}
return Response.AsRedirect("~/timeregistration/importmap/" + HttpUtility.UrlEncode(fileName));
};
Get["/importmap/{url*}"] = parameters =>
{
var viewModel = new ImportViewModel();
viewModel.ServerFile = Path.Combine(rootPathProvider.GetRootPath(), "App_Data", "Uploads", parameters.url);
var excelPackage = new ExcelPackage(new FileInfo(viewModel.ServerFile));
var worksheet = excelPackage.Workbook.Worksheets.First();
viewModel.ColumnNames = new List<ImportViewModel.ColumnInfo>();
foreach (var firstRowCell in worksheet.Cells[worksheet.Dimension.Start.Row, worksheet.Dimension.Start.Column, 1, worksheet.Dimension.End.Column])
viewModel.ColumnNames.Add(new ImportViewModel.ColumnInfo { Column = firstRowCell.Start.Column, Name = firstRowCell.Text });
return View["ImportMap", viewModel];
};
Post["/import"] = _ =>
{
var viewModel = this.Bind<ImportViewModel>();
var result = excelService.Import(viewModel.ServerFile, viewModel.ProjectIdColumn, viewModel.TaskColumn,
viewModel.DateColumn, viewModel.FromColumn, viewModel.ToColumn,
viewModel.RateColumn, viewModel.DescriptionColumn);
return View["ImportResult", result];
};
Get["/export/{fromDate}/{toDate}"] = parameters =>
{
var min = ((DateTime)parameters.fromDate).GetNumericValue();
var max = ((DateTime)parameters.toDate).AddDays(1).GetNumericValue();
var items = timeRegistrationRepository
.Where(t => t.Date.Numeric >= min && t.Date.Numeric < max)
.OrderBy(t => t.Date.Numeric)
.ThenBy(t => t.From.Numeric)
.ToList();
return Response.AsExcel(items);
};
}
public SurveyController(ICeremonyService ceremonyService, IExcelService excelService)
{
_ceremonyService = ceremonyService;
_excelService = excelService;
}
public RightController(IExcelService excelService, IRightService rightService, ICacheProvider cacheService)
{
_excelService = excelService;
_rightService = rightService;
_cacheService = cacheService;
}
public CultureController(ICultureService cultureService, IExcelService excelService, IRightService rightService)
{
_cultureService = cultureService;
_excelService = excelService;
_rightService = rightService;
}
protected ExcelTests(string fileName, IExcelService excelService)
{
_fileName = fileName;
ExcelService = excelService;
}
public MainViewModel(
IDragDropService dragDropService,
IBackupFileService backupFileService,
IWindowService windowService,
IFileOpenSaveService fileOpenSaveService,
IDialogService dialogService,
ISnackbarService snackbarService,
IExcelService excelService)
{
_dragDropService = dragDropService;
_backupFileService = backupFileService;
_windowService = windowService;
_fileOpenSaveService = fileOpenSaveService;
_dialogService = dialogService;
_snackbarService = snackbarService;
_excelService = excelService;
Files.CollectionChanged += FilesCollectionChanged;
SetTitle();
// subscriptions...
WeakReferenceMessenger.Default.Register <DragOverMessage>(this, OnDragOver);
WeakReferenceMessenger.Default.Register <DragDropMessage>(this, OnDragDrop);
WeakReferenceMessenger.Default.Register <MainWindowClosingMessage>(this, OnMainWindowClosing);
AddDesignTimeItems();
InitCommands();
GetVersionData();
}
