private void dgv_DanhSach_AfterExitEditMode(object sender, EventArgs e) { try { var hs = new DapAn { IdKyThi = _idkythi, MaMon = dgv_DanhSach.ActiveRow.Cells["MaMon"].Text, MaDe = dgv_DanhSach.ActiveRow.Cells["MaDe"].Text, CauHoi = int.Parse(dgv_DanhSach.ActiveRow.Cells["CauHoi"].Text), ThangDiem = !string.IsNullOrEmpty(dgv_DanhSach.ActiveRow.Cells["ThangDiem"].Text) ? double.Parse(dgv_DanhSach.ActiveRow.Cells["ThangDiem"].Text) : 0, }; _listUpdate.Add(hs); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
private void Nhapdiem() { try { var frm = new FrmNhapDiem(); frm.ShowDialog(); if (string.IsNullOrEmpty(frm.txtNhapdiem.Text)) return; _listUpdate.Clear(); foreach (var row in dgv_DanhSach.Rows) { row.Cells["ThangDiem"].Value = frm.txtNhapdiem.Text; var hs = new DapAn { IdKyThi = _idkythi, MaMon = row.Cells["MaMon"].Text, MaDe = row.Cells["MaDe"].Text, CauHoi = int.Parse(row.Cells["CauHoi"].Text), ThangDiem = double.Parse(frm.txtNhapdiem.Text) }; _listUpdate.Add(hs); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
/// <summary> /// Sửa lại đáp án đúng của 1 câu hỏi /// </summary> /// <returns>true</returns> private static void UpdateThangDiem(DapAn item) { try { var thangdiem = item.ThangDiem.ToString().Replace(',', '.'); var str = "UPDATE DAPAN SET ThangDiem = " + thangdiem + " " + "WHERE MaMon = '" + item.MaMon + "' and MaDe = '" + item.MaDe + "' " + "and CauHoi =" + item.CauHoi + " and IdKyThi= " + item.IdKyThi + ""; Conn.ExcuteQuerySql(str); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
/// <summary> /// Sửa lại đáp án đúng của câu hỏi /// </summary> /// <returns>true</returns> private static void UpdateDapAn(DapAn item) { try { Conn.ExcuteQuerySql("UPDATE DAPAN SET Dapan = '" + item.Dapan + "' " + "WHERE MaMon = '" + item.MaMon + "' and MaDe = '" + item.MaDe + "' " + "and CauHoi = " + item.CauHoi + " and IdKyThi= " + item.IdKyThi + ""); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
/// <summary> /// Lưu dữ liệu trên UltraGrid /// </summary> protected override void SaveDetail() { try { foreach (var row in dgv_DanhSach.Rows) { var hs = new DapAn { IdKyThi = _idKythi, MaMon = row.Cells["MaMon"].Text, MaDe = row.Cells["MaDe"].Text, CauHoi = int.Parse(row.Cells["CauHoi"].Text), Dapan = row.Cells["Dapan"].Text, ThangDiem = 0 }; _listAdd.Add(hs); } if (_listAdd.Count <= 0) return; InsertData.ThemDapAn(_listAdd); MessageBox.Show(@"Đã lưu vào CSDL", FormResource.MsgCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message.Contains(FormResource.msgLostConnect) ? FormResource.txtLoiDB : ex.Message); Log2File.LogExceptionToFile(ex); } }
/// <summary> /// Thêm 1 đáp án cho mã đề /// </summary> /// <returns></returns> public static bool ThemDapAn(DapAn item) { try { Conn.ExcuteQuerySql("insert into DapAn(IdKyThi,MaMon,MaDe,CauHoi,Dapan,ThangDiem) values(" + item.IdKyThi + ",'" + item.MaMon + "','" + item.MaDe + "'," + item.CauHoi + ",'" + item.Dapan + "'," + item.ThangDiem + ")"); return true; } catch (Exception ex) { Log2File.LogExceptionToFile(ex); return false; } }
private void dgv_DanhSach_AfterExitEditMode(object sender, EventArgs e) { try { var hs = new DapAn { IdKyThi = _idKyThi, MaMon = dgv_DanhSach.ActiveRow.Cells["MaMon"].Text, MaDe = dgv_DanhSach.ActiveRow.Cells["MaDe"].Text, CauHoi = int.Parse(dgv_DanhSach.ActiveRow.Cells["CauHoi"].Text), Dapan = dgv_DanhSach.ActiveRow.Cells["Dapan"].Text, }; _listUpdate.Add(hs); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }