using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.ComponentModel; using Core.Mes.Client.Comm.Attribute; /// /// 数据库表SLM_ORDER_HEAD所对应的实体类(生成工具:代码生成工具3.0) /// 作者:PC9898 时间:2017-02-10 /// public class SlmWellOrderEntity { /// /// ORD_PK /// private string ordPk = ""; /// /// 管理卡号(YY+MM+四位流水号) /// private string managNo = ""; /// /// 合同号(记录创建时如无合同号,形成LS+YYMMDD+三位流水号的临时合同号 /// private string orderNo = ""; /// /// 合同类型 /// private string orderTyp = ""; /// /// 合同类型描述 /// private string orderTypDesc = ""; /// /// 客户编码 /// private string customerNo = ""; /// /// 客户名称 /// private string customerNm = ""; /// /// 简称 /// private string abrvition = ""; /// /// 销售组织(国贸/钢贸/销售公司) /// private string saleOrg = ""; /// /// 销售组织描述 /// private string saleOrgDesc = ""; /// /// 销售区域编码 /// private string saleAreaNo = ""; /// /// 销售区域描述 /// private string saleAreaDesc = ""; /// /// 合同状态 /// private string orderSts = ""; /// /// 合同状态描述 /// private string orderStsDesc = ""; /// /// 创建人 /// private string createName = ""; /// /// 创建时间 /// private string createTime = ""; private string wellUseCode = ""; /// /// ORD_PK /// [Description("ORD_PK")] [Nullable(false)] [DataLength(40)] public string OrdPk { get { return ordPk; } set { ordPk = value; } } /// /// 管理卡号(YY+MM+四位流水号) /// [Description("管理卡号")] [Nullable(true)] [DataLength(20)] public string ManagNo { get { return managNo; } set { managNo = value; } } /// /// 合同号(记录创建时如无合同号,形成LS+YYMMDD+三位流水号的临时合同号 /// [Description("合同号")] [Nullable(true)] [DataLength(20)] public string OrderNo { get { return orderNo; } set { orderNo = 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(10)] public string CustomerNo { get { return customerNo; } set { customerNo = value; } } /// /// 客户名称 /// [Description("客户名称")] [Nullable(true)] [DataLength(60)] public string CustomerNm { get { return customerNm; } set { customerNm = value; } } /// /// 简称 /// [Description("简称")] [Nullable(true)] [DataLength(60)] public string Abrvition { get { return abrvition; } set { abrvition = 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(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 CreateName { get { return createName; } set { createName = value; } } /// /// 创建时间 /// [Description("创建时间")] [Nullable(true)] public string CreateTime { get { return createTime; } set { createTime = value; } } //-------合同行---------------- /// /// ORD_LN_PK(ORD_PK+三位流失号) /// private string ordLnPk = ""; /// /// 合同行号(ORD_PK向下三位流水号,确保流水号的连续性) /// private string orderSeq = ""; /// /// 客户Alpha编号 /// private string custAlphaNo = ""; /// /// 产品规范码 /// private string psc = ""; /// /// 产品规范描述 /// private string pscDesc = ""; /// /// 冶金规范码 /// private string msc = ""; /// /// 冶金规范描述 /// private string mscDesc = ""; /// /// 冶金规范类型(A:钢管+管坯、B:钢管+接箍、C:短节+附件) /// private string mscStyle = ""; /// /// 用途码 /// private string useCode = ""; /// /// 用途码描述 /// private string useDesc = ""; /// /// 品种分类(油井管;专业管;普管) /// private string prdCls = ""; /// /// 品名代码 /// 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 specCode = ""; /// /// 产品规格描述 /// private string specName = ""; /// /// 外径(mm) /// private decimal? dimater = null; /// /// 壁厚(mm) /// private decimal? height = null; /// /// 扣型代码 /// private string modelCode = ""; /// /// 扣型描述 /// private string modelDesc = ""; /// /// 长度单位 /// private string lenUnit = ""; /// /// 下限 /// private decimal? lenMin = null; /// /// 上限 /// private decimal? lenMax = null; /// /// 交货量差 /// private string delvryRange = ""; /// /// 最终用户(来源客户表) /// private string finalUser = ""; /// /// 最终用户描述 /// private string finalUserDesc = ""; /// /// 外购坯(COM_BASE_INFO:1218) /// private string outsBilletFl = ""; /// /// 外购管(COM_BASE_INFO:1219) /// private string outsStlPipeFl = ""; /// /// ASSEL(1:允许;0:不允许) /// private string asselFl = ""; /// /// 监制要求(1:有;0:无) /// private string producerFl = ""; /// /// 监制编号(ORD_LN_PK+三位流水号) /// private string prdcrNo = ""; /// /// 监制说明 /// private string prdcrDesc = ""; /// /// MPS要求(1:有;0无) /// private string mpsFl = ""; /// /// MPS编号 /// private string mpsNo = ""; /// /// MPS说明 /// private string mpsDesc = ""; /// /// 附加要求编码 /// private string addAskNo = ""; /// /// 订货附加要求描述 /// private string orderAddDesc = ""; /// /// 产品特殊要求标识 /// private string orderSpecialFl = ""; /// /// 特殊要求技术规范说明 /// private string orderSpecialHead = ""; /// /// 产品特殊要求描述 /// private string orderSpecialDesc = ""; /// /// 合同行状态 /// private string orderLnStatus = ""; /// /// 客户Alpha编码(Alpha编码生成MSC(n)后,写入的) /// private string custAlphaNo2 = ""; /// /// ASSEL+外购的标识:1.只有ASSEL A 2.外购 W 3.ASSEL+外购 AW 4.什么都没有 为空。 /// private string aw = ""; /// /// ORD_LN_PK(ORD_PK+三位流失号) /// [Description("ORD_LN_PK")] [Nullable(false)] [DataLength(40)] public string OrdLnPk { get { return ordLnPk; } set { ordLnPk = value; } } /// /// 合同行号(ORD_PK向下三位流水号,确保流水号的连续性) /// [Description("合同行号")] [Nullable(false)] [DataLength(3)] public string OrderSeq { get { return orderSeq; } set { orderSeq = value; } } /// /// 客户Alpha编号 /// [Description("客户Alpha编号")] [Nullable(true)] [DataLength(20)] public string CustAlphaNo { get { return custAlphaNo; } set { custAlphaNo = value; } } /// /// 产品规范码 /// [Description("产品规范码")] [Nullable(false)] [DataLength(20)] public string Psc { get { return psc; } set { psc = value; } } /// /// 产品规范描述 /// [Description("产品规范描述")] [Nullable(false)] [DataLength(500)] public string PscDesc { get { return pscDesc; } set { pscDesc = value; } } /// /// 冶金规范码 /// [Description("冶金规范码")] [Nullable(true)] [DataLength(20)] public string Msc { get { return msc; } set { msc = value; } } /// /// 冶金规范描述 /// [Description("冶金规范描述")] [Nullable(true)] [DataLength(500)] public string MscDesc { get { return mscDesc; } set { mscDesc = value; } } /// /// 冶金规范类型(A:钢管+管坯、B:钢管+接箍、C:短节+附件) /// [Description("冶金规范类型")] [Nullable(true)] [DataLength(1)] public string MscStyle { get { return mscStyle; } set { mscStyle = value; } } /// /// 用途码 /// [Description("用途码")] [Nullable(true)] [DataLength(20)] public string UseCode { get { return useCode; } set { useCode = value; } } /// /// 用途码描述 /// [Description("用途码描述")] [Nullable(true)] [DataLength(200)] public string UseDesc { get { return useDesc; } set { useDesc = value; } } /// /// 品种分类(油井管;专业管;普管) /// [Description("品种分类")] [Nullable(true)] [DataLength(20)] public string PrdCls { get { return prdCls; } set { prdCls = value; } } /// /// 品名代码 /// [Description("品名代码")] [Nullable(false)] [DataLength(20)] public string Produccode { get { return produccode; } set { produccode = value; } } /// /// 品名描述 /// [Description("品名")] [Nullable(false)] [DataLength(100)] public string Producname { get { return producname; } set { producname = value; } } /// /// 标准代码 /// [Description("标准代码")] [Nullable(false)] [DataLength(20)] public string StdCode { get { return stdCode; } set { stdCode = value; } } /// /// 标准名称 /// [Description("标准")] [Nullable(false)] [DataLength(200)] public string StdName { get { return stdName; } set { stdName = value; } } /// /// 钢级(牌号)代码 /// [Description("钢级代码")] [Nullable(false)] [DataLength(10)] public string Steelcode { get { return steelcode; } set { steelcode = value; } } /// /// 钢级(牌号)名称 /// [Description("钢级")] [Nullable(false)] [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(false)] [DataLength(20)] public string SpecCode { get { return specCode; } set { specCode = value; } } /// /// 产品规格描述 /// [Description("产品规格")] [Nullable(false)] [DataLength(100)] public string SpecName { get { return specName; } set { specName = value; } } /// /// 外径(mm) /// [Description("外径(mm)")] [Nullable(false)] [DataLength(6)] public decimal? Dimater { get { return dimater; } set { dimater = value; } } /// /// 壁厚(mm) /// [Description("壁厚(mm)")] [Nullable(false)] [DataLength(6)] public decimal? Height { get { return height; } set { height = 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 LenUnit { get { return lenUnit; } set { lenUnit = value; } } /// /// 下限 /// [Description("下限")] [Nullable(true)] [DataLength(6)] public decimal? LenMin { get { return lenMin; } set { lenMin = value; } } /// /// 上限 /// [Description("上限")] [Nullable(true)] [DataLength(6)] public decimal? LenMax { get { return lenMax; } set { lenMax = value; } } /// /// 交货量差 /// [Description("交货量差")] [Nullable(true)] [DataLength(22)] public string DelvryRange { get { return delvryRange; } set { delvryRange = value; } } /// /// 最终用户(来源客户表) /// [Description("最终用户代码")] [Nullable(false)] [DataLength(20)] public string FinalUser { get { return finalUser; } set { finalUser = value; } } /// /// 最终用户描述 /// [Description("最终用户")] [Nullable(false)] [DataLength(100)] public string FinalUserDesc { get { return finalUserDesc; } set { finalUserDesc = 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; } } /// /// ASSEL(1:允许;0:不允许) /// [Description("ASSEL")] [Nullable(true)] [DataLength(1)] public string AsselFl { get { return asselFl; } set { asselFl = value; } } /// /// 监制要求(1:有;0:无) /// [Description("监制要求")] [Nullable(true)] [DataLength(1)] public string ProducerFl { get { return producerFl; } set { producerFl = value; } } /// /// 监制编号(ORD_LN_PK+三位流水号) /// [Description("监制编号")] [Nullable(true)] [DataLength(400)] public string PrdcrNo { get { return prdcrNo; } set { prdcrNo = value; } } /// /// 监制说明 /// [Description("监制说明")] [Nullable(true)] [DataLength(500)] public string PrdcrDesc { get { return prdcrDesc; } set { prdcrDesc = value; } } /// /// MPS要求(1:有;0无) /// [Description("MPS要求")] [Nullable(true)] [DataLength(1)] public string MpsFl { get { return mpsFl; } set { mpsFl = value; } } /// /// MPS编号 /// [Description("MPS编号")] [Nullable(true)] [DataLength(40)] public string MpsNo { get { return mpsNo; } set { mpsNo = value; } } /// /// MPS说明 /// [Description("MPS说明")] [Nullable(true)] [DataLength(100)] public string MpsDesc { get { return mpsDesc; } set { mpsDesc = 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(1)] public string OrderSpecialFl { get { return orderSpecialFl; } set { orderSpecialFl = value; } } /// /// 特殊要求技术规范说明 /// [Description("特殊要求技术规范说明")] [Nullable(true)] [DataLength(100)] public string OrderSpecialHead { get { return orderSpecialHead; } set { orderSpecialHead = value; } } /// /// 产品特殊要求描述 /// [Description("产品特殊要求描述")] [Nullable(true)] [DataLength(4000)] public string OrderSpecialDesc { get { return orderSpecialDesc; } set { orderSpecialDesc = value; } } /// /// 合同行状态 /// [Description("合同行状态")] [Nullable(true)] [DataLength(20)] public string OrderLnStatus { get { return orderLnStatus; } set { orderLnStatus = value; } } /// /// 客户Alpha编码(Alpha编码生成MSC(n)后,写入的) /// [Description("客户Alpha编码")] [Nullable(true)] [DataLength(20)] public string CustAlphaNo2 { get { return custAlphaNo2; } set { custAlphaNo2 = value; } } /// /// ASSEL+外购的标识:1.只有ASSEL A 2.外购 W 3.ASSEL+外购 AW 4.什么都没有 为空。 /// [Description("AW")] [Nullable(true)] [DataLength(2)] public string Aw { get { return aw; } set { aw = value; } } //-----交货行-------------- /// /// ORD_LN_DLY_PK(ORD_LN_PK+三位流水号) /// private string ordLnDlyPk = ""; /// /// 交货编码(ORD_PK向下三位流水号,确保流水号唯一性、连续性) /// private string deliveryNo = ""; /// /// 交货结束日期/最迟交货日期 /// private string delvryEdate = ""; /// /// 订货量 /// private decimal? delvryQty = null; /// /// 计量单位 /// private string orderUnit = ""; /// /// 估算重量 /// private decimal? wgtEstmt = null; /// /// 保总长 /// private decimal? ensuTotlLen = null; /// /// 交货行状态 /// private string deliveryStatus = ""; /// /// 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; } } /// /// 交货编码(ORD_PK向下三位流水号,确保流水号唯一性、连续性) /// [Description("交货编码")] [Nullable(false)] [DataLength(3)] public string DeliveryNo { get { return deliveryNo; } set { deliveryNo = value; } } /// /// 交货结束日期/最迟交货日期 /// [Description("交货日期")] [Nullable(false)] public string DelvryEdate { get { return delvryEdate; } set { delvryEdate = value; } } /// /// 订货量 /// [Description("订货量")] [Nullable(false)] [DataLength(22)] public decimal? DelvryQty { get { return delvryQty; } set { delvryQty = value; } } /// ///计量单位 /// [Description("计量单位")] [Nullable(true)] [DataLength(20)] public string OrderUnit { get { return orderUnit; } set { orderUnit = value; } } /// /// 估算重量 /// [Description("估算重量")] [Nullable(true)] [DataLength(10)] public decimal? WgtEstmt { get { return wgtEstmt; } set { wgtEstmt = value; } } /// /// 保总长 /// [Description("保总长")] [Nullable(true)] [DataLength(10)] public decimal? EnsuTotlLen { get { return ensuTotlLen; } set { ensuTotlLen = value; } } /// /// 交货行状态 /// [Description("交货行状态")] [Nullable(true)] [DataLength(20)] public string DeliveryStatus { get { return deliveryStatus; } set { deliveryStatus = value; } } /// /// 产能井耗用编号 /// [Description("产能井耗用编号")] public string WellUseCode { get { return wellUseCode; } set { wellUseCode = value; } } }