using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using HotelPms.Share.Util;
using System;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;

namespace HotelPms.Share.Windows.Report
{
    public class GridCsv : ReportBase, IDisposable, IReport
    {
        #region  ★★★★★　Declartions　★★★★★

        private bool m_Disposed = false;

        #endregion

        #region  ★★★★★　Property　★★★★★

        #endregion

        #region  ★★★★★　Class Event　★★★★★

        public GridCsv(DataTable data, GridStyle style)
        {
            m_Data = data;
            m_Style = style;
        }

        ~GridCsv()
        {
            Dispose(false);
        }

        protected virtual void Dispose(bool disposing)
        {
            if (!m_Disposed)   //一回だけ
            {
                if (disposing)
                {
                    //Managed Resources
                }

                //Unmanaged resources
                m_Disposed = true;
            }
        }

        public void Dispose()
        {
            Dispose(true);
            GC.SuppressFinalize(this);
        }

        #endregion

        #region  ★★★★★　Control Event　★★★★★
        #endregion

        #region  ★★★★★　Private Function　★★★★★
        #endregion

        #region  ★★★★★　Public  Function　★★★★★

        public void Output()
        {
            string path = System.IO.Path.GetTempFileName().Replace(".tmp", ".csv");
            Output(path);
            Process.Start(path);
        }

        public void Output(string file)
        {
            try
            {
                using (StreamWriter sw = new StreamWriter(file, false, Encoding.UTF8))
                {
                    StringBuilder colNames = new StringBuilder();
                    int col = 0;
                    foreach (ColumnStyle cs in m_Style.ColumnStyle)
                    {
                        if (col > 0) { colNames.Append(","); }
                        colNames.Append("\"");
                        colNames.Append(cs.Text);
                        colNames.Append("\"");
                        col++;
                    }
                    sw.WriteLine(colNames.ToString());

                    //データ
                    for (int i = 0; i < m_Data.Rows.Count; i++)
                    {
                        StringBuilder row = new StringBuilder();
                        col = 0;
                        foreach (ColumnStyle cs in m_Style.ColumnStyle)
                        {
                            string text = m_Data.Rows[i][cs.DataField].ToString();
                            if (col > 0) { row.Append(","); }
                            row.Append("\"");
                            row.Append(text);
                            row.Append("\"");
                            col++;
                        }
                        sw.WriteLine(row.ToString());
                    }

                    sw.Close();
                }
            }
            catch
            {
            }
        }


        #endregion

    }
}