protected virtual void LoadGrid() { try { var tb1 = Statistic.GopKetQua(_list); var tb2 = Statistic.GopKetQua1(_list); if (tb2.Rows.Count > 0 && _list.Count > 1) { IList <Sinhvien> listthongke = new List <Sinhvien>(); foreach (DataRow row in tb2.Rows) { var a = int.Parse(row["MaSV"].ToString()); foreach (var sv in listthongke.Where(sv => sv.MaSV == a)) { for (var i = 0; i < _list.Count; i++) { var ten = "Diem" + (i + 1); var diem = row[ten].ToString(); if (!string.IsNullOrEmpty(diem)) { sv.Diemthi[i] = int.Parse(row[ten].ToString()); } } goto b; } var sv1 = new Sinhvien(_list.Count) { MaSV = a, HoSV = row["HoSV"].ToString(), TenSV = row["TenSV"].ToString(), MaLop = row["MaLop"].ToString(), NgaySinh = row["NgaySinh"].ToString(), }; for (var i = 0; i < _list.Count; i++) { var ten = "Diem" + (i + 1); var diem = row[ten].ToString(); if (!string.IsNullOrEmpty(diem)) { sv1.Diemthi[i] = double.Parse(row[ten].ToString()); } else { sv1.Diemthi[i] = 0; } } listthongke.Add(sv1); b :; } var t = tb1.Rows.Count; foreach (var item in listthongke) { tb1.Rows.Add(++t, item.MaSV, item.HoSV, item.TenSV, item.NgaySinh, item.MaLop); for (var i = 0; i < _list.Count; i++) { var ten = "Diem" + (i + 1); tb1.Rows[tb1.Rows.Count - 1][ten] = item.Diemthi[i]; } tb1.Rows[tb1.Rows.Count - 1]["TongDiem"] = item.Tinhtong(); } Invoke((Action)(() => _listtk = listthongke)); } Invoke((Action)(() => dgv_DanhSach.DataSource = tb1)); Invoke((Action)(() => pnl_from.Visible = true)); lock (LockTotal) { OnCloseDialog(); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
protected virtual void LoadGrid() { try { var tb1 = Statistic.GopKetQua(_list); var tb2 = Statistic.GopKetQua1(_list); if (tb2.Rows.Count > 0 && _list.Count > 1) { IList<Sinhvien> listthongke = new List<Sinhvien>(); foreach (DataRow row in tb2.Rows) { var a = int.Parse(row["MaSV"].ToString()); foreach (var sv in listthongke.Where(sv => sv.MaSV == a)) { for (var i = 0; i < _list.Count; i++) { var ten = "Diem" + (i + 1); var diem = row[ten].ToString(); if (!string.IsNullOrEmpty(diem)) sv.Diemthi[i] = int.Parse(row[ten].ToString()); } goto b; } var sv1 = new Sinhvien(_list.Count) { MaSV = a, HoSV = row["HoSV"].ToString(), TenSV = row["TenSV"].ToString(), MaLop = row["MaLop"].ToString(), NgaySinh = row["NgaySinh"].ToString(), }; for (var i = 0; i < _list.Count; i++) { var ten = "Diem" + (i + 1); var diem = row[ten].ToString(); if (!string.IsNullOrEmpty(diem)) sv1.Diemthi[i] = double.Parse(row[ten].ToString()); else sv1.Diemthi[i] = 0; } listthongke.Add(sv1); b:; } var t = tb1.Rows.Count; foreach (var item in listthongke) { tb1.Rows.Add(++t, item.MaSV, item.HoSV, item.TenSV, item.NgaySinh, item.MaLop); for (var i = 0; i < _list.Count; i++) { var ten = "Diem" + (i + 1); tb1.Rows[tb1.Rows.Count - 1][ten] = item.Diemthi[i]; } tb1.Rows[tb1.Rows.Count - 1]["TongDiem"] = item.Tinhtong(); } Invoke((Action)(() => _listtk = listthongke)); } Invoke((Action)(()=>dgv_DanhSach.DataSource = tb1)); Invoke((Action)(() => pnl_from.Visible = true)); lock (LockTotal) { OnCloseDialog(); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }