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; }
}
}