///-----------------------------------------------------------------------
/// <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;
    }
}