/// <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(); } } }