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); }