public void InsertNhapHang(DTO_PhieuNhapHang pnhDTO) { helper.ThucHienCauLenhSQL("INSERT INTO PHIEUNHAP (MaPN, MaNV, MaNCC, ThoiGianLap) VALUES (N'" + pnhDTO.MaPN + "',N'" + pnhDTO.MaNV + "',N'" + pnhDTO.MaNCC + "',N'" + pnhDTO.ThoiGianLap + "')"); }
public void UpdateNhapHang(DTO_PhieuNhapHang pnhDTO) { helper.ThucHienCauLenhSQL("UPDATE PHIEUNHAP SET MaNV =N'" + pnhDTO.MaNV + "', MaNCC =N'" + pnhDTO.MaNCC + "', ThoiGianLap ='" + pnhDTO.ThoiGianLap + "' where MaPN = N'" + pnhDTO.MaPN + "'"); }
public void DeleteNhapHang(DTO_PhieuNhapHang pnhDTO) { helper.ThucHienCauLenhSQL("DELETE from PHIEUNHAP Where MaPN=N'" + pnhDTO.MaPN + "'"); }