MES_Client/TGMES/Core.StlMes.Client.YdmBcPipeManage/Entity/CrmBaseMaterialEntity.cs

using Core.Mes.Client.Comm.Attribute;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Text;

namespace Core.StlMes.Client.YdmBcPipeManage.Entity
{
    /// <summary>
    /// 数据库表CRM_BASE_MATERIAL所对应的实体类（生成工具：代码生成工具3.0）
    /// 作者：LAPTOP-I2IGVKJC   时间：2022-04-13
    /// </summary>
    public class CrmBaseMaterialEntity
    {
        /// <summary>
        /// 物料编码
        /// </summary>
        private string materialNo = "";
        /// <summary>
        /// 物料描述
        /// </summary>
        private string materialDesc = "";
        /// <summary>
        /// 品名代码
        /// </summary>
        private string produccode = "";
        /// <summary>
        /// 品名描述
        /// </summary>
        private string producname = "";
        /// <summary>
        /// 品名简称
        /// </summary>
        private string producJx = "";
        /// <summary>
        /// 品名英语名称
        /// </summary>
        private string producEng = "";
        /// <summary>
        /// 标准类别代码
        /// </summary>
        private string stdStyle = "";
        /// <summary>
        /// 标准类别描述(PSL1....)
        /// </summary>
        private string stdStyleDesc = "";
        /// <summary>
        /// 钢级(牌号)代码
        /// </summary>
        private string steelcode = "";
        /// <summary>
        /// 钢级(牌号)名称
        /// </summary>
        private string steelname = "";
        /// <summary>
        /// 钢种代码(GZ0001)
        /// </summary>
        private string gradecode = "";
        /// <summary>
        /// 钢种名称
        /// </summary>
        private string gradename = "";
        /// <summary>
        /// 外径
        /// </summary>
        private string dimater = "";
        /// <summary>
        /// 壁厚
        /// </summary>
        private string height = "";
        /// <summary>
        /// 管坯规格代码(从产品规格表中取值)
        /// </summary>
        private string specCode = "";
        /// <summary>
        /// 管坯规格描述
        /// </summary>
        private string specName = "";
        /// <summary>
        /// 扣型代码
        /// </summary>
        private string modelCode = "";
        /// <summary>
        /// 扣型描述
        /// </summary>
        private string modelDesc = "";
        /// <summary>
        /// 允许外购
        /// </summary>
        private string outsrcAllow = "";
        /// <summary>
        /// 首次生产(对应物料缴库时改变首次生产标识)("1";首次生产；"0":已生产过)
        /// </summary>
        private string firstPrdc = "";
        /// <summary>
        /// 创建人
        /// </summary>
        private string createName = "";
        /// <summary>
        /// 创建时间
        /// </summary>
        private string createTime = "";
        /// <summary>
        /// 修改人
        /// </summary>
        private string updateName = "";
        /// <summary>
        /// 修改时间
        /// </summary>
        private string updateTime = "";
        /// <summary>
        /// 删除人
        /// </summary>
        private string deleteName = "";
        /// <summary>
        /// 删除时间
        /// </summary>
        private string deleteTime = "";
        /// <summary>
        /// 是否自动生成工艺文件(1:是 0:否)
        /// </summary>
        private string autoCraft = "";
        /// <summary>
        /// 物料大类
        /// </summary>
        private string materialTypeMax = "";
        /// <summary>
        /// 物料中类
        /// </summary>
        private string materialTypeMid = "";
        /// <summary>
        /// 物料小类
        /// </summary>
        private string materialTypeMin = "";
        /// <summary>
        /// 属性分类1
        /// </summary>
        private string propertyType1 = "";
        /// <summary>
        /// 属性分类2
        /// </summary>
        private string propertyType2 = "";
        /// <summary>
        /// TP系列
        /// </summary>
        private string tpSeries = "";
        /// <summary>
        /// 特殊扣型
        /// </summary>
        private string specialModel = "";
        /// <summary>
        /// 高端产品
        /// </summary>
        private string upmarketProduct = "";
        /// <summary>
        /// 高附加值产品
        /// </summary>
        private string highAdditionalProduct = "";
        /// <summary>
        /// 物料大类
        /// </summary>
        private string materialTypeMaxDesc = "";
        /// <summary>
        /// 物料中类
        /// </summary>
        private string materialTypeMidDesc = "";
        /// <summary>
        /// 物料小类
        /// </summary>
        private string materialTypeMinDesc = "";
        /// <summary>
        /// 属性分类1
        /// </summary>
        private string propertyType1Desc = "";
        /// <summary>
        /// 属性分类2
        /// </summary>
        private string propertyType2Desc = "";
        /// <summary>
        /// 完全成本
        /// </summary>
        private decimal? totalCost = null;
        /// <summary>
        /// 数据类型(0 新增 1修改 2删除)
        /// </summary>
        private string dataStatus = "";
        /// <summary>
        /// CRM是否同步(0 未同步 1已同步)
        /// </summary>
        private string isFlag = "";
        /// <summary>
        /// CRM同步时间
        /// </summary>
        private string synchroTime = "";
        /// <summary>
        /// 主键
        /// </summary>
        private string id = "";
        /// <summary>
        /// 插入时间
        /// </summary>
        private string dataTime = "";

