public void SetOrder()
{
SettingsFactory factory = new SettingsFactory();
Settings settings = factory.GetSettings();
isOrderSet = false;
Excel.Range titleRange = (Excel.Range)bomSheet.Rows[1];
Excel.Range cells = (Excel.Range)titleRange.Cells;
Excel.Range testCell = (Excel.Range)cells.Cells[1, 1];
int usedColumns = bomSheet.UsedRange.Columns.Count;
if (!(bool)testCell.MergeCells)
{
for (int i = 1; i <= usedColumns; i++)
{
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.Designator))
{
DESIGNATOR = i;
isDesignator = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.Type))
{
TYPE = i;
isType = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.ManufacturerPartNumber))
{
MANUFACTURER_PARTNUMBER = i;
isManufacturerPartNumber = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.Description))
{
DESCRIPTION = i;
isDescription = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.Manufacturer))
{
MANUFACTURER = i;
isManufacturer = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.Note))
{
NOTE = i;
isNote = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.Note1))
{
NOTE1 = i;
isNote1 = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.Quantity))
{
QUANTITY = i;
isQuantity = true;
continue;
}
}
}
if (isDesignator && isManufacturerPartNumber)
{
isOrderSet = true;
}
}
public void SetOrder()
{
SettingsFactory factory = new SettingsFactory();
Settings settings = factory.GetSettings();
isOrderSet = false;
Excel.Range titleRange = (Excel.Range)bomSheet.Rows[1];
Excel.Range cells = (Excel.Range)titleRange.Cells;
Excel.Range testCell = (Excel.Range)cells.Cells[1, 1];
int usedColumns = bomSheet.UsedRange.Columns.Count;
if (!(bool)testCell.MergeCells)
{
for (int i = 1; i <= usedColumns; i++)
{
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.SWFormat))
{
FORMAT = i;
isFormat = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.SWPosition))
{
POSITION = i;
isPosition = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.SWDesignation))
{
DESIGNATION = i;
isDesignation = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.SWName))
{
NAME = i;
isName = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.SWQuantity))
{
QUANTITY = i;
isQuantity = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.SWNote))
{
NOTE = i;
isNote = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.SWDocumentSection))
{
DOCUMENT_SECTION = i;
isDocumentSection = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.SWClass))
{
CLASS = i;
isClass = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.SWGost))
{
GOST = i;
isGost = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.SWSizesParametres))
{
SIZES_PARAMETRES = i;
isSizesParametres = true;
continue;
}
if ((cells[1, i] as Excel.Range).Value2.Equals(settings.SWReplacement))
{
REPLACEMENT = i;
isReplacement = true;
continue;
}
}
}
if (isDocumentSection && (isName || isSizesParametres))
{
isOrderSet = true;
}
}