/// <summary>
/// 获取分页班级信息列表
/// </summary>
/// <param name="search">查询条件</param>
/// <returns></returns>
public VMEXTClassPageInfoResponse GetEXTClassByPage(EXTClassRequest search)
{
VMEXTClassPageInfoResponse response = new VMEXTClassPageInfoResponse();
response = ProductClassRepository.GetEXTClassByPage(search);
return(response);
}
public IActionResult ExportExcle(EXTClassRequest request)
{
try
{
VMEXTClassPageInfoResponse response = productClassDomainService.GetEXTClassByPage(request);
var stream = ExcelHelper.SaveExcel(response.ReusltList.ToList());
return(File(stream, "application/vnd.ms-excel", "班级信息.xlsx"));
}
catch (Exception ex)
{
_Log4Net.Error("ExportExcle--异常信息", ex);
return(null);
}
}
public BaseResponse GetEXTClassByPage(EXTClassRequest request)
{
try
{
VMEXTClassPageInfoResponse response = productClassDomainService.GetEXTClassByPage(request);
return(ApiSuccessResult(response));
//VMEXTClassPageInfoResponse response = EXTClassDomainService.GetVMEXTClassByPage(request);
//return ApiSuccessResult(response);
}
catch (Exception ex)
{
_Log4Net.Error("GetEXTClassByPage--异常信息", ex);
return(ApiErrorResult(ex.Message));
}
}
/// <summary>
/// 获取分页班级信息列表
/// </summary>
/// <param name="search">查询条件</param>
/// <returns></returns>
public VMEXTClassPageInfoResponse GetEXTClassByPage(EXTClassRequest search)
{
VMEXTClassPageInfoResponse resultInfo = new VMEXTClassPageInfoResponse();
string strWhere = string.Empty;
var _parameters = new DynamicParameters();
#region 查询条件
if (search.PocSource?.Count > 0)
{
strWhere += " and c.POCSource in @Pocsource";
_parameters.Add("@Pocsource", search.PocSource.ToArray());
}
if (search.LevelOneOrgID?.Count > 0)
{
strWhere += " and c.TeachLevelOneOrgID in @OneOrgId";
_parameters.Add("@OneOrgId", search.LevelOneOrgID.ToArray());
}
//班级状态
if (!string.IsNullOrEmpty(search.ClassStatus))
{
if ((search.ClassStatus == ((int)EXTClassStatusEnum.Enabled).ToString()) || (search.ClassStatus.ToString() == ((int)EXTClassStatusEnum.Disabled).ToString()))
{
strWhere += " and c.ClassStatus = @ClassStatus";
_parameters.Add("@ClassStatus", search.ClassStatus);
}
}
//班级名称
if (!string.IsNullOrEmpty(search.ClassName))
{
var signs = new List <string> {
"'", "[", "%", "_"
};
strWhere += " and c.ClassName like @ClassName";
_parameters.Add("@ClassName", $"%{search.ClassName.ReplaceBySigns(signs)}%");
}
#endregion
string strSql = @"(SELECT c.* ,(CASE C.POCSource WHEN '100' THEN '校管家' ELSE '' END) POCSourceName,m.CourseName,
(SELECT TOP 1 TeacherUserName FROM T_EXT_ClassTeachTime ct WHERE ct.ProductClassID=c.Id) TeacherUserName
FROM T_EXT_Class c
LEFT JOIN T_EXT_Course m on m.FromSystem= c.FromSystem and m.CourseID=c.CourseID
WHERE 1=1 " + strWhere + ") as t";
string SqlOrder = " ORDER BY t.Id desc";
if (!string.IsNullOrWhiteSpace(search.SortName))
{
SqlOrder = " ORDER BY t." + search.SortName + " " + search.SortOrder;
}
string strQuery = "SELECT * FROM " + strSql + " " + SqlOrder;
resultInfo.RecordCount = GetPageCount <VM_EXT_Class>(EumDBName.POC, strSql, "", _parameters);
string sql = string.Empty;
if (search.IsExport)
{
sql = strQuery;
}
else
{
sql = $"{strQuery} OFFSET {(search.PageIndex - 1) * search.PageSize} ROW FETCH NEXT {search.PageSize} ROWS ONLY";
}
resultInfo.ReusltList = GetInfos <VM_EXT_Class>(EumDBName.POC, sql, _parameters).AsList();
return(resultInfo);
}
