public void sual(EC_tb_Chatlieu l)
{
string sql = (@"UPDATE tb_Chatlieu
SET tenchatlieu =N'" + l.TENCHATLIEU + "' where machatlieu =N'" + l.MACHATLIEU + "'");
cn.ExcuteNonQuery(sql);
}
public void themoil(EC_tb_Chatlieu l)
{
if (!Lsql.kiemtral(l.MACHATLIEU))
{
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_Chatlieu l)
{
cn.ExcuteNonQuery("DELETE FROM [tb_Chatlieu] WHERE [machatlieu] = N'" + l.MACHATLIEU + "'");
}
public void themmoil(EC_tb_Chatlieu l)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_Chatlieu
(machatlieu, tenchatlieu) VALUES (N'" + l.MACHATLIEU + "',N'" + l.TENCHATLIEU + "')");
}
public void xoal(EC_tb_Chatlieu l)
{
Lsql.xoal(l);
}
public void sual(EC_tb_Chatlieu l)
{
Lsql.sual(l);
}