public string ReStart(string id, int index = 1, int size = 100, int count = 1000)
{
var work_order = db.work_order.FirstOrDefault(a => a.OrderId == id);
var from = db.data_source.Find(work_order.InportSourceId);
var to = db.data_source.Find(work_order.ExportSourceId);
var fieldMapping =
(from a in db.field_mapping
join b in db.method on a.MethodId equals b.Id
where a.OrderId == work_order.OrderId && a.Creator == "1"
select new FieldMappingItem()
{
field = a.FieldIn,
toField = a.FieldOut,
method = (int)b.Id,
methodClassName = b.TypeFillName,
methodDll = b.AssemblyPath,
methodName = b.MethodName,
}).ToList();
if (from == null || to == null || fieldMapping.Count <= 0)
{
throw new CheckException("配置不完善");
}
var param = new TransferParam
{
OrderId = work_order.OrderId,
FromConnString = @from.Link,
FromTable = @from.TableName,
FromTypeCode = @from.TypeCode,
Where = work_order.InportWhere,
OrderBy = work_order.InportOrderByField,
ToConnString = to.Link,
ToTypeCode = to.TypeCode,
ToTable = to.TableName,
Index = index,
Size = size,
Count = count,
FieldMapping = fieldMapping
};
TransferEngine.Start(param);
return("Ok");
}
public IHttpActionResult Postwork_order(work_order work_order)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (!db.field_mapping.Any(a => a.OrderId == work_order.OrderId && a.State == 0))
{
throw new Exception("请配置字段映射关系");
}
var runState = 1;
if (db.work_order.Any(a => a.InportSourceId == work_order.InportSourceId && a.ExportSourceId == work_order.ExportSourceId && a.State == runState))
{
throw new Exception("已存在正在运行的迁移策略.");
}
if (work_order.StartTime == default(DateTime))
{
work_order.StartTime = DateTime.Now;
}
if (work_order.PageIndex <= 0)
{
work_order.PageIndex = 1;
}
work_order.CreateTime = DateTime.Now;
work_order.UserId = 1;
work_order.Creator = "1";
work_order.EndTime = DateTime.Now;
work_order.InportWhere = work_order.InportWhere ?? string.Empty;
work_order.Remake = work_order.Remake ?? string.Empty;
work_order.InportOrderByField = work_order.InportOrderByField ?? string.Empty;
work_order.Modifier = "1";
work_order.ModifyTime = DateTime.Now;
work_order.Exception = string.Empty;
db.work_order.Add(work_order);
db.SaveChanges();
var from = db.data_source.Find(work_order.InportSourceId);
var to = db.data_source.Find(work_order.ExportSourceId);
var fieldMapping =
(from a in db.field_mapping
join b in db.method on a.MethodId equals b.Id
where a.OrderId == work_order.OrderId && a.Creator == "1"
select new FieldMappingItem()
{
field = a.FieldIn,
toField = a.FieldOut,
method = (int)b.Id,
methodClassName = b.TypeFillName,
methodDll = b.AssemblyPath,
methodName = b.MethodName,
}).ToList();
if (from == null || to == null || fieldMapping.Count <= 0)
{
throw new CheckException("配置不完善");
}
var param = new TransferParam
{
OrderId = work_order.OrderId,
FromConnString = @from.Link,
FromTable = @from.TableName,
FromTypeCode = @from.TypeCode,
Where = work_order.InportWhere,
OrderBy = work_order.InportOrderByField,
ToConnString = to.Link,
ToTypeCode = to.TypeCode,
ToTable = to.TableName,
Size = work_order.PageSize,
Count = (int)work_order.DataCount,
FieldMapping = fieldMapping
};
TransferEngine.Start(param);
return(CreatedAtRoute("DefaultApi", new { id = work_order.Id }, work_order));
}