public void CloseConnect()
{
if (context != null)
{
context.Dispose();
context = null;
}
}
public DBConnect StartConnect()
{
if (context == null)
{
context = new PostgreSQLContext();
}
return(this);
}
public static void Seed(PostgreSQLContext context)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
var locations = new List <Location>
{
new Location {
Code = "CZ", Province = "江苏省", City = "常州市"
},
new Location {
Code = "NT", Province = "江苏省", City = "南通市"
},
new Location {
Code = "WX", Province = "江苏省", City = "无锡市"
},
new Location {
Code = "WZ", Province = "浙江省", City = "温州市"
},
new Location {
Code = "SY", Province = "辽宁省", City = "沈阳市"
},
new Location {
Code = "DL", Province = "辽宁省", City = "大连市"
},
new Location {
Code = "QD", Province = "山东省", City = "青岛市"
},
new Location {
Code = "HF", Province = "安徽省", City = "合肥市"
},
new Location {
Code = "WH", Province = "湖北省", City = "武汉市"
},
new Location {
Code = "XA", Province = "陕西省", City = "西安市"
}
};
var managers = new List <Manager>
{
new Manager {
Code = "CZM0000000001", Name = "袁舰"
},
new Manager {
Code = "CZM0000000002", Name = "熊大"
},
new Manager {
Code = "CZM0000000003", Name = "熊二"
}
};
var salons = new List <Salon>
{
new Salon {
Code = "MY0000000001", Name = "袁舰母婴工作室", LocationCode = "SY", ManagerCode = "CZM0000000001"
},
new Salon {
Code = "MY0000000002", Name = "熊大母婴工作室", LocationCode = "DL", ManagerCode = "CZM0000000002"
},
new Salon {
Code = "MY0000000003", Name = "熊二母婴工作室", LocationCode = "DL", ManagerCode = "CZM0000000003"
}
};
var serviceGroups = new List <ServiceGroup>
{
new ServiceGroup {
Code = "CR", GroupName = "催乳", ShowIndex = "5"
},
new ServiceGroup {
Code = "CHXF", GroupName = "产后修复", ShowIndex = "3"
},
new ServiceGroup {
Code = "SZJK", GroupName = "生殖健康", ShowIndex = "7"
},
new ServiceGroup {
Code = "CHTXHF", GroupName = "体型恢复", ShowIndex = "4"
},
new ServiceGroup {
Code = "ZYLL", GroupName = "中医理疗", ShowIndex = "6"
},
new ServiceGroup {
Code = "XETN", GroupName = "小儿推拿", ShowIndex = "1"
},
new ServiceGroup {
Code = "MYHL", GroupName = "母婴护理", ShowIndex = "2"
},
};
var services = new List <Service>
{
new Service {
Code = "CR00000001", GroupCode = serviceGroups[0].Code, Name = "开奶", Price = "101"
},
new Service {
Code = "CR00000002", GroupCode = serviceGroups[0].Code, Name = "通乳", Price = "102"
},
new Service {
Code = "CR00000003", GroupCode = serviceGroups[0].Code, Name = "回奶", Price = "103"
},
new Service {
Code = "CR00000004", GroupCode = serviceGroups[0].Code, Name = "急性乳腺炎", Price = "104"
},
new Service {
Code = "CHXF000001", GroupCode = serviceGroups[1].Code, Name = "妊娠纹修复", Price = "105"
},
new Service {
Code = "CHXF000002", GroupCode = serviceGroups[1].Code, Name = "骨盆修复", Price = "106"
},
new Service {
Code = "CHXF000003", GroupCode = serviceGroups[1].Code, Name = "盆底肌修复", Price = "107"
},
new Service {
Code = "CHXF000004", GroupCode = serviceGroups[1].Code, Name = "肩颈调理", Price = "108"
},
new Service {
Code = "CHXF000005", GroupCode = serviceGroups[1].Code, Name = "暖宫", Price = "109"
},
new Service {
Code = "CHXF000006", GroupCode = serviceGroups[1].Code, Name = "满月发汗", Price = "110"
},
new Service {
Code = "CHXF000007", GroupCode = serviceGroups[1].Code, Name = "胸型优化", Price = "111"
},
new Service {
Code = "CHXF000008", GroupCode = serviceGroups[1].Code, Name = "头疗", Price = "112"
},
new Service {
Code = "CHXF000009", GroupCode = serviceGroups[1].Code, Name = "腹直肌分离修复", Price = "113"
},
new Service {
Code = "SZJK0000001", GroupCode = serviceGroups[2].Code, Name = "一指私密", Price = "114"
},
new Service {
Code = "CHTXHF0001", GroupCode = serviceGroups[3].Code, Name = "瘦四肢", Price = "115"
},
new Service {
Code = "CHTXHF0002", GroupCode = serviceGroups[3].Code, Name = "提臀", Price = "116"
},
new Service {
Code = "CHTXHF0003", GroupCode = serviceGroups[3].Code, Name = "大肚腩", Price = "117"
},
new Service {
Code = "ZYLL0000001", GroupCode = serviceGroups[4].Code, Name = "拔罐", Price = "118"
},
new Service {
Code = "ZYLL0000002", GroupCode = serviceGroups[4].Code, Name = "艾灸", Price = "119"
},
new Service {
Code = "ZYLL0000003", GroupCode = serviceGroups[4].Code, Name = "刮痧", Price = "120"
},
new Service {
Code = "XETN000001", GroupCode = serviceGroups[5].Code, Name = "洗澡", Price = "20"
},
new Service {
Code = "XETN000002", GroupCode = serviceGroups[5].Code, Name = "药浴", Price = "98"
},
new Service {
Code = "XETN000003", GroupCode = serviceGroups[5].Code, Name = "推拿", Price = "68"
},
new Service {
Code = "XETN000004", GroupCode = serviceGroups[5].Code, Name = "艾灸", Price = "68"
},
new Service {
Code = "XETN000005", GroupCode = serviceGroups[5].Code, Name = "洗澡+抚触", Price = "38"
},
new Service {
Code = "XETN000006", GroupCode = serviceGroups[5].Code, Name = "洗澡+推拿", Price = "78"
},
new Service {
Code = "XETN000007", GroupCode = serviceGroups[5].Code, Name = "药浴+推拿", Price = "138"
},
new Service {
Code = "XETN000008", GroupCode = serviceGroups[5].Code, Name = "推拿+艾灸", Price = "138"
},
new Service {
Code = "MYHL000001", GroupCode = serviceGroups[6].Code, Name = "育婴", Price = "122"
},
new Service {
Code = "MYHL000002", GroupCode = serviceGroups[6].Code, Name = "月嫂", Price = "123"
},
};
var salonservices = new List <SalonService>
{
new SalonService {
SalonCode = "MY0000000001", ServiceCode = "CR00000001", Service = services[0]
},
new SalonService {
SalonCode = "MY0000000001", ServiceCode = "CR00000002", Service = services[1]
},
};
var staffServiceTimes = new List <StaffServiceTime>
{
new StaffServiceTime {
Code = "ST01", StartTime = "08:00", EndTime = "09:00"
},
new StaffServiceTime {
Code = "ST02", StartTime = "09:30", EndTime = "10:30"
},
new StaffServiceTime {
Code = "ST03", StartTime = "11:00", EndTime = "12:00"
},
new StaffServiceTime {
Code = "ST04", StartTime = "12:30", EndTime = "13:30"
},
new StaffServiceTime {
Code = "ST05", StartTime = "14:00", EndTime = "15:00"
},
new StaffServiceTime {
Code = "ST06", StartTime = "15:30", EndTime = "16:30"
},
new StaffServiceTime {
Code = "ST07", StartTime = "17:00", EndTime = "18:00"
}
};
var staffs = new List <Staff>
{
new Staff {
Code = "E0000000001", Name = "地鼠1号", SalonCode = "MY0000000001", Salon = salons[0],
},
new Staff {
Code = "E0000000002", Name = "地鼠2号", SalonCode = "MY0000000002", Salon = salons[1],
},
};
var staffOrders = new List <StaffOrder>
{
};
var assets = new List <Assets>
{
};
var customs = new List <Custom>
{
};
var orders = new List <Order>
{
};
var staffBookTimes = new List <StaffBookTime>
{
};
context.Locations.AddRange(locations);
context.Managers.AddRange(managers);
context.Salons.AddRange(salons);
context.ServiceGroups.AddRange(serviceGroups);
context.Services.AddRange(services);
context.SalonServices.AddRange(salonservices);
context.StaffServiceTimes.AddRange(staffServiceTimes);
context.StaffBookTimes.AddRange(staffBookTimes);
context.Staffs.AddRange(staffs);
context.StaffOrders.AddRange(staffOrders);
context.Assets.AddRange(assets);
context.Customs.AddRange(customs);
context.Orders.AddRange(orders);
context.SaveChanges();
}