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);
}