示例#1
0
 public DataLayer.PP_WasteCanbanInfo ConvertToTable(WasteCanbanInfoModel model)
 {
     DataLayer.PP_WasteCanbanInfo tbl = new DataLayer.PP_WasteCanbanInfo();
     tbl.WasteCanbanID    = model.WasteCanbanID;
     tbl.FacilityID       = model.FacilityID;
     tbl.WorkerID         = model.WorkerID;
     tbl.WasteSourceID    = model.WasteSourceID;
     tbl.WTrackingCode    = model.WTrackingCode;
     tbl.WPackageCode     = model.WPackageCode;
     tbl.WInventoryCode   = model.WInventoryCode;
     tbl.InputOutputID    = model.InputOutputID;
     tbl.WastageQuantity  = model.WastageQuantity;
     tbl.TaminID          = model.TaminID;
     tbl.WasteDesc        = model.WasteDesc;
     tbl.OvercomeDesc     = model.OvercomeDesc;
     tbl.YearID           = model.YearID;
     tbl.UserID           = model.UserID;
     tbl.BranchID         = model.BranchID;
     tbl.RegisteredDate   = model.RegisteredDate;
     tbl.WCProcessStageID = model.WCProcessStageID;
     tbl.ActionID         = model.ActionID;
     tbl.FaultID          = model.FaultID;
     tbl.WasteSupplierID  = model.WasteSupplierID;
     tbl.BOM         = model.BOM;
     tbl.WastePartID = model.WastePartID;
     tbl.ReworkTime  = model.ReworkTime;
     return(tbl);
 }
示例#2
0
        ///////// second detail
        public WasteCanbanInfoModel ConvertToModel(DataLayer.PP_WasteCanbanInfo tbl)
        {
            WasteCanbanInfoModel model = new WasteCanbanInfoModel();

            model.WasteCanbanID   = tbl.WasteCanbanID;
            model.FacilityID      = tbl.FacilityID;
            model.WorkerID        = tbl.WorkerID;
            model.WasteSourceID   = tbl.WasteSourceID;
            model.WTrackingCode   = tbl.WTrackingCode;
            model.WPackageCode    = tbl.WPackageCode;
            model.WInventoryCode  = tbl.WInventoryCode;
            model.InputOutputID   = tbl.InputOutputID;
            model.WastageQuantity = tbl.WastageQuantity;
            model.TaminID         = tbl.TaminID;
            model.WasteDesc       = tbl.WasteDesc;
            model.OvercomeDesc    = tbl.OvercomeDesc;
            model.YearID          = tbl.YearID;
            model.UserID          = tbl.UserID;
            model.BranchID        = tbl.BranchID;
            model.RegisteredDate  = tbl.RegisteredDate;
            model.ActionID        = tbl.ActionID;
            model.FaultID         = tbl.FaultID;
            model.ReworkTime      = tbl.ReworkTime;
            model.WasteSupplierID = tbl.WasteSupplierID;
            model.BOM             = tbl.BOM;
            model.WastePartID     = tbl.WastePartID;
            if (context.PP_WarehouseTypeInfos.Where(q => q.WarehouseTypeInfoID == tbl.WInventoryCode).FirstOrDefault() != null)
            {
                model.WInventoryCodeName = context.PP_WarehouseTypeInfos.Where(q => q.WarehouseTypeInfoID == tbl.WInventoryCode).FirstOrDefault().WarehouseTypeInfoName;
            }
            if (context.PP_CodeInfos.Where(q => q.CodeID == tbl.WPackageCode).FirstOrDefault() != null)
            {
                model.WPackageCodeName = context.PP_CodeInfos.Where(q => q.CodeID == tbl.WPackageCode).FirstOrDefault().CodeDesc;
            }
            if (context.PP_CodeInfos.Where(q => q.CodeID == tbl.WTrackingCode).FirstOrDefault() != null)
            {
                model.WTrackingCodeName = context.PP_CodeInfos.Where(q => q.CodeID == tbl.WTrackingCode).FirstOrDefault().CodeDesc;
            }
            if (context.PP_WasteSourceInfos.Where(q => q.WasteSourceID == tbl.WasteSourceID).FirstOrDefault() != null)
            {
                model.WasteSourceIDName = context.PP_WasteSourceInfos.Where(q => q.WasteSourceID == tbl.WasteSourceID).FirstOrDefault().WasteSourceName;
            }
            if (context.PP_WorkersInfos.Where(q => q.WorkersID == tbl.WorkerID).FirstOrDefault() != null)
            {
                model.WorkerIDName = context.PP_WorkersInfos.Where(q => q.WorkersID == tbl.WorkerID).FirstOrDefault().WorkersName + " " + context.PP_WorkersInfos.Where(q => q.WorkersID == tbl.WorkerID).FirstOrDefault().WorkersSurname;
            }
            if (context.PP_FacilityInfos.Where(q => q.FacilityID == tbl.FacilityID).FirstOrDefault() != null)
            {
                model.FacilityIDName = context.PP_FacilityInfos.Where(q => q.FacilityID == tbl.FacilityID).FirstOrDefault().FacilityName;
            }
            if (context.PP_FaultInfos.Where(q => q.FaultID == tbl.FaultID).FirstOrDefault() != null)
            {
                model.FaultIDName = context.PP_FaultInfos.Where(q => q.FaultID == tbl.FaultID).FirstOrDefault().FaultName;
            }
            if (context.PP_ActionInfos.Where(q => q.ActionID == tbl.ActionID).FirstOrDefault() != null)
            {
                model.ActionIDName = context.PP_ActionInfos.Where(q => q.ActionID == tbl.ActionID).FirstOrDefault().ActionName;
            }
            if (context.MRP_PartInfos.Where(q => q.PartID == tbl.WastePartID).FirstOrDefault() != null)
            {
                model.WastePartIDName = context.MRP_PartInfos.Where(q => q.PartID == tbl.WastePartID).FirstOrDefault().PartName;
            }
            if (context.PP_ProcessStageInfos.Where(q => q.ProcessStageID == tbl.WCProcessStageID).FirstOrDefault() != null)
            {
                model.WCProcessStageIDName = context.PP_ProcessStageInfos.Where(q => q.ProcessStageID == tbl.WCProcessStageID).FirstOrDefault().ProcessStageName;
            }
            if (context.PP_Tamins.Where(q => q.TaminID == tbl.TaminID).FirstOrDefault() != null)
            {
                model.TaminName = context.PP_Tamins.Where(q => q.TaminID == tbl.TaminID).FirstOrDefault().TaminName;
            }
            //model.WCProcessStageID = tbl.WCProcessStageID;
            return(model);
        }