public List <DtoMediaResourceAndObject> GetXiaoAiBianOrPrologue(PagingObject paging, int mediaType)
{
return(MediaResourceRepository.GetXiaoAiBianOrPrologue(paging, mediaType));
}
public List <Bas_SchoolLevel> GetList(PagingObject pagination)
{
return(base.QueryPaging <Bas_SchoolLevel>("*", $"Bas_SchoolLevel WHERE Bhl_Status = {(int)StatusEnum.有效}", "Bhl_Id", pagination).ToList());
}
public virtual IEnumerable <TEntity> GetPagedEntityData(IQueryable <TEntity> query, Expression <Func <TEntity, object> > orderExpression, PagingObject pagingObject)
{
Func <IQueryable <TEntity>, IOrderedQueryable <TEntity> > orderby = OrderEntities(pagingObject.SortOrder, orderExpression);
if (!pagingObject.IncludeAllDataInd)
{
int elementsToSkip = (pagingObject.PageIndex - 1) * pagingObject.PageSize;
return(orderby(query).Skip(elementsToSkip).Take(pagingObject.PageSize).ToList <TEntity>());
}
else
{
return(orderby(query).ToList <TEntity>());
}
}
/// <summary>
/// 获取推荐历史记录
/// </summary>
/// <param name="paging">分页信息</param>
/// <param name="advPosType">广告位类型</param>
/// <param name="advStatus">广告位详情状态 < 0 查所有</param>
/// <returns></returns>
public List <DtoAdvertisingPos> GetPagingAdvertisingHistory(PagingObject paging, int advPosId)
{
return(AdvertisingPosRepository.GetPagingAdvertisingHistory(paging, advPosId));
}
public List <Bas_StudentLogin> GetStudentLogin(PagingObject paging, int studentId)
{
var sql = "Bas_StudentLogin where Bsg_StudentId=@StudentId";
return(QueryPaging <Bas_StudentLogin>("*", sql, "Bsg_LoginTime DESC", paging, new { StudentId = studentId }).ToList());
}
/// <summary>
/// Search the specified tenantId, operatorId, paging and sortedFields.
/// </summary>
/// <returns>The search.</returns>
/// <param name="tenantId">Tenant identifier.</param>
/// <param name="operatorId">Operator identifier.</param>
/// <param name="paging">Paging.</param>
/// <param name="sortedFields">Sorted fields.</param>
public IList <User> Search(int tenantId, int operatorId, PagingObject paging, List <SortedField> sortedFields)
{
return(_userDao.SearchUser(tenantId, operatorId, paging, sortedFields).Select(user => user.ToBusinessObject()).ToList());
}
public List <DtoMediaResourceAndObject> GetXiaoAiBianOrPrologue(PagingObject paging, int mediaType)
{
var sql = "Yw_MediaResource inner join Yw_MediaObject on Ymr_MediaObjectId=Yme_Id where Ymr_MediaType=@MediaType and Ymr_Status=1 and Yme_Status=1";
return(QueryPaging <DtoMediaResourceAndObject>("*", sql, "Ymr_CreateTime DESC", paging, new { MediaType = mediaType }).ToList());
}
public List<DtoStudentOrder> GetStudentOrderByStudentId(PagingObject paging, int studentId)
{
return OrderService.GetStudentOrderByStudentId(paging, studentId);
}
public List <Table> GetPagingTable(string fields, string where, string orderby, PagingObject paging)
{
List <Table> list = base.QueryPaging <Table>(fields, where, orderby, paging).ToList();
return(list);
}
public List <DtoCashVoucher> GetPagingCashVoucher(PagingObject paging, int id, string name, int status, int voucherType)
{
return(CashVoucherRepository.GetPagingCashVoucher(paging, id, name, status, voucherType));
}
public List <DtoCashVoucher> GetPagingCashVoucherForSchool(PagingObject paging, int id, string name, int status, int schoolId)
{
return(CashVoucherRepository.GetPagingCashVoucherForSchool(paging, id, name, status, schoolId));
}
public List <DtoStudentCashVoucher> GetPagingStudentCashVoucher(PagingObject paging, int cashVoucherId, int status, string usedReferNo)
{
return(StudentCashVoucherRepository.GetPagingStudentCashVoucher(paging, cashVoucherId, status, usedReferNo));
}
public IList <DtoProductCategory> GetPagingProduct(PagingObject paging, int id)
{
return(Service.GetPagingProduct(paging, id));
}
public List <Yw_ResourceGroup> GetPagingResourceGroup(PagingObject paging, int id, string name, int grade, int status)
{
return(ResourceGroupRepository.GetPagingResourceGroup(paging, id, name, grade, status));
}
/// <summary>
/// 选课中心课程列表,不包含价格
/// </summary>
public List <DtoSelectCenterCourseObject> GetCourseWithoutPrice(DtoCourseSelectCondition condition, PagingObject paging)
{
string field = $@"a.Ycs_Id as CourseId,a.Ycs_Name as CourseName,a.Ycs_CoverImage as CourseImage,
a.Ycs_SellCount as SellCount,a.Ycs_Grade as Grade,a.Ycs_CourseType as CourseType,a.Ycs_LessonCount as LessonCount";
string where = $@"yw_course a
where a.ycs_status = 3 {condition.GradeExpression} {condition.CourseTypeExpression}";
string orderBy = condition.OrderExpression;
return(QueryPaging <DtoSelectCenterCourseObject>(field, where, orderBy, paging, new { SchoolLevelId = condition.SchoolLevel, Grade = condition.Grade, CourseType = condition.CourseType }).ToList());
}
/// <summary>
/// 选课中心课程列表
/// </summary>
public List <DtoSelectCenterResult> GetCourseForSelectCenter(DtoCourseSelectCondition condition, PagingObject paging, out bool includePrice)
{
SchoolBll schBll = new SchoolBll();
Bas_School school = schBll.GetSchoolByStudent(condition.StudentId);
if (school != null)
{
includePrice = true;
return(GetCourseWithPriceForSelectCenter(school, condition, paging));
}
else
{
includePrice = false;
return(GetCourseWithoutPriceForSelectCenter(condition, paging));
}
}
public List <Table> GetPagingTable(string fields, string where, string orderby, PagingObject paging)
{
List <Table> list = Service.GetPagingTable(fields, where, orderby, paging);
return(list);
}
/// <summary>
/// 选课中心课程列表不包含价格（学生没有绑定校区）
/// </summary>
/// <param name="condition"></param>
/// <param name="paging"></param>
/// <returns></returns>
private List <DtoSelectCenterResult> GetCourseWithoutPriceForSelectCenter(DtoCourseSelectCondition condition, PagingObject paging)
{
List <DtoSelectCenterResult> results = new List <DtoSelectCenterResult>();
List <DtoSelectCenterCourseObject> courseList = CourseRepository.GetCourseWithoutPrice(condition, paging);
if (courseList.Count > 0)
{
foreach (DtoSelectCenterCourseObject obj in courseList)
{
results.Add(CreateSelectCenterResultItem(obj));
}
}
return(results);
}
public virtual List <LeaveRequest> GetLeaveRequests(int?employeeId, int?teamId, string searchText, PagingObject pagingObject = null,
Expression <Func <LeaveRequest, object> > orderExpression = null, string includeProperties = "")
{
IQueryable <LeaveRequest> query = (from leaveRequest in _Context.LeaveRequests
select leaveRequest);
if (query == null)
{
return(new List <LeaveRequest>());
}
if (teamId != null)
{
query = from leaveRequest in query
join employee in _Context.Employees on leaveRequest.EmployeeId equals employee.EmployeeId
where employee.TeamId == teamId.Value
select leaveRequest;
}
else
{
query = from leaveRequest in query
where leaveRequest.EmployeeId == employeeId.Value
select leaveRequest;
}
if (!string.IsNullOrEmpty(searchText))
{
query = from leaveRequest in query
where leaveRequest.LeaveDescription.Contains(searchText)
select leaveRequest;
}
if (query == null)
{
return(new List <LeaveRequest>());
}
if (!string.IsNullOrEmpty(includeProperties))
{
query = Include(query, includeProperties);
}
if (pagingObject != null)
{
return(GetPagedEntityData(query, orderExpression, pagingObject).ToList());
}
return(query.ToList());
}
/// <summary>
/// 选课中心课程列表包含价格（学生已经绑定校区）
/// </summary>
private List <DtoSelectCenterResult> GetCourseWithPriceForSelectCenter(Bas_School school, DtoCourseSelectCondition condition, PagingObject paging)
{
List <DtoSelectCenterResult> results = new List <DtoSelectCenterResult>();
condition.SetSchoolLevel(school.Bsl_Level);
condition.SetSchoolId(school.Bsl_Id);
List <DtoSelectCenterCourseObject> courseList = CourseRepository.GetCourseWithPrice(condition, paging);
if (courseList.Count > 0)
{
List <DtoSimpleCourse> simpleCourses = courseList.Select(
x => new DtoSimpleCourse()
{
CourseId = x.CourseId, Amount = x.CoursePrice, CourseType = x.CourseType, Grade = x.Grade
})
.ToList();
Dictionary <string, decimal> voucherDic = GetVoucherDicForUserCourse(simpleCourses, condition);
foreach (DtoSelectCenterCourseObject obj in courseList)
{
results.Add(CreateSelectCenterResultItem(obj, voucherDic));
}
}
return(results);
}
/// <summary>
/// 获取推荐楼层信息
/// </summary>
/// <param name="paging">分页信息</param>
/// <param name="advPosType">广告位类型</param>
/// <param name="advStatus">广告位详情状态 < 0 查所有</param>
/// <returns></returns>
public List <DtoAdvertisingPos> GetPagingAdvertisingPos(PagingObject paging, int advPosType, int advStatus)
{
return(AdvertisingPosRepository.GetPagingAdvertisingPos(paging, advPosType, advStatus));
}
/// <summary>
/// Search the specified tenantId, operatorId, pId, paging and sortedFields.
/// </summary>
/// <returns>The search.</returns>
/// <param name="tenantId">Tenant identifier.</param>
/// <param name="operatorId">Operator identifier.</param>
/// <param name="pId">P identifier.</param>
/// <param name="paging">Paging.</param>
/// <param name="sortedFields">Sorted fields.</param>
public IList <Organization> Search(int tenantId, int operatorId, int pId, PagingObject paging, List <SortedField> sortedFields)
{
return(_organizationDao.GetOrganizationsByLevel(tenantId, operatorId, pId, paging, sortedFields).Select(org => org.ToBusinessObject()).ToList());
}
public IList <Role> Search(int tenantId, int operatorId, PagingObject paging, List <SortedField> sortedFields)
{
return(_roleDao.GetRoles(tenantId, operatorId, paging, sortedFields).Select(role => role.ToBusinessObject()).ToList());
}
public List <DtoProductCategory> GetPagingProduct(PagingObject paging, int id)
{
return(base.QueryPaging <DtoProductCategory>("a.Id,a.Name as ProductName,b.Name as CatName", "Product a inner join ProductCategory b on a.CatId=b.Id and a.Id<=@Id", "a.Id", paging, new { Id = id }).ToList());
}
public List <Bas_StudentLogin> GetStudentLogin(PagingObject paging, int studentId)
{
return(StudentLoginRepository.GetStudentLogin(paging, studentId));
}
public List <DtoEmployee> GetPagingEmployee(PagingObject paging, string accountOrNameOrPhone, int bro_id, int status)
{
return(BllEmployeeRepository.GetPagingEmployee(paging, accountOrNameOrPhone, bro_id, status));
}
public virtual IEnumerable <TEntity> GetPagedEntities(Expression <Func <TEntity, bool> > filter = null, Expression <Func <TEntity, object> > orderExpression = null, PagingObject pagingObject = null, string includeProperties = "")
{
IQueryable <TEntity> query = _DbSet;
if (filter != null)
{
query = query.Where(filter);
}
if (!string.IsNullOrEmpty(includeProperties))
{
query = Include(query, includeProperties);
}
if (orderExpression != null)
{
return(GetPagedEntityData(query, orderExpression, pagingObject));
}
return(query.ToList());
}
/// <summary>
/// Gets the menus.
/// </summary>
/// <returns>The menus.</returns>
/// <param name="tenantId">Tenant identifier.</param>
/// <param name="operatorId">Operator identifier.</param>
public IList <Menu> Search(int tenantId, int operatorId, PagingObject paging, List <SortedField> sortedFields)
{
return(_menuDao.GetMenus(tenantId, operatorId, paging, sortedFields).Select(menu => menu.ToBusinessObject()).ToList());
}
/// <summary>
/// Gets the organizations by level.
/// </summary>
/// <returns>The organizations by level.</returns>
/// <param name="tenantId">Tenant identifier.</param>
/// <param name="operatorId">Operator identifier.</param>
/// <param name="pId">P identifier.</param>
public IList <OrganizationDO> GetOrganizationsByLevel(int tenantId, int operatorId, int pId, PagingObject paging, List <SortedField> sortedFields)
{
var sql = "SELECT * FROM public.organization where tenantid=@tenantid and parentid=@pid";
sql = sql.Sort(sortedFields);
if (paging != null)
{
sql = sql.Paging(paging);
}
return(Query <OrganizationDO>(sql, new { tenantId, pId }));
}
public List <DtoStudentOrder> GetStudentOrderByStudentId(PagingObject paging, int studentId)
{
string sql = "Yw_StudentOrder inner join Yw_Course on Yod_CourseId=Ycs_Id where Yod_StudentId=@StudentId";
return(QueryPaging <DtoStudentOrder>("Yw_StudentOrder.*,Ycs_Name as CourseName", sql, "Yod_OrderTime DESC", paging, new { StudentId = studentId }).ToList());
}
