示例#1
0
        private void ComboboxSave()
        {
            XmlRead read   = new XmlRead();
            int     result = 0;

            try
            {
                int num2;
                read.Delete(FileName.File1);
                int.TryParse(this.txt_1.Text, out result);
                result--;
                if (result < 0)
                {
                    result = 0;
                }
                DataTable table = ExcelRead.ExcelToDataTable(this.file_1.get_TextBoxFile().Text, this.com_sheet_1.Text.Trim() + "$", 0);
                for (num2 = 0; num2 < table.Columns.Count; num2++)
                {
                    int num3 = num2 + 1;
                    read.File1AppendChild("1." + num3.ToString(), table.Rows[Convert.ToInt32(result)][num2].ToString());
                }
                read.Delete(FileName.File2);
                int.TryParse(this.txt_2.Text, out result);
                result--;
                if (result < 0)
                {
                    result = 0;
                }
                if (File.Exists(this.file_2.get_TextBoxFile().Text.Trim()))
                {
                    DataTable table2 = ExcelRead.ExcelToDataTable(this.file_2.get_TextBoxFile().Text, this.com_sheet_2.Text.Trim() + "$", 0);
                    for (num2 = 0; num2 < table2.Columns.Count; num2++)
                    {
                        read.File2AppendChild("2." + ((num2 + 1)).ToString(), table.Rows[Convert.ToInt32(result)][num2].ToString());
                    }
                }
                Regex regex = new Regex(@"^\[\d+\]");
                read.SetKey1(regex.Replace(this.combo_1.Text.Trim(), string.Empty));
                read.SetKey2(regex.Replace(this.combo_2.Text.Trim(), string.Empty));
            }
            catch (Exception exception)
            {
                MessageBoxHelper.Show(exception.ToString(), "异常");
            }
        }