public void Xoa(QLKTX.BusinessObject.CanBoInfo cb) { SqlCommand s = new SqlCommand("Delete CANBO where MACBQL=@ma"); s.Parameters.Add("@ma", SqlDbType.Int).Value = cb.MaSo; ser.Load(s); }
public void Sua(QLKTX.BusinessObject.CanBoInfo cb) { SqlCommand s = new SqlCommand("Update CANBO set TENCBQL = @ten, DIACHI=@diachi where MACBQL= @ma"); s.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = cb.Ten; s.Parameters.Add("@ma", SqlDbType.Int).Value = cb.MaSo; s.Parameters.Add("@diachi", SqlDbType.NVarChar, 100).Value = cb.DiaChi; ser.Load(s); }
public void Them(QLKTX.BusinessObject.CanBoInfo cb) { SqlCommand s = new SqlCommand("INSERT INTO CANBO(MACBQL,TENCBQL,DIACHI) VALUES(@ma,@ten,@diachi)"); s.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = cb.Ten; s.Parameters.Add("@ma", SqlDbType.Int).Value = cb.MaSo; s.Parameters.Add("@diachi", SqlDbType.NVarChar, 100).Value = cb.DiaChi; ser.Load(s); }
private void btnXoa_Click(object sender, EventArgs e) { if (dataDSCanBoQuanLy.SelectedRows.Count > 0) { txtMa.Text = dataDSCanBoQuanLy.SelectedRows[0].Cells[0].Value.ToString(); txtTen.Text = dataDSCanBoQuanLy.SelectedRows[0].Cells[1].Value.ToString(); txtDiaChi.Text = dataDSCanBoQuanLy.SelectedRows[0].Cells[2].Value.ToString(); if (MessageBox.Show("Bạn có muốn xóa cán bộ: \"" + txtTen.Text + "\" Không?", "Cán bộ", MessageBoxButtons.YesNo) == DialogResult.Yes) { QLKTX.BusinessObject.CanBoInfo info = new QLKTX.BusinessObject.CanBoInfo(); info.MaSo = Convert.ToInt32(txtMa.Text); info.Ten = txtTen.Text; info.DiaChi = txtDiaChi.Text; ctrl.Xoa(info); ctrl.LayDSCanBoQuanLy(dataDSCanBoQuanLy); } } }
private void btnCapNhat_Click(object sender, EventArgs e) { if (ctrl.KiemTra(txtMa, txtTen, txtDiaChi)) { QLKTX.BusinessObject.CanBoInfo cb = new QLKTX.BusinessObject.CanBoInfo(); cb.MaSo = Convert.ToInt32(txtMa.Text); cb.Ten = txtTen.Text; cb.DiaChi = txtDiaChi.Text; if (Adding) { ctrl.Them(cb); } else { if (Updating) { ctrl.Sua(cb); } } ctrl.LayDSCanBoQuanLy(dataDSCanBoQuanLy); Updating = Adding = false; txtMa.Enabled = false; txtTen.Enabled = false; txtDiaChi.Enabled = false; btnThem.Enabled = true; btnXoa.Enabled = true; btnSua.Enabled = true; btnCapNhat.Enabled = false; btnBoQua.Visible = false; dataDSCanBoQuanLy.Enabled = true; } }
public void Sua(QLKTX.BusinessObject.CanBoInfo info) { CanBoData data = new CanBoData(); data.Sua(info); }
public void Them(QLKTX.BusinessObject.CanBoInfo info) { CanBoData data = new CanBoData(); data.Them(info); }