public void suam(EC_tb_Mau m)
{
string sql = (@"UPDATE tb_Mau
SET tenmau =N'" + m.TENMAU + "' where mamau =N'" + m.MAMAU + "'");
cn.ExcuteNonQuery(sql);
}
public void themoim(EC_tb_Mau m)
{
if (!msql.kiemtram(m.MAMAU))
{
msql.themmoim(m);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void xoam(EC_tb_Mau m)
{
cn.ExcuteNonQuery("DELETE FROM [tb_Mau] WHERE [mamau] = N'" + m.MAMAU + "'");
}
public void themmoim(EC_tb_Mau m)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_Mau
(mamau, tenmau) VALUES (N'" + m.MAMAU + "',N'" + m.TENMAU + "')");
}
public void xoam(EC_tb_Mau m)
{
msql.xoam(m);
}
public void suam(EC_tb_Mau m)
{
msql.suam(m);
}