using System;
using System.Collections.Generic;
using System.Text;

namespace HH.WMS.Utils.ExcelLibrary.SpreadSheet
{
    public class CellFormat
    {
        private CellFormatType formatType;
        private string formatString;

        public CellFormat(CellFormatType type, string fmt)
        {
            formatType = type;
            formatString = fmt;
        }

        public CellFormatType FormatType
        {
            get { return formatType; }
        }

        public string FormatString
        {
            get { return formatString; }
            set { formatString = value; }
        }

        /// <summary>
        /// Default Format.
        /// </summary>
        public static readonly CellFormat General = new CellFormat(CellFormatType.General, "General");
        
        /// <summary>
        /// Format the DateTime with: "YYYY-MM-DD" e.g: 2009-02-18
        /// </summary>
        public static readonly CellFormat Date = new CellFormat(CellFormatType.Date, @"YYYY\-MM\-DD");
        
        /// <summary>
        /// Format the DateTime with: "HH:mm:ss" e.g: 14:45:00
        /// </summary>
        /// <example>Format the DateTime with: "HH:mm:ss" e.g: 14:45:00</example>
        public static readonly CellFormat Time = new CellFormat(CellFormatType.Time, "HH:mm:ss");
        
        /// <summary>
        /// Format the number with: "#,###.00000" e.g: 100.12345
        /// </summary>
        /// <example>Format the number with: "#,###.00000" e.g: 100.12345</example>
        public static readonly CellFormat Engineer = new CellFormat(CellFormatType.Scientific, "#,###.00000");
    }
}