public void Update()
{
DataTable dt = new DataTable("table1");
oracleConnection.Open();
string cmdStr = @"select * from borrow_info WHERE READER_ID='" + user.Id + "'";
OracleCommand command = new OracleCommand(cmdStr, oracleConnection);
OracleDataAdapter adapter = new OracleDataAdapter(command);
adapter.Fill(dt);
adapter.Dispose();
oracleConnection.Close();
ltCus.Clear();
foreach (DataRow dataRow in dt.Rows)
{
ReturnUtil util = new ReturnUtil
{
Id = dataRow["BOOK_ID"].ToString(),
Name = dataRow["BOOK_NAME"].ToString(),
BorrowTime = dataRow["BORROW_TIME"].ToString(),
Count = ltCus.Count + 1,
ReturnTime = dataRow["RETURN_TIME"].ToString()
};
ltCus.Add(util);
}
listView.ItemsSource = ltCus;
}
private void listView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
button1.IsEnabled = true;
button2.IsEnabled = true;
util = (ReturnUtil)listView.SelectedItem;
}