private void ReadBody()
{
int i = (_invoice.IsRub) ? 12 : 11; //первая строка с данными
int incement = (_invoice.IsRub) ? 7 : 4;
int readBlocks = 0;
int countBlocks = GetCountBlocks();
while (readBlocks < countBlocks)
{
currentCell = (_invoice.IsRub) ? "Q" + i : "D" + i;
while (_excelBook.getValue(currentCell, currentCell) != null)
{
DCRow dcRow = new DCRow();
currentCell = (_invoice.IsRub) ? "Q" + i : "D" + i; //№ документа
dcRow.SetNumber(_excelBook.getValue(currentCell, currentCell));
currentCell = (_invoice.IsRub) ? "F" + i : "E" + i; //Счёт дебет
dcRow.SetOrdp(_excelBook.getValue(currentCell, currentCell));
currentCell = (_invoice.IsRub) ? "J" + i : "G" + i; //Счёт кредит
dcRow.SetBenm(_excelBook.getValue(currentCell, currentCell));
currentCell = (_invoice.IsRub) ? "AA" + i : "Y" + i; //Назначение платежа
dcRow.SetCom(_excelBook.getValue(currentCell, currentCell));
currentCell = (_invoice.IsRub) ? "L" + i : "I" + i; //Сумма по дебету
if ((_excelBook.getValue(currentCell, currentCell) != null) && (_excelBook.getValue(currentCell, currentCell).ToString() != string.Empty))
{
dcRow.SetSum(_excelBook.getValue(currentCell, currentCell));
if (dcRow.Sum != 0.0)
{
Debet.Add(dcRow);
}
}
else
{
currentCell = (_invoice.IsRub) ? "P" + i : "O" + i; //Сумма по кредиту
dcRow.SetSum(_excelBook.getValue(currentCell, currentCell));
if (dcRow.Sum != 0.0)
{
Credit.Add(dcRow);
}
}
i++;
currentCell = (_invoice.IsRub) ? "Q" + i : "D" + i;
}
i += incement;
readBlocks++;
}
ReadTails(i - incement);
}
private void ReadBody()
{
int i = (_invoice.IsRub) ? 12 : 11; //первая строка с данными
int incement = (_invoice.IsRub) ? 7 : 4;
int readBlocks = 0;
int countBlocks = GetCountBlocks();
while (readBlocks < countBlocks)
{
currentCell = (_invoice.IsRub) ? "Q" + i : "D" + i;
while (_excelBook.getValue(currentCell, currentCell) != null)
{
DCRow dcRow = new DCRow();
currentCell = (_invoice.IsRub) ? "Q" + i : "D" + i; //№ документа
dcRow.SetNumber(_excelBook.getValue(currentCell, currentCell));
currentCell = (_invoice.IsRub) ? "F" + i : "E" + i; //Счёт дебет
dcRow.SetOrdp(_excelBook.getValue(currentCell, currentCell));
currentCell = (_invoice.IsRub) ? "J" + i : "G" + i; //Счёт кредит
dcRow.SetBenm(_excelBook.getValue(currentCell, currentCell));
currentCell = (_invoice.IsRub) ? "AA" + i : "Y" + i; //Назначение платежа
dcRow.SetCom(_excelBook.getValue(currentCell, currentCell));
currentCell = (_invoice.IsRub) ? "L" + i : "I" + i; //Сумма по дебету
if ((_excelBook.getValue(currentCell, currentCell) != null) && (_excelBook.getValue(currentCell, currentCell).ToString() != string.Empty))
{
dcRow.SetSum(_excelBook.getValue(currentCell, currentCell));
if (dcRow.Sum != 0.0)
Debet.Add(dcRow);
}
else
{
currentCell = (_invoice.IsRub) ? "P" + i : "O" + i; //Сумма по кредиту
dcRow.SetSum(_excelBook.getValue(currentCell, currentCell));
if (dcRow.Sum != 0.0)
Credit.Add(dcRow);
}
i++;
currentCell = (_invoice.IsRub) ? "Q" + i : "D" + i;
}
i += incement;
readBlocks++;
}
ReadTails(i - incement);
}
public void Add(DCRow row)
{
_list.Add(row);
}
public void Add(DCRow row)
{
_list.Add(row);
}
