public static PmsProject SelPmsObject(PmsProject _param)
{
if (_param.Type == null)
{
_param.Type = PmsConstant.TYPE_PROJECT;
}
PmsProject pmsProject = DaoFactory.GetData <PmsProject>("Pms.SelPmsProject", _param);
pmsProject.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = pmsProject.Type, OID = pmsProject.BPolicyOID
}).First();
pmsProject.Calendar = CalendarRepository.SelCalendar(new Calendar {
Type = CommonConstant.TYPE_CALENDAR, OID = pmsProject.CalendarOID
});
PmsRelationship Member = PmsRelationshipRepository.SelPmsRelationship(new PmsRelationship {
Type = PmsConstant.RELATIONSHIP_MEMBER, RootOID = pmsProject.OID, RoleOID = BDefineRepository.SelDefine(new BDefine {
Module = PmsConstant.MODULE_PMS, Type = CommonConstant.DEFINE_ROLE, Name = PmsConstant.ROLE_PM
}).OID
}).First();
pmsProject.PMNm = PersonRepository.SelPerson(new Person {
OID = Member.ToOID
}).Name;
return(pmsProject);
}
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 ActionResult InfoDocument(int OID)
{
Doc docDetail = DocRepository.SelDocObject(new Doc {
OID = OID
});
if (docDetail.Doc_Lib_Lev1_OID != null)
{
docDetail.Doc_Lib_Lev1_KorNm = LibraryRepository.SelLibraryObject(new Library {
OID = docDetail.Doc_Lib_Lev1_OID
}).KorNm;
}
if (docDetail.Doc_Lib_Lev2_OID != null)
{
docDetail.Doc_Lib_Lev2_KorNm = LibraryRepository.SelLibraryObject(new Library {
OID = docDetail.Doc_Lib_Lev2_OID
}).KorNm;
}
if (docDetail.Doc_Lib_Lev3_OID != null)
{
docDetail.Doc_Lib_Lev3_KorNm = LibraryRepository.SelLibraryObject(new Library {
OID = docDetail.Doc_Lib_Lev3_OID
}).KorNm;
}
ViewBag.docDetail = docDetail;
ViewBag.Status = BPolicyRepository.SelBPolicy(new BPolicy {
Type = DocumentContant.TYPE_DOCUMENT
});
return(View());
}
public JsonResult SelMyApproval(ApprovalTask _param)
{
List <Person> persons = PersonRepository.SelPersons(new Person {
});
List <BPolicy> policies = BPolicyRepository.SelBPolicy(new BPolicy {
Type = CommonConstant.TYPE_APPROVAL_TASK
});
List <ApprovalTask> myApproval = new List <ApprovalTask>();
DaoFactory.GetList <ApprovalTask>("Comm.SelMyApprovalTask", _param).ForEach(approv =>
{
approv.PersonObj = persons.Find(person => person.OID == approv.PersonOID);
approv.PersonNm = approv.PersonObj.Name;
approv.DepartmentNm = approv.PersonObj.DepartmentNm;
approv.BPolicy = policies.Find(policy => policy.OID == approv.BPolicyOID);
approv.ApprovalBPolicy = DObjectRepository.SelDObject(new DObject {
OID = approv.ApprovalOID
}).BPolicy;
if (approv.BPolicy.Name == approv.ApprovalBPolicy.Name)
{
myApproval.Add(approv);
}
});
return(Json(myApproval));
}
public static PmsBaseLineProject SelPmsBaseLIneProject(PmsBaseLineProject _param)
{
_param.Type = PmsConstant.TYPE_BASE_LINE_PROJECT;
PmsBaseLineProject pmsBaseLineProject = DaoFactory.GetData <PmsBaseLineProject>("Pms.SelPmsBaseLineProject", _param);
pmsBaseLineProject.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = pmsBaseLineProject.Type, OID = pmsBaseLineProject.BPolicyOID
}).First();
return(pmsBaseLineProject);
}
public static QuickResponse SelQuickResponse(QuickResponse _param)
{
_param.Type = QmsConstant.TYPE_QUICK_RESPONSE;
QuickResponse quickResponse = DaoFactory.GetData <QuickResponse>("Qms.SelQuickResponse", _param);
quickResponse.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = QmsConstant.TYPE_QUICK_RESPONSE, OID = quickResponse.BPolicyOID
}).First();
return(quickResponse);
}
public static Doc SelDocObject(Doc _param)
{
_param.Type = DocumentContant.TYPE_DOCUMENT;
Doc lDoc = DaoFactory.GetData <Doc>("Doc.SelDoc", _param);
lDoc.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = lDoc.Type, OID = lDoc.BPolicyOID
}).First();
return(lDoc);
}
public ActionResult MyApproval()
{
ViewBag.Types = BDefineRepository.SelDefines(new BDefine {
Type = CommonConstant.DEFINE_TYPE
});
ViewBag.Status = BPolicyRepository.SelBPolicy(new BPolicy {
Type = CommonConstant.TYPE_APPROVAL_TASK
});
return(View());
}
public static PmsProcess SelPmsProcess(PmsProcess _param)
{
_param.Type = _param.ProcessType;
PmsProcess pmsProcess = DaoFactory.GetData <PmsProcess>("Pms.SelPmsProcess", _param);
pmsProcess.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = pmsProcess.ProcessType, OID = pmsProcess.BPolicyOID
}).First();
return(pmsProcess);
}
public static int InsPmsBaseLineProject(PmsBaseLineProject _param)
{
_param.CreateUs = 1;
if (_param.BPolicyOID == null)
{
_param.BPolicyOID = BPolicyRepository.SelBPolicy(new BPolicy {
Type = _param.Type
}).First().OID;
}
return(DaoFactory.SetInsert("Pms.InsPmsBaseLineProject", _param));
}
public static ProblemsLibrary SelProblemsLibraryObject(ProblemsLibrary _param)
{
_param.Type = EcontentsConstant.TYPE_ECONTENTS;
ProblemsLibrary lProblemsLibrary = DaoFactory.GetData <ProblemsLibrary>("Econtents.SelProblemsLibrary", _param);
lProblemsLibrary.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = lProblemsLibrary.Type, OID = lProblemsLibrary.BPolicyOID
}).First();
return(lProblemsLibrary);
}
public ActionResult InfoChangeRequest(int OID)
{
ECR ECRDetail = ECRRepository.SelChangeRequestObject(new ECR {
OID = OID
});
ViewBag.ECRDetail = ECRDetail;
ViewBag.Status = BPolicyRepository.SelBPolicy(new BPolicy {
Type = EoConstant.TYPE_CHANGE_REQUEST
});
return(View());
}
public ActionResult InfoChangeOrder(int OID)
{
ECO ECODetail = ECORepository.SelChangeOrderObject(new ECO {
OID = OID
});
ViewBag.ECODetail = ECODetail;
ViewBag.Status = BPolicyRepository.SelBPolicy(new BPolicy {
Type = EoConstant.TYPE_CHANGE_ORDER
});
return(View());
}
public ActionResult InfoProblemsLibrary(int OID)
{
ProblemsLibrary ProblemsLibraryDetail = ProblemsLibraryRepository.SelProblemsLibraryObject(new ProblemsLibrary {
OID = OID
});
ViewBag.OID = ProblemsLibraryDetail.OID;
ViewBag.ProblemsLibraryDetail = ProblemsLibraryDetail;
ViewBag.Status = BPolicyRepository.SelBPolicy(new BPolicy {
Type = EcontentsConstant.TYPE_ECONTENTS
});
return(View(ProblemsLibraryDetail));
}
public static List <Doc> SelDoc(Doc _param)
{
_param.Type = DocumentContant.TYPE_DOCUMENT;
List <Doc> lDoc = DaoFactory.GetList <Doc>("Doc.SelDoc", _param);
lDoc.ForEach(obj =>
{
obj.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = obj.Type, OID = obj.BPolicyOID
}).First();
});
return(lDoc);
}
public static List <ProblemsLibrary> SelProblemsLibrary(ProblemsLibrary _param)
{
_param.Type = EcontentsConstant.TYPE_ECONTENTS;
//_param.StartCreateDt =
List <ProblemsLibrary> lProblemsLibrary = DaoFactory.GetList <ProblemsLibrary>("Econtents.SelProblemsLibrary", _param);
lProblemsLibrary.ForEach(obj =>
{
obj.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = obj.Type, OID = obj.BPolicyOID
}).First();
});
return(lProblemsLibrary);
}
public JsonResult SelectCalendar()
{
List <Calendar> lCalendar = DaoFactory.GetList <Calendar>("Manage.SelCalendar", new Calendar {
Type = CommonConstant.TYPE_CALENDAR
});
lCalendar.ForEach(obj =>
{
obj.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = obj.Type, OID = obj.BPolicyOID
}).First();
});
return(Json(lCalendar));
}
public static List <PmsProject> SelPmsObjects(PmsProject _param)
{
if (_param.Type == null)
{
_param.Type = PmsConstant.TYPE_PROJECT;
}
List <PmsProject> lPmsProject = DaoFactory.GetList <PmsProject>("Pms.SelPmsProject", _param);
lPmsProject.ForEach(dObj =>
{
dObj.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = dObj.Type, OID = dObj.BPolicyOID
}).First();
});
return(lPmsProject);
}
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 ActionResult InfoEPart(int OID)
{
ViewBag.OID = OID;
EPart InfoEPart = EPartRepository.SelEPartObject(new EPart {
OID = OID
});
Library MaterialKey = LibraryRepository.SelLibraryObject(new Library {
Name = "PSIZE"
});
List <Library> MaterialList = LibraryRepository.SelLibrary(new Library {
FromOID = MaterialKey.OID
});
ViewBag.MaterialList = MaterialList;
Library prodstrKey = LibraryRepository.SelLibraryObject(new Library {
Name = "PROD_STRUCTURE"
});
List <Library> prodstrList = LibraryRepository.SelLibrary(new Library {
FromOID = prodstrKey.OID
});
ViewBag.prodstrList = prodstrList;
if (InfoEPart.Prod_Lib_Lev2_OID != null && InfoEPart.Prod_Lib_Lev2_OID > 0)
{
ViewBag.PROD_LIBLv2 = LibraryRepository.SelLibrary(new Library {
FromOID = InfoEPart.Prod_Lib_Lev1_OID
});
}
if (InfoEPart.Prod_Lib_Lev3_OID != null && InfoEPart.Prod_Lib_Lev3_OID > 0)
{
ViewBag.PROD_LIBLv3 = LibraryRepository.SelLibrary(new Library {
FromOID = InfoEPart.Prod_Lib_Lev2_OID
});
}
ViewBag.Status = BPolicyRepository.SelBPolicy(new BPolicy {
Type = EBomConstant.TYPE_PART
});
return(View(InfoEPart));
}
public static ECO SelChangeOrderObject(ECO _param)
{
_param.Type = EoConstant.TYPE_CHANGE_ORDER;
ECO lECO = DaoFactory.GetData <ECO>("ChangeOrder.SelChangeOrder", _param);
lECO.Oem_Lib_OID_KorNm = LibraryRepository.SelLibraryObject(new Library {
OID = lECO.Oem_Lib_OID
}).KorNm;
lECO.Car_Lib_OID_KorNm = LibraryRepository.SelLibraryObject(new Library {
OID = lECO.Car_Lib_OID
}).KorNm;
lECO.Pms_OID_KorNm = LibraryRepository.SelLibraryObject(new Library {
OID = lECO.Pms_OID
}).KorNm;
lECO.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = lECO.Type, OID = lECO.BPolicyOID
}).First();
return(lECO);
}
public static ECR SelChangeRequestObject(ECR _param)
{
_param.Type = EoConstant.TYPE_CHANGE_REQUEST;
ECR lECR = DaoFactory.GetData <ECR>("ChangeRequest.SelChangeRequest", _param);
lECR.Oem_Lib_Nm = LibraryRepository.SelLibraryObject(new Library {
OID = lECR.Oem_Lib_OID
}).KorNm;
lECR.Car_Lib_Nm = LibraryRepository.SelLibraryObject(new Library {
OID = lECR.Car_Lib_OID
}).KorNm;
lECR.Pms_Nm = LibraryRepository.SelLibraryObject(new Library {
OID = lECR.Pms_OID
}).KorNm;
lECR.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = lECR.Type, OID = lECR.BPolicyOID
}).First();
return(lECR);
}
public static List <ECO> SelChangeOrder(ECO _param)
{
_param.Type = EoConstant.TYPE_CHANGE_ORDER;
List <ECO> lECO = DaoFactory.GetList <ECO>("ChangeOrder.SelChangeOrder", _param);
lECO.ForEach(obj =>
{
obj.Oem_Lib_OID_KorNm = LibraryRepository.SelLibraryObject(new Library {
OID = obj.Oem_Lib_OID
}).KorNm;
obj.Car_Lib_OID_KorNm = LibraryRepository.SelLibraryObject(new Library {
OID = obj.Car_Lib_OID
}).KorNm;
obj.Pms_OID_KorNm = LibraryRepository.SelLibraryObject(new Library {
OID = obj.Pms_OID
}).KorNm;
obj.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = obj.Type, OID = obj.BPolicyOID
}).First();
});
return(lECO);
}
public static List <ECR> SelChangeRequest(ECR _param)
{
_param.Type = EoConstant.TYPE_CHANGE_REQUEST;
List <ECR> lECR = DaoFactory.GetList <ECR>("ChangeRequest.SelChangeRequest", _param);
lECR.ForEach(obj =>
{
obj.Oem_Lib_Nm = LibraryRepository.SelLibraryObject(new Library {
OID = obj.Oem_Lib_OID
}).KorNm;
obj.Car_Lib_Nm = LibraryRepository.SelLibraryObject(new Library {
OID = obj.Car_Lib_OID
}).KorNm;
obj.Pms_Nm = LibraryRepository.SelLibraryObject(new Library {
OID = obj.Pms_OID
}).KorNm;
obj.BPolicy = BPolicyRepository.SelBPolicy(new BPolicy {
Type = obj.Type, OID = obj.BPolicyOID
}).First();
});
return(lECR);
}
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);
}
