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();
}
