public InsideBillToExcel(DocInsideBill arg) { _templatePath = AppDomain.CurrentDomain.BaseDirectory + "\\Reports\\insideBillTemplate.xlt"; _docInsideBills = new List<DocInsideBill> {arg}; }
private void SetValues(DocInsideBill arg) { FindAndReplace("$FROM", arg.From.Name); FindAndReplace("$TO", arg.To.Name); Excel.Range range = _excelApp.Range["CD16", "CD16"]; range.Value = arg.Number; range = _excelApp.Range["CT16", "CT16"]; range.Value = arg.RegDate.Date; for (int i = 0; i < _docInsideBills.Count; ++i) { range = _excelApp.Range["B22", "B22"]; range.Value = (i + 1); range = _excelApp.Range["J22", "J22"]; range.Value = _docInsideBills[i].Inventory.Name; range = _excelApp.Range["BS22", "BS22"]; range.Value = _docInsideBills[i].Inventory.Number; range = _excelApp.Range["CK22", "CK22"]; range.Value = 1; if (i < _docInsideBills.Count - 1) AddInventoryRow(); } }
public void MockExport() { var docMock = new DocInsideBill { Inventory = _docInventory.Find(1), From = _otdelMapper.Find(1), To = _otdelMapper.Find(2), Number = "821/1", RegDate = DateTime.Now, LastUpdate = DateTime.Now }; docMock.Inventory.Name = "Супер-пупер компьютер + сканер и прочая дребедень"; var doc = new InsideBillToExcel(docMock); doc.Export(); }