private void HandleCloneAppProperties(object param) { try { if (AllowClone && CloneAppName.Trim().Length != 0) { cloneApp = (from s in DbContext.Apps where s.AppName == CloneAppName select s).FirstOrDefault(); if (cloneApp == null) { throw new Exception(string.Format("找不到测点编号为{0}的测点", CloneAppName)); } ApparatusType type = AppTypes.FirstOrDefault(s => s.Id == cloneApp.AppTypeID); NewApp.ApparatusType = type; NewApp.X = cloneApp.X; NewApp.Y = cloneApp.Y; NewApp.Z = cloneApp.Z; NewApp.OtherInfo = cloneApp.OtherInfo; NewApp.BuriedTime = cloneApp.BuriedTime; } } catch (Exception ex) { Messenger.Default.Send <Exception>(ex); } }
// POST odata/ApparatusTypes public async Task <IHttpActionResult> Post(ApparatusType apparatustype) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.ApparatusTypes.Add(apparatustype); try { await db.SaveChangesAsync(); } catch (DbUpdateException) { if (ApparatusTypeExists(apparatustype.Id)) { return(Conflict()); } else { throw; } } return(Created(apparatustype)); }
public ApparatusRecordData(System.IO.BinaryReader reader) { Type = (ApparatusType)reader.ReadInt32(); Quality = reader.ReadSingle(); weight = reader.ReadSingle(); value = reader.ReadInt32(); }
// PUT odata/ApparatusTypes(5) public async Task <IHttpActionResult> Put([FromODataUri] Guid key, ApparatusType apparatustype) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (key != apparatustype.Id) { return(BadRequest()); } db.Entry(apparatustype).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ApparatusTypeExists(key)) { return(NotFound()); } else { throw; } } return(Updated(apparatustype)); }
public async Task <IHttpActionResult> Patch([FromODataUri] Guid key, Delta <ApparatusType> patch) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } ApparatusType apparatustype = await db.ApparatusTypes.FindAsync(key); if (apparatustype == null) { return(NotFound()); } patch.Patch(apparatustype); try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ApparatusTypeExists(key)) { return(NotFound()); } else { throw; } } return(Updated(apparatustype)); }
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, "删除 失败"); }
// DELETE odata/ApparatusTypes(5) public async Task <IHttpActionResult> Delete([FromODataUri] Guid key) { ApparatusType apparatustype = await db.ApparatusTypes.FindAsync(key); if (apparatustype == null) { return(NotFound()); } db.ApparatusTypes.Remove(apparatustype); await db.SaveChangesAsync(); return(StatusCode(HttpStatusCode.NoContent)); }
// GET api/functions public IEnumerable <ApparatusType> Get() { var type1 = new ApparatusType(); type1.Id = Guid.NewGuid(); type1.TypeName = "第一种类型"; var type2 = new ApparatusType(); type2.Id = Guid.NewGuid(); type2.TypeName = "第二种类型"; return(new ApparatusType[] { type1, type2 }); }
protected override void bgw_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e) { try { using (DamWCFContext dam6Entities = new DamWCFContext(false)) { ResetConnectionString(dam6Entities); using (EF5x.Models.DamDBContext dam5Entities = new EF5x.Models.DamDBContext()) { ResetConnectionString(dam5Entities); _allRowCnt = dam5Entities.ApparatusTypes.Count(); foreach (var item in dam5Entities.ApparatusTypes.AsNoTracking()) { if (dam6Entities.ApparatusTypes.FirstOrDefault(i => i.Id == item.ApparatusTypeID) == null) { ApparatusType newItem = new ApparatusType(); newItem.Id = item.ApparatusTypeID; newItem.TypeName = item.TypeName; dam6Entities.ApparatusTypes.Add(newItem); dam6Entities.SaveChanges(); dam6Entities.Entry(newItem).State = System.Data.Entity.EntityState.Detached;// System.Data.Entity.EntityState.Detached;; } handledCnt++; reportProgress(); } } } reportProgress(); bgwResult = "导入成功!"; } catch (Exception ex) { if (ex.InnerException != null) { bgwResult = ex.InnerException.Message; } else { bgwResult = ex.Message; } } }
protected override void Seed(Hammergo.Data.DamWCFContext context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. E.g. // // context.People.AddOrUpdate( // p => p.FullName, // new Person { FullName = "Andrew Peters" }, // new Person { FullName = "Brice Lambson" }, // new Person { FullName = "Rowan Miller" } // ); // var type1 = new ApparatusType(); type1.Id = Guid.NewGuid(); type1.TypeName = "第一种类型"; var type2 = new ApparatusType(); type2.Id = Guid.NewGuid(); type2.TypeName = "第二种类型"; context.ApparatusTypes.AddOrUpdate(type1, type2); //添加工程部位 var root = new ProjectPart() { Id = Guid.NewGuid(), PartName = "root", ParentPart = null, }; var p1 = new ProjectPart() { Id = Guid.NewGuid(), PartName = "p1", ParentPart = root.Id, }; var p2 = new ProjectPart() { Id = Guid.NewGuid(), PartName = "p2", ParentPart = root.Id, }; context.ProjectParts.AddOrUpdate(root, p1, p2); //添加仪器 var app1 = new App(); app1.Id = Guid.NewGuid(); app1.AppName = "第一支仪器"; app1.CalculateName = "FirstApp"; app1.AppTypeID = type1.Id; app1.ProjectPartID = p1.Id; var app2 = new App(); app2.Id = Guid.NewGuid(); app2.AppName = "第二支仪器"; app2.CalculateName = "SecondApp"; app2.AppTypeID = type2.Id; app2.ProjectPartID = p2.Id; var app3 = new App(); app3.Id = Guid.NewGuid(); app3.AppName = "第三支仪器"; app3.CalculateName = "ThirdApp"; app3.AppTypeID = type2.Id; app3.ProjectPartID = p2.Id; context.Apps.AddOrUpdate(app1, app2, app3); var remark3 = new Remark() { Id = Guid.NewGuid(), Date = DateTime.Now, RemarkText = "remark", AppId = app2.Id, }; context.Remarks.AddOrUpdate(remark3); var conParam1 = new ConstantParam() { Id = Guid.NewGuid(), AppId = app1.Id, ParamName = "c1", ParamSymbol = "c1", PrecisionNum = 2, UnitSymbol = "no", Val = 1, Order = 1, Description = "no description", }; var mesParam1 = new MessureParam() { Id = Guid.NewGuid(), AppId = app1.Id, ParamName = "m1", ParamSymbol = "m1", PrecisionNum = 2, UnitSymbol = "no", Order = 1, Description = "no description", }; var calcParam1 = new CalculateParam() { Id = Guid.NewGuid(), AppId = app1.Id, ParamName = "cal1", ParamSymbol = "cal1", PrecisionNum = 2, UnitSymbol = "no", Order = 1, Description = "no description", }; context.AppParams.AddOrUpdate(conParam1, mesParam1, calcParam1); //添加第一支仪器的数据 DateTimeOffset date = DateTimeOffset.Now; int count = 20; for (int i = 0; i < count; i++) { MessureValue mv = new MessureValue() { Id = Guid.NewGuid(), ParamId = mesParam1.Id, Date = date.AddDays(-i), Val = i }; CalculateValue cv = new CalculateValue() { Id = Guid.NewGuid(), ParamId = calcParam1.Id, Date = date.AddDays(-i), Val = i }; var remark = new Remark() { Id = Guid.NewGuid(), Date = date.AddDays(-i), RemarkText = "remark" + i, AppId = app1.Id, }; context.MessureValues.AddOrUpdate(mv); context.CalculateValues.AddOrUpdate(cv); context.Remarks.AddOrUpdate(remark); } //添加第三支仪器的参数 var conParam1_third = new ConstantParam() { Id = Guid.NewGuid(), AppId = app3.Id, ParamName = "c1", ParamSymbol = "c1", PrecisionNum = 2, UnitSymbol = "no", Val = 1, Order = 1, Description = "no description", }; var mesParam1_third = new MessureParam() { Id = Guid.NewGuid(), AppId = app3.Id, ParamName = "m1", ParamSymbol = "m1", PrecisionNum = 2, UnitSymbol = "no", Order = 1, Description = "no description", }; var calcParam1_third = new CalculateParam() { Id = Guid.NewGuid(), AppId = app3.Id, ParamName = "cal1", ParamSymbol = "cal1", PrecisionNum = 2, UnitSymbol = "no", Order = 1, Description = "no description", }; context.AppParams.AddOrUpdate(conParam1_third, mesParam1_third, calcParam1_third); ///first app fomula var formula = new Formula() { Id = Guid.NewGuid(), ParamId = calcParam1.Id, StartDate = DateTimeOffset.MinValue, EndDate = DateTimeOffset.MaxValue, CalculateOrder = 1, FormulaExpression = "c1+m1" }; context.Formulae.AddOrUpdate(formula); var formula_third = new Formula() { Id = Guid.NewGuid(), ParamId = calcParam1_third.Id, StartDate = DateTimeOffset.MinValue, EndDate = DateTimeOffset.MaxValue, CalculateOrder = 1, FormulaExpression = "c1+m1+FirstApp.cal1" }; context.Formulae.AddOrUpdate(formula_third); //添加第三支仪器的数据 count = 10; for (int i = 0; i < count; i++) { MessureValue mv = new MessureValue() { Id = Guid.NewGuid(), ParamId = mesParam1_third.Id, Date = date.AddDays(-i), Val = i + 1 }; CalculateValue cv = new CalculateValue() { Id = Guid.NewGuid(), ParamId = calcParam1_third.Id, Date = date.AddDays(-i), Val = i + 2 }; var remark = new Remark() { Id = Guid.NewGuid(), Date = date.AddDays(-i), RemarkText = "remark" + i + 1, AppId = app3.Id, }; context.MessureValues.AddOrUpdate(mv); context.CalculateValues.AddOrUpdate(cv); context.Remarks.AddOrUpdate(remark); } }
public Apparatus(string name, ApparatusType type) : base(name) { Model = Constants.DefaultModelValue; Type = type; DisplayName = ""; }