public static EPart UdtEPartObject(EPart _param)
{
_param.Type = EBomConstant.TYPE_PART;
DaoFactory.SetUpdate("EBom.UpdateEPart", _param);
return(_param);
}
public static List <EPart> SelRootChildList(EPart _param)
{
List <EPart> lSelRootChildList = DaoFactory.GetList <EPart>("EBom.SelRootChildList", new EPart {
Type = EBomConstant.TYPE_PART, FromOID = _param.FromOID
});
lSelRootChildList.ForEach(obj =>
{
obj.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = obj.Type, OID = obj.BPolicyOID
}).First();
if (obj.Oem_Lib_OID != null)
{
obj.Oem_Lib_NM = LibraryRepository.SelLibraryObject(new Library {
OID = obj.Oem_Lib_OID
}).KorNm;
}
if (obj.Car_Lib_OID != null)
{
obj.Car_Lib_Nm = LibraryRepository.SelLibraryObject(new Library {
OID = obj.Car_Lib_OID
}).KorNm;
}
});
//var ll = (from l in lSelRootChildList select l).GroupBy(x => x.OID).Select(y => y.First());
List <EPart> RootChildList = lSelRootChildList.GroupBy(x => x.OID).Select(y => y.First()).ToList();
//var LinqRootChildList = (from List in lSelRootChildList
// select List).GroupBy(x => x.OID).Select(y => y.First());
//LinqRootChildList = LinqRootChildList.ToList<EPart>();
return(RootChildList);
}
public static EPart ChkEPart(EPart _param)
{
EPart lPartObj = DaoFactory.GetData <EPart>("EBom.ChkEPart", new EPart {
Type = EBomConstant.TYPE_PART, Name = _param.Name
});
return(lPartObj);
}
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 List <EPart> SelEPart(EPart _param)
{
_param.Type = EBomConstant.TYPE_PART;
//_param.StartCreateDt =
List <EPart> lEPart = DaoFactory.GetList <EPart>("EBom.SelEPart", _param);
lEPart.ForEach(obj =>
{
obj.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = obj.Type, OID = obj.BPolicyOID
}).First();
if (obj.Car_Lib_OID != null)
{
obj.Car_Lib_Nm = LibraryRepository.SelCodeLibraryObject(new Library {
OID = obj.Car_Lib_OID
}).KorNm;
}
if (obj.Block_No != null)
{
if (obj.Division == Common.Constant.EBomConstant.DIV_ASSEMBLY)
{
obj.Block_NoNm = LibraryRepository.SelCodeLibraryObject(new Library {
OID = obj.Block_No
}).KorNm;
}
else
{
obj.Block_NoNm = LibraryRepository.SelLibraryObject(new Library {
OID = obj.Block_No
}).KorNm;
}
}
if (obj.Material_OID != null)
{
obj.Material_Nm = LibraryRepository.SelLibraryObject(new Library {
OID = obj.Material_OID
}).KorNm;
}
if (obj.ITEM_No != null)
{
obj.ITEM_NoNm = LibraryRepository.SelCodeLibraryObject(new Library {
OID = obj.ITEM_No
}).KorNm;
}
});
return(lEPart);
}
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 EPart SelEPartObject(EPart _param)
{
EPart lEPart = DaoFactory.GetData <EPart>("EBom.SelEPart", new EPart {
Type = EBomConstant.TYPE_PART, OID = _param.OID
});
lEPart.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = lEPart.Type, OID = lEPart.BPolicyOID
}).First();
if (lEPart.ITEM_No != null)
{
lEPart.ITEM_NoNm = LibraryRepository.SelCodeLibraryObject(new Library {
OID = lEPart.ITEM_No
}).KorNm;
}
if (lEPart.ITEM_Middle != null)
{
lEPart.ITEM_MiddleNm = LibraryRepository.SelCodeLibraryObject(new Library {
OID = lEPart.ITEM_Middle
}).KorNm;
}
if (lEPart.EPartType != null)
{
lEPart.EPartTypeNm = LibraryRepository.SelLibraryObject(new Library {
OID = Convert.ToInt32(lEPart.EPartType)
}).KorNm;
}
if (lEPart.Production_Place != null)
{
lEPart.Production_PlaceNm = LibraryRepository.SelLibraryObject(new Library {
OID = lEPart.Production_Place
}).KorNm;
}
if (lEPart.Block_No != null)
{
if (lEPart.Division == Common.Constant.EBomConstant.DIV_ASSEMBLY)
{
lEPart.Block_NoNm = LibraryRepository.SelCodeLibraryObject(new Library {
OID = lEPart.Block_No
}).KorNm;
}
else
{
lEPart.Block_NoNm = LibraryRepository.SelLibraryObject(new Library {
OID = lEPart.Block_No
}).KorNm;
}
}
if (lEPart.Car_Lib_OID != null)
{
lEPart.Car_Lib_Nm = LibraryRepository.SelCodeLibraryObject(new Library {
OID = lEPart.Car_Lib_OID
}).KorNm;
}
if (lEPart.Material_OID != null)
{
lEPart.Material_Nm = LibraryRepository.SelLibraryObject(new Library {
OID = lEPart.Material_OID
}).KorNm;
}
return(lEPart);
}