Zbiór zmian 620 dla branches

Data:

2009-04-28 15:41:04 (17 years ago)

Autor:

marek

Opis:

re #161 - dodano funkcje do exportu w formacie CSV

Lokalizacja:

branches/ReklamaReorganizacja/BazaReklam

Pliki:

• Classes/Helpers/ExcelHelper.cs (zmodyfikowane) (3 diffs)
• ClientsForm.cs (zmodyfikowane) (2 diffs)

branches/ReklamaReorganizacja/BazaReklam/Classes/Helpers/ExcelHelper.cs

@@ +1 @@
+using System;
+using System.Data;
+using System.IO;
+using System.Text;
 using System.Windows.Forms;
 
@@ -5 +9 @@
     public class ExcelHelper
     {
+        //TODO: replace ExcelHelper Export method with ExportToCsv (see below). This will remove unneccesary depedencies..
         public void Export(DataGridView source)
         {
@@ -36 +41 @@
                 }
             }
-            //  excel.Save("New.xls");
             excel.Visible = true;
+        }
+        
+        public void ExportToCsv(DataGridView gridView, string strFilePath)
+        {
+            StreamWriter sw = new StreamWriter(strFilePath, false, Encoding.Default);
+            
+            //write all the columns
+            StringBuilder columns = new StringBuilder();
+            for (int i = 0; i < gridView.Columns.Count; i++)
+            {
+                columns.Append(string.Format("\"{0}\",", gridView.Columns[i].HeaderText));
+            }
+
+            sw.WriteLine(columns.ToString().Remove(columns.ToString().Length-1));
+
+            // Now write all the rows.
+            StringBuilder rowBuilder;
+            foreach (DataGridViewRow row in gridView.Rows)
+            {
+                rowBuilder = new StringBuilder();
+                foreach (DataGridViewColumn column in gridView.Columns)
+                    rowBuilder.Append(string.Format("\"{0}\",", row.Cells[column.Name].Value));
+
+                sw.WriteLine(rowBuilder.ToString().Remove(rowBuilder.ToString().Length - 1));
+            }
+            sw.Flush();
+            sw.Close();
+            sw.Dispose();
+        }
+
+        public void ExportToCsv(DataTable dt, string strFilePath)
+        {
+            // Create the CSV file to which grid data will be exported.
+            StreamWriter sw = new StreamWriter(strFilePath, false, Encoding.UTF8);
+
+            // First we will write the headers.
+            int iColCount = dt.Columns.Count;
+            for (int i = 0; i < iColCount; i++)
+            {
+                sw.Write(string.Format("\"{0}\"", dt.Columns[i]));
+
+                if (i < iColCount - 1) //write comma after every column, not after the last one
+                    sw.Write(",");
+            }
+
+            sw.Write(sw.NewLine);
+
+            // Now write all the rows.
+            foreach (DataRow dr in dt.Rows)
+            {
+                for (int i = 0; i < iColCount; i++)
+                {
+                    if (!Convert.IsDBNull(dr[i]))
+                        sw.Write(string.Format("\"{0}\"", dr[i]));
+
+                    if (i < iColCount - 1) //write comma after every column, not after the last one
+                        sw.Write(",");
+                }
+
+                sw.Write(sw.NewLine);
+            }
+            sw.Flush();
+            sw.Close();
+            sw.Dispose();
         }
     }

branches/ReklamaReorganizacja/BazaReklam/ClientsForm.cs

@@ -3 +3 @@
 using System.Data;
 using System.Data.SqlClient;
+using System.Diagnostics;
 using System.Drawing;
 using System.Windows.Forms;
@@ -2203 +2204 @@
         }
 
+        //TODO: replace ExcelHelper Export method with ExportToCsv to remove unneccesary depedencies..
         private void excelToolStripButton_Click(object sender, EventArgs e)
         {
             Cursor = Cursors.WaitCursor;
 
-            ExcelHelper ex = new ExcelHelper();
-            ex.Export(clientsDataGridView);
-
+            ExcelHelper excelHelper = new ExcelHelper();
+            excelHelper.Export(clientsDataGridView);
+            
             Cursor = Cursors.Default;
         }
-
-        //private void dodajTytulButton_Click(object sender, EventArgs e)
-        //{
-        //    if (kLIENCIBindingSource.Current == null) return;
-
-        //    if (tytulyListBox.SelectedValue == null)
-        //    {
-        //        MessageBox.Show("Wybierz tytu³.");
-        //        return;
-        //    }
-
-        //    DataRowView row = (DataRowView)kLIENCIBindingSource.Current;
-        //    int custId = Int32.Parse(row["CustomerId"].ToString());
-
-        //    kLIENCI_TYTULTableAdapter.Insert(tytulyListBox.SelectedValue.ToString(), custId, User.Instance().Login, DateTime.Now);
-        //    kLIENCI_TYTULTableAdapter.FillByCustomerId(rEKLAMADataSet.KLIENCI_TYTUL, custId);
-
-        //}
-
-        //private void usunTytulButton_Click(object sender, EventArgs e)
-        //{
-        //    if (kLIENCITYTULBindingSource.Current != null)
-        //    {
-        //        if (kLIENCITYTULBindingSource.Current != null)
-        //        {
-        //            kLIENCITYTULBindingSource.RemoveCurrent();
-        //            kLIENCI_TYTULTableAdapter.Update(rEKLAMADataSet.KLIENCI_TYTUL);
-        //        }
-        //    }
-        //}
 
         private void agencjaToolStripComboBox_SelectedIndexChanged(object sender, EventArgs e)