public void update(ChiTietPhieuXuatHangDTO info) { string updateCommand = "UPDATE ChiTietPhieuXuatHang " + "SET MaPhieuXuat = '" + info.MaPhieuXuatHang + "', " + " MatHang = '" + info.MaMatHang + "', " + " SoLuongHang = '" + info.SoLuong + " WHERE MaChiTiet = '" + info.MaChiTietPhieuXuatHang + "'"; executeNonQuery(updateCommand); }
protected override object GetDataFromDataRow(DataTable dt, int i) { ChiTietPhieuXuatHangDTO ctpxh = new ChiTietPhieuXuatHangDTO(); ctpxh.MaChiTietPhieuXuatHang = dt.Rows[i]["MaChiTietPhieuXuatHang"].ToString(); ctpxh.MaPhieuXuatHang = dt.Rows[i]["MaPhieuXuatHang"].ToString(); ctpxh.MaMatHang = dt.Rows[i]["MaMatHang"].ToString(); ctpxh.SoLuong = int.Parse(dt.Rows[i]["SoLuong"].ToString()); return (object)ctpxh; }
public void insert(ChiTietPhieuXuatHangDTO info) { string insertCommand = "INSERT INTO ChiTietPhieuXuatHang VALUES('" + info.MaChiTietPhieuXuatHang + "', '" + info.MaPhieuXuatHang + "', '" + info.MaMatHang + "', '" + info.SoLuong + ")"; executeNonQuery(insertCommand); }