using Aspose.Cells;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
using System.IO;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public class WebTool
{
  public void BindTree(DataTable dataSource, TreeNodeCollection nodes, string parentId, string idColumn, string parentIdColumn, string textColumn, string values)
  {
    nodes.Clear();
    this.BindTreeNode(dataSource, nodes, parentId, idColumn, parentIdColumn, textColumn, values);
  }

  public void BindTreeNode(DataTable dataSource, TreeNodeCollection nodes, string parentId, string idColumn, string parentIdColumn, string textColumn, string values)
  {
    foreach (DataRowView dataRowView in new DataView(dataSource)
    {
      RowFilter = string.IsNullOrEmpty(parentId) ? parentIdColumn + " is null" : string.Format(parentIdColumn + "='{0}'", (object) parentId)
    })
    {
      TreeNode treeNode = new TreeNode();
      treeNode.Value = dataRowView[idColumn].ToString();
      treeNode.Text = dataRowView[textColumn].ToString();
      treeNode.Checked = (Enumerable.Any<string>((IEnumerable<string>) values.Split(new char[1]
      {
        ','
      }, StringSplitOptions.RemoveEmptyEntries), (Func<string, bool>) (c => c == treeNode.Value)) ? 1 : 0) != 0;
      treeNode.ShowCheckBox = new bool?(true);
      nodes.Add(treeNode);
      this.BindTree(dataSource, treeNode.ChildNodes, treeNode.Value, idColumn, parentIdColumn, textColumn, values);
    }
  }

  public void Export(DataTable dataTable, Dictionary<string, string> dictionary, string fileName, HttpResponse Response)
  {
    StringBuilder stringBuilder = new StringBuilder();
    //stringBuilder.Append("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\"/>");//旧的-导出xls
    stringBuilder.Append("<meta http-equiv=\"content-type\" content=\"vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=UTF-8\"/>");//导出格式xlsx
    stringBuilder.AppendLine("<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");
    stringBuilder.AppendLine("<tr>");
    foreach (KeyValuePair<string, string> keyValuePair in dictionary)
    {
      stringBuilder.AppendLine("<th>");
      stringBuilder.Append(keyValuePair.Key);
      stringBuilder.Append("</th>");
    }
    stringBuilder.Append("</tr>");
    if (dataTable.Rows.Count == 0)
    {
      stringBuilder.Append("<tr>");
      stringBuilder.AppendLine("<td  colspan=\"" + (object) dictionary.Count + "\">");
      stringBuilder.Append("暂无数据");
      stringBuilder.Append("</td>");
      stringBuilder.Append("</tr>");
    }
    foreach (DataRow dataRow in (InternalDataCollectionBase) dataTable.Rows)
    {
      stringBuilder.Append("<tr>");
      foreach (KeyValuePair<string, string> keyValuePair in dictionary)
      {
        string str = dataRow[keyValuePair.Value].ToString();
        stringBuilder.AppendLine("<td>");
        stringBuilder.Append(str);
        stringBuilder.Append("</td>");
      }
      stringBuilder.Append("</tr>");
    }
    stringBuilder.AppendLine("</table>");
    Response.ClearContent();
    Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".xlsx");
    Response.ContentType = "application/excel";
    Response.ContentEncoding = Encoding.UTF8;
    Response.Write(stringBuilder.ToString());
    Response.End();
  }

  public void Export(DataTable dataTable, List<string> columnName, List<string> columnChinaName, List<int> columnWidth, string reportTitleName, string reportFileName, HttpResponse Response)
  {
    Workbook workbook = new Workbook();
    Worksheet worksheet = workbook.Worksheets[0];
    Cells cells = worksheet.Cells;
    string[,] strArray = new string[dataTable.Rows.Count, columnName.Count];
    for (int index1 = 0; index1 < dataTable.Rows.Count; ++index1)
    {
      for (int index2 = 0; index2 < columnName.Count; ++index2)
        strArray[index1, index2] = dataTable.Rows[index1][columnName[index2].ToString() ?? ""].ToString();
    }
    Aspose.Cells.Style style1 = workbook.Styles[workbook.Styles.Add()];
    style1.HorizontalAlignment = TextAlignmentType.Center;
    style1.Font.Name = "宋体";
    style1.Font.IsBold = true;
    style1.Font.Size = 18;
    cells["A1"].SetStyle(style1);
    cells["A1"].PutValue(reportTitleName);
    cells.SetRowHeight(0, 20.0);
    cells.CreateRange(0, 0, 1, columnName.Count).Merge();
    Aspose.Cells.Style style2 = workbook.Styles[workbook.Styles.Add()];
    style2.HorizontalAlignment = TextAlignmentType.Center;
    style2.Font.Name = "宋体";
    style2.Font.Size = 15;
    for (int columnIndex = 0; columnIndex < columnChinaName.Count; ++columnIndex)
    {
      cells[1, columnIndex].PutValue(columnChinaName[columnIndex].ToString());
      cells[1, columnIndex].SetStyle(style2);
      worksheet.AutoFitColumn(columnIndex);
    }
    Aspose.Cells.Style style3 = workbook.Styles[workbook.Styles.Add()];
    style3.HorizontalAlignment = TextAlignmentType.Left;
    style3.Font.Name = "宋体";
    style3.Font.Size = 12;
    for (int index1 = 0; index1 < strArray.Length / columnName.Count; ++index1)
    {
      for (int index2 = 0; index2 < columnName.Count; ++index2)
      {
        cells[index1 + 2, index2].PutValue(strArray[index1, index2].ToString());
        cells[index1 + 2, index2].SetStyle(style3);
      }
    }
    for (int column = 0; column < columnName.Count; ++column)
    {
      if (columnWidth == null)
        cells.SetColumnWidth(column, 10.0);
      else
        cells.SetColumnWidth(column, Convert.ToDouble(columnWidth[column].ToString()));
    }
    Response.ContentType = "application/ms-excel;charset=utf-8";
    Response.AddHeader("content-disposition", "attachment; filename=" + string.Format("{0}.xls", (object) reportFileName));
    MemoryStream memoryStream = workbook.SaveToStream();
    Response.BinaryWrite(memoryStream.ToArray());
    Response.End();
  }

  public void Export(DataTable dataTable, List<string> columnName, List<string> columnChinaName, List<int> columnWidth, string reportFileName, HttpResponse Response)
  {
    Workbook workbook = new Workbook();
    Worksheet worksheet = workbook.Worksheets[0];
    Cells cells = worksheet.Cells;
    string[,] strArray = new string[dataTable.Rows.Count, columnName.Count];
    for (int index1 = 0; index1 < dataTable.Rows.Count; ++index1)
    {
      for (int index2 = 0; index2 < columnName.Count; ++index2)
        strArray[index1, index2] = dataTable.Rows[index1][columnName[index2].ToString() ?? ""].ToString();
    }
    Aspose.Cells.Style style1 = workbook.Styles[workbook.Styles.Add()];
    style1.HorizontalAlignment = TextAlignmentType.Center;
    style1.Font.Name = "宋体";
    style1.Font.Size = 13;
    for (int columnIndex = 0; columnIndex < columnChinaName.Count; ++columnIndex)
    {
      cells[0, columnIndex].PutValue(columnChinaName[columnIndex].ToString());
      cells[0, columnIndex].SetStyle(style1);
      worksheet.AutoFitColumn(columnIndex);
    }
    Aspose.Cells.Style style2 = workbook.Styles[workbook.Styles.Add()];
    style2.HorizontalAlignment = TextAlignmentType.Left;
    style2.Font.Name = "宋体";
    style2.Font.Size = 12;
    for (int index1 = 0; index1 < strArray.Length / columnName.Count; ++index1)
    {
      for (int index2 = 0; index2 < columnName.Count; ++index2)
      {
        cells[index1 + 1, index2].PutValue(strArray[index1, index2].ToString());
        cells[index1 + 1, index2].SetStyle(style2);
      }
    }
    for (int column = 0; column < columnName.Count; ++column)
    {
      if (columnWidth == null)
        cells.SetColumnWidth(column, 10.0);
      else
        cells.SetColumnWidth(column, Convert.ToDouble(columnWidth[column].ToString()));
    }
    Response.ContentType = "application/ms-excel;charset=utf-8";
    Response.AddHeader("content-disposition", "attachment; filename=" + string.Format("{0}.xls", (object) reportFileName));
    MemoryStream memoryStream = workbook.SaveToStream();
    Response.BinaryWrite(memoryStream.ToArray());
    Response.End();
  }

  public void Export(DataSet dataSet, List<string> sheetName, List<string> columnName, List<string> columnChinaName, List<int> columnWidth, string reportFileName, HttpResponse Response)
  {
    Workbook workbook = new Workbook();
    workbook.Worksheets.RemoveAt(0);
    Aspose.Cells.Style style1 = workbook.Styles[workbook.Styles.Add()];
    style1.HorizontalAlignment = TextAlignmentType.Center;
    style1.Font.Name = "宋体";
    style1.Font.Size = 13;
    Aspose.Cells.Style style2 = workbook.Styles[workbook.Styles.Add()];
    style2.HorizontalAlignment = TextAlignmentType.Left;
    style2.Font.Name = "宋体";
    style2.Font.Size = 12;
    for (int index1 = 0; index1 < dataSet.Tables.Count; ++index1)
    {
      Worksheet worksheet = workbook.Worksheets.Add(sheetName[index1]);
      Cells cells = worksheet.Cells;
      string[,] strArray = new string[dataSet.Tables[index1].Rows.Count, columnName.Count];
      for (int index2 = 0; index2 < dataSet.Tables[index1].Rows.Count; ++index2)
      {
        for (int index3 = 0; index3 < columnName.Count; ++index3)
          strArray[index2, index3] = dataSet.Tables[index1].Rows[index2][columnName[index3].ToString() ?? ""].ToString();
      }
      for (int columnIndex = 0; columnIndex < columnChinaName.Count; ++columnIndex)
      {
        cells[0, columnIndex].PutValue(columnChinaName[columnIndex].ToString());
        cells[0, columnIndex].SetStyle(style1);
        worksheet.AutoFitColumn(columnIndex);
      }
      for (int index2 = 0; index2 < strArray.Length / columnName.Count; ++index2)
      {
        for (int index3 = 0; index3 < columnName.Count; ++index3)
        {
          cells[index2 + 1, index3].PutValue(strArray[index2, index3].ToString());
          cells[index2 + 1, index3].SetStyle(style2);
        }
      }
      for (int column = 0; column < columnName.Count; ++column)
      {
        if (columnWidth == null)
          cells.SetColumnWidth(column, 10.0);
        else
          cells.SetColumnWidth(column, Convert.ToDouble(columnWidth[column].ToString()));
      }
    }
    Response.ContentType = "application/ms-excel;charset=utf-8";
    Response.AddHeader("content-disposition", "attachment; filename=" + string.Format("{0}.xls", (object) reportFileName));
    MemoryStream memoryStream = workbook.SaveToStream();
    Response.BinaryWrite(memoryStream.ToArray());
    Response.End();
  }

  public DataSet ReadExcel(string path)
  {
    string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=Excel 8.0;";
    using (OleDbConnection oleDbConnection = new OleDbConnection(str))
    {
      oleDbConnection.Open();
      DataSet dataSet = new DataSet();
      DataTable schema = oleDbConnection.GetSchema("Tables");
      for (int index = 0; index < schema.Rows.Count; ++index)
      {
        DataTable dataTable = new DataTable();
        new OleDbDataAdapter("select * from [" + schema.Rows[index]["TABLE_NAME"].ToString() + "]", str).Fill(dataTable);
        dataSet.Tables.Add(dataTable);
      }
      return dataSet;
    }
  }

  public void LogAdd(string title, string description, int parameterId)
  {
  }

  public void LogAdd(Page page, Exception e)
  {
  }

  public void DeleteUploadFile(HttpContext context, List<string> files)
  {
    foreach (string fileName in files)
      this.DeleteUploadFile(context, fileName);
  }

  public void DeleteUploadFile(HttpContext context, string fileName)
  {
    if (string.IsNullOrEmpty(fileName) || fileName.ToLower().StartsWith("/file") || fileName.ToLower().StartsWith("file"))
      return;
    fileName = context.Server.MapPath("file/" + fileName);
    if (!File.Exists(fileName))
      return;
    File.Delete(fileName);
  }

  public bool CheckExtensionName(HttpRequest request, string fieldName)
  {
    return this.CheckExtensionName(request, fieldName, new string[5]
    {
      ".gif",
      ".jpg",
      ".jpeg",
      ".png",
      ".bmp"
    });
  }

  public bool CheckExtensionName(HttpRequest request, string fieldName, string[] extensions)
  {
    if (Enumerable.Contains<string>((IEnumerable<string>) request.Files.AllKeys, fieldName))
    {
      HttpPostedFile httpPostedFile = request.Files[fieldName];
      if (httpPostedFile.ContentLength > 0)
      {
        string str1 = Path.GetExtension(httpPostedFile.FileName).ToLower();
        foreach (string str2 in extensions)
        {
          if (str1 == str2)
            return true;
        }
      }
    }
    return false;
  }

  public string SaveUploadFile(HttpContext context, string fieldName)
  {
    HttpRequest request = context.Request;
    if (Enumerable.Contains<string>((IEnumerable<string>) request.Files.AllKeys, fieldName))
    {
      HttpPostedFile httpPostedFile = request.Files[fieldName];
      if (httpPostedFile.ContentLength > 0)
      {
        DateTime now = DateTime.Now;
        string str1 = Path.GetExtension(httpPostedFile.FileName).ToLower();
        string str2 = now.ToString("yyyyMMddHHmmssfff") + str1;
        string path1 = ConfigurationManager.AppSettings["UploadFilePath"];
        string str3 = context.Server.MapPath(path1);
        if ((int) str3[str3.Length - 1] != 92)
          str3 = str3 + str3 + "\\";
        string path2 = str3 + now.ToString("yyyy-MM") + "\\";
        if (!Directory.Exists(path2))
          Directory.CreateDirectory(path2);
        httpPostedFile.SaveAs(path2 + str2);
        return now.ToString("yyyy-MM") + "/" + str2;
      }
    }
    return "";
  }
}