using NPOI.POIFS.FileSystem;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using NPOI.XWPF.UserModel;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.IO;
using System.Text;

namespace eyuan
{
  public static class NOPIHandler
  {
    /// <summary>
    /// 
    /// </summary>
    /// <param name="fileName"></param>
    /// <returns></returns>
    public static List<List<List<string>>> ReadExcel(string fileName)
    {
      //打開Excel工作簿
      XSSFWorkbook hssfworkbook = null;
      try
      {
        using (FileStream file = new FileStream(fileName, FileMode.Open, FileAccess.Read))
        {
          hssfworkbook = new XSSFWorkbook(file);
        }
      }
      catch (Exception e)
      {
        LogHandler.LogWrite(string.Format("文件{0}打開失敗，錯誤：{1}", new string[] { fileName, e.ToString() }));
      }
      //循環(huán)Sheet頁
      int sheetsCount = hssfworkbook.NumberOfSheets;
      List<List<List<string>>> workBookContent = new List<List<List<string>>>();
      for (int i = 0; i < sheetsCount; i++)
      {
        //Sheet索引從0開始
        ISheet sheet = hssfworkbook.GetSheetAt(i);
        //循環(huán)行
        List<List<string>> sheetContent = new List<List<string>>();
        int rowCount = sheet.PhysicalNumberOfRows;
        for (int j = 0; j < rowCount; j++)
        {
          //Row（邏輯行）的索引從0開始
          IRow row = sheet.GetRow(j);
          //循環(huán)列（各行的列數(shù)可能不同）
          List<string> rowContent = new List<string>();
          int cellCount = row.PhysicalNumberOfCells;
          for (int k = 0; k < cellCount; k++)
          {
            //ICell cell = row.GetCell(k);
            ICell cell = row.Cells[k];
            if (cell == null)
            {
              rowContent.Add("NIL");
            }
            else
            {
              rowContent.Add(cell.ToString());
              //rowContent.Add(cell.StringCellValue);
            }
          }
          //添加行到集合中
          sheetContent.Add(rowContent);
        }
        //添加Sheet到集合中
        workBookContent.Add(sheetContent);
      }

      return workBookContent;
    }

    /// <summary>
    /// 
    /// </summary>
    /// <param name="fileName"></param>
    /// <returns></returns>
    public static string ReadExcelText(string fileName)
    {
      string ExcelCellSeparator = ConfigurationManager.AppSettings["ExcelCellSeparator"];
      string ExcelRowSeparator = ConfigurationManager.AppSettings["ExcelRowSeparator"];
      string ExcelSheetSeparator = ConfigurationManager.AppSettings["ExcelSheetSeparator"];
      //
      List<List<List<string>>> excelContent = ReadExcel(fileName);
      string fileText = string.Empty;
      StringBuilder sbFileText = new StringBuilder();
      //循環(huán)處理WorkBook中的各Sheet頁
      List<List<List<string>>>.Enumerator enumeratorWorkBook = excelContent.GetEnumerator();
      while (enumeratorWorkBook.MoveNext())
      {

        //循環(huán)處理當期Sheet頁中的各行
        List<List<string>>.Enumerator enumeratorSheet = enumeratorWorkBook.Current.GetEnumerator();
        while (enumeratorSheet.MoveNext())
        {

          string[] rowContent = enumeratorSheet.Current.ToArray();
          sbFileText.Append(string.Join(ExcelCellSeparator, rowContent));
          sbFileText.Append(ExcelRowSeparator);
        }
        sbFileText.Append(ExcelSheetSeparator);
      }
      //
      fileText = sbFileText.ToString();
      return fileText;
    }

