public override bool Init(IEnumerable<IFreeDocument> datas)
{
collection = dataManager.DataCollections.FirstOrDefault(d => d.Name == Table);
if (collection == null && string.IsNullOrEmpty(Table) == false)
{
collection = new DataCollection(new List<IFreeDocument>()) {Name = Table};
dataManager.AddDataCollection(collection);
}
return base.Init(datas);
}
public DataCollection Clone(bool isdeep)
{
var docuts = new List<IFreeDocument>();
for (int i = 0; i < ComputeData.Count; i ++)
{
if (isdeep)
{
var fr = new FreeDocument();
ComputeData[i].DictCopyTo(fr);
docuts.Add(fr);
}
else
{
docuts.Add(ComputeData[i] as IFreeDocument);
}
}
var collection = new DataCollection(docuts);
collection.Name = Name + '1';
collection.TableInfo = this.TableInfo.Clone();
return collection;
}
public void SaveFile(DataCollection dataCollection, string path = null, string format = null)
{
IFileConnector exporter = null;
if (format != null)
{
exporter = PluginProvider.GetObjectInstance<IFileConnector>(format);
}
else
{
exporter = FileConnector.SmartGetExport(path);
}
if (exporter == null)
{
return;
}
IList<IFreeDocument> data = dataCollection.ComputeData;
exporter.FileName = path;
processManager.CurrentProcessTasks.Add(TemporaryTask.AddTempTask(dataCollection + "导出数据任务", exporter.WriteData(data), null, result =>
{
if (MainDescription.IsUIForm && string.IsNullOrEmpty(exporter.FileName) == false)
{
if (MessageBox.Show("文件导出成功，是否要打开查看?", "提示信息", MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
try
{
System.Diagnostics.Process.Start(exporter.FileName);
}
catch (Exception ex)
{
MessageBox.Show("打开文件失败：" + ex.Message);
}
}
}
}, data.Count,notifyInterval:1000));
}
public void AddDataCollection(DataCollection collection)
{
DataCollections.Add(collection);
}
public DataCollection AddDataCollection(
IEnumerable<IFreeDocument> source, string collectionName = null, bool isCover = false)
{
if (collectionName == null)
{
collectionName = "数据集" + DateTime.Now.ToShortTimeString();
}
DataCollection collection = DataCollections.FirstOrDefault(d => d.Name == collectionName);
if (collection != null)
{
if (!isCover)
{
foreach (IFreeDocument computeable in source)
{
collection.ComputeData.Add(computeable);
}
collection.OnPropertyChanged("Count");
}
else
{
XLogSys.Print.Warn(collectionName + "数据源已经存在，不进行覆盖，没有保存");
}
return collection;
}
var data = new DataCollection(source.ToList()) {Name = collectionName};
DataCollections.Add(data);
return data;
}
public override bool Init()
{
if (MainDescription.IsUIForm)
{
DataCollections = new SafeObservable<DataCollection>();
dockableManager = MainFrmUI as IDockableManager;
var view = PluginProvider.GetObjectInstance<ICustomView>("系统状态视图");
var userControl = view as UserControl;
if (userControl != null)
{
userControl.DataContext = MainFrmUI;
dockableManager.AddDockAbleContent(FrmState.Mini, view, "系统状态视图");
}
}
else
{
DataCollections = new ObservableCollection<DataCollection>();
}
processManager = MainFrmUI.PluginDictionary["模块管理"] as IProcessManager;
commands = new List<ICommand>();
var dbaction = new BindingAction();
dbaction.ChildActions.Add(new Command("配置连接",
obj =>
{
Window w = PropertyGridFactory.GetPropertyWindow(obj);
w.ShowDialog();
},
obj => obj != null));
dbaction.ChildActions.Add(
new Command("刷新", obj => RefreshConnect(obj as IDataBaseConnector), obj => obj != null));
dbaction.ChildActions.Add(
new Command("执行查询", obj =>
{
var query = new QueryEntity();
query.Connector = obj as IDataBaseConnector;
query.GetQueryFunc = d =>
{
if (d == null)
return;
if (d.Any() == false)
return;
AddDataCollection(d, GetNewName());
};
propertyGridWindow.SetObjectView(query);
}, obj => obj != null));
dbaction.ChildActions.Add(
new Command("删除连接", obj =>
{
if (MessageBox.Show("确定要删除该连接吗？", "提示信息", MessageBoxButton.YesNoCancel) == MessageBoxResult.Yes)
{
var con = obj as DBConnectorBase;
_dbConnections.Remove(con);
}
}, obj => obj != null));
var dataaction = new BindingAction();
var tableAction = new BindingAction();
tableAction.ChildActions.Add(new Command(
"查看",
async obj =>
{
var items = obj as TableInfo;
List<IFreeDocument> dataAll =
await
GetDataFromDB(items.Connector, items.Name, true,
items.Connector is FileManager ? -1 : 200);
if (dataAll == null || dataAll.Count == 0)
{
XLogSys.Print.Warn("没有在表中的发现可用的数据");
return;
}
if (items.Connector is FileManager)
{
string file = (items.Connector as FileManager).LastFileName;
var name = Path.GetFileNameWithoutExtension(file);
AddDataCollection(dataAll, name);
return;
}
var excel = PluginProvider.GetObjectInstance<IDataViewer>("可编辑列表");
if (excel == null)
return;
object view = excel.SetCurrentView(dataAll.Select(d=>d as IFreeDocument).ToList());
if (ControlExtended.DockableManager != null)
{
ControlExtended.DockableManager.AddDockAbleContent(
FrmState.Custom, view, items.Name);
}
},
obj => obj != null));
tableAction.ChildActions.Add(new Command(
"添加到数据集",
async obj =>
{
var items = obj as TableInfo;
List<IFreeDocument> datas = await GetDataFromDB(items.Connector, items.Name, true);
if (datas == null)
return;
AddDataCollection(datas, items.Name);
},
obj => obj != null));
tableAction.ChildActions.Add(new Command(
"添加虚拟数据集",
obj =>
{
var con = obj as TableInfo;
ReadCollection(con.Connector, con.Name, true);
},
obj => obj != null));
tableAction.ChildActions.Add(new Command(
"删除表",
obj =>
{
var items = obj as TableInfo;
DropTable(items.Connector, items.Name);
},
obj => obj != null));
tableAction.ChildActions.Add(new Command(
"查看属性",
obj =>
{
Window w = PropertyGridFactory.GetPropertyWindow(obj);
w.ShowDialog();
},
obj => obj != null));
tableAction.ChildActions.Add(new Command(
"执行查询",
obj =>
{
var query = new QueryEntity();
query.TableInfo = obj as TableInfo;
query.Connector = query.TableInfo.Connector;
query.GetQueryFunc = d =>
{
if (d == null)
return;
if (d.Any() == false)
return;
AddDataCollection(d, GetNewName());
};
propertyGridWindow.SetObjectView(query);
}, obj => obj != null));
var visitData = new BindingAction("浏览方式");
IEnumerable<Command> visitCommands = PluginProvider.GetPluginCollection(typeof (IDataViewer)).Select(
d =>
{
var comm = new Command(d.Name);
comm.Execute = d2 =>
{
var data = d2 as DataCollection;
if (data.Count == 0)
{
MessageBox.Show("不存在任何数据", "提示信息");
return;
}
ControlExtended.UIInvoke(() =>
{
var view = PluginProvider.GetObjectInstance<IDataViewer>(d.Name);
object r = view.SetCurrentView(data.ComputeData);
if (ControlExtended.DockableManager != null)
{
ControlExtended.DockableManager.AddDockAbleContent(
FrmState.Float, r, data.Name + " " + d.Name);
}
});
};
return comm;
});
visitData.Execute = obj => visitCommands.FirstOrDefault(d => d.Text == "可编辑列表").Execute(obj);
foreach (Command visitCommand in visitCommands)
{
visitData.ChildActions.Add(visitCommand);
}
dataaction.ChildActions.Add(new Command(
"数据清洗", obj =>
{
DataCollection collection = GetCollection(obj);
if (collection == null) return;
var plugin = processManager.GetOneInstance("SmartETLTool", true, true) as SmartETLTool;
dynamic generator = PluginProvider.GetObjectByType<IColumnProcess>("TableGE");
generator.TableSelector.SelectItem = collection;
plugin.CurrentETLTools.Add(generator);
plugin.RefreshSamples(true);
ControlExtended.DockableManager.ActiveModelContent(plugin);
}, obj => true, "new"));
dataaction.ChildActions.Add(new Command(
"拷贝", obj =>
{
DataCollection collection = GetCollection(obj);
if (collection == null) return;
DataCollection n = collection.Clone(true);
n.Name = GetNewName(collection.Name);
DataCollections.Add(n);
}, obj => true, "page_new"));
var saveData = new Command("另存为", d =>
{
DataCollection collection = GetCollection(d);
if (collection == null)
return;
var ofd = new SaveFileDialog {Filter = FileConnector.GetDataFilter(), DefaultExt = "*"};
ofd.FileName = collection.Name + ".xlsx";
if (ofd.ShowDialog() == true)
{
string filename = ofd.FileName;
SaveFile(collection.Name, filename);
}
}, obj => true, "save");
dataaction.ChildActions.Add(saveData);
dataaction.ChildActions.Add(visitData);
dataaction.ChildActions.Add(new Command(
"新建",
obj =>
DataCollections.Add(new DataCollection(new List<IFreeDocument>())
{
Name = GetNewName("新建数据集")
}), obj => true, "box"));
dataaction.ChildActions.Add(new Command(
"配置", obj =>
{
DataCollection collection = GetCollection(obj);
if (collection != null) propertyGridWindow.SetObjectView(collection);
}, obj => true, "settings"));
dataaction.ChildActions.Add(new Command(
"删除", obj =>
{
DataCollection collection = GetCollection(obj);
if (collection != null) DataCollections.Remove(collection);
}, obj => true, "delete"));
var convert = new BindingAction("转换表类型");
dataaction.ChildActions.Add(convert);
convert.ChildActions.Add(new Command("转为非虚拟数据集", obj =>
{
DataCollection coll = GetCollection(obj);
if (coll.Count > 500000)
{
if (
MessageBox.Show("本集合数据量较大，转换可能会占用较高的内存和导致程序崩溃，确定继续吗?", "提示信息", MessageBoxButton.YesNoCancel) !=
MessageBoxResult.Yes)
{
return;
}
}
var docuts = new List<IFreeDocument>();
var task=TemporaryTask.AddTempTask("转为非虚拟数据集", coll.ComputeData, d =>
{
if (d != null)
docuts.Add(d as IFreeDocument);
}, result =>
{
var collection = new DataCollection(docuts) {Name = coll.Name + '1'};
AddDataCollection(collection);
this.DataCollections.Remove(coll);
});
processManager.CurrentProcessTasks.Add(task);
}));
var insertdb = new BindingAction("保存到数据库");
insertdb.SetChildActionSource(() =>
{
return _dbConnections.Select(dataBaseConnector => new Command(dataBaseConnector.Name, obj =>
{
var data = obj as DataCollection;
processManager.CurrentProcessTasks.Add(TemporaryTask.AddTempTask(data.Name + "插入到数据库", dataBaseConnector.InserDataCollection(data), result => dataBaseConnector.RefreshTableNames(), count: data.Count/1000));
})).Cast<ICommand>().ToList();
});
dataaction.ChildActions.Add(insertdb);
var otherDataAction = new BindingAction();
otherDataAction.ChildActions.Add(new Command("清空数据", obj => CleanData(), obj => DataCollections.Count > 0));
commands.Add(dbaction);
commands.Add(tableAction);
commands.Add(dataaction);
commands.Add(otherDataAction);
var dblistAction = new BindingAction("数据库管理");
var addnew = new BindingAction("增加新连接");
dblistAction.ChildActions.Add(addnew);
foreach (XFrmWorkAttribute item in PluginProvider.GetPluginCollection(typeof (IDataBaseConnector)))
{
addnew.ChildActions.Add(new Command(item.Name)
{
Execute = obj =>
{
var con = PluginProvider.GetObjectInstance(item.MyType) as DBConnectorBase;
con.Name = item.Name;
_dbConnections.Add(con);
}
});
}
commands.Add(dblistAction);
dockableManager = MainFrmUI as IDockableManager;
if (processManager?.CurrentProject != null)
{
LoadDataConnections();
}
processManager.OnCurrentProjectChanged += (s, e) => LoadDataConnections();
ConfigUI = PropertyGridFactory.GetInstance(_dbConnections.FirstOrDefault());
propertyGridWindow = MainFrmUI.PluginDictionary["属性配置器"] as XFrmWorkPropertyGrid;
var changed = DataCollections as INotifyCollectionChanged;
changed.CollectionChanged += (s, e) => OnDataSourceChanged(new EventArgs());
return true;
}