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 { /// /// 数据库表CRM_SLM_ORDER所对应的实体类(生成工具:代码生成工具3.0) /// 作者:LAPTOP-I2IGVKJC 时间:2021-06-04 /// public class CrmSlmOrderEntity { /// /// ORD_PK /// private string ordPk = ""; /// /// ORD_LN_PK(ORD_PK+三位流失号) /// private string ordLnPk = ""; /// /// ORD_LN_DLY_PK(ORD_LN_PK+三位流水号) /// private string ordLnDlyPk = ""; /// /// 合同号(记录创建时如无合同号,形成LS+YYMMDD+三位流水号的临时合同号 /// private string orderNo = ""; /// /// 合同行号(ORD_PK向下三位流水号,确保流水号的连续性) /// private string orderSeq = ""; /// /// 交货编码(ORD_PK向下三位流水号,确保流水号唯一性、连续性) /// private string deliveryNo = ""; /// /// 客户合同号 /// private string custmOrderNo = ""; /// /// 合同类型 /// private string orderTyp = ""; /// /// 合同类型描述 /// private string orderTypDesc = ""; /// /// 省市/区域代码 /// private string regionNo = ""; /// /// 省市/区域 /// private string regionName = ""; /// /// 销售组织(国内贸易部/国际贸易部) /// private string saleOrg = ""; /// /// 销售组织描述 /// private string saleOrgDesc = ""; /// /// 销售区域编码 /// private string saleAreaNo = ""; /// /// 销售区域描述 /// private string saleAreaDesc = ""; /// /// 订货单位代码 /// private string customerNo = ""; /// /// 订货单位名称 /// private string customerNm = ""; /// /// 收货单位编码 /// private string receivNo = ""; /// /// 收货单位名称 /// private string receivNm = ""; /// /// 计价方式(1203) /// private string priceFl = ""; /// /// 订货量 /// private decimal? orderQty = null; /// /// 订货价(结算价) /// private decimal? balncePrice = null; /// /// 币种 /// private string currency = ""; /// /// 付款方式 /// private string mnyAskTyp = ""; /// /// 是否含税 0 否 1 是 /// private string containTax = ""; /// /// 订货计量单位(支、米、吨) /// private string orderUnit = ""; /// /// 品名代码 /// private string produccode = ""; /// /// 品名描述 /// private string producname = ""; /// /// 标准代码 /// private string stdCode = ""; /// /// 标准名称 /// private string stdName = ""; /// /// 钢级(牌号)代码 /// private string steelcode = ""; /// /// 钢级(牌号)名称 /// private string steelname = ""; /// /// 标准类别代码 /// private string stdStyle = ""; /// /// 标准类别描述 /// private string stdStyleDesc = ""; /// /// 扣型代码 /// private string modelCode = ""; /// /// 扣型描述 /// private string modelDesc = ""; /// /// 订货规格代码(用于合同、质保书、标牌、标识) /// private string orderSpecCode = ""; /// /// 订货规格描述(用于合同、质保书、标牌、标识) /// private string orderSpecDesc = ""; /// /// 产品规格代码 /// private string specCode = ""; /// /// 产品规格描述 /// private string specName = ""; /// /// 外径(mm) /// private decimal? dimater = null; /// /// 壁厚(mm) /// private decimal? height = null; /// /// 长度编码 /// private string lenNo = ""; /// /// 长度描述 /// private string lenDesc = ""; /// /// 长度单位 /// private string lenUnit = ""; /// /// 外购坯(COM_BASE_INFO:1218) /// private string outsBilletFl = ""; /// /// 外购管(COM_BASE_INFO:1219) /// private string outsStlPipeFl = ""; /// /// 付款要求描述 /// private string mnyAskDesc = ""; /// /// 合同头锁定状态 /// private string islock = ""; /// /// 监制说明 /// private string prdcrDesc = ""; /// /// MPS说明 /// private string mpsDesc = ""; /// /// 结算单位编码 /// private string stlmtUnitNo = ""; /// /// 结算单位名称 /// private string stlmtUnitNm = ""; /// /// 交货量差方式(绝对值;百分比) /// private string delvryRangeTpe = ""; /// /// 交货量差下限 /// private decimal? delvryRangeMin = null; /// /// 交货量差上限 /// private decimal? delvryRangeMax = null; /// /// 附加要求编码 /// private string addAskNo = ""; /// /// 订货附加要求描述 /// private string orderAddDesc = ""; /// /// 产品特殊要求描述 /// private string orderSpecialDesc = ""; /// /// 交货行状态 /// private string orderSts = ""; /// /// 交货行状态描述 /// private string orderStsDesc = ""; /// /// 制造商代码 /// private string supplyUnitCode = ""; /// /// 制造商 /// private string supplyUnit = ""; /// /// 重量估算 /// private decimal? wgtEstmt = null; /// /// 交货结束日期 /// private string delvryEdate = ""; /// /// 生效时间 /// private string effectTime = ""; /// /// 提报时间 /// private string tibaoTime = ""; /// /// CRM是否同步(0 未同步 1已同步) /// private string isFlag = ""; /// /// 数据类型(0 新增 1修改 2删除) /// private string dataStatus = ""; /// /// CRM用于修改的字段 /// private string crmFlag = ""; /// /// CRM同步时间 /// private string synchroTime = ""; /// /// 主键 /// private string id = ""; /// /// 创建时间 /// private string createTime = ""; /// /// 合同行状态 /// private string orderLnSts = ""; /// /// 合同行状态描述 /// private string orderLnStsDesc = ""; /// /// 合同创建人 /// private string createName = ""; private string fstDraweeUnit = ""; private string keepType; private string createTimestamp = ""; /// /// 合同头状态 /// private string orderHeadSts = ""; /// /// 合同头状态描述 /// private string orderHeadStsDesc = ""; private string materialNo; private string materialDesc; [Description("物料编码")] public string MaterialNo { get { return materialNo; } set { materialNo = value; } } [Description("物料名称")] public string MaterialDesc { get { return materialDesc; } set { materialDesc = value; } } [Description("合同头状态")] public string OrderHeadSts { get { return orderHeadSts; } set { orderHeadSts = value; } } [Description("合同头状态描述")] public string OrderHeadStsDesc { get { return orderHeadStsDesc; } set { orderHeadStsDesc = value; } } /// /// 创建时间戳 /// [Description("创建时间戳")] public string CreateTimestamp { get { return createTimestamp; } set { createTimestamp = value; } } /// /// 保价类型 /// [Description("保价类型")] public string KeepType { get { return keepType; } set { keepType = value; } } private string problemMsg; /// /// 问题反馈 /// [Description("问题反馈")] public string ProblemMsg { get { return problemMsg; } set { problemMsg = value; } } /// /// 数据状态(0 合同头 1合同行 2交货行) /// private string dataFlag = ""; [Description("操作数据类型")] [Nullable(true)] public string DataFlag { get { return dataFlag; } set { dataFlag = value; } } /// /// 首次受票人(国贸/钢贸/集团/客户) 卖出单位 /// [Description("首次受票人")] [Nullable(true)] [DataLength(30)] public string FstDraweeUnit { get { return fstDraweeUnit; } set { fstDraweeUnit = value; } } /// /// ORD_PK /// [Description("ORD_PK")] [Nullable(false)] [DataLength(40)] public string OrdPk { get { return ordPk; } set { ordPk = value; } } /// /// ORD_LN_PK(ORD_PK+三位流失号) /// [Description("ORD_LN_PK")] [Nullable(false)] [DataLength(40)] public string OrdLnPk { get { return ordLnPk; } set { ordLnPk = value; } } /// /// ORD_LN_DLY_PK(ORD_LN_PK+三位流水号) /// [Description("ORD_LN_DLY_PK")] [Nullable(false)] [DataLength(40)] public string OrdLnDlyPk { get { return ordLnDlyPk; } set { ordLnDlyPk = value; } } /// /// 合同号(记录创建时如无合同号,形成LS+YYMMDD+三位流水号的临时合同号 /// [Description("合同号")] [Nullable(true)] [DataLength(20)] public string OrderNo { get { return orderNo; } set { orderNo = value; } } /// /// 合同行号(ORD_PK向下三位流水号,确保流水号的连续性) /// [Description("合同行号")] [Nullable(true)] [DataLength(3)] public string OrderSeq { get { return orderSeq; } set { orderSeq = value; } } /// /// 交货编码(ORD_PK向下三位流水号,确保流水号唯一性、连续性) /// [Description("交货编码")] [Nullable(true)] [DataLength(3)] public string DeliveryNo { get { return deliveryNo; } set { deliveryNo = value; } } /// /// 客户合同号 /// [Description("客户合同号")] [Nullable(true)] [DataLength(100)] public string CustmOrderNo { get { return custmOrderNo; } set { custmOrderNo = value; } } /// /// 合同类型 /// [Description("合同类型")] [Nullable(true)] [DataLength(20)] public string OrderTyp { get { return orderTyp; } set { orderTyp = value; } } /// /// 合同类型描述 /// [Description("合同类型描述")] [Nullable(true)] [DataLength(20)] public string OrderTypDesc { get { return orderTypDesc; } set { orderTypDesc = value; } } /// /// 省市/区域代码 /// [Description("省市/区域代码")] [Nullable(true)] [DataLength(40)] public string RegionNo { get { return regionNo; } set { regionNo = value; } } /// /// 省市/区域 /// [Description("省市/区域")] [Nullable(true)] [DataLength(100)] public string RegionName { get { return regionName; } set { regionName = value; } } /// /// 销售组织(国内贸易部/国际贸易部) /// [Description("销售组织")] [Nullable(true)] [DataLength(20)] public string SaleOrg { get { return saleOrg; } set { saleOrg = value; } } /// /// 销售组织描述 /// [Description("销售组织描述")] [Nullable(true)] [DataLength(20)] public string SaleOrgDesc { get { return saleOrgDesc; } set { saleOrgDesc = value; } } /// /// 销售区域编码 /// [Description("销售区域编码")] [Nullable(true)] [DataLength(20)] public string SaleAreaNo { get { return saleAreaNo; } set { saleAreaNo = value; } } /// /// 销售区域描述 /// [Description("销售区域描述")] [Nullable(true)] [DataLength(50)] public string SaleAreaDesc { get { return saleAreaDesc; } set { saleAreaDesc = value; } } /// /// 订货单位代码 /// [Description("订货单位代码")] [Nullable(true)] [DataLength(10)] public string CustomerNo { get { return customerNo; } set { customerNo = value; } } /// /// 订货单位名称 /// [Description("订货单位名称")] [Nullable(true)] [DataLength(128)] public string CustomerNm { get { return customerNm; } set { customerNm = value; } } /// /// 收货单位编码 /// [Description("收货单位编码")] [Nullable(true)] [DataLength(100)] public string ReceivNo { get { return receivNo; } set { receivNo = value; } } /// /// 收货单位名称 /// [Description("收货单位名称")] [Nullable(true)] [DataLength(100)] public string ReceivNm { get { return receivNm; } set { receivNm = value; } } /// /// 计价方式(1203) /// [Description("计价方式")] [Nullable(true)] [DataLength(20)] public string PriceFl { get { return priceFl; } set { priceFl = value; } } /// /// 订货量 /// [Description("订货量")] [Nullable(true)] [DataLength(22)] public decimal? OrderQty { get { return orderQty; } set { orderQty = value; } } /// /// 订货价(结算价) /// [Description("订货价")] [Nullable(true)] [DataLength(22)] public decimal? BalncePrice { get { return balncePrice; } set { balncePrice = value; } } /// /// 币种 /// [Description("币种")] [Nullable(true)] [DataLength(20)] public string Currency { get { return currency; } set { currency = value; } } /// /// 付款方式 /// [Description("付款方式")] [Nullable(true)] [DataLength(20)] public string MnyAskTyp { get { return mnyAskTyp; } set { mnyAskTyp = value; } } /// /// 是否含税 0 否 1 是 /// [Description("是否含税")] [Nullable(true)] [DataLength(1)] public string ContainTax { get { return containTax; } set { containTax = value; } } /// /// 订货计量单位(支、米、吨) /// [Description("订货计量单位")] [Nullable(true)] [DataLength(20)] public string OrderUnit { get { return orderUnit; } set { orderUnit = value; } } /// /// 品名代码 /// [Description("品名代码")] [Nullable(true)] [DataLength(20)] public string Produccode { get { return produccode; } set { produccode = value; } } /// /// 品名描述 /// [Description("品名描述")] [Nullable(true)] [DataLength(100)] public string Producname { get { return producname; } set { producname = value; } } /// /// 标准代码 /// [Description("标准代码")] [Nullable(true)] [DataLength(20)] public string StdCode { get { return stdCode; } set { stdCode = value; } } /// /// 标准名称 /// [Description("标准名称")] [Nullable(true)] [DataLength(200)] public string StdName { get { return stdName; } set { stdName = value; } } /// /// 钢级(牌号)代码 /// [Description("钢级(牌号)代码")] [Nullable(true)] [DataLength(10)] public string Steelcode { get { return steelcode; } set { steelcode = value; } } /// /// 钢级(牌号)名称 /// [Description("钢级(牌号)名称")] [Nullable(true)] [DataLength(100)] public string Steelname { get { return steelname; } set { steelname = value; } } /// /// 标准类别代码 /// [Description("标准类别代码")] [Nullable(true)] [DataLength(20)] public string StdStyle { get { return stdStyle; } set { stdStyle = value; } } /// /// 标准类别描述 /// [Description("标准类别描述")] [Nullable(true)] [DataLength(50)] public string StdStyleDesc { get { return stdStyleDesc; } set { stdStyleDesc = value; } } /// /// 扣型代码 /// [Description("扣型代码")] [Nullable(true)] [DataLength(20)] public string ModelCode { get { return modelCode; } set { modelCode = value; } } /// /// 扣型描述 /// [Description("扣型描述")] [Nullable(true)] [DataLength(100)] public string ModelDesc { get { return modelDesc; } set { modelDesc = value; } } /// /// 订货规格代码(用于合同、质保书、标牌、标识) /// [Description("订货规格代码")] [Nullable(true)] [DataLength(20)] public string OrderSpecCode { get { return orderSpecCode; } set { orderSpecCode = value; } } /// /// 订货规格描述(用于合同、质保书、标牌、标识) /// [Description("订货规格描述")] [Nullable(true)] [DataLength(200)] public string OrderSpecDesc { get { return orderSpecDesc; } set { orderSpecDesc = value; } } /// /// 产品规格代码 /// [Description("产品规格代码")] [Nullable(true)] [DataLength(20)] public string SpecCode { get { return specCode; } set { specCode = value; } } /// /// 产品规格描述 /// [Description("产品规格描述")] [Nullable(true)] [DataLength(100)] public string SpecName { get { return specName; } set { specName = value; } } /// /// 外径(mm) /// [Description("外径(mm)")] [Nullable(true)] [DataLength(6)] public decimal? Dimater { get { return dimater; } set { dimater = value; } } /// /// 壁厚(mm) /// [Description("壁厚(mm)")] [Nullable(true)] [DataLength(6)] public decimal? Height { get { return height; } set { height = value; } } /// /// 长度编码 /// [Description("长度编码")] [Nullable(true)] [DataLength(20)] public string LenNo { get { return lenNo; } set { lenNo = value; } } /// /// 长度描述 /// [Description("长度描述")] [Nullable(true)] [DataLength(200)] public string LenDesc { get { return lenDesc; } set { lenDesc = value; } } /// /// 长度单位 /// [Description("长度单位")] [Nullable(true)] [DataLength(20)] public string LenUnit { get { return lenUnit; } set { lenUnit = value; } } /// /// 外购坯(COM_BASE_INFO:1218) /// [Description("外购坯")] [Nullable(true)] [DataLength(20)] public string OutsBilletFl { get { return outsBilletFl; } set { outsBilletFl = value; } } /// /// 外购管(COM_BASE_INFO:1219) /// [Description("外购管")] [Nullable(true)] [DataLength(20)] public string OutsStlPipeFl { get { return outsStlPipeFl; } set { outsStlPipeFl = value; } } /// /// 付款要求描述 /// [Description("付款要求描述")] [Nullable(true)] [DataLength(200)] public string MnyAskDesc { get { return mnyAskDesc; } set { mnyAskDesc = value; } } /// /// 合同头锁定状态 /// [Description("合同头锁定状态")] [Nullable(true)] [DataLength(1)] public string Islock { get { return islock; } set { islock = value; } } /// /// 监制说明 /// [Description("监制说明")] [Nullable(true)] [DataLength(500)] public string PrdcrDesc { get { return prdcrDesc; } set { prdcrDesc = value; } } /// /// MPS说明 /// [Description("MPS说明")] [Nullable(true)] [DataLength(100)] public string MpsDesc { get { return mpsDesc; } set { mpsDesc = value; } } /// /// 结算单位编码 /// [Description("结算单位编码")] [Nullable(true)] [DataLength(10)] public string StlmtUnitNo { get { return stlmtUnitNo; } set { stlmtUnitNo = value; } } /// /// 结算单位名称 /// [Description("结算单位名称")] [Nullable(true)] [DataLength(128)] public string StlmtUnitNm { get { return stlmtUnitNm; } set { stlmtUnitNm = value; } } /// /// 交货量差方式(绝对值;百分比) /// [Description("交货量差方式")] [Nullable(true)] [DataLength(20)] public string DelvryRangeTpe { get { return delvryRangeTpe; } set { delvryRangeTpe = value; } } /// /// 交货量差下限 /// [Description("交货量差下限")] [Nullable(true)] [DataLength(5)] public decimal? DelvryRangeMin { get { return delvryRangeMin; } set { delvryRangeMin = value; } } /// /// 交货量差上限 /// [Description("交货量差上限")] [Nullable(true)] [DataLength(5)] public decimal? DelvryRangeMax { get { return delvryRangeMax; } set { delvryRangeMax = value; } } /// /// 附加要求编码 /// [Description("附加要求编码")] [Nullable(true)] [DataLength(16)] public string AddAskNo { get { return addAskNo; } set { addAskNo = value; } } /// /// 订货附加要求描述 /// [Description("订货附加要求描述")] [Nullable(true)] [DataLength(4000)] public string OrderAddDesc { get { return orderAddDesc; } set { orderAddDesc = value; } } /// /// 产品特殊要求描述 /// [Description("产品特殊要求描述")] [Nullable(true)] [DataLength(4000)] public string OrderSpecialDesc { get { return orderSpecialDesc; } set { orderSpecialDesc = value; } } /// /// 交货行状态 /// [Description("交货行状态")] [Nullable(true)] [DataLength(20)] public string OrderSts { get { return orderSts; } set { orderSts = value; } } /// /// 交货行状态描述 /// [Description("交货行状态描述")] [Nullable(true)] [DataLength(20)] public string OrderStsDesc { get { return orderStsDesc; } set { orderStsDesc = value; } } /// /// 制造商代码 /// [Description("制造商代码")] [Nullable(true)] [DataLength(20)] public string SupplyUnitCode { get { return supplyUnitCode; } set { supplyUnitCode = value; } } /// /// 制造商 /// [Description("制造商")] [Nullable(true)] [DataLength(20)] public string SupplyUnit { get { return supplyUnit; } set { supplyUnit = value; } } /// /// 重量估算 /// [Description("重量估算")] [Nullable(true)] [DataLength(10)] public decimal? WgtEstmt { get { return wgtEstmt; } set { wgtEstmt = value; } } /// /// 交货结束日期 /// [Description("交货结束日期")] [Nullable(true)] public string DelvryEdate { get { return delvryEdate; } set { delvryEdate = value; } } /// /// 生效时间 /// [Description("生效时间")] [Nullable(true)] public string EffectTime { get { return effectTime; } set { effectTime = value; } } /// /// 提报时间 /// [Description("提报时间")] [Nullable(true)] public string TibaoTime { get { return tibaoTime; } set { tibaoTime = value; } } /// /// CRM是否同步(0 未同步 1已同步) /// [Description("CRM是否同步")] [Nullable(true)] [DataLength(1)] public string IsFlag { get { return isFlag; } set { isFlag = value; } } /// /// 数据类型(0 新增 1修改 2删除) /// [Description("数据类型")] [Nullable(true)] [DataLength(1)] public string DataStatus { get { return dataStatus; } set { dataStatus = value; } } /// /// CRM用于修改的字段 /// [Description("CRM用于修改的字段")] [Nullable(true)] [DataLength(10)] public string CrmFlag { get { return crmFlag; } set { crmFlag = value; } } /// /// CRM同步时间 /// [Description("CRM同步时间")] [Nullable(true)] public string SynchroTime { get { return synchroTime; } set { synchroTime = value; } } /// /// 主键 /// [Description("主键")] [Nullable(false)] [DataLength(40)] public string Id { get { return id; } set { id = value; } } /// /// 创建时间 /// [Description("创建时间")] [Nullable(true)] public string CreateTime { get { return createTime; } set { createTime = value; } } /// /// 合同行状态 /// [Description("合同行状态")] [Nullable(true)] [DataLength(20)] public string OrderLnSts { get { return orderLnSts; } set { orderLnSts = value; } } /// /// 合同行状态描述 /// [Description("合同行状态描述")] [Nullable(true)] [DataLength(20)] public string OrderLnStsDesc { get { return orderLnStsDesc; } set { orderLnStsDesc = value; } } /// /// 合同创建人 /// [Description("合同创建人")] [Nullable(true)] [DataLength(40)] public string CreateName { get { return createName; } set { createName = value; } } private string balncePriceSts; [Description("结算价状态")] public string BalncePriceSts { get { return balncePriceSts; } set { balncePriceSts = value; } } } }