MES_Client/TGMES/Core.StlMes.Client.SaleOrder/Object/SlmOrderAuthenticationEntity.cs

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

namespace com.steering.pss.sale.order.model
{/// <summary>
    /// 数据库表SLM_ORDER_AUTHENTICATION所对应的实体类（生成工具：代码生成工具3.0）
    /// 作者：DESKTOP-DG6B81Q   时间：2015-12-29
    /// </summary>
    public class SlmOrderAuthenticationEntity
    {
        /// <summary>
        /// ORD_PK
        /// </summary>
        private string ordPk = "";
        /// <summary>
        /// ORD_LN_PK(ORD_PK+三位流失号)
        /// </summary>
        private string ordLnPk = "";
        /// <summary>
        /// 合同行号(ORD_PK向下三位流水号,确保流水号的连续性)
        /// </summary>
        private string orderSeq = "";
        /// <summary>
        /// 客户编码
        /// </summary>
        private string customerNo = "";
        /// <summary>
        /// 客户名称
        /// </summary>
        private string customerNm = "";
        /// <summary>
        /// 品名代码
        /// </summary>
        private string produccode = "";
        /// <summary>
        /// 品名描述
        /// </summary>
        private string producname = "";
        /// <summary>
        /// 标准代码
        /// </summary>
        private string stdCode = "";
        /// <summary>
        /// 标准名称
        /// </summary>
        private string stdName = "";
        /// <summary>
        /// 钢级(牌号)代码
        /// </summary>
        private string steelcode = "";
        /// <summary>
        /// 钢级(牌号)名称
        /// </summary>
        private string steelname = "";
        /// <summary>
        /// 产品规格代码
        /// </summary>
        private string specCode = "";
        /// <summary>
        /// 产品规格描述
        /// </summary>
        private string specName = "";
        /// <summary>
        /// 扣型代码
        /// </summary>
        private string modelCode = "";
        /// <summary>
        /// 扣型描述
        /// </summary>
        private string modelDesc = "";
        /// <summary>
        /// 签订日期
        /// </summary>
        private string signDate = "";
        /// <summary>
        /// 交货日期
        /// </summary>
        private string delvryDate = "";
        /// <summary>
        /// 合同首次发运时间
        /// </summary>
        private string delvryBdate = "";
        /// <summary>
        /// 合同末次发运时间
        /// </summary>
        private string delvryEdate = "";
        /// <summary>
        /// 订货量
        /// </summary>
        private string orderQty = "";
        /// <summary>
        /// 订货计量单位(支、米、吨)
        /// </summary>
        private string orderUnit = "";
        /// <summary>
        /// 交货量差(-5%,5%)
        /// </summary>
        private string delvryRangeTpe = "";
        /// <summary>
        /// 合同发运量
        /// </summary>
        private string sendQty = "";
        /// <summary>
        /// 变更状态1：OK  2： 量不合  3:交货期不合 4：量不合及交货期不合
        /// </summary>
        private string changeStatus = "";
        /// <summary>
        /// 客户合同号
        /// </summary>
        private string custmOrderNo = "";
        /// <summary>
        /// 客户合同签订日期
        /// </summary>
        private string custmSignDate = "";
        /// <summary>
        /// 客户合同交货日期
        /// </summary>
        private string custmDelvryDate = "";
        /// <summary>
        /// 合同变更编号
        /// </summary>
        private string changeNo = "";
        /// <summary>
        /// 打印次数
        /// </summary>
        private string printCount = "";
        /// <summary>
        /// 结算单位编码
        /// </summary>
        private string stlmtUnitNo = "";
        /// <summary>
        /// 结算单位名称
        /// </summary>
        private string stlmtUnitNm = "";
        /// <summary>
        /// 最终用户(来源客户表)
        /// </summary>
        private string finalUser = "";
        /// <summary>
        /// 最终用户描述
        /// </summary>
        private string finalUserDesc = "";
        /// <summary>
        /// 合同行状态
        /// </summary>
        private string orderLnStatus = "";
        /// <summary>
        /// 结算价状态0录入1确认
        /// </summary>
        private string balncePriceSts = "";
        /// <summary>
        /// 排产审批单号
        /// </summary>
        private string schApproveNo = "";
        /// <summary>
        /// 合同审批单号
        /// </summary>
        private string ordApproveNo = "";
        /// <summary>
        /// 价格编号
        /// </summary>
        private string priceNo = "";
        /// <summary>
        /// 备注
        /// </summary>
        private string memo = "";
        /// <summary>
        /// 销售片区
        /// </summary>
        private string saleAreaNo = "";
        /// <summary>
        /// 销售片区
        /// </summary>
        private string saleAreaNm = "";
        /// <summary>
        /// 销售组织
        /// </summary>
        private string saleOrg = "";
        /// <summary>
        /// 是否返回（1是 0 否）
        /// </summary>
        private string isReturn = "";
        /// <summary>
        /// 返回时间
        /// </summary>
        private string returnTime = "";

