//Xoá
public void XoaDuLieu(E_phongtro et)
{
sql.XoaDuLieu(et);
}
//Sửa
public void SuaDuLieu(E_phongtro et)
{
sql.SuaDuLieu(et);
}
// Thêm Dữ Liệu
public void ThemDuLieu(E_phongtro et)
{
sql.ThemDuLieu(et);
}
//Xoá
public void XoaDuLieu(E_phongtro et)
{
cn.ThucThiCauLenh(@"DELETE FROM phongtro Where mapt='" + et.mapt + "'");
}
//Sửa
public void SuaDuLieu(E_phongtro et)
{
cn.ThucThiCauLenh(@"UPDATE phongtro SET tang = N'" + et.tang + "', tenphong =N'" + et.tenphong + "', loai ='" + et.loai + "', sltoida ='" + et.sltoida + "', trangthai ='" + et.trangthai + "' Where mapt='" + et.mapt + "'");
}
// Thêm Dữ Liệu
public void ThemDuLieu(E_phongtro et)
{
cn.ThucThiCauLenh(@"INSERT INTO phongtro (mapt, tang, tenphong, loai, sltoida, trangthai) VALUES ('" + et.mapt + "',N'" + et.tang + "',N'" + et.tenphong + "',N'" + et.loai + "',N'" + et.sltoida + "',N'" + et.trangthai + "')");
}