public void sual(EC_tb_Theloai l)
{
string sql = (@"UPDATE tb_Theloai
SET tentheloai =N'" + l.TENTHELOAI + "' where matheloai =N'" + l.MATHELOAI + "'");
cn.ExcuteNonQuery(sql);
}
public void themoil(EC_tb_Theloai l)
{
if (!Lsql.kiemtral(l.MATHELOAI))
{
Lsql.themmoil(l);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void xoal(EC_tb_Theloai l)
{
Lsql.xoal(l);
}
public void sual(EC_tb_Theloai l)
{
Lsql.sual(l);
}
public void xoal(EC_tb_Theloai l)
{
cn.ExcuteNonQuery("DELETE FROM [tb_Theloai] WHERE [matheloai] = N'" + l.MATHELOAI + "'");
}
public void themmoil(EC_tb_Theloai l)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_Theloai
(matheloai, tentheloai) VALUES (N'" + l.MATHELOAI + "',N'" + l.TENTHELOAI + "')");
}
