private void btnXemTKB_Click(object sender, EventArgs e)
{
this.Dispose();
XemTKB tkb = new XemTKB();
tkb.ShowDialog();
}
private void btnXemTKB_Click(object sender, EventArgs e)
{
if (btnXemTKB.Enabled == true)
{
XemTKB xtkb = new XemTKB();
XepThoiKhoaBieuEntities xl = new XepThoiKhoaBieuEntities();
for (int ni = 0; ni < 6; ni++)
{
xtkb.dgvTKB.Rows.Add();
if (ni == 0)
{
xtkb.dgvTKB.Rows[ni].Cells[0].Value = "Thứ 2";
}
if (ni == 1)
{
xtkb.dgvTKB.Rows[ni].Cells[0].Value = "Thứ 3";
}
if (ni == 2)
{
xtkb.dgvTKB.Rows[ni].Cells[0].Value = "Thứ 4";
}
if (ni == 3)
{
xtkb.dgvTKB.Rows[ni].Cells[0].Value = "Thứ 5";
}
if (ni == 4)
{
xtkb.dgvTKB.Rows[ni].Cells[0].Value = "Thứ 6";
}
if (ni == 5)
{
xtkb.dgvTKB.Rows[ni].Cells[0].Value = "Thứ 7";
}
}
var tenl =
from d in xl.Lops
select d;
int cel = 1;
foreach (var lh in tenl)
{
xtkb.dgvTKB.Columns[cel].HeaderText = lh.TenLop;
string t2 = null;
string t3 = null;
string t4 = null;
string t5 = null;
string t6 = null;
string t7 = null;
int dem2 = 1;
int dem3 = 1;
int dem4 = 1;
int dem5 = 1;
int dem6 = 1;
int dem7 = 1;
var ttkb =
from d in tkb
where d.MaLop == lh.MaLop
orderby d.MaTiet
select d;
foreach (var t in ttkb)
{
if (t.MaTiet <= 10)
{
var tenm =
from d in xl.MonHocs
where d.MaMH == t.MaMH
select d;
foreach (var gv in tenm)
{
if (dem2 < 4)
{
t2 += gv.TenMH + ", ";
}
else
{
t2 += gv.TenMH;
}
dem2++;
}
if (Compare(lh.TenLop.ToString(), "12") == true ||
(Compare(lh.TenLop.ToString(), "11") == true && lh.MaBan == 1))
{
if (dem2 == 5)
{
t2 = "Chào cờ, " + t2;
}
}
else
{
if (dem2 == 5)
{
t2 += ", Chào cờ";
}
}
xtkb.dgvTKB.Rows[0].Cells[cel].Value = t2;
}
else if (t.MaTiet > 10 && t.MaTiet <= 20)
{
var tenm =
from d in xl.MonHocs
where d.MaMH == t.MaMH
select d;
foreach (var gv in tenm)
{
if (dem3 < 5)
{
t3 += gv.TenMH + ", ";
}
else
{
t3 += gv.TenMH;
}
dem3++;
}
xtkb.dgvTKB.Rows[1].Cells[cel].Value = t3;
}
else if (t.MaTiet > 20 && t.MaTiet <= 30)
{
var tenm =
from d in xl.MonHocs
where d.MaMH == t.MaMH
select d;
foreach (var gv in tenm)
{
if (dem4 < 5)
{
t4 += gv.TenMH + ", ";
}
else
{
t4 += gv.TenMH;
}
dem4++;
}
xtkb.dgvTKB.Rows[2].Cells[cel].Value = t4;
}
else if (t.MaTiet > 30 && t.MaTiet <= 40)
{
var tenm =
from d in xl.MonHocs
where d.MaMH == t.MaMH
select d;
foreach (var gv in tenm)
{
if (dem5 < 5)
{
t5 += gv.TenMH + ", ";
}
else
{
t5 += gv.TenMH;
}
dem5++;
}
xtkb.dgvTKB.Rows[3].Cells[cel].Value = t5;
}
else if (t.MaTiet > 40 && t.MaTiet <= 50)
{
var tenm =
from d in xl.MonHocs
where d.MaMH == t.MaMH
select d;
foreach (var gv in tenm)
{
if (dem6 < 4)
{
t6 += gv.TenMH + ", ";
}
else
{
t6 += gv.TenMH;
}
dem6++;
}
xtkb.dgvTKB.Rows[4].Cells[cel].Value = t6;
}
else if (t.MaTiet > 50 && t.MaTiet <= 60)
{
var tenm =
from d in xl.MonHocs
where d.MaMH == t.MaMH
select d;
foreach (var gv in tenm)
{
if (dem7 < 3)
{
t7 += gv.TenMH + ", ";
}
else
{
t7 += gv.TenMH;
}
dem7++;
}
xtkb.dgvTKB.Rows[5].Cells[cel].Value = t7;
}
}
cel++;
}
xtkb.ShowDialog();
}
}