public void GetClassInfo(HttpContext context)
{
HttpRequest request = context.Request;
int PageIndex = RequestHelper.int_transfer(request, "PageIndex");
int PageSize = RequestHelper.int_transfer(request, "PageSize");
int SectionID = RequestHelper.int_transfer(request, "SectionID");
string DP = RequestHelper.string_transfer(request, "DP");
string CT = RequestHelper.string_transfer(request, "CT");
string CP = RequestHelper.string_transfer(request, "CP");
string TD = RequestHelper.string_transfer(request, "TD");
string TN = RequestHelper.string_transfer(request, "TN");
string MD = RequestHelper.string_transfer(request, "MD");
string GD = RequestHelper.string_transfer(request, "GD");
string CN = RequestHelper.string_transfer(request, "CN");
string Key = RequestHelper.string_transfer(request, "Key");
SortType S_DP = (SortType)RequestHelper.int_transfer(request, "S_DP");
SortType S_CN = (SortType)RequestHelper.int_transfer(request, "S_CN");
SortType S_CT = (SortType)RequestHelper.int_transfer(request, "S_CT");
SortType S_CP = (SortType)RequestHelper.int_transfer(request, "S_CP");
SortType S_TD = (SortType)RequestHelper.int_transfer(request, "S_TD");
SortType S_TN = (SortType)RequestHelper.int_transfer(request, "S_TN");
SortType S_MD = (SortType)RequestHelper.int_transfer(request, "S_MD");
SortType S_GD = (SortType)RequestHelper.int_transfer(request, "S_GD");
SortType S_CLS = (SortType)RequestHelper.int_transfer(request, "S_CLS");
SortType S_TJ = (SortType)RequestHelper.int_transfer(request, "S_TJ");
SortType S_BR = (SortType)RequestHelper.int_transfer(request, "S_BR");
SortType S_SY = (SortType)RequestHelper.int_transfer(request, "S_SY");
string DepartmentName = RequestHelper.string_transfer(request, "DepartmentName");
int UnEvaTeaRoleId = RequestHelper.int_transfer(request, "UnEvaTeaRoleId");
int ClassModeltype = RequestHelper.int_transfer(request, "ClassModelType");
ClassModelType ClassModelType = (ClassModelType)ClassModeltype;
int BirthdayS = RequestHelper.int_transfer(request, "BirthdayS");
int BirthdayE = RequestHelper.int_transfer(request, "BirthdayE");
int SchoolS = RequestHelper.int_transfer(request, "SchoolS");
int SchoolE = RequestHelper.int_transfer(request, "SchoolE");
try
{
jsonModel = GetClassInfo_Helper(PageIndex, PageSize, SectionID, DP, CT, CP, TD, TN, MD, GD,
CN, Key, ClassModelType, BirthdayS, BirthdayE, SchoolS, SchoolE,
S_DP, S_CN, S_CT, S_CP, S_TD, S_TN, S_MD, S_GD, S_CLS, S_TJ, S_BR, S_SY, DepartmentName, UnEvaTeaRoleId);
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
finally
{
//无论后端出现什么问题，都要给前端有个通知【为防止jsonModel 为空 ,全局字段 jsonModel 特意声明之后进行初始化】
context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}");
}
}
public string GetEntityTypeText(ClassModelType classModelType)
{
switch (classModelType)
{
case ClassModelType.AbstractClass: return("-abstract- ");
case ClassModelType.Enumeration: return("-enum- ");
default: return(null);
}
}
public static JsonModelNum GetClassInfo_Helper(int PageIndex, int PageSize, int SectionID, string DP, string CT, string CP, string TD,
string TN, string MD, string GD, string CN, string Key, ClassModelType ClassModelType, int BirthdayS, int BirthdayE, int SchoolS, int SchoolE,
SortType S_DP, SortType S_CN, SortType S_CT, SortType S_CP, SortType S_TD, SortType S_TN,
SortType S_MD, SortType S_GD, SortType S_CLS, SortType S_TJ, SortType S_BR, SortType S_SY, string DepartmentName, int UnEvaTeaRoleId)
{
int intSuccess = (int)errNum.Success;
JsonModelNum jsm = new JsonModelNum();
try
{
List <Course> Course_List = Constant.Course_List;
List <CourseRel> CourseRel_List = Constant.CourseRel_List;
List <Sys_Dictionary> Sys_Dictionary_List = Constant.Sys_Dictionary_List;
List <CourseRoom> CourseRoom_List = Constant.CourseRoom_List;
List <StudySection> StudySection_List = Constant.StudySection_List;
var list = (from cref in CourseRel_List
join dic in Sys_Dictionary_List on cref.CourseType_Id equals dic.Key
join sdy in StudySection_List on dic.SectionId equals sdy.Id
where cref.StudySection_Id == sdy.Id
select new { SectionID = sdy.Id, CourseID = cref.Course_Id, dic.Value }).ToList();
var query = (from CourseRoom_ in CourseRoom_List
join Course_ in Course_List on CourseRoom_.Coures_Id equals Course_.UniqueNo
join StudySection_ in StudySection_List on CourseRoom_.StudySection_Id equals StudySection_.Id
join li in list on new { SectionID = StudySection_.Id, CourseID = Course_.UniqueNo } equals new { SectionID = li.SectionID, CourseID = li.CourseID } into lis
from li_ in lis.DefaultIfEmpty()
select new ClassModel()
{
CourseTypeDic = li_ != null? li_.Value:"",
//年度
Academic = StudySection_.Academic,
//级别
SectionID = StudySection_.Id,
//学年学期
DisPlayName = StudySection_.DisPlayName,
//课堂名称
Course_Name = Course_.Name,
//班
ClassName = CourseRoom_.ClassName,
//年级
GradeInfo_Name = CourseRoom_.GradeName,
//教师姓名
Teacher_Name = CourseRoom_.TeacherName,
//开课部门
DepartmentName = Course_.DepartmentName,
//课程类型
CourseType = CourseRoom_.CourseType,
//课程性质
CourseProperty = Course_.CourseProperty,
//教师部门
TeacherDepartmentName = CourseRoom_.TeacherDepartmentName,
CourseDepartmentName = CourseRoom_.DepartmentName,
//专业部门
RoomDepartmentName = CourseRoom_.RoomDepartmentName,
TeacherJobTitle = CourseRoom_.TeacherJobTitle,
TeacherBirthday = CourseRoom_.TeacherBirthday,
TeacherSchooldate = CourseRoom_.TeacherSchooldate,
CourseID = CourseRoom_.Coures_Id,
ClassID = CourseRoom_.ClassID,
TeacherUID = CourseRoom_.TeacherUID,
Id = CourseRoom_.UniqueNo,
//序号
Num = 0,
});
if (UnEvaTeaRoleId != 0)
{
string[] unEvaTeachers = Constant.Sys_RoleOfUser_List.Where(t => t.Role_Id == UnEvaTeaRoleId).Select(t => t.UniqueNo).ToArray();
query = query.Where(t => unEvaTeachers.Contains(t.TeacherUID) == false);
}
query = GetClassInfoNormalHelper(SectionID, DP, CT, CP, TD, TN, MD, GD, CN, Key, DepartmentName, query);
switch (ClassModelType)
{
case ClassModelType.CourseRoom:
break;
case ClassModelType.DisExpertTask:
query = (from q in query where q.TeacherBirthday >= BirthdayS && q.TeacherBirthday <= BirthdayE && q.TeacherSchooldate >= SchoolS && q.TeacherSchooldate <= SchoolE select q);
break;
default:
break;
}
query = GetClassInfoSortHelper(S_DP, S_CN, S_CT, S_CP, S_TD, S_TN, S_MD, S_GD, S_CLS, S_TJ, S_BR, S_SY, query);
var queryList = query.ToList();
int count = 1;
queryList.ForEach(i =>
{
i.Num += count;
count++;
});
var query_last = (from an in queryList select an).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
foreach (var li in query_last)
{
li.TableCount = (from r in Constant.CourseRel_List
where r.Course_Id == li.CourseID && r.StudySection_Id == li.SectionID
join t in Constant.Eva_CourseType_Table_List on new { CourseTypeId = r.CourseType_Id, r.StudySection_Id } equals new { CourseTypeId = t.CourseTypeId, t.StudySection_Id }
select r).ToList().Count();
}
jsm = JsonModelNum.GetJsonModel_o(intSuccess, "success", query_last);
jsm.PageIndex = PageIndex;
jsm.PageSize = PageSize;
jsm.PageCount = (int)Math.Ceiling((double)query.Count() / PageSize);
jsm.RowCount = query.Count();
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(jsm);
}
