public void sua(EC_tb_Nhomhang l)
{
string sql = (@"UPDATE tb_Nhomhang
SET tennhom =N'" + l.TENNHOM + "', congcu =N'" + l.CONGCU + "' where manhom =N'" + l.MANHOM + "'");
cn.ExcuteNonQuery(sql);
}
public void themoi(EC_tb_Nhomhang n)
{
if (!nccsql.kiemtral(n.MANHOM))
{
nccsql.themmoi(n);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void xoa(EC_tb_Nhomhang l)
{
cn.ExcuteNonQuery("DELETE FROM [tb_Nhomhang] WHERE [manhom] = N'" + l.MANHOM + "'");
}
public void themmoi(EC_tb_Nhomhang l)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_Nhomhang
(manhom, tennhom, congcu) VALUES (N'" + l.MANHOM + "',N'" + l.TENNHOM + "',N'" + l.CONGCU + "')");
}
public void xoa(EC_tb_Nhomhang n)
{
nccsql.xoa(n);
}
public void suan(EC_tb_Nhomhang ncc)
{
nccsql.sua(ncc);
}
