| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924 |
- 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.Mcp.VRP.Entity
- {
- /// <summary>
- /// 数据库表VRP_OFFLINE_RESULT所对应的实体类(生成工具:代码生成工具3.0)
- /// 作者:DM22222 时间:2016-09-28
- /// </summary>
- public class VrpOfflineResultEntity
- {
- /// <summary>
- /// 实绩编号(机组+工序点代码+年月日+6位流水)
- /// </summary>
- private string resultNo = "";
- /// <summary>
- /// 产线代码
- /// </summary>
- private string plineCode = "";
- /// <summary>
- /// 产线描述
- /// </summary>
- private string plineName = "";
- /// <summary>
- /// 工序点代码(上料。。。。)
- /// </summary>
- private string stationCode = "";
- /// <summary>
- /// 工序点名称
- /// </summary>
- private string stationDesc = "";
- /// <summary>
- /// 炉批计划ID
- /// </summary>
- private string heatPlanNo = "";
- /// <summary>
- /// 镦拔扩作业批次号
- /// </summary>
- private string zyBatchId = "";
- /// <summary>
- /// 镦拔扩订单编号
- /// </summary>
- private string proPlanId = "";
- /// <summary>
- /// 镦拔扩订单排产序号
- /// </summary>
- private string gxPlanNo = "";
- /// <summary>
- /// 判定炉号
- /// </summary>
- private string judgeStoveNo = "";
- /// <summary>
- /// 批号(炉批号)
- /// </summary>
- private string batchNo = "";
- /// <summary>
- /// 品名代码
- /// </summary>
- private string produccode = "";
- /// <summary>
- /// 品名描述
- /// </summary>
- private string producname = "";
- /// <summary>
- /// 钢级(牌号)代码
- /// </summary>
- private string steelcode = "";
- /// <summary>
- /// 钢级(牌号)名称
- /// </summary>
- private string steelname = "";
- /// <summary>
- /// 钢种代码
- /// </summary>
- private string gradecode = "";
- /// <summary>
- /// 钢种名称
- /// </summary>
- private string gradename = "";
- /// <summary>
- /// 扣型代码
- /// </summary>
- private string modelCode = "";
- /// <summary>
- /// 扣型描述
- /// </summary>
- private string modelDesc = "";
- /// <summary>
- /// 标准代码
- /// </summary>
- private string stdCode = "";
- /// <summary>
- /// 标准名称
- /// </summary>
- private string stdName = "";
- /// <summary>
- /// 标准类别代码
- /// </summary>
- private string stdStyle = "";
- /// <summary>
- /// 标准类别描述(PSL1....)
- /// </summary>
- private string stdStyleDesc = "";
- /// <summary>
- /// 外径(实际)
- /// </summary>
- private decimal? actDimater = null;
- /// <summary>
- /// 壁厚(实际)
- /// </summary>
- private decimal? actHeight = null;
- /// <summary>
- /// 长度(实际)
- /// </summary>
- private decimal? actLen = null;
- /// <summary>
- /// 长度下限(实际)
- /// </summary>
- private string actLenMin = "";
- /// <summary>
- /// 长度上限(实际)
- /// </summary>
- private string actLenMax = "";
- /// <summary>
- /// 组炉主炉号
- /// </summary>
- private string zpJudgeStoveNo = "";
- /// <summary>
- /// 组炉主批号
- /// </summary>
- private string zpBatchNo = "";
- /// <summary>
- /// 离线支数
- /// </summary>
- private decimal? offlineNum = null;
- /// <summary>
- /// 离线重量
- /// </summary>
- private decimal? offlineWt = null;
- /// <summary>
- /// 返线支数
- /// </summary>
- private decimal? reNum = null;
- /// <summary>
- /// 返线重量
- /// </summary>
- private decimal? reWt = null;
- /// <summary>
- /// 组炉支数
- /// </summary>
- private decimal? groupNum = null;
- /// <summary>
- /// 组炉重量
- /// </summary>
- private decimal? groupWt = null;
- /// 委外支数
- /// </summary>
- private decimal? subcontractNum = null;
- /// 委外重量
- /// </summary>
- private decimal? subcontractWt = null;
- /// <summary>
- /// 委外回报支数
- /// </summary>
- private decimal? subcontractcompleteNum = null;
- /// <summary>
- /// 委外回报重量
- /// </summary>
- private decimal? subcontractcompleteWt = null;
- /// <summary>
- /// 委外单号
- /// </summary>
- private string subcontractNo = "";
- /// <summary>
- /// 委外单号序号
- /// </summary>
- private string subcontractNoSeq = "";
- /// <summary>
- /// 作业日期(年月日)
- /// </summary>
- private string proYearMonthDay = "";
- /// <summary>
- /// 操作人
- /// </summary>
- private string proUser = "";
- /// <summary>
- /// 操作班次
- /// </summary>
- private string proShift = "";
- /// <summary>
- /// 操作班组
- /// </summary>
- private string proGroup = "";
- /// <summary>
- /// 操作时间
- /// </summary>
- private string proTime = "";
- private string memo = "";
- [Description("备注")]
- public string Memo
- {
- get { return memo; }
- set { memo = value; }
- }
- private string flag = "";
- [Description("撤销标记")]
- public string Flag
- {
- get { return flag; }
- set { flag = value; }
- }
- private string flagStoveNo = "";
- [Description("标识炉号")]
- public string FlagStoveNo
- {
- get { return flagStoveNo; }
- set { flagStoveNo = value; }
- }
- private string batchGroudNo = "";
- [Description("组号")]
- public string BatchGroudNo
- {
- get { return batchGroudNo; }
- set { batchGroudNo = value; }
- }
- private string zyBatchId1;
- [Description("原炉计划号")]
- public string ZyBatchId1
- {
- get { return zyBatchId1; }
- set { zyBatchId1 = value; }
- }
- /// <summary>
- /// 组炉标记(1组炉生成的)
- /// </summary>
- private string groupLog = "";
- [Description("委外重量")]
- public decimal? SubcontractWt
- {
- get { return subcontractWt; }
- set { subcontractWt = value; }
- }
-
- private string returnProcess = "";
- [Description("返线工序点")]
- public string ReturnProcess
- {
- get { return returnProcess; }
- set { returnProcess = value; }
- }
- private decimal? offlineBranch = null;
- [Description("离线编辑支")]
- public decimal? OfflineBranch
- {
- get { return offlineBranch; }
- set { offlineBranch = value; }
- }
- private decimal? totalcount = null;
- [Description("离线剩余支")]
- public decimal? Totalcount
- {
- get { return totalcount; }
- set { totalcount = value; }
- }
- private string processOrder;
- [Description("工序合同号")]
- public string ProcessOrder
- {
- get { return processOrder; }
- set { processOrder = value; }
- }
- private string orderNo;
- [Description("合同号")]
- public string OrderNo
- {
- get { return orderNo; }
- set { orderNo = value; }
- }
- private string orderSeq;
- [Description("合同行号")]
- public string OrderSeq
- {
- get { return orderSeq; }
- set { orderSeq = value; }
- }
- private string deliveryNo;
- [Description("交货行号")]
- public string DeliveryNo
- {
- get { return deliveryNo; }
- set { deliveryNo = value; }
- }
- private string ordLnDlyPk;
- [Description("交货行PK")]
- public string OrdLnDlyPk
- {
- get { return ordLnDlyPk; }
- set { ordLnDlyPk = value; }
- }
- private string groupId;
- [Description("组炉操作ID")]
- public string GroupId
- {
- get { return groupId; }
- set { groupId = value; }
- }
- /// <summary>
- /// 实绩编号(机组+工序点代码+年月日+6位流水)
- /// </summary>
- [Description("实绩编号")]
- [Nullable(false)]
- [DataLength(22)]
- public string ResultNo
- {
- get { return resultNo; }
- set { resultNo = value; }
- }
- /// <summary>
- /// 产线代码
- /// </summary>
- [Description("产线代码")]
- [Nullable(true)]
- [DataLength(20)]
- public string PlineCode
- {
- get { return plineCode; }
- set { plineCode = value; }
- }
- /// <summary>
- /// 产线描述
- /// </summary>
- [Description("产线描述")]
- [Nullable(true)]
- [DataLength(40)]
- public string PlineName
- {
- get { return plineName; }
- set { plineName = value; }
- }
- /// <summary>
- /// 工序点代码(上料。。。。)
- /// </summary>
- [Description("工序点代码(上料。。。。)")]
- [Nullable(true)]
- [DataLength(20)]
- public string StationCode
- {
- get { return stationCode; }
- set { stationCode = value; }
- }
- /// <summary>
- /// 工序点名称
- /// </summary>
- [Description("工序点")]
- [Nullable(true)]
- [DataLength(40)]
- public string StationDesc
- {
- get { return stationDesc; }
- set { stationDesc = value; }
- }
- /// <summary>
- /// 炉批计划ID
- /// </summary>
- [Description("炉批计划ID")]
- [Nullable(true)]
- [DataLength(20)]
- public string HeatPlanNo
- {
- get { return heatPlanNo; }
- set { heatPlanNo = value; }
- }
- /// <summary>
- /// 镦拔扩作业批次号
- /// </summary>
- [Description("生产批号")]
- [Nullable(true)]
- [DataLength(20)]
- public string ZyBatchId
- {
- get { return zyBatchId; }
- set { zyBatchId = 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 string GxPlanNo
- {
- get { return gxPlanNo; }
- set { gxPlanNo = value; }
- }
- /// <summary>
- /// 判定炉号
- /// </summary>
- [Description("炉号")]
- [Nullable(true)]
- [DataLength(6)]
- public string JudgeStoveNo
- {
- get { return judgeStoveNo; }
- set { judgeStoveNo = value; }
- }
- /// <summary>
- /// 批号(炉批号)
- /// </summary>
- [Description("批号")]
- [Nullable(true)]
- [DataLength(10)]
- public string BatchNo
- {
- get { return batchNo; }
- set { batchNo = 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(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 string Gradecode
- {
- get { return gradecode; }
- set { gradecode = value; }
- }
- /// <summary>
- /// 钢种名称
- /// </summary>
- [Description("钢种")]
- [Nullable(true)]
- [DataLength(100)]
- public string Gradename
- {
- get { return gradename; }
- set { gradename = 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)]
- [DataLength(20)]
- public string StdCode
- {
- get { return stdCode; }
- set { stdCode = value; }
- }
- /// <summary>
- /// 标准名称
- /// </summary>
- [Description("标准名称")]
- [Nullable(true)]
- [DataLength(256)]
- public string StdName
- {
- get { return stdName; }
- set { stdName = value; }
- }
- /// <summary>
- /// 标准类别代码
- /// </summary>
- [Description("标准类别代码")]
- [Nullable(true)]
- [DataLength(20)]
- public string StdStyle
- {
- get { return stdStyle; }
- set { stdStyle = value; }
- }
- /// <summary>
- /// 标准类别描述(PSL1....)
- /// </summary>
- [Description("标准类别")]
- [Nullable(true)]
- [DataLength(50)]
- public string StdStyleDesc
- {
- get { return stdStyleDesc; }
- set { stdStyleDesc = value; }
- }
- /// <summary>
- /// 外径(实际)
- /// </summary>
- [Description("外径")]
- [Nullable(true)]
- [DataLength(5)]
- public decimal? ActDimater
- {
- get { return actDimater; }
- set { actDimater = value; }
- }
- /// <summary>
- /// 壁厚(实际)
- /// </summary>
- [Description("壁厚")]
- [Nullable(true)]
- [DataLength(5)]
- public decimal? ActHeight
- {
- get { return actHeight; }
- set { actHeight = value; }
- }
- /// <summary>
- /// 长度(实际)
- /// </summary>
- [Description("长度")]
- [Nullable(true)]
- [DataLength(9)]
- public decimal? ActLen
- {
- get { return actLen; }
- set { actLen = value; }
- }
- /// <summary>
- /// 长度下限(实际)
- /// </summary>
- [Description("长度下限")]
- [Nullable(true)]
- [DataLength(10)]
- public string ActLenMin
- {
- get { return actLenMin; }
- set { actLenMin = value; }
- }
- /// <summary>
- /// 长度上限(实际)
- /// </summary>
- [Description("长度上限")]
- [Nullable(true)]
- [DataLength(10)]
- public string ActLenMax
- {
- get { return actLenMax; }
- set { actLenMax = value; }
- }
- /// <summary>
- /// 组炉主炉号
- /// </summary>
- [Description("组炉主炉号")]
- [Nullable(true)]
- [DataLength(6)]
- public string ZpJudgeStoveNo
- {
- get { return zpJudgeStoveNo; }
- set { zpJudgeStoveNo = value; }
- }
- /// <summary>
- /// 组炉主批号
- /// </summary>
- [Description("组炉主批号")]
- [Nullable(true)]
- [DataLength(10)]
- public string ZpBatchNo
- {
- get { return zpBatchNo; }
- set { zpBatchNo = value; }
- }
- /// <summary>
- /// 离线支数
- /// </summary>
- [Description("离线总支数")]
- [Nullable(true)]
- [DataLength(6)]
- public decimal? OfflineNum
- {
- get { return offlineNum; }
- set { offlineNum = value; }
- }
- /// <summary>
- /// 离线重量
- /// </summary>
- [Description("离线重量")]
- [Nullable(true)]
- [DataLength(8)]
- public decimal? OfflineWt
- {
- get { return offlineWt; }
- set { offlineWt = value; }
- }
- /// <summary>
- /// 返线支数
- /// </summary>
- [Description("返线支数")]
- [Nullable(true)]
- [DataLength(6)]
- public decimal? ReNum
- {
- get { return reNum; }
- set { reNum = value; }
- }
- /// <summary>
- /// 返线重量
- /// </summary>
- [Description("返线重量")]
- [Nullable(true)]
- [DataLength(8)]
- public decimal? ReWt
- {
- get { return reWt; }
- set { reWt = value; }
- }
- /// <summary>
- /// 组炉支数
- /// </summary>
- [Description("组炉支数")]
- [Nullable(true)]
- [DataLength(6)]
- public decimal? GroupNum
- {
- get { return groupNum; }
- set { groupNum = value; }
- }
- /// <summary>
- /// 组炉重量
- /// </summary>
- [Description("组炉重量")]
- [Nullable(true)]
- [DataLength(6)]
- public decimal? GroupWt
- {
- get { return groupWt; }
- set { groupWt = value; }
- }
- /// <summary>
- /// 委外支数
- /// </summary>
- [Description("委外支数")]
- [Nullable(true)]
- [DataLength(6)]
- public decimal? SubcontractNum
- {
- get { return subcontractNum; }
- set { subcontractNum = value; }
- }
- /// <summary>
- /// 委外回报支数
- /// </summary>
- [Description("委外回报支数")]
- [Nullable(true)]
- [DataLength(6)]
- public decimal? SubcontractcompleteNum
- {
- get { return subcontractcompleteNum; }
- set { subcontractcompleteNum = value; }
- }
- /// <summary>
- /// 委外回报重量
- /// </summary>
- [Description("委外回报重量")]
- [Nullable(true)]
- [DataLength(8)]
- public decimal? SubcontractcompleteWt
- {
- get { return subcontractcompleteWt; }
- set { subcontractcompleteWt = value; }
- }
- /// <summary>
- /// 委外单号
- /// </summary>
- [Description("委外单号")]
- [Nullable(true)]
- [DataLength(20)]
- public string SubcontractNo
- {
- get { return subcontractNo; }
- set { subcontractNo = value; }
- }
- /// <summary>
- /// 委外单号序号
- /// </summary>
- [Description("委外单号序号")]
- [Nullable(true)]
- [DataLength(20)]
- public string SubcontractNoSeq
- {
- get { return subcontractNoSeq; }
- set { subcontractNoSeq = value; }
- }
- /// <summary>
- /// 作业日期(年月日)
- /// </summary>
- [Description("作业日期")]
- [Nullable(true)]
- [DataLength(8)]
- public string ProYearMonthDay
- {
- get { return proYearMonthDay; }
- set { proYearMonthDay = value; }
- }
- /// <summary>
- /// 操作人
- /// </summary>
- [Description("操作人")]
- [Nullable(true)]
- [DataLength(20)]
- public string ProUser
- {
- get { return proUser; }
- set { proUser = value; }
- }
- /// <summary>
- /// 操作班次
- /// </summary>
- [Description("班次")]
- [Nullable(true)]
- [DataLength(1)]
- public string ProShift
- {
- get { return proShift; }
- set { proShift = value; }
- }
- /// <summary>
- /// 操作班组
- /// </summary>
- [Description("班组")]
- [Nullable(true)]
- [DataLength(1)]
- public string ProGroup
- {
- get { return proGroup; }
- set { proGroup = value; }
- }
- /// <summary>
- /// 操作时间
- /// </summary>
- [Description("操作时间")]
- [Nullable(true)]
- public string ProTime
- {
- get { return proTime; }
- set { proTime = value; }
- }
- /// <summary>
- /// 组炉标记(1组炉生成的)
- /// </summary>
- [Description("组炉标记")]
- [Nullable(true)]
- [DataLength(1)]
- public string GroupLog
- {
- get { return groupLog; }
- set { groupLog = value; }
- }
- private string gxsl = "";
- public string Gxsl
- {
- get { return gxsl; }
- set { gxsl = value; }
- }
- private string gxxk = "";
- public string Gxxk
- {
- get { return gxxk; }
- set { gxxk = value; }
- }
- private string gxyz = "";
- public string Gxyz
- {
- get { return gxyz; }
- set { gxyz = value; }
- }
- private string gxdj = "";
- public string Gxdj
- {
- get { return gxdj; }
- set { gxdj = value; }
- }
- private string gxbj = "";
- public string Gxbj
- {
- get { return gxbj; }
- set { gxbj = value; }
- }
- private string gxcld = "";
- public string Gxcld
- {
- get { return gxcld; }
- set { gxcld = value; }
- }
- }
- }
|