public void update(PhieuXuatHangDTO info)
{
string updateCommand = "UPDATE PhieuXuatHang " +
"SET TongTienXuat = '" + info.TongTienXuat + "', " +
" WHERE MaPhieu = '" + info.MaPhieuXuatHang + "'";
executeNonQuery(updateCommand);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
PhieuXuatHangDTO ptt = new PhieuXuatHangDTO();
ptt.MaPhieuXuatHang = dt.Rows[i]["MaPhieu"].ToString();
ptt.TongTienXuat = int.Parse(dt.Rows[i]["TongTienXuat"].ToString());
return (object)ptt;
}
public void insert(PhieuXuatHangDTO info)
{
string insertCommand = "INSERT INTO PhieuXuatHang VALUES('" +
info.MaPhieuXuatHang + "', '" +
info.TongTienXuat + ")";
executeNonQuery(insertCommand);
}
