private void LayDanhSachHocVien()
{
try
{
HocVienFilter _filter = new HocVienFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
_filter.LoaiHocVienId = KeySetting.LOAIHOCVIEN_CHOLOP;
_filter.NgayTiepNhan_Tu = date_TuNgay.DateTime;
_filter.NgayTiepNhan_Den = date_DenNgay.DateTime;
this.lstHocVien = HocVienLogic.Select(_filter);
if (this.lstHocVien != null && this.lstHocVien.Count > 0)
{
for (int i = 0; i < this.lstHocVien.Count; i++)
{
this.lstHocVien[i].Stt = i + 1;
}
gridControlDSHocVien.DataSource = this.lstHocVien;
}
else
{
gridControlDSHocVien.DataSource = null;
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void LayDanhSachHocVien()
{
try
{
HocVienFilter _filter = new HocVienFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
_filter.LoaiHocVienId = KeySetting.LOAIHOCVIEN_CHINHTHUC;
_filter.NgayTiepNhan_Tu = date_TuNgay.DateTime;
_filter.NgayTiepNhan_Den = date_DenNgay.DateTime;
this.lstHocVien = HocVienLogic.SelectQuanLyHocVien(_filter);
if (this.lstHocVien != null && this.lstHocVien.Count > 0)
{
for (int i = 0; i < this.lstHocVien.Count; i++)
{
this.lstHocVien[i].Stt = i + 1;
}
gridControlDSHocVien.DataSource = this.lstHocVien;
}
else
{
gridControlDSHocVien.DataSource = null;
}
lblTongCong.Text = string.Format("Tổng cộng: {0} học viên", gridViewDSHocVien.RowCount);
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void LoadDanhSachHocVien()
{
try
{
gridControlDSHocVien.DataSource = null;
//Thread th = new Thread(() =>
//{
HocVienFilter _filter = new HocVienFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
_filter.NgayTiepNhan_Tu = date_TuNgay.DateTime;
_filter.NgayTiepNhan_Den = date_DenNgay.DateTime;
List <HocVien_PlusDTO> _lstHocVien = HocVienLogic.Select(_filter);
if (_lstHocVien != null && _lstHocVien.Count > 0)
{
//gridControlDSHocVien.Invoke((MethodInvoker)delegate
//{
gridControlDSHocVien.DataSource = _lstHocVien;
lblTongCong.Text = string.Format("Tổng cộng: {0} học viên ({1} học viên chính thức; {2} học viên tiềm năng; {3} học viên chờ lớp)", _lstHocVien.Count, _lstHocVien.Where(o => o.LoaiHocVienId == KeySetting.LOAIHOCVIEN_CHINHTHUC).ToList().Count, _lstHocVien.Where(o => o.LoaiHocVienId == KeySetting.LOAIHOCVIEN_TIEMNANG).ToList().Count, _lstHocVien.Where(o => o.LoaiHocVienId == KeySetting.LOAIHOCVIEN_CHOLOP).ToList().Count);
//});
}
else
{
gridControlDSHocVien.DataSource = null;
lblTongCong.Text = string.Format("Tổng cộng: {0} học viên ({1} học viên chính thức; {2} học viên tiềm năng; {3} học viên chờ lớp)", 0, 0, 0);
}
//});
//th.Start();
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
try
{
HocVienFilter _filter = new HocVienFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
_filter.NgayTiepNhan_Tu = date_TuNgay.DateTime;
_filter.NgayTiepNhan_Den = date_DenNgay.DateTime;
this._lstHocVien = HocVienLogic.Select(_filter);
if (this._lstHocVien != null && this._lstHocVien.Count > 0)
{
gridControlDSHocVien.DataSource = this._lstHocVien;
}
else
{
gridControlDSHocVien.DataSource = null;
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
SplashScreenManager.CloseForm();
}
private void LoadDanhSachHocVien()
{
thHocVien = new Thread(() =>
{
//thPhieuGhiDanh.Join();
HocVienFilter _filter = new HocVienFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
_filter.NgayTiepNhan_Tu = date_TuNgay.DateTime;
_filter.NgayTiepNhan_Den = date_DenNgay.DateTime;
object source = HocVienLogic.Select(_filter);
gridControlDSHocVien.Invoke((MethodInvoker) delegate
{
gridControlDSHocVien.DataSource = source;
});
});
thHocVien.Start();
}
public static List <HocVien_PlusDTO> Select(HocVienFilter _filter)
{
try
{
//GlobalSettings.NewDatacontexDatabase();
// List<HocVien_PlusDTO> _result = null;
var query = (from p in GlobalSettings.Database.HOCVIENs
select p).AsEnumerable().Select((obj, index) => new HocVien_PlusDTO
{
Stt = index + 1,
HocVienId = obj.HocVienId,
CoSoId = obj.CoSoId,
TenCoSoTrungTam = obj.COSOTRUNGTAM.TenCoSo,
LoaiHocVienId = obj.LoaiHocVienId,
MaLoaiHocVien = obj.LOAIHOCVIEN.MaLoaiHocVien,
TenLoaiHocVien = obj.LOAIHOCVIEN.TenLoaiHocVien,
MaHocVien = obj.MaHocVien,
TenHocVien = obj.TenHocVien,
GioiTinh = obj.GioiTinh,
NgaySinh = obj.NgaySinh,
DiaChi = obj.DiaChi,
Sdt = obj.Sdt,
Email = obj.Email,
NgayTiepNhan = obj.NgayTiepNhan,
SdtBo = obj.SdtBo,
EmailBo = obj.EmailBo,
SdtMe = obj.SdtMe,
EmailMe = obj.EmailMe,
TenNguoiTuVan = obj.TenNguoiTuVan,
GhiChu = obj.GhiChu,
IsRemove = obj.IsRemove,
CreatedDate = obj.CreatedDate,
CreatedBy = obj.CreatedBy,
CreatedLog = obj.CreatedLog,
ModifiedDate = obj.ModifiedDate,
ModifiedBy = obj.ModifiedBy,
ModifiedLog = obj.ModifiedLog,
/*TaiKhoanId = obj.TaiKhoanId,
* TenDangNhap=obj.TAIKHOAN.TenDangNhap,*/
});
if (_filter.MaHocVien != null)
{
query = query.Where(o => o.MaHocVien.Contains(_filter.MaHocVien)).ToList();
}
if (_filter.HocVienId != null && _filter.HocVienId != 0)
{
query = query.Where(o => o.HocVienId == _filter.HocVienId).ToList();
}
if (_filter.CoSoId != null && _filter.CoSoId != 0)
{
query = query.Where(o => o.CoSoId == _filter.CoSoId).ToList();
}
if (_filter.NgayTiepNhan_Tu != null && _filter.NgayTiepNhan_Den != null)
{
query = query.Where(o => o.NgayTiepNhan >= _filter.NgayTiepNhan_Tu && o.NgayTiepNhan <= _filter.NgayTiepNhan_Den).ToList();
}
if (_filter.LoaiHocVienId != null && _filter.LoaiHocVienId != 0)
{
query = query.Where(o => o.LoaiHocVienId == _filter.LoaiHocVienId).ToList();
}
if (_filter.GioiTinh != null && _filter.GioiTinh != "")
{
query = query.Where(o => o.GioiTinh == _filter.GioiTinh).ToList();
}
return(query.ToList());
}
catch (System.Exception ex)
{
return(null);
O2S_Common.Logging.LogSystem.Error(ex);
}
}
public static List <QuanLyHocVienDTO> SelectQuanLyHocVien(HocVienFilter _filter)
{
try
{
// List<HocVien_PlusDTO> _result = null;
var query = (from hv in GlobalSettings.Database.HOCVIENs
join pgd in Database.PHIEUGHIDANHs on hv.HocVienId equals pgd.HocVienId into phieu
from pgd1 in phieu.DefaultIfEmpty()
join bd in Database.BANGDIEMs on pgd1.PhieuGhiDanhId equals bd.PhieuGhiDanhId into bangdiem
from bd1 in bangdiem.DefaultIfEmpty()
where pgd1.IsRemove != 1
select new QuanLyHocVienDTO
{
HocVienId = hv.HocVienId,
CoSoId = hv.CoSoId,
TenCoSoTrungTam = hv.COSOTRUNGTAM.TenCoSo,
LoaiHocVienId = hv.LoaiHocVienId,
MaLoaiHocVien = hv.LOAIHOCVIEN.MaLoaiHocVien,
TenLoaiHocVien = hv.LOAIHOCVIEN.TenLoaiHocVien,
MaHocVien = hv.MaHocVien,
TenHocVien = hv.TenHocVien,
GioiTinh = hv.GioiTinh,
NgaySinh = hv.NgaySinh,
DiaChi = hv.DiaChi,
Sdt = hv.Sdt,
Email = hv.Email,
NgayTiepNhan = hv.NgayTiepNhan,
SdtBo = hv.SdtBo,
EmailBo = hv.EmailBo,
SdtMe = hv.SdtMe,
EmailMe = hv.EmailMe,
IsRemove = hv.IsRemove,
CreatedDate = hv.CreatedDate,
CreatedBy = hv.CreatedBy,
CreatedLog = hv.CreatedLog,
ModifiedDate = hv.ModifiedDate,
ModifiedBy = hv.ModifiedBy,
ModifiedLog = hv.ModifiedLog,
TenDangNhap = hv.TAIKHOAN.TenDangNhap,
PhieuGhiDanhId = pgd1 == null ? 0 : pgd1.PhieuGhiDanhId,
MaPhieuGhiDanh = pgd1 == null ? "" : pgd1.MaPhieuGhiDanh,
NgayGhiDanh = pgd1 == null ? null : pgd1.NgayGhiDanh,
TongTien = pgd1 == null ? 0 : pgd1.TongTien,
DaDong = pgd1 == null ? 0 : pgd1.DaDong,
ConNo = pgd1 == null ? 0 : pgd1.ConNo,
MienGiam_PhanTram = pgd1 == null ? 0 : pgd1.MienGiam_PhanTram,
MienGiam_Tien = pgd1 == null ? 0 : pgd1.MienGiam_Tien,
KhoaHocId = pgd1 == null ? 0 : pgd1.KhoaHocId,
TenKhoaHoc = pgd1 == null ? "" : pgd1.KHOAHOC.TenKhoaHoc,
LopHocId = bd1 == null ? 0 : bd1.LopHocId,
TenLopHoc = bd1 == null ? "" : bd1.LOPHOC.TenLopHoc,
BangDiemId = bd1 == null ? 0 : bd1.BangDiemId,
DiemTrungBinh = bd1 == null ? 0 : bd1.DiemTrungBinh,
TenTrangThai = bd1 == null ? "" : (bd1.TrangThai == 0 ? "Xếp lớp" : bd1.TrangThai == 1 ? "Đang học" : bd1.TrangThai == 3 ? "Có điểm" : bd1.TrangThai == 99 ? "Kết thúc" : ""),
}).ToList();
//if (_filter.MaHocVien != null)
//{
// query = query.Where(o => o.MaHocVien == _filter.MaHocVien).ToList();
//}
//if (_filter.HocVienId != null && _filter.HocVienId != 0)
//{
// query = query.Where(o => o.HocVienId == _filter.HocVienId).ToList();
//}
if (_filter.CoSoId != null && _filter.CoSoId != 0)
{
query = query.Where(o => o.CoSoId == _filter.CoSoId).ToList();
}
if (_filter.NgayTiepNhan_Tu != null && _filter.NgayTiepNhan_Den != null)
{
query = query.Where(o => o.NgayTiepNhan >= _filter.NgayTiepNhan_Tu && o.NgayTiepNhan <= _filter.NgayTiepNhan_Den).ToList();
}
if (_filter.LoaiHocVienId != null && _filter.LoaiHocVienId != 0)
{
query = query.Where(o => o.LoaiHocVienId == _filter.LoaiHocVienId).ToList();
}
//if (_filter.GioiTinh != null && _filter.GioiTinh != "")
//{
// query = query.Where(o => o.GioiTinh == _filter.GioiTinh).ToList();
//}
return(query.ToList());
}
catch (System.Exception ex)
{
return(null);
O2S_Common.Logging.LogSystem.Error(ex);
}
}