/// <summary> /// Справка за доказателства в ексел /// </summary> /// <param name="courtId"></param> /// <param name="model"></param> /// <returns></returns> public byte[] CaseEvidenceSpr_ToExcel(int courtId, CaseEvidenceSprFilterVM model) { var caseEvidenceSprs = CaseEvidenceSpr(courtId, model).OrderBy(x => x.DateAccept).ToList(); var htmlTemplate = repo.AllReadonly <HtmlTemplate>() .Where(x => x.Alias.ToUpper() == "Evidence".ToUpper()) .FirstOrDefault(); NPoiExcelService excelService = new NPoiExcelService(htmlTemplate.Content, 0); excelService.rowIndex = (htmlTemplate.XlsDataRow ?? 0) - 1; excelService.InsertList( caseEvidenceSprs, new List <Expression <Func <CaseEvidenceSprVM, object> > >() { x => x.RegNumber, x => x.DateAccept, x => x.FileNumber, x => x.CaseGroupLabel, x => x.CaseNumber, x => x.NamePodsydim, x => x.Description, x => x.MovementsDateSend, x => x.MovementsDateReceive, x => x.Movements } ); return(excelService.ToArray()); }