        /// <summary>
        /// 合同号
        /// </summary>
        private string orderNo = "";

        private string supplyUnit = "";

        private string fstDraweeUnit = "";

        /// <summary>
        /// 首次受票人
        /// </summary>
        [Description("首次受票人")]
        public string FstDraweeUnit
        {
            get { return fstDraweeUnit; }
            set { fstDraweeUnit = value; }
        }

        /// <summary>
        /// 供应商
        /// </summary>
        [Description("供应商")]
        public string SupplyUnit
        {
            get { return supplyUnit; }
            set { supplyUnit = value; }
        }

        private string returnName = "";
        /// <summary>
        /// 返回人
        /// </summary>
        [Description("返回人")]
        public string ReturnName
        {
            get { return returnName; }
            set { returnName = value; }
        }

        private string saleOrgDesc = "";
        /// <summary>
        /// 销售组织
        /// </summary>
        [Description("销售组织")]
        public string SaleOrgDesc
        {
            get { return saleOrgDesc; }
            set { saleOrgDesc = value; }
        }

        private string ordLnStatusDesc = "";
        /// <summary>
        /// 合同行状态描述
        /// </summary>
        [Description("合同行状态")]
        public string OrdLnStatusDesc
        {
            get { return ordLnStatusDesc; }
            set { ordLnStatusDesc = value; }
        }

        private string sendCount = "";

        /// <summary>
        /// 发运量(支)
        /// </summary>
        [Description("发运量(支)")]
        public string SendCount
        {
            get { return sendCount; }
            set { sendCount = value; }
        }

        // UPDATE_TIME   BAL_QTY   SCH_QTY  STORE_QTY  SCH_COUNT ORDER_FILE

        private string orderFile = "";

        /// <summary>
        /// 合同文本
        /// </summary>
        [Description("合同文本")]
        public string OrderFile
        {
            get { return orderFile; }
            set { orderFile = value; }
        }

        private string userorderFile = "";

        /// <summary>
        /// 用户合同文本
        /// </summary>
        [Description("用户合同文本")]
        public string UserorderFile
        {
            get { return userorderFile; }
            set { userorderFile = value; }
        }

        private string updateTime = "";
        /// <summary>
        /// 更新时间
        /// </summary>
        [Description("更新时间")]
        public string UpdateTime
        {
            get { return updateTime; }
            set { updateTime = value; }
        }
        private string balQty = "";
        /// <summary>
        /// 结算量(吨)
        /// </summary>
        [Description("结算量(吨)")]
        public string BalQty
        {
            get { return balQty; }
            set { balQty = value; }
        }
        private string schQty = "";
        /// <summary>
        /// 排产量(吨)
        /// </summary>
        [Description("排产量(吨)")]
        public string SchQty
        {
            get { return schQty; }
            set { schQty = value; }
        }
        private string storeQty = "";
        /// <summary>
        /// 库存量(吨)
        /// </summary>
        [Description("库存量(吨)")]
        public string StoreQty
        {
            get { return storeQty; }
            set { storeQty = value; }
        }
        private string schCount = "";
        /// <summary>
        /// 排产量(支)
        /// </summary>
        [Description("排产量(支)")]
        public string SchCount
        {
            get { return schCount; }
            set { schCount = value; }
        }


        /// <summary>
        /// ORD_PK
        /// </summary>
        [Description("ORD_PK")]
        [Nullable(false)]
        [DataLength(40)]
        public string OrdPk
        {
            get { return ordPk; }
            set { ordPk = value; }
        }

        /// <summary>
        /// ORD_LN_PK(ORD_PK+三位流失号)
        /// </summary>
        [Description("ORD_LN_PK")]
        [Nullable(false)]
        [DataLength(40)]
        public string OrdLnPk
        {
            get { return ordLnPk; }
            set { ordLnPk = value; }
        }

        /// <summary>
        /// 合同行号(ORD_PK向下三位流水号,确保流水号的连续性)
        /// </summary>
        [Description("合同行号")]
        [Nullable(false)]
        [DataLength(3)]
        public string OrderSeq
        {
            get { return orderSeq; }
            set { orderSeq = value; }
        }

        /// <summary>
        /// 客户编码
        /// </summary>
        [Description("订货单位")]
        [Nullable(true)]
        [DataLength(10)]
        public string CustomerNo
        {
            get { return customerNo; }
            set { customerNo = value; }
        }

