void serviceClient_GetLengthServicePieCompleted(object sender, GetLengthServicePieCompletedEventArgs 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>(); foreach (var item in employeeInfo) { PieEmployeece pieEmployeece = new PieEmployeece(); int workAge = 0; if (item.ENTRYDATE != null) { DateTime ENTRYDATE = DateTime.Parse(item.ENTRYDATE.ToString()); //得到公龄 workAge = GetWorkAge(ENTRYDATE); } pieEmployeece.Age = workAge.ToString(); //pieEmployeece.EMPLOYEEID = item.EMPLOYEEID; pieEmployeece.Name = item.Name; employeeceList.Add(pieEmployeece); } //1年及1年以内 int m1 = employeeceList.Where(t => int.Parse(t.Age) <= 1).Count(); //1~3年(含3年) int m2 = employeeceList.Where(t => int.Parse(t.Age) >1 && int.Parse(t.Age) <=3).Count(); //3~5年(含5年) int m3 = employeeceList.Where(t => int.Parse(t.Age) >3 && int.Parse(t.Age) <= 5).Count(); //5~8年(含8年) int m4 = employeeceList.Where(t => int.Parse(t.Age) >5 && int.Parse(t.Age) <= 8).Count(); //8~10年(不含10年) int m5 = employeeceList.Where(t => int.Parse(t.Age) >8 && int.Parse(t.Age) <10).Count(); //10年以上 int m6 = employeeceList.Where(t => int.Parse(t.Age) >=10).Count(); List<PieEmployeece> newEmployeeceList = new List<PieEmployeece>(); for (int i = 0; i < 6; i++) { PieEmployeece pie = new PieEmployeece(); switch (i) { case 0: if (m1 != 0) { pie.Name = "1年及1年以内"; pie.CountEmployeece = m1; newEmployeeceList.Add(pie); } break; case 1: if (m2 != 0) { pie.Name = "1~3年(含3年)"; pie.CountEmployeece = m2; newEmployeeceList.Add(pie); } break; case 2: if (m3 != 0) { pie.Name = "3~5年(含5年)"; pie.CountEmployeece = m3; newEmployeeceList.Add(pie); } break; case 3: if (m4 != 0) { pie.Name = "5~8年(含8年)"; pie.CountEmployeece = m4; newEmployeeceList.Add(pie); } break; case 4: if (m5 != 0) { pie.Name = "8~10年(不含10年)"; pie.CountEmployeece = m5; newEmployeeceList.Add(pie); } break; case 5: if (m5 != 0) { pie.Name = "10年以上"; pie.CountEmployeece = m5; newEmployeeceList.Add(pie); } break; } } listPieEmployeece = newEmployeeceList; CreatePieChart(); } else { if (StrCompanyIDs == "") { MessageBox.Show("请选择公司!"); } else { MessageBox.Show(this.nuYear.Value.ToString() + "~" + this.EndnuYear.Value.ToString() + "年没有查询到数据!"); listPieEmployeece = null; } } } }
void serviceClient_GetLengthServicePieCompleted(object sender, GetLengthServicePieCompletedEventArgs 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>(); foreach (var item in employeeInfo) { PieEmployeece pieEmployeece = new PieEmployeece(); int workAge = 0; if (item.ENTRYDATE != null) { DateTime ENTRYDATE = DateTime.Parse(item.ENTRYDATE.ToString()); //得到公龄 workAge = GetWorkAge(ENTRYDATE); } pieEmployeece.Age = workAge.ToString(); //pieEmployeece.EMPLOYEEID = item.EMPLOYEEID; pieEmployeece.Name = item.Name; employeeceList.Add(pieEmployeece); } //1年及1年以内 int m1 = employeeceList.Where(t => int.Parse(t.Age) <= 1).Count(); //1~3年(含3年) int m2 = employeeceList.Where(t => int.Parse(t.Age) > 1 && int.Parse(t.Age) <= 3).Count(); //3~5年(含5年) int m3 = employeeceList.Where(t => int.Parse(t.Age) > 3 && int.Parse(t.Age) <= 5).Count(); //5~8年(含8年) int m4 = employeeceList.Where(t => int.Parse(t.Age) > 5 && int.Parse(t.Age) <= 8).Count(); //8~10年(不含10年) int m5 = employeeceList.Where(t => int.Parse(t.Age) > 8 && int.Parse(t.Age) < 10).Count(); //10年以上 int m6 = employeeceList.Where(t => int.Parse(t.Age) >= 10).Count(); List <PieEmployeece> newEmployeeceList = new List <PieEmployeece>(); for (int i = 0; i < 6; i++) { PieEmployeece pie = new PieEmployeece(); switch (i) { case 0: if (m1 != 0) { pie.Name = "1年及1年以内"; pie.CountEmployeece = m1; newEmployeeceList.Add(pie); } break; case 1: if (m2 != 0) { pie.Name = "1~3年(含3年)"; pie.CountEmployeece = m2; newEmployeeceList.Add(pie); } break; case 2: if (m3 != 0) { pie.Name = "3~5年(含5年)"; pie.CountEmployeece = m3; newEmployeeceList.Add(pie); } break; case 3: if (m4 != 0) { pie.Name = "5~8年(含8年)"; pie.CountEmployeece = m4; newEmployeeceList.Add(pie); } break; case 4: if (m5 != 0) { pie.Name = "8~10年(不含10年)"; pie.CountEmployeece = m5; newEmployeeceList.Add(pie); } break; case 5: if (m5 != 0) { pie.Name = "10年以上"; pie.CountEmployeece = m5; newEmployeeceList.Add(pie); } break; } } listPieEmployeece = newEmployeeceList; CreatePieChart(); } else { if (StrCompanyIDs == "") { MessageBox.Show("请选择公司!"); } else { MessageBox.Show(this.nuYear.Value.ToString() + "~" + this.EndnuYear.Value.ToString() + "年没有查询到数据!"); listPieEmployeece = null; } } } }