private void btnLuu_Click(object sender, EventArgs e) { int numberOfRow = lVDiem.Items.Count; for (int i = 0; i < numberOfRow; i++) { ListViewItem item = lVDiem.Items[i]; DiemInfo diem = new DiemInfo(); diem = (DiemInfo)item.Tag; m_DiemCtrl.LuuDiem(diem.HocSinh.MaHocSinh, diem.MonHoc.MaMonHoc, diem.HocKy.MaHocKy, diem.NamHoc.MaNamHoc, diem.Lop.MaLop, diem.LoaiDiem.MaLoai, diem.Diem); } lVDiem.Items.Clear(); MessageBoxEx.Show("Đã lưu vào bảng điểm!", "COMPLETED", MessageBoxButtons.OK, MessageBoxIcon.Information); }
private void simpleButtonLuu_Click(object sender, EventArgs e) { if (dGVDiem.RowCount == 0) { MessageBoxEx.Show("Chưa có học sinh!", "CHÚ Ý", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (KiemTraDiemTruocKhiLuu("colDiem") == true) { if (MsgboxUtil.YesNo("Bạn có chắc chắn muốn cập nhật không ?") == DialogResult.Yes) { if (STT != null) { int rowcount = 0; foreach (DataGridViewRow row in dGVDiem.Rows) { rowcount++; #region Kiểm tra miệng if (row.Cells["colDiem"].Value != null) { String chuoiDiemChuaXuLy = row.Cells["colDiem"].Value.ToString(); String diemDaXuLy = null; int count = 0; for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++) { if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1) { count++; } else { if (i == chuoiDiemChuaXuLy.Length - 1) { i++; count++; } diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count); if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy)) { m_DiemCtrl.LuuDiem(row.Cells["colMaQuaTrinhHoc"].Value.ToString(), cmbMonHoc.SelectedValue.ToString(), cmbLoaiDiem.SelectedValue.ToString(), float.Parse(diemDaXuLy.ToString())); } diemDaXuLy = null; count = 0; } } } #endregion #region Lưu vào bảng kết quả if (rowcount <= dGVDiem.Rows.Count) { m_BaoCaoTongKetMonCtrl.LuuKetQuaSD(row.Cells["colMaQuaTrinhHoc"].Value.ToString(), cmbMonHoc.SelectedValue.ToString()); m_BaoCaoTongKetMonCtrl.LuuKetQua1(cmbHocKy.SelectedValue.ToString(), cmbLop.SelectedValue.ToString(), cmbMonHoc.SelectedValue.ToString()); m_BaoCaoTongKetHocKyCtrl.LuuKetQua1(cmbHocKy.SelectedValue.ToString(), cmbLop.SelectedValue.ToString()); } #endregion #region Xóa các kết quả cũ if (STT != null) { for (int i = 1; i < 60; i++) { for (int j = 1; j < 20; j++) { int id = STT[i, j]; if (id > 0) { m_DiemCtrl.XoaBangDiem(id); // m_DiemCtrl.XoaDiem(id); } else { break; } } } } #endregion } MessageBoxEx.Show("Cập nhật thành công!", "COMPLETED", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } }
private void btnLuuDiem_Click(object sender, EventArgs e) { if (KiemTraDiemTruocKhiLuu("colDiemMieng") == true && KiemTraDiemTruocKhiLuu("colDiem15Phut") == true && KiemTraDiemTruocKhiLuu("colDiem45Phut") == true && KiemTraDiemTruocKhiLuu("colDiemThi") == true) { #region Nếu nhập điểm if (buttonItemNhapDuLieu.Checked == true && STT == null) { int rowcount = 0; foreach (DataGridViewRow row in dGVDiem.Rows) { rowcount++; #region Kiểm tra miệng if (row.Cells["colDiemMieng"].Value != null) { String chuoiDiemChuaXuLy = row.Cells["colDiemMieng"].Value.ToString(); String diemDaXuLy = null; int count = 0; for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++) { if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1) { count++; } else { if (i == chuoiDiemChuaXuLy.Length - 1) { i++; count++; } diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count); if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy)) { m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(), cmbMonHoc.SelectedValue.ToString(), cmbHocKy.SelectedValue.ToString(), cmbNamHoc.SelectedValue.ToString(), cmbLop.SelectedValue.ToString(), "LD0001", float.Parse(diemDaXuLy.ToString())); } diemDaXuLy = null; count = 0; } } } #endregion #region Kiểm tra 15 phút if (row.Cells["colDiem15Phut"].Value != null) { String chuoiDiemChuaXuLy = row.Cells["colDiem15Phut"].Value.ToString(); String diemDaXuLy = null; int count = 0; for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++) { if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1) { count++; } else { if (i == chuoiDiemChuaXuLy.Length - 1) { i++; count++; } diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count); if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy)) { m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(), cmbMonHoc.SelectedValue.ToString(), cmbHocKy.SelectedValue.ToString(), cmbNamHoc.SelectedValue.ToString(), cmbLop.SelectedValue.ToString(), "LD0002", float.Parse(diemDaXuLy.ToString())); } diemDaXuLy = null; count = 0; } } } #endregion #region Kiểm tra 45 phút if (row.Cells["colDiem45Phut"].Value != null) { String chuoiDiemChuaXuLy = row.Cells["colDiem45Phut"].Value.ToString(); String diemDaXuLy = null; int count = 0; for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++) { if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1) { count++; } else { if (i == chuoiDiemChuaXuLy.Length - 1) { i++; count++; } diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count); if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy)) { m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(), cmbMonHoc.SelectedValue.ToString(), cmbHocKy.SelectedValue.ToString(), cmbNamHoc.SelectedValue.ToString(), cmbLop.SelectedValue.ToString(), "LD0003", float.Parse(diemDaXuLy.ToString())); } diemDaXuLy = null; count = 0; } } } #endregion #region Thi học kỳ if (row.Cells["colDiemThi"].Value != null) { String diemThi = row.Cells["colDiemThi"].Value.ToString(); if (quyDinh.KiemTraDiem(diemThi)) { m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(), cmbMonHoc.SelectedValue.ToString(), cmbHocKy.SelectedValue.ToString(), cmbNamHoc.SelectedValue.ToString(), cmbLop.SelectedValue.ToString(), "LD0004", float.Parse(diemThi.ToString())); } } #endregion #region Lưu vào bảng kết quả if (rowcount <= dGVDiem.Rows.Count) { m_KQHocKyMonHocCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(), cmbLop.SelectedValue.ToString(), cmbMonHoc.SelectedValue.ToString(), cmbHocKy.SelectedValue.ToString(), cmbNamHoc.SelectedValue.ToString()); m_KQCaNamMonHocCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(), cmbLop.SelectedValue.ToString(), cmbMonHoc.SelectedValue.ToString(), cmbNamHoc.SelectedValue.ToString()); m_KQHocKyTongHopCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(), cmbLop.SelectedValue.ToString(), cmbHocKy.SelectedValue.ToString(), cmbNamHoc.SelectedValue.ToString()); m_KQCaNamTongHopCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(), cmbLop.SelectedValue.ToString(), cmbNamHoc.SelectedValue.ToString()); } #endregion } MessageBoxEx.Show("Đã lưu thành công vào bảng điểm!", "COMPLETED", MessageBoxButtons.OK, MessageBoxIcon.Information); } #endregion #region Nếu sửa điểm if (buttonItemCapNhatDuLieu.Checked == true || STT != null) { int rowcount = 0; foreach (DataGridViewRow row in dGVDiem.Rows) { rowcount++; #region Kiểm tra miệng if (row.Cells["colDiemMieng"].Value != null) { String chuoiDiemChuaXuLy = row.Cells["colDiemMieng"].Value.ToString(); String diemDaXuLy = null; int count = 0; for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++) { if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1) { count++; } else { if (i == chuoiDiemChuaXuLy.Length - 1) { i++; count++; } diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count); if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy)) { m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(), cmbMonHocSD.SelectedValue.ToString(), cmbHocKySD.SelectedValue.ToString(), cmbNamHocSD.SelectedValue.ToString(), cmbLopSD.SelectedValue.ToString(), "LD0001", float.Parse(diemDaXuLy.ToString())); } diemDaXuLy = null; count = 0; } } } #endregion #region Kiểm tra 15 phút if (row.Cells["colDiem15Phut"].Value != null) { String chuoiDiemChuaXuLy = row.Cells["colDiem15Phut"].Value.ToString(); String diemDaXuLy = null; int count = 0; for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++) { if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1) { count++; } else { if (i == chuoiDiemChuaXuLy.Length - 1) { i++; count++; } diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count); if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy)) { m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(), cmbMonHocSD.SelectedValue.ToString(), cmbHocKySD.SelectedValue.ToString(), cmbNamHocSD.SelectedValue.ToString(), cmbLopSD.SelectedValue.ToString(), "LD0002", float.Parse(diemDaXuLy.ToString())); } diemDaXuLy = null; count = 0; } } } #endregion #region Kiểm tra 45 phút if (row.Cells["colDiem45Phut"].Value != null) { String chuoiDiemChuaXuLy = row.Cells["colDiem45Phut"].Value.ToString(); String diemDaXuLy = null; int count = 0; for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++) { if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1) { count++; } else { if (i == chuoiDiemChuaXuLy.Length - 1) { i++; count++; } diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count); if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy)) { m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(), cmbMonHocSD.SelectedValue.ToString(), cmbHocKySD.SelectedValue.ToString(), cmbNamHocSD.SelectedValue.ToString(), cmbLopSD.SelectedValue.ToString(), "LD0003", float.Parse(diemDaXuLy.ToString())); } diemDaXuLy = null; count = 0; } } } #endregion #region Thi học kỳ if (row.Cells["colDiemThi"].Value != null) { String diemThi = row.Cells["colDiemThi"].Value.ToString(); if (quyDinh.KiemTraDiem(diemThi)) { m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(), cmbMonHocSD.SelectedValue.ToString(), cmbHocKySD.SelectedValue.ToString(), cmbNamHocSD.SelectedValue.ToString(), cmbLopSD.SelectedValue.ToString(), "LD0004", float.Parse(diemThi.ToString())); } } #endregion #region Lưu vào bảng kết quả if (rowcount <= dGVDiem.Rows.Count) { m_KQHocKyMonHocCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(), cmbLopSD.SelectedValue.ToString(), cmbMonHocSD.SelectedValue.ToString(), cmbHocKySD.SelectedValue.ToString(), cmbNamHocSD.SelectedValue.ToString()); m_KQCaNamMonHocCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(), cmbLopSD.SelectedValue.ToString(), cmbMonHocSD.SelectedValue.ToString(), cmbNamHocSD.SelectedValue.ToString()); m_KQHocKyTongHopCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(), cmbLopSD.SelectedValue.ToString(), cmbHocKySD.SelectedValue.ToString(), cmbNamHocSD.SelectedValue.ToString()); m_KQCaNamTongHopCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(), cmbLopSD.SelectedValue.ToString(), cmbNamHocSD.SelectedValue.ToString()); } #endregion #region Xóa các kết quả cũ if (STT != null) { for (int i = 1; i < 60; i++) { for (int j = 1; j < 20; j++) { int id = STT[i, j]; if (id > 0) { m_DiemCtrl.XoaDiem(id); } else { break; } } } } #endregion } MessageBoxEx.Show("Cập nhật thành công!", "COMPLETED", MessageBoxButtons.OK, MessageBoxIcon.Information); } #endregion } }
private void simpleButtonLuu_Click(object sender, EventArgs e) { if (dGVDiem.RowCount == 0) { MessageBoxEx.Show("Chưa có học sinh!", "CHÚ Ý", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (cmbHocKy.SelectedValue == null) { MessageBoxEx.Show("Bạn chưa chọn học kỳ!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (cmbLop.SelectedValue == null) { MessageBoxEx.Show("Bạn chưa chọn lớp!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (cmbMonHoc.SelectedValue == null) { MessageBoxEx.Show("Bạn chưa chọn môn học!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (KiemTraDiemTruocKhiLuu("colDiem") == true) { if (MsgboxUtil.YesNo("Bạn có chắc chắn muốn lưu không ?") == DialogResult.Yes) { if (STT == null) { int rowcount = 0; foreach (DataGridViewRow row in dGVDiem.Rows) { rowcount++; if (row.Cells["colDiem"].Value != null) { String chuoiDiemChuaXuLy = row.Cells["colDiem"].Value.ToString(); String diemDaXuLy = null; int count = 0; for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++) { if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1) { count++; } else { if (i == chuoiDiemChuaXuLy.Length - 1) { i++; count++; } diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count); if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy)) { m_DiemCtrl.LuuDiem(row.Cells["colMaQuaTrinhHoc"].Value.ToString(), cmbMonHoc.SelectedValue.ToString(), cmbLoaiDiem.SelectedValue.ToString(), float.Parse(diemDaXuLy.ToString())); } diemDaXuLy = null; count = 0; } } } if (rowcount <= dGVDiem.Rows.Count) { m_BaoCaoTongKetMonCtrl.LuuKetQua(row.Cells["colMaQuaTrinhHoc"].Value.ToString(), cmbMonHoc.SelectedValue.ToString()); m_BaoCaoTongKetHocKyCtrl.LuuKetQua(row.Cells["colMaQuaTrinhHoc"].Value.ToString()); } } m_BaoCaoTongKetMonCtrl.LuuKetQua1(cmbHocKy.SelectedValue.ToString(), cmbLop.SelectedValue.ToString(), cmbMonHoc.SelectedValue.ToString()); m_BaoCaoTongKetHocKyCtrl.LuuKetQua1(cmbHocKy.SelectedValue.ToString(), cmbLop.SelectedValue.ToString()); } MessageBoxEx.Show("Đã lưu thành công!", "Thành Công", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { return; } } }