You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
82 lines
2.8 KiB
82 lines
2.8 KiB
///-----------------------------------------------------------------------
|
|
/// <copyright file="ExcelExtansion.cs" company="ChipMOS">
|
|
/// 程式代號: ExcelExtansion
|
|
/// 程式名稱: ExcelExtansion
|
|
/// 程式說明:
|
|
/// 起始作者: Rexxar.eng
|
|
/// 起始日期: 2017/03/13 16:55:08
|
|
/// 最新修改人: Hercules
|
|
/// 最新修日期: 2017/05/18 17:45:54
|
|
/// </copyright>
|
|
///-----------------------------------------------------------------------
|
|
#region 程式異動記錄
|
|
/// xx.YYYY/MM/DD VER AUTHOR COMMENTS(說明修改的內容)
|
|
/// 01.2017/03/13 1.000 Rexxar.eng Excel tools(RV.3120)
|
|
/// 02.2017/03/13 1.001 Rexxar.eng Excel tools(RV.3121)
|
|
/// 03.2017/03/13 1.002 Rexxar.eng Excel tools(RV.3126)
|
|
/// 04.2017/03/14 1.003 Hercules 調整Excel Export(RV.3129)
|
|
/// 05.2017/05/18 1.004 Hercules 補程式Header註解(RV.4375)
|
|
#endregion
|
|
|
|
using OT.COM.ArsenalDB;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Globalization;
|
|
|
|
namespace CounsellorBL.BLStructure
|
|
{
|
|
|
|
/// <summary>
|
|
/// 類別名稱:Parameter
|
|
/// 類別說明:
|
|
/// 起始作者:
|
|
/// 起始日期:
|
|
/// 最新修改人:
|
|
/// 最新修改日:
|
|
/// </summary>
|
|
public class ExcelHelperParameter
|
|
{
|
|
public delegate object DE_Translate(Dictionary<string, object> i_dicRawData);
|
|
|
|
public Dictionary<string, DE_Translate> TraslateMap { get; private set; } = new Dictionary<string, DE_Translate>();
|
|
/// <summary>
|
|
/// 函式名稱:MakeFileName
|
|
/// 函式說明:
|
|
/// 起始作者:
|
|
/// 起始日期:
|
|
/// 最新修改人:
|
|
/// 最新修改日:
|
|
/// </summary>
|
|
/// <param name="i_sPrefix">
|
|
/// 參數說明
|
|
/// </param>
|
|
/// <returns>
|
|
/// 回傳
|
|
/// </returns>
|
|
/// <summary>
|
|
public static string MakeFileName(string i_sPrefix)
|
|
{
|
|
return (i_sPrefix ?? "") + DateTime.Now.ToString("yyyyMMddHHmmss", CultureInfo.CurrentCulture) + ".xls";
|
|
}
|
|
/// <summary>
|
|
/// 類別成員、類別屬性說明:QueryData
|
|
/// </summary>
|
|
public QueryDataSet QueryData { get; set; }
|
|
/// <summary>
|
|
/// 類別成員、類別屬性說明:FileName
|
|
/// </summary>
|
|
public string FileName { get; set; }
|
|
/// <summary>
|
|
/// 類別成員、類別屬性說明:Path
|
|
/// </summary>
|
|
public string Path { get; set; }
|
|
/// <summary>
|
|
/// 類別成員、類別屬性說明:HeaderMappingData
|
|
/// </summary>
|
|
public List<Dictionary<string, object>> HeaderMappingData { get; private set; }
|
|
/// <summary>
|
|
/// 類別成員、類別屬性說明:SheetName
|
|
/// </summary>
|
|
public string SheetName { get; set; } = null;
|
|
}
|
|
}
|