    /// <summary>
    /// 讀取Word內容
    /// </summary>
    /// <param name="fileName"></param>
    /// <returns></returns>
    public static string ReadWordText(string fileName)
    {
      string WordTableCellSeparator = ConfigurationManager.AppSettings["WordTableCellSeparator"];
      string WordTableRowSeparator = ConfigurationManager.AppSettings["WordTableRowSeparator"];
      string WordTableSeparator = ConfigurationManager.AppSettings["WordTableSeparator"];
      //
      string CaptureWordHeader = ConfigurationManager.AppSettings["CaptureWordHeader"];
      string CaptureWordFooter = ConfigurationManager.AppSettings["CaptureWordFooter"];
      string CaptureWordTable = ConfigurationManager.AppSettings["CaptureWordTable"];
      string CaptureWordImage = ConfigurationManager.AppSettings["CaptureWordImage"];
      //
      string CaptureWordImageFileName = ConfigurationManager.AppSettings["CaptureWordImageFileName"];
      //
      string fileText = string.Empty;
      StringBuilder sbFileText = new StringBuilder();

      #region 打開文檔
      XWPFDocument document = null;
      try
      {
        using (FileStream file = new FileStream(fileName, FileMode.Open, FileAccess.Read))
        {
          document = new XWPFDocument(file);
        }
      }
      catch (Exception e)
      {
        LogHandler.LogWrite(string.Format("文件{0}打開失敗，錯誤：{1}", new string[] { fileName, e.ToString() }));
      }
      #endregion

      #region 頁眉、頁腳
      //頁眉
      if (CaptureWordHeader == "true")
      {
        sbFileText.AppendLine("Capture Header Begin");
        foreach (XWPFHeader xwpfHeader in document.HeaderList)
        {
          sbFileText.AppendLine(string.Format("{0}", new string[] { xwpfHeader.Text }));
        }
        sbFileText.AppendLine("Capture Header End");
      }
      //頁腳
      if (CaptureWordFooter == "true")
      {
        sbFileText.AppendLine("Capture Footer Begin");
        foreach (XWPFFooter xwpfFooter in document.FooterList)
        {
          sbFileText.AppendLine(string.Format("{0}", new string[] { xwpfFooter.Text }));
        }
        sbFileText.AppendLine("Capture Footer End");
      }
      #endregion

      #region 表格
      if (CaptureWordTable == "true")
      {
        sbFileText.AppendLine("Capture Table Begin");
        foreach (XWPFTable table in document.Tables)
        {
          //循環(huán)表格行
          foreach (XWPFTableRow row in table.Rows)
          {
            foreach (XWPFTableCell cell in row.GetTableCells())
            {
              sbFileText.Append(cell.GetText());
              //
              sbFileText.Append(WordTableCellSeparator);
            }

            sbFileText.Append(WordTableRowSeparator);
          }
          sbFileText.Append(WordTableSeparator);
        }
        sbFileText.AppendLine("Capture Table End");
      }
      #endregion

      #region 圖片
      if (CaptureWordImage == "true")
      {
        sbFileText.AppendLine("Capture Image Begin");
        foreach (XWPFPictureData pictureData in document.AllPictures)
        {
          string picExtName = pictureData.suggestFileExtension();
          string picFileName = pictureData.GetFileName();
          byte[] picFileContent = pictureData.GetData();
          //
          string picTempName = string.Format(CaptureWordImageFileName, new string[] { Guid.NewGuid().ToString() + "_" + picFileName + "." + picExtName });
          //
          using (FileStream fs = new FileStream(picTempName, FileMode.Create, FileAccess.Write))
          {
            fs.Write(picFileContent, 0, picFileContent.Length);
            fs.Close();
          }
          //
          sbFileText.AppendLine(picTempName);
        }
        sbFileText.AppendLine("Capture Image End");
      }
      #endregion

      //正文段落
      sbFileText.AppendLine("Capture Paragraph Begin");
      foreach (XWPFParagraph paragraph in document.Paragraphs)
      {
        sbFileText.AppendLine(paragraph.ParagraphText);

      }
      sbFileText.AppendLine("Capture Paragraph End");
      //

      //
      fileText = sbFileText.ToString();
      return fileText;
    }


  }
}