public async Task <List <IFreeDocument> > GetDataFromDB(IDataBaseConnector db, string dataName, bool isNewData, int mount = -1) { if (db == null) { return(null); } var table = db.RefreshTableNames().FirstOrDefault(d => d.Name == dataName); var dataAll = new List <IFreeDocument>(); var task = TemporaryTask <FreeDocument> .AddTempTaskSimple(dataName + GlobalHelper.Get("key_222"), db.GetEntities(dataName, mount), dataAll.Add, null, table?.Size ?? -1, notifyInterval : 1000); processManager.CurrentProcessTasks.Add(task); await Task.Run( () => task.Wait()); return(dataAll); }
public override bool Init() { if (MainDescription.IsUIForm) { DataCollections = new SafeObservable <DataCollection>(); dockableManager = MainFrmUI as IDockableManager; var views = "223:Mini 794:Middle"; foreach (var item in views.Split(' ')) { var item2 = item.Split(':'); var name = item2[0]; var control = FrmState.Mini; Enum.TryParse(item2[1], out control); var itemName = "key_" + name; itemName = GlobalHelper.Get(itemName); var view = PluginProvider.GetObjectInstance <ICustomView>(GlobalHelper.Get(itemName)); var userControl = view as UserControl; if (userControl != null) { if (name == "223") { dynamic dcontrol = userControl; dataListBox = dcontrol.dataListBox as ListBox; } userControl.DataContext = MainFrmUI; dockableManager.AddDockAbleContent(control, view, itemName); } } } else { DataCollections = new ObservableCollection <DataCollection>(); } processManager = MainFrmUI.PluginDictionary["DataProcessManager"] as IProcessManager; commands = new List <ICommand>(); var dbaction = new BindingAction(); dbaction.ChildActions.Add(new Command(GlobalHelper.Get("key_224"), obj => { var w = PropertyGridFactory.GetPropertyWindow(obj); w.ShowDialog(); }, obj => obj != null, "edit")); dbaction.ChildActions.Add( new Command(GlobalHelper.Get("key_142"), obj => RefreshConnect(obj as IDataBaseConnector), obj => obj != null, "refresh")); dbaction.ChildActions.Add( new Command(GlobalHelper.Get("key_213"), 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()); }; PropertyGridFactory.GetPropertyWindow(query).ShowDialog(); }, obj => obj != null, "magnify")); dbaction.ChildActions.Add( new Command(GlobalHelper.Get("key_225"), obj => { if ( MessageBox.Show(GlobalHelper.Get("key_226"), GlobalHelper.Get("key_99"), MessageBoxButton.YesNoCancel) == MessageBoxResult.Yes) { var con = obj as DBConnectorBase; _dbConnections.Remove(con); } }, obj => obj != null, "delete")); var dataaction = new BindingAction(); var tableAction = new BindingAction(); tableAction.ChildActions.Add(new Command( GlobalHelper.Get("view"), async obj => { var items = obj as TableInfo; List <IFreeDocument> dataAll = null; try { dataAll = await GetDataFromDB(items.Connector, items.Name, true, items.Connector is FileManager ? -1 : 200); } catch (Exception ex) { MessageBox.Show(GlobalHelper.Get("key_228") + ex.Message); return; } if (dataAll == null || dataAll.Count == 0) { XLogSys.Print.Warn(GlobalHelper.Get("key_229")); return; } if (items.Connector is FileManager) { var file = (items.Connector as FileManager).LastFileName; var name = Path.GetFileNameWithoutExtension(file); AddDataCollection(dataAll, name, isCover: true); return; } var excel = PluginProvider.GetObjectInstance <IDataViewer>(GlobalHelper.Get("key_230")); if (excel == null) { return; } var view = excel.SetCurrentView(dataAll.Select(d => d).ToList()); if (ControlExtended.DockableManager != null) { ControlExtended.DockableManager.AddDockAbleContent( FrmState.Custom, view, items.Name); } }, obj => obj != null)); tableAction.ChildActions.Add(new Command( GlobalHelper.Get("key_231"), async obj => { var items = obj as TableInfo; var datas = await GetDataFromDB(items.Connector, items.Name, true); if (datas == null) { return; } AddDataCollection(datas, items.Name); }, obj => obj != null, "add")); tableAction.ChildActions.Add(new Command( GlobalHelper.Get("key_232"), obj => { var con = obj as TableInfo; ReadCollection(con.Connector, con.Name, true); }, obj => obj != null, "layer_add")); tableAction.ChildActions.Add(new Command( GlobalHelper.Get("key_233"), obj => { var items = obj as TableInfo; DropTable(items.Connector, items.Name); }, obj => obj != null, "delete")); tableAction.ChildActions.Add(new Command( GlobalHelper.Get("key_234"), obj => { var w = PropertyGridFactory.GetPropertyWindow(obj); w.ShowDialog(); }, obj => obj != null, "edit")); tableAction.ChildActions.Add(new Command( GlobalHelper.Get("key_213"), 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()); }; PropertyGridFactory.GetPropertyWindow(query).ShowDialog(); }, obj => obj != null, "magnify")); var visitData = new BindingAction(GlobalHelper.Get("key_235")); var 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(GlobalHelper.Get("key_236"), GlobalHelper.Get("key_99")); return; } ControlExtended.UIInvoke(() => { var view = PluginProvider.GetObjectInstance <IDataViewer>(d.Name); var r = view.SetCurrentView(data.ComputeData); if (ControlExtended.DockableManager != null) { var window = new Window { Title = data.Name + " " + d.Name }; window.WindowState = WindowState.Maximized; window.Content = r; window.Activate(); window.ShowDialog(); } }); }; return(comm); }); visitData.Execute = obj => visitCommands.FirstOrDefault(d => d.Text == GlobalHelper.Get("key_230")).Execute(obj); foreach (var visitCommand in visitCommands) { visitData.ChildActions.Add(visitCommand); } dataaction.ChildActions.Add(new Command( GlobalHelper.Get("smartetl_name"), obj => { var collection = GetSelectedCollection(obj).FirstOrDefault(); if (collection == null) { return; } var plugin = processManager.GetOneInstance("SmartETLTool", true, true, true) as SmartETLTool; dynamic generator = PluginProvider.GetObjectByType <IColumnProcess>("TableGE"); generator.Father = plugin; generator.TableSelector.SelectItem = collection.Name; plugin.CurrentETLTools.Add(generator); plugin.ETLMount++; plugin.Init(); //plugin.RefreshSamples(true); ControlExtended.DockableManager.ActiveModelContent(plugin); }, obj => true, "new")); var saveData = new Command(GlobalHelper.Get("key_237"), d => { var collection = GetSelectedCollection(d).FirstOrDefault(); if (collection == null) { return; } var ofd = new SaveFileDialog { Filter = FileConnector.GetDataFilter(), DefaultExt = "*" }; ofd.FileName = collection.Name + ".xlsx"; if (ofd.ShowDialog() == true) { var filename = ofd.FileName; SaveFile(collection.Name, filename); } }, obj => true, "save"); dataaction.ChildActions.Add(saveData); dataaction.ChildActions.Add(visitData); dataaction.ChildActions.Add(new Command( GlobalHelper.Get("key_238"), obj => { if (obj != null) { foreach (var collection in GetSelectedCollection(obj)) { if (collection == null) { return; } var n = collection.Clone(true); n.Name = GetNewName(collection.Name); DataCollections.Add(n); } } else { DataCollections.Add(new DataCollection(new List <IFreeDocument>()) { Name = GetNewName(GlobalHelper.Get("key_239")) }); } ; }, obj => true, "add")); dataaction.ChildActions.Add(new Command( GlobalHelper.Get("key_240"), obj => { var collection = GetSelectedCollection(obj).ToList(); if (!collection.Any()) { return; } PropertyGridFactory.GetPropertyWindow(collection.FirstOrDefault()).ShowDialog(); }, obj => true, "settings")); dataaction.ChildActions.Add(new Command( GlobalHelper.Get("key_169"), obj => { foreach (var collection in GetSelectedCollection(obj)) { if (collection != null) { DataCollections.Remove(collection); } } }, obj => true, "delete")); var convert = new BindingAction(GlobalHelper.Get("key_241")); dataaction.ChildActions.Add(convert); convert.ChildActions.Add(new Command(GlobalHelper.Get("key_242"), obj => { var coll = GetSelectedCollection(obj).FirstOrDefault(); if (coll == null) { return; } if (coll.Count > 500000) { if ( MessageBox.Show(GlobalHelper.Get("key_243"), GlobalHelper.Get("key_99"), MessageBoxButton.YesNoCancel) != MessageBoxResult.Yes) { return; } } var docuts = new List <IFreeDocument>(); var task = TemporaryTask <FreeDocument> .AddTempTaskSimple(GlobalHelper.Get("key_242"), coll.ComputeData, d => { if (d != null) { docuts.Add(d); } }, result => { var collection = new DataCollection(docuts) { Name = coll.Name + '1' }; AddDataCollection(collection); DataCollections.Remove(coll); }); processManager.CurrentProcessTasks.Add(task); })); var insertdb = new BindingAction(GlobalHelper.Get("key_244")); insertdb.SetChildActionSource(() => { return(_dbConnections.Select(dataBaseConnector => new Command(dataBaseConnector.Name, obj => { var data = obj as DataCollection; processManager.CurrentProcessTasks.Add( TemporaryTask <FreeDocument> .AddTempTaskSimple(data.Name + GlobalHelper.Get("key_245"), dataBaseConnector.InserDataCollection(data), null, continueAction: (a) => dataBaseConnector.RefreshTableNames(), count: data.Count / 1000)); }, obj => dataBaseConnector.IsUseable, icon: "database")).Cast <ICommand>().ToList()); }); dataaction.ChildActions.Add(insertdb); var otherDataAction = new BindingAction(); otherDataAction.ChildActions.Add(new Command(GlobalHelper.Get("key_132"), obj => CleanData(), obj => DataCollections.Count > 0, "clear")); commands.Add(dbaction); commands.Add(tableAction); commands.Add(dataaction); commands.Add(otherDataAction); var dblistAction = new BindingAction(GlobalHelper.Get("key_246")); var addnew = new BindingAction(GlobalHelper.Get("key_247")) { Icon = "add" }; dblistAction.ChildActions.Add(addnew); foreach (var 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); }, Icon = "connect" }); } commands.Add(dblistAction); dockableManager = MainFrmUI as IDockableManager; if (processManager?.CurrentProject != null) { LoadDataConnections(processManager.CurrentProject.DBConnections); } if (MainDescription.IsUIForm) { ConfigUI = PropertyGridFactory.GetInstance(_dbConnections.FirstOrDefault()); } var changed = DataCollections as INotifyCollectionChanged; changed.CollectionChanged += (s, e) => OnDataSourceChanged(new EventArgs()); return(true); }