| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939 |
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Linq;
- using System.Text;
- using Core.Mes.Client.Comm.Attribute;
- namespace Core.StlMes.Client.PlnSaleOrd.Entity
- {
- /// <summary>
- /// 数据库表PLN_ORDER_ZG所对应的实体类(生成工具:代码生成工具3.0)
- /// 作者:USER-20150714WV 时间:2015-11-16
- /// </summary>
- public class PlnOrderZgEntity
- {
- /// <summary>
- /// 轧管合同编号
- /// </summary>
- private string proOrderNo = "";
- /// <summary>
- /// 排产联动组号
- /// </summary>
- private string planGroupId = "";
- /// <summary>
- /// 合同来源(销售合同、备料需求、补量需求)
- /// </summary>
- private string orderSource = "";
- /// <summary>
- /// 交货编码PK
- /// </summary>
- private string ordLnDlyPk = "";
- /// <summary>
- /// 排产流水号
- /// </summary>
- private string plnDivideId = "";
- /// <summary>
- /// 合同号
- /// </summary>
- private string orderNo = "";
- /// <summary>
- /// 合同行号
- /// </summary>
- private string orderSeq = "";
- /// <summary>
- /// 交货编码
- /// </summary>
- private string deliveryNo = "";
- /// <summary>
- /// 备料需求号
- /// </summary>
- private string reqBlId = "";
- /// <summary>
- /// 制程索引号
- /// </summary>
- private string indexSeq = "";
- /// <summary>
- /// BOM
- /// </summary>
- private string bom = "";
- /// <summary>
- /// 全程工序顺序号(COM_MSC_PROCESS)
- /// </summary>
- private decimal? backlogSeq = null;
- /// <summary>
- /// 钢级(牌号)代码
- /// </summary>
- private string steelcode = "";
- /// <summary>
- /// 钢级(牌号)名称
- /// </summary>
- private string steelname = "";
- /// <summary>
- /// 外径
- /// </summary>
- private decimal? outdiameter = null;
- /// <summary>
- /// 壁厚
- /// </summary>
- private decimal? wallthick = null;
- /// <summary>
- /// 控制壁厚
- /// </summary>
- private decimal? aimwallthick = null;
- /// <summary>
- /// 最大长度
- /// </summary>
- private decimal? lengthmax = null;
- /// <summary>
- /// 最小长度
- /// </summary>
- private decimal? lengthmin = null;
- /// <summary>
- /// 控制长度
- /// </summary>
- private decimal? aimlength = null;
- /// <summary>
- /// 工序产出物料编码
- /// </summary>
- private string outwlId = "";
- /// <summary>
- /// 轧制长度
- /// </summary>
- private decimal? rollLength = null;
- /// <summary>
- /// 产出长度
- /// </summary>
- private decimal? outLength = null;
- /// <summary>
- /// 单坯产出支数
- /// </summary>
- private decimal? outnumSingle = null;
- /// <summary>
- /// 管坯直径
- /// </summary>
- private decimal? diameterGp = null;
- /// <summary>
- /// 管坯长度
- /// </summary>
- private decimal? lengthGp = null;
- /// <summary>
- /// 投入管坯编码
- /// </summary>
- private string inwlGp = "";
- /// <summary>
- /// 管坯单重
- /// </summary>
- private decimal? weightGpOne = null;
- /// <summary>
- /// 成材率
- /// </summary>
- private decimal? getrate = null;
- /// <summary>
- /// 可选产线编码
- /// </summary>
- private string plineCodeMay = "";
- /// <summary>
- /// 可选产线描述
- /// </summary>
- private string plineNameMay = "";
- /// <summary>
- /// 轧管产线代码
- /// </summary>
- private string plineCode = "";
- /// <summary>
- /// 轧管产线描述
- /// </summary>
- private string plineName = "";
- /// <summary>
- /// 合同重量
- /// </summary>
- private decimal? orderweight = null;
- /// <summary>
- /// 合同支数
- /// </summary>
- private decimal? ordernum = null;
- /// <summary>
- /// 利库量
- /// </summary>
- private decimal? matchWt = null;
- /// <summary>
- /// 利库支数
- /// </summary>
- private decimal? matchNum = null;
- /// <summary>
- /// 有无外购计划
- /// </summary>
- private string ifbuyplan = "";
- /// <summary>
- /// 外购计划号
- /// </summary>
- private string buyplanid = "";
- /// <summary>
- /// 外购计划量
- /// </summary>
- private decimal? buyplanWt = null;
- /// <summary>
- /// 待生产量(订单量-利库-外购)
- /// </summary>
- private decimal? reqProdWt = null;
- /// <summary>
- /// 待生产支数
- /// </summary>
- private decimal? reqProdNum = null;
- /// <summary>
- /// 最晚完成日期
- /// </summary>
- private string prodEndDate = "";
- /// <summary>
- /// 工序合同状态(1计划,2排产,3生产中,4生产完成,5合同关闭,6合同取消,9封闭)
- /// </summary>
- private string orderstatus = "";
- /// <summary>
- /// 是否已排工序订单
- /// </summary>
- private string isPlaned = "";
- /// <summary>
- /// 轧管订单编号
- /// </summary>
- private string proPlanId = "";
- /// <summary>
- /// 生产完成重量
- /// </summary>
- private decimal? finishweight = null;
- /// <summary>
- /// 是否末端工序
- /// </summary>
- private string isendgx = "";
- /// <summary>
- /// 下一工序
- /// </summary>
- private string nextGx = "";
- /// <summary>
- /// 是否工序补量合同(末工序不能为1)
- /// </summary>
- private string isExtraOrd = "";
- /// <summary>
- /// 是否轧管监制
- /// </summary>
- private string ifMonitorZg = "";
- /// <summary>
- /// 监制编号
- /// </summary>
- private string prdcrNo = "";
- /// <summary>
- /// 工艺文件号
- /// </summary>
- private string craftFileNo = "";
- /// <summary>
- /// 工艺文件责任人
- /// </summary>
- private string craftFileMan = "";
- /// <summary>
- /// 创建人
- /// </summary>
- private string createName = "";
- /// <summary>
- /// 创建时间
- /// </summary>
- private string createTime = "";
- /// <summary>
- /// 修改人
- /// </summary>
- private string updateName = "";
- /// <summary>
- /// 修改时间
- /// </summary>
- private string updateTime = "";
- /// <summary>
- /// 轧管合同编号
- /// </summary>
- [Description("轧管合同编号")]
- [Nullable(false)]
- [DataLength(20)]
- public string ProOrderNo
- {
- get { return proOrderNo; }
- set { proOrderNo = value; }
- }
- /// <summary>
- /// 排产联动组号
- /// </summary>
- [Description("排产联动组号")]
- [Nullable(true)]
- [DataLength(40)]
- public string PlanGroupId
- {
- get { return planGroupId; }
- set { planGroupId = value; }
- }
- /// <summary>
- /// 合同来源(销售合同、备料需求、补量需求)
- /// </summary>
- [Description("合同来源")]
- [Nullable(true)]
- [DataLength(20)]
- public string OrderSource
- {
- get { return orderSource; }
- set { orderSource = value; }
- }
- /// <summary>
- /// 交货编码PK
- /// </summary>
- [Description("交货编码PK")]
- [Nullable(false)]
- [DataLength(40)]
- public string OrdLnDlyPk
- {
- get { return ordLnDlyPk; }
- set { ordLnDlyPk = value; }
- }
- /// <summary>
- /// 排产流水号
- /// </summary>
- [Description("排产流水号")]
- [Nullable(false)]
- [DataLength(10)]
- public string PlnDivideId
- {
- get { return plnDivideId; }
- set { plnDivideId = value; }
- }
- /// <summary>
- /// 合同号
- /// </summary>
- [Description("合同号")]
- [Nullable(true)]
- [DataLength(20)]
- public string OrderNo
- {
- get { return orderNo; }
- set { orderNo = value; }
- }
- /// <summary>
- /// 合同行号
- /// </summary>
- [Description("合同行号")]
- [Nullable(true)]
- [DataLength(3)]
- public string OrderSeq
- {
- get { return orderSeq; }
- set { orderSeq = value; }
- }
- /// <summary>
- /// 交货编码
- /// </summary>
- [Description("交货行号")]
- [Nullable(true)]
- [DataLength(3)]
- public string DeliveryNo
- {
- get { return deliveryNo; }
- set { deliveryNo = value; }
- }
- /// <summary>
- /// 备料需求号
- /// </summary>
- [Description("备料需求号")]
- [Nullable(true)]
- [DataLength(20)]
- public string ReqBlId
- {
- get { return reqBlId; }
- set { reqBlId = value; }
- }
- /// <summary>
- /// 制程索引号
- /// </summary>
- [Description("制程索引号")]
- [Nullable(true)]
- [DataLength(32)]
- public string IndexSeq
- {
- get { return indexSeq; }
- set { indexSeq = value; }
- }
- /// <summary>
- /// BOM
- /// </summary>
- [Description("BOM")]
- [Nullable(true)]
- [DataLength(40)]
- public string Bom
- {
- get { return bom; }
- set { bom = value; }
- }
- /// <summary>
- /// 全程工序顺序号(COM_MSC_PROCESS)
- /// </summary>
- [Description("全程工序顺序号")]
- [Nullable(true)]
- [DataLength(22)]
- public decimal? BacklogSeq
- {
- get { return backlogSeq; }
- set { backlogSeq = 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(10)]
- public decimal? Outdiameter
- {
- get { return outdiameter; }
- set { outdiameter = value; }
- }
- /// <summary>
- /// 壁厚
- /// </summary>
- [Description("壁厚")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? Wallthick
- {
- get { return wallthick; }
- set { wallthick = value; }
- }
- /// <summary>
- /// 控制壁厚
- /// </summary>
- [Description("控制壁厚")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? Aimwallthick
- {
- get { return aimwallthick; }
- set { aimwallthick = value; }
- }
- /// <summary>
- /// 最大长度
- /// </summary>
- [Description("最大长度")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? Lengthmax
- {
- get { return lengthmax; }
- set { lengthmax = value; }
- }
- /// <summary>
- /// 最小长度
- /// </summary>
- [Description("最小长度")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? Lengthmin
- {
- get { return lengthmin; }
- set { lengthmin = value; }
- }
- /// <summary>
- /// 控制长度
- /// </summary>
- [Description("控制长度")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? Aimlength
- {
- get { return aimlength; }
- set { aimlength = value; }
- }
- /// <summary>
- /// 工序产出物料编码
- /// </summary>
- [Description("工序产出物料编码")]
- [Nullable(true)]
- [DataLength(40)]
- public string OutwlId
- {
- get { return outwlId; }
- set { outwlId = value; }
- }
- /// <summary>
- /// 轧制长度
- /// </summary>
- [Description("轧制长度")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? RollLength
- {
- get { return rollLength; }
- set { rollLength = value; }
- }
- /// <summary>
- /// 产出长度
- /// </summary>
- [Description("产出长度")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? OutLength
- {
- get { return outLength; }
- set { outLength = value; }
- }
- /// <summary>
- /// 单坯产出支数
- /// </summary>
- [Description("单坯产出支数")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? OutnumSingle
- {
- get { return outnumSingle; }
- set { outnumSingle = value; }
- }
- /// <summary>
- /// 管坯直径
- /// </summary>
- [Description("管坯直径")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? DiameterGp
- {
- get { return diameterGp; }
- set { diameterGp = value; }
- }
- /// <summary>
- /// 管坯长度
- /// </summary>
- [Description("管坯长度")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? LengthGp
- {
- get { return lengthGp; }
- set { lengthGp = value; }
- }
- /// <summary>
- /// 投入管坯编码
- /// </summary>
- [Description("投入管坯编码")]
- [Nullable(true)]
- [DataLength(40)]
- public string InwlGp
- {
- get { return inwlGp; }
- set { inwlGp = value; }
- }
- /// <summary>
- /// 管坯单重
- /// </summary>
- [Description("管坯单重")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? WeightGpOne
- {
- get { return weightGpOne; }
- set { weightGpOne = value; }
- }
- /// <summary>
- /// 成材率
- /// </summary>
- [Description("成材率")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? Getrate
- {
- get { return getrate; }
- set { getrate = value; }
- }
- /// <summary>
- /// 可选产线编码
- /// </summary>
- [Description("可选产线编码")]
- [Nullable(true)]
- [DataLength(100)]
- public string PlineCodeMay
- {
- get { return plineCodeMay; }
- set { plineCodeMay = value; }
- }
- /// <summary>
- /// 可选产线描述
- /// </summary>
- [Description("可选产线描述")]
- [Nullable(true)]
- [DataLength(400)]
- public string PlineNameMay
- {
- get { return plineNameMay; }
- set { plineNameMay = value; }
- }
- /// <summary>
- /// 轧管产线代码
- /// </summary>
- [Description("轧管产线代码")]
- [Nullable(true)]
- [DataLength(20)]
- public string PlineCode
- {
- get { return plineCode; }
- set { plineCode = value; }
- }
- /// <summary>
- /// 轧管产线描述
- /// </summary>
- [Description("轧管产线描述")]
- [Nullable(true)]
- [DataLength(100)]
- public string PlineName
- {
- get { return plineName; }
- set { plineName = value; }
- }
- /// <summary>
- /// 合同重量
- /// </summary>
- [Description("合同重量")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? Orderweight
- {
- get { return orderweight; }
- set { orderweight = value; }
- }
- /// <summary>
- /// 合同支数
- /// </summary>
- [Description("合同支数")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? Ordernum
- {
- get { return ordernum; }
- set { ordernum = value; }
- }
- /// <summary>
- /// 利库量
- /// </summary>
- [Description("利库量")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? MatchWt
- {
- get { return matchWt; }
- set { matchWt = value; }
- }
- /// <summary>
- /// 利库支数
- /// </summary>
- [Description("利库支数")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? MatchNum
- {
- get { return matchNum; }
- set { matchNum = value; }
- }
- /// <summary>
- /// 有无外购计划
- /// </summary>
- [Description("有无外购计划")]
- [Nullable(true)]
- [DataLength(1)]
- public string Ifbuyplan
- {
- get { return ifbuyplan; }
- set { ifbuyplan = value; }
- }
- /// <summary>
- /// 外购计划号
- /// </summary>
- [Description("外购计划号")]
- [Nullable(true)]
- [DataLength(20)]
- public string Buyplanid
- {
- get { return buyplanid; }
- set { buyplanid = value; }
- }
- /// <summary>
- /// 外购计划量
- /// </summary>
- [Description("外购计划量")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? BuyplanWt
- {
- get { return buyplanWt; }
- set { buyplanWt = value; }
- }
- /// <summary>
- /// 待生产量(订单量-利库-外购)
- /// </summary>
- [Description("待生产量")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? ReqProdWt
- {
- get { return reqProdWt; }
- set { reqProdWt = value; }
- }
- /// <summary>
- /// 待生产支数
- /// </summary>
- [Description("待生产支数")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? ReqProdNum
- {
- get { return reqProdNum; }
- set { reqProdNum = value; }
- }
- /// <summary>
- /// 最晚完成日期
- /// </summary>
- [Description("最晚完成日期")]
- public string ProdEndDate
- {
- get { return prodEndDate; }
- set { prodEndDate = value; }
- }
- /// <summary>
- /// 工序合同状态(1计划,2排产,3生产中,4生产完成,5合同关闭,6合同取消,9封闭)
- /// </summary>
- [Description("工序合同状态")]
- [Nullable(true)]
- [DataLength(20)]
- public string Orderstatus
- {
- get { return orderstatus; }
- set { orderstatus = value; }
- }
- /// <summary>
- /// 是否已排工序订单
- /// </summary>
- [Description("是否已排工序订单")]
- [Nullable(true)]
- [DataLength(10)]
- public string IsPlaned
- {
- get { return isPlaned; }
- set { isPlaned = value; }
- }
- /// <summary>
- /// 轧管订单编号
- /// </summary>
- [Description("轧管订单编号")]
- [Nullable(true)]
- [DataLength(20)]
- public string ProPlanId
- {
- get { return proPlanId; }
- set { proPlanId = value; }
- }
- /// <summary>
- /// 生产完成重量
- /// </summary>
- [Description("生产完成重量")]
- [Nullable(true)]
- [DataLength(10)]
- public decimal? Finishweight
- {
- get { return finishweight; }
- set { finishweight = value; }
- }
- /// <summary>
- /// 是否末端工序
- /// </summary>
- [Description("是否末端工序")]
- [Nullable(true)]
- [DataLength(1)]
- public string Isendgx
- {
- get { return isendgx; }
- set { isendgx = value; }
- }
- /// <summary>
- /// 下一工序
- /// </summary>
- [Description("下一工序")]
- [Nullable(true)]
- [DataLength(20)]
- public string NextGx
- {
- get { return nextGx; }
- set { nextGx = value; }
- }
- /// <summary>
- /// 是否工序补量合同(末工序不能为1)
- /// </summary>
- [Description("是否工序补量合同")]
- [Nullable(true)]
- [DataLength(1)]
- public string IsExtraOrd
- {
- get { return isExtraOrd; }
- set { isExtraOrd = value; }
- }
- /// <summary>
- /// 是否轧管监制
- /// </summary>
- [Description("是否轧管监制")]
- [Nullable(true)]
- [DataLength(1)]
- public string IfMonitorZg
- {
- get { return ifMonitorZg; }
- set { ifMonitorZg = value; }
- }
- /// <summary>
- /// 监制编号
- /// </summary>
- [Description("监制编号")]
- [Nullable(true)]
- [DataLength(40)]
- public string PrdcrNo
- {
- get { return prdcrNo; }
- set { prdcrNo = value; }
- }
- /// <summary>
- /// 工艺文件号
- /// </summary>
- [Description("工艺文件号")]
- [Nullable(true)]
- [DataLength(40)]
- public string CraftFileNo
- {
- get { return craftFileNo; }
- set { craftFileNo = value; }
- }
- /// <summary>
- /// 工艺文件责任人
- /// </summary>
- [Description("工艺文件责任人")]
- [Nullable(true)]
- [DataLength(20)]
- public string CraftFileMan
- {
- get { return craftFileMan; }
- set { craftFileMan = value; }
- }
- /// <summary>
- /// 创建人
- /// </summary>
- [Description("创建人")]
- [Nullable(true)]
- [DataLength(20)]
- public string CreateName
- {
- get { return createName; }
- set { createName = value; }
- }
- /// <summary>
- /// 创建时间
- /// </summary>
- [Description("创建时间")]
- 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("修改时间")]
- public string UpdateTime
- {
- get { return updateTime; }
- set { updateTime = value; }
- }
- }
- }
|