// delete data
public void XoaDuLieu(EC_KhuVuc et)
{
SQL.XoaDuLieu(et);
}
//-------- update data
public void SuaDuLieu(EC_KhuVuc et)
{
SQL.SuaDuLieu(et);
}
// in ssert dữ liệu ---------------
public void ThemDuLieu(EC_KhuVuc et)
{
SQL.ThemDuLieu(et);
}
//================delete data
public void XoaDuLieu(EC_KhuVuc etkv)
{
cn.ThucThiSQL("DELETE FROM KhuVuc where MaKhu= '" + etkv.MaKhu + "'");
}
//================ update data
public void SuaDuLieu(EC_KhuVuc etkv)
{
cn.ThucThiSQL("UPDATE KhuVuc SET GhiChu = N'" + etkv.GhiChu + "', TenKhu = N'" + etkv.TenKhu + "' where MaKhu= '" + etkv.MaKhu + "'");
}
//===============thêm data (insert)===================
public void ThemDuLieu(EC_KhuVuc etkv)
{
cn.ThucThiSQL("INSERT INTO KhuVuc (MaKhu, TenKhu, GhiChu) VALUES ('" + etkv.MaKhu + "',N'" + etkv.TenKhu + "',N'" + etkv.GhiChu + "')");
}