private void cDataGridView1_ButtonSelectClick(CDataGridView cdgv, int rowindex, int columnindex) { string linetabletypename = ""; //表结构名称 string linetablename = ""; //表名称 if (((DataTable)cdgv.DataSource).TableName.ToString() == "IM") { linetabletypename = ((DataTable)cdgv.DataSource).Namespace.ToString() + "T" + "." + ((DataTable)cdgv.DataSource).Rows[rowindex]["Code"].ToString(); } else { linetabletypename = ((DataTable)cdgv.DataSource).Namespace.ToString() + "." + ((DataTable)cdgv.DataSource).Columns[columnindex].ColumnName.ToString(); } linetablename = linetabletypename + "[R" + (rowindex + 1).ToString() + ",C" + (columnindex + 1).ToString() + "]"; if (!ds.Tables.Contains(linetablename)) { //不存在则创建 DataTable dt = new DataTable(); dt = ds.Tables[linetabletypename].Clone(); dt.Namespace = linetabletypename; dt.TableName = linetablename; ds.Tables.Add(dt); } FullTable a = new FullTable(); a.Text = linetablename; a.ds = ds; a.dt = ds.Tables[linetablename]; a.ShowDialog(); cdgv.Rows[rowindex].Cells[columnindex].Value = "点击赋值:" + a.lines.ToString() + "行"; }
private void toolStripMenuItem4_Click(object sender, EventArgs e) { try { FullTable a = new FullTable(); a.dt = this.DataSource as DataTable; a.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public async Task PrepareData() { // Prepare data only if needed if (Config.Reload || !File.Exists(Config.FullDataFile)) { // Data DataContainer dataContainer = new DataContainer(); // Data list DataSource[] dataSources = new DataSource[] { new Products(Config.Reload), new HistoricalPrices(Config.Reload), new Weather(Config.Reload), new Forex(Config.Reload), new Google(Config.Reload), new WikiTrends(Config.Reload), new Futures(Config.Reload), new Fundamentals(Config.Reload) }; // Go to data folder Directory.SetCurrentDirectory(Config.DataDirectory); // Prepare all data foreach (DataSource ds in dataSources) { await ds.Prepare(dataContainer); } // Create datatable FullTable fullTable = new FullTable(); fullTable.CreateFullTable(dataContainer); // Export data Directory.CreateDirectory(Config.TradingDataFolder); Exporter.ExportCSV(fullTable.DataTable, true, Config.FullDataFile, "Exporting full data"); Console.WriteLine(); } // Create RNN data if (Config.Reload || !File.Exists(Config.RnnTrainXFile) || !File.Exists(Config.RnnTrainYFile) || !File.Exists(Config.RnnValidXFile) || !File.Exists(Config.RnnValidYFile) || !File.Exists(Config.RnnTestXFile) || !File.Exists(Config.RnnTestYFile)) { // Create datatable RnnTable rnnTable = new RnnTable(); rnnTable.CreateRnnTable(); // Export data Exporter.ExportRnnConfig(rnnTable.RnnConfig, Config.RnnConfigFile); Exporter.ExportCSV(rnnTable.TrainX, Config.RnnTrainXFile); Exporter.ExportCSV(rnnTable.TrainY, Config.RnnTrainYFile); Exporter.ExportCSV(rnnTable.ValidX, Config.RnnValidXFile); Exporter.ExportCSV(rnnTable.ValidY, Config.RnnValidYFile); Exporter.ExportCSV(rnnTable.TestX, Config.RnnTestXFile); Exporter.ExportCSV(rnnTable.TestY, Config.RnnTestYFile); Console.WriteLine(); } }