/// <summary>
/// метод нахождения названия компании в Excel-файле генподрядчика
/// </summary>
/// <returns></returns>
public CASTitle FindTitle(Excel.Application TempImportExcel, int index)
{
if (CountingColumn == 0 || CountingLine == 0)
{
if (this.TempImportExcel == null)
{
this.TempImportExcel = TempImportExcel;
}
Excel.Range leftTopCell = findLeftTopCell();
CountingLine = leftTopCell.Row + 1;
CountingColumn = leftTopCell.Column + 2;
for (int i = 1;
TempImportExcel.Cells[leftTopCell.Row + i, leftTopCell.Column].Text.Trim() != "1"; i++)
{
CountingLine++;
}
}
CASTitle result = new CASTitle();
result.Title = TempImportExcel.Cells[findIndexLine(index), CountingColumn].Text;
result.Point = false;
return(result);
}
/// <summary>
/// метод нахождения названия компании в Excel-файле генподрядчика
/// </summary>
/// <returns></returns>
public CASTitle FindTitle(Excel.Application TempImportExcel, int index)
{
if (this.TempImportExcel == null)
{
this.TempImportExcel = TempImportExcel;
}
if (CountingLine == 0 || CountingColumn == 0)
{
Excel.Range leftTopCell = findLeftTopCell();
CountingLine = leftTopCell.Row;
CountingColumn = leftTopCell.Column + 1;
for (int i = 1; TempImportExcel.Cells[CountingLine + 1, leftTopCell.Column].Text.Trim() != "1"; i++)
{
CountingLine++;
}
}
CASTitle result = new CASTitle();
result.Title = TempImportExcel.Cells[CountingLine + index, CountingColumn].Text;
if (TempImportExcel.Cells[CountingLine + index, CountingColumn - 1].Value == null)
{
result.Point = false;
}
return(result);
}
/// <summary>
/// метод нахождения названия компании в Excel-файле генподрядчика
/// </summary>
/// <returns></returns>
public CASTitle FindTitle(object[,] array, int index)
{
if (CountingColumn == 0 || CountingLine == 0)
{
if (this.array == null)
{
this.array = array;
}
Cell leftTopCell = findLeftTopCell();
CountingLine = leftTopCell.Row + 1;
CountingColumn = leftTopCell.Column + 2;
for (int i = 1;
array[leftTopCell.Row + i, leftTopCell.Column]?.ToString().Trim() != "1"; i++)
{
CountingLine++;
}
}
CASTitle result = new CASTitle();
result.Title = (string)array[findIndexLine(index), CountingColumn];
result.Point = false;
return(result);
}
/// <summary>
/// метод нахождения названия компании в Excel-файле генподрядчика
/// </summary>
/// <returns></returns>
public CASTitle FindTitle(object[,] array, int index)
{
if (this.array == null)
{
this.array = array;
}
if (CountingLine == 0 || CountingColumn == 0)
{
Cell leftTopCell = findLeftTopCell();
CountingLine = leftTopCell.Row;
CountingColumn = leftTopCell.Column + 1;
for (;; CountingLine++)
{
if (array[CountingLine + 1, leftTopCell.Column] != null &&
array[CountingLine + 1, leftTopCell.Column].ToString().Trim() == "1")
{
break;
}
}
}
CASTitle result = new CASTitle();
if (array[CountingLine + index, CountingColumn] != null)
{
result.Title = array[CountingLine + index, CountingColumn].ToString();
}
else
{
result.Title = "";
}
if (array[CountingLine + index, CountingColumn - 1] == null)
{
result.Point = false;
}
else
{
result.Point = true;
}
return(result);
}
