void serviceClient_GetEducationPieEmployeeceInfoCompleted(object sender, GetEducationPieEmployeeceInfoCompletedEventArgs e) { if (e.Error != null) { MessageBox.Show("错误信息:" + e.Error.ToString()); } else { if (e.Result != null) { //得到员工数据 var employeeInfo = from p in e.Result select p; List<PieEmployeece> employeeceList = new List<PieEmployeece>(); // 0、1、2、3表示大专及以下 int CountEmployeece = employeeInfo.Where(T => (T.Education == "0" || T.Education == "1" || T.Education == "2" || T.Education == "3")).Count(); ; //分组查询 var employee = from p in employeeInfo orderby p.Education group p by p.Education into g select new PieEmployeece { Education = g.Key, CountEmployeece = g.Count() }; int employeece = 0; //分解数据 foreach (var item in employee) { PieEmployeece pieEmployeece = new PieEmployeece(); // 0、1、2、3表示大专及以下/ 4:本科/5: 硕士/6: 博士 if (CountEmployeece > 0 && employeece==0) { pieEmployeece.Education = "大专及以下"; //人数 pieEmployeece.CountEmployeece = CountEmployeece; employeece = 1; employeeceList.Add(pieEmployeece); } else if (item.Education == "4") { pieEmployeece.Education ="本科"; //人数 pieEmployeece.CountEmployeece = item.CountEmployeece; employeeceList.Add(pieEmployeece); } else if (item.Education == "5") { pieEmployeece.Education = "硕士"; //人数 pieEmployeece.CountEmployeece = item.CountEmployeece; employeeceList.Add(pieEmployeece); } else if (item.Education == "6") { pieEmployeece.Education = "博士"; //人数 pieEmployeece.CountEmployeece = item.CountEmployeece; employeeceList.Add(pieEmployeece); } } if (employeeceList.Count()>0) { listPieEmployeece = employeeceList; CreatePieChart(); } else { MessageBox.Show("没有符合学历要求员工!"); } } else { if (StrCompanyIDs == "") { MessageBox.Show("请选择公司!"); } else { MessageBox.Show(nuYear.Value.ToString() + "年没有查询到数据!"); listPieEmployeece = null; } } } }
void serviceClient_GetEducationPieEmployeeceInfoCompleted(object sender, GetEducationPieEmployeeceInfoCompletedEventArgs e) { if (e.Error != null) { MessageBox.Show("错误信息:" + e.Error.ToString()); } else { if (e.Result != null) { //得到员工数据 var employeeInfo = from p in e.Result select p; List <PieEmployeece> employeeceList = new List <PieEmployeece>(); // 0、1、2、3表示大专及以下 int CountEmployeece = employeeInfo.Where(T => (T.Education == "0" || T.Education == "1" || T.Education == "2" || T.Education == "3")).Count();; //分组查询 var employee = from p in employeeInfo orderby p.Education group p by p.Education into g select new PieEmployeece { Education = g.Key, CountEmployeece = g.Count() }; int employeece = 0; //分解数据 foreach (var item in employee) { PieEmployeece pieEmployeece = new PieEmployeece(); // 0、1、2、3表示大专及以下/ 4:本科/5: 硕士/6: 博士 if (CountEmployeece > 0 && employeece == 0) { pieEmployeece.Education = "大专及以下"; //人数 pieEmployeece.CountEmployeece = CountEmployeece; employeece = 1; employeeceList.Add(pieEmployeece); } else if (item.Education == "4") { pieEmployeece.Education = "本科"; //人数 pieEmployeece.CountEmployeece = item.CountEmployeece; employeeceList.Add(pieEmployeece); } else if (item.Education == "5") { pieEmployeece.Education = "硕士"; //人数 pieEmployeece.CountEmployeece = item.CountEmployeece; employeeceList.Add(pieEmployeece); } else if (item.Education == "6") { pieEmployeece.Education = "博士"; //人数 pieEmployeece.CountEmployeece = item.CountEmployeece; employeeceList.Add(pieEmployeece); } } if (employeeceList.Count() > 0) { listPieEmployeece = employeeceList; CreatePieChart(); } else { MessageBox.Show("没有符合学历要求员工!"); } } else { if (StrCompanyIDs == "") { MessageBox.Show("请选择公司!"); } else { MessageBox.Show(nuYear.Value.ToString() + "年没有查询到数据!"); listPieEmployeece = null; } } } }