/// <summary>
/// 作者：Vincen
/// 时间：2014.01.02
/// 描述：获取反馈信息列表，通过反馈类型
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="feedbackType"></param>
/// <returns></returns>
public ActionResult GetFeedbackListByFeedbackType([DefaultValue(1)]int pageIndex, int feedbackType)
{
var page = new Paging()
{
PageIndex = pageIndex,
PageSize = 10
};
var model = FeedbackBLL.GetFeedbackListByFeedbackType(feedbackType, page);
return PartialView("_List", model);
}
/// <summary>
/// 作者：Vincen
/// 时间：2013.11.12 PM
/// 描述：获取Follow列表信息（分页），通过FU方式
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="followModeType"></param>
/// <returns></returns>
public ActionResult FollowListByFollowModeType([DefaultValue(1)]int pageIndex, int followModeType)
{
var page = new Paging()
{
PageIndex = pageIndex,
PageSize = WebCommon.Global.StudentPageSize
};
var model = FollowBLL.GetFollowDetailsByStudentId(LoginUserManager.CurrLoginUser.StudentId, followModeType, page);
return PartialView("_FollowList", model);
}
/// <summary>
/// 作者：Beta
/// 时间：2014.01.16
/// 描述：获取公告通知列表 根据用户id（分页）
/// </summary>
/// <param name="pageIndex"></param>
/// <returns></returns>
public ActionResult NoticeList([DefaultValue(1)]int pageIndex)
{
var page = new Paging()
{
PageIndex = pageIndex,
PageSize = Global.StudentPageSize
};
var model = EmeBLL.GetNoitceListByUserId(LoginUserManager.CurrLoginUser.UserId, PlatformType.Student, page);
return PartialView("_NoticeList", model);
}
public ActionResult TeacherRateFeedbackList(SearchRateFeedbackModel search, [DefaultValue(1)]int pageIndex)
{
Paging paging = new Paging
{
PageIndex = pageIndex,
PageSize = 15
};
var model = RateBLL.GetTeacherRateFeedback(search.BranchId, search.IsGreater, Eme.WebCommon.LoginUserManager.CurrLoginUser.UserId, search.SearchKey, search.SearchKeyword
, search.BeginDate, search.EndDate, search.ProductId, paging);
Session["SearchTeacherRateFeedbackModel"] = search;
return PartialView("_List", model);
}
public ActionResult GetRemarkListByUserId(int userId, [DefaultValue(1)]int pageIndex)
{
var page = new Paging()
{
PageIndex = pageIndex,
PageSize = 10
};
var model = UserBLL.GetRemarkListByUserId(userId, page);
Session["RemarkUserId"] = userId;
//monica 添加viewbag
ViewBag.userId = userId;
return PartialView("_List", model);
}
/// <summary>
///作者:monica
/// 时间:2012.12.15
/// 描述:查询当前页的排课列表
/// </summary>
/// <param name="search"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public ActionResult ArrangeCourseByListBySession(SearchArrangeCourseModel search, [DefaultValue(1)]int pageIndex)
{
var page = new Paging()
{
PageIndex = pageIndex,
PageSize = 15
};
search = Session["SearchArrangeCourse"] as SearchArrangeCourseModel;
var model = StudyBLL.GetArrangeCourseList(search.UserId, search.BranchId, search.CourseBeginTime,
search.CourseEndTime, search.IsOnline, null, search.IsVip, search.IsOpen, search.TeacherType, search.ProductLevel, search.ProductId, search.SearchKey,
search.SearchKeyword, page);
ViewBag.CurPageIndex = pageIndex;
return PartialView("_List", model);
}
/// <summary>
/// 作者:Vincen
/// 时间:2014.01.21
/// 描述:获取学员列表(分页)
/// </summary>
/// <param name="branchId"></param>
/// <param name="userId"></param>
/// <param name="contractStatusType"></param>
/// <param name="currLevel"></param>
/// <param name="isLimitBook"></param>
/// <param name="sex"></param>
/// <param name="isVip"></param>
/// <param name="isMyStudent"></param>
/// <param name="searchKey"></param>
/// <param name="searchKeyword"></param>
/// <param name="contractBeginDate">合同起始日期搜索-开始</param>
/// <param name="contractEndDate">合同起始日期搜索-结束</param>
/// <param name="contractBeginTime">合同截止日期搜索-开始</param>
/// <param name="contractEndTime">合同截止日期搜索-结束</param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<User> GetStudentList(int? branchId, int? userId, int? contractStatusType, int? currLevel, bool? isLimitBook, int? sex, bool? isVip, bool? isMyStudent, int? searchKey, string searchKeyword, DateTime? contractBeginDate, DateTime? contractEndDate, DateTime? contractBeginTime, DateTime? contractEndTime, Paging page)
{
if (!string.IsNullOrEmpty(searchKeyword))
{
searchKeyword = searchKeyword.Trim();
}
var query = from a in Db.User.Where(q => q.UserType == ConvertEnum.UserTypeForStudent && q.Status != ConvertEnum.StatusTypeForDelete)
join b in Db.Student.Where(q => q.Status == ConvertEnum.StatusTypeForActive) on a.Id equals b.UserId
join c in Db.Contract.Where(q => q.Status == ConvertEnum.StatusTypeForActive) on b.Id equals c.StudentId
orderby c.BeginDate descending
select new { User = a, StudentId = b.Id, ContractId = c.Id };
if (branchId.HasValue)
{
query = from q in query join ub in Db.UserBranch.Where(t => t.IsMain
&& t.BranchId == branchId.Value && t.Status == ConvertEnum.StatusTypeForActive) on q.User.Id equals ub.UserId
select q;
}
if (isMyStudent.HasValue)
{
// 我的学员
if (isMyStudent.Value)
{
if (userId.HasValue)
{
//query = query.Where(p => p.Student.Any(s => s.SA == userId || s.CC == userId));
}
}
}
if (contractStatusType.HasValue)
{
//query = query.Where(p => p.Student.Any(s => s.Contract.Any(c => c.ContractDetail.Any(d => d.ContractStatusType == contractStatusType.Value))));
}
//合同开始日期搜索
if (contractBeginDate.HasValue)
{
//query = query.Where(p => p.Student.Any(s => s.Contract.Any(c => c.BeginDate >= contractBeginDate.Value)));
}
if (contractEndDate.HasValue)
{
contractEndDate = contractEndDate.Value.AddDays(1);
//query = query.Where(p => p.Student.Any(s => s.Contract.Any(c => c.BeginDate <= contractEndDate.Value)));
}
//合同截止日期搜索
if (contractBeginTime.HasValue)
{
//query = query.Where(p => p.Student.Any(s => s.Contract.Any(c => c.EndDate >= contractBeginTime.Value)));
}
if (contractEndTime.HasValue)
{
contractEndTime = contractEndTime.Value.AddDays(1);
//query = query.Where(p => p.Student.Any(s => s.Contract.Any(c => c.EndDate <= contractEndTime.Value)));
}
if (currLevel.HasValue)
{
//query = query.Where(p => p.Student.Any(s => s.Contract.Any(c => c.ContractDetail.Any(d => d.ContractLevel.Any(l => l.ProductLevelId == currLevel && l.IsCurrent)))));
}
if (isLimitBook.HasValue)
{
//query = query.Where(p => p.Student.Any(s => s.Contract.Any(c => c.ContractDetail.Any(d => d.IsLimitBook == isLimitBook.Value))));
}
if (isVip.HasValue)
{
query = from q in query
join cd in Db.ContractDetail.Where(t => t.IsVip == isVip.Value) on q.ContractId equals cd.ContractId
select q;
//query = query.Where(p => p.Student.Any(s => s.Contract.Any(c => c.ContractDetail.Any(d => d.IsVip == isVip.Value))));
}
if (sex.HasValue)
{
//query = query.Where(p => p.UserInfo.Any(u => u.Sex == sex.Value));
}
if (searchKey.HasValue && !string.IsNullOrEmpty(searchKeyword))
{
// if (searchKey.Value == CommonHelper.To<int>(SearchStudentKey.KeyWord))
// {
// query = query.Where(p =>
//p.UserInfo.Any(u => u.CName.Contains(searchKeyword) || u.EName.Contains(searchKeyword) || u.Mobile.Contains(searchKeyword) || u.Email.Contains(searchKeyword)) ||
//p.UserName.Equals(searchKeyword, StringComparison.CurrentCultureIgnoreCase));
// }
// else if (searchKey.Value == CommonHelper.To<int>(SearchStudentKey.UserName))
// {
// query = query.Where(p => p.UserInfo.Any(u => u.CName.Contains(searchKeyword) || u.EName.Contains(searchKeyword)));
// }
// else if (searchKey.Value == CommonHelper.To<int>(SearchStudentKey.Account))
// {
// query = query.Where(p => p.UserName.Equals(searchKeyword, StringComparison.CurrentCultureIgnoreCase));
// }
// else if (searchKey.Value == CommonHelper.To<int>(SearchStudentKey.SA))
// {
// query = query.Where(p =>
// p.Student.Any(s =>
// s.SA.HasValue &&
// Db.UserInfo.Any(u => (
// u.CName.Equals(searchKeyword, StringComparison.CurrentCultureIgnoreCase) ||
// u.EName.Equals(searchKeyword, StringComparison.CurrentCultureIgnoreCase)) &&
// u.UserId == s.SA.Value)));
// }
// else if (searchKey.Value == CommonHelper.To<int>(SearchStudentKey.CC))
// {
// query = query.Where(p =>
// p.Student.Any(s =>
// s.CC.HasValue &&
// Db.UserInfo.Any(u => (
// u.CName.Equals(searchKeyword, StringComparison.CurrentCultureIgnoreCase) ||
// u.EName.Equals(searchKeyword, StringComparison.CurrentCultureIgnoreCase)) &&
// u.UserId == s.CC.Value)));
// }
}
else if (!searchKey.HasValue && !string.IsNullOrEmpty(searchKeyword))
{
query = from q in query
join ui in Db.UserInfo on q.User.Id equals ui.UserId
where ui.CName.Contains(searchKeyword) || ui.EName.Contains(searchKeyword) || ui.Mobile.Contains(searchKeyword) || ui.Email.Contains(searchKeyword) || q.User.UserName.Equals(searchKeyword, StringComparison.CurrentCultureIgnoreCase)
select q;
// query = query.Where(p =>
//p.UserInfo.Any(u => u.CName.Contains(searchKeyword) || u.EName.Contains(searchKeyword) || u.Mobile.Contains(searchKeyword) || u.Email.Contains(searchKeyword)) ||
//p.UserName.Equals(searchKeyword, StringComparison.CurrentCultureIgnoreCase));
}
return (from q in query orderby q.User.Id descending select q.User).ToPagedList(page.PageIndex, page.PageSize);
//query.Distinct().OrderByDescending(p => p.Id).ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者：Beta
/// 时间：2014.06.11
/// 描述：获取学员报备信息 （分页）
/// </summary>
/// <param name="userId"></param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<Referral> GetReferralListByUserId(int userId, Paging page)
{
return Db.Referral.Where(p =>
p.UserId == userId &&
p.Status == ConvertEnum.StatusTypeForActive)
.OrderBy(p => p.CreateTime)
.ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者：Primo
/// 时间：2015.04.24
/// 描述：获取投诉列表信息，通过用户ID(分页)
/// </summary>
/// <param name="userId"></param>
/// <param name="feedbackType"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public ActionResult GetComplainListByUserId(int userId, int menuId, [DefaultValue(1)]int pageIndex)
{
var page = new Paging()
{
PageIndex = pageIndex,
PageSize = 3
};
var model = ComplainBLL.GetComplainContentListByUserId(userId, menuId, page);
return PartialView("_ComplainList", model);
}
public ActionResult SearchStudentList(SearchStudentModel search, int pageIndex = 1)
{
if (search.IsAreaStudent.HasValue)
{
if (string.IsNullOrWhiteSpace(search.SearchKeyword))
{
return null;
}
}
else if (search.IsAllStudent.HasValue)
{
if (string.IsNullOrWhiteSpace(search.SearchKeyword))
{
return null;
}
}
else
{
// 我的学员
if (
LoginUserManager.CurrLoginUser.RightsList.Any(
p => p.SCode.Equals("EM001") && p.Status == ConvertEnum.StatusTypeForActive))
{
search.IsMyStudent = true;
search.UserId = LoginUserManager.CurrLoginUser.UserId;
}
else
{
if (search.IsMyStudent.HasValue && search.IsMyStudent.Value)
{
search.UserId = LoginUserManager.CurrLoginUser.UserId;
}
}
}
// Ark 注：参数应该是 SearchStudentModel，以后优化时修改
Paging paging = new Paging
{
PageIndex = pageIndex,
PageSize = 5
};
//var model = StudentBLL.GetStudentList(search.BranchId, search.UserId, search.ContractStatusType, search.CurrentLevel, search.IsLimitBook, search.Sex, search.IsVip, search.IsMyStudent, search.SearchKey,
// search.SearchKeyword, search.ContractBeginDate, search.ContractEndDate, search.ContractBeginTime, search.ContractEndTime, paging);
var saCCInfos = new List<SACCInfo>();
var contractInfos = new List<ContractInfo>();
var contractDetailInfos = new List<ContractDetailInfo>();
var contractLevelInfos = new List<ContractLevelInfo>();
var contractFrozenInfos = new List<ContractFrozenInfo>();
var model = StudentBLL.GetStudentList(search.BranchId, search.UserId, search.ContractStatusType, search.CurrentLevel, search.ProductId,
search.IsLimitBook, search.Sex, search.IsVip, search.IsMyStudent, search.IsAreaStudent, search.IsAllStudent, search.SearchKey, search.SearchKeyword,
search.ContractBeginDate, search.ContractEndDate, search.ContractBeginTime, search.ContractEndTime,search.ConditionType, paging,
out saCCInfos, out contractInfos, out contractDetailInfos, out contractLevelInfos, out contractFrozenInfos);
ViewBag.SACCInfos = saCCInfos;
ViewBag.ContractInfos = contractInfos;
ViewBag.ContractDetailInfos = contractDetailInfos;
ViewBag.ContractLevelInfos = contractLevelInfos;
ViewBag.ContractFrozenInfos = contractFrozenInfos;
Session["StudentSearchModel"] = search;
return PartialView("_StudentList", model);// PartialView("_List", model);
}
/// <summary>
/// 作者：Raymond
/// 时间：2014-1-3
/// 描述：根据关键字获取产品列表
/// ------------------------------
/// 更新：Vincen
/// 时间：2014.02.28
/// </summary>
/// <param name="branchId"></param>
/// <param name="keyWords"></param>
/// <returns></returns>
public static PagedList<Product> GetProductPageList(int? branchId, string keyWords, Paging page)
{
var Db = new EmeEntities(dbRead);
var query = from p in Db.Product where p.Status != ConvertEnum.StatusTypeForDelete select p;
if (branchId.HasValue)
{
query = query.Where(p => p.ProductBranch.Any(b => b.BranchId == branchId.Value));
}
if (!string.IsNullOrEmpty(keyWords))
{
query = query.Where(p => p.CName.Contains(keyWords) || p.EName.Contains(keyWords) || p.Description.Contains(keyWords));
}
return query.OrderBy(p => p.OrderNum).ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者:Vincen
/// 时间：2014.02.28
/// 描述：根据状态获取产品列表
/// </summary>
/// <param name="sType">产品状态</param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<Product> GetProductList(StatusType sType, Paging page)
{
var Db = new EmeEntities(dbRead);
var status = CommonHelper.To<int>(sType);
var query = from p in Db.Product where p.Status == status select p;
return query.OrderBy(p => p.OrderNum).ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者：Vincen
/// 时间：2014.03.27
/// 描述：获取产品级别类型课程列表
/// </summary>
/// <param name="productLevelType"></param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<ProductLevelCourseTypeCourse> GetProductLevelCourseTypeCourseList(int productLevelType, Paging page)
{
var Db = new EmeEntities(dbRead);
var activeStatus = CommonHelper.To<int>(StatusType.Active);
var query = from a in Db.ProductLevelCourseTypeCourse
where a.ProductLevelCourseTypeId == productLevelType && a.Status == activeStatus
select a;
return query.OrderBy(p => p.Course.EName).ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者：Kylin
/// 时间：2015.1.5
/// 描述：获取培训计划列表
/// </summary>
/// <param name="userId"></param>
/// <param name="branchId"></param>
/// <param name="beginDate"></param>
/// <param name="endDate"></param>
/// <param name="isOnline"></param>
/// <param name="isSpeaker"></param>
/// <param name="searchKeyValue"></param>
/// <param name="searchKey"></param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<TrainSchedule> GetTrainScheduleListByUserId(int userId, int branchId, DateTime? beginDate, DateTime? endDate, bool? isOnline, bool? isSpeaker, string searchKeyValue, int? searchKey, Paging page)
{
var db = new EmeEntities();
var query = db.TrainSchedule.Where(p => p.Status == ConvertEnum.StatusTypeForActive
&& p.SpeakerId != userId
&& p.IsBook
&& !p.TrainRecord.Any(t => t.TrainScheduleId == p.Id && t.Status == ConvertEnum.StatusTypeForActive && t.UserId == userId && !t.IsUnBook)
&& (!p.IsRights || (p.IsRights && p.TrainRights.Any(o => o.TrainSchedule.Status == ConvertEnum.StatusTypeForActive
&& o.TrainScheduleId == p.Id
&& o.BranchId == branchId
&& o.Branch.UserBranch.Any(t => t.UserId == userId && t.BranchId == o.BranchId && t.Status == ConvertEnum.StatusTypeForActive)))));
if (beginDate.HasValue)
{
query = query.Where(p => p.BeginTime >= beginDate);
}
if (endDate.HasValue)
{
var etime = endDate.Value.AddDays(1).AddSeconds(-1);
query = query.Where(p => p.EndTime <= etime);
}
if (isOnline.HasValue && isOnline.Value)
{
query = query.Where(p => p.MeetingPlatformType != ConvertEnum.MeetingPlatformTypeForOffline);
}
if (isOnline.HasValue && !isOnline.Value)
{
query = query.Where(p => p.MeetingPlatformType == ConvertEnum.MeetingPlatformTypeForOffline);
}
//if (isSpeaker.HasValue)
//{
// query = query.Where(p => p.SpeakerId == userId);
//}
//Add search key for query
if (searchKey.HasValue && !string.IsNullOrWhiteSpace(searchKeyValue))
{
if (searchKey.Value == ConvertEnum.SearchTrainingForTitle)
{
query =
query.Where(
r => r.Subject.Contains(searchKeyValue));
}
else if (searchKey.Value == ConvertEnum.SearchTrainingForContent)
{
query =
query.Where(
r => r.TContent.Contains(searchKeyValue));
}
else if (searchKey.Value == ConvertEnum.SearchTrainingForSpeaker)
{
query =
query.Where(
r => r.Speaker.Contains(searchKeyValue));
}
}
//关键字默认查询
if (!string.IsNullOrWhiteSpace(searchKeyValue))
{
query = query.Where(r => r.Speaker.Contains(searchKeyValue)
|| r.User.UserInfo.Any(t => t.CName.Contains(searchKeyValue)
|| t.EName.Contains(searchKeyValue)) || r.Subject.Contains(searchKeyValue));
}
return query.AsNoTracking().OrderByDescending(o => o.EndTime > DateTime.Now ? 1 : 0).OrderBy(p => p.BeginTime)
.ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者：Vincen
/// 时间：2013.12.25
/// 描述：获取培训计划列表，通过中心编号
/// </summary>
/// <param name="branchId"></param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<TrainSchedule> GetTrainScheduleListByBranchId(int branchId, Paging page)
{
var db = new EmeEntities();
return db.TrainSchedule.Where(p => p.Status == ConvertEnum.StatusTypeForActive && (p.IsRights && p.TrainRights.Any(o => o.BranchId == branchId)) || !p.IsRights).AsNoTracking()
.OrderByDescending(p => p.BeginTime)
.ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者：Kylin
/// 时间：2014.04.10
/// 描述：获取培训计划列表，用于后台管理
/// </summary>
/// <param name="branchId">权限中心</param>
/// <param name="beginTime"></param>
/// <param name="endTime"></param>
/// <param name="platformType"></param>
/// <param name="searchKey"></param>
/// <param name="searchKeyValue"></param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<TrainSchedule> GetTrainScheduleList(int? branchId, DateTime? beginTime, DateTime? endTime, MeetingPlatformType? platformType, int? searchKey, string searchKeyValue, Paging page)
{
var db = new EmeEntities();
var query = db.TrainSchedule.Where(p => p.Status == ConvertEnum.StatusTypeForActive);
if (branchId.HasValue)
{
query = query.Where(p => p.TrainRights.Any(o => o.Branch.UserBranch.Any(t => (t.BranchId == branchId
|| t.Branch.ParentId == branchId) && t.IsMain)) || !p.IsRights);
}
if (beginTime.HasValue)
{
query = query.Where(p => p.BeginTime >= beginTime);
}
if (endTime.HasValue)
{
query = query.Where(p => p.EndTime >= endTime);
}
if (platformType.HasValue)
{
var pType = CommonHelper.To<int>(platformType);
query = query.Where(p => p.MeetingPlatformType == pType);
}
if (!string.IsNullOrEmpty(searchKeyValue))
{
switch (searchKey)
{
case 101: //主题
query = query.Where(p => p.Subject.Contains(searchKeyValue));
break;
case 102://内容
query = query.Where(p => p.TContent.Contains(searchKeyValue));
break;
case 103://speaker
query = query.Where(p => p.Speaker.Contains(searchKeyValue));
break;
case 104: //MeetingRoom
query = query.Where(p => p.MeetingRoom.Contains(searchKeyValue));
break;
default:
query = query.Where(p => (p.TContent.Contains(searchKeyValue) || p.Subject.Contains(searchKeyValue)));
break;
}
}
return query.AsNoTracking().OrderByDescending(p => p.BeginTime).ThenByDescending(p => p.EndTime).ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者：Kylin
/// 时间：2014.1.14
/// 描述：获取通知列表，通过用户编号
/// ---------------------------------
/// 更新：Vincen
/// 时间：2014.04.30
/// </summary>
/// <param name="branchId"></param>
/// <param name="plartFormType"></param>
/// <param name="beginDate"></param>
/// <param name="endDate"></param>
/// <param name="searchKey"></param>
/// <param name="searchKeyword"></param>
/// /// <param name="page"></param>
/// <returns></returns>
public static PagedList<Notice> GetNoticeList(int branchId, int? plartFormType, DateTime? beginDate, DateTime? endDate, int? searchKey, string searchKeyword, Paging page)
{
var Db = new EmeEntities(dbRead);
var noRightsList = Db.Notice.Where(p => p.Status == ConvertEnum.StatusTypeForActive && !p.IsRights);
var tempList = Db.Notice.Where(p => p.Status == ConvertEnum.StatusTypeForActive).
Where(p => p.NoticeRights.Any(n => n.BranchId == branchId && n.Status == ConvertEnum.StatusTypeForActive)).
Union(noRightsList);
if (plartFormType.HasValue)
{
tempList = tempList.Where(p => p.PlatformType == plartFormType);
}
if (beginDate.HasValue && beginDate != DateTime.MinValue)
{
tempList = tempList.Where(p => p.BeginDate >= beginDate);
}
if (endDate.HasValue && endDate != DateTime.MinValue)
{
tempList = tempList.Where(p => p.BeginDate <= endDate);
}
if (!searchKey.HasValue)
{
searchKey = 101;
}
if (!string.IsNullOrEmpty(searchKeyword) && searchKeyword.Length > 0)
{
switch (searchKey.Value)
{
case 101: // 主题
tempList = tempList.Where(p => p.Subject.Contains(searchKeyword));
break;
case 102: // 内容
tempList = tempList.Where(p => p.NContent.Contains(searchKeyword));
break;
default:
tempList = tempList.Where(p => p.Subject.Contains(searchKeyword));
break;
}
}
return tempList.AsNoTracking()
.OrderByDescending(p => p.SetTopTime)
.ThenByDescending(p => p.OrderNum)
.ThenBy(p => p.BeginDate)
.ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者：Beta
/// 时间：2014.01.16
/// 描述：获取公告通知 根据用户id查询（分页）
/// </summary>
/// <param name="userId"></param>
/// <param name="platformType"></param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<Notice> GetNoitceListByUserId(int userId, PlatformType platformType, Paging page)
{
var Db = new EmeEntities();
var platform = CommonHelper.To<int>(platformType);
var noRightsList = Db.Notice.Where(p => p.Status == ConvertEnum.StatusTypeForActive && p.PlatformType == platform && !p.IsRights);
var tempList =
Db.Notice.Where(
p =>
p.Status == ConvertEnum.StatusTypeForActive && p.PlatformType == platform &&
p.NoticeRights.Any(n => n.Branch.UserBranch.Any(u => u.UserId == userId)));
noRightsList = noRightsList.Union(tempList);
var allList = noRightsList.Distinct().OrderByDescending(p => p.SetTopTime).ThenBy(p => p.BeginDate).ThenBy(p => p.OrderNum).ThenByDescending(p => p.IsTop).ToPagedList(page.PageIndex, page.PageSize);
return allList;
}
/// <summary>
/// 作者：Vincen
/// 时间：2013.12.23
/// 描述：获取指定接收人的消息列表
/// </summary>
/// <param name="userId"></param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<MessageReceiver> GetMessageReceiverListListByUserId(int userId, Paging page)
{
var Db = new EmeEntities(dbRead);
var query = from a in Db.MessageReceiver
where a.Receiver == userId && a.Status == 101
orderby a.CreateTime descending
select a;
return query.ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者：Vincen
/// 时间：2014.06.18
/// 描述：获取学员报备信息 （分页）
/// </summary>
/// <param name="branchId"></param>
/// <param name="referralStageType"></param>
/// <param name="referralStatusType"></param>
/// <param name="beginDateTime"></param>
/// <param name="endDateTime"></param>
/// <param name="searchKey"></param>
/// <param name="searchKeyword"></param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<Referral> GetReferralList(int branchId, int? referralStageType, int? referralStatusType, DateTime? beginDateTime, DateTime? endDateTime, int? searchKey, string searchKeyword, Paging page)
{
var query = from a in Db.Referral
where a.Status == ConvertEnum.StatusTypeForActive &&
a.User.UserBranch.Any(p => p.BranchId == branchId && p.IsMain)
select a;
var searchKeywords = "";
if (!string.IsNullOrEmpty(searchKeyword))
{
searchKeywords = searchKeyword.Trim();
}
if (referralStageType.HasValue)
{
query = query.Where(p => p.ReferralStageType == referralStageType);
}
if (referralStatusType.HasValue)
{
query = query.Where(p => p.ReferralStatusType == referralStatusType);
}
if (beginDateTime.HasValue)
{
query = query.Where(p => p.CreateTime.HasValue ? p.CreateTime.Value >= beginDateTime.Value : true);
}
if (endDateTime.HasValue)
{
endDateTime = endDateTime.Value.AddDays(1);
query = query.Where(p => p.CreateTime.HasValue ? p.CreateTime.Value >= endDateTime.Value : true);
}
if (searchKey.HasValue && !string.IsNullOrEmpty(searchKeyword))
{
switch (searchKey.Value)
{
case 101: // 姓名
query = query.Where(p =>
p.CName.Contains(searchKeywords) ||
p.EName.Contains(searchKeywords) ||
p.User.UserInfo.Any(u => u.CName.Contains(searchKeywords)) ||
p.User.UserInfo.Any(u => u.EName.Contains(searchKeywords)));
break;
case 102: // 手机号码
query = query.Where(p => p.Mobile.Contains(searchKeywords));
break;
case 103: // SA
query = query.Where(p =>
p.User.Student.Any(s =>
s.SA.HasValue &&
Db.UserInfo.Any(u =>
u.UserId == s.SA.Value &&
(u.CName.Contains(searchKeywords) || u.EName.Contains(searchKeywords)))));
break;
case 104: // CC
query = query.Where(p =>
p.User.Student.Any(s =>
s.CC.HasValue &&
Db.UserInfo.Any(u =>
u.UserId == s.CC.Value &&
(u.CName.Contains(searchKeywords) || u.EName.Contains(searchKeywords)))));
break;
case 105: // 地址
query = query.Where(p => p.Address.Contains(searchKeywords));
break;
}
}
return query.OrderByDescending(p => p.CreateTime).ToPagedList(page.PageIndex, page.PageSize);
}
public ActionResult SearchObservationList(SearchObservationListModel searchModel,
[DefaultValue(1)] int pageIndex)
{
Session["SearchObservationListModel"] = searchModel;
var page = new Paging()
{
PageIndex = pageIndex,
PageSize = 15
};
//选项卡索引
int tabIndex = Session["ObservationTabIndex"] != null ? int.Parse(Session["ObservationTabIndex"].ToString()) : 1;
return ReserveCourse(pageIndex, tabIndex);
}
public ActionResult SearchSurveyContent(int pageIndex, int? branchId, int? platformType, string keyWord)
{
var page = new Paging()
{
PageIndex = pageIndex,
PageSize = WebCommon.Global.ManagerSmallPageSize
};
var model = SurveyBLL.GetSurveyList(branchId, platformType, keyWord, page);
return PartialView("SurveyContent", model);
}
/// <summary>
/// 作者：Raymond
/// 时间：2014-3-25
/// 描述：获取产品课节分页列表
/// </summary>
/// <param name="productId"></param>
/// <param name="productLevelId"></param>
/// <param name="productCourseTypeId"></param>
/// <param name="branchId"></param>
/// <param name="keyWord"></param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<ProductLevelCourseTypeCourse> GetProductLevelCourseTypeCoursePageList(int productId, int? productLevelId, int? productCourseTypeId, int? branchId, string keyWord, Paging page)
{
var Db = new EmeEntities();
var activeStatus = CommonHelper.To<int>(StatusType.Active);
if (string.IsNullOrEmpty(keyWord))
keyWord = "";
var query = from a in Db.ProductLevelCourseTypeCourse
join b in Db.ProductLevelCourseType on a.ProductLevelCourseTypeId equals b.Id
join c in Db.ProductLevel on b.ProductLevelId equals c.Id
where a.Status == activeStatus && c.ProductId == productId && (!productLevelId.HasValue || b.ProductLevelId == productLevelId)
&& (!productCourseTypeId.HasValue || b.ProductCourseTypeId == productCourseTypeId)
&& (a.Course.CName.Contains(keyWord))
&& (!branchId.HasValue || a.BranchId == branchId || a.IsSystem)
select a;
return query.Distinct().OrderBy(p => p.Course.CName).ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者：Beta
/// 时间：2014/04/28
/// 描述：获取反馈列表信息，通过用户ID(分页)
/// </summary>
/// <param name="userId"></param>
/// <param name="feedbackType"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public ActionResult GetFeedbackListByUserId(int userId, int feedbackType, [DefaultValue(1)]int pageIndex)
{
var page = new Paging()
{
PageIndex = pageIndex,
PageSize = 3
};
var model = FeedbackBLL.GetFeedbackListByUserId(userId, feedbackType, page);
return PartialView("_List", model);
}
/// <summary>
/// 作者：Raymond
/// 时间：2013-11-26
/// 描述：分页获取产品列表
/// </summary>
/// <returns></returns>
public static PagedList<Product> GetProductListByPaging(Paging page)
{
var Db = new EmeEntities(dbRead);
var query = from c in Db.Product where c.Status != ConvertEnum.StatusTypeForDelete select c;
return query.OrderBy(p => p.OrderNum).ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者：Raymond
/// 时间：2013-12-10
/// 描述：通过中心Id，获取缓存中的班次分页列表
/// </summary>
/// <param name="branchId"></param>
/// <param name="keyWord"></param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<WorkTime> GetWorkTimeListByBranchId(int branchId, string keyWord, Paging page)
{
var key = string.Format("{0}{1}", Klist, branchId);
var keyList = new List<string>();
if (!Icache.IsSet(key))
{
var wList = BranchBLL.GetWorkTimeListByBranchId(branchId, keyWord);
foreach (var w in wList)
{
SetWorkTimeCache(w);
keyList.Add(string.Format("{0}{1}", Kword, w.Id));
}
Icache.Set(key, keyList, 180 * 24 * 60);
}
else
{
keyList = Icache.Get<List<string>>(key) ?? new List<string>(); ;
}
var list = from k in keyList select GetWorkTimeCacheByKey(k);
if (!string.IsNullOrEmpty(keyWord))
{
list = list.Where(p => p.CName.Contains(keyWord) || p.EName.Contains(keyWord));
}
return list.OrderBy(p => p.OrderNum).AsQueryable().ToPagedList(page.PageIndex, page.PageSize);
}
public ActionResult SearchSurveyList(SearchSurveyModel search, [DefaultValue(1)]int pageIndex)
{
var page = new Paging() { PageIndex = pageIndex, PageSize = WebCommon.Global.ManagerSmallPageSize };
var model = SurveyBLL.GetSurveyList(search.BranchId, search.PlatformType, search.BeginDate, search.EndDate, search.SearchKeyWord, page);
Session["SurveySearch"] = search;
return PartialView("_SurveyList", model);
}
/// <summary>
/// 作者：monica
/// 时间:2014.12.20
/// 描述：等待确认
/// </summary>
/// <returns></returns>
public ActionResult WaitConfirmCourse([DefaultValue(1)] int pageIndex, [DefaultValue(1)] int tabIndex)
{
;
Session["ObservationTabIndex"] = tabIndex;
SearchObservationListModel searchModel = Session["SearchObservationListModel"] as SearchObservationListModel ?? new SearchObservationListModel();
var page = new Paging()
{
PageIndex = pageIndex,
PageSize = 15
};
ViewBag.CurPageIndex = pageIndex;
searchModel.IsConfirmed = null;
searchModel.IsRated = null;
searchModel.IsAttend = null;
searchModel.IsConfirmed = false;
///默认起止时间
DateTime sdate = DateTime.Now.AddDays(-(DateTime.Now.Day - 1)).Date;
DateTime edate = DateTime.Now.AddMonths(1).AddDays(-(DateTime.Now.Day)).Date;
var selObservationList = new List<ObservationModel>();
var observationList = StudyBLL.GetObserationUnConfirmList(LoginUserManager.CurrLoginUser.UserId,searchModel.BeginDate ?? sdate, searchModel.EndDate ?? edate,searchModel.SearchKey,searchModel.SearchKeyValue,page);
return PartialView("_ComfirmList", observationList);
}
/// <summary>
/// 作者：Vincen
/// 时间：2014.04.27
/// 描述：获取教室类型列表
/// </summary>
/// <param name="branchId"></param>
/// <param name="classroomType"></param>
/// <param name="keyword"></param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<Classroom> GetClassroomPagedList(int? branchId, int? classroomType, string keyword, Paging page)
{
var key = string.Format("{0}{1}", Klist, branchId);
var keyList = new List<string>();
if (!Icache.IsSet(key))
{
var bList = BranchBLL.GetClassroomList(branchId);
foreach (var b in bList)
{
SetClassroomCache(b);
keyList.Add(string.Format("{0}{1}", Kword, b.Id));
}
Icache.Set(key, keyList, 180 * 24 * 60);
}
else
{
keyList = Icache.Get<List<string>>(key) ?? new List<string>();
}
var list = from k in keyList select GetClassroomCacheByKey(k);
if (classroomType.HasValue)
{
list = list.Where(p => p.ClassroomTypeId == classroomType.Value);
}
if (!string.IsNullOrEmpty(keyword))
{
list = list.Where(p => p.ClassroomName.Contains(keyword));
}
list = list.Where(p => p.Status != ConvertEnum.StatusTypeForDelete);
return list.OrderByDescending(p => p.CreateTime).ThenBy(p => p.ClassroomName).AsQueryable().ToPagedList(page.PageIndex, page.PageSize);
}
/// <summary>
/// 作者：Vincen
/// 时间：2014.01.21
/// 描述：获取产品列表，通过其状态
/// ----------------------------------------
/// 更新：Vincen
/// 时间：2014.02.28
/// </summary>
/// <param name="branchId"></param>
/// <param name="pType"></param>
/// <param name="keyWords"></param>
/// <param name="page"></param>
/// <returns></returns>
public static PagedList<Product> GetCacheProductListByBranchId(int branchId, StatusType pType, string keyWords, Paging page)
{
var key = string.Format("{0}{1}", Klist, branchId);
var keyList = new List<string>();
if (!Icache.IsSet(key))
{
var pList = ProductBLL.GetProductListByBranchId(branchId);
foreach (var p in pList)
{
SetProductCache(p);
keyList.Add(string.Format("{0}{1}", Kword, p.Id));
}
Icache.Set(key, keyList, 180 * 24 * 60);
}
else
{
keyList = Icache.Get<List<string>>(key) ?? new List<string>(); ;
}
var list = from k in keyList select GetCacheProductByKey(k);
list = list.Where(p => p.Status == Utility.CommonHelper.To<int>(pType));
if (!string.IsNullOrEmpty(keyWords))
{
list = list.Where(p => p.CName.Contains(keyWords) || p.EName.Contains(keyWords));
}
return list.OrderBy(p => p.OrderNum).AsQueryable().ToPagedList(page.PageIndex, page.PageSize);
}