public void DoTest2() { UiVersion v = new UiVersion() { ProductCode = "TEST", VersionCode = 2, VersionNumber = "0.0.2", VersionDesc = "测试版本2.", VersionFile = "Test2.exe" }; using (MyVersionManagerContext context = new MyVersionManagerContext()) { // 从数据库中查询数据. DbVersion dv = context.DbVersions.FirstOrDefault(p => p.ProductCode == "TEST" && p.VersionCode == 2); // UI 上面的数据, 更新到 数据库中. Mapper.Map <UiVersion, DbVersion>( source: v, destination: dv, opts: opt => { opt.AfterMap((src, dest) => dest.LastUpdateUser = "******"); }); // 物理保存. context.SaveChanges(); } }
public void DoTest1() { using (MyVersionManagerContext context = new MyVersionManagerContext()) { DbProduct dp = context.DbProducts.Find("TEST"); UiProduct up = Mapper.Map <DbProduct, UiProduct>(source: dp); Console.WriteLine("DB TO UI ..."); Console.WriteLine("DB = {0}", dp); Console.WriteLine("UI = {0}", up); Console.WriteLine("DB TO UI Finish."); DbVersion dv = dp.VersionList.LastOrDefault(); UiVersion uv = Mapper.Map <DbVersion, UiVersion>(source: dv); Console.WriteLine("DB TO UI ..."); Console.WriteLine("DB = {0}", dv); Console.WriteLine("UI = {0}", uv); List <DbVersion> dvList = dp.VersionList; List <UiVersion> uvList = Mapper.Map <List <DbVersion>, List <UiVersion> >(source: dvList); Console.WriteLine("DB List TO UI List..."); Console.WriteLine("DB List = ..."); foreach (var item in dvList) { Console.WriteLine(item); } Console.WriteLine("UI List = ..."); foreach (var item in uvList) { Console.WriteLine(item); } Console.WriteLine("DB TO UI Finish."); } }
public void DoTest1() { using (MyVersionManagerContext context = new MyVersionManagerContext()) { DbProduct dp = context.DbProducts.Find("TEST"); UiProduct up = Mapper.Map <DbProduct, UiProduct>(source: dp); Console.WriteLine("DB TO UI ..."); Console.WriteLine("DB = {0}", dp); Console.WriteLine("UI = {0}", up); Console.WriteLine("DB TO UI Finish."); DbVersion dv = dp.VersionList.LastOrDefault(); UiVersion uv = Mapper.Map <DbVersion, UiVersion>(source: dv); Console.WriteLine("DB TO UI ..."); Console.WriteLine("DB = {0}", dv); Console.WriteLine("UI = {0}", uv); Console.WriteLine("DB TO UI Finish."); } }
public void DoTest1() { UiProduct p = new UiProduct() { ProductCode = "TEST", ProductName = "测试产品", }; UiVersion v1 = new UiVersion() { ProductCode = "TEST", VersionCode = 1, VersionNumber = "0.0.1", VersionDesc = "测试版本.", VersionFile = "Test.exe" }; UiVersion v2 = new UiVersion() { ProductCode = "TEST", VersionCode = 2, VersionNumber = "0.0.2", VersionDesc = "测试版本.", VersionFile = "Test.exe" }; DbProduct dp = Mapper.Map <UiProduct, DbProduct>( source: p, opts: opt => { opt.AfterMap((src, dest) => { dest.CreateTime = DateTime.Now; dest.CreateUser = "******"; dest.LastUpdateUser = "******"; dest.IsActive = true; }); } ); DbVersion dv1 = Mapper.Map <UiVersion, DbVersion>( source: v1, opts: opt => { opt.AfterMap((src, dest) => { dest.CreateTime = DateTime.Now; dest.CreateUser = "******"; dest.LastUpdateUser = "******"; dest.IsActive = true; }); } ); DbVersion dv2 = Mapper.Map <UiVersion, DbVersion>( source: v2, opts: opt => { opt.AfterMap((src, dest) => { dest.CreateTime = DateTime.Now; dest.CreateUser = "******"; dest.LastUpdateUser = "******"; dest.IsActive = true; }); } ); using (MyVersionManagerContext context = new MyVersionManagerContext()) { // 删除历史测试数据. context.Database.ExecuteSqlCommand("DELETE FROM db_version WHERE product_code = 'TEST'"); context.Database.ExecuteSqlCommand("DELETE FROM db_product WHERE product_code = 'TEST'"); // 新增最新的测试数据. context.DbProducts.Add(dp); context.DbVersions.Add(dv1); context.DbVersions.Add(dv2); // 物理保存. context.SaveChanges(); } }