public void sual(EC_tb_Calam l) { string sql = (@"UPDATE tb_Calam SET tenca =N'" + l.TENCA + "' where maca =N'" + l.MACA + "'"); cn.ExcuteNonQuery(sql); }
public void themoil(EC_tb_Calam l) { if (!Lsql.kiemtral(l.MACA)) { 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_Calam l) { cn.ExcuteNonQuery("DELETE FROM [tb_Calam] WHERE [maca] = N'" + l.MACA + "'"); }
public void themmoil(EC_tb_Calam l) { cn.ExcuteNonQuery(@"INSERT INTO tb_Calam (maca, tenca) VALUES (N'" + l.MACA + "',N'" + l.TENCA + "')"); }
public void xoal(EC_tb_Calam l) { Lsql.xoal(l); }
public void sual(EC_tb_Calam l) { Lsql.sual(l); }