public static void testBookLocation()
{
string dataBaseConnectString = "Data Source=192.168.28.129;Initial Catalog=Location;User ID=sa;Password=19831122";
ShelfLocationDatabase shelfDatabase = new ShelfLocationDatabase(dataBaseConnectString);
BookLocationDatabase bookDatabase = new BookLocationDatabase(dataBaseConnectString);
string testDecodeRFIDShelf = "3W01A0101";
ShelfLocationInformation sl = shelfDatabase.getShelfLocation(testDecodeRFIDShelf);
bookDatabase.saveBookLocation("222222223", sl);
}
public static void testShelfLocation(){
//书架位置信息的测试代码
string dataBaseConnectString = "Data Source=192.168.28.129;Initial Catalog=Location;User ID=sa;Password=19831122";
ShelfLocationDatabase shelfDatabase = new ShelfLocationDatabase(dataBaseConnectString);
string testDecodeRFIDShelf = "3W01A0101";
ShelfLocationInformation sl=shelfDatabase.getShelfLocation(testDecodeRFIDShelf);
Console.WriteLine("floor:" + sl.floor);
Console.WriteLine("selection:" + sl.selection);
Console.WriteLine("row:" + sl.row);
Console.WriteLine("side:" + sl.side);
Console.WriteLine("col:" + sl.col);
Console.WriteLine("shelf:" + sl.shelf);
Console.WriteLine("code:" + sl.code);
Console.ReadKey();
}