private void cmbClass_SelectedIndexChanged(object sender, EventArgs e)
{
int count = dgvTKB.Rows.Count;
for (int i = 0; i < count; i++)
{
dgvTKB.Rows.RemoveAt(0);
}
for (int i = 0; i < 6; i++)
{
dgvTKB.Rows.Add();
dgvTKB.Rows[i].Cells["Tiet"].Value = i + 1;
}
KetNoiDB db = new KetNoiDB();
DataTable tb = db.getDatatable(@"select gg.Thu, gg.Tietday, m.TenMon,l.TenLop, g.Ho+' '+g.Ten as Hoten, gg.MaGV from tblGiangday gg, tblLop l, tblGiaovien g, tblMonhoc m
where gg.MaGV = g.MaGV and l.MaLop = gg.MaLop and m.MaMon = g.MaMon and l.TenLop='" + cmbClass.Text + @"' order by gg.Tietday");
for (int i = 0; i < tb.Rows.Count; i++)
{
string thu = tb.Rows[i]["Thu"].ToString();
int tiet = int.Parse(tb.Rows[i]["Tietday"].ToString());
dgvTKB.Rows[tiet - 1].Cells["Thu" + thu].Value = tb.Rows[i]["TenMon"].ToString();
dgvTKB.Rows[tiet - 1].Cells["TenGV" + thu].Value = tb.Rows[i]["Hoten"].ToString();
}
}
private static void InitServices()
{
TableAdapterManager.ChiNhanhTableAdapter = ChiNhanhTableAdapter;
TableAdapterManager.CTDDHTableAdapter = CTDDHTableAdapter;
TableAdapterManager.CTPNTableAdapter = CTPNTableAdapter;
TableAdapterManager.CTPXTableAdapter = CTPXTableAdapter;
TableAdapterManager.DatHangTableAdapter = DatHangTableAdapter;
TableAdapterManager.KhoTableAdapter = KhoTableAdapter;
TableAdapterManager.NhanVienTableAdapter = NhanVienTableAdapter;
TableAdapterManager.PhieuNhapTableAdapter = PhieuNhapTableAdapter;
TableAdapterManager.PhieuXuatTableAdapter = PhieuXuatTableAdapter;
TableAdapterManager.VattuTableAdapter = VattuTableAdapter;
ChiNhanhTableAdapter.ClearBeforeFill = true;
CTDDHTableAdapter.ClearBeforeFill = true;
CTPNTableAdapter.ClearBeforeFill = true;
CTPXTableAdapter.ClearBeforeFill = true;
DatHangTableAdapter.ClearBeforeFill = true;
KhoTableAdapter.ClearBeforeFill = true;
NhanVienTableAdapter.ClearBeforeFill = true;
PhieuNhapTableAdapter.ClearBeforeFill = true;
VattuTableAdapter.ClearBeforeFill = true;
_ketNoiDB = new KetNoiDB();
_formLogin = new FormLogin();
}
static void initService()
{
_ketNoiDB = new KetNoiDB();
_formDangNhap = new FormDangNhap();
}
public FormLogin()
{
InitializeComponent();
_dataRepository = Program._ketNoiDB;
}