//Sua du lieu
public void updateGiangday(EC_tblGiangday et)
{
cn.ThucThiCauLenhSQL(@"UPDATE tblGiangday SET Thu = '" + et.Thu + "', Tietday = '" + et.Tietday + "' WHERE MaGV = '" + et.MaGV + "' and MaLop = '" + et.MaLop + "' and Thu = " + et.Thu + "");
}
//Xoa du lieu
public void delGiangday(EC_tblGiangday et)
{
cn.ThucThiCauLenhSQL(@"DELETE FROM tblGiangday WHERE MaGV = '" + et.MaGV + "' and MaLop = '" + et.MaLop + "' and Tietday = '" + et.Tietday + "' and Thu = " + et.Thu + "");
}
//Them du lieu
public void addGiangday(EC_tblGiangday et)
{
cn.ThucThiCauLenhSQL(@"INSERT INTO tblGiangday(MaGV , MaLop, Thu, Tietday) values('" + et.MaGV + "','" + et.MaLop + "'," + et.Thu + ",'" + et.Tietday + "')");
}
