private void sformListForFaculty_and_kafs()
{
using (FacultyTableAdapter facultyAdapter = new FacultyTableAdapter()) {
using (KafsTableAdapter KafsAdapter = new KafsTableAdapter()) {
using (itemprop_employeesTableAdapter EmployeesAdapter = new itemprop_employeesTableAdapter()) {
using (POSTTableAdapter PostAdapter = new POSTTableAdapter()) {
using (itemprop_prepod_disciplinesTableAdapter DiscipAdapter = new itemprop_prepod_disciplinesTableAdapter()) {
using (ArmKaf_PovKvalPrepodTableAdapter QualificAdapter = new ArmKaf_PovKvalPrepodTableAdapter()) {
DataSet.itemprop_prepod_disciplinesDataTable DiscipTable = new DataSet.itemprop_prepod_disciplinesDataTable();
DataSet.ArmKaf_PovKvalPrepodDataTable QualificTable = new DataSet.ArmKaf_PovKvalPrepodDataTable();
DataSet.KafsDataTable kafsTable = new DataSet.KafsDataTable();
DataSet.itemprop_employeesDataTable EmployeesTable = new DataSet.itemprop_employeesDataTable();
DataSet.POSTDataTable PostTable = new DataSet.POSTDataTable();
int StudyYear = (DateTime.Now.Month >= 9) ? DateTime.Now.Year : DateTime.Now.Year - 1;
var h2 = new HtmlGenericControl("h2");
h2.InnerText = "Педагогический состав";
Content.Controls.Add(h2);
DataSet.FacultyDataTable FacultyTable = new DataSet.FacultyDataTable();
Func <DataRow, bool> func = (Row) => {
return((int)Row["CodFaculty"] == 80 ? true : false);
};
facultyAdapter.Fill(FacultyTable);
KafsAdapter.Fill(kafsTable);
PostAdapter.Fill(PostTable);
DiscipAdapter.Fill(DiscipTable, (short)StudyYear, string.Empty, "0", true);
EmployeesAdapter.Fill(EmployeesTable, StudyYear);
QualificAdapter.Fill(QualificTable);
foreach (DataRow RowFac in FacultyTable.Rows)
{
var h3 = new HtmlGenericControl("h3");
h3.InnerText = RowFac["NameFaculty"].ToString().Trim();
Content.Controls.Add(h3);
DataRow[] Kafs = kafsTable.Select("CodFaculty = " + RowFac["CodFaculty"].ToString());
foreach (DataRow RowKaf in Kafs)
{
var h4 = new HtmlGenericControl("h4");
h4.InnerText = "Кафедра " + RowKaf["NameKaf"].ToString().Trim().ToLower();
Content.Controls.Add(h4);
DataRow[] EmployeesListInKaf = EmployeesTable.Select("CodKaf = " + RowKaf["CodKaf"].ToString().Trim());
Table table = new Table();
table.Style.Add(HtmlTextWriterStyle.BorderCollapse, "collapse");
table.Style.Add(HtmlTextWriterStyle.BorderColor, "black");
table.Style.Add(HtmlTextWriterStyle.BorderStyle, "solid");
table.Style.Add(HtmlTextWriterStyle.BorderWidth, "1px");
table.Style.Add(HtmlTextWriterStyle.FontSize, "11px");
table.Style.Add(HtmlTextWriterStyle.Width, "1000px");
AddHtmlHeader(table);
for (int i = 0; i < EmployeesListInKaf.Length; i++)
{
DataRow[] PostRows = PostTable.Select("CODPE = " + EmployeesListInKaf[i]["CodPrep"].ToString());
DataRow[] DiscipRows = DiscipTable.Select("codprep = " + EmployeesListInKaf[i]["CodPrep"].ToString());
DataRow[] QualificRows = QualificTable.Select("CodPrep = " + EmployeesListInKaf[i]["CodPrep"].ToString());
string post = String.Empty;
if (PostRows.Length != 0)
{
post = PostRows[PostRows.Length - 1]["POSTNAM"].ToString();
}
AddHtmlRow(EmployeesListInKaf[i],
table,
post,
i + 1,
StudyYear,
DiscipRows,
QualificRows);
}
this.Content.Controls.Add(table);
}
}
}
}
}
}
}
}
}
