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));
}
