public static List <EBOM> EBomStructure(EBOM _param)
{
List <EBOM> EBom = DaoFactory.GetList <EBOM>("EBom.SelEBom", new EBOM {
Type = EBomConstant.TYPE_PART, FromOID = _param.FromOID
});
return(EBom);
}
public static List <EBOM> SelRootChildEBomList(EBOM _param)
{
List <EBOM> lSelRootChildList = DaoFactory.GetList <EBOM>("EBom.SelRootChildEBomList", new EBOM {
Type = EBomConstant.TYPE_PART, FromOID = _param.FromOID
});
//List<EBOM> RootChildList = lSelRootChildList.GroupBy(x => x.OID).Select(y => y.First()).ToList();
return(lSelRootChildList);
}
public static void getReverseEbomStructure(EBOM _relData, int _rootOID)
{
_relData.Parents = getReverseEbom(new EBOM {
Type = EBomConstant.TYPE_PART, ToOID = _relData.FromOID
}, _rootOID);
_relData.Parents.ForEach(item =>
{
item.Level = _relData.Level + 1;
getReverseEbomStructure(item, _rootOID);
});
}
public static void getEbomStructure(EBOM _relData, int _rootOID)
{
_relData.Children = getEbom(new EBOM {
Type = EBomConstant.TYPE_PART, FromOID = _relData.ToOID
}, _rootOID);
_relData.Children.ForEach(item =>
{
item.Level = _relData.Level + 1;
getEbomStructure(item, _rootOID);
});
}
public static EBOM getListReverseEbom(int _level, int _rootOID)
{
EBOM getStructure = new EBOM();
getStructure.Level = _level;
getStructure.FromOID = _rootOID;
EPart PataData = SelEPartObject(new EPart {
OID = _rootOID
});
getStructure.FromData = PataData;
getStructure.Description = PataData.Description;
getStructure.ObjName = PataData.Name;
getStructure.ObjRevision = PataData.Revision;
getStructure.ObjTdmxOID = PataData.TdmxOID;
getStructure.ObjIsLatest = PataData.IsLatest;
getStructure.ObjTitle = PataData.Title;
getStructure.ObjRep_Part_No = PataData.Rep_Part_No;
getStructure.ObjRep_Part_No2 = PataData.Rep_Part_No2;
getStructure.ObjEo_No = PataData.Eo_No;
getStructure.ObjEtc = PataData.Etc;
getStructure.ObjApprovOID = PataData.ApprovOID;
getStructure.ObjEPartType = PataData.EPartType;
getStructure.ObjITEM_No = PataData.ITEM_No;
getStructure.ObjITEM_NoNm = PataData.ITEM_NoNm;
getStructure.ObjITEM_Middle = PataData.ITEM_Middle;
getStructure.ObjITEM_MiddleNm = PataData.ITEM_MiddleNm;
getStructure.ObjProduction_Place = PataData.Production_Place;
getStructure.ObjProduction_PlaceNm = PataData.Production_PlaceNm;
getStructure.ObjMaterial_OID = PataData.Material_OID;
getStructure.ObjMaterial_Nm = PataData.Material_Nm;
getStructure.ObjBlock_No = PataData.Block_No;
getStructure.ObjBlock_NoNm = PataData.Block_NoNm;
getStructure.ObjSel_Eo = PataData.Sel_Eo;
getStructure.ObjSel_Eo_Dt = PataData.Sel_Eo_Dt;
getStructure.ObjSpec = PataData.Spec;
getStructure.ObjSurface = PataData.Surface;
getStructure.ObjOem_Lib_OID = PataData.Oem_Lib_OID;
getStructure.ObjCar_Lib_OID = PataData.Car_Lib_OID;
getStructure.ObjPms_OID = PataData.Pms_OID;
getStructure.ObjProd_Lib_Lev1_OID = PataData.Prod_Lib_Lev1_OID;
getStructure.ObjProd_Lib_Lev2_OID = PataData.Prod_Lib_Lev2_OID;
getStructure.ObjProd_Lib_Lev3_OID = PataData.Prod_Lib_Lev3_OID;
getStructure.ObjCar_Lib_Nm = PataData.Car_Lib_Nm;
getStructure.BPolicy = PataData.BPolicy;
getReverseEbomStructure(getStructure, _rootOID);
return(getStructure);
}
public static List <EBOM> getReverseEbom(EBOM _param, int _rootOID)
{
List <EBOM> EBom = DaoFactory.GetList <EBOM>("EBom.SelEBom", _param);
foreach (EBOM Obj in EBom)
{
EPart PataData = SelEPartObject(new EPart {
OID = Obj.FromOID
});
Obj.FromData = PataData;
Obj.Description = PataData.Description;
Obj.ObjName = PataData.Name;
Obj.ObjRevision = PataData.Revision;
Obj.ObjTdmxOID = PataData.TdmxOID;
Obj.ObjIsLatest = PataData.IsLatest;
Obj.ObjTitle = PataData.Title;
Obj.ObjRep_Part_No = PataData.Rep_Part_No;
Obj.ObjRep_Part_No2 = PataData.Rep_Part_No2;
Obj.ObjEo_No = PataData.Eo_No;
Obj.ObjEtc = PataData.Etc;
Obj.ObjApprovOID = PataData.ApprovOID;
Obj.ObjEPartType = PataData.EPartType;
Obj.ObjITEM_No = PataData.ITEM_No;
Obj.ObjITEM_NoNm = PataData.ITEM_NoNm;
Obj.ObjITEM_Middle = PataData.ITEM_Middle;
Obj.ObjITEM_MiddleNm = PataData.ITEM_MiddleNm;
Obj.ObjProduction_Place = PataData.Production_Place;
Obj.ObjProduction_PlaceNm = PataData.Production_PlaceNm;
Obj.ObjMaterial_OID = PataData.Material_OID;
Obj.ObjMaterial_Nm = PataData.Material_Nm;
Obj.ObjBlock_No = PataData.Block_No;
Obj.ObjBlock_NoNm = PataData.Block_NoNm;
Obj.ObjSel_Eo = PataData.Sel_Eo;
Obj.ObjSel_Eo_Dt = PataData.Sel_Eo_Dt;
Obj.ObjSpec = PataData.Spec;
Obj.ObjSurface = PataData.Surface;
Obj.ObjOem_Lib_OID = PataData.Oem_Lib_OID;
Obj.ObjCar_Lib_OID = PataData.Car_Lib_OID;
Obj.ObjPms_OID = PataData.Pms_OID;
Obj.ObjProd_Lib_Lev1_OID = PataData.Prod_Lib_Lev1_OID;
Obj.ObjProd_Lib_Lev2_OID = PataData.Prod_Lib_Lev2_OID;
Obj.ObjProd_Lib_Lev3_OID = PataData.Prod_Lib_Lev3_OID;
Obj.ObjCar_Lib_Nm = PataData.Car_Lib_Nm;
Obj.BPolicy = PataData.BPolicy;
}
return(EBom);
}
public static List <EBOM> getListEbomAddChild(int _level, string _Name, EPart _Param)
{
List <EPart> EPartList = EPartRepository.SelEPart(_Param);
List <EBOM> getStructureList = new List <EBOM>();
int?TimeOID = Convert.ToInt32(DateTimeOffset.Now.ToUnixTimeSeconds());
foreach (var obj in EPartList)
{
TimeOID = TimeOID + 1;
EBOM getStructure = new EBOM();
getStructure.Level = _level;
getStructure.OID = TimeOID;
getStructure.ToOID = obj.OID;
getStructure.ToData = obj;
getStructure.Description = obj.Description;
getStructure.ObjName = obj.Name;
getStructure.ObjRevision = obj.Revision;
getStructure.ObjTdmxOID = obj.TdmxOID;
getStructure.ObjIsLatest = obj.IsLatest;
getStructure.ObjEPartType = obj.EPartType;
getStructure.ObjThumbnail = obj.Thumbnail;
getStructure.ObjCar_Lib_OID = obj.Car_Lib_OID;
getStructure.ObjCar_Lib_Nm = obj.Car_Lib_Nm;
getStructure.ObjDivision = obj.Division;
getStructure.ObjITEM_No = obj.ITEM_No;
getStructure.ObjITEM_NoNm = obj.ITEM_NoNm;
getStructure.ObjITEM_Middle = obj.ITEM_Middle;
getStructure.ObjITEM_MiddleNm = obj.ITEM_MiddleNm;
getStructure.ObjProduction_Place = obj.Production_Place;
getStructure.ObjProduction_PlaceNm = obj.Production_PlaceNm;
getStructure.ObjMaterial_OID = obj.Material_OID;
getStructure.ObjMaterial_Nm = obj.Material_Nm;
getStructure.ObjBlock_No = obj.Block_No;
getStructure.ObjBlock_NoNm = obj.Block_NoNm;
getStructure.ObjSerial = obj.Serial;
getStructure.ObjSel_Revision = obj.Sel_Revision;
getStructure.BPolicy = obj.BPolicy;
getEbomStructure(getStructure, Convert.ToInt32(obj.OID));
getStructureList.Add(getStructure);
}
return(getStructureList);
}
public static EBOM getListEbom(int _level, int _rootOID)
{
EBOM getStructure = new EBOM();
getStructure.Level = _level;
getStructure.ToOID = _rootOID;
EPart PataData = SelEPartObject(new EPart {
OID = _rootOID
});
getStructure.ToData = PataData;
getStructure.Description = PataData.Description;
getStructure.ObjName = PataData.Name;
getStructure.ObjRevision = PataData.Revision;
getStructure.ObjTdmxOID = PataData.TdmxOID;
getStructure.ObjIsLatest = PataData.IsLatest;
getStructure.ObjEPartType = PataData.EPartType;
getStructure.ObjThumbnail = PataData.Thumbnail;
getStructure.ObjCar_Lib_OID = PataData.Car_Lib_OID;
getStructure.ObjCar_Lib_Nm = PataData.Car_Lib_Nm;
getStructure.ObjDivision = PataData.Division;
getStructure.ObjITEM_No = PataData.ITEM_No;
getStructure.ObjITEM_NoNm = PataData.ITEM_NoNm;
getStructure.ObjITEM_Middle = PataData.ITEM_Middle;
getStructure.ObjITEM_MiddleNm = PataData.ITEM_MiddleNm;
getStructure.ObjProduction_Place = PataData.Production_Place;
getStructure.ObjProduction_PlaceNm = PataData.Production_PlaceNm;
getStructure.ObjMaterial_OID = PataData.Material_OID;
getStructure.ObjMaterial_Nm = PataData.Material_Nm;
getStructure.ObjBlock_No = PataData.Block_No;
getStructure.ObjBlock_NoNm = PataData.Block_NoNm;
getStructure.ObjSerial = PataData.Serial;
getStructure.ObjSel_Revision = PataData.Sel_Revision;
getStructure.BPolicy = PataData.BPolicy;
getStructure.diseditable = EBomConstant.DISEDITABLE;
getEbomStructure(getStructure, _rootOID);
return(getStructure);
}
public static List <EBOM> getEbom(EBOM _param, int _rootOID)
{
List <EBOM> EBom = DaoFactory.GetList <EBOM>("EBom.SelEBom", _param);
foreach (EBOM Obj in EBom)
{
EPart PataData = SelEPartObject(new EPart {
OID = Obj.ToOID
});
Obj.ToData = PataData;
Obj.Description = PataData.Description;
Obj.ObjName = PataData.Name;
Obj.ObjRevision = PataData.Revision;
Obj.ObjTdmxOID = PataData.TdmxOID;
Obj.ObjIsLatest = PataData.IsLatest;
Obj.ObjEPartType = PataData.EPartType;
Obj.ObjThumbnail = PataData.Thumbnail;
Obj.ObjCar_Lib_OID = PataData.Car_Lib_OID;
Obj.ObjCar_Lib_Nm = PataData.Car_Lib_Nm;
Obj.ObjDivision = PataData.Division;
Obj.ObjITEM_No = PataData.ITEM_No;
Obj.ObjITEM_NoNm = PataData.ITEM_NoNm;
Obj.ObjITEM_Middle = PataData.ITEM_Middle;
Obj.ObjITEM_MiddleNm = PataData.ITEM_MiddleNm;
Obj.ObjProduction_Place = PataData.Production_Place;
Obj.ObjProduction_PlaceNm = PataData.Production_PlaceNm;
Obj.ObjMaterial_OID = PataData.Material_OID;
Obj.ObjMaterial_Nm = PataData.Material_Nm;
Obj.ObjBlock_No = PataData.Block_No;
Obj.ObjBlock_NoNm = PataData.Block_NoNm;
Obj.ObjSerial = PataData.Serial;
Obj.ObjSel_Revision = PataData.Sel_Revision;
Obj.BPolicy = PataData.BPolicy;
Obj.diseditable = EBomConstant.FLOWEDITABLE;
}
return(EBom);
}
public static int UdtAction(EBOM _param)
{
int OID = DaoFactory.SetUpdate("EBom.UdtEBomStructure", _param);
return(OID);
}
public static int DeleteAction(EBOM _param)
{
int OID = DaoFactory.SetDelete("EBom.delEBomStructure", _param);
return(OID);
}
public static int AddAction(EBOM _param)
{
int OID = DaoFactory.SetInsert("EBom.InsEBomStructure", _param);
return(OID);
}
