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.Entity { /// /// 数据库表PLN_ZY_JG_WORKBILL所对应的实体类(生成工具:代码生成工具3.0) /// 作者:PC-20180117CCCC 时间:2018-06-26 /// public class PlnZyJgWorkMidbillEntity { /// /// 工单号(炉次计划号+01流水) /// private string woId = ""; /// /// 炉次计划号 /// private string heatPlanNo= ""; /// /// 判定炉号 /// private string judgeStoveNo = ""; /// /// 批号 /// private string batchNo = ""; /// /// 组号 /// private string batchGroudNo = ""; /// /// 接箍产线代码 /// private string plineCode = ""; /// /// 接箍产线描述 /// private string plineName = ""; /// /// 是否全工序委托(0否,1是) /// private string ifAllOutWork = ""; /// /// 是否委外锯切(0否,1是) /// private string ifOutCut = ""; /// /// 是否委外粗加工(0否,1是) /// private string ifOutCjg = ""; /// /// 是否委外压印(0否,1是) /// private string ifOutImpress = ""; /// /// 是否委外车丝(0否,1是) /// private string ifOutLathe = ""; /// /// 是否委外探伤(0否,1是) /// private string ifOutDetect = ""; /// /// 是否委外喷砂(0否,1是) /// private string ifOutBlast = ""; /// /// 是否委外涂层(0否,1镀铜,2磷化3.镀铜及磷化) /// private string ifOutCoat = ""; /// /// 涂层类型(0.无、1镀铜、2磷化、3镀铜及磷化) /// private string coatType = ""; /// /// 计划接箍个数 /// private decimal? planJgNum = null; /// /// 测算接箍个数 /// private decimal? csJgNum = null; /// /// 需求接箍个数 /// private decimal? xqJgNum = null; /// /// 压印喷标要求(4项之一) /// private string demandCopper = ""; /// /// 车丝机床组号 /// private string latheGrpNo = ""; /// /// 车丝机床组 /// private string latheGrpNm = ""; /// /// 探伤要求(4项之一,408401) /// private string demandDetection = ""; /// /// 喷砂要求(4项之一) /// private string demandBlast = ""; /// /// 磷化镀铜要求(4项之一,408402) /// private string demandBonderizing = ""; /// /// 工单状态(0计划,1下发,2生产中,3生产完成,4.关闭) /// private string zyBillStatus = ""; /// /// 备注 /// private string memo = ""; /// /// 创建人 /// private string createName = ""; /// /// 创建时间 /// private string createTime = ""; /// /// 下发人 /// private string updateName = ""; /// /// 下发时间 /// private string updateTime = ""; /// /// 是否委外喷标(0否,1是,2无喷标) /// private string ifOutCopper = ""; /// /// 关闭时间 /// private string closeTime = ""; /// /// 计划支数 /// private decimal? planBlNum = null; /// /// 计划重量 /// private decimal? planBlWt = null; /// /// 是否委外螺纹检验(0否,1是) /// private string ifOutThread = ""; /// /// 实际上料支 /// private decimal? realBlNum = null; /// /// 实际上料吨 /// private decimal? realBlWt = null; /// /// 冶炼炉号(电炉号) /// private string stoveNo = ""; /// /// 标示炉号(打印炉号) /// private string flagStoveNo = ""; /// /// 出库个数 /// private decimal? outNum = null; /// /// 出库吨 /// private decimal? outWt = null; /// /// 钢级(牌号)代码 /// private string steelcode = ""; /// /// 钢级(牌号)名称 /// private string steelname = ""; /// /// 钢种代码 /// private string gradecode = ""; /// /// 钢种名称 /// private string gradename = ""; /// /// 接箍规格描述 /// private string specJgDesc = ""; /// /// 接箍规格代码 /// private string specJg = ""; /// /// 中孔类别(I、II、III、IV...) /// private string styleJg = ""; /// /// 接箍标准代码 /// private string stdCode = ""; /// /// 接箍标准名称 /// private string stdName = ""; /// /// 接箍标准类别代码 /// private string stdStyle = ""; /// /// 接箍标准类别描述(I、II、III) /// private string stdStyleDesc = ""; /// /// 接箍品种代码 /// private string produccodeJg = ""; /// /// 接箍品种描述 /// private string produccodeJgDesc = ""; /// /// 接箍码 /// private string codeJg = ""; /// /// 接箍备料码 /// private string codeJgBl = ""; /// /// 备料码集合 /// private string codeBlAll = ""; /// /// 扣型代码 /// private string modelCode = ""; /// /// 接箍扣型描述 /// private string modelDesc = ""; /// /// 是否接箍监制 /// private string ifMonitorJg = ""; /// /// 监制编号 /// private string prdcrNo = ""; /// /// 锯切支数CUT_PIECES /// private string cutPieces = ""; /// /// 工单号(炉次计划号+01流水) /// [Description("锯切支数")] [Nullable(true)] [DataLength(20)] public string CutPieces { get { return cutPieces; } set { cutPieces = value; } } /// /// 库存确认MATCONFIRM /// private string matconfirm = ""; /// /// 确认 /// [Description("确认")] [Nullable(true)] [DataLength(20)] public string Matconfirm { get { return matconfirm; } set { matconfirm = value; } } /// /// 班次COL_SHIFT /// private string colShift = ""; /// /// 班次 /// [Description("班次")] [Nullable(true)] [DataLength(20)] public string ColShift { get { return colShift; } set { colShift = value; } } /// /// 操作工COL_OPERATOR /// private string colOperator = ""; /// /// 操作工 /// [Description("操作工")] [Nullable(true)] [DataLength(20)] public string ColOperator { get { return colOperator; } set { colOperator = value; } } /// /// 废品个数FAIL_CUT_NUM /// private string failCutNum = ""; /// /// 工单号(炉次计划号+01流水) /// [Description("废品个数")] [Nullable(true)] [DataLength(20)] public string FailCutNum { get { return failCutNum; } set { failCutNum = value; } } /// /// 上料支数LOAD_PIECES /// private string loadPieces = ""; /// /// 工单号(炉次计划号+01流水) /// [Description("上料支数")] [Nullable(true)] [DataLength(20)] public string LoadPieces { get { return loadPieces; } set { loadPieces = value; } } /// /// 上料重量LOAD_WEIGHT /// private string loadWeight = ""; /// /// 工单号(炉次计划号+01流水) /// [Description("上料重量")] [Nullable(true)] [DataLength(20)] public string LoadWeight { get { return loadWeight; } set { loadWeight = value; } } /// /// 螺纹个数SJ_NUM /// private string sjNum = ""; /// /// 工单号(炉次计划号+01流水) /// [Description("螺纹个数")] [Nullable(true)] [DataLength(20)] public string SjNum { get { return sjNum; } set { sjNum = value; } } /// /// 锯切个数CUT_NUM /// private string cutNum = ""; /// /// 工单号(炉次计划号+01流水) /// [Description("锯切个数")] [Nullable(true)] [DataLength(20)] public string CutNum { get { return cutNum; } set { cutNum = value; } } /// /// 车丝个数CS_NUM /// private string csNum = ""; /// /// 工单号(炉次计划号+01流水) /// [Description("车丝个数")] [Nullable(true)] [DataLength(20)] public string CsNum { get { return csNum; } set { csNum = value; } } /// /// 探伤个数TS_NUM /// private string tsNum = ""; /// /// 工单号(炉次计划号+01流水) /// [Description("探伤个数")] [Nullable(true)] [DataLength(20)] public string TsNum { get { return tsNum; } set { tsNum = value; } } /// /// 喷砂个数PS_NUM /// private string psNum = ""; /// /// 工单号(炉次计划号+01流水) /// [Description("喷砂个数")] [Nullable(true)] [DataLength(20)] public string PsNum { get { return psNum; } set { psNum = value; } } /// //合同号ORDER_NO /// private string orderNo = ""; /// /// 合同号 /// [Description("合同号")] [Nullable(true)] [DataLength(20)] public string OrderNo { get { return orderNo; } set { orderNo = value; } } /// //合同行号ORDER_SEQ /// private string orderSeq = ""; /// /// 合同行号 /// [Description("合同行号")] [Nullable(true)] [DataLength(40)] public string OrderSeq { get { return orderSeq; } set { orderSeq = value; } } /// //合同子行号ORDER_SEQ_NO /// private string orderSeqNo = ""; /// /// 合同子行号 /// [Description("交货行号")] [Nullable(true)] [DataLength(40)] public string OrderSeqNo { get { return orderSeqNo; } set { orderSeqNo = value; } } /// /// 锯切个数QUALIFIED_NUMBER /// private string qualifiedNumber = ""; /// /// 锯切个数(炉次计划号+01流水) /// [Description("锯切个数")] [Nullable(true)] [DataLength(20)] public string QualifiedNumber { get { return qualifiedNumber; } set { qualifiedNumber = value; } } /// /// 车丝个数PRODUCED_PCS /// private string producedPcs = ""; /// /// 车丝个数(炉次计划号+01流水) /// [Description("车丝个数")] [Nullable(true)] [DataLength(20)] public string ProducedPcs { get { return producedPcs; } set { producedPcs = value; } } /// /// 磷化个数LH_NUM /// private string lhNum = ""; /// /// 车丝个数(炉次计划号+01流水) /// [Description("磷化个数")] [Nullable(true)] [DataLength(20)] public string LhNum { get { return lhNum; } set { lhNum = value; } } /// /// 工单号(炉次计划号+01流水) /// [Description("工单号")] [Nullable(false)] [DataLength(20)] public string WoId { get { return woId; } set { woId = value; } } /// /// 炉次计划号 /// [Description("炉次计划号")] [Nullable(false)] [DataLength(20)] public string HeatPlanNo { get { return heatPlanNo; } set { heatPlanNo = value; } } /// /// 判定炉号 /// [Description("判定炉号")] [Nullable(true)] [DataLength(6)] public string JudgeStoveNo { get { return judgeStoveNo; } set { judgeStoveNo = value; } } /// /// 批号 /// [Description("批号")] [Nullable(true)] [DataLength(20)] public string BatchNo { get { return batchNo; } set { batchNo = value; } } /// /// 组号 /// [Description("组号")] [Nullable(true)] [DataLength(3)] public string BatchGroudNo { get { return batchGroudNo; } set { batchGroudNo = value; } } /// /// 接箍产线代码 /// [Description("接箍产线代码")] [Nullable(true)] [DataLength(20)] public string PlineCode { get { return plineCode; } set { plineCode = value; } } /// /// 接箍产线描述 /// [Description("产线描述")] [Nullable(true)] [DataLength(100)] public string PlineName { get { return plineName; } set { plineName = value; } } /// /// 是否全工序委托(0否,1是) /// [Description("是否全委外")] [Nullable(true)] [DataLength(1)] public string IfAllOutWork { get { return ifAllOutWork; } set { ifAllOutWork = value; } } /// /// 是否委外锯切(0否,1是) /// [Description("是否委外锯切")] [Nullable(true)] [DataLength(1)] public string IfOutCut { get { return ifOutCut; } set { ifOutCut = value; } } /// /// 是否委外粗加工(0否,1是) /// [Description("是否委外粗加工")] [Nullable(true)] [DataLength(1)] public string IfOutCjg { get { return ifOutCjg; } set { ifOutCjg = value; } } /// /// 是否委外压印(0否,1是) /// [Description("是否委外压印")] [Nullable(true)] [DataLength(1)] public string IfOutImpress { get { return ifOutImpress; } set { ifOutImpress = value; } } /// /// 是否委外车丝(0否,1是) /// [Description("是否委外车丝")] [Nullable(true)] [DataLength(1)] public string IfOutLathe { get { return ifOutLathe; } set { ifOutLathe = value; } } /// /// 是否委外探伤(0否,1是) /// [Description("是否委外探伤")] [Nullable(true)] [DataLength(1)] public string IfOutDetect { get { return ifOutDetect; } set { ifOutDetect = value; } } /// /// 是否委外喷砂(0否,1是) /// [Description("是否委外喷砂")] [Nullable(true)] [DataLength(1)] public string IfOutBlast { get { return ifOutBlast; } set { ifOutBlast = value; } } /// /// 是否委外涂层(0否,1镀铜,2磷化3.镀铜及磷化) /// [Description("是否委外涂层")] [Nullable(true)] [DataLength(1)] public string IfOutCoat { get { return ifOutCoat; } set { ifOutCoat = value; } } /// /// 涂层类型(0.无、1镀铜、2磷化、3镀铜及磷化) /// [Description("涂层类型")] [Nullable(true)] [DataLength(1)] public string CoatType { get { return coatType; } set { coatType = value; } } /// /// 计划接箍个数 /// [Description("计划个数")] [Nullable(true)] [DataLength(10)] public decimal? PlanJgNum { get { return planJgNum; } set { planJgNum = value; } } /// /// 测算接箍个数 /// [Description("测算个数")] [Nullable(true)] [DataLength(10)] public decimal? CsJgNum { get { return csJgNum; } set { csJgNum = value; } } /// /// 需求接箍个数 /// [Description("需求个数")] [Nullable(true)] [DataLength(10)] public decimal? XqJgNum { get { return xqJgNum; } set { xqJgNum = value; } } /// /// 压印喷标要求(4项之一) /// [Description("是否压印喷标")] [Nullable(true)] [DataLength(40)] public string DemandCopper { get { return demandCopper; } set { demandCopper = value; } } /// /// 探伤要求(4项之一,408401) /// [Description("是否探伤")] [Nullable(true)] [DataLength(40)] public string DemandDetection { get { return demandDetection; } set { demandDetection = value; } } /// /// 喷砂要求(4项之一) /// [Description("是否喷砂")] [Nullable(true)] [DataLength(40)] public string DemandBlast { get { return demandBlast; } set { demandBlast = value; } } /// /// 磷化镀铜要求(4项之一,408402) /// [Description("是否磷化镀铜")] [Nullable(true)] [DataLength(40)] public string DemandBonderizing { get { return demandBonderizing; } set { demandBonderizing = value; } } /// /// 工单状态(0计划,1下发,2生产中,3生产完成,4.关闭) /// [Description("工单状态")] [Nullable(true)] [DataLength(1)] public string ZyBillStatus { get { return zyBillStatus; } set { zyBillStatus = value; } } /// /// 备注 /// [Description("备注")] [Nullable(true)] [DataLength(200)] public string Memo { get { return memo; } set { memo = 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; } } //CONFIRM_TIME确认时间 private string confirmTime = ""; [Description("作业区确认时间")] [Nullable(true)] public string ConfirmTime { get { return confirmTime; } set { confirmTime = value; } } //作业区确认人 private string matconfirmName = ""; [Description("生产准备确认人")] [Nullable(true)] [DataLength(20)] public string MatconfirmName { get { return matconfirmName; } set { matconfirmName = value; } } //CONFIRM_TIME确认时间 private string matconfirmTime = ""; [Description("生产准备确认时间")] [Nullable(true)] public string MatconfirmTime { get { return matconfirmTime; } set { matconfirmTime = value; } } //确认人 private string confirmName = ""; [Description("作业区确认人")] [Nullable(true)] [DataLength(20)] public string ConfirmName { get { return confirmName; } set { confirmName = value; } } /// /// 下发人 /// [Description("下发人")] [Nullable(true)] [DataLength(20)] public string UpdateName { get { return updateName; } set { updateName = value; } } /// /// 下发时间 /// [Description("下发时间")] [Nullable(true)] public string UpdateTime { get { return updateTime; } set { updateTime = value; } } /// /// 是否委外喷标(0否,1是,2无喷标) /// [Description("是否委外喷标")] [Nullable(true)] [DataLength(1)] public string IfOutCopper { get { return ifOutCopper; } set { ifOutCopper = value; } } /// /// 关闭时间 /// [Description("关闭时间")] [Nullable(true)] public string CloseTime { get { return closeTime; } set { closeTime = value; } } /// /// 计划支数 /// [Description("计划支")] [Nullable(true)] [DataLength(10)] public decimal? PlanBlNum { get { return planBlNum; } set { planBlNum = value; } } /// /// 计划重量 /// [Description("计划吨")] [Nullable(true)] [DataLength(10)] public decimal? PlanBlWt { get { return planBlWt; } set { planBlWt = value; } } /// /// 是否委外螺纹检验(0否,1是) /// [Description("是否委外螺纹检验")] [Nullable(true)] [DataLength(1)] public string IfOutThread { get { return ifOutThread; } set { ifOutThread = value; } } /// /// 实际上料支 /// [Description("上料支")] [Nullable(true)] [DataLength(10)] public decimal? RealBlNum { get { return realBlNum; } set { realBlNum = value; } } /// /// 实际上料吨 /// [Description("上料吨")] [Nullable(true)] [DataLength(10)] public decimal? RealBlWt { get { return realBlWt; } set { realBlWt = value; } } /// /// 冶炼炉号(电炉号) /// [Description("冶炼炉号")] [Nullable(true)] [DataLength(10)] public string StoveNo { get { return stoveNo; } set { stoveNo = value; } } /// /// 标示炉号(打印炉号) /// [Description("标示炉号")] [Nullable(true)] [DataLength(10)] public string FlagStoveNo { get { return flagStoveNo; } set { flagStoveNo = value; } } /// /// 出库个数 /// [Description("出库个")] [Nullable(true)] [DataLength(10)] public decimal? OutNum { get { return outNum; } set { outNum = value; } } /// /// 出库吨 /// [Description("出库吨")] [Nullable(true)] [DataLength(10)] public decimal? OutWt { get { return outWt; } set { outWt = 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(10)] public string Gradecode { get { return gradecode; } set { gradecode = value; } } /// /// 钢种名称 /// [Description("钢种")] [Nullable(true)] [DataLength(100)] public string Gradename { get { return gradename; } set { gradename = value; } } /// /// 接箍规格描述 /// [Description("规格")] [Nullable(true)] [DataLength(100)] public string SpecJgDesc { get { return specJgDesc; } set { specJgDesc = value; } } /// /// 接箍规格代码 /// [Description("接箍规格代码")] [Nullable(true)] [DataLength(10)] public string SpecJg { get { return specJg; } set { specJg = value; } } /// /// 中孔类别(I、II、III、IV...) /// [Description("中孔类别")] [Nullable(true)] [DataLength(8)] public string StyleJg { get { return styleJg; } set { styleJg = 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 StdStyle { get { return stdStyle; } set { stdStyle = value; } } /// /// 接箍标准类别描述(I、II、III) /// [Description("标准类别")] [Nullable(true)] [DataLength(10)] public string StdStyleDesc { get { return stdStyleDesc; } set { stdStyleDesc = value; } } /// /// 接箍品种代码 /// [Description("接箍品种代码")] [Nullable(true)] [DataLength(20)] public string ProduccodeJg { get { return produccodeJg; } set { produccodeJg = value; } } /// /// 接箍品种描述 /// [Description("品种")] [Nullable(true)] [DataLength(100)] public string ProduccodeJgDesc { get { return produccodeJgDesc; } set { produccodeJgDesc = value; } } /// /// 接箍码 /// [Description("接箍码")] [Nullable(true)] [DataLength(7)] public string CodeJg { get { return codeJg; } set { codeJg = value; } } /// /// 接箍备料码 /// [Description("接箍备料码")] [Nullable(true)] [DataLength(20)] public string CodeJgBl { get { return codeJgBl; } set { codeJgBl = value; } } /// /// 备料码集合 /// [Description("备料码集合")] [Nullable(true)] [DataLength(200)] public string CodeBlAll { get { return codeBlAll; } set { codeBlAll = 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(1)] public string IfMonitorJg { get { return ifMonitorJg; } set { ifMonitorJg = value; } } /// /// 监制编号 /// [Description("监制编号")] [Nullable(true)] [DataLength(40)] public string PrdcrNo { get { return prdcrNo; } set { prdcrNo = value; } } /// /// 上料行ID(炉计划ID+2位流水) /// private string heatPlanSqe = ""; /// /// 上料行ID(炉计划ID+2位流水) /// [Description("上料行ID")] [Nullable(false)] [DataLength(20)] public string HeatPlanSqe { get { return heatPlanSqe; } set { heatPlanSqe = value; } } [Description("机床组号")] public string LatheGrpNo { get { return latheGrpNo; } set { latheGrpNo = value; } } [Description("车丝机编号")] public string LatheGrpNm { get { return latheGrpNm; } set { latheGrpNm = value; } } private string singleCutNun = ""; [Description("单支可切个数")] public string SingleCutNun { get { return singleCutNun; } set { singleCutNun = value; } } private string singleweight = ""; [Description("接箍单重")] public string Singleweight { get { return singleweight; } set { singleweight = value; } } /// /// 接箍合同号集合JG_ORDERNO_ALL /// private string jgOrdernoAll = ""; /// /// 接箍合同号集合 /// [Description("接箍合同号")] [Nullable(false)] [DataLength(200)] public string JgOrdernoAll { get { return jgOrdernoAll; } set { jgOrdernoAll = value; } } private string craftNoJg2 = ""; [Description("二级工艺文件")] public string CraftNoJg2 { get { return craftNoJg2; } set { craftNoJg2 = value; } } private string craftSeq2 = ""; [Description("工艺序号")] public string CraftSeq2 { get { return craftSeq2; } set { craftSeq2 = value; } } private string craftPath = ""; [Description("工艺路径")] public string CraftPath { get { return craftPath; } set { craftPath = value; } } /// /// 主交货编码PK /// private string ordLnDlyPk = ""; /// /// 主合同号 /// private string orderNoSeq = ""; /// /// 主交货编码 /// private string deliveryNo = ""; /// /// 主交货编码PK /// [Description("交货行PK")] [Nullable(true)] [DataLength(50)] public string OrdLnDlyPk { get { return ordLnDlyPk; } set { ordLnDlyPk = value; } } /// /// 主合同号 /// [Description("合同号")] [Nullable(true)] [DataLength(20)] public string OrderNoSeq { get { return orderNoSeq; } set { orderNoSeq = value; } } /// /// 主交货编码 /// [Description("交货行")] [Nullable(true)] [DataLength(3)] public string DeliveryNo { get { return deliveryNo; } set { deliveryNo = value; } } private string latheCutNm = ""; [Description("切管机编号")] public string LatheCutNm { get { return latheCutNm; } set { latheCutNm = value; } } } }