コード例 #1
0
 private void btnThemDiem_Click(object sender, EventArgs e)
 {
     if (txtMaDiem.Text != "" && txtMaHS.Text != "" && txtMonHoc.Text != "" && txtNamHoc.Text != "" && cbbHocKy.Text != "")
     {
         DiemTKCN d = new DiemTKCN(txtMaDiem.Text, null);
         if (cd.XoadiemTKCNCTHS(d))
         {
             MessageBox.Show("Xóa thành công");
         }
     }
     else
     {
         MessageBox.Show("Vui lòng nhập đầy đủ thông tin");
     }
 }
コード例 #2
0
        private void btnThemDiem_Click(object sender, EventArgs e)
        {
            DiemTKCN d = new DiemTKCN(txtMaDiem.Text, null);
            NamHoc   n = new NamHoc(null, txtNamHoc.Text);
            HocSinh  h = new HocSinh(txtMaHS.Text, null, null, DateTime.MinValue, null, null, null, null, null, null, null);

            if (txtMaHS.Text != "" && txtNamHoc.Text != "" && txtMaDiem.Text != "")
            {
                if (cd.themdiemTKCNCTHS(d, h, n))
                {
                    MessageBox.Show("Thêm thành công");
                    dgvHienThiCT.DataSource = cd.hienthiDiemTKCNCTHS(n, h);
                }
            }
            else
            {
                MessageBox.Show("vui lòng nhập đầy đủ thông tin");
            }
        }
コード例 #3
0
        public bool XoadiemTKCNCTHS(DiemTKCN d)
        {
            try
            {
                conn.Open();

                string SQL = string.Format("delete from DIEM_TKCN where MADIEM_TKCN = '" + d.MaDiem + "'");

                SqlCommand cmd = new SqlCommand(SQL, conn);
                int        kq  = (int)cmd.ExecuteNonQuery();
                if (kq > 0)
                {
                    return(true);
                }
            }
            catch
            {
            }
            finally
            {
                conn.Close();
            }
            return(false);
        }
コード例 #4
0
        public bool themdiemTKCNCTHS(DiemTKCN d, HocSinh h, NamHoc n)
        {
            try
            {
                conn.Open();

                string SQL = string.Format("exec themdiemTKCNCTHS '" + d.MaDiem + "', '" + h.Mahs + "', N'" + n.TenNH + "'");

                SqlCommand cmd = new SqlCommand(SQL, conn);
                int        kq  = (int)cmd.ExecuteNonQuery();
                if (kq > 0)
                {
                    return(true);
                }
            }
            catch
            {
            }
            finally
            {
                conn.Close();
            }
            return(false);
        }
コード例 #5
0
 public bool themdiemTKCNCTHS(DiemTKCN d, HocSinh h, NamHoc n)
 {
     return(cnd.themdiemTKCNCTHS(d, h, n));
 }
コード例 #6
0
 public bool XoadiemTKCNCTHS(DiemTKCN d)
 {
     return(cnd.XoadiemTKCNCTHS(d));
 }