private void btnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
XuLi cn = new XuLi();
string sql = "Delete from TinhThanh where MaTinhThanh='" + txtMaTinhThanh.Text + "'";
cn.TacDong(sql);
taiDuLieu();
}
private void btnSua_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
XuLi cn = new XuLi();
string sql2 = "update TinhThanh set TenTinhThanh='" + txtTenTinhThanh.Text + "' where MaTinhThanh='" + txtMaTinhThanh.Text + "'";
cn.TacDong(sql2);
taiDuLieu();
btnXoa.Enabled = true;
btnSua.Enabled = true;
}
private void btnSua_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
XuLi cn = new XuLi();
string sql2 = "update MucLuong set MucLuong='" + txtMucLuong.Text + "',PhuCap='" + cbMaPhuCap.SelectedValue.ToString() + "' where MaML='" + txtMaML.Text + "'";
cn.TacDong(sql2);
taiDuLieu();
btnXoa.Enabled = true;
btnSua.Enabled = true;
}
private void btnSua_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
XuLi cn = new XuLi();
string sql2 = "update PhuCap set TenPhuCap='" + txtTenPC.Text + "',MucPhuCap='" + txtMucPC.Text + "' where MaPhuCap='" + txtMaPC.Text + "'";
cn.TacDong(sql2);
taiDuLieu();
btnXoa.Enabled = true;
btnSua.Enabled = true;
}
private void btnLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
XuLi cn = new XuLi();
string x = txtMaTinhThanh.Text;
string y = txtTenTinhThanh.Text;
string sql1 = "INSERT INTO TinhThanh(MaTinhThanh,TenTinhThanh)" +
"values('" + x + "','" + y + "')";
if (hanhDong == "them")
{
cn.TacDong(sql1);
}
taiDuLieu();
btnXoa.Enabled = true;
btnSua.Enabled = true;
}
private void btnLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
XuLi cn = new XuLi();
string x = txtMaML.Text;
string y = txtMucLuong.Text;
string n = cbMaPhuCap.SelectedValue.ToString();
string sql1 = "INSERT INTO MucLuong(MaML,MucLuong,MaPhuCap)" +
"values('" + x + "','" + y + "','" + n + "')";
if (hanhDong == "them")
{
cn.TacDong(sql1);
}
taiDuLieu();
btnXoa.Enabled = true;
btnSua.Enabled = true;
}
