void trlLop_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
DM_LopInfo pDM_LopInfo = uctrlLop.GetNodeSelected();
if (pDM_LopInfo != null)
{
IDDM_Lop = pDM_LopInfo.DM_LopID;
// load sinh vien
if (rdSinhVien.SelectedIndex == 0)
{
dtSinhVien = oBKQHT_DangKyHocLai.GetSinhVien(IDDM_Lop, 0, 0, IDDM_MonHoc, Program.IDNamHoc, Program.HocKy, 0);
dtSinhVien.DefaultView.RowFilter = "Diem <5";
grdSinhVien.DataSource = dtSinhVien.DefaultView;
}
else
{
dtSinhVien = oBKQHT_DangKyHocLai.GetSinhVien(IDDM_Lop, 0, 0, IDDM_MonHoc, Program.IDNamHoc, Program.HocKy, 0);
grdSinhVien.DataSource = dtSinhVien;
}
btnCapNhat.Enabled = true;
}
else
{
btnCapNhat.Enabled = false;
}
}
void trlLop_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
pDM_LopInfo = uctrlLop.GetNodeSelected();
if (pDM_LopInfo != null)
{
dtSinhVien = oBTC_DanhSachHocBong.GetNotInSinhVien(pDM_LopInfo, Program.IDNamHoc, Program.HocKy, Program.NamHoc,
"" + chkRenLuyen.EditValue, txtDiemTBC.Text == "" ? 0 : double.Parse(txtDiemTBC.Text));
string HoDem = "";
foreach (DataRow dr in dtSinhVien.Rows)
{
dr["TenSV"] = GetTen(dr["HoVaTen"].ToString(), ref HoDem);
dr["HoVa"] = HoDem;
}
grdSinhVien.DataSource = dtSinhVien;
dtTroCap = oBTC_DanhSachHocBong.GetInSinhVien(pDM_LopInfo, Program.IDNamHoc, Program.HocKy);
foreach (DataRow dr in dtTroCap.Rows)
{
dr["TenSV"] = GetTen(dr["HoVaTen"].ToString(), ref HoDem);
dr["HoVa"] = HoDem;
}
grdTroCap.DataSource = dtTroCap;
strID = "";
}
else
{
grdSinhVien.DataSource = null;
grdTroCap.DataSource = null;
strID = "";
}
}
void trlLop_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
pDM_LopInfo = uctrlLop.GetNodeSelected();
IsLoadMonNhapDiem = false;
LoadMonHocNhapDiem();
grvMonHoc_FocusedRowChanged(null, null);
}
public DataTable GetDanhSachLop(DM_LopInfo pDM_LopInfo, string NamHoc)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <DM_LopInfo>(client.cDDM_Lop_GetDanhSachLop(GlobalVar.MaXacThuc, pDM_LopInfo, NamHoc)));
}
}
public DataTable GetTongHopXepLoai(DM_LopInfo pDM_LopInfo, string NamHoc, int IDDM_NamHoc, int HocKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <DM_LopInfo>(client.cDDM_Lop_GetTongHopXepLoai(GlobalVar.MaXacThuc, pDM_LopInfo, NamHoc, IDDM_NamHoc, HocKy)));
}
}
public DM_LopInfo GetDM_LopInfo()
{
DM_LopInfo pDM_LopInfo = new DM_LopInfo();
if (cmbHe.EditValue != null)
{
pDM_LopInfo.IDDM_He = int.Parse(cmbHe.EditValue.ToString());
}
if (cmbTrinhDo.EditValue != null)
{
pDM_LopInfo.IDDM_TrinhDo = int.Parse(cmbTrinhDo.EditValue.ToString());
}
if (cmbKhoa.EditValue != null)
{
pDM_LopInfo.IDDM_Khoa = int.Parse(cmbKhoa.EditValue.ToString());
}
if (cmbKhoaHoc.EditValue != null)
{
pDM_LopInfo.IDDM_KhoaHoc = int.Parse(cmbKhoaHoc.EditValue.ToString());
}
if (cmbNganh.EditValue != null)
{
pDM_LopInfo.IDDM_Nganh = int.Parse(cmbNganh.EditValue.ToString());
}
if (cmbLop.EditValue != null)
{
pDM_LopInfo.DM_LopID = int.Parse(cmbLop.EditValue.ToString());
}
return(pDM_LopInfo);
}
//public DataTable Get(DM_LopInfo pDM_LopInfo)
//{
// using (var client = new UnimOsServiceClient())
// {
// return ConvertList.ToDataTable<DM_LopInfo>(client.cDDM_Lop_Get(GlobalVar.MaXacThuc, pDM_LopInfo));
// }
//}
//public string GetTenLop(int DM_LopID)
//{
// oDM_LopInfo = new DM_LopInfo();
// oDM_LopInfo.DM_LopID = DM_LopID;
// DataTable dt = Get(oDM_LopInfo);
// if (dt.Rows.Count > 0)
// return dt.Rows[0]["TenLop"].ToString();
// return "";
//}
public DataTable GetLopGop(DM_LopInfo pDM_LopInfo, int IDDM_MonHoc, string NamHoc)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_Lop_GetLopGopResult>(client.cDDM_Lop_GetLopGop(GlobalVar.MaXacThuc, pDM_LopInfo, IDDM_MonHoc, NamHoc)));
}
}
public List <DM_LopInfo> GetList(DM_LopInfo pDM_LopInfo)
{
List <DM_LopInfo> oDM_LopInfoList = new List <DM_LopInfo>();
DataTable dtb = Get(pDM_LopInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_LopInfo = new DM_LopInfo();
oDM_LopInfo.DM_LopID = int.Parse(dtb.Rows[i]["DM_LopID"].ToString());
oDM_LopInfo.TenLop = dtb.Rows[i]["TenLop"].ToString();
oDM_LopInfo.IDDM_He = int.Parse(dtb.Rows[i]["IDDM_He"].ToString());
oDM_LopInfo.IDDM_TrinhDo = int.Parse(dtb.Rows[i]["IDDM_TrinhDo"].ToString());
oDM_LopInfo.IDDM_Khoa = int.Parse(dtb.Rows[i]["IDDM_Khoa"].ToString());
oDM_LopInfo.IDDM_Nganh = int.Parse(dtb.Rows[i]["IDDM_Nganh"].ToString());
oDM_LopInfo.IDDM_ChuyenNganh = int.Parse(dtb.Rows[i]["IDDM_ChuyenNganh"].ToString());
oDM_LopInfo.NienKhoa = dtb.Rows[i]["NienKhoa"].ToString();
oDM_LopInfo.IDDM_KhoaHoc = int.Parse(dtb.Rows[i]["IDDM_KhoaHoc"].ToString());
oDM_LopInfo.SoSinhVien = int.Parse(dtb.Rows[i]["SoSinhVien"].ToString());
oDM_LopInfo.NgayVao = DateTime.Parse(dtb.Rows[i]["NgayVao"].ToString());
oDM_LopInfo.NgayRa = DateTime.Parse(dtb.Rows[i]["NgayRa"].ToString());
oDM_LopInfo.DaRaTruong = bool.Parse(dtb.Rows[i]["DaRaTruong"].ToString());
oDM_LopInfo.IDDM_TruongLienKet = int.Parse(dtb.Rows[i]["IDDM_TruongLienKet"].ToString());
oDM_LopInfo.XepThoiKhoaBieu = bool.Parse(dtb.Rows[i]["XepThoiKhoaBieu"].ToString());
oDM_LopInfo.KieuLopTachGop = int.Parse(dtb.Rows[i]["KieuLopTachGop"].ToString());
oDM_LopInfoList.Add(oDM_LopInfo);
}
}
return(oDM_LopInfoList);
}
public DataTable GetSinhVien(DM_LopInfo pDM_LopInfo, string NamHoc, bool ChuaTaoMa)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <SV_SinhVienInfo>(client.cDSV_SinhVien_GetSinhVien(GlobalVar.MaXacThuc, pDM_LopInfo, NamHoc, ChuaTaoMa)));
}
}
void trlLop_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
pDM_LopInfo = uctrlLop.GetNodeSelected();
if (pDM_LopInfo != null)
{
if (pDM_LopInfo.DM_LopID > 0)
{
grcLop.Visible = false;
}
else
{
grcLop.Visible = true;
}
dtThang = oBTC_DanhSachHocBong.GetThangInSinhVien(pDM_LopInfo, Program.IDNamHoc, Program.HocKy, Program.NamHoc);
cmbThang.Properties.DataSource = dtThang;
if (dtThang.Rows.Count > 0)
{
cmbThang.ItemIndex = 0;
}
Loaded = false;
cmbThang_EditValueChanged(null, null);
}
else
{
cmbThang.Properties.DataSource = null;
grdHocBong.DataSource = null;
}
}
public DataTable GetKeHoachToanTruong(int IDNamHoc, string NamHoc, DM_LopInfo pDM_LopInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <DM_LopInfo>(client.cDDM_Lop_GetKeHoachToanTruong(GlobalVar.MaXacThuc, IDNamHoc, NamHoc, pDM_LopInfo)));
}
}
public dlgChonLop(bool _MultiCheck)
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
MultiCheck = _MultiCheck;
}
public frmLopHoc()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
LoadCombo();
}
public DataTable GetDiemThucTapTotNghiep(DM_LopInfo pDM_LopInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <KQHT_DiemTongKetMonInfo>(client.cDKQHT_DiemTongKetMon_GetDiemThucTapTotNghiep(GlobalVar.MaXacThuc, pDM_LopInfo)));
}
}
public frmLapMaSinhVien()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBSV_SinhVien = new cBSV_SinhVien();
pDM_LopInfo = new DM_LopInfo();
}
public frmThongKeSVTheoLop()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
pSV_SinhVienInfo = new SV_SinhVienInfo();
oBSV_SinhVien = new cBSV_SinhVien();
oBKQHT_DanhSachNgungHoc = new cBKQHT_DanhSachNgungHoc();
//repositoryItemLookUpEditGioiTinh.DataSource = LoadGioiTinhSV();
//cboDanhSachHienThi.
_grCols = new Dictionary <int, GridColumn>()
{
{ 0, tl },
{ 1, g1 },
{ 2, g2 },
{ 3, g3 },
{ 4, g4 },
{ 5, g5 },
{ 6, g6 },
{ 7, g7 },
{ 8, g8 },
{ 9, g9 },
{ 10, g10 },
{ 11, g11 },
{ 12, g12 }
};
}
void trlLop_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
pDM_LopInfo = uctrlLop.GetNodeSelected();
if (pDM_LopInfo != null)
{
IDDM_Lop = pDM_LopInfo.DM_LopID;
DataTable dtCTDT = oBDM_Lop.GetChuongTrinhDaoTao(IDDM_Lop);
if (dtCTDT.Rows.Count > 0)
{
IDKQHT_ChuongTrinhDaoTao = int.Parse("0" + dtCTDT.Rows[0]["IDKQHT_ChuongTrinhDaoTao"]);
}
else
{
IDKQHT_ChuongTrinhDaoTao = 0;
}
if (IDKQHT_ChuongTrinhDaoTao != 0)
{
FillKy(cmbKyKhung, int.Parse("0" + dtCTDT.Rows[0]["SoHocKy"]));
HocKy = GetKyThuFromHocKy(dtCTDT.Rows[0]["NienKhoa"].ToString());
cmbKyKhung.EditValue = HocKy;
if (cmbKyKhung.EditValue.ToString() == HocKy.ToString())
{
cmbKyKhung_SelectedValueChanged(null, null);
}
LoadMonKy(IDDM_Lop);
}
else if (pDM_LopInfo.DM_LopID > 0)
{
grdMonKy.DataSource = null;
grdMonKhung.DataSource = null;
ThongBao("Lớp này chưa có chương trình đào tạo.");
}
}
}
public DataTable GetTongHop(DM_LopInfo pDM_LopInfo, int IDDM_NamHoc, int IDTC_LoaiThuChi, int HocKy, int IDTC_QuyenHoaDon, bool TongHopTuDau)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <TC_BienLaiThuTienInfo>(client.cDTC_BienLaiThuTien_GetTongHop(GlobalVar.MaXacThuc, pDM_LopInfo, IDDM_NamHoc, IDTC_LoaiThuChi, HocKy, IDTC_QuyenHoaDon, TongHopTuDau)));
}
}
public dlgMoKeHoach()
{
InitializeComponent();
clsIni = new Lib.Ini(Application.StartupPath + "\\truongviet.ini");
this.DialogResult = DialogResult.Cancel;
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
}
public frmLop_MonThiTotNghiep()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
oBKQHT_MonThiTotNghiep_Lop = new cBKQHT_MonThiTotNghiep_Lop();
pKQHT_MonThiTotNghiep_LopInfo = new KQHT_MonThiTotNghiep_LopInfo();
}
public void Delete(DM_LopInfo pDM_LopInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_LopID", SqlDbType.Int, pDM_LopInfo.DM_LopID));
RunProcedure("sp_DM_Lop_Delete", colParam);
}
public DataTable Get(DM_LopInfo pDM_LopInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_LopID", SqlDbType.Int, pDM_LopInfo.DM_LopID));
return(RunProcedureGet("sp_DM_Lop_Get", colParam));
}
public frmDoiTuongTroCapSinhVien()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
oBSV_DoiTuongTroCap = new cBSV_DoiTuongTroCap();
pSV_DoiTuongTroCapInfo = new SV_DoiTuongTroCapInfo();
}
public frmDoiTuongMienGiamSinhVien()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
oBSV_DoiTuongMienGiam = new cBSV_DoiTuongMienGiam();
pSV_DoiTuongMienGiamInfo = new SV_DoiTuongMienGiamInfo();
}
void trlLop_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
pDM_LopInfo = uctrlLop.GetNodeSelected();
if (pDM_LopInfo.DM_LopID > 0)
{
webBrowserLop.DocumentText = GenHTML(pDM_LopInfo.DM_LopID);
}
}
public frmTietNghiCoDinhLop()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
pXL_TietNghiCoDinhLopInfo = new XL_TietNghiCoDinhLopInfo();
oBXL_TietNghiCoDinhLop = new cBXL_TietNghiCoDinhLop();
}
public frmTongHopChiHocBong()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBSV_SinhVien = new cBSV_SinhVien();
pDM_LopInfo = new DM_LopInfo();
oBTC_DanhSachHocBong = new cBTC_DanhSachHocBong();
}
public frmTKB_Print()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
oBXL_SuKienTKB = new cBXL_SuKienTKB();
}
public frmBaoCaoDanhSachMienGiam()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBSV_SinhVien = new cBSV_SinhVien();
pDM_LopInfo = new DM_LopInfo();
oBTC_DinhMucThuSinhVien = new cBTC_DinhMucThuSinhVien();
}
public dlgLocSinhVien(dlgBienLaiThuTienChiTiet mdlg, string mMaSinhVien)
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBSV_SinhVien = new cBSV_SinhVien();
pDM_LopInfo = new DM_LopInfo();
dlg = mdlg;
MaSinhVien = mMaSinhVien;
}
