/// <summary>
/// 用户数据Seed
/// </summary>
public void UserSeed()
{
Console.WriteLine("用户Seed");
using (var dbCtx = new TheContext())
{
IList <User> defaultUsers = new List <User>();
for (var i = 0; i < 3; i++)
{
defaultUsers.Add(new User()
{
Name = "user" + i.ToString(),
LogicId = Util.GenerateIntId(),
Position = "职位" + i,
Remark = "备注" + i
});
}
foreach (User user in defaultUsers)
{
dbCtx.Users.Add(user);
}
dbCtx.SaveChanges();
}
}
/// <summary>
/// 管理员数据Seed
/// </summary>
public void AdminSeed()
{
Console.WriteLine("管理员Seed");
using (var dbCtx = new TheContext())
{
IList <Admin> defaultAdmins = new List <Admin>();
for (var i = 0; i < 10; i++)
{
defaultAdmins.Add(new Admin()
{
Account = "admin" + i.ToString(),
Password = "******",
Type = 2
});
}
foreach (Admin admin in defaultAdmins)
{
dbCtx.Admins.Add(admin);
}
dbCtx.SaveChanges();
}
}
/// <summary>
/// 清空所有的数据
/// </summary>
public void DeleteAllData()
{
using (var dbCtx = new TheContext())
{
dbCtx.Histories.Clear();
dbCtx.Equipments.Clear();
dbCtx.EquipmentTypes.Clear();
dbCtx.Users.Clear();
dbCtx.Admins.Clear();
dbCtx.SaveChanges();
}
}
/// <summary>
/// 设备类型Seed
/// </summary>
public void EquipmentTypeSeed()
{
Console.WriteLine("设备类型Seed");
using (var dbCtx = new TheContext())
{
IList <EquipmentType> bigEquipmentTypes = new List <EquipmentType>();//大类数据Seed
for (var i = 0; i < 5; i++)
{
bigEquipmentTypes.Add(new EquipmentType()
{
Title = "大类" + i.ToString(),
Type = 0
});
}
foreach (var bigEquipmentType in bigEquipmentTypes)
{
dbCtx.EquipmentTypes.Add(bigEquipmentType);
}
dbCtx.SaveChanges();
IList <EquipmentType> smallEquipmentTypes = new List <EquipmentType>(); //小类数据Seed
for (var i = 0; i < 5; i++)
{
smallEquipmentTypes.Add(new EquipmentType()
{
Title = "小类" + i.ToString(),
Type = 1,
BigEquipmentType = bigEquipmentTypes[i] //设置小类所属大类的Id
});
}
foreach (var smallEquipmentType in smallEquipmentTypes)
{
dbCtx.EquipmentTypes.Add(smallEquipmentType);
}
dbCtx.SaveChanges();
}
}
/// <summary>
/// 设备数据Seed
/// </summary>
public void EquipmentSeed()
{
Console.WriteLine("设备Seed");
using (var dbCtx = new TheContext())
{
IList <EquipmentType> smallEquipmentTypes = dbCtx
.EquipmentTypes
.Where(et => et.Type == 1)
.ToList();
IList <User> users = dbCtx.Users
.ToList();
var admin = dbCtx.Admins.First();
foreach (var smallEquipmentType in smallEquipmentTypes)
{
foreach (var user in users)
{
for (var i = 0; i < 2; i++)
{
dbCtx.Equipments.Add(new Equipment()
{
Title = "设备" + i,
LogicId = Util.GenerateIntId(),
Worth = 20,
PurchasingDate = new DateTime(2016, 7, 18).Date,
State = 1,
Remark = "备注",
EquipmentType = smallEquipmentType,
User = user,
Admin = admin
});
}
}
}
dbCtx.SaveChanges();
}
}
