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); } }