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.MessureParams.Count();
DateTime minDate = new DateTime(1970, 1, 1);
var newItem = new MessureValue();
foreach (var paramItem in dam5Entities.MessureParams.AsNoTracking())
{
//寻找已有数据中的最大date
DateTimeOffset maxDate = (from i in dam6Entities.MessureValues
where i.ParamId == paramItem.MessureParamID
select i.Date).DefaultIfEmpty(minDate).Max();
//get all mes values which >maxDate
var query = from i in dam5Entities.MessureValues.AsNoTracking()
where i.messureParamID == paramItem.MessureParamID && i.Date > maxDate
select i;
foreach (var item in query)
{
newItem.Id = Guid.NewGuid();
newItem.ParamId = item.messureParamID;
newItem.Date = item.Date;
newItem.Val = item.Val;
dam6Entities.MessureValues.Add(newItem);
dam6Entities.SaveChanges();
dam6Entities.Entry(newItem).State = System.Data.Entity.EntityState.Detached;;
}
handledCnt++;
reportProgress();
}
}
}
reportProgress();
bgwResult = "导入成功!";
}
catch (Exception ex)
{
if (ex.InnerException != null)
{
bgwResult = ex.InnerException.Message;
}
else
{
bgwResult = ex.Message;
}
}
}
public void TestConnection()
{
string result = "";
try
{
using (EF5x.Models.DamDBContext dam5xEntities = new EF5x.Models.DamDBContext())
{
//dam5xEntities.Database.Connection.ConnectionString = ConnectionString5x;
dam5xEntities.Database.Connection.Open();
dam5xEntities.Database.Connection.Close();
}
using (DamWCFContext dam6xEntities = new DamWCFContext(false))
{
//dam6xEntities.Database.Connection.ConnectionString = ConnectionString6x;
dam6xEntities.Database.Connection.Open();
dam6xEntities.Database.Connection.Close();
}
result = "连接测试成功";
}
catch (Exception ex)
{
result = ex.ToString();
}
ResultString = result;
}
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.Apparatus.Count();
foreach (var item in dam5Entities.Apparatus.AsNoTracking())
{
if (dam6Entities.Apps.FirstOrDefault(i => i.AppName == item.AppName) == null)
{
var newItem = new Hammergo.Data.App();
newItem.Id = Guid.NewGuid();
newItem.AppName = item.AppName;
newItem.CalculateName = item.CalculateName;
newItem.AppTypeID = item.AppTypeID;
newItem.ProjectPartID = item.ProjectPartID;
newItem.BuriedTime = item.BuriedTime;
newItem.OtherInfo = item.OtherInfo;
newItem.X = item.X;
newItem.Y = item.Y;
newItem.Z = item.Z;
dam6Entities.Apps.Add(newItem);
dam6Entities.SaveChanges();
dam6Entities.Entry(newItem).State = 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 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.ProjectParts.Count();
foreach (var item in dam5Entities.ProjectParts)
{
if (dam6Entities.ProjectParts.FirstOrDefault(i => i.Id == item.ProjectPartID) == null)
{
ProjectPart newItem = new ProjectPart();
newItem.Id = item.ProjectPartID;
newItem.PartName = item.PartName;
newItem.ParentPart = item.ParentPart;
dam6Entities.ProjectParts.Add(newItem);
dam6Entities.SaveChanges();
dam6Entities.Entry(newItem).State = 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 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.MessureParams.Count();
foreach (var item in dam5Entities.CalculateParams.AsNoTracking())
{
var id = (from i in dam6Entities.Apps.AsNoTracking()
where i.AppName == item.appName
select i).First().Id;
if (dam6Entities.CalculateParams.FirstOrDefault(i => i.Id == item.CalculateParamID) == null)
{
var newItem = new CalculateParam();
newItem.AppId = id;
newItem.Id = item.CalculateParamID;
newItem.Description = item.Description;
newItem.Order = item.Order == null?(byte)0:item.Order.Value;
newItem.ParamName = item.ParamName;
newItem.ParamSymbol = item.ParamSymbol;
newItem.PrecisionNum = item.PrecisionNum == null ? (byte)0 : item.PrecisionNum.Value;
newItem.UnitSymbol = item.UnitSymbol;
var formula = new Formula();
formula.Id = Guid.NewGuid();
formula.ParamId = item.CalculateParamID;
formula.FormulaExpression = item.CalculateExpress;
byte calcOrder = 1;
if (item.CalculateOrder != null)
{
calcOrder = item.CalculateOrder.Value;
}
formula.CalculateOrder = calcOrder;
formula.StartDate = new DateTime(1970, 1, 1); //默认公式的时间刻度
formula.EndDate = new DateTime(9999, 12, 31); //默认终止时间
dam6Entities.CalculateParams.Add(newItem);
dam6Entities.Formulae.Add(formula);
dam6Entities.SaveChanges();
dam6Entities.Entry(newItem).State = System.Data.Entity.EntityState.Detached;;
dam6Entities.Entry(formula).State = 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 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.MessureParams.Count();
foreach (var item in dam5Entities.MessureParams.AsNoTracking())
{
var id = (from i in dam6Entities.Apps.AsNoTracking()
where i.AppName == item.appName
select i).First().Id;
if (dam6Entities.MessureParams.FirstOrDefault(i => i.Id == item.MessureParamID) == null)
{
var newItem = new MessureParam();
newItem.AppId = id;
newItem.Id = item.MessureParamID;
newItem.Description = item.Description;
newItem.Order = item.Order == null?(byte)0:item.Order.Value;
newItem.ParamName = item.ParamName;
newItem.ParamSymbol = item.ParamSymbol;
newItem.PrecisionNum = item.PrecisionNum == null ? (byte)0 : item.PrecisionNum.Value;
newItem.UnitSymbol = item.UnitSymbol;
dam6Entities.MessureParams.Add(newItem);
dam6Entities.SaveChanges();
dam6Entities.Entry(newItem).State = 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 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);
//import tasktype
foreach (var taskType in dam5Entities.TaskTypes)
{
var newTaskType = new TaskType();
newTaskType.Id = taskType.TaskTypeID;
newTaskType.TypeName = taskType.TypeName;
dam6Entities.TaskTypes.Add(newTaskType);
dam6Entities.SaveChanges();
dam6Entities.Entry(newTaskType).State = System.Data.Entity.EntityState.Detached;
}
_allRowCnt = dam5Entities.AppCollections.Count();
DateTime minDate = new DateTime(1970, 1, 1);
var newAppCol = new AppCollection();
var newTaskApp = new TaskApp();
foreach (var oldItem in dam5Entities.AppCollections)
{
newAppCol.Id = oldItem.AppCollectionID;
newAppCol.CollectionName = oldItem.CollectionName;
newAppCol.Description = oldItem.Description;
newAppCol.Order = oldItem.Order;
newAppCol.TaskTypeID = oldItem.taskTypeID;
dam6Entities.AppCollections.Add(newAppCol);
dam6Entities.SaveChanges();
dam6Entities.Entry(newAppCol).State = System.Data.Entity.EntityState.Detached;;
var query = from i in dam5Entities.TaskAppratus
where i.appCollectionID == newAppCol.Id
select i;
foreach (var item in query)
{
var id = (from i in dam6Entities.Apps
where i.AppName == item.appName
select i).First().Id;
newTaskApp.Id = Guid.NewGuid();
newTaskApp.AppId = id;
newTaskApp.Order = item.Order;
newTaskApp.AppCollectionID = item.appCollectionID;
dam6Entities.TaskApps.Add(newTaskApp);
dam6Entities.SaveChanges();
dam6Entities.Entry(newTaskApp).State = System.Data.Entity.EntityState.Detached;;
}
handledCnt++;
reportProgress();
}
}
}
reportProgress();
bgwResult = "导入成功!";
}
catch (Exception ex)
{
if (ex.InnerException != null)
{
bgwResult = ex.InnerException.Message;
}
else
{
bgwResult = ex.Message;
}
}
}
