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