private void btnXoaGV_Click(object sender, EventArgs e) { if (btnXoaGV.Enabled == true) { string err = null; DialogResult r = MessageBox.Show(null, "Bạn có chắc xóa giáo viên " + txtTenGV.Text + " không!", "Cân nhắc", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { try { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); GiaoVien gv = new GiaoVien(); gv.MaGV = Int32.Parse(txtMaGV.Text); gv.TenGV = txtTenGV.Text; et.Entry(gv).State = EntityState.Deleted; et.SaveChanges(); MessageBox.Show("Đã xóa!"); QLGiaoVien_Load(sender, e); } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } } } }
private void btnXoaPH_Click(object sender, EventArgs e) { if (btnXoaPH.Enabled == true) { string err = null; DialogResult r = MessageBox.Show(null, "Bạn có chắc xóa phòng " + txtTenPH.Text + " không!", "Cân nhắc", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { try { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); PhongHoc ph = new PhongHoc(); ph.MaPH = Int32.Parse(txtMaPH.Text); et.Entry(ph).State = EntityState.Deleted; et.SaveChanges(); MessageBox.Show("Đã xóa!"); } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } QLPhongHoc_Load(sender, e); } } }
private void btnXoaBan_Click(object sender, EventArgs e) { if (btnXoaBan.Enabled == true) { DialogResult r = MessageBox.Show(null, "Bạn có chắc xóa ban " + txtTenBan.Text + " không!", "Cân nhắc", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { try { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); Ban bdel = new Ban(); bdel.MaBan = Int32.Parse(txtMaBan.Text); bdel.TenBan = txtTenBan.Text; et.Entry(bdel).State = EntityState.Deleted; et.SaveChanges(); MessageBox.Show("Đã xóa!"); QLBan_Load(sender, e); } catch (Exception ex) { MessageBox.Show("Xóa lỗi! Lỗi " + ex.Message); } } } }
private void btnReload_Click(object sender, EventArgs e) { if (k == 1) { try { if (t == 1) { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); GiaoVien gv = new GiaoVien(); gv.MaGV = Int32.Parse(txtMaGV.Text); gv.TenGV = txtTenGV.Text; gv.GioiTinh = txtGioiTinh.Text; gv.SDT = txtSDT.Text; gv.ChucVu = txtChucVu.Text; gv.Email = txtEmail.Text; gv.MaBM = Int32.Parse(txtMaBM.Text); et.Entry(gv).State = EntityState.Added; et.SaveChanges(); MessageBox.Show("Thêm thành công!"); } else { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); GiaoVien gv = new GiaoVien(); gv.MaGV = Int32.Parse(txtMaGV.Text); gv.TenGV = txtTenGV.Text; gv.GioiTinh = txtGioiTinh.Text; gv.SDT = txtSDT.Text; gv.ChucVu = txtChucVu.Text; gv.Email = txtEmail.Text; gv.MaBM = Int32.Parse(txtMaBM.Text); et.Entry(gv).State = EntityState.Modified; et.SaveChanges(); MessageBox.Show("Sửa thành công!"); } QLGiaoVien_Load(sender, e); } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } } else { QLGiaoVien_Load(sender, e); } }
private void btnXoaBM_Click(object sender, EventArgs e) { if (btnXoaBM.Enabled == true) { DialogResult r = MessageBox.Show(null, "Bạn có chắc xóa bộ môn " + txtTenBM.Text + " không!", "Cân nhắc", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); BoMon bmdel = new BoMon(); bmdel.MaBM = Int32.Parse(txtMaBM.Text); et.Entry(bmdel).State = EntityState.Deleted; et.SaveChanges(); MessageBox.Show("Đã xóa!"); QLBoMon_Load(sender, e); } } }
private void btnReload_Click(object sender, EventArgs e) { if (k == 1) { try { if (t == 1) { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); Lop lop = new Lop(); lop.MaLop = Int32.Parse(txtMaLH.Text); lop.TenLop = txtTenLH.Text; lop.SoHocSinh = Int32.Parse(txtSoHS.Text); lop.MaBan = Int32.Parse(txtMaBan.Text); et.Entry(lop).State = EntityState.Added; et.SaveChanges(); MessageBox.Show("Thêm thành công!"); } else { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); Lop lop = new Lop(); lop.MaLop = Int32.Parse(txtMaLH.Text); lop.TenLop = txtTenLH.Text; lop.SoHocSinh = Int32.Parse(txtSoHS.Text); lop.MaBan = Int32.Parse(txtMaBan.Text); et.Entry(lop).State = EntityState.Modified; et.SaveChanges(); MessageBox.Show("Sửa thành công!"); } QLLop_Load(sender, e); } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } } else { QLLop_Load(sender, e); } }
private void btnReload_Click(object sender, EventArgs e) { if (k == 1) { try { if (t == 1) { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); PhongHoc ph = new PhongHoc(); ph.MaPH = Int32.Parse(txtMaPH.Text); ph.TenPH = txtTenPH.Text; ph.DungLuong = Int32.Parse(txtDungLuong.Text); et.Entry(ph).State = EntityState.Added; et.SaveChanges(); MessageBox.Show("Đã xóa!"); } else { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); PhongHoc ph = new PhongHoc(); ph.MaPH = Int32.Parse(txtMaPH.Text); ph.TenPH = txtTenPH.Text; ph.DungLuong = Int32.Parse(txtDungLuong.Text); et.Entry(ph).State = EntityState.Modified; et.SaveChanges(); MessageBox.Show("Đã xóa!"); } } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } QLPhongHoc_Load(sender, e); } else { QLPhongHoc_Load(sender, e); } }
private void btnReload_Click(object sender, EventArgs e) { if (k == 1) { try { if (t == 1) { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); Ban b = new Ban(); b.MaBan = Int32.Parse(txtMaBan.Text); b.TenBan = txtTenBan.Text; et.Entry(b).State = EntityState.Added; et.SaveChanges(); MessageBox.Show("Thêm thành công!"); } else { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); Ban bnew = new Ban(); bnew.MaBan = Int32.Parse(txtMaBan.Text); bnew.TenBan = txtTenBan.Text; et.Entry(bnew).State = EntityState.Modified; et.SaveChanges(); MessageBox.Show("Sửa thành công!"); } } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } QLBan_Load(sender, e); } else { QLBan_Load(sender, e); } }
private void btnXoaLop_Click(object sender, EventArgs e) { if (btnXoaLop.Enabled == true) { DialogResult r = MessageBox.Show(null, "Bạn có chắc xóa lớp " + txtTenLH.Text + " không!", "Cân nhắc", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { try { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); Lop lop = new Lop(); lop.MaLop = Int32.Parse(txtMaLH.Text); et.Entry(lop).State = EntityState.Deleted; et.SaveChanges(); MessageBox.Show("Đã xóa!"); } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } QLLop_Load(sender, e); } } }
private void btnReload_Click(object sender, EventArgs e) { if (k == 1) { try { if (t == 1) { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); MonHoc mh = new MonHoc(); mh.MaMH = Int32.Parse(txtMaMH.Text); mh.TenMH = txtTenMH.Text; et.Entry(mh).State = EntityState.Added; et.SaveChanges(); } else { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); MonHoc mh = new MonHoc(); mh.MaMH = Int32.Parse(txtMaMH.Text); mh.TenMH = txtTenMH.Text; et.Entry(mh).State = EntityState.Modified; et.SaveChanges(); } } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } QLMonHoc_Load(sender, e); } else { QLMonHoc_Load(sender, e); } }
private void dgvRangBuoc_CellClick(object sender, DataGridViewCellEventArgs e) { XepThoiKhoaBieuEntities xl = new XepThoiKhoaBieuEntities(); int r = dgvRangBuoc.CurrentCell.RowIndex; if (r >= 0 && r < dgvRangBuoc.RowCount) { switch (xet) { case 1: { txt1.Text = dgvRangBuoc.Rows[r].Cells[0].Value.ToString(); string tenGV = null; string TenMH = null; int magv = Int32.Parse(dgvRangBuoc.Rows[r].Cells[1].Value.ToString()); int mamh = Int32.Parse(dgvRangBuoc.Rows[r].Cells[2].Value.ToString()); var teng = from d in xl.GiaoViens where d.MaGV == magv select d; var tenm = from d in xl.MonHocs where d.MaMH == mamh select d; foreach (var gv in teng) { tenGV = gv.TenGV; } foreach (var mh in tenm) { TenMH = mh.TenMH; } txt2.Text = tenGV; txt3.Text = TenMH; txt4.Text = dgvRangBuoc.Rows[r].Cells[3].Value.ToString(); txt4.Show(); lbl4.Show(); txt5.Hide(); lbl5.Hide(); break; } case 2: { txt1.Text = dgvRangBuoc.Rows[r].Cells[0].Value.ToString(); string tenLop = null; string TenPhong = null; int malop = Int32.Parse(dgvRangBuoc.Rows[r].Cells[1].Value.ToString()); int maphong = Int32.Parse(dgvRangBuoc.Rows[r].Cells[2].Value.ToString()); var tenl = from d in xl.Lops where d.MaLop == malop select d; var tenp = from d in xl.PhongHocs where d.MaPH == maphong select d; foreach (var lh in tenl) { tenLop = lh.TenLop; } foreach (var ph in tenp) { TenPhong = ph.TenPH; } txt2.Text = tenLop; txt3.Text = TenPhong; txt4.Hide(); lbl4.Hide(); txt5.Hide(); lbl5.Hide(); break; } case 3: { txt1.Text = dgvRangBuoc.Rows[r].Cells[0].Value.ToString(); string TenLop = null; string TenMH = null; int malop = Int32.Parse(dgvRangBuoc.Rows[r].Cells[1].Value.ToString()); int mamh = Int32.Parse(dgvRangBuoc.Rows[r].Cells[2].Value.ToString()); var tenl = from d in xl.Lops where d.MaLop == malop select d; var tenm = from d in xl.MonHocs where d.MaMH == mamh select d; foreach (var lh in tenl) { TenLop = lh.TenLop; } foreach (var mh in tenm) { TenMH = mh.TenMH; } txt2.Text = TenLop; txt3.Text = TenMH; txt4.Text = dgvRangBuoc.Rows[r].Cells[3].Value.ToString(); txt4.Show(); lbl4.Show(); txt5.Hide(); lbl5.Hide(); break; } case 4: { txt1.Text = dgvRangBuoc.Rows[r].Cells[0].Value.ToString(); string TenLop = null; string TenMH = null; string TenGV = null; string TenPH = null; int magv = Int32.Parse(dgvRangBuoc.Rows[r].Cells[1].Value.ToString()); int malop = Int32.Parse(dgvRangBuoc.Rows[r].Cells[2].Value.ToString()); int mamh = Int32.Parse(dgvRangBuoc.Rows[r].Cells[3].Value.ToString()); int maph = Int32.Parse(dgvRangBuoc.Rows[r].Cells[4].Value.ToString()); var tenl = from d in xl.Lops where d.MaLop == malop select d; var tenm = from d in xl.MonHocs where d.MaMH == mamh select d; var tengv = from d in xl.GiaoViens where d.MaGV == magv select d; var tenph = from d in xl.PhongHocs where d.MaPH == maph select d; foreach (var lh in tenl) { TenLop = lh.TenLop; } foreach (var mh in tenm) { TenMH = mh.TenMH; } foreach (var gv in tengv) { TenGV = gv.TenGV; } foreach (var ph in tenph) { TenPH = ph.TenPH; } txt2.Text = TenGV; txt3.Text = TenLop; txt4.Text = TenMH; txt5.Text = TenPH; txt4.Show(); txt5.Show(); lbl4.Show(); lbl5.Show(); break; } case 5: { txt1.Text = dgvRangBuoc.Rows[r].Cells[0].Value.ToString(); string TenLop = null; string TenMH = null; int malop = Int32.Parse(dgvRangBuoc.Rows[r].Cells[1].Value.ToString()); int mamh = Int32.Parse(dgvRangBuoc.Rows[r].Cells[2].Value.ToString()); var tenl = from d in xl.Lops where d.MaLop == malop select d; var tenm = from d in xl.MonHocs where d.MaMH == mamh select d; foreach (var lh in tenl) { TenLop = lh.TenLop; } foreach (var mh in tenm) { TenMH = mh.TenMH; } txt2.Text = TenLop; txt3.Text = TenMH; txt4.Text = dgvRangBuoc.Rows[r].Cells[3].Value.ToString(); txt4.Show(); lbl4.Show(); txt5.Hide(); lbl5.Hide(); break; } case 6: { txt1.Text = dgvRangBuoc.Rows[r].Cells[0].Value.ToString(); string TenLop = null; string TenMH = null; string TenGV = null; string TenPH = null; string Time = null; int malop = Int32.Parse(dgvRangBuoc.Rows[r].Cells[1].Value.ToString()); int mamh = Int32.Parse(dgvRangBuoc.Rows[r].Cells[2].Value.ToString()); int magv = Int32.Parse(dgvRangBuoc.Rows[r].Cells[0].Value.ToString()); int maph = Int32.Parse(dgvRangBuoc.Rows[r].Cells[3].Value.ToString()); int matiet = Int32.Parse(dgvRangBuoc.Rows[r].Cells[4].Value.ToString()); var tenl = from d in xl.Lops where d.MaLop == malop select d; var tenm = from d in xl.MonHocs where d.MaMH == mamh select d; var tengv = from d in xl.GiaoViens where d.MaGV == magv select d; var tenph = from d in xl.PhongHocs where d.MaPH == maph select d; var time = from d in xl.Tiets where d.STT == matiet select d; foreach (var gv in tengv) { TenGV = gv.TenGV; } foreach (var lh in tenl) { TenLop = lh.TenLop; } foreach (var mh in tenm) { TenMH = mh.TenMH; } foreach (var ph in tenph) { TenPH = ph.TenPH; } foreach (var t in time) { Time = t.Time; } txt1.Text = TenGV; txt2.Text = TenLop; txt3.Text = TenMH; txt4.Text = TenPH; txt5.Text = Time; txt4.Show(); lbl4.Show(); txt5.Show(); lbl5.Show(); lbl1.Text = "Tên GV"; lbl2.Text = "Tên Lớp"; lbl3.Text = "Tên MH"; lbl4.Text = "Tên PH"; lbl5.Text = "Time"; break; } } lbl1.Show(); lbl2.Show(); lbl3.Show(); txt1.Show(); txt2.Show(); txt3.Show(); } }
public void XepTKB() { int them = 0; for (int i = 0; i < GiaoVien_LopHoc.Count - 1; i++) { for (int j = 0; j < Lop_T_MH.Count - 1; j++) { if (GiaoVien_LopHoc[i].MaLop == Lop_T_MH[j].MaLop && GiaoVien_LopHoc[i].MaMh == Lop_T_MH[j].MaMH) { XepThoiKhoaBieuEntities xl = new XepThoiKhoaBieuEntities(); ThoiKhoaBieu tkb1 = new ThoiKhoaBieu(); tkb1.MaGV = GiaoVien_LopHoc[i].MaGV; tkb1.MaLop = GiaoVien_LopHoc[i].MaLop; tkb1.MaMH = GiaoVien_LopHoc[i].MaMh; tkb1.MaTiet = Lop_T_MH[j].MaTiet; tkb1.MaPH = GiaoVien_LopHoc[i].MaPH; tkb.Add(tkb1); //xl.Entry(tkb1).State = EntityState.Added; //xl.SaveChanges(); them++; } } } MessageBox.Show("Da xep xong " + them + " tiet hoc!"); //DataTable dt = new DataTable(); //dt = bl.ExecuteQueryDataSet("select * from ThoiKhoaBieu", CommandType.Text); //dgvRangBuoc.DataSource = dt; try { dgvRangBuoc.Show(); foreach (DataGridViewRow r in dgvRangBuoc.Rows) { dgvRangBuoc.Rows.Clear(); } int i = 0; for (int k = 0; k < tkb.Count - 1; k++) { dgvRangBuoc.Rows.Add(); dgvRangBuoc.Rows[i].Cells[0].Value = tkb[k].MaGV; dgvRangBuoc.Rows[i].Cells[1].Value = tkb[k].MaLop; dgvRangBuoc.Rows[i].Cells[2].Value = tkb[k].MaMH; dgvRangBuoc.Rows[i].Cells[3].Value = tkb[k].MaPH; dgvRangBuoc.Rows[i].Cells[4].Value = tkb[k].MaTiet; i++; xet = 6; lbl2.Text = "Tên Lớp"; lbl3.Text = "Tên MH"; dgvRangBuoc.Columns[0].HeaderText = "Mã GV"; dgvRangBuoc.Columns[1].HeaderText = "Mã Lớp"; dgvRangBuoc.Columns[2].HeaderText = "Mã MH"; dgvRangBuoc.Columns[3].HeaderText = "Mã PH"; dgvRangBuoc.Columns[4].HeaderText = "Mã Tiết"; } lbl1.Hide(); lbl2.Hide(); lbl3.Hide(); lbl4.Hide(); lbl5.Hide(); txt1.Hide(); txt2.Hide(); txt3.Hide(); txt4.Hide(); txt5.Hide(); } catch (Exception ex) { MessageBox.Show("lỗi! " + ex.Message); } }
public void XThoiKhoaBieu() { try { XepThoiKhoaBieuEntities xl = new XepThoiKhoaBieuEntities(); var giaovien = from d in xl.GiaoViens select d; var monhoc = from d in xl.MonHocs select d; var lop = from d in xl.Lops select d; var phong = from d in xl.PhongHocs select d; foreach (var gt in giaovien) { GiaoVien gv = new GiaoVien(); gv.MaGV = gt.MaGV; gv.TenGV = gt.TenGV; gv.MaBM = gt.MaBM; givi.Add(gv); g++; } foreach (var gt in monhoc) { MonHoc MH = new MonHoc(); MH.MaMH = gt.MaMH; MH.TenMH = gt.TenMH; MH.MaBM = gt.MaBM; moho.Add(MH); m++; } foreach (var gt in lop) { Lop LOP = new Lop(); LOP.MaLop = gt.MaLop; LOP.TenLop = gt.TenLop; loho.Add(LOP); l++; } foreach (var gt in phong) { PhongHoc PH = new PhongHoc(); PH.MaPH = gt.MaPH; PH.TenPH = gt.TenPH; phho.Add(PH); p++; } int dem; dem = 1; //Giáo viên nào dạy môn nào for (int i = 0; i < g; i++) { for (int j = 0; j < m; j++) { int cv; if (givi[i].MaBM == moho[j].MaBM) { GV_MH gvmh = new GV_MH(); gvmh.stt = dem; gvmh.MaGV = givi[i].MaGV; gvmh.MaMH = moho[j].MaMH; cv = SoSanh(Int32.Parse(givi[i].MaGV.ToString())); switch (cv) { case 0: { gvmh.Sotiet = 18; break; } case 1: { gvmh.Sotiet = 2; break; } case 2: { gvmh.Sotiet = 4; break; } case 3: { gvmh.Sotiet = 15; break; } case 4: { gvmh.Sotiet = 17; break; } case 5: { gvmh.Sotiet = 9; break; } case 6: { gvmh.Sotiet = 0; break; } } GVMHTable.Add(gvmh); dem++; } } } int ph = 0; //Lớp nào học phòng nào dem = 1; int check = 0; for (int i = 0; i < l; i++) { if (Compare(loho[i].TenLop.ToString(), "12") == true || (Compare(loho[i].TenLop.ToString(), "11") == true && loho[i].MaBan == 1)) { Lop_Phong lopphong = new Lop_Phong(); lopphong.stt = dem; lopphong.MaLop = loho[i].MaLop; lopphong.MaPH = phho[ph].MaPH; lopphong.Buoi = "Sáng"; dem++; LPTable.Add(lopphong); check++; } else { Lop_Phong lopphong = new Lop_Phong(); lopphong.stt = dem; lopphong.MaLop = loho[i].MaLop; lopphong.MaPH = phho[ph].MaPH; lopphong.Buoi = "Chiều"; dem++; LPTable.Add(lopphong); check++; } if (check >= 2) { ph++; check = 0; } } //Lớp nào học môn nào dem = 1; for (int i = 0; i < l; i++) { for (int j = 0; j < m; j++) { Lop_MH lopmh = new Lop_MH(); lopmh.stt = dem; lopmh.MaLop = loho[i].MaLop; lopmh.MaMH = moho[j].MaMH; if (loho[i].MaLop <= 11) //Lớp 10 { if (lopmh.MaMH == 1) //toán { lopmh.sotiet = 5; } else if (lopmh.MaMH == 5)//văn { lopmh.sotiet = 4; } else if (lopmh.MaMH == 3 || lopmh.MaMH == 6)//hóa, anh { lopmh.sotiet = 3; } else if (lopmh.MaMH == 2 || lopmh.MaMH == 4 || lopmh.MaMH == 8 || lopmh.MaMH == 11 || lopmh.MaMH == 12 || lopmh.MaMH == 13)//lý, địa, sinh, tin,TD,QP { lopmh.sotiet = 2; } else if (lopmh.MaMH != 14) //các môn còn lại khác tiếng pháp { lopmh.sotiet = 1; } } else if (loho[i].MaLop > 11 && loho[i].MaLop <= 21)//lớp 11 { if (lopmh.MaMH == 1) { lopmh.sotiet = 5; } else if (lopmh.MaMH == 5 || lopmh.MaMH == 6)//Anh, Văn { lopmh.sotiet = 4; } else if (lopmh.MaMH == 2 || lopmh.MaMH == 3)//Lý, Hóa { lopmh.sotiet = 3; } else if (lopmh.MaMH == 4 || lopmh.MaMH == 12 || lopmh.MaMH == 13)// Sinh, TD,QP { lopmh.sotiet = 2; } else if (lopmh.MaMH != 14)//các môn còn lại khác tiếng pháp { lopmh.sotiet = 1; } } else //lớp 12 { if (lopmh.MaMH == 1) //Toán { lopmh.sotiet = 4; } else if (lopmh.MaMH == 6)//Anh { lopmh.sotiet = 3; } else if (lopmh.MaMH == 2 || lopmh.MaMH == 3 || lopmh.MaMH == 4 || lopmh.MaMH == 5)//lý, hóa, sinh, văn { lopmh.sotiet = 3; } else if (lopmh.MaMH == 7 || lopmh.MaMH == 11 || lopmh.MaMH == 12 || lopmh.MaMH == 13)//sử, tin,TD,QP { lopmh.sotiet = 2; } else if (lopmh.MaMH != 14)//các môn còn lại khác tiếng pháp { lopmh.sotiet = 1; } } Lop_Monhoc.Add(lopmh); dem++; } } //Giáo viên nào dạy lớp nào dem = 1; Random ra = new Random(); for (int i = 0; i < m; i++) { for (int j = 0; j < l; j++) { GV_Lop gvl = new GV_Lop(); gvl.stt = dem; gvl.MaLop = loho[j].MaLop; gvl.MaMh = moho[i].MaMH; chon = new List <Chon>(); int nchon = 0; for (int l = 0; l < GVMHTable.Count - 1; l++) { if (GVMHTable[l].MaMH == gvl.MaMh) { Chon ch = new Chon(); ch.stt = nchon; ch.MAGV = GVMHTable[l].MaGV; chon.Add(ch); nchon++; } } int a; if (nchon > 1) { a = ra.Next(nchon); } else { a = 0; } int magv = chon[a].MAGV; gvl.MaGV = magv; for (int l = 0; l < LPTable.Count - 1; l++) { if (LPTable[l].MaLop == loho[j].MaLop) { gvl.MaPH = LPTable[l].MaPH; break; } } GiaoVien_LopHoc.Add(gvl); dem++; } } int tiet = 0; dem = 1; Random rd = new Random(); Random rd1 = new Random(); for (int it = 0; it < l; it++) { List <int> chonMh = new List <int>(); int sotiet = 0; for (int i = 0; i < moho.Count - 1; i++) ////bỏ thể dục + quốc phòng { sotiet = 0; if (moho[i].MaMH != 12 && moho[i].MaMH != 13) { for (int j = 0; j < Lop_Monhoc.Count - 1; j++) { if (Lop_Monhoc[j].MaMH == moho[i].MaMH && Lop_Monhoc[j].MaLop == loho[it].MaLop) { sotiet = Lop_Monhoc[j].sotiet; break; } } for (int j = 0; j < sotiet; j++) //Số lần xuất hiện môn học trong List chonMh { chonMh.Add(Lop_Monhoc[i].MaMH); } } } if (Compare(loho[it].TenLop.ToString(), "12") == true || (Compare(loho[it].TenLop.ToString(), "11") == true && loho[it].MaBan == 1)) { for (int th = 0; th < 6; th++) { for (int i = 1; i <= 5; i++)//lớp buổi sáng { Lop_Tiet_MH lgvmh = new Lop_Tiet_MH(); tiet = i + 10 * th; if (tiet == 1) { } else if (tiet == 29 || tiet == 30 || tiet == 25) { } else { int vt; if (chonMh.Count > 1) { vt = rd.Next(chonMh.Count - 1); } else { vt = 0; } lgvmh.stt = dem; lgvmh.MaLop = loho[it].MaLop; lgvmh.MaMH = chonMh[vt]; lgvmh.MaTiet = tiet; if (chonMh.Count > 1) { chonMh.RemoveAt(vt); } Lop_T_MH.Add(lgvmh); dem++; } } } } else { for (int th = 0; th < 6; th++) { for (int i = 6; i <= 10; i++)//lớp buổi chieu { Lop_Tiet_MH lgvmh = new Lop_Tiet_MH(); tiet = i + 10 * th; if (tiet == 10) { } else if (tiet == 59 || tiet == 60 || tiet == 50) { } else { int vt; if (chonMh.Count > 1) { vt = rd1.Next(chonMh.Count - 1); } else { vt = 0; } lgvmh.stt = dem; lgvmh.MaLop = loho[it].MaLop; lgvmh.MaMH = chonMh[vt]; lgvmh.MaTiet = tiet; if (chonMh.Count > 1) { chonMh.RemoveAt(vt); } Lop_T_MH.Add(lgvmh); dem++; } } } } } } catch (Exception ex) { MessageBox.Show("Lỗi! " + ex.Message); } }
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(); } }
public XThoiKhoaBieu() { XepThoiKhoaBieuEntities xl = new XepThoiKhoaBieuEntities(); List <GiaoVien> givi = new List <GiaoVien>(); List <MonHoc> moho = new List <MonHoc>(); List <Lop> loho = new List <Lop>(); List <PhongHoc> phho = new List <PhongHoc>(); GVMHTable = new List <GV_MH>(); LPTable = new List <Lop_Phong>(); int g; int m; int l; int p; var giaovien = from d in xl.GiaoViens select d; var monhoc = from d in xl.MonHocs select d; var lop = from d in xl.Lops select d; var phong = from d in xl.PhongHocs select d; foreach (var gt in giaovien) { g = 0; GiaoVien gv = new GiaoVien(); gv.MaGV = gt.MaGV; gv.TenGV = gt.TenGV; gv.MaBM = gt.MaBM; givi.Add(gv); g++; } foreach (var gt in monhoc) { m = 0; MonHoc MH = new MonHoc(); MH.MaMH = gt.MaMH; MH.TenMH = gt.TenMH; MH.MaBM = gt.MaBM; moho.Add(MH); m++; } foreach (var gt in lop) { l = 0; Lop LOP = new Lop(); LOP.MaLop = gt.MaLop; LOP.TenLop = gt.TenLop; loho.Add(LOP); l++; } foreach (var gt in phong) { p = 0; PhongHoc PH = new PhongHoc(); PH.MaPH = gt.MaPH; PH.TenPH = gt.TenPH; phho.Add(PH); p++; } int dem; dem = 0; ////Giáo viên nào dạy môn nào //for(int i=0;i<g;i++) //{ // for(int j=0;j<m;j++) // { // if (givi[i].MaBM == moho[j].MaBM) // { // GVMHTable[dem].stt = dem; // GVMHTable[dem].MaGV = givi[i].MaGV; // GVMHTable[dem].MaMH = moho[j].MaMH; // dem++; // } // } //} //int ph = 0; ////Lớp nào học phòng nào //for (int i = 0; i < l; i++) //{ // if (Compare(loho[i].TenLop.ToString(),"12")==true // || (Compare(loho[i].TenLop.ToString(), "11") == true && loho[i].MaBan == 1)) // { // LPTable[dem].stt = dem; // LPTable[dem].MaLop = loho[i].MaLop; // LPTable[dem].MaPH = phho[ph++].MaPH; // LPTable[dem].Buoi = "Sáng"; // dem++; // } // else // { // LPTable[dem].stt = dem; // LPTable[dem].MaLop = loho[i].MaLop; // LPTable[dem].MaPH = phho[ph++].MaPH; // LPTable[dem].Buoi = "Chiều"; // dem++; // } //} ////Lớp nào học môn nào //dem = 0; //for (int i = 0; i < l; i++) //{ // for (int j = 0; j < m; j++) // { // Lop_Monhoc[dem].stt = dem; // Lop_Monhoc[dem].MaLop = loho[i].MaLop; // Lop_Monhoc[dem].MaMH = moho[i].MaMH; // dem++; // } //} }