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

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

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

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

        /// <summary>
        /// 工作页对应的实体全类名
        /// </summary>
        public string ClassName { get; set; }

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

        /// <summary>
        /// 工作单元列表
        /// </summary>
        public List<WorkCellEntity> WorkCells { get; set; }

        /// <summary>
        /// 表头写入开始行 从1开始
        /// </summary>
        public int HeadStartLine { get; set; }

        /// <summary>
        /// 数据写入开始行  从1开始
        /// </summary>
        public int DataStartLine { get; set; }


        /// <summary>
        /// 无参构造
        /// </summary>
        public WorkSheetEntity() { WorkCells = new List<WorkCellEntity>(); }


        /// <summary>
        /// 有参构造
        /// </summary>
        /// <param name="workSheet">orm印射的类</param>
        public WorkSheetEntity(EXCELWorkSheet workSheet)
        {
            EntityPropHelper<WorkSheetEntity, EXCELWorkSheet>.CopyProp(workSheet, this, GetColumnMap());
            WorkCells = new List<WorkCellEntity>();
        }



         ///<summary>
        /// 获取自定义角色类中的字段名为键，orm中对象的字段名为值的字段
        /// </summary>
        /// <returns></returns>
        public static Dictionary<string, string> GetColumnMap()
        {
            return new Dictionary<string, string>() 
            { 
                {"Id", "id"},
                {"Name", "name"},
                {"WorkBookId", "workbookid"},
                {"WorkBookName", "workbookname"},
                {"ClassName", "classname"},
                {"HeadStartLine","headstartline"},
                {"DataStartLine","datastartline"},
                {"SheetIndex","sheetindex"}
            };
        }


        



        /// <summary>
        /// 将对象转换成ORM中的类型
        /// </summary>
        /// <returns>Orm中的BASEShift类型</returns>
        public EXCELWorkSheet ToOrm()
        {
            EXCELWorkSheet workSheet = new EXCELWorkSheet();
            EntityPropHelper<WorkSheetEntity, EXCELWorkSheet>.CopyProp(this, workSheet, GetColumnMap());

            return workSheet;
        }


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


        /// <summary>
        /// 获取ShiftEntity对应的表名
        /// </summary>
        /// <returns>表名</returns>
        public static string GetTableName()
        {
            return "[dbo].[EXCELWorkSheet]";
        }
    }
}