private void gridLop_Click(object sender, EventArgs e)
{
try
{
var temp = BangDiemLogic.SelectDetail(GlobalSettings.UserID, O2S_Common.TypeConvert.Parse.ToInt32(gridLop.SelectedRows[0].Cells["clmLopHocId"].Value.ToString()));
lblTenLop.Text = temp.TenLopHoc;
lblMaLop.Text = temp.LopHocId.ToString();
lblTenKhoaHoc.Text = temp.TenKhoaHoc;
lblNgayBD.Text = temp.NgayBatDau.Value.ToShortDateString();
lblNgayKT.Text = temp.NgayKetThuc.Value.ToShortDateString();
lblSiSo.Text = temp.SiSo.ToString();
lblTinhTrang.Text = (bool)temp.DangMo ? "Đang mở" : "Đã đóng";
lblDiemTB.Text = temp.DiemTrungBinh.ToString();
}
catch
{
lblTenLop.Text = string.Empty;
lblMaLop.Text = string.Empty;
lblTenKhoaHoc.Text = string.Empty;
lblNgayBD.Text = string.Empty;
lblNgayKT.Text = string.Empty;
lblSiSo.Text = string.Empty;
lblTinhTrang.Text = string.Empty;
lblDiemTB.Text = string.Empty;
}
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
try
{
if (cboLopHoc.SelectedValue != null)
{
int _lophocid = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
this.lstBangDiem = BangDiemLogic.SelectTheoDoiBangDiemLop(_lophocid);
if (this.lstBangDiem != null && this.lstBangDiem.Count > 0)
{
for (int i = 0; i < this.lstBangDiem.Count; i++)
{
this.lstBangDiem[i].Stt = i + 1;
}
gridControlDSPhieuGhiDanh.DataSource = this.lstBangDiem;
}
else
{
gridControlDSPhieuGhiDanh.DataSource = null;
}
}
else
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.VUI_LONG_NHAP_DAY_DU_THONG_TIN);
frmthongbao.Show();
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
SplashScreenManager.CloseForm();
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
gridLop.DataSource = BangDiemLogic.SelectDSLop(GlobalSettings.UserID, rdKhoangThoiGian.Checked ? (DateTime?)DateTime.ParseExact(dateTuNgay.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture) : null,
rdKhoangThoiGian.Checked ? (DateTime?)DateTime.ParseExact(dateDenNgay.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture) : null, rdKhoaHoc.Checked ? O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString()) : 0);
gridLop_Click(sender, e);
}
private void gridLop_Click(object sender, EventArgs e)
{
try
{
var f = BangDiemLogic.Select(GlobalSettings.UserID, O2S_Common.TypeConvert.Parse.ToInt32(gridLop.SelectedRows[0].Cells["clmLopHocId"].Value.ToString()));
lblTenLop.Text = f.LOPHOC.TenLopHoc;
lblMaLop.Text = f.LopHocId.ToString();
lblTenKhoaHoc.Text = f.LOPHOC.KHOAHOC.TenKhoaHoc;
lblNgayBD.Text = f.LOPHOC.NgayBatDau.Value.ToShortDateString();
lblNgayKT.Text = f.LOPHOC.NgayKetThuc.Value.ToShortDateString();
lblSiSo.Text = f.LOPHOC.SiSo.ToString();
lblDaDong.Text = ((decimal)f.PHIEUGHIDANH.DaDong).ToString("C0");
lblConNo.Text = ((decimal)f.PHIEUGHIDANH.ConNo).ToString("C0");
lblTongNoTatCa.Text = BangDiemLogic.TongNoCacLop(GlobalSettings.UserID).ToString("C0");
}
catch
{
lblTenLop.Text = string.Empty;
lblMaLop.Text = string.Empty;
lblTenKhoaHoc.Text = string.Empty;
lblNgayBD.Text = string.Empty;
lblNgayKT.Text = string.Empty;
lblSiSo.Text = string.Empty;
lblDaDong.Text = string.Empty;
lblConNo.Text = string.Empty;
lblTongNoTatCa.Text = string.Empty;
}
}
private void btnLuuLop_Click(object sender, EventArgs e)
{
try
{
//insert + Xoa tai BANGDIEM
int _LopHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
foreach (var item in this.dsXepLopHocVien)
{
//kiem tra ton tai hay khong
List <BANGDIEM> _kiemtratontai = BangDiemLogic.SelectTheoPhieuGhiDanh(item.PhieuGhiDanhId ?? 0);
if (_kiemtratontai == null || _kiemtratontai.Count == 0)
{
BANGDIEM _bangdiem = new BANGDIEM();
_bangdiem.HocVienId = item.HocVienId ?? 0;
_bangdiem.LopHocId = _LopHocId;
_bangdiem.PhieuGhiDanhId = item.PhieuGhiDanhId ?? 0;
_bangdiem.KhoaHocId = item.KhoaHocId ?? 0;
_bangdiem.TrangThai = 0;//=0: xep lop; =1: dang hoc; =3: co diem; =99:ket thuc
BangDiemLogic.Insert(_bangdiem);
}
}
List <BANGDIEM> _lstBangDiem_LopHoc = BangDiemLogic.SelectTheoLopHoc(_LopHocId);
if (_lstBangDiem_LopHoc != null && _lstBangDiem_LopHoc.Count > 0)
{
List <BANGDIEM> _bangdiem_Xoa = (from p in _lstBangDiem_LopHoc
where !(from q in this.dsXepLopHocVien select q.PhieuGhiDanhId).Contains(p.PhieuGhiDanhId)
select p).ToList();
if (_bangdiem_Xoa != null && _bangdiem_Xoa.Count > 0)
{
BangDiemLogic.DeleteList(_bangdiem_Xoa);
}
}
//Update SiSo cua LOPHOC
LOPHOC _lophoc = LopHocLogic.SelectSingle(_LopHocId);
LopHocLogic.Update(new LOPHOC()
{
LopHocId = _lophoc.LopHocId,
TenLopHoc = _lophoc.TenLopHoc,
NgayBatDau = _lophoc.NgayBatDau,
NgayKetThuc = _lophoc.NgayKetThuc,
SiSoToiDa = _lophoc.SiSoToiDa,
SiSo = this.dsXepLopHocVien.Count,
KhoaHocId = _lophoc.KhoaHocId,
IsLock = _lophoc.IsLock
});
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THANH_CONG);
frmthongbao.Show();
}
catch (Exception ex)
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THAT_BAI);
frmthongbao.Show();
O2S_Common.Logging.LogSystem.Error(ex);
}
}
private void ValidateXoaPhieuGhiDanh(int _PhieuGhiDanhId)
{
List <BANGDIEM> _bangdiem = BangDiemLogic.SelectTheoPhieuGhiDanh(_PhieuGhiDanhId);
if (_bangdiem != null && _bangdiem.Count > 0)
{
throw new ArgumentException("Học viên đã được xếp lớp nên không thể xóa được.");
}
}
private void btnInAn_DSLop_Click(object sender, EventArgs e)
{
try
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
if (cboLopHoc.SelectedValue != null)
{
List <reportExcelDTO> thongTinThem = new List <reportExcelDTO>();
//khoa hoc, lop hoc
int _KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString());
KHOAHOC _khoahoc = KhoaHocLogic.SelectSingle(_KhoaHocId);
int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
LOPHOC _lophoc = LopHocLogic.SelectSingle(_lophocId);
reportExcelDTO _item_makhoahoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.MAKHOAHOC,
value = _khoahoc.MaKhoaHoc,
};
thongTinThem.Add(_item_makhoahoc);
reportExcelDTO _item_tenkhoahoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.TENKHOAHOC,
value = _khoahoc.TenKhoaHoc,
};
thongTinThem.Add(_item_tenkhoahoc);
//
reportExcelDTO _item_malophoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.MALOPHOC,
value = _lophoc.MaLopHoc,
};
thongTinThem.Add(_item_malophoc);
reportExcelDTO _item_tenlophoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.TENLOPHOC,
value = _lophoc.TenLopHoc,
};
thongTinThem.Add(_item_tenlophoc);
List <XepLopDTO> _lstXepLop = BangDiemLogic.SelectDSHV_Lop(_lophocId);
string fileTemplatePath = "FUN_XepLop_DanhSachLopHoc.xlsx";
DataTable _databaocao = O2S_Common.DataTables.Convert.ListToDataTable(_lstXepLop);
Utilities.Prints.PrintPreview.ShowPrintPreview_UsingExcelTemplate(fileTemplatePath, thongTinThem, _databaocao);
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
SplashScreenManager.CloseForm();
}
private void ValidateSuaKhoaHoc(int _KhoaHocId)
{
//kiem tra neu khóa học đã có trong BANGDIEM thì không cho sửa
BangDiemFilter _filter = new BangDiemFilter();
_filter.KhoaHocId = _KhoaHocId;
List <BANGDIEM> _lstBangDiem = BangDiemLogic.SelectFilter(_filter);
if (_lstBangDiem != null && _lstBangDiem.Count > 0)
{
throw new ArgumentException("Khóa học đã được sử dụng nên không thể sửa");
}
}
/// <summary>
/// Nạp bảng điểm lên giao diện
/// </summary>
/// <param name="maHV">Mã học viên</param>
/// <param name="maLop">Mã lớp</param>
public void LoadBangDiem(int maHV, int maLop)
{
try
{
var bangDiem = BangDiemLogic.SelectDetail(maHV, maLop);
lblTenLop.Text = bangDiem.TenLopHoc;
lblTenKhoaHocoa.Text = bangDiem.TenKhoaHoc;
lblDiemTrungBinh.Text = (bangDiem.DiemTrungBinh ?? 0).ToString("N2");
gridControlDSDiem.DataSource = bangDiem.BangDiemChiTiets;
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void frmBangDiem_Load(object sender, EventArgs e)
{
lblTitle.Text = string.Format("Bảng điểm của {0}", TaiKhoanLogic.FullUserName(new TAIKHOAN()
{
TenDangNhap = GlobalSettings.UserCode
}));
cboLop.DataSource = BangDiemLogic.SelectDSLop(GlobalSettings.UserID);
cboLop.DisplayMember = "TenLopHoc";
cboLop.ValueMember = "LopHocId";
lblTenLop.Text = lblTenKhoaHocoa.Text = string.Empty;
lblDiemTrungBinh.Text = 0.ToString();
isLoaded = true;
cboLop_SelectedValueChanged(sender, e);
}
public void LoadDSHVCuaLop()
{
try
{
if (cboLopHoc.SelectedValue != null)
{
int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
List <XepLopDTO> _dsXepLopHocVien = BangDiemLogic.SelectDSHV_Lop(_lophocId);
gridControlDSHV.DataSource = _dsXepLopHocVien;
}
else
{
gridControlDSHV.DataSource = null;
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void btnLuuThongTin_Click(object sender, EventArgs e)
{
try
{
if (BangDiemLogic.UpdateFull(this.bangDiemFull_Click))
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THANH_CONG);
frmthongbao.Show();
}
else
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THAT_BAI);
frmthongbao.Show();
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
}
public void LoadDSHVLopChuaDu()
{
try
{
if (cboLopHoc.SelectedValue != null)
{
int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
this.dsXepLopHocVien = BangDiemLogic.SelectDSHV_Lop(_lophocId);
gridControlHV_XepLop.DataSource = this.dsXepLopHocVien;
}
else
{
gridControlHV_XepLop.DataSource = null;
}
lblTongCongHVLop.Text = string.Format("Tổng cộng: {0} học viên", gridViewHV_XepLop.RowCount);
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
public void LoadPanelDiem(int _hocvienId, int _lophocId)
{
//List<BangDiemChiTietDTO> _lstBangDiem = new List<BangDiemChiTietDTO>();
this.bangDiemFull_Click = BangDiemLogic.SelectDetail(_hocvienId, _lophocId);
lblMaLop.Text = this.bangDiemFull_Click.TenLopHoc;
lblTenLop.Text = this.bangDiemFull_Click.TenLopHoc;
lblKhoa.Text = this.bangDiemFull_Click.TenKhoaHoc;
lblMaHV.Text = this.bangDiemFull_Click.MaHocVien;
lblTenHocVien.Text = this.bangDiemFull_Click.TenHocVien;
////load Danh sach diem
//foreach (var item in this.bangDiemFull_Click.BangDiemChiTiets)
//{
// BangDiemChiTietDTO _bangdiem = new BangDiemChiTietDTO();
// _bangdiem.BangDiemChiTietId = item.BangDiemChiTietId; ;
// _bangdiem.BangDiemId = this.bangDiemFull_Click.BangDiemId;
// _bangdiem.MaMonHoc = item.MaMonHoc;
// _bangdiem.TenMonHoc = item.TenMonHoc;
// _bangdiem.Diem = item.Diem ?? 0;
// _lstBangDiem.Add(_bangdiem);
//}
gridControlDSDiem.DataSource = this.bangDiemFull_Click.BangDiemChiTiets;
}
private void btnXemTatCa_Click(object sender, EventArgs e)
{
gridLop.DataSource = BangDiemLogic.SelectDSLop(GlobalSettings.UserID, null, null, 0);
gridLop_Click(sender, e);
}
