// Выводит объекты в Excel файл
public void printAllToExcel()
{
ExcelDocumentManager manager_out = new ExcelDocumentManager();
manager_out.setVisible(true);
manager_out.CreateExcelApplication();
manager_out.CreateWorkbook();
manager_out.OpenSheet();
manager_out.toFirstRow();
// Выводим шапку
FISGIAObject tempObj = new FISGIAObject();
for (int i = 1; i <= tempObj.Fields().Length; i++)
{
manager_out.cell(i).Value = tempObj.Description(i);
}
manager_out.toNextRow();
// Выводим объекты
foreach (FISGIAObject obj in this.objects)
{
for (int i = 1; i <= obj.Fields().Length; i++)
{
manager_out.cell(i).Value = obj.Get(i);
}
manager_out.toNextRow();
}
} //--//--
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
//Application.Run(new Form1());
//Загружаем заявления студентов (FISGIA)
FISGIAObjectManager manager = new FISGIAObjectManager();
manager.LoadFiles();
Logger.getInstance().log("Загружено студентов " + manager.getCount().ToString());
/*List <ASURSOObject> list = manager.getAllArrived();
* Logger.getInstance().log("Отобрано студентов " + list.Count.ToString());
* (new LogForm(Logger.getInstance().getAllLogs())).ShowDialog();*/
// Смотрим найденных студентов
/*ExcelDocumentManager office = new ExcelDocumentManager();
* office.setVisible(true);
* office.CreateExcelApplication();
* office.CreateWorkbook();
* office.OpenSheet();
*
* office.toFirstRow();
* office.cell(1).Value = "Найдены данные";
* office.toNextRow();
* int i = 1;
* foreach(String name in (new ASURSOObject()).Descriptions())
* {
* office.cell(i).Value = name;
* i++;
* }
* office.toNextRow();
*
* foreach(ASURSOObject obj in list)
* {
* for(int j=1; j<= obj.Fields().Length; j++)
* {
* office.cell(j).Value = (obj.Field(j).Contains("Group") ? "'" : "") + obj.Get(j);
* }
* office.toNextRow();
* }*/
// Смотрим, есть ли студенты, прошедшие по приказу (knowlege) но не найденные в заявлениях (FISGIA)
ExcelDocumentManager office = new ExcelDocumentManager();
office.setVisible(true);
office.CreateExcelApplication();
office.CreateWorkbook();
office.OpenSheet();
office.toFirstRow();
office.cell(1).Value = "Не найдены данные";
office.toNextRow();
office.cell(1).Value = "Фамилия";
office.cell(2).Value = "Имя";
office.cell(3).Value = "Отчество";
office.cell(4).Value = "Группа";
office.toNextRow();
List <ArrivedStudentObject> allArrived = new GIAToASURSOConverter.knowlege.ArrivedStudentsKnowlege().getAll();
foreach (ArrivedStudentObject obj in allArrived)
{
bool found = false;
//=====================================================================================
// Поиск в найденных
//foreach (ASURSOObject aobj in list)
foreach (FISGIAObject aobj in manager.getAll())
{
String family = obj.Get("Family");
String name = obj.Get("Name");
String sername = obj.Get("Sername");
String family2 = aobj.Get("Family");
String name2 = aobj.Get("Name");
String sername2 = aobj.Get("Sername");
if (CheckSimilaryFIO.Check(family, name, sername, family2, name2, sername2) == true)
{
found = true;
}
} //===============================================================================================
if (found == false)
{
office.cell(1).Value = obj.Get("Family");
office.cell(2).Value = obj.Get("Name");
office.cell(3).Value = obj.Get("Sername");
office.cell(4).Value = "'" + obj.Get("Group");
office.toNextRow();
}
}
}