ClassmajorScheduleSettingServices.cs 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using EMIS.Entities;
  6. using System.Linq.Expressions;
  7. using Bowin.Common.Linq.Entity;
  8. using Bowin.Common.Linq;
  9. using EMIS.DataLogic.SchedulingManage.SchedulingSettings;
  10. using EMIS.ViewModel.SchedulingManage.SchedulingSettings;
  11. using EMIS.ViewModel.CalendarManage;
  12. using EMIS.CommonLogic.CalendarManage;
  13. namespace EMIS.CommonLogic.SchedulingManage.SchedulingSettings
  14. {
  15. public class ClassmajorScheduleSettingServices : BaseServices, IClassmajorScheduleSettingServices
  16. {
  17. public ClassmajorScheduleSettingDAL classmajorScheduleSettingDAL { get; set; }
  18. public IArrangementServices arrangementServices { get; set; }
  19. /// <summary>
  20. /// 查询
  21. /// </summary>
  22. /// <param name="classmajorID">班级ID</param>
  23. /// <param name="grademajorID">年级专业ID</param>
  24. /// <param name="collegeID">院系所ID</param>
  25. /// <param name="pageIndex"></param>
  26. /// <param name="pageSize"></param>
  27. /// <returns></returns>
  28. public Bowin.Common.Linq.Entity.IGridResultSet<ViewModel.SchedulingManage.SchedulingSettings.ClassmajorScheduleSettingView> GetClassmajorScheduleSettingViewGrid(Guid? classmajorID, int? StandardID, Guid? collegeID, int? gradeYearID, int pageIndex, int pageSize)
  29. {
  30. Expression<Func<CF_Classmajor, bool>> exp = (x => true);
  31. if (classmajorID.HasValue)
  32. exp = exp.And(x => x.ClassmajorID == classmajorID);
  33. if (gradeYearID.HasValue)
  34. exp = exp.And(x => x.CF_Grademajor.GradeID == gradeYearID);
  35. if (StandardID.HasValue)
  36. exp = exp.And(x => x.CF_Grademajor.CF_Facultymajor.StandardID == StandardID);
  37. if (collegeID.HasValue)
  38. exp = exp.And(x => x.CF_Grademajor.CF_Facultymajor.CollegeID == collegeID);
  39. var query = classmajorScheduleSettingDAL.GetClassmajorScheduleSettingViewQueryable(exp);
  40. return query.OrderByDescending(x => x.CreateTime).ToGridResultSet<ClassmajorScheduleSettingView>(pageIndex, pageSize);
  41. }
  42. /// <summary>
  43. /// 查询
  44. /// </summary>
  45. /// <param name="classmajorID"></param>
  46. /// <returns></returns>
  47. public Bowin.Common.Linq.Entity.IGridResultSet<ViewModel.CalendarManage.ArrangementView> GetArrangementViewGrid(Guid? classmajorID)
  48. {
  49. var resultSet = classmajorScheduleSettingDAL.GetArrangementViewQueryable(classmajorID).OrderBy(x => x.StartTimes).ToGridResultSet<ArrangementView>();
  50. if (resultSet.total > 0)
  51. {
  52. return resultSet;
  53. }
  54. return arrangementServices.GetArrangementViewGrid();
  55. }
  56. /// <summary>
  57. /// 新增
  58. /// </summary>
  59. /// <param name="listArrangement"></param>
  60. /// <param name="classmajorID"></param>
  61. public void ClassmajorScheduleSettingAdd(List<ViewModel.CalendarManage.ArrangementView> listArrangement, Guid? classmajorID)
  62. {
  63. try
  64. {
  65. UnitOfWork.Delete<ES_ClassmajorScheduleSetting>(x => x.ClassmajorID == classmajorID);
  66. foreach (var arrangementView in listArrangement)
  67. {
  68. bool? IsOnWork = false;
  69. for (int i = 0; i < 7; i++)
  70. {
  71. if (i == (int)DayOfWeek.Monday)
  72. IsOnWork = arrangementView.MondayIsOnWork;
  73. if (i == (int)DayOfWeek.Tuesday)
  74. IsOnWork = arrangementView.TuesdayIsOnWork;
  75. if (i == (int)DayOfWeek.Wednesday)
  76. IsOnWork = arrangementView.WednesdayIsOnWork;
  77. if (i == (int)DayOfWeek.Thursday)
  78. IsOnWork = arrangementView.ThursdayIsOnWork;
  79. if (i == (int)DayOfWeek.Friday)
  80. IsOnWork = arrangementView.FridayIsOnWork;
  81. if (i == (int)DayOfWeek.Saturday)
  82. IsOnWork = arrangementView.SaturdayIsOnWork;
  83. if (i == (int)DayOfWeek.Sunday)
  84. IsOnWork = arrangementView.SundayIsOnWork;
  85. ES_ClassmajorScheduleSetting classmajorScheduleSetting = new ES_ClassmajorScheduleSetting();
  86. classmajorScheduleSetting.ClassmajorScheduleSettingID = Guid.NewGuid();
  87. classmajorScheduleSetting.ClassmajorID = classmajorID;
  88. classmajorScheduleSetting.CoursesTimeID = arrangementView.CoursesTimeID;
  89. classmajorScheduleSetting.Weekday = i;
  90. classmajorScheduleSetting.IsOnWork = IsOnWork;
  91. SetNewStatus(classmajorScheduleSetting);
  92. UnitOfWork.Add(classmajorScheduleSetting);
  93. }
  94. }
  95. UnitOfWork.Commit();
  96. }
  97. catch (Exception)
  98. {
  99. throw;
  100. }
  101. }
  102. /// <summary>
  103. /// 删除
  104. /// </summary>
  105. /// <param name="classmajorIDs"></param>
  106. public void ClassmajorScheduleSettingDelete(List<Guid?> classmajorIDs)
  107. {
  108. try
  109. {
  110. UnitOfWork.Delete<ES_ClassmajorScheduleSetting>(x => classmajorIDs.Contains(x.ClassmajorID));
  111. }
  112. catch (Exception)
  113. {
  114. throw;
  115. }
  116. }
  117. }
  118. }