//public async Task<ActionResult> BizWorkList()
//{
// ViewBag.LeftMenu = Global.BizWorkMng;
// var listScBizWork = await _scBizWorkService.GetBizWorkList(int.Parse(Session[Global.CompSN].ToString()));
// var bizWorkViews =
// Mapper.Map<List<BizWorkViewModel>>(listScBizWork);
// int bizCount = bizWorkViews.Count;
// int curPage = 1;
// int pagingSize = int.Parse(ConfigurationManager.AppSettings["PagingSize"]);
// // bizWorkViews에 존재하는 사업 count
// for (int i = 0; i < bizCount; i++)
// {
// var bizWorkSn = bizWorkViews[i].BizWorkSn;
// var pagedListScBizWork = await _scBizWorkService.GetPagedListBizWorkComList(bizWorkSn, curPage, pagingSize);
// var compCount = pagedListScBizWork.TotalItemCount;
// bizWorkViews[i].ComCount = Convert.ToString(compCount);
// }
// // bizWorkVies.Count : 총 사업에 대한 count
// return View(new StaticPagedList<BizWorkViewModel>(bizWorkViews.ToPagedList(1, pagingSize), 1, pagingSize, bizWorkViews.Count));
//}
//[HttpPost]
//public async Task<ActionResult> BizWorkList(string Query, string curPage)
//{
// ViewBag.LeftMenu = Global.BizWorkMng;
// //var listScNtc = _scNtcService.GetNotices(SelectList, Query);
// var listScBizWork = await _scBizWorkService.GetBizWorkListByBizWorkNm(int.Parse(Session[Global.CompSN].ToString()), Query);
// var bizWorkViews = Mapper.Map<List<BizWorkViewModel>>(listScBizWork);
// int pagingSize = int.Parse(ConfigurationManager.AppSettings["PagingSize"]);
// int bizCount = bizWorkViews.Count;
// for (int i = 0; i < bizCount; i++)
// {
// var bizWorkSn = bizWorkViews[i].BizWorkSn;
// var pagedListScBizWork = await _scBizWorkService.GetPagedListBizWorkComList(bizWorkSn, int.Parse(curPage), pagingSize);
// var compCount = pagedListScBizWork.TotalItemCount;
// bizWorkViews[i].ComCount = Convert.ToString(compCount);
// }
// return View(new StaticPagedList<BizWorkViewModel>(bizWorkViews.ToPagedList(int.Parse(curPage), pagingSize), int.Parse(curPage), pagingSize, bizWorkViews.Count));
//}
//public async Task<ActionResult> BizWorkComList(string bizWorkSn, string bizWorkNm, string curPage)
//{
// ViewBag.LeftMenu = Global.BizWorkMng;
// ViewBag.BizWorkNm = bizWorkNm;
// int pagingSize = int.Parse(ConfigurationManager.AppSettings["PagingSize"]);
// var pagedListScBizWork = await _scBizWorkService.GetPagedListBizWorkComList(int.Parse(bizWorkSn), int.Parse(curPage ?? "1"), pagingSize);
// var comListViews =
// Mapper.Map<List<JoinCompanyViewModel>>(pagedListScBizWork);
// ViewBag.BizWorkSN = bizWorkSn;
// return View(new StaticPagedList<JoinCompanyViewModel>(comListViews, pagedListScBizWork.PageNumber, pagingSize, pagedListScBizWork.TotalItemCount));
//}
public async Task <ActionResult> BizWorkDetail(string bizWorkSn)
{
ViewBag.LeftMenu = Global.BizWorkMng;
var scBizWork = await _scBizWorkService.GetBizWorkByBizWorkSn(int.Parse(bizWorkSn));
var bizWorkViews =
Mapper.Map <BizWorkViewModel>(scBizWork);
return(View(bizWorkViews));
}
public async Task <ActionResult> BizWorkDetail(string bizWorkSn)
{
ViewBag.LeftMenu = Global.BizWorkMng;
//var listScNtc = _scNtcService.GetNotices(SelectList, Query);
var scBizWork = await _scBizWorkService.GetBizWorkByBizWorkSn(int.Parse(bizWorkSn));
var bizWorkViews =
Mapper.Map <BizWorkViewModel>(scBizWork);
return(View(bizWorkViews));
}
public async Task <JsonResult> GetMonth(string Year, int CompSn, int BizWorkSn)
{
if (Session[Global.UserType].Equals(Global.Company))
{// 기업회원
var month = ReportHelper.MakeMonth(int.Parse(Year));
return(Json(month));
}
else
{
var scBizWork = await _scBizWorkService.GetBizWorkByBizWorkSn(BizWorkSn);
var month = ReportHelper.MakeBizMonth(scBizWork, int.Parse(Year));
return(Json(month));
}
}
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>();
ReportUtil reportUtil = new ReportUtil(scBizWorkService, quesResult1Service, quesResult2Service, quesMasterService, sboFinancialIndexTService, scCavService, scCompanyFinanceService, rptMasterService, scFinancialIndexTService, procMngService);
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;
}
double point = 0.0;
//int companySn = compMapping.ScCompInfo.CompSn;
//VcUsrInfo companyUserInfo = await scUsrService.getScUsrByCompSn(companySn);
//int CompSn = companyUserInfo.CompSn;
//string UseErp = companyUserInfo.UseErp;
//다래 재무정보 유무 체크하는 로직 추가해야함.(문진표정보, 재무정보가 있어야 보고서 생성가능.)
//다래 재무정보 조회해야 함.
//if (compMapping.ScUsr.UseErp.ToString() == "1") // ERP 사용
//{
// //var sboFinacialIndexT = await sboFinancialIndexTService.GetSHUSER_SboFinancialIndexT(compMapping.ScCompInfo.RegistrationNo, ConfigurationManager.AppSettings["CorpCode"], ConfigurationManager.AppSettings["BizCode"], paramModel.BizWorkYear.ToString());
// //if (sboFinacialIndexT == null) continue;
// //point = await reportUtil.GetCompanyTotalPoint(quesMasters.QuestionSn, sboFinacialIndexT);
//}
//else
//{
var scFinancialIndexT = await scFinancialIndexTService.getScFinancialIndexTAsync(compMapping.COMP_SN, paramModel.BizWorkYear.ToString());
if (scFinancialIndexT == null)
{
continue;
}
//종합점수 조회하여 분류별로 딕셔너리 저장
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 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>();
var curBizWork = await scBizWorkService.GetBizWorkByBizWorkSn(paramModel.BizWorkSn);
{
var compMappings = curBizWork.ScCompMappings;
foreach (var compMapping in compMappings)
{
var quesMasters = await quesMasterService.GetQuesMasterAsync(compMapping.ScCompInfo.RegistrationNo, paramModel.BizWorkYear);
if (quesMasters == 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, sboFinacialIndexT);
if (point >= 0 && point <= 50)
{
dicStartUp.Add(compMapping.CompSn, quesMasters.QuestionSn);
}
else if (point > 50 && point <= 75)
{
dicGrowth.Add(compMapping.CompSn, quesMasters.QuestionSn);
}
else
{
dicIndependent.Add(compMapping.CompSn, 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) / (39 + dicStartUp.Count + dicGrowth.Count + dicIndependent.Count)) * 100, 0).ToString();
//보육성장단계 평균
int growthCnt = await GetCheckListCnt(dicGrowth, checkListViewModel.DetailCd);
checkListViewModel.GrowthAvg = Math.Round(((growthCnt + item.QuesCheckList.GrowthStep.Value + 0.0) / (39 + dicStartUp.Count + dicGrowth.Count + dicIndependent.Count)) * 100, 0).ToString();
//자립성장단계 평균
int IndependentCnt = await GetCheckListCnt(dicIndependent, checkListViewModel.DetailCd);
checkListViewModel.IndependentAvg = Math.Round(((IndependentCnt + item.QuesCheckList.IndependentStep.Value + 0.0) / (39 + dicStartUp.Count + dicGrowth.Count + 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) / (39 + dicStartUp.Count + dicGrowth.Count + dicIndependent.Count)) * 100, 0).ToString();
CheckList.Add(checkListViewModel);
count++;
}
return(CheckList);
}
