private void tagChooseText_clicked(DataTable tb) { textBox.Text += "File loaded! "; try { single = tb.Clone(); //复制输入tb的结构 DataTable sortTable = SortAccordingToLength(tb, 1); //根据指定列的长度进行排序 Dictionary <string, string> indexMap = SingleExtraction(sortTable, single); //CommonTools.SaveDataTable2Excel(single); idxMap = CommonTools.DictToDataTable <string>(indexMap); //CommonTools.SaveDataTable2Excel(map); } catch (Exception err) { MessageBox.Show(err.Message); } textBox.Text += "input row lines:" + tb.Rows.Count.ToString() + "\n"; originCount = tb.Rows.Count; }
/* * private void LoadIndexFile(object sender, RoutedEventArgs e) * { * var filePath = CommonTools.OpenOneFile(excelSuffix); * if (filePath != null) * { * string[] tableTags = { "Src", "Target" }; * TagChoose tagChoose = new TagChoose(tableTags); * tagChoose.sendTable += new TagChoose.Tabledelegate(tagChooseIndex_clicked); * textBox.Text += "Loading " + filePath + "...\n"; * tagChoose.SetData(filePath); * tagChoose.Show(); * } * } * * private void LoadOrgFile(object sender, RoutedEventArgs e) * { * var filePath = CommonTools.OpenOneFile(excelSuffix); * if (filePath != null) * { * string[] tableTags = { "UniqueId", "Src","Target" }; * TagChoose tagChoose = new TagChoose(tableTags); * tagChoose.sendTable += new TagChoose.Tabledelegate(tagChooseOrg_clicked); * textBox.Text += "Loading " + filePath + "...\n"; * tagChoose.SetData(filePath); * tagChoose.Show(); * } * } * private void LoadSingleFile(object sender, RoutedEventArgs e) * { * var filePath = CommonTools.OpenOneFile(excelSuffix); * if (filePath != null) * { * string[] tableTags = { "UniqueId", "Target" }; * TagChoose tagChoose = new TagChoose(tableTags); * tagChoose.sendTable += new TagChoose.Tabledelegate(tagChooseSingle_clicked); * textBox.Text += "Loading "+ filePath + "...\n"; * tagChoose.SetData(filePath); * tagChoose.Show(); * } * } */ private void DoMerge(object sender, RoutedEventArgs e) { if (simALL == null) { MessageBox.Show("please load origin file!"); return; } if (labelMap == null) { MessageBox.Show("please load index file!"); return; } if (singleDict == null) { MessageBox.Show("please load simple file!"); return; } textBox.Text += "Processing... \n"; for (int i = 0; i < simALL.Rows.Count; i++) { string id = simALL.Rows[i][0].ToString(); if (labelMap.ContainsKey(id)) { id = labelMap[id]; } if (singleDict.ContainsKey(id)) { if (simALL.Rows[i][2] == DBNull.Value) { simALL.Rows[i][2] = singleDict[id]; } } } CommonTools.SaveDataTable2Excel(simALL, "保存输出表"); textBox.Text += "Finished!! \n"; //Thread.Sleep(5000); Close(); }
private void tagChooseIndex_clicked(DataTable dt) { textBox.Text += "File loaded\n"; labelMap = CommonTools.DataTableToDict(dt); }