public async Task <ActionResult> ReportCover(BasicSurveyReportViewModel paramModel) { ViewBag.naviLeftMenu = Global.Report; ViewBag.paramModel = paramModel; if (paramModel.CompSn == 0 || paramModel.NumSn == "0") { return(View(paramModel)); } var vcCompInfoObj = await vcCompInfoService.getVcCompInfoByCompSn(paramModel.CompSn); paramModel.CompNm = vcCompInfoObj.CompNm; paramModel.BizWorkNm = ""; //var scCompMapping = await scCompMappingService.GetCompMappingAsync(paramModel.NumSn, paramModel.CompSn); //paramModel.CompNm = scCompMapping.ScCompInfo.CompNm; //paramModel.BizWorkNm = scCompMapping.ScBizWork.BizWorkNm; ViewBag.CompNm = paramModel.CompNm; ViewBag.paramModel = paramModel; ViewBag.NumSn = paramModel.NumSn; ViewBag.CompSn = paramModel.CompSn; ViewBag.BizWorkYear = paramModel.BizWorkYear; ViewBag.Status = paramModel.Status; ViewBag.QuestionSn = paramModel.QuestionSn; //ViewBag.NullCheck = paramModel.NullCheck; return(View(paramModel)); }
public async Task <ActionResult> BasicSurveyCover(BasicSurveyReportViewModel paramModel, int curPage = 0) { ViewBag.LeftMenu = Global.Report; if (paramModel.CompSn == 0 || paramModel.BizWorkSn == 0) { return(View(paramModel)); } var scCompMapping = await scCompMappingService.GetCompMappingAsync(paramModel.BizWorkSn, paramModel.CompSn); paramModel.CompNm = scCompMapping.ScCompInfo.CompNm; paramModel.BizWorkNm = scCompMapping.ScBizWork.BizWorkNm; var rptMaster = scCompMapping.ScCompInfo.RptMasters.Where(rm => rm.BasicYear == paramModel.BizWorkYear && rm.BizWorkSn == paramModel.BizWorkSn && rm.CompSn == paramModel.CompSn).SingleOrDefault(); paramModel.QuestionSn = rptMaster.QuestionSn; paramModel.Status = rptMaster.Status; var rptMaters = scCompMapping.ScCompInfo.RptMasters.Where(rm => rm.BizWorkSn == paramModel.BizWorkSn && rm.Status == "C").ToList(); ViewBag.SelectReportYearList = ReportHelper.MakeBasicSurveyYear(rptMaters, paramModel.BizWorkYear); return(View(paramModel)); }
public async Task <ActionResult> BasicSurveyReport(BasicSurveyReportViewModel paramModel, string curPage) { ViewBag.LeftMenu = Global.Report; //사업관리기관 DownDown List Data var loginId = Session[Global.LoginID].ToString(); var expertMappings = await scExpertMappingService.GetExpertsAsync(loginId); var bizMngList = expertMappings.Select(s => s.ScBizWork.ScCompInfo).GroupBy(s => new { s.CompSn, s.CompNm }); var bizWorkMngr = new List <SelectListItem>(); bizWorkMngr.Add(new SelectListItem { Value = "0", Text = "사업관리기관 선택", Selected = true }); if (bizMngList != null) { foreach (var item in bizMngList) { bizWorkMngr.Add(new SelectListItem { Value = item.Key.CompSn.ToString(), Text = item.Key.CompNm.ToString() }); } } SelectList list = new SelectList(bizWorkMngr, "Value", "Text"); ViewBag.SelectBizWorkMngrList = list; //사업 DropDown List Data if (paramModel.BizWorkMngr == 0) { ViewBag.SelectBizWorkList = ReportHelper.MakeBizWorkList(null); } else { var bizWorkList = expertMappings.Where(i => i.ScBizWork.MngCompSn == paramModel.BizWorkMngr).Select(s => s.ScBizWork).ToList(); ViewBag.SelectBizWorkList = ReportHelper.MakeBizWorkList(bizWorkList); } //기초역량 보고서 조회 int pagingSize = int.Parse(ConfigurationManager.AppSettings["PagingSize"]); var rptMsters = await rptMasterService.GetRptMasterListForExpert(int.Parse(curPage ?? "1"), pagingSize, loginId, paramModel.BizWorkSn, paramModel.BizWorkMngr, "C"); //뷰모델 맵핑 var rptMasterListView = Mapper.Map <List <BasicSurveyReportViewModel> >(rptMsters); return(View(new StaticPagedList <BasicSurveyReportViewModel>(rptMasterListView, int.Parse(curPage ?? "1"), pagingSize, rptMsters.TotalItemCount))); }
public async Task <ActionResult> BasicSurveyReport(BasicSurveyReportViewModel paramModel, string curPage) { ViewBag.naviLeftMenu = Global.Report; int pagingSize = int.Parse(ConfigurationManager.AppSettings["PagingSize"]); int pageSize = int.Parse(ConfigurationManager.AppSettings["PagingSize"]); var listPageView = await tcmsCompStatusSelectViewService.getTcmsByWriteBa("Y"); var selectCompViews = Mapper.Map <List <BasicSurveyReportViewModel> >(listPageView); string[] nCheckArray = new string[listPageView.Count]; //var testview = await vcMentorMappingService.getVcMentorMappingByCompSn(listPageView[i].CompSn); if (listPageView.Count > 0) { for (int i = 0; i < nCheckArray.Length; i++) { var obj = await vcMentorMappingService.GetCompSnForTcms(Convert.ToString(listPageView[i].CompSn), Convert.ToString(listPageView[i].BaSn), listPageView[i].NumSn, listPageView[i].SubNumSn, listPageView[i].ConCode); if (obj == null) { nCheckArray[i] = null; } else { selectCompViews[i].MentorSn = Convert.ToString(obj.MentorSn); //mentorsn 저장 var mentorid = await vcUsrInfoService.getMentorInfoBySn(selectCompViews[i].MentorSn); var mentorname = await vcUsrInfoService.selectScUsrByTcms(Convert.ToString(mentorid.TcmsLoginKey)); selectCompViews[i].MentorNm = mentorname.Name; //mentorname 저장 } } } var searchBy = new List <SelectListItem>() { new SelectListItem { Value = "0", Text = "기업명", Selected = true }, new SelectListItem { Value = "1", Text = "전문기관(BA)명" }, }; ViewBag.SelectList = searchBy; ViewBag.ListPageView = listPageView; return(View(new StaticPagedList <BasicSurveyReportViewModel>(selectCompViews.ToPagedList(1, pageSize), 1, pagingSize, selectCompViews.Count))); }
public static CommentViewModel MakeCommentViewModel(BasicSurveyReportViewModel paramModel, string detailCode, RptMentorComment rptMentorComment = null) { CommentViewModel viewModel = new CommentViewModel(); if (rptMentorComment == null) { viewModel.DetailCd = detailCode; viewModel.Comment = ""; } else { viewModel.DetailCd = rptMentorComment.DetailCd; viewModel.Comment = rptMentorComment.Comment; } return(viewModel); }
public async Task <ActionResult> CurrentQueState(BasicSurveyReportViewModel paramModel, string curPage) { ViewBag.LeftMenu = Global.ComMng; //사업년도 DownDown List Data //ViewBag.SelectBizWorkYearList = ReportHelper.MakeYear(2015); var bizWorkYearDropDown = ReportHelper.MakeYear(2015); SelectList bizWorkYear = new SelectList(bizWorkYearDropDown, "Value", "Text"); ViewBag.SelectBizWorkYearList = bizWorkYear; var mentorId = Session[Global.LoginID].ToString(); if (string.IsNullOrEmpty(paramModel.Status)) { paramModel.Status = ""; } //사업 DropDown List Data var listScMentorMapping = await scMentorMappingService.GetMentorMappingListByMentorId(mentorId, paramModel.BizWorkYear); var listScBizWork = listScMentorMapping.Select(mmp => mmp.ScBizWork).ToList(); ViewBag.SelectBizWorkList = ReportHelper.MakeBizWorkList(listScBizWork); var listScCompMapping = await scCompMappingService.GetCompMappingListByMentorId(mentorId, "A", paramModel.BizWorkSn, paramModel.BizWorkYear); var listScCompInfo = listScCompMapping.Select(cmp => cmp.ScCompInfo).ToList(); ViewBag.SelectCompInfoList = ReportHelper.MakeCompanyList(listScCompInfo); ViewBag.SelectStatusList = ReportHelper.MakeReportStatusList(); //기초역량 보고서 조회 int pagingSize = int.Parse(ConfigurationManager.AppSettings["PagingSize"]); // 문진표 작성 완료 후 count var countTest = await _quesMasterService.GetQuesMasterAsync(paramModel.QuestionSn); var rptMsters = await rptMasterService.GetRptMasterList(int.Parse(curPage ?? "1"), pagingSize, mentorId, paramModel.BizWorkYear, paramModel.BizWorkSn, paramModel.CompSn, paramModel.Status); //뷰모델 맵핑 var rptMasterListView = Mapper.Map <List <BasicSurveyReportViewModel> >(rptMsters); return(View(new StaticPagedList <BasicSurveyReportViewModel>(rptMasterListView, int.Parse(curPage ?? "1"), pagingSize, rptMsters.TotalItemCount))); }
public static CheckBoxViewModel MakeCheckBoxViewModel(BasicSurveyReportViewModel paramModel, string detailCode, RptMentorComment rptMentorComment = null) { var viewModel = new CheckBoxViewModel(); Console.WriteLine(detailCode); if (rptMentorComment == null) { viewModel.DetailCd = detailCode; viewModel.CheckVal = false; } else { viewModel.DetailCd = rptMentorComment.DetailCd; viewModel.CheckVal = bool.Parse(rptMentorComment.Comment); } return(viewModel); }
public async Task <ActionResult> BasicSurveyReport(BasicSurveyReportViewModel paramModel, string curPage) { ViewBag.LeftMenu = Global.Report; //사업관리기관 DownDown List Data var bizMngList = await scUsrService.GetBizManagerAsync(); var bizMngDropDown = Mapper.Map <List <BizMngDropDownModel> >(bizMngList); BizMngDropDownModel title = new BizMngDropDownModel(); title.CompSn = 0; title.CompNm = "사업관리기관 선택"; bizMngDropDown.Insert(0, title); SelectList bizList = new SelectList(bizMngDropDown, "CompSn", "CompNm"); ViewBag.SelectBizWorkMngrList = bizList; //사업 DropDown List Data if (paramModel.BizWorkMngr == 0) { ViewBag.SelectBizWorkList = ReportHelper.MakeBizWorkList(null); } else { var listScBizWork = await scBizWorkService.GetBizWorkList(paramModel.BizWorkMngr, null, 0); ViewBag.SelectBizWorkList = ReportHelper.MakeBizWorkList(listScBizWork); } //기초역량 보고서 조회 int pagingSize = int.Parse(ConfigurationManager.AppSettings["PagingSize"]); //var rptMsters = await rptMasterService.GetRptMasterListForSysManager(int.Parse(curPage ?? "1"), pagingSize, paramModel.BizWorkSn, paramModel.BizWorkMngr, "C"); var compMappings = await scCompMappingService.GetPagedListCompMappingsForBasicReportAsync(int.Parse(curPage ?? "1"), pagingSize, paramModel.BizWorkMngr, null, paramModel.BizWorkSn); //뷰모델 맵핑 var rptMasterListView = Mapper.Map <List <BasicSurveyReportViewModel> >(compMappings); return(View(new StaticPagedList <BasicSurveyReportViewModel>(rptMasterListView, int.Parse(curPage ?? "1"), pagingSize, compMappings.TotalItemCount))); }
public async Task <IList <CheckListViewModel> > getGrowthStepPointCheckList(BasicSurveyReportViewModel paramModel, string quesCheckListSmallClassCd) { //사업참여 기업들의 레벨(창업보육, 보육성장, 자립성장) 분류 Dictionary <int, int> dicStartUp = new Dictionary <int, int>(); Dictionary <int, int> dicGrowth = new Dictionary <int, int>(); Dictionary <int, int> dicIndependent = new Dictionary <int, int>(); SqlParameter numSn = new SqlParameter("NUM_SN", paramModel.NumSn); object[] parameters = new object[] { numSn }; var curBizWorkObj = await procMngService.getBizWorkInfoByBizWorkSn(parameters); //var curBizWork = await scBizWorkService.GetBizWorkByBizWorkSn(int.Parse(paramModel.NumSn)); { //var compMappings = curBizWork.ScCompMappings.Where(sc => sc.Status == "A"); foreach (var compMapping in curBizWorkObj) { var quesMasters = await quesMasterService.GetQuesMasterAsync(compMapping.REGISTRATION_NO, paramModel.BizWorkYear); if (quesMasters == null) { continue; } //다래 재무정보 유무 체크하는 로직 추가해야함.(문진표정보, 재무정보가 있어야 보고서 생성가능.) //다래 재무정보 조회해야 함. var scFinancialIndexT = await scFinancialIndexTService.getScFinancialIndexTAsync(compMapping.COMP_SN, paramModel.BizWorkYear.ToString()); if (scFinancialIndexT == null) { continue; } //var sboFinacialIndexT = await sboFinancialIndexTService.GetSHUSER_SboFinancialIndexT(compMapping.ScCompInfo.RegistrationNo, ConfigurationManager.AppSettings["CorpCode"], ConfigurationManager.AppSettings["BizCode"], paramModel.BizWorkYear.ToString()); //if (sboFinacialIndexT == null) //{ // continue; //} //종합점수 조회하여 분류별로 딕셔너리 저장 var point = await GetCompanyTotalPoint(quesMasters.QuestionSn, scFinancialIndexT); if (point >= 0 && point <= 50) { dicStartUp.Add(compMapping.COMP_SN, quesMasters.QuestionSn); } else if (point > 50 && point <= 75) { dicGrowth.Add(compMapping.COMP_SN, quesMasters.QuestionSn); } else { dicIndependent.Add(compMapping.COMP_SN, quesMasters.QuestionSn); } } } //리스트 데이터 생성 var quesResult1s = await quesResult1Service.GetQuesResult1sAsync(paramModel.QuestionSn, quesCheckListSmallClassCd); int count = 1; var CheckList = new List <CheckListViewModel>(); foreach (var item in quesResult1s) { CheckListViewModel checkListViewModel = new CheckListViewModel(); checkListViewModel.Count = count.ToString(); checkListViewModel.AnsVal = item.AnsVal.Value; checkListViewModel.DetailCd = item.QuesCheckList.DetailCd; checkListViewModel.Title = item.QuesCheckList.ReportTitle; //창업보육단계 평균 int startUpCnt = await GetCheckListCnt(dicStartUp, checkListViewModel.DetailCd); checkListViewModel.StartUpAvg = Math.Round(((startUpCnt + item.QuesCheckList.StartUpStep.Value + 0.0) / (50 + dicStartUp.Count)) * 100, 0).ToString(); //보육성장단계 평균 int growthCnt = await GetCheckListCnt(dicGrowth, checkListViewModel.DetailCd); checkListViewModel.GrowthAvg = Math.Round(((growthCnt + item.QuesCheckList.GrowthStep.Value + 0.0) / (46 + dicGrowth.Count)) * 100, 0).ToString(); //자립성장단계 평균 int IndependentCnt = await GetCheckListCnt(dicIndependent, checkListViewModel.DetailCd); checkListViewModel.IndependentAvg = Math.Round(((IndependentCnt + item.QuesCheckList.IndependentStep.Value + 0.0) / (4 + dicIndependent.Count)) * 100, 0).ToString(); //참여기업 평균 checkListViewModel.BizInCompanyAvg = Math.Round(((IndependentCnt + growthCnt + startUpCnt + 0.0) / (dicStartUp.Count + dicGrowth.Count + dicIndependent.Count)) * 100, 0).ToString(); //전체 평균 checkListViewModel.TotalAvg = Math.Round(((IndependentCnt + growthCnt + startUpCnt + item.QuesCheckList.TotalStep.Value + 0.0) / (100 + dicStartUp.Count + dicGrowth.Count + dicIndependent.Count)) * 100, 0).ToString(); CheckList.Add(checkListViewModel); count++; } return(CheckList); }
public static RptMentorComment MakeRptMentorcomment(CheckBoxViewModel viewModel, BasicSurveyReportViewModel paramModel) { RptMentorComment rptComment = new RptMentorComment(); rptComment.DetailCd = viewModel.DetailCd; rptComment.Comment = viewModel.CheckVal.ToString(); rptComment.BasicYear = paramModel.BizWorkYear; rptComment.BizWorkSn = paramModel.BizWorkSn; rptComment.QuestionSn = paramModel.QuestionSn; return(rptComment); }
public async Task<ActionResult> BasicSurveyReport(BasicSurveyReportViewModel paramModel, string curPage) { ViewBag.LeftMenu = Global.Report; //사업년도 DownDown List Data //ViewBag.SelectBizWorkYearList = ReportHelper.MakeYear(2015); var bizWorkYearDropDown = ReportHelper.MakeYear(2015); SelectList bizWorkYear = new SelectList(bizWorkYearDropDown, "Value", "Text"); ViewBag.SelectBizWorkYearList = bizWorkYear; var mentorId = Session[Global.LoginID].ToString(); if (string.IsNullOrEmpty(paramModel.Status)) paramModel.Status = ""; //사업 DropDown List Data var listScMentorMapping = await scMentorMappingService.GetMentorMappingListByMentorId(mentorId, paramModel.BizWorkYear); var listScBizWork = listScMentorMapping.Select(mmp => mmp.ScBizWork).ToList(); ViewBag.SelectBizWorkList = ReportHelper.MakeBizWorkList(listScBizWork); var listScCompMapping = await scCompMappingService.GetCompMappingListByMentorId(mentorId, "A", paramModel.BizWorkSn, paramModel.BizWorkYear); var listScCompInfo = listScCompMapping.Select(cmp => cmp.ScCompInfo).ToList(); ViewBag.SelectCompInfoList = ReportHelper.MakeCompanyList(listScCompInfo); ViewBag.SelectStatusList = ReportHelper.MakeReportStatusList(); var scCompMapping = await scCompMappingService.GetCompMappingAsync(paramModel.BizWorkSn, paramModel.CompSn); //scCompMapping.ScCompInfo. //var statusForCom = await sc //기초역량 보고서 조회 int pagingSize = int.Parse(ConfigurationManager.AppSettings["PagingSize"]); //// 문진표 작성 완료 후 count //var countTest = await _quesMasterService.GetQuesMasterAsync(paramModel.QuestionSn); var rptMsters = await rptMasterService.GetRptMasterList(int.Parse(curPage ?? "1"), pagingSize, mentorId, paramModel.BizWorkYear, paramModel.BizWorkSn, paramModel.CompSn, paramModel.Status); //var rptMaters2 = scCompMapping.ScCompInfo.RptMasters.Where(rm => rm.BasicYear == paramModel.BizWorkYear && rm.BizWorkSn == paramModel.BizWorkSn && rm.CompSn == paramModel.CompSn).SingleOrDefault(); // QuesMaster -> stauts ="C"인 애들만 mapping var quesMaster = await _quesMasterService.GetQuesMasterAsync(paramModel.RegistrationNo, paramModel.BizWorkYear); var quesMasterP = await _quesMasterService.GetQuesMasterAsyncPro(paramModel.RegistrationNo, paramModel.BizWorkYear); //paramModel.CompleteCount = 0; //paramModel.NotYetCountForMentor = 0; //paramModel.TotalCountForMentor = 0; // 추가적으로 for 문 돌리거나 그냥 viewModel에 direct로 박아주는 방법 //if(quesMaster.Status == "C") //{ // paramModel.CompleteCount++; //} //else //{ // paramModel.NotYetCountForMentor++; //} // 전체 기업 수 count //var a = quesMaster.Status; //var b = quesMaster.QuesCompInfo; //paramModel.Status = quesMaster.Status; paramModel.TotalCountForMentor = listScCompMapping.Count; // var a = rptMsters.Subset; //뷰모델 맵핑 var rptMasterListView = Mapper.Map<List<BasicSurveyReportViewModel>>(rptMsters); return View(new StaticPagedList<BasicSurveyReportViewModel>(rptMasterListView, int.Parse(curPage ?? "1"), pagingSize, rptMsters.TotalItemCount)); }