Example #1
0
 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 + "')");
 }
Example #2
0
 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 + "'");
 }
Example #3
0
 public void DeleteNhapHang(DTO_PhieuNhapHang pnhDTO)
 {
     helper.ThucHienCauLenhSQL("DELETE from PHIEUNHAP Where MaPN=N'" + pnhDTO.MaPN + "'");
 }