public void sual(EC_tb_Congviec l) { string sql = (@"UPDATE tb_Congviec SET tencv =N'" + l.TENCV + "' where macv =N'" + l.MACV + "'"); cn.ExcuteNonQuery(sql); }
public void themoil(EC_tb_Congviec l) { if (!Lsql.kiemtral(l.MACV)) { 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_Congviec l) { Lsql.xoal(l); }
public void sual(EC_tb_Congviec l) { Lsql.sual(l); }
public void xoal(EC_tb_Congviec l) { cn.ExcuteNonQuery("DELETE FROM [tb_Congviec] WHERE [macv] = N'" + l.MACV + "'"); }
public void themmoil(EC_tb_Congviec l) { cn.ExcuteNonQuery(@"INSERT INTO tb_Congviec (macv, tencv) VALUES (N'" + l.MACV + "',N'" + l.TENCV + "')"); }