using iWareCommon.Common.Entity;
using iWareCommon.Utils;
using iWareDataCore.ORM;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace iWareDataCore.BASE.Entity
{
    public class MaterialEntity : ICommonEntity<BASEMaterial>
    {
        /// <summary>
        /// 1物料主键
        /// </summary>
        public int Id { get; set; }

        /// <summary>
        /// 2物料名称
        /// </summary>
        public string Name { get; set; }

        /// <summary>
        /// 2物料规格号
        /// </summary>
        public string MaterialNo { get; set; }

        /// <summary>
        /// 3物料号
        /// </summary>
        public string Code { get; set; }

        /// <summary>
        /// 4版本（用于保存在SAP中的物料类型）
        /// </summary>
        public string Version { get; set; }

        /// <summary>
        /// 5物料状态（启用、禁用）
        /// </summary>
        public int Status { get; set; }

        /// <summary>
        /// 6外键物料类型id
        /// </summary>
        public int TypeId { get; set; }

        /// <summary>
        /// 7保质期
        /// </summary>
        public string GuaranteePeriod { get; set; }

        /// <summary>
        /// 8计数单位
        /// </summary>
        public string Unit { get; set; }

        /// <summary>
        /// 9备注（用于保存SAP中的物料组）
        /// </summary>
        public string Remark { get; set; }

        /// <summary>
        /// 10描述
        /// </summary>
        public string Description { get; set; }

        /// <summary>
        /// 11成本
        /// </summary>
        public decimal Cost { get; set; }

        /// <summary>
        /// 12船级社
        /// </summary>
        public string ClassificationSociety { get; set; }

        /// <summary>
        /// 13分段号
        /// </summary>
        public string SerialNo { get; set; }

        /// <summary>
        /// 14垂直位置
        /// </summary>
        public string VerticalPosition { get; set; }

        /// <summary>
        /// 15重量
        /// </summary>
        public string Weight { get; set; }

        /// <summary>
        /// 16发放工程号
        /// </summary>
        public string IssueProjectNo { get; set; }

        /// <summary>
        /// 17采购工程号
        /// </summary>
        public string ProcurementProjectNo { get; set; }

        /// <summary>
        /// 18切割类型
        /// </summary>
        public string CuttingType { get; set; }

        /// <summary>
        /// 19页码
        /// </summary>
        public string PageNo { get; set; }

        /// <summary>
        /// 20厚
        /// </summary>
        public string Thick { get; set; }

        /// <summary>
        /// 21宽
        /// </summary>
        public string Wide { get; set; }

        /// <summary>
        /// 22长
        /// </summary>
        public string Length { get; set; }

        /// <summary>
        /// 23记号笔
        /// </summary>
        public string MarkingPen { get; set; }

        /// <summary>
        /// 24分道
        /// </summary>
        public string LaneSeparation { get; set; }






        /// <summary>
        /// 无参构造
        /// </summary>
        public MaterialEntity() { }


        /// <summary>
        /// 有参构造
        /// </summary>
        /// <param name="material">orm映射的类</param>
        public MaterialEntity(BASEMaterial material)
        {
            EntityPropHelper<MaterialEntity, BASEMaterial>.CopyProp(material, this, GetColumnMap());

        }


        /// <summary>
        /// 转换视图的方法
        /// </summary>
        /// <param name="material"></param>
        public MaterialEntity(MaterialViewEntity material)
        {
            var keys = GetColumnMap().Keys.ToList();
            var columnMap = new Dictionary<string, string>();
            keys.ForEach(x => columnMap.Add(x, x));

            EntityPropHelper<MaterialEntity, MaterialViewEntity>.CopyProp(material, this, columnMap);

        }


        /// <summary>
        /// 将对象转换成ORM中的类型
        /// </summary>
        /// <returns>Orm中的BASEMaterial类型</returns>
        public BASEMaterial ToOrm()
        {
            BASEMaterial material = new BASEMaterial();

            EntityPropHelper<MaterialEntity, BASEMaterial>.CopyProp(this, material, GetColumnMap());

            return material;
        }



        ///<summary>
        /// 获取自定义角色类中的字段名为键，orm中对象的字段名为值的字段
        /// </summary>
        /// <returns></returns>
        public static Dictionary<string, string> GetColumnMap()
        {
            return new Dictionary<string, string>() 
            { 
                { "Id", "id"},
                { "Name", "name"},
                { "Code", "code"},
                { "MaterialNo", "materialno"},
                { "Version", "version"},
                { "Status", "status"},
                { "TypeId","typeid"},
                { "GuaranteePeriod", "guaranteeperiod"},
                { "Unit", "unit"},
                { "Remark", "remark"},
                { "Description", "description"},
                { "Cost", "cost"},
                { "ClassificationSociety", "classificationsociety"},
                { "SerialNo", "serialno"},
                { "VerticalPosition", "verticalposition"},
                { "Weight", "weight"},
                { "IssueProjectNo", "issueprojectno"},
                { "ProcurementProjectNo", "procurementprojectno"},
                { "CuttingType", "cuttingtype"},
                { "PageNo", "pageno"},
                { "Thick", "thick"},
                { "Wide", "wide"},
                { "Length", "length"},
                { "MarkingPen", "markingpen"},
                { "LaneSeparation", "laneseparation"}

            };
        }




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

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