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