// GET: Work public ActionResult Index() { WorkDAC dac = new WorkDAC(); ViewBag.PQ = dac.GetProductQTYBYFclt(); ViewBag.fcount = dac.GetCountFcltWork(); ViewBag.Icount = dac.GetCountInstack(); ViewBag.ItemCount = dac.GetCountITEM(); return(View()); }
public List <WorkVO> GetAllWork() { WorkDAC dac = new WorkDAC(); return(dac.GetAllWork()); }
public ActionResult Member() { //Bar chart 일을 많이한 사원 데이터 뽑기 WorkDAC dac = new WorkDAC(); List <WorkVO> AllList = new List <WorkVO>(); AllList = dac.GetAllWork(); List <string> Name = new List <string>(); Name = (from it in AllList select it.USER_NAME).ToList(); List <int> time = new List <int>(); time = (from a in AllList select Convert.ToInt32(a.work_time)).ToList(); string data1 = string.Empty; for (int t = 0; t < time.Count; t++) { data1 += Name[t] + "," + time[t] + ","; } data1 = data1.TrimEnd(','); ViewBag.data1 = data1; // Pie chart List <ProceessCodeWorkVO> pieList = new List <ProceessCodeWorkVO>(); pieList = dac.GetProcessList(); List <string> process = new List <string>(); process = (from b in pieList select b.Process_Code).ToList(); List <int> ProcessTime = new List <int>(); ProcessTime = (from p_time in pieList select Convert.ToInt32(p_time.work_time)).ToList(); string data2 = string.Empty; string PCode = string.Empty; for (int i = 0; i < ProcessTime.Count; i++) { data2 += ProcessTime[i].ToString() + ","; } for (int q = 0; q < process.Count; q++) { PCode += process[q] + ","; } data2 = data2.TrimEnd(','); PCode = PCode.TrimEnd(','); ViewBag.data2 = data2; ViewBag.PCode = PCode; //Bar chart 매달마다 일 많이 한 인원 List <yearChartVO> yearList = new List <yearChartVO>(); yearList = dac.GetYearChart(); StringBuilder sb = new StringBuilder(); List <string> NameList = (from name in yearList select name.User_Name).ToList(); //List<decimal> dataList1 = (from data in yearList // select data.work_time).ToList(); //List<decimal> dataList2 = (from data in yearList // select data.work_time).ToList(); //List<decimal> dataList3 = (from data in yearList // select data.work_time).ToList(); string bardata1 = string.Empty; string bardata2 = string.Empty; string bardata3 = string.Empty; //foreach (var bardata in dataList1) //{ // bardata1 = "[" + string.Join(",", dataList1.ToArray()) + "]"; // bardata2 = "[" + string.Join(",", dataList2.ToArray()) + "]"; // bardata3 = "[" + string.Join(",", dataList3.ToArray()) + "]"; //} for (int u = 1; u < 13; u++) { sb.Append(u + "월,"); } for (int p = 0; p < yearList.Count; p++) { if (p % 3 == 1) { bardata2 += yearList[p].work_time.ToString() + ","; } else if (p % 3 == 2) { bardata3 += yearList[p].work_time.ToString() + ","; } else if (p % 3 == 0) { bardata1 += yearList[p].work_time.ToString() + ","; } } string barName1 = NameList[0]; string barName2 = NameList[1]; string barName3 = NameList[2]; ViewBag.Labels = sb.ToString().TrimEnd(','); ViewBag.Name1 = barName1; ViewBag.Name2 = barName2; ViewBag.Name3 = barName3; ViewBag.bardata1 = "[" + bardata1.TrimEnd(',') + "]"; ViewBag.bardata2 = "[" + bardata2.TrimEnd(',') + "]"; ViewBag.bardata3 = "[" + bardata3.TrimEnd(',') + "]"; return(View()); }