public void suaCV(EC_tb_CongViec cv) { string sql = (@"UPDATE tb_Congviec SET tencv =N'" + cv.TENCV + "' where macv =N'" + cv.MACV + "'"); cn.ExcuteNonQuery(sql); }
public void themoicv(EC_tb_CongViec cv) { if (!cvsql.kiemtraCV(cv.MACV)) { cvsql.themmoiCV(cv); } else { MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public void xoaCV(EC_tb_CongViec cv) { cn.ExcuteNonQuery("DELETE FROM [tb_Congviec] WHERE [macv] = N'" + cv.MACV + "'"); }
public void themmoiCV(EC_tb_CongViec cv) { cn.ExcuteNonQuery(@"INSERT INTO tb_Congviec (macv, tencv) VALUES (N'" + cv.MACV + "',N'" + cv.TENCV + "')"); }
public void xoacv(EC_tb_CongViec cv) { cvsql.xoaCV(cv); }
public void suacv(EC_tb_CongViec cv) { cvsql.suaCV(cv); }