public static List <MonHoc_PlusDTO> Select(MonHocFilter _filter)
{
try
{
//List<MonHoc_PlusDTO> _result = null;
var query = (from p in GlobalSettings.Database.MONHOCs
select p).AsEnumerable().Select((obj, index) => new MonHoc_PlusDTO
{
Stt = index + 1,
MonHocId = obj.MonHocId,
MaMonHoc = obj.MaMonHoc,
TenMonHoc = obj.TenMonHoc,
DiemToiDa = obj.DiemToiDa,
IsRemove = obj.IsRemove,
CreatedDate = obj.CreatedDate,
CreatedBy = obj.CreatedBy,
CreatedLog = obj.CreatedLog,
ModifiedDate = obj.ModifiedDate,
ModifiedBy = obj.ModifiedBy,
ModifiedLog = obj.ModifiedLog,
});
if (_filter.MonHocId != null && _filter.MonHocId != 0)
{
query = query.Where(o => o.MonHocId == _filter.MonHocId).ToList();
}
return(query.ToList());
}
catch (System.Exception ex)
{
return(null);
O2S_Common.Logging.LogSystem.Error(ex);
}
}
private void LoadGridMonHoc()
{
try
{
MonHocFilter _filter = new MonHocFilter();
// _filter.CoSoId = GlobalSettings.CoSoId;
List <MonHoc_PlusDTO> _lstMonHoc = MonHocLogic.Select(_filter);
if (_lstMonHoc != null && _lstMonHoc.Count > 0)
{
gridControlMonHoc.DataSource = _lstMonHoc;
}
else
{
gridControlMonHoc.DataSource = null;
}
lblTongCong.Text = string.Format("Tổng cộng: {0} môn học", gridViewMonHoc.RowCount);
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