        /// <summary>
        /// 物料编码
        /// </summary>
        [Description("物料编码")]
        [Nullable(false)]
        [DataLength(30)]
        public string MaterialNo
        {
            get { return materialNo; }
            set { materialNo = value; }
        }

        /// <summary>
        /// 物料描述
        /// </summary>
        [Description("物料描述")]
        [Nullable(true)]
        [DataLength(100)]
        public string MaterialDesc
        {
            get { return materialDesc; }
            set { materialDesc = value; }
        }

        /// <summary>
        /// 品名代码
        /// </summary>
        [Description("品名代码")]
        [Nullable(true)]
        [DataLength(20)]
        public string Produccode
        {
            get { return produccode; }
            set { produccode = value; }
        }

        /// <summary>
        /// 品名描述
        /// </summary>
        [Description("品名描述")]
        [Nullable(true)]
        [DataLength(100)]
        public string Producname
        {
            get { return producname; }
            set { producname = value; }
        }

        /// <summary>
        /// 品名简称
        /// </summary>
        [Description("品名简称")]
        [Nullable(true)]
        [DataLength(50)]
        public string ProducJx
        {
            get { return producJx; }
            set { producJx = value; }
        }

        /// <summary>
        /// 品名英语名称
        /// </summary>
        [Description("品名英语名称")]
        [Nullable(true)]
        [DataLength(200)]
        public string ProducEng
        {
            get { return producEng; }
            set { producEng = value; }
        }

        /// <summary>
        /// 标准类别代码
        /// </summary>
        [Description("标准类别代码")]
        [Nullable(true)]
        [DataLength(20)]
        public string StdStyle
        {
            get { return stdStyle; }
            set { stdStyle = value; }
        }

        /// <summary>
        /// 标准类别描述(PSL1....)
        /// </summary>
        [Description("标准类别描述(PSL1....)")]
        [Nullable(true)]
        [DataLength(50)]
        public string StdStyleDesc
        {
            get { return stdStyleDesc; }
            set { stdStyleDesc = value; }
        }

        /// <summary>
        /// 钢级(牌号)代码
        /// </summary>
        [Description("钢级(牌号)代码")]
        [Nullable(true)]
        [DataLength(10)]
        public string Steelcode
        {
            get { return steelcode; }
            set { steelcode = value; }
        }

        /// <summary>
        /// 钢级(牌号)名称
        /// </summary>
        [Description("钢级(牌号)名称")]
        [Nullable(true)]
        [DataLength(100)]
        public string Steelname
        {
            get { return steelname; }
            set { steelname = value; }
        }

        /// <summary>
        /// 钢种代码(GZ0001)
        /// </summary>
        [Description("钢种代码(GZ0001)")]
        [Nullable(true)]
        [DataLength(6)]
        public string Gradecode
        {
            get { return gradecode; }
            set { gradecode = value; }
        }

        /// <summary>
        /// 钢种名称
        /// </summary>
        [Description("钢种名称")]
        [Nullable(true)]
        [DataLength(100)]
        public string Gradename
        {
            get { return gradename; }
            set { gradename = value; }
        }

        /// <summary>
        /// 外径
        /// </summary>
        [Description("外径")]
        [Nullable(true)]
        [DataLength(10)]
        public string Dimater
        {
            get { return dimater; }
            set { dimater = value; }
        }

        /// <summary>
        /// 壁厚
        /// </summary>
        [Description("壁厚")]
        [Nullable(true)]
        [DataLength(10)]
        public string Height
        {
            get { return height; }
            set { height = value; }
        }

        /// <summary>
        /// 管坯规格代码(从产品规格表中取值)
        /// </summary>
        [Description("管坯规格代码(从产品规格表中取值)")]
        [Nullable(false)]
        [DataLength(20)]
        public string SpecCode
        {
            get { return specCode; }
            set { specCode = value; }
        }

        /// <summary>
        /// 管坯规格描述
        /// </summary>
        [Description("管坯规格描述")]
        [Nullable(true)]
        [DataLength(100)]
        public string SpecName
        {
            get { return specName; }
            set { specName = value; }
        }

        /// <summary>
        /// 扣型代码
        /// </summary>
        [Description("扣型代码")]
        [Nullable(true)]
        [DataLength(20)]
        public string ModelCode
        {
            get { return modelCode; }
            set { modelCode = value; }
        }

        /// <summary>
        /// 扣型描述
        /// </summary>
        [Description("扣型描述")]
        [Nullable(true)]
        [DataLength(100)]
        public string ModelDesc
        {
            get { return modelDesc; }
            set { modelDesc = value; }
        }

        /// <summary>
        /// 允许外购
        /// </summary>
        [Description("允许外购")]
        [Nullable(true)]
        [DataLength(2)]
        public string OutsrcAllow
        {
            get { return outsrcAllow; }
            set { outsrcAllow = value; }
        }

        /// <summary>
        /// 首次生产(对应物料缴库时改变首次生产标识)("1";首次生产；"0":已生产过)
        /// </summary>
        [Description("首次生产(对应物料缴库时改变首次生产标识)(\"1\";首次生产；\"0\":已生产过)")]
        [Nullable(true)]
        [DataLength(20)]
        public string FirstPrdc
        {
            get { return firstPrdc; }
            set { firstPrdc = value; }
        }

        /// <summary>
        /// 创建人
        /// </summary>
        [Description("创建人")]
        [Nullable(true)]
        [DataLength(20)]
        public string CreateName
        {
            get { return createName; }
            set { createName = value; }
        }

        /// <summary>
        /// 创建时间
        /// </summary>
        [Description("创建时间")]
        [Nullable(true)]
        public string CreateTime
        {
            get { return createTime; }
            set { createTime = value; }
        }

        /// <summary>
        /// 修改人
        /// </summary>
        [Description("修改人")]
        [Nullable(true)]
        [DataLength(20)]
        public string UpdateName
        {
            get { return updateName; }
            set { updateName = value; }
        }

        /// <summary>
        /// 修改时间
        /// </summary>
        [Description("修改时间")]
        [Nullable(true)]
        public string UpdateTime
        {
            get { return updateTime; }
            set { updateTime = value; }
        }

        /// <summary>
        /// 删除人
        /// </summary>
        [Description("删除人")]
        [Nullable(true)]
        [DataLength(20)]
        public string DeleteName
        {
            get { return deleteName; }
            set { deleteName = value; }
        }

        /// <summary>
        /// 删除时间
        /// </summary>
        [Description("删除时间")]
        [Nullable(true)]
        public string DeleteTime
        {
            get { return deleteTime; }
            set { deleteTime = value; }
        }

        /// <summary>
        /// 是否自动生成工艺文件(1:是 0:否)
        /// </summary>
        [Description("是否自动生成工艺文件(1:是 0:否)")]
        [Nullable(true)]
        [DataLength(2)]
        public string AutoCraft
        {
            get { return autoCraft; }
            set { autoCraft = value; }
        }

        /// <summary>
        /// 物料大类
        /// </summary>
        [Description("物料大类")]
        [Nullable(true)]
        [DataLength(10)]
        public string MaterialTypeMax
        {
            get { return materialTypeMax; }
            set { materialTypeMax = value; }
        }

        /// <summary>
        /// 物料中类
        /// </summary>
        [Description("物料中类")]
        [Nullable(true)]
        [DataLength(10)]
        public string MaterialTypeMid
        {
            get { return materialTypeMid; }
            set { materialTypeMid = value; }
        }

        /// <summary>
        /// 物料小类
        /// </summary>
        [Description("物料小类")]
        [Nullable(true)]
        [DataLength(10)]
        public string MaterialTypeMin
        {
            get { return materialTypeMin; }
            set { materialTypeMin = value; }
        }

        /// <summary>
        /// 属性分类1
        /// </summary>
        [Description("属性分类1")]
        [Nullable(true)]
        [DataLength(10)]
        public string PropertyType1
        {
            get { return propertyType1; }
            set { propertyType1 = value; }
        }

