public static JsonModelNum GetMoneyLog_Helper(string LoginName, int pageIndex, int PageSize)
{
JsonModelNum jsm = null;
try
{
List <MoneyLog> MoneyLog_List = Constant.MoneyLog_List;
MoneyLog_List = (from m in MoneyLog_List where m.UserID == LoginName orderby m.CreateTime descending select m).ToList();
if (MoneyLog_List.Count > 0)
{
var userListt_get = MoneyLog_List.Skip((pageIndex - 1) * PageSize).Take(PageSize).ToList();
jsm = JsonModelNum.GetJsonModel(0, "success", userListt_get);
jsm.PageIndex = pageIndex;
jsm.PageSize = PageSize;
jsm.PageCount = (MoneyLog_List.Count + PageSize - 1) / PageSize;;
jsm.RowCount = MoneyLog_List.Count;
}
else
{
jsm = JsonModelNum.GetJsonModel(300, "暂无数据");
}
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(jsm);
}
public static JsonModelNum GetCourseInfoHelper(int PageIndex, int PageSize, int SectionId, string Key, string CourseTypeID)
{
JsonModelNum jsm = new JsonModelNum();
int intSuccess = (int)errNum.Success;
try
{
List <Course> Course_List = Constant.Course_List;
List <CourseRel> CourseRel_List = Constant.CourseRel_List;
DictionType_Enum dictiontype = DictionType_Enum.Course_Type;
List <Sys_Dictionary> Sys_Dictionary_List = Constant.Sys_Dictionary_List;
string dictiontypevalue = Convert.ToString((int)dictiontype);
var courrel = (from CourseRel_ in CourseRel_List
where CourseRel_.StudySection_Id == SectionId && CourseRel_.CourseType_Id == CourseTypeID
join Sys_Dictionary_ in Sys_Dictionary_List.Where(i => i.Type == dictiontypevalue) on CourseRel_.CourseType_Id equals Sys_Dictionary_.Key
where Sys_Dictionary_.SectionId == SectionId
select new { CourseRel_.CourseType_Id, CourseRel_.Course_Id, Sys_Dictionary_.Value, Sys_Dictionary_.IsEnable, CourseRelID = CourseRel_.Id }).ToList();
var query = (from Course_ in Course_List
where Course_.Name.Contains(Key) || Course_.UniqueNo.Contains(Key)
join cr in courrel on Course_.UniqueNo equals cr.Course_Id
orderby Course_.IsEnable
select new
{
Course_Id = Course_.Id,
//课程名称
Course_Name = Course_.Name,
//课程编号
Course_No = Course_.UniqueNo,
//课程分类id
CourseRel_Id = cr == null ? "" : cr.CourseType_Id,
CourseRel_Name = (cr == null ? "未分类" : cr.Value),
CourseRelID = cr == null ? 0 : cr.CourseRelID,
Course_.IsEnable,
DepartMentID = Course_.DepartMentID,
DepartmentName = Course_.DepartmentName,
SubDepartmentID = Course_.SubDepartmentID,
SubDepartmentName = Course_.SubDepartmentName,
CourseProperty = Course_.CourseProperty,
}).ToList();
var query_last = (from an in query select an).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
//jsm = JsonModel.get_jsonmodel(intSuccess, "success", query_last);
//返回所有表格数据
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);
}
public void GetAward(HttpContext context)
{
JsonModelNum jsonModelNum = null;
try
{
HttpRequest request = context.Request;
string UID = RequestHelper.string_transfer(request, "UID");
string dsp = RequestHelper.string_transfer(request, "dsp");
string Key = RequestHelper.string_transfer(request, "Key");
int Id = RequestHelper.int_transfer(request, "Id");
bool Current = RequestHelper.bool_transfer(request, "Current");
bool IsLast = RequestHelper.bool_transfer(request, "IsLast");
int PageIndex = RequestHelper.int_transfer(request, "PageIndex");
int PageSize = RequestHelper.int_transfer(request, "PageSize");
if (IsLast || Current || Id > 0)
{
//bool result = Constant.Check_Login_DIP(UID, dsp);
//if (result)
//{
jsonModelNum = GetAward_Helper(PageIndex, PageSize, Key, Current, IsLast, Id);
//}
//else
//{
// jsonModelNum = JsonModelNum.GetJsonModel(1000, "已超时");
//}
}
else
{
bool result = Constant.Check_Login_DIP(UID, dsp);
if (result)
{
jsonModelNum = GetAward_Helper(PageIndex, PageSize, Key, Current, IsLast, Id);
}
else
{
jsonModelNum = JsonModelNum.GetJsonModel(1000, "已超时");
}
}
}
catch (Exception ex)
{
jsonModelNum = JsonModelNum.GetJsonModel(400, ex.Message);
LogHelper.Error(ex);
}
finally
{
//无论后端出现什么问题，都要给前端有个通知【为防止jsonModel 为空 ,全局字段 jsonModel 特意声明之后进行初始化】
context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModelNum) + "}");
}
}
public static JsonModelNum GetAward_Helper(int pageIndex, int PageSize, string Key, bool Current, bool IsLast, int Id)
{
JsonModelNum jsm = null;
try
{
List <Award_Public> Prize_Public_List = Constant.Award_Public_List;
List <Globe> Globe_List = Constant.Globe_List;
List <PrizeModel> price_list = (from prize in Prize_Public_List
where Convert.ToString(prize.Name).Contains(Key)
orderby prize.Id
select new PrizeModel()
{
Id = prize.Id,
Code = prize.Code,
Name = prize.Name,
StartTime = prize.StartTime,
CloseTime = prize.CloseTime,
EndTime = prize.EndTime,
Year = prize.Year,
IsEnable = prize.IsEnable,
GlobeList = Globe_S.GetBase(prize.PrizeContent, Globe_List),
PrizeContent = prize.PrizeContent,
IsCompleate = prize.IsCompleate,
}).ToList();
if (Id > 0)
{
price_list = (from prize in price_list where prize.Id == Id select prize).ToList();
if (price_list.Count > 0)
{
var prize = price_list[0];
jsm = JsonModelNum.GetJsonModel(0, "获取成功", prize);
}
else
{
jsm = JsonModelNum.GetJsonModel(300, "无数据");
}
}
else if (Current)
{
price_list = price_list.Where(item => DateTime.Now < item.CloseTime && item.StartTime < DateTime.Now).ToList();
if (price_list.Count > 0)
{
var prize = price_list[0];
DateTimeS DateTimeS = TimeTransfer((DateTime)prize.CloseTime, DateTime.Now);
prize.Leave_Day = DateTimeS.days;
prize.Leave_Hour = DateTimeS.hours;
prize.Leave_Minuite = DateTimeS.minutes;
prize.Leave_Second = DateTimeS.seconds;
jsm = JsonModelNum.GetJsonModel(0, "获取成功", prize);
}
else
{
jsm = JsonModelNum.GetJsonModel(300, "无数据");
}
}
else
{
if (IsLast)
{
var prize_lis = price_list.Where(item => DateTime.Now > item.CloseTime).OrderByDescending(i => i.CloseTime).ToList();
if (prize_lis.Count > 0)
{
jsm = JsonModelNum.GetJsonModel(0, "获取成功", prize_lis[0]);
}
else
{
jsm = JsonModelNum.GetJsonModel(300, "无数据");
}
}
else
{
//where DateTime.Now >= prize.CloseTime || DateTime.Now <= prize.StartTime
price_list = (from prize in price_list select prize).OrderByDescending(i => i.CloseTime).ToList();
var price_list_get = price_list.Skip((pageIndex - 1) * PageSize).Take(PageSize).ToList();
foreach (var item in price_list_get)
{
if (item.StartTime > DateTime.Now)
{
item.State = 1;
}
else if (item.CloseTime < DateTime.Now)
{
item.State = 3;
}
else if (item.CloseTime > DateTime.Now && item.StartTime < DateTime.Now)
{
item.State = 2;
}
}
if (price_list.Count > 0)
{
jsm = JsonModelNum.GetJsonModel(0, "获取成功", price_list_get);
jsm.PageIndex = pageIndex;
jsm.PageSize = PageSize;
jsm.PageCount = (price_list.Count + PageSize - 1) / PageSize;;;
jsm.RowCount = price_list.Count;
}
else
{
jsm = JsonModelNum.GetJsonModel(300, "无数据");
}
}
}
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(jsm);
}
public static JsonModelNum GetNoDis_CourseInfoHelper(int PageIndex, int PageSize, string Major_Id, int SectionId, string Key)
{
JsonModelNum jsm = new JsonModelNum();
int intSuccess = (int)errNum.Success;
try
{
List <Course> Course_List = Constant.Course_List;
List <CourseRel> CourseRel_List = Constant.CourseRel_List;
if (Major_Id != "")
{
Course_List = (from course in Course_List where course.DepartMentID == Major_Id select course).ToList();
}
if (Key != "")
{
Course_List = (from course in Course_List where course.Name.Contains(Key) || course.UniqueNo.Contains(Key) select course).ToList();
}
var query = (from Course_ in Course_List
join cr in CourseRel_List on new
{
UniqueNo = Course_.UniqueNo,
SectionId = SectionId
} equals new
{
UniqueNo = cr.Course_Id,
SectionId = (int)cr.StudySection_Id
} into courelfs_
from courel in courelfs_.DefaultIfEmpty()
where courel == null
orderby Course_.IsEnable
select new
{
Course_Id = Course_.Id,
//课程名称
Course_Name = Course_.Name,
//课程编号
Course_No = Course_.UniqueNo,
//课程分类id
//CourseRel_Id = cr == null ? "" : cr.CourseType_Id,
//CourseRel_Name = (cr == null ? "未分类" : cr.Value),
//CourseRelID = cr == null ? 0 : cr.CourseRelID,
Course_.IsEnable,
DepartMentID = Course_.DepartMentID,
DepartmentName = Course_.DepartmentName,
SubDepartmentID = Course_.SubDepartmentID,
SubDepartmentName = Course_.SubDepartmentName,
CourseProperty = Course_.CourseProperty,
}).ToList();
var query_last = (from an in query select an).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
//jsm = JsonModel.get_jsonmodel(intSuccess, "success", query_last);
//返回所有表格数据
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);
}
public static JsonModelNum GetClassInfoSelect_Helper(int SectionID, string TeacherUID, string CourseID, string DepartmentName, int UnEvaTeaRoleId)
{
int intSuccess = (int)errNum.Success;
JsonModelNum jsm = new JsonModelNum();
try
{
List <Course> Course_List = Constant.Course_List;
List <CourseRoom> CourseRoom_List = Constant.CourseRoom_List;
List <StudySection> StudySection_List = Constant.StudySection_List;
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
select new ClassModel()
{
Id = CourseRoom_.UniqueNo,
SectionID = StudySection_.Id,
//年度
Academic = StudySection_.Academic,
//级别
Semester = StudySection_.Semester,
//学年学期
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,
TeacherUID = CourseRoom_.TeacherUID,
CourseID = CourseRoom_.Coures_Id,
ClassID = CourseRoom_.ClassID,
//序号
Num = 0,
}).ToList();
if (SectionID > 0)
{
query = (from q in query where q.SectionID == SectionID select q).ToList();
}
if (TeacherUID != "")
{
query = (from q in query where q.TeacherUID == TeacherUID select q).ToList();
}
if (CourseID != "")
{
query = (from q in query where q.CourseID == CourseID select q).ToList();
}
if (DepartmentName != "")
{
query = (from q in query where q.TeacherDepartmentName == DepartmentName select q).ToList();
}
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).ToList();
}
var data = new
{
DPList = (from qe in query where qe.DepartmentName != "" select qe.DepartmentName).Distinct().ToList(),
CTList = (from qe in query where qe.CourseType != "" select qe.CourseType).Distinct().ToList(),
CPList = (from qe in query where qe.CourseProperty != "" select qe.CourseProperty).Distinct().ToList(),
TDList = (from qe in query where qe.TeacherDepartmentName != "" select qe.TeacherDepartmentName).Distinct().ToList(),
TNList = (from qe in query where qe.Teacher_Name != "" select new TNModel()
{
TeacherUID = qe.TeacherUID, TeacherName = qe.Teacher_Name, TeacherDepartmentName = qe.TeacherDepartmentName
}).Distinct(new TNModelComparer()).ToList(),
MDList = (from qe in query where qe.CourseDepartmentName != "" select qe.CourseDepartmentName).Distinct().ToList(),
GDList = (from qe in query where qe.GradeInfo_Name != "" select qe.GradeInfo_Name).Distinct().ToList(),
CNList = (from qe in query where qe.ClassName != "" select qe.ClassName).Distinct().ToList(),
RPList = (from qe in query where qe.RoomDepartmentName != "" select qe.RoomDepartmentName).Distinct().ToList(),
ClsList = (from qe in query where qe.ClassName != "" select new ClsModel()
{
ClassID = qe.ClassID, ClassName = qe.ClassName
}).Distinct(new ClsModelComparer()).ToList(),
CCList = (from qe in query where qe.CourseID != "" && qe.ClassID != "" select new CCModel {
Id = qe.Id, ClassID = qe.ClassID, CourseID = qe.CourseID, ClassName = qe.ClassName, Course_Name = qe.Course_Name
}).Distinct(new CCModelComparer()).ToList(),
};
jsm = JsonModelNum.GetJsonModel_o(intSuccess, "success", data);
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(jsm);
}
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);
}
public static JsonModelNum GetCourseInfoHelper(int PageIndex, int PageSize, int SectionId, string Key, string CourseTypeID)
{
JsonModelNum jsm = new JsonModelNum();
DictionType_Enum dictiontype = DictionType_Enum.Course_Type;
int intSuccess = (int)errNum.Success;
try
{
List <Course> Course_List = Constant.Course_List;
List <CourseRoom> CourseRoom_List = Constant.CourseRoom_List.Distinct(new CourseRoomCompare()).ToList();
List <CourseRel> CourseRel_List = Constant.CourseRel_List;
List <Sys_Dictionary> Sys_Dictionary_List = Constant.Sys_Dictionary_List;
string dictiontypevalue = Convert.ToString((int)dictiontype);
var courrel = (from CourseRel_ in CourseRel_List
where CourseRel_.StudySection_Id == SectionId
join Sys_Dictionary_ in Sys_Dictionary_List.Where(i => i.Type == dictiontypevalue) on CourseRel_.CourseType_Id equals Sys_Dictionary_.Key
where Sys_Dictionary_.SectionId == SectionId
select new
{
CourseRel_.CourseType_Id,
CourseRel_.Course_Id,
Sys_Dictionary_.Value,
Sys_Dictionary_.IsEnable,
CourseRelID = CourseRel_.Id,
}).ToList();
if (CourseTypeID != "-1" && CourseTypeID != "null") //课程分类不是全部和未分类
{
courrel = (from c in courrel where c.CourseType_Id == CourseTypeID select c).ToList();
}
var query = (from Course_ in Course_List
join room in CourseRoom_List on Course_.UniqueNo equals room.Coures_Id
where room.StudySection_Id == SectionId
join cr_ in courrel on Course_.UniqueNo equals cr_.Course_Id into crlist
from cr in crlist.DefaultIfEmpty()
orderby Course_.IsEnable
select new
{
Course_Id = Course_.Id,
//课程名称
Course_Name = Course_.Name,
//课程编号
Course_No = Course_.UniqueNo,
//课程分类id
CourseRel_Id = cr == null ? "" : cr.CourseType_Id,
CourseRel_Name = (cr == null ? "未分类" : cr.Value),
PkType = Course_.PkType,
Course_.TaskProperty,
CourseRelID = cr == null ? 0 : cr.CourseRelID,
Course_.IsEnable,
DepartMentID = Course_.DepartMentID,
DepartmentName = Course_.DepartmentName,
SubDepartmentID = Course_.SubDepartmentID,
SubDepartmentName = Course_.SubDepartmentName,
CourseProperty = Course_.CourseProperty,
}).ToList();
if (CourseTypeID != "-1") //不是全部
{
if (CourseTypeID == "null") //未分类
{
query = (from q in query where q.CourseRel_Id == "" select q).ToList();
}
else //其他类别
{
query = (from q in query where q.CourseRel_Id != "" select q).ToList();
}
}
if (Key != "")
{
query = (from qu in query
where qu.Course_Name.Contains(Key) || qu.Course_No.Contains(Key)
select qu).ToList();
}
var query_last = (from an in query select an).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
//返回所有表格数据
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);
}
/// <summary>
/// 获取答题列表
/// </summary>
/// <param name="context"></param>
public static JsonModel Get_Eva_QuestionAnswer_Helper(int PageIndex, int PageSize, int SectionID, int ReguID, string CourseID, string TeacherUID, string DepartmentID,
string Key, int TableID, string AnswerUID, IsAllSchool IsAllSchool, ModeType modeType, int Eva_Role,
bool eva_check_depart, bool eva_check_school, bool eva_check_indepart, int State, int SourceType, int IsSelfStart, string TeacherMajor_ID)
{
int intSuccess = (int)errNum.Success;
JsonModelNum jsm = new JsonModelNum();
try
{
var list = (from q in Constant.Eva_QuestionAnswer_List
where q.Eva_Role == Eva_Role
join reg in Constant.Eva_Regular_List on q.ReguID equals reg.Id
join u in Constant.UserInfo_List on q.TeacherUID equals u.UniqueNo
join d in Constant.Major_List on u.Major_ID equals d.Id
join r in Constant.CourseRoom_List on q.RoomID equals r.UniqueNo into rooms
join tb in Constant.Eva_Table_List on q.TableID equals tb.Id into tables
from t in tables.DefaultIfEmpty()
from room in rooms.DefaultIfEmpty()
select new Eva_QuestionModel()
{
Id = q.Id,
RelationID = q.RelationID,
SectionID = q.SectionID,
DisPlayName = q.DisPlayName,
TeacherUID = q.TeacherUID,
TeacherName = q.TeacherName,
CourseID = q.CourseID,
CourseName = q.CourseName,
DepartmentID = d.Id,
DepartmentName = d.Major_Name,
TableID = q.TableID,
TableName = q.TableName,
State = q.State,
Score = q.Score,
Num = 0,
ReguID = q.ReguID,
ReguName = q.ReguName,
AnswerUID = q.AnswerUID,
AnswerName = q.IsRealName == (int)IsRealNameType.yes ? q.AnswerName : "匿名",
CreateTime = q.CreateTime,
ClassName = room != null ? room.ClassName : "",
RoleList = (from ru in Constant.Sys_RoleOfUser_List where ru.UniqueNo == q.AnswerUID select ru.Role_Id).ToList(),
RoomID = q.RoomID,
IsScore = t.IsScore == 0 ? true : false,
RegStartTime = reg.StartTime,
RegEndTime = reg.EndTime
}).ToList();
if (SectionID > 0)
{
list = (from li in list where li.SectionID == SectionID select li).ToList();
}
if (ReguID > 0)
{
list = (from li in list where li.ReguID == ReguID select li).ToList();
}
if (CourseID != "")
{
list = (from li in list where li.CourseID == CourseID select li).ToList();
}
if (TeacherUID != "")
{
list = (from li in list where li.TeacherUID == TeacherUID select li).ToList();
}
if (DepartmentID != "")
{
list = (from li in list where li.DepartmentID == DepartmentID select li).ToList();
}
if (TableID > 0)
{
list = (from li in list where li.TableID == TableID select li).ToList();
}
if (AnswerUID != "")
{
list = (from li in list where li.AnswerUID == AnswerUID select li).ToList();
}
if (State > 0)
{
list = (from li in list where li.State == State select li).ToList();
}
if (SourceType > 0)
{
list = (from li in list
join exp in Constant.Expert_Teacher_Course_List on li.RelationID equals exp.Id
where exp.SourceType == SourceType
select li).ToList();
}
if (IsSelfStart > 0)
{
list = (from li in list
join exp in Constant.Expert_Teacher_Course_List on li.RelationID equals exp.Id
where exp.IsSelfStart == IsSelfStart
select li).ToList();
}
switch (modeType)
{
case ModeType.Record:
if (Key != "")
{
list = (from li in list where li.CourseName.Contains(Key) || li.TeacherName.Contains(Key) select li).ToList();
}
break;
case ModeType.Check:
list = (from li in list where li.State == (int)QueState.Submited select li).ToList();
if (Key != "")
{
list = (from li in list where li.CourseName.Contains(Key) || li.TeacherName.Contains(Key) || li.AnswerName.Contains(Key) select li).ToList();
}
List <Eva_QuestionModel> modellist = new List <Eva_QuestionModel>();
var evaquery = (from li in list
join exp in Constant.Expert_Teacher_Course_List on li.RelationID equals exp.Id select new { li, exp.SourceType, exp.TeacherMajor_ID });
//本院院专家为true=》本院院专家数据（SourceType==1&&TeacherMajor_ID）
if (eva_check_indepart && !eva_check_depart && !eva_check_school)
{
modellist = evaquery.Where(t => t.SourceType == 1 && t.TeacherMajor_ID == TeacherMajor_ID).Select(t => t.li).ToList();
}
//校专家为true=》校专家数据（SourceType==2）
else if (!eva_check_indepart && !eva_check_depart && eva_check_school)
{
modellist = evaquery.Where(t => SourceType == 2).Select(t => t.li).ToList();
}
//全校院专家为true||本院院专家、全校院专家为true，校专家为false=》全校院专家（SourceType==1）
else if ((!eva_check_indepart && eva_check_depart && !eva_check_school) || (eva_check_indepart && eva_check_depart && !eva_check_school))
{
modellist = evaquery.Where(t => t.SourceType == 1).Select(t => t.li).ToList();
}
//本院院专家、校专家为true=》本院院专家数据和校专家数据（(SourceType==1&&TeacherMajor_ID)||SourceType==2）
else if (eva_check_indepart && !eva_check_depart && eva_check_school)
{
modellist = evaquery.Where(t => (t.SourceType == 1 && t.TeacherMajor_ID == TeacherMajor_ID) || SourceType == 2).Select(t => t.li).ToList();
}
//全校院专家为、校专家为true||全部为true=》全部数据
else if ((!eva_check_indepart && eva_check_depart && eva_check_school) || (eva_check_indepart && eva_check_depart && eva_check_school))
{
modellist = evaquery.Select(t => t.li).ToList();
}
list = modellist;
break;
case ModeType.Look:
if (Key != "")
{
if ((int)IsAllSchool == 2)
{
list = (from li in list where li.CourseName.Contains(Key) select li).ToList();
}
else
{
list = (from li in list where li.CourseName.Contains(Key) || li.TeacherName.Contains(Key) || li.AnswerName.Contains(Key) select li).ToList();
}
}
break;
default:
break;
}
for (int i = 0; i < list.Count; i++)
{
list[i].Num = i + 1;
var header = Constant.Eva_QuestionAnswer_Header_List.Where(h => h.QuestionID == list[i].Id);
var header_class = header.FirstOrDefault(h => h.CustomCode == "5");
list[i].HeaderClassName = header_class != null? header_class.Value:"";
var header_stu = header.FirstOrDefault(h => h.CustomCode == "6");
list[i].HeaderStuName = header_stu != null ? header_stu.Value : "";
}
var query_last = (from an in list select an).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
//返回所有表格数据
jsm = JsonModelNum.GetJsonModel_o(intSuccess, "success", query_last);
jsm.PageIndex = PageIndex;
jsm.PageSize = PageSize;
jsm.PageCount = (int)Math.Ceiling((double)list.Count() / PageSize);
jsm.RowCount = list.Count();
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(jsm);
}
public static JsonModel Get_UserByRoleID_Helper(int PageIndex, int PageSize, int RoleID, string Key, string Dp, string Cls)
{
int intSuccess = (int)errNum.Success;
JsonModelNum jsm = new JsonModelNum();
try
{
var list = (from user in Constant.UserInfo_List
join stu in Constant.Student_List on user.UniqueNo equals stu.UniqueNo into stus
from stu_ in stus.DefaultIfEmpty()
join tea in Constant.Teacher_List on user.UniqueNo equals tea.UniqueNo into teas
from tea_ in teas.DefaultIfEmpty()
join ru in Constant.Sys_RoleOfUser_List on user.UniqueNo equals ru.UniqueNo
join role in Constant.Sys_Role_List on ru.Role_Id equals role.Id
where role.Id == RoleID
select new UserModel
{
Num = 0,
UniqueNo = user.UniqueNo,
Name = user.Name,
Sex = user.Sex,
DepartmentID = user.Major_ID,
DepartmentName = user.DepartmentName,
SubDepartmentName = user.SubDepartmentName,
ClassID = stu_ != null ? stu_.ClassNo : "",
ClassName = stu_ != null ? stu_.ClassName : "",
TeacherBirthday = tea_ != null ? tea_.TeacherBirthday : 0,
TeacherSchooldate = tea_ != null ? tea_.TeacherSchooldate : 0,
Status = tea_ != null ? tea_.Status : "",
RoleUser_Id = ru.Id
}).ToList();
if (Dp != "")
{
list = (from li in list where li.DepartmentID == Dp select li).ToList();
}
if (Cls != "")
{
list = (from li in list where li.ClassID == Cls select li).ToList();
}
if (Key != "")
{
list = (from li in list where li.Name.Contains(Key) || li.UniqueNo.Contains(Key) select li).ToList();
}
for (int i = 0; i < list.Count; i++)
{
list[i].Num = i + 1;
}
var query_last = (from an in list select an).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
//返回所有表格数据
jsm = JsonModelNum.GetJsonModel_o(intSuccess, "success", query_last);
jsm.PageIndex = PageIndex;
jsm.PageSize = PageSize;
jsm.PageCount = (int)Math.Ceiling((double)list.Count() / PageSize);
jsm.RowCount = list.Count();
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(jsm);
}
