/// <summary> /// 기술경영,마케팅 /// </summary> public async Task <double> GetTechMng(int questionSn, ScFinancialIndexT sboFinancialIndexT) { //산식엑셀 1-8 ~ 1-17 double totalPoint = 0; double preReserchAmt = 0.0; // 전기 연구개발비 var rpt = rptMasterService.GetRptMasterByQuestionSn(questionSn); // QuestionSn 기준으로 CompSn 가져오기 var pre = scCompanyFinanceService.getScCompanyFinance(rpt.CompSn, int.Parse(sboFinancialIndexT.Year) - 1); // CompSn과 Year를 기준으로 입력된 D-1년도 재무제표 데이터 가져오기 if (pre != null) { preReserchAmt = Convert.ToDouble(pre.CiOrdevexp + pre.CiResearch + pre.McRndexp); } // 연구개발 투자 { double avg = 0D; double numerator = (Convert.ToDouble(sboFinancialIndexT.ReserchAmt) + preReserchAmt) / 2.0; double denominator = Convert.ToDouble(sboFinancialIndexT.CurrentSale); if (denominator != 0) // 매출액 있을 때 { if (numerator == 0) // 연구개발비가 0이면 { avg = 0; } else // 연구개발비가 0이 아니면 { avg = (numerator / denominator) * 100; } } else // 매출액이 0일 때 { if (numerator != 0) // 연구개발비가 있으면 { avg = 3D; // 최고점 } else // 연구개발비가 0이면 { avg = 0; } } totalPoint = totalPoint + ReportHelper.CalcPoint(ReportHelper.GetCodeTypeM(avg), 2); } //연구개발 인력의 비율 var quesResult2sEmpRate = await quesResult2Service.GetQuesResult2sAsync(questionSn, "A1B102"); //전체임직원수 var TotalEmp = quesResult2sEmpRate.SingleOrDefault(i => i.QuesCheckList.DetailCd == "A1B10202"); //연구개발인력 var RndEmp = quesResult2sEmpRate.SingleOrDefault(i => i.QuesCheckList.DetailCd == "A1B10201"); if (TotalEmp != null) { if (int.Parse(TotalEmp.D) != 0) { double avg = (int.Parse(RndEmp.D) / double.Parse(TotalEmp.D)) * 100; totalPoint = totalPoint + ReportHelper.CalcPoint(ReportHelper.GetCodeTypeE(avg), 1); } } //연구개발 인력의 능력 var quesResult2sEmpCapa = await quesResult2Service.GetQuesResult2sAsync(questionSn, "A1B103"); //박사급 var DoctorEmp = quesResult2sEmpCapa.SingleOrDefault(i => i.QuesCheckList.DetailCd == "A1B10301"); //석사급 var MasterEmp = quesResult2sEmpCapa.SingleOrDefault(i => i.QuesCheckList.DetailCd == "A1B10302"); //학사급 var CollegeEmp = quesResult2sEmpCapa.SingleOrDefault(i => i.QuesCheckList.DetailCd == "A1B10303"); //기능사급 var TechEmp = quesResult2sEmpCapa.SingleOrDefault(i => i.QuesCheckList.DetailCd == "A1B10304"); //고졸이하급 var HighEmp = quesResult2sEmpCapa.SingleOrDefault(i => i.QuesCheckList.DetailCd == "A1B10305"); if ((int.Parse(DoctorEmp.D) + int.Parse(MasterEmp.D) + int.Parse(CollegeEmp.D) + int.Parse(TechEmp.D) + int.Parse(HighEmp.D)) != 0) { double avg = ((int.Parse(DoctorEmp.D) * 5) + (int.Parse(MasterEmp.D) * 4) + (int.Parse(CollegeEmp.D) * 3) + (int.Parse(TechEmp.D) * 2) + (int.Parse(HighEmp.D) * 1)) / (double.Parse(DoctorEmp.D) + double.Parse(MasterEmp.D) + double.Parse(CollegeEmp.D) + double.Parse(TechEmp.D) + double.Parse(HighEmp.D)); totalPoint = totalPoint + ReportHelper.CalcPoint(ReportHelper.GetCodeTypeE(avg), 3); } // A1B104 : 사업화역량 var quesResult1sBizCapa = await quesResult1Service.GetQuesResult1sAsync(questionSn, "A1B104"); totalPoint = totalPoint + ReportHelper.CalcPoint(ReportHelper.GetCodeTypeC(ReportHelper.CalcCheckCount(quesResult1sBizCapa)), 5); // A1B105 : 사업화실적 var quesResult2sBizResult = await quesResult2Service.GetQuesResult2sAsync(questionSn, "A1B105"); //사업화실적 총 건수 var BizResultCnt = quesResult2sBizResult.SingleOrDefault(i => i.QuesCheckList.DetailCd == "A1B10502"); { double avg = (int.Parse(BizResultCnt.D) + int.Parse(BizResultCnt.D451) + int.Parse(BizResultCnt.D452)) / 3.0; totalPoint = totalPoint + ReportHelper.CalcPoint(ReportHelper.GetCodeTypeE(avg), 4); } // A1B106 : 생산설비의 운영체제 및 관리 var quesResult1sFacMng = await quesResult1Service.GetQuesResult1sAsync(questionSn, "A1B106"); totalPoint = totalPoint + ReportHelper.CalcPoint(ReportHelper.GetCodeTypeA(ReportHelper.CalcCheckCount(quesResult1sFacMng)), 2); // A1B107 : 공정관리 var quesResult1sProcess = await quesResult1Service.GetQuesResult1sAsync(questionSn, "A1B107"); totalPoint = totalPoint + ReportHelper.CalcPoint(ReportHelper.GetCodeTypeC(ReportHelper.CalcCheckCount(quesResult1sProcess)), 2); // A1B108 : 품질관리 var quesResult1sQaMng = await quesResult1Service.GetQuesResult1sAsync(questionSn, "A1B108"); totalPoint = totalPoint + ReportHelper.CalcPoint(ReportHelper.GetCodeTypeC(ReportHelper.CalcCheckCount(quesResult1sQaMng)), 3); // A1C101 : 마케팅 전략의 수립 및 실행 var quesResult1sMarketing = await quesResult1Service.GetQuesResult1sAsync(questionSn, "A1C101"); totalPoint = totalPoint + ReportHelper.CalcPoint(ReportHelper.GetCodeTypeG(ReportHelper.CalcCheckCount(quesResult1sMarketing)), 8); // A1C102 : 고객관리 var quesResult1sCustMng = await quesResult1Service.GetQuesResult1sAsync(questionSn, "A1C102"); totalPoint = totalPoint + ReportHelper.CalcPoint(ReportHelper.GetCodeTypeA(ReportHelper.CalcCheckCount(quesResult1sCustMng)), 9); return(totalPoint); }