public void T_Remark() { Uri uri = new Uri(TestConfig.serviceUrl); var context = new DamServiceRef.Container(uri); context.Format.UseJson(); var itemList = context.Remarks.ToList(); int cnt1 = context.Remarks.Count(); var app = context.Apps.Take(1).SingleOrDefault();//top 1 var newItem = new Remark(); newItem.Id = Guid.NewGuid(); newItem.RemarkText = "测试"; newItem.Date = DateTime.Now; newItem.AppId = app.Id; context.AddToRemarks(newItem); context.SaveChanges(); int cnt2 = context.Remarks.Count(); Assert.IsTrue(cnt1 + 1 == cnt2, "插入 失败"); //在单独查询 context.Detach(newItem); var itemInDb = context.Remarks.Where(s => s.Id == newItem.Id).SingleOrDefault(); Assert.AreEqual(itemInDb.Id, newItem.Id, "插入失败"); //更新 itemInDb.RemarkText = newItem.RemarkText + "modify"; context.UpdateObject(itemInDb); context.SaveChanges(); context.Detach(itemInDb); var itemUpdated = context.Remarks.Where(s => s.Id == itemInDb.Id).SingleOrDefault(); Assert.AreEqual(itemUpdated.RemarkText, itemInDb.RemarkText, "更新失败"); //删除 context.DeleteObject(itemUpdated); context.SaveChanges(); int fCnt = context.Remarks.Count(); Assert.IsTrue(cnt1 == fCnt, "删除 失败"); }
public void T_projectPart() { Uri uri = new Uri(TestConfig.serviceUrl); var context = new DamServiceRef.Container(uri); context.Format.UseJson(); var itemList = context.ProjectParts.ToList(); int cnt1 = context.ProjectParts.Count(); var root = context.ProjectParts.Where(s => s.ParentPart == null).SingleOrDefault(); var newItem = new ProjectPart(); newItem.Id = Guid.NewGuid(); newItem.PartName = "测试部位"; newItem.ParentPart = root.Id; context.AddToProjectParts(newItem); context.SaveChanges(); int cnt2 = context.ProjectParts.Count(); Assert.IsTrue(cnt1 + 1 == cnt2, "插入 失败"); //在单独查询 context.Detach(newItem); var itemInDb = context.ProjectParts.Where(s => s.Id == newItem.Id).SingleOrDefault(); Assert.AreEqual(itemInDb.Id, newItem.Id, "插入失败"); //更新 itemInDb.PartName = newItem.PartName + "modify"; context.UpdateObject(itemInDb); context.SaveChanges(); context.Detach(itemInDb); var itemUpdated = context.ProjectParts.Where(s => s.Id == itemInDb.Id).SingleOrDefault(); Assert.AreEqual(itemUpdated.PartName, itemInDb.PartName, "更新失败"); //删除 context.DeleteObject(itemUpdated); context.SaveChanges(); int fCnt = context.ProjectParts.Count(); Assert.IsTrue(cnt1 == fCnt, "删除 失败"); }
public void T_app() { Uri uri = new Uri(TestConfig.serviceUrl); var context = new DamServiceRef.Container(uri); context.Format.UseJson(); var itemList = context.Apps.ToList(); int cnt1 = context.Apps.Count(); var newItem = new App(); newItem.Id = Guid.NewGuid(); newItem.AppName = "新的仪器"; newItem.CalculateName = "newCreatedApp"; context.AddToApps(newItem); context.SaveChanges(); int cnt2 = context.Apps.Count(); Assert.IsTrue(cnt1 + 1 == cnt2, "插入 失败"); //在单独查询 context.Detach(newItem); var itemInDb = context.Apps.Where(s => s.Id == newItem.Id).SingleOrDefault(); Assert.AreEqual(itemInDb.Id, newItem.Id, "插入失败"); //更新 itemInDb.AppName = newItem.AppName + "modify"; context.UpdateObject(itemInDb); context.SaveChanges(); context.Detach(itemInDb); var itemUpdated = context.Apps.Where(s => s.Id == itemInDb.Id).SingleOrDefault(); Assert.AreEqual(itemUpdated.AppName, itemInDb.AppName, "更新失败"); //删除 context.DeleteObject(itemUpdated); context.SaveChanges(); int fCnt = context.Apps.Count(); Assert.IsTrue(cnt1 == fCnt, "删除 失败"); }
public void T_type() { Uri uri = new Uri(TestConfig.serviceUrl); var context = new DamServiceRef.Container(uri); context.Format.UseJson(); var typeList = context.ApparatusTypes.ToList(); int cnt1 = context.ApparatusTypes.Count(); var newType = new ApparatusType() { Id = Guid.NewGuid(), TypeName = (new Random((int)DateTime.Now.Ticks)).Next().ToString() }; context.AddToApparatusTypes(newType); context.SaveChanges(); int cnt2 = context.ApparatusTypes.Count(); int cnt3 = context.ApparatusTypes.Where(s => s.TypeName == "第一种类型").Count(); Assert.IsTrue(cnt1 != cnt2, "插入 失败"); //在单独查询 context.Detach(newType); var type1 = context.ApparatusTypes.Where(s => s.Id == newType.Id).SingleOrDefault(); Assert.AreEqual(type1.TypeName, newType.TypeName, "插入失败"); //更新 type1.TypeName = newType.TypeName + "modify"; context.UpdateObject(type1); context.SaveChanges(); var type2 = context.ApparatusTypes.Where(s => s.Id == newType.Id).SingleOrDefault(); Assert.AreEqual(type2.TypeName, type1.TypeName, "更新失败"); //删除 context.DeleteObject(type2); context.SaveChanges(); int fCnt = context.ApparatusTypes.Count(); Assert.IsTrue(cnt1 == fCnt, "删除 失败"); }
public void T_app_CheckExistData2() { Uri uri = new Uri(TestConfig.serviceUrl); var context = new DamServiceRef.Container(uri); context.Format.UseJson(); var app = context.Apps.Where(s => s.AppName == "第一支仪器").SingleOrDefault(); context.LoadProperty <AppParam>(app, "AppParams", null); //添加测量参数 DateTimeOffset date = DateTimeOffset.Now; List <MessureValue> list = new List <MessureValue>(); foreach (var param in app.AppParams.OfType <MessureParam>()) { var item = new MessureValue() { Id = Guid.NewGuid(), Date = date, ParamId = param.Id, Val = 1 }; list.Add(item); context.AddToMessureValues(item); } context.SaveChanges(); var result = context.CheckExistData(app.Id, date); Assert.AreEqual(true, result, "测试失败"); foreach (var item in list) { context.DeleteObject(item); } context.SaveChanges(); result = context.CheckExistData(app.Id, date); Assert.AreEqual(false, result, "测试失败"); }