public ShelfLocationInformation getShelfLocation(string decodedRFID)
{
//string sqlCommandString = "select * from " + shelfDecodedRFIDToLocationTable + " where code=" + "'" + decodedRFID + "'";
string sqlCommandString = "select * from " + shelfDecodedRFIDToLocationTable + " where code=@decodedRFID";
try
{
ShelfLocationInformation oneShelf = new ShelfLocationInformation();
connectionDatabase();
SqlCommand readCommand = new SqlCommand(sqlCommandString, sqlConnection);
readCommand.Parameters.Add(new SqlParameter("decodedRFID",decodedRFID));
SqlDataReader sqlReader = readCommand.ExecuteReader();
sqlReader.Read();
oneShelf.floor = Int32.Parse(sqlReader["floor"].ToString().Trim());
oneShelf.selection = sqlReader["selection"].ToString().Trim();
oneShelf.row = Int32.Parse(sqlReader["row"].ToString().Trim());
oneShelf.side = sqlReader["side"].ToString().Trim();
oneShelf.col = Int32.Parse(sqlReader["col"].ToString().Trim());
oneShelf.shelf = Int32.Parse(sqlReader["shelf"].ToString().Trim());
oneShelf.code = sqlReader["code"].ToString().Trim();
disconnectionDatabase();
return oneShelf;
}
catch (Exception e)
{
throw e;
//return bookName; //return empty book name
}
}
public void saveBookLocation(string decodedBookRFIDCode,ShelfLocationInformation shelfLocation)
{
string sqlCommandStringForDelete= "delete from "+bookDecodedRFIDToLocationTable+" where bookDecodedRFID=@bookDecodedRFID";
string sqlCommandStringForInsert= "insert into "+bookDecodedRFIDToLocationTable+" (floor,selection,row,side,col,shelf,code,bookDecodedRFID) VALUES (@floor,@selection,@row,@side,@col,@shelf,@code,@bookDecodedRFID)";
try
{
connectionDatabase();
//首先删除指定条目，参数为图书的rfid码
SqlCommand deleteCommand = new SqlCommand(sqlCommandStringForDelete, sqlConnection);
deleteCommand.Parameters.Add(new SqlParameter("bookDecodedRFID", decodedBookRFIDCode));
deleteCommand.ExecuteNonQuery();
//再添加这个条目
SqlCommand insertCommand = new SqlCommand(sqlCommandStringForInsert, sqlConnection);
//insertCommand.Parameters.Add(new SqlParameter("table", bookDecodedRFIDToLocationTable));
insertCommand.Parameters.Add(new SqlParameter("floor", shelfLocation.floor));
insertCommand.Parameters.Add(new SqlParameter("selection", shelfLocation.selection));
insertCommand.Parameters.Add(new SqlParameter("row", shelfLocation.row));
insertCommand.Parameters.Add(new SqlParameter("side", shelfLocation.side));
insertCommand.Parameters.Add(new SqlParameter("col", shelfLocation.col));
insertCommand.Parameters.Add(new SqlParameter("shelf", shelfLocation.shelf));
insertCommand.Parameters.Add(new SqlParameter("code", shelfLocation.code));
insertCommand.Parameters.Add(new SqlParameter("bookDecodedRFID", decodedBookRFIDCode));
insertCommand.ExecuteNonQuery();
disconnectionDatabase();
}
catch (Exception e)
{
throw e;
}
}
