Exemple #1
0
        private void ExportExceltoolStripButton_Click(object sender, EventArgs e)
        {
            if (myTable.Rows.Count != 0)
            {
                SaveFileDialog saveFileDialog1 = new SaveFileDialog();

                saveFileDialog1.Filter           = "Excel files (*.xls)|*.xls";
                saveFileDialog1.FilterIndex      = 1;
                saveFileDialog1.RestoreDirectory = true;

                if (saveFileDialog1.ShowDialog() == DialogResult.OK)
                {
                    string filename;

                    FormReading fr = new FormReading();
                    fr.Label1.Text = @"正在导出数据,生成Excel文件";
                    fr.Owner       = this;
                    Point point = this.Location;
                    fr.StartPosition = FormStartPosition.Manual;
                    fr.Size          = new Size(300, 100);
                    fr.Location      = new Point(point.X + (this.Size.Width - fr.Size.Width) / 2, point.Y + (this.Size.Height - fr.Size.Height) / 2);
                    fr.Show();

                    filename = saveFileDialog1.FileName;
                    CreateWorkbook(filename);

                    fr.Close();
                }
            }
        }
Exemple #2
0
        private void 打开OToolStripMenuItem_Click(object sender, EventArgs e)
        {
            OpenFileDialog            openFileDialog1 = new OpenFileDialog();
            DataGridViewTextBoxColumn dgvColumn;

            //openFileDialog1.InitialDirectory = System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
            openFileDialog1.Filter           = "Vcf files (*.vcf)|*.vcf|Excel files (*.xls)|*.xls|All files (*.*)|*.*";
            openFileDialog1.FilterIndex      = 1;
            openFileDialog1.RestoreDirectory = true;

            if (openFileDialog1.ShowDialog(this) == DialogResult.OK)
            {
                dataGridView1.DataSource = null;
                dataGridView1.Update();

                myTable  = new DataTable();
                filename = openFileDialog1.FileName;

                #region "打开VCF文件"
                if (openFileDialog1.FilterIndex == 1)
                {
                    ExportExceltoolStripButton.Enabled = true;
                    ExportVCFtoolStripButton.Enabled   = false;

                    System.IO.StreamReader sr = new System.IO.StreamReader(filename);

                    string  name;
                    DataRow row;

                    string s = "";

                    row = myTable.NewRow();

                    int line         = 0;
                    int IndexTel     = 0;
                    int IndexTelWork = 0;

                    string longstring = null;

                    while ((s = sr.ReadLine()) != null)
                    {
                        // 判断最后一个字符是否为"="号
                        // 判读第一个字符是否为"="号
                        if (s.EndsWith("="))
                        {
                            if (longstring == null)
                            {
                                s          = s.Substring(0, s.Length - 1);
                                longstring = s;
                            }
                            else
                            {
                                s          = s.Substring(0, s.Length - 1);
                                longstring = longstring + s;
                            }

                            continue;
                        }
                        if (longstring != null)
                        {
                            if (s.StartsWith("="))
                            {
                                s = longstring + s;
                            }
                            else
                            {
                                s = longstring;
                            }

                            longstring = null;
                        }

                        string[] split = s.Split(new char[] { ':' });

                        if (split.Length > 1)
                        {
                            if (split[0].Contains("BEGIN"))
                            {
                                line = 0;
                                //row = table.NewRow();
                            }
                            if (split[0].Contains("FN"))
                            {
                                if (split[0].Contains("FN;CHARSET=UTF-8"))
                                {
                                    if (split[0].Contains("ENCODING=QUOTED-PRINTABLE"))
                                    {
                                        name = ConvertHexToString(split[1], Encoding.UTF8);
                                    }
                                    else
                                    {
                                        name = split[1];
                                    }

                                    if (!myTable.Columns.Contains("姓名"))
                                    {
                                        myTable.Columns.Add("姓名", typeof(string));
                                    }

                                    row       = myTable.NewRow();
                                    row["姓名"] = name;
                                }
                                else
                                {
                                    if (split[0].Contains("ENCODING=QUOTED-PRINTABLE"))
                                    {
                                        name = ConvertHexToString(split[1], Encoding.UTF8);
                                    }
                                    else
                                    {
                                        name = split[1];
                                    }

                                    if (!myTable.Columns.Contains("姓名"))
                                    {
                                        myTable.Columns.Add("姓名", typeof(string));
                                    }

                                    row       = myTable.NewRow();
                                    row["姓名"] = name;
                                }
                            }

                            if (split[0].Contains("X-OPPO-GROUP;CHARSET=UTF-8"))
                            {
                                if (!myTable.Columns.Contains("群组"))
                                {
                                    myTable.Columns.Add("群组", typeof(string));
                                }

                                row["群组"] = ConvertHexToString(split[1], Encoding.UTF8);
                            }

                            if ((split[0] == "TEL;CELL;PREF") || (split[0] == "TEL;CELL"))
                            {
                                IndexTel++;

                                if (!myTable.Columns.Contains("手机" + IndexTel.ToString()))
                                {
                                    myTable.Columns.Add("手机" + IndexTel.ToString(), typeof(string));
                                }
                                row["手机" + IndexTel.ToString()] = split[1];
                            }

                            if ((split[0] == "TEL;WORK;VOICE") || (split[0] == "TEL;WORK"))
                            {
                                IndexTelWork++;

                                if (!myTable.Columns.Contains("办公电话" + IndexTelWork.ToString()))
                                {
                                    myTable.Columns.Add("办公电话" + IndexTelWork.ToString(), typeof(string));
                                }
                                row["办公电话" + IndexTelWork.ToString()] = split[1];
                            }
                            if ((split[0] == "TEL;HOME;VOICE") || (split[0] == "TEL;HOME"))
                            {
                                if (!myTable.Columns.Contains("住宅电话"))
                                {
                                    myTable.Columns.Add("住宅电话", typeof(string));
                                }
                                row["住宅电话"] = split[1];
                            }
                            if (split[0] == "EMAIL;WORK")
                            {
                                if (!myTable.Columns.Contains("工作邮箱"))
                                {
                                    myTable.Columns.Add("工作邮箱", typeof(string));
                                }
                                row["工作邮箱"] = split[1];
                            }
                            if (split[0] == "EMAIL;HOME")
                            {
                                if (!myTable.Columns.Contains("家庭邮箱"))
                                {
                                    myTable.Columns.Add("家庭邮箱", typeof(string));
                                }
                                row["家庭邮箱"] = split[1];
                            }
                            if (split[0] == "ADR;HOME;CHARSET=UTF-8;ENCODING=QUOTED-PRINTABLE")
                            {
                                string addr;

                                addr = split[1].Trim(';');
                                addr = ConvertHexToString(addr, Encoding.UTF8);

                                if (!myTable.Columns.Contains("家庭地址"))
                                {
                                    myTable.Columns.Add("家庭地址", typeof(string));
                                }
                                row["家庭地址"] = addr;
                            }
                            if (split[0] == "ADR;WORK;CHARSET=UTF-8;ENCODING=QUOTED-PRINTABLE")
                            {
                                string addr = null;

                                string[] addrs;

                                addrs = split[1].Split(new char[] { ';' });

                                for (int x = addrs.Length; x > 0; x--)
                                {
                                    addr += addrs[x - 1];
                                }



                                //addr = split[1].Replace(";","");
                                addr = ConvertHexToString(addr, Encoding.UTF8);

                                if (!myTable.Columns.Contains("单位地址"))
                                {
                                    myTable.Columns.Add("单位地址", typeof(string));
                                }
                                row["单位地址"] = addr;
                            }
                            if (split[0] == "ORG;CHARSET=UTF-8;ENCODING=QUOTED-PRINTABLE")
                            {
                                string addr;
                                addr = split[1].Trim(';');
                                addr = ConvertHexToString(addr, Encoding.UTF8);

                                if (!myTable.Columns.Contains("公司"))
                                {
                                    myTable.Columns.Add("公司", typeof(string));
                                }
                                row["公司"] = addr;
                            }

                            if ((split[0] == "END")) // || (split[0] == "END:VCARD"))
                            {
                                line         = 0;
                                IndexTel     = 0;
                                IndexTelWork = 0;

                                myTable.Rows.Add(row);
                                myTable.AcceptChanges();
                            }
                        }

                        longstring = null;
                    }

                    sr.Close();

                    toolStripSearch.Enabled = true;
                }
                #endregion
                #region "打开Excel文件"
                else if (openFileDialog1.FilterIndex == 2)
                {
                    ExportExceltoolStripButton.Enabled = false;
                    ExportVCFtoolStripButton.Enabled   = true;

                    Excel.Application excel = new Excel.Application();
                    Excel.Workbook    book  = excel.Application.Workbooks.Add(filename);

                    foreach (Excel._Worksheet sheet in book.Sheets)
                    {
                        if (sheet.Name == "通讯录")
                        {
                            DataRow row;
                            //row = myTable.NewRow();

                            FormReading fr = new FormReading();
                            fr.Label1.Text = @"正在读取Excel文件";
                            fr.Owner       = this;
                            Point point = this.Location;
                            fr.StartPosition = FormStartPosition.Manual;
                            fr.Size          = new Size(300, 100);
                            fr.Location      = new Point(point.X + (this.Size.Width - fr.Size.Width) / 2, point.Y + (this.Size.Height - fr.Size.Height) / 2);
                            fr.Show();

                            int ColIndex = 1;
                            int ColNum   = 1; // 列数
                            int r        = 2;

                            while (sheet.Cells[1, ColIndex].value != null)
                            {
                                if (!myTable.Columns.Contains(sheet.Cells[1, ColIndex].value))
                                {
                                    myTable.Columns.Add(sheet.Cells[1, ColIndex].value, typeof(string));
                                }

                                ColIndex++;
                            }

                            ColNum = ColIndex - 1;

                            while (sheet.Cells[r, 1].value != null)
                            {
                                row = myTable.NewRow();

                                for (ColIndex = 1; ColIndex <= ColNum; ColIndex++)
                                {
                                    row[sheet.Cells[1, ColIndex].value] = sheet.Cells[r, ColIndex].value;
                                }

                                myTable.Rows.Add(row);
                                r++;
                            }

                            StatusLabel1.Image = VcfEdit.Properties.Resources.export_vcard;
                            fr.Close();
                        }
                    }
                }
                #endregion

                StatusLabel1.Text = myTable.Rows.Count + "个联系人。";
                dataSet.Tables.Add(myTable);

                // Use the Select method to find all rows matching the filter.
                foundRows = myTable.Select();

                //foreach (DataRow row in foundRows)
                //    dt.ImportRow(row);

                int i = 0;
                for (i = 0; i < myTable.Columns.Count; i++)
                {
                    dgvColumn = new DataGridViewTextBoxColumn();
                    dgvColumn.DataPropertyName = myTable.Columns[i].ColumnName;
                    dgvColumn.HeaderText       = myTable.Columns[i].ColumnName;
                    dgvColumn.Name             = myTable.Columns[i].ColumnName;
                    dataGridView1.Columns.Add(dgvColumn);
                }
                dataGridView1.DataSource = myTable;
                dataGridView1.Update();
                dataGridView1.AllowUserToAddRows = false;

                toolStripSearch.Enabled = true;
                myTable.ColumnChanged  += new DataColumnChangeEventHandler(OnColumnChanged);
            }
        }