private void tabulkaToolStripMenuItem_Click(object sender, EventArgs e)
{
Tabulka form = new Tabulka();
form.Show();
Hide();
}
private static Collection <Tabulka> ReadT(SqlDataReader reader)
{
Collection <Tabulka> tab = new Collection <Tabulka>();
while (reader.Read())
{
int i = -1;
Tabulka t = new Tabulka();
t.Tym = reader.GetString(++i);
t.GV = reader.GetInt32(++i);
t.GO = reader.GetInt32(++i);
t.body = reader.GetInt32(++i);
tab.Add(t);
}
return(tab);
}
public IList<UsekOddeleniWithCount> GetLopCounts(StavUkolu su, Tabulka ta)
{
string table = "";
string whereClause = " WHERE " + ta + ".Deleted = 0 ";
switch (su)
{
//default:
case StavUkolu.Vsechny:
break;
case StavUkolu.Vyresene:
whereClause += " AND " + ta + ".FinishDate is not null ";
break;
case StavUkolu.Nevyresene:
whereClause += " AND " + ta + ".FinishDate is null ";
break;
case StavUkolu.CekajiciNaSchvaleni:
whereClause += " AND " + ta + ".CloseDate is not null AND " + ta + ".FinishDate is null";
break;
case StavUkolu.PoDeadlinu:
whereClause += " AND " + ta + ".FinishDate is null AND " + ta + ".PlannedCloseDate < NOW() ";
break;
}
string sql = "SELECT Usek.Nazev AS Usek, Oddeleni.Nazev AS Oddeleni, COUNT(" + ta + ".Id) AS Pocet " +
" FROM Usek " +
" LEFT OUTER JOIN Oddeleni ON Oddeleni.Usek = Usek.Id " +
" LEFT OUTER JOIN Uzivatel ON Uzivatel.Oddeleni = Oddeleni.Id " +
" LEFT OUTER JOIN " + ta + " ON " + ta + ".Resitel = Uzivatel.Id " +
whereClause +
" GROUP BY Usek.Nazev, Oddeleni.Nazev";
IQuery query = Session.CreateSQLQuery(sql)
.SetResultTransformer(Transformers.AliasToBean<UsekOddeleniWithCount>());
return query.List<UsekOddeleniWithCount>();
}
