| | |
| | | public string OrderNo { get; set; } |
| | | public BIZ_MES_WO WO { get; set; } |
| | | public BIZ_MES_WO_BATCH Batch { get; set; } |
| | | public BAS_CUSTOMER Customer { get; set; } |
| | | public List<BIZ_MES_WO_SN> WoSNs { get; set; } |
| | | public List<MES_WO_EDGE> Edges { get; set; } |
| | | public List<MES_WO_NODE> Nodes { get; set; } |
| | |
| | | WO = Biz.Db.Queryable<BIZ_MES_WO>().Where(q => q.ORDER_NO == OrderNo).First(); |
| | | Batch = Biz.Db.Queryable<BIZ_MES_WO_BATCH>().Where(q => q.ORDER_NO == OrderNo && q.ACT_LINE == lineCode |
| | | && (q.STATUS == BIZ_MES_WO_BATCH.STATUSs.Release.GetValue() || q.STATUS == BIZ_MES_WO_BATCH.STATUSs.Working.GetValue())).First(); |
| | | Customer = Biz.Db.Queryable<BAS_CUSTOMER>().Where(q => q.CUST_CODE == WO.CUST_CODE).First(); |
| | | WoSNs = Biz.Db.Queryable<BIZ_MES_WO_SN>().Where(q => q.WORK_ORDER == OrderNo).ToList(); |
| | | Edges = Biz.Db.Queryable<MES_WO_EDGE>().Where(q => q.WORK_ORDER == OrderNo).ToList(); |
| | | Nodes = Biz.Db.Queryable<MES_WO_NODE>().Where(q => q.WORK_ORDER == OrderNo).ToList(); |