/// <summary>
/// 初始化数据库——首次使用
/// </summary>
/// <returns></returns>
public static bool InitializeTable()
{
StorageInfo info = new StorageInfo()
{
RFIDNumber = "00000000", //不存在料盘时的RFID号
Type = "null", //null代表空库位
Number = 0, //数量为0
TrayIsExist = false //不存在料盘
};
try
{
using (var wareHouseDB = new WMSDbContext())
{
for (int index = 0; index < 60; index++)
{
wareHouseDB.StorageInfo.Add(info);
wareHouseDB.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// 一般不用
/// </summary>
public static void Remove()
{
using (var wareHouseDB = new WMSDbContext())
{
for (int index = 61; index < 300; index++)
{
StorageInfo storageInfo = wareHouseDB.StorageInfo.Where(p => p.LocationID == index).FirstOrDefault();
wareHouseDB.StorageInfo.Remove(storageInfo);
wareHouseDB.SaveChanges();
}
}
}
