private void button2_Click(object sender, EventArgs e) { var employee = (Employee)employeeBindingSource.Current; var sy = (from s in _db.SchoolYear where s.ID == Repository.GetSchollYearID() select s).FirstOrDefault(); var form = new FormViewLoadEmployee(employee.GetEmployeeInfo(sy)); form.ShowDialog(); }
private void button4_Click(object sender, EventArgs e) { string returnString = "Фамилия".PadRight(30) + "|" + "Должность".PadRight(20) + "|" + "Ставка".PadRight(10) + "|" + "Часов по ставке".PadRight(15) + "|" + "Факт. нагрузка".PadRight(14) + "|" + "Перегрузка".PadRight(10) + "|" + "Недогрузка".PadRight(10) + "|" + Environment.NewLine; decimal workloadForm = 0; decimal overload = 0; decimal underload = 0; decimal workloadFact = 0; List <Employee> employeeList = (from emp in _db.Employee where emp.NonActive == false select emp).ToList(); foreach (Employee eisy in employeeList) { if (eisy.RateInHours != 0 || eisy.Overload != 0 || eisy.Underload != 0) { returnString += eisy.Fio.PadRight(30) + "|" + eisy.Rate.First(r => r.SchoolYearID == Repository.SchoolYear).Post.Name.PadRight(20) + "|" + eisy.Rate.FirstOrDefault(x => x.SchoolYearID == Repository.SchoolYear).Rate1.ToString().PadRight(10) + "|" + eisy.RateInHours.ToString().PadLeft(15) + "|" + eisy.WorkLoad.ToString().PadLeft(15) + "|" + eisy.Overload.ToString().PadLeft(10) + "|" + eisy.Underload.ToString().PadLeft(10) + "|" + Environment.NewLine; workloadForm += eisy.RateInHours; overload += eisy.Overload; underload += eisy.Underload; workloadFact += eisy.WorkLoad; } } returnString += "\n"; returnString += "ИТОГО: ".PadRight(30) + "|" + "".PadRight(20) + "|" + "".PadRight(10) + "|" + workloadForm.ToString().PadLeft(15) + "|" + workloadFact.ToString().PadLeft(15) + "|" + overload.ToString().PadLeft(10) + "|" + underload.ToString().PadLeft(10) + "|" + Environment.NewLine; FormViewLoadEmployee foemEditor = new FormViewLoadEmployee(returnString); foemEditor.ShowDialog(); }
private void поРаспределеннойНагрузкиToolStripMenuItem_Click(object sender, EventArgs e) { var str = ""; var collection = (from licp in _db.LoadInCoursePlan join ciw in _db.CourseInWork on licp.CourseInWorkID equals ciw.ID join sl in _db.SortLoad on licp.SortLoadID equals sl.Id join slict in _db.SortLoadInCourseType on sl.Id equals slict.SortLoadID join d in _db.Documents on ciw.DocumentId equals d.DocumentId join ct in _db.CourseType on slict.CourseTypeID equals ct.Id where d.CourseTypeInDocument.Any(x => x.CourseTypeId == ct.Id) && ciw.SchoolYearID == Repository.SchoolYear select new { Plan = licp, Doc = d, Type = ct, Work = ciw }); foreach (var item in collection.GroupBy(x => x.Doc)) { str += item.Key.Name + "\r\n"; foreach (var item2 in item.GroupBy(x => x.Type)) { str += "\t" + item2.Key.Name + "\r\n"; foreach (var item3 in item2.GroupBy(x => x.Work.FormStudy)) { str += "\t\t" + (item3.Key == true ? "Очники" : "Заочники") + "\r\n"; foreach (var item4 in item3.GroupBy(x => x.Work.Semestr1)) { str += string.Format("\t\t\t{0} семестр. \r\n\t\t\t\tПо плану: \t{1} часов. \r\n\t\t\t\tРаспределено: \t{2} часов.\r\n", item4.Key?.Name ?? "---", item4.Sum(x => x.Plan.CountHours), item4.Sum(x => x.Plan.LoadInCourseFact.Sum(y => y.CountHours))); } str += string.Format("\t\t{0} / {1}\r\n", item3.Sum(x => x.Plan.CountHours), item3.Sum(x => x.Plan.LoadInCourseFact.Sum(y => y.CountHours))); } str += string.Format("\t{0} / {1}\r\n", item2.Sum(x => x.Plan.CountHours), item2.Sum(x => x.Plan.LoadInCourseFact.Sum(y => y.CountHours))); } str += string.Format("{0} / {1}\r\n\r\n", item.Sum(x => x.Plan.CountHours), item.Sum(x => x.Plan.LoadInCourseFact.Sum(y => y.CountHours))); } str += string.Format("Всего по плану {0} часов.\r\nРаспределено {1}", _db.LoadInCoursePlan.Where(p => p.CourseInWork.SchoolYearID == Repository.SchoolYear).Sum(x => x.CountHours), _db.LoadInCourseFact.Where(f => f.LoadInCoursePlan.CourseInWork.SchoolYearID == Repository.SchoolYear).Sum(x => x.CountHours)); var form = new FormViewLoadEmployee(str); form.ShowDialog(); }