123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127 |
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using EMIS.Entities;
- using System.Linq.Expressions;
- using Bowin.Common.Linq.Entity;
- using Bowin.Common.Linq;
- using EMIS.DataLogic.SchedulingManage.SchedulingSettings;
- using EMIS.ViewModel.SchedulingManage.SchedulingSettings;
- using EMIS.ViewModel.CalendarManage;
- using EMIS.CommonLogic.CalendarManage;
- namespace EMIS.CommonLogic.SchedulingManage.SchedulingSettings
- {
- public class ClassmajorScheduleSettingServices : BaseServices, IClassmajorScheduleSettingServices
- {
- public ClassmajorScheduleSettingDAL classmajorScheduleSettingDAL { get; set; }
- public IArrangementServices arrangementServices { get; set; }
- /// <summary>
- /// 查询
- /// </summary>
- /// <param name="classmajorID">班级ID</param>
- /// <param name="grademajorID">年级专业ID</param>
- /// <param name="collegeID">院系所ID</param>
- /// <param name="pageIndex"></param>
- /// <param name="pageSize"></param>
- /// <returns></returns>
- public Bowin.Common.Linq.Entity.IGridResultSet<ViewModel.SchedulingManage.SchedulingSettings.ClassmajorScheduleSettingView> GetClassmajorScheduleSettingViewGrid(Guid? classmajorID, int? StandardID, Guid? collegeID, int? gradeYearID, int pageIndex, int pageSize)
- {
- Expression<Func<CF_Classmajor, bool>> exp = (x => true);
- if (classmajorID.HasValue)
- exp = exp.And(x => x.ClassmajorID == classmajorID);
- if (gradeYearID.HasValue)
- exp = exp.And(x => x.CF_Grademajor.GradeID == gradeYearID);
- if (StandardID.HasValue)
- exp = exp.And(x => x.CF_Grademajor.CF_Facultymajor.StandardID == StandardID);
- if (collegeID.HasValue)
- exp = exp.And(x => x.CF_Grademajor.CF_Facultymajor.CollegeID == collegeID);
- var query = classmajorScheduleSettingDAL.GetClassmajorScheduleSettingViewQueryable(exp);
- return query.OrderByDescending(x => x.CreateTime).ToGridResultSet<ClassmajorScheduleSettingView>(pageIndex, pageSize);
- }
- /// <summary>
- /// 查询
- /// </summary>
- /// <param name="classmajorID"></param>
- /// <returns></returns>
- public Bowin.Common.Linq.Entity.IGridResultSet<ViewModel.CalendarManage.ArrangementView> GetArrangementViewGrid(Guid? classmajorID)
- {
- var resultSet = classmajorScheduleSettingDAL.GetArrangementViewQueryable(classmajorID).OrderBy(x => x.StartTimes).ToGridResultSet<ArrangementView>();
- if (resultSet.total > 0)
- {
- return resultSet;
- }
- return arrangementServices.GetArrangementViewGrid();
- }
- /// <summary>
- /// 新增
- /// </summary>
- /// <param name="listArrangement"></param>
- /// <param name="classmajorID"></param>
- public void ClassmajorScheduleSettingAdd(List<ViewModel.CalendarManage.ArrangementView> listArrangement, Guid? classmajorID)
- {
- try
- {
- UnitOfWork.Delete<ES_ClassmajorScheduleSetting>(x => x.ClassmajorID == classmajorID);
- foreach (var arrangementView in listArrangement)
- {
- bool? IsOnWork = false;
- for (int i = 0; i < 7; i++)
- {
- if (i == (int)DayOfWeek.Monday)
- IsOnWork = arrangementView.MondayIsOnWork;
- if (i == (int)DayOfWeek.Tuesday)
- IsOnWork = arrangementView.TuesdayIsOnWork;
- if (i == (int)DayOfWeek.Wednesday)
- IsOnWork = arrangementView.WednesdayIsOnWork;
- if (i == (int)DayOfWeek.Thursday)
- IsOnWork = arrangementView.ThursdayIsOnWork;
- if (i == (int)DayOfWeek.Friday)
- IsOnWork = arrangementView.FridayIsOnWork;
- if (i == (int)DayOfWeek.Saturday)
- IsOnWork = arrangementView.SaturdayIsOnWork;
- if (i == (int)DayOfWeek.Sunday)
- IsOnWork = arrangementView.SundayIsOnWork;
- ES_ClassmajorScheduleSetting classmajorScheduleSetting = new ES_ClassmajorScheduleSetting();
- classmajorScheduleSetting.ClassmajorScheduleSettingID = Guid.NewGuid();
- classmajorScheduleSetting.ClassmajorID = classmajorID;
- classmajorScheduleSetting.CoursesTimeID = arrangementView.CoursesTimeID;
- classmajorScheduleSetting.Weekday = i;
- classmajorScheduleSetting.IsOnWork = IsOnWork;
- SetNewStatus(classmajorScheduleSetting);
- UnitOfWork.Add(classmajorScheduleSetting);
- }
- }
- UnitOfWork.Commit();
- }
- catch (Exception)
- {
- throw;
- }
- }
- /// <summary>
- /// 删除
- /// </summary>
- /// <param name="classmajorIDs"></param>
- public void ClassmajorScheduleSettingDelete(List<Guid?> classmajorIDs)
- {
- try
- {
- UnitOfWork.Delete<ES_ClassmajorScheduleSetting>(x => classmajorIDs.Contains(x.ClassmajorID));
- }
- catch (Exception)
- {
- throw;
- }
- }
- }
- }
|