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