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 = "";
}
