Esempio n. 1
0
        private void OnExportData()
        {
            List <DataTable> dts        = new List <DataTable>();
            List <string>    sheetNames = new List <string>();

            if (this.dataGridView2.DataSource != null)
            {
                DataTable dt = this.dataGridView2.DataSource as DataTable;
                dt.TableName = "电芯数据";
                dts.Add(dt);
                sheetNames.Add(dt.TableName);
            }
            SaveFileDialog dlg = new SaveFileDialog();

            dlg.Filter = "excel files (*.xlsx)|*.xlsx";
            if (dlg.ShowDialog() == DialogResult.OK)
            {
                try
                {
                    string fileName = dlg.FileName;

                    DelegateExportLog dlgtExportLog = new DelegateExportLog(AsyExportLog);
                    dlgtExportLog.BeginInvoke(dts.ToArray(), fileName, sheetNames.ToArray(), CallbackExportlogOK, dlgtExportLog);
                    waitDlg = new LogManage.WaitDlg();
                    waitDlg.ShowDialog();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
Esempio n. 2
0
        private void OnExportLog(DataTable dt)
        {
            SaveFileDialog dlg = new SaveFileDialog();

            dlg.Filter = "excel files (*.xlsx)|*.xlsx";
            if (dlg.ShowDialog() == DialogResult.OK)
            {
                try
                {
                    string            fileName      = dlg.FileName;
                    string            sheetName     = "Log";
                    DelegateExportLog dlgtExportLog = new DelegateExportLog(AsyExportLog);
                    dlgtExportLog.BeginInvoke(dt, fileName, sheetName, CallbackExportlogOK, dlgtExportLog);
                    waitDlg = new WaitDlg();
                    waitDlg.ShowDialog();
                    //CreateExcelFile(fileName, sheetName);
                    ////string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                    ////"Data Source=" + fileName + ";" +
                    ////"Extended Properties='Excel 8.0; HDR=Yes; IMEX=2'";
                    //string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" +
                    //"Data Source=" + fileName + ";" +
                    //"Extended Properties='Excel 12.0; HDR=Yes; IMEX=0'";
                    //using (OleDbConnection ole_conn = new OleDbConnection(strConn))
                    //{
                    //    ole_conn.Open();
                    //    using (OleDbCommand ole_cmd = ole_conn.CreateCommand())
                    //    {
                    //        foreach (DataRow dr in dt.Rows)
                    //        {
                    //            string logContent = dr["内容"].ToString();
                    //            logContent = logContent.Substring(0, Math.Min(255, logContent.Count()));
                    //            ole_cmd.CommandText = string.Format(@"insert into [{0}$](日志ID,内容,类别,日志来源,时间)values('{1}','{2}','{3}','{4}','{5}')", sheetName, dr["日志ID"].ToString(), logContent, dr["类别"].ToString(), dr["日志来源"].ToString(), dr["时间"].ToString());
                    //            ole_cmd.ExecuteNonQuery();
                    //        }

                    //        MessageBox.Show("数据导出成功......");
                    //    }
                    //}
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            }
        }