        /// <summary>
        /// 客户名称
        /// </summary>
        [Description("订货单位")]
        [Nullable(true)]
        [DataLength(60)]
        public string CustomerNm
        {
            get { return customerNm; }
            set { customerNm = 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(20)]
        public string StdCode
        {
            get { return stdCode; }
            set { stdCode = value; }
        }

        /// <summary>
        /// 标准名称
        /// </summary>
        [Description("标准名称")]
        [Nullable(true)]
        [DataLength(200)]
        public string StdName
        {
            get { return stdName; }
            set { stdName = 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>
        /// 产品规格代码
        /// </summary>
        [Description("产品规格代码")]
        [Nullable(true)]
        [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)]
        public string SignDate
        {
            get { return signDate; }
            set { signDate = value; }
        }

        /// <summary>
        /// 交货日期
        /// </summary>
        [Description("交货日期")]
        [Nullable(true)]
        public string DelvryDate
        {
            get { return delvryDate; }
            set { delvryDate = value; }
        }

        /// <summary>
        /// 合同首次发运时间
        /// </summary>
        [Description("首次发运时间")]
        [Nullable(true)]
        public string DelvryBdate
        {
            get { return delvryBdate; }
            set { delvryBdate = value; }
        }

        /// <summary>
        /// 合同末次发运时间
        /// </summary>
        [Description("末次发运时间")]
        [Nullable(true)]
        public string DelvryEdate
        {
            get { return delvryEdate; }
            set { delvryEdate = value; }
        }

        /// <summary>
        /// 订货量
        /// </summary>
        [Description("订货量")]
        [Nullable(true)]
        [DataLength(22)]
        public string OrderQty
        {
            get { return orderQty; }
            set { orderQty = value; }
        }

        /// <summary>
        /// 订货计量单位(支、米、吨)
        /// </summary>
        [Description("订货计量单位")]
        [Nullable(true)]
        [DataLength(20)]
        public string OrderUnit
        {
            get { return orderUnit; }
            set { orderUnit = value; }
        }

        /// <summary>
        /// 交货量差(-5%,5%)
        /// </summary>
        [Description("交货量差")]
        [Nullable(true)]
        [DataLength(20)]
        public string DelvryRangeTpe
        {
            get { return delvryRangeTpe; }
            set { delvryRangeTpe = value; }
        }

        /// <summary>
        /// 合同发运量(吨)
        /// </summary>
        [Description("发运量(吨)")]
        [Nullable(true)]
        [DataLength(22)]
        public string SendQty
        {
            get { return sendQty; }
            set { sendQty = value; }
        }

        /// <summary>
        /// 变更状态（交货期和交货量）1：OK  2： 量不合 3:交货期不满足 4：量不合交货期不满足
        /// </summary>
        [Description("交货状态")]
        [Nullable(true)]
        [DataLength(1)]
        public string ChangeStatus
        {
            get { return changeStatus; }
            set { changeStatus = value; }
        }

        /// <summary>
        /// 客户合同号
        /// </summary>
        [Description("客户合同号")]
        [Nullable(true)]
        [DataLength(100)]
        public string CustmOrderNo
        {
            get { return custmOrderNo; }
            set { custmOrderNo = value; }
        }

        /// <summary>
        /// 客户合同签订日期
        /// </summary>
        [Description("客户合同签订日期")]
        [Nullable(true)]
        public string CustmSignDate
        {
            get { return custmSignDate; }
            set { custmSignDate = value; }
        }

        /// <summary>
        /// 客户合同交货日期
        /// </summary>
        [Description("客户合同交货日期")]
        [Nullable(true)]
        public string CustmDelvryDate
        {
            get { return custmDelvryDate; }
            set { custmDelvryDate = value; }
        }

        /// <summary>
        /// 合同变更编号
        /// </summary>
        [Description("合同变更编号")]
        [Nullable(true)]
        [DataLength(200)]
        public string ChangeNo
        {
            get { return changeNo; }
            set { changeNo = value; }
        }

        /// <summary>
        /// 打印次数
        /// </summary>
        [Description("打印次数")]
        [Nullable(true)]
        [DataLength(3)]
        public string PrintCount
        {
            get { return printCount; }
            set { printCount = value; }
        }

        /// <summary>
        /// 结算单位编码
        /// </summary>
        [Description("结算单位编码")]
        [Nullable(true)]
        [DataLength(10)]
        public string StlmtUnitNo
        {
            get { return stlmtUnitNo; }
            set { stlmtUnitNo = value; }
        }

        /// <summary>
        /// 结算单位名称
        /// </summary>
        [Description("结算单位")]
        [Nullable(true)]
        [DataLength(60)]
        public string StlmtUnitNm
        {
            get { return stlmtUnitNm; }
            set { stlmtUnitNm = value; }
        }

        /// <summary>
        /// 最终用户(来源客户表)
        /// </summary>
        [Description("最终用户(来源客户表)")]
        [Nullable(true)]
        [DataLength(20)]
        public string FinalUser
        {
            get { return finalUser; }
            set { finalUser = value; }
        }

        /// <summary>
        /// 最终用户描述
        /// </summary>
        [Description("最终用户")]
        [Nullable(true)]
        [DataLength(100)]
        public string FinalUserDesc
        {
            get { return finalUserDesc; }
            set { finalUserDesc = value; }
        }

        /// <summary>
        /// 合同行状态
        /// </summary>
        [Description("合同行状态")]
        [Nullable(true)]
        [DataLength(20)]
        public string OrderLnStatus
        {
            get { return orderLnStatus; }
            set { orderLnStatus = value; }
        }

        /// <summary>
        /// 结算价状态0录入1确认
        /// </summary>
        [Description("结算价状态")]
        [Nullable(true)]
        [DataLength(1)]
        public string BalncePriceSts
        {
            get { return balncePriceSts; }
            set { balncePriceSts = value; }
        }

        /// <summary>
        /// 排产审批单号
        /// </summary>
        [Description("排产审批单号")]
        [Nullable(true)]
        [DataLength(50)]
        public string SchApproveNo
        {
            get { return schApproveNo; }
            set { schApproveNo = value; }
        }

        /// <summary>
        /// 合同审批单号
        /// </summary>
        [Description("合同审批单号")]
        [Nullable(true)]
        [DataLength(50)]
        public string OrdApproveNo
        {
            get { return ordApproveNo; }
            set { ordApproveNo = value; }
        }

        /// <summary>
        /// 价格编号
        /// </summary>
        [Description("价格编号")]
        [Nullable(true)]
        [DataLength(20)]
        public string PriceNo
        {
            get { return priceNo; }
            set { priceNo = value; }
        }

        /// <summary>
        /// 备注
        /// </summary>
        [Description("备注")]
        [Nullable(true)]
        [DataLength(400)]
        public string Memo
        {
            get { return memo; }
            set { memo = value; }
        }

        /// <summary>
        /// 销售片区
        /// </summary>
        [Description("销售片区")]
        [Nullable(true)]
        [DataLength(20)]
        public string SaleAreaNo
        {
            get { return saleAreaNo; }
            set { saleAreaNo = value; }
        }

        /// <summary>
        /// 销售片区
        /// </summary>
        [Description("销售片区")]
        [Nullable(true)]
        [DataLength(100)]
        public string SaleAreaNm
        {
            get { return saleAreaNm; }
            set { saleAreaNm = value; }
        }

        /// <summary>
        /// 销售组织
        /// </summary>
        [Description("销售组织")]
        [Nullable(true)]
        [DataLength(10)]
        public string SaleOrg
        {
            get { return saleOrg; }
            set { saleOrg = value; }
        }

        /// <summary>
        /// 是否返回（1是 0 否）
        /// </summary>
        [Description("是否返回")]
        [Nullable(true)]
        [DataLength(1)]
        public string IsReturn
        {
            get { return isReturn; }
            set { isReturn = value; }
        }

        /// <summary>
        /// 返回时间
        /// </summary>
        [Description("返回时间")]
        [Nullable(true)]
        public string ReturnTime
        {
            get { return returnTime; }
            set { returnTime = value; }
        }

        /// <summary>
        /// 合同号
        /// </summary>
        [Description("合同号")]
        [Nullable(true)]
        [DataLength(10)]
        public string OrderNo
        {
            get { return orderNo; }
            set { orderNo = value; }
        }

        /// <summary>
        /// 创建人
        /// </summary>
        private string createName = "";
        /// <summary>
        /// 原始创建人
        /// </summary>
        private string createNameOld = "";
        /// <summary>
        /// 原始销售区域编码
        /// </summary>
        private string saleAreaNoOld = "";
        /// <summary>
        /// 原始销售区域描述
        /// </summary>
        private string saleAreaDescOld = "";
        /// <summary>
        /// 创建人
        /// </summary>
        [Description("创建人")]
        [Nullable(true)]
        [DataLength(20)]
        public string CreateName
        {
            get { return createName; }
            set { createName = value; }
        }
        /// <summary>
        /// 原始创建人
        /// </summary>
        [Description("原始创建人")]
        [Nullable(true)]
        [DataLength(20)]
        public string CreateNameOld
        {
            get { return createNameOld; }
            set { createNameOld = value; }
        }

        /// <summary>
        /// 原始销售区域编码
        /// </summary>
        [Description("原始销售区域编码")]
        [Nullable(true)]
        [DataLength(20)]
        public string SaleAreaNoOld
        {
            get { return saleAreaNoOld; }
            set { saleAreaNoOld = value; }
        }

        /// <summary>
        /// 原始销售区域描述
        /// </summary>
        [Description("原始销售区域描述")]
        [Nullable(true)]
        [DataLength(50)]
        public string SaleAreaDescOld
        {
            get { return saleAreaDescOld; }
            set { saleAreaDescOld = value; }
        }

    }
}