        /// <summary>
        /// 属性分类2
        /// </summary>
        [Description("属性分类2")]
        [Nullable(true)]
        [DataLength(10)]
        public string PropertyType2
        {
            get { return propertyType2; }
            set { propertyType2 = value; }
        }

        /// <summary>
        /// TP系列
        /// </summary>
        [Description("TP系列")]
        [Nullable(true)]
        [DataLength(2)]
        public string TpSeries
        {
            get { return tpSeries; }
            set { tpSeries = value; }
        }

        /// <summary>
        /// 特殊扣型
        /// </summary>
        [Description("特殊扣型")]
        [Nullable(true)]
        [DataLength(2)]
        public string SpecialModel
        {
            get { return specialModel; }
            set { specialModel = value; }
        }

        /// <summary>
        /// 高端产品
        /// </summary>
        [Description("高端产品")]
        [Nullable(true)]
        [DataLength(2)]
        public string UpmarketProduct
        {
            get { return upmarketProduct; }
            set { upmarketProduct = value; }
        }

        /// <summary>
        /// 高附加值产品
        /// </summary>
        [Description("高附加值产品")]
        [Nullable(true)]
        [DataLength(2)]
        public string HighAdditionalProduct
        {
            get { return highAdditionalProduct; }
            set { highAdditionalProduct = value; }
        }

        /// <summary>
        /// 物料大类
        /// </summary>
        [Description("物料大类")]
        [Nullable(true)]
        [DataLength(100)]
        public string MaterialTypeMaxDesc
        {
            get { return materialTypeMaxDesc; }
            set { materialTypeMaxDesc = value; }
        }

        /// <summary>
        /// 物料中类
        /// </summary>
        [Description("物料中类")]
        [Nullable(true)]
        [DataLength(100)]
        public string MaterialTypeMidDesc
        {
            get { return materialTypeMidDesc; }
            set { materialTypeMidDesc = value; }
        }

        /// <summary>
        /// 物料小类
        /// </summary>
        [Description("物料小类")]
        [Nullable(true)]
        [DataLength(100)]
        public string MaterialTypeMinDesc
        {
            get { return materialTypeMinDesc; }
            set { materialTypeMinDesc = value; }
        }

        /// <summary>
        /// 属性分类1
        /// </summary>
        [Description("属性分类1")]
        [Nullable(true)]
        [DataLength(100)]
        public string PropertyType1Desc
        {
            get { return propertyType1Desc; }
            set { propertyType1Desc = value; }
        }

        /// <summary>
        /// 属性分类2
        /// </summary>
        [Description("属性分类2")]
        [Nullable(true)]
        [DataLength(100)]
        public string PropertyType2Desc
        {
            get { return propertyType2Desc; }
            set { propertyType2Desc = value; }
        }

        /// <summary>
        /// 完全成本
        /// </summary>
        [Description("完全成本")]
        [Nullable(true)]
        [DataLength(9)]
        public decimal? TotalCost
        {
            get { return totalCost; }
            set { totalCost = value; }
        }

        /// <summary>
        /// 数据类型(0 新增 1修改 2删除)
        /// </summary>
        [Description("数据类型(0 新增 1修改 2删除)")]
        [Nullable(true)]
        [DataLength(1)]
        public string DataStatus
        {
            get { return dataStatus; }
            set { dataStatus = value; }
        }

        /// <summary>
        /// CRM是否同步(0 未同步 1已同步)
        /// </summary>
        [Description("CRM是否同步(0 未同步 1已同步)")]
        [Nullable(true)]
        [DataLength(1)]
        public string IsFlag
        {
            get { return isFlag; }
            set { isFlag = value; }
        }

        /// <summary>
        /// CRM同步时间
        /// </summary>
        [Description("CRM同步时间")]
        [Nullable(true)]
        public string SynchroTime
        {
            get { return synchroTime; }
            set { synchroTime = value; }
        }

        /// <summary>
        /// 主键
        /// </summary>
        [Description("主键")]
        [Nullable(false)]
        [DataLength(40)]
        public string Id
        {
            get { return id; }
            set { id = value; }
        }

        /// <summary>
        /// 插入时间
        /// </summary>
        [Description("插入时间")]
        [Nullable(true)]
        public string DataTime
        {
            get { return dataTime; }
            set { dataTime = value; }
        }
    }
}