private static object[,] PrepareListForSet1(SetItem obj)
{
var rowsCount = obj.MOList.Count + 8 + obj.ControlMOList.Count + 1;
var columnsCount = obj.MICList.Count + 5;
object[,] data = new object[rowsCount, columnsCount];
//data[0, 0] = "Метод тестирования: " + obj.TestMethod;
//data[2, 0] = "Сет № " + obj.Set;
//data[2, 4] = obj.AB;
data[0, 0] = "Ячейка";
data[0, 1] = "№";
data[0, 2] = "Муз. №.";
data[0, 3] = "МО";
for (int i = 0; i < obj.MICList.Count; i++)
{
data[0, 4 + i] = obj.MICList[i];
}
data[0, 4 + obj.MICList.Count] = "МПК";
for (int i = 0; i < obj.MOList.Count; i++)
{
data[1 + i, 0] = obj.MOList[i].Cell;
data[1 + i, 1] = obj.MOList[i].Number;
data[1 + i, 2] = obj.MOList[i].MuseumNumber;
data[1 + i, 3] = obj.MOList[i].MO;
}
data[1 + obj.MOList.Count, 0] = "Контрольн.МО";
for (int i = 0; i < obj.ControlMOList.Count; i++)
{
data[2 + obj.MOList.Count + i, 0] = obj.ControlMOList[i].Cell;
data[2 + obj.MOList.Count + i, 1] = obj.ControlMOList[i].Number;
data[2 + obj.MOList.Count + i, 2] = obj.ControlMOList[i].MuseumNumber;
data[2 + obj.MOList.Count + i, 3] = obj.ControlMOList[i].MO;
}
return(data);
}
private static void FormatSheetForSet1(Excel.Worksheet sheet, SetItem obj)
{
// formatting All sheet
sheet.PageSetup.PrintGridlines = false;
;
sheet.PageSetup.Orientation = Excel.XlPageOrientation.xlPortrait;
sheet.PageSetup.PaperSize = Excel.XlPaperSize.xlPaperA4;
sheet.PageSetup.RightFooter = "Дата: &DD Стр &PP из &NN";
sheet.PageSetup.RightHeader = "Исследование " + obj.Project + ", сет № " + obj.Set + " - " + obj.TestMethod +
" - " + obj.AB;
sheet.PageSetup.Zoom = false;
sheet.PageSetup.LeftHeader = "НИИ Антимикробной химиотерапии";
sheet.PageSetup.TopMargin = 50;
sheet.PageSetup.BottomMargin = 50;
sheet.PageSetup.HeaderMargin = 20;
sheet.PageSetup.FooterMargin = 20;
sheet.PageSetup.RightMargin = 10;
sheet.PageSetup.LeftMargin = 50;
sheet.PageSetup.Order = Excel.XlOrder.xlOverThenDown;
//// Foramatting test method
//sheet.Range[sheet.Cells[1, 1], sheet.Cells[1, obj.MICList.Count + 5]].Merge();
//FormatHeaderText1(sheet.Range[sheet.Cells[1, 1], sheet.Cells[1, 3]]);
//// Formatting Set Number
//sheet.Range[sheet.Cells[3, 1], sheet.Cells[3, 4]].Merge();
//FormatHeaderText1(sheet.Range[sheet.Cells[3, 1], sheet.Cells[3, 1]]);
//// Formatting Set Number
//sheet.Range[sheet.Cells[3, 5], sheet.Cells[3, obj.MICList.Count + 5]].Merge();
//FormatHeaderText1(sheet.Range[sheet.Cells[3, 5], sheet.Cells[3, obj.MICList.Count + 5]]);
//Formatting table with MO
FormatTableCells1(sheet.Range[sheet.Cells[1, 1], sheet.Cells[1 + obj.MOList.Count, obj.MICList.Count + 5]]);
sheet.PageSetup.Zoom = false;
sheet.PageSetup.FitToPagesWide = 1;
// sheet.PageSetup.FitToPagesTall = 0;
//Formatting Control MO Header
sheet.Range[sheet.Cells[2 + obj.MOList.Count, 1], sheet.Cells[2 + obj.MOList.Count, obj.MICList.Count + 5]].Merge();
sheet.Range[sheet.Cells[2 + obj.MOList.Count, 1], sheet.Cells[2 + obj.MOList.Count, obj.MICList.Count + 5]].RowHeight = 15;
FormatHeaderControlMOText1(
sheet.Range[
sheet.Cells[2 + obj.MOList.Count, 1], sheet.Cells[2 + obj.MOList.Count, obj.MICList.Count + 5]]);
// Formatting table with control MO
FormatTableCells1(sheet.Range[sheet.Cells[1 + obj.MOList.Count + 1, 1], sheet.Cells[1 + obj.MOList.Count + 1 + obj.ControlMOList.Count, obj.MICList.Count + 5]]);
FormatHeaderControlMOText1(sheet.Range[
sheet.Cells[3 + obj.MOList.Count, 2], sheet.Cells[1 + obj.MOList.Count + obj.ControlMOList.Count, 4]]);
//Formatting Top Row
sheet.Range[sheet.Cells[1, 1], sheet.Cells[5, obj.MICList.Count + 5]].ColumnWidth = 6;
//Formatting Left Columns
sheet.Range[sheet.Cells[1, 1], sheet.Cells[5 + obj.MOList.Count, 1]].ColumnWidth = 6;
sheet.Range[sheet.Cells[1, 2], sheet.Cells[5 + obj.MOList.Count, 2]].ColumnWidth = 8;
sheet.Range[sheet.Cells[1, 3], sheet.Cells[5 + obj.MOList.Count, 3]].ColumnWidth = 8;
sheet.Range[sheet.Cells[1, 4], sheet.Cells[5 + obj.MOList.Count, 4]].ColumnWidth = 14;
//Formatting Right Columns
sheet.Range[sheet.Cells[1, obj.MICList.Count + 5], sheet.Cells[1 + obj.MOList.Count, obj.MICList.Count + 5]].ColumnWidth = 8;
sheet.Cells[obj.MOList.Count + obj.ControlMOList.Count + 3, 2] = "Проверил:";
// Разбиваем на две части
if (obj.MOList.Count > 48)
{
sheet.ResetAllPageBreaks();
// sheet.DisplayPageBreaks = true;
sheet.HPageBreaks.Add(sheet.Cells[50, 1]);
}
}