public static List <DotHoc_PlusDTO> Select(DotHocFilter _filter)
{
try
{
var query = (from p in GlobalSettings.Database.DOTHOCs
select p).AsEnumerable().Select((obj, index) => new DotHoc_PlusDTO
{
Stt = index + 1,
DotHocId = obj.DotHocId,
MaDotHoc = obj.MaDotHoc,
CoSoId = obj.CoSoId,
TenCoSoTrungTam = obj.COSOTRUNGTAM.TenCoSo,
LopHocId = obj.LopHocId,
TenLopHoc = obj.LOPHOC.TenLopHoc,
TenDotHoc = obj.TenDotHoc,
HocPhi = obj.HocPhi,
SoBuoiHoc = obj.SoBuoiHoc,
IsLock = obj.IsLock,
IsRemove = obj.IsRemove,
CreatedDate = obj.CreatedDate,
CreatedBy = obj.CreatedBy,
CreatedLog = obj.CreatedLog,
ModifiedDate = obj.ModifiedDate,
ModifiedBy = obj.ModifiedBy,
ModifiedLog = obj.ModifiedLog,
});
if (_filter.DotHocId != null && _filter.DotHocId != 0)
{
query = query.Where(o => o.DotHocId == _filter.DotHocId).ToList();
}
if (_filter.CoSoId != null && _filter.CoSoId != 0)
{
query = query.Where(o => o.CoSoId == _filter.CoSoId).ToList();
}
if (_filter.LopHocId != null && _filter.LopHocId != 0)
{
query = query.Where(o => o.LopHocId == _filter.LopHocId).ToList();
}
if (_filter.IsLock != null)
{
query = query.Where(o => o.IsLock == _filter.IsLock).ToList();
}
return(query.ToList());
}
catch (System.Exception ex)
{
return(null);
O2S_Common.Logging.LogSystem.Error(ex);
}
}
private void LoadDotHocTheoLopHoc()
{
try
{
DotHocFilter _filter = new DotHocFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
_filter.LopHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
cboDotHoc.DataSource = DotHocLogic.Select(_filter);
cboDotHoc.DisplayMember = "TenDotHoc";
cboDotHoc.ValueMember = "DotHocId";
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
