private void MergeAndOutput(object sender, RoutedEventArgs e) { if (org == null) { MessageBox.Show("please load total file!"); return; } if (sortedMap == null) { MessageBox.Show("please load sorted file!"); return; } textBox.Text += "Processing... \n"; string id; string sortedNo; for (int i = 0; i < org.Rows.Count; i++) { id = org.Rows[i][0].ToString(); if (sortedMap.ContainsKey(id)) { sortedNo = sortedMap[id]; if (org.Rows[i][1] == DBNull.Value) { org.Rows[i][1] = sortedNo; } } } CommonTools.SaveDataTable2Excel(org, "保存输出表"); }
private void SortAndSave(object sender, RoutedEventArgs e) { try { DataTable sorted = DoSort(sort_in); sort_out = mergeBack(sort_in, sorted); //这张表是一张干净的,不包含空格,只包含笔顺和次序的表 CommonTools.SaveDataTable2Excel(sorted, "保存笔顺表"); textBox.Text += "output row lines:" + sorted.Rows.Count.ToString() + "\n"; DataRow[] selected = sorted.Select("initial = 0"); if (isChineseWordExist(selected, 1)) { MessageBox.Show("Check Unidentify Chinese Words First!"); return; } //根据原表的结构填回,只包含次序,不包含笔顺。 CommonTools.SaveDataTable2Excel(sort_out, "保存分类排序表"); textBox.Text += "output row lines:" + sort_out.Rows.Count.ToString() + "\n"; } catch (Exception err) { MessageBox.Show(err.Message); } }
private void SortAndSave(object sender, RoutedEventArgs e) { try { sort_out = DoSort(sort_in); } catch (Exception err) { MessageBox.Show(err.Message); } CommonTools.SaveDataTable2Excel(sort_out, "保存分类排序表"); textBox.Text += "output row lines:" + sort_out.Rows.Count.ToString() + "\n"; }