private void SaveDetail2() { try { foreach (var row in dgv_DanhSach.Rows) { var hs = new DiemThi { MaSV = int.Parse(row.Cells["MaSV"].Text), Diem = double.Parse(row.Cells["DiemThi"].Text), IdNamHoc = _idnamhoc, HocKy = _hocky }; _listThongke.Add(hs); } if (_listThongke.Count > 0) { InsertData.ThemThongKe(_listThongke); MessageBox.Show(@"Lưu lại thành công"); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
/// <summary> /// Thêm bảng thống kê /// </summary> /// <returns></returns> public static bool ThemThongKe(DiemThi item) { try { var diem = item.Diem.ToString().Replace(',', '.'); Conn.ExcuteQuerySql("insert into DIEMTHI(MaSV,IdNamHoc,HocKy,Diem) values(" + item.MaSV + "," + item.IdNamHoc + ",'" + item.HocKy + "'," +diem + ")"); return true; } catch (Exception ex) { Log2File.LogExceptionToFile(ex); return false; } }