using iWareCommon.Common.Entity;
using iWareCommon.Utils;
using iWareExcel.ORM;
using System;
using System.Collections.Generic;
namespace iWareExcel.EXCEL.Entity
{
    public class WorkCellEntity : ICommonEntity<EXCELWorkCell>
    {
        /// <summary>
        /// 主键
        /// </summary>
        public int Id { get; set; }

        /// <summary>
        /// Excel展示名
        /// </summary>
        public string DisplayName { get; set; }

        /// <summary>
        /// 属性名
        /// </summary>
        public string PropName { get; set; }

        /// <summary>
        /// 工作页Id
        /// </summary>
        public int WorkSheetId { get; set; }

        /// <summary>
        /// 工作页名称
        /// </summary>
        public string WorkSheetName { get; set; }

        /// <summary>
        /// 工作簿Id
        /// </summary>
        public int WorkBookId { get; set; }

        /// <summary>
        /// 工作簿名称
        /// </summary>
        public string WorkBookName { get; set; }

        /// <summary>
        /// 数据类型
        /// </summary>
        public int DataType { get; set; }

        /// <summary>
        /// 是否枚举
        /// </summary>
        public int IsEnum { get; set; }

        /// <summary>
        /// 枚举类名
        /// </summary>
        public string EnumClass { get; set; }

        /// <summary>
        /// 排序
        /// </summary>
        public int CellIndex { get; set; }
       

        /// <summary>
        /// 构造函数
        /// </summary>
        public WorkCellEntity(){}


       /// <summary>
       /// 构造函数
       /// </summary>
       /// <param name="workCell">工作单元</param>
        public WorkCellEntity(EXCELWorkCell workCell) 
        {
            EntityPropHelper<WorkCellEntity, EXCELWorkCell>.CopyProp(workCell, this, GetColumnMap());
        }

        /// <summary>
        /// 将实体类转成ORM类
        /// </summary>
        /// <returns></returns>
        public EXCELWorkCell ToOrm()
        {
            var workCell = new EXCELWorkCell();
            EntityPropHelper<WorkCellEntity, EXCELWorkCell>.CopyProp(this, workCell, GetColumnMap());
            return workCell;
        }

        /// <summary>
        /// 获取自定义工位类中的字段名为键，orm中对象的字段名为值的字段
        /// </summary>
        /// <returns></returns>
        public static Dictionary<String, String> GetColumnMap()
        {
            return new Dictionary<string, string>() 
            { 
                {"Id", "id"},
                {"DisplayName", "displayname"},
                {"PropName","propname"},
                {"WorkSheetId","worksheetid"},
                {"WorkSheetName","worksheetname"},
                {"WorkBookId","workbookid"},
                {"WorkBookName","workbookname"},
                {"DataType","datatype"},
                {"IsEnum","isenum"},
                {"EnumClass","enumclass"},
                {"CellIndex", "cellindex"}
            };
        }


        /// <summary>
        /// 根据Entity的字段转ORM的字段
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public static String GetColumnName(String name)
        {
            var columnMap = GetColumnMap();
            return columnMap.ContainsKey(name) ? columnMap[name] : name;
        }


        public static string GetTableName()
        {
            return "[dbo].[EXCELWorkCell]";
        }



        
    }
}