public static void Init(XmsDbContext context) { List <TbCurrencyRate> list = new List <TbCurrencyRate>() { new TbCurrencyRate() { Id = 1, IsEnabled = true, BeginDate = DateTime.Now, EndDate = DateTime.Now, Code = "GBP", Name = "英镑", Rate = 8.9000, CreateTime = DateTime.Now, ModifyTime = DateTime.Now }, new TbCurrencyRate() { Id = 2, IsEnabled = true, BeginDate = DateTime.Now, EndDate = DateTime.Now, Code = "HKD", Name = "港币", Rate = 0.8000, CreateTime = DateTime.Now, ModifyTime = DateTime.Now }, new TbCurrencyRate() { Id = 3, IsEnabled = true, BeginDate = DateTime.Now, EndDate = DateTime.Now, Code = "RMB", Name = "人民币", Rate = 1.0000, CreateTime = DateTime.Now, ModifyTime = DateTime.Now }, new TbCurrencyRate() { Id = 4, IsEnabled = true, BeginDate = DateTime.Now, EndDate = DateTime.Now, Code = "RUB", Name = "俄罗斯卢布", Rate = 0.1000, CreateTime = DateTime.Now, ModifyTime = DateTime.Now }, new TbCurrencyRate() { Id = 5, IsEnabled = true, BeginDate = DateTime.Now, EndDate = DateTime.Now, Code = "SGD", Name = "新加坡元", Rate = 4.8000, CreateTime = DateTime.Now, ModifyTime = DateTime.Now }, new TbCurrencyRate() { Id = 6, IsEnabled = true, BeginDate = DateTime.Now, EndDate = DateTime.Now, Code = "USD", Name = "美元", Rate = 6.5000, CreateTime = DateTime.Now, ModifyTime = DateTime.Now }, }; list.ForEach(tmp => context.CurrencyRates.Add(tmp)); context.SaveChanges(); }
public static void Init(XmsDbContext context) { //context.Database.ExecuteSqlCommand("ALTER TABLE [dbo].[DistributionCenter] DROP CONSTRAINT [FK_dbo.DistributionCenter_dbo.DistributionCenter_ParentId]"); List <TbDistributionCenter> list = new List <TbDistributionCenter>(); int lastId = 1; list.AddRange(InitType1(lastId, out lastId)); list.ForEach(tmp => context.DistributionCenters.Add(tmp)); context.SaveChanges(); }
public static void Init(XmsDbContext context) { context.Database.ExecuteSqlCommand("ALTER TABLE [dbo].[TbDataDictionary] DROP CONSTRAINT [FK_dbo.TbDataDictionary_dbo.TbDataDictionary_ParentId]"); List <TbDataDictionary> list = new List <TbDataDictionary>(); int lastId = 1; list.AddRange(InitType1(lastId, out lastId)); list.ForEach(tmp => context.DataDictionarys.Add(tmp)); context.SaveChanges(); }
public static void Init(XmsDbContext context) { List <TbChannel> list = new List <TbChannel>() { new TbChannel() { Id = 1, Name = "渠道A" }, new TbChannel() { Id = 2, Name = "渠道B" }, new TbChannel() { Id = 3, Name = "渠道C" }, new TbChannel() { Id = 4, Name = "渠道D" }, new TbChannel() { Id = 5, Name = "渠道E" }, new TbChannel() { Id = 6, Name = "渠道F" }, new TbChannel() { Id = 7, Name = "渠道G" }, }; list.ForEach(tmp => context.Channels.Add(tmp)); context.SaveChanges(); }
public static void Init(XmsDbContext context) { List <TbIncidentalPrice> list = new List <TbIncidentalPrice>() { new TbIncidentalPrice() { Id = 1, GoodsType = GoodsType.Bag, UnitCode = "KG", UnitNumber = 1.0, UnitValue = 2.5000, Name = "Z2", BeginTime = DateTime.Now, EndTime = DateTime.Now }, new TbIncidentalPrice() { Id = 2, GoodsType = GoodsType.Bag, UnitCode = "BS", UnitNumber = 1.0, UnitValue = 10.0000, Name = "Z3", BeginTime = DateTime.Now, EndTime = DateTime.Now }, new TbIncidentalPrice() { Id = 3, GoodsType = GoodsType.Bag, UnitCode = "BS", UnitNumber = 1.0, UnitValue = 0.0000, Name = "Z4", BeginTime = DateTime.Now, EndTime = DateTime.Now }, new TbIncidentalPrice() { Id = 4, GoodsType = GoodsType.Bag, UnitCode = "BS", UnitNumber = 1.0, UnitValue = 0.0000, Name = "Z5", BeginTime = DateTime.Now, EndTime = DateTime.Now }, new TbIncidentalPrice() { Id = 5, GoodsType = GoodsType.Bag, UnitCode = "BS", UnitNumber = 1.0, UnitValue = 0.0000, Name = "Z6", BeginTime = DateTime.Now, EndTime = DateTime.Now }, new TbIncidentalPrice() { Id = 6, GoodsType = GoodsType.Bag, UnitCode = "BS", UnitNumber = 1.0, UnitValue = 10.0000, Name = "Z7", BeginTime = DateTime.Now, EndTime = DateTime.Now }, new TbIncidentalPrice() { Id = 7, GoodsType = GoodsType.Bag, UnitCode = "BS", UnitNumber = 1.0, UnitValue = 20.0000, Name = "Z8", BeginTime = DateTime.Now, EndTime = DateTime.Now }, new TbIncidentalPrice() { Id = 8, GoodsType = GoodsType.Bag, UnitCode = "BS", UnitNumber = 1.0, UnitValue = 50.0000, Name = "P2", BeginTime = DateTime.Now, EndTime = DateTime.Now }, new TbIncidentalPrice() { Id = 9, GoodsType = GoodsType.Bag, UnitCode = "DP", UnitNumber = 1.0, UnitValue = 0.0300, Name = "E4", BeginTime = DateTime.Now, EndTime = DateTime.Now }, new TbIncidentalPrice() { Id = 10, GoodsType = GoodsType.Bag, UnitCode = "DP", UnitNumber = 1.0, UnitValue = 0.0300, Name = "H7", BeginTime = DateTime.Now, EndTime = DateTime.Now }, new TbIncidentalPrice() { Id = 11, GoodsType = GoodsType.Bag, UnitCode = "BS", UnitNumber = 1.0, UnitValue = 0.0000, Name = "Y6", BeginTime = DateTime.Now, EndTime = DateTime.Now }, new TbIncidentalPrice() { Id = 12, GoodsType = GoodsType.Bag, UnitCode = "BS", UnitNumber = 1.0, UnitValue = 0.0000, Name = "Y7", BeginTime = DateTime.Now, EndTime = DateTime.Now }, new TbIncidentalPrice() { Id = 13, GoodsType = GoodsType.Bag, UnitCode = "BS", UnitNumber = 1.0, UnitValue = 0.0000, Name = "Y5", BeginTime = DateTime.Now, EndTime = DateTime.Now }, }; list.ForEach(tmp => context.IncidentalPrices.Add(tmp)); context.SaveChanges(); }