public ActionResult ApplyIndex()
{
DtoApplyStudentSearch search = new DtoApplyStudentSearch();
search.SchoolId = CurrentUser.Teacher.Yoh_SchoolId;
return(View(search));
}
/// <summary>
/// 搜索申请学生列表
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public List <DtoStudentApplySchool> GetToDoApplyList(DtoApplyStudentSearch search)
{
if (search == null)
{
return(null);
}
var strWhere = new StringBuilder();
var fields = "ap.*,s.*,st.Yoh_Name AS TeacherName,st.Yoh_Phone AS TeacherPhone,sc.Bsl_SchoolName AS SchoolName ";
var orderBy = "ap.Yay_ApplyTime DESC ";
var parameters = new DynamicParameters();
strWhere.Append($@"dbo.Yw_StudentApplySchool ap
JOIN dbo.Bas_Student s ON ap.Yay_StudentId=s.Bst_Id AND s.Bst_SchoolId=0
JOIN dbo.Yw_SchoolTeacher st ON ap.Yay_TeacherId=st.Yoh_Id
JOIN dbo.Bas_School sc ON ap.Yay_SchoolId = sc.Bsl_Id
WHERE 1=1 AND ap.Yay_Status={(int)ApplyStatusEnum.申请}");
//if (search.Status > 0)
//{
// strWhere.Append(" AND ap.Yay_Status=@Yay_Status");
// parameters.Add("Yay_Status", search.Status);
//}
if (search.SchoolId > 0)
{
strWhere.Append(" AND ap.Yay_SchoolId=@Yay_SchoolId");
parameters.Add("Yay_SchoolId", search.SchoolId);
}
if (search.Grade > 0)
{
strWhere.Append(" AND s.Bst_Grade=@Grade");
parameters.Add("Grade", search.Grade);
}
if (!string.IsNullOrEmpty(search.Bst_No))
{
strWhere.Append(" AND s.Bst_No=@Bst_No");
parameters.Add("Bst_No", search.Bst_No);
}
if (!string.IsNullOrEmpty(search.SearchStr))
{
strWhere.Append(" AND (s.Bst_Name LIKE @Bst_Name OR s.Bst_NickName LIKE @Bst_NickName OR s.Bst_Phone LIKE @Bst_Phone)");
parameters.Add("Bst_Name", $"%{search.SearchStr}%");
parameters.Add("Bst_NickName", $"%{search.SearchStr}%");
parameters.Add("Bst_Phone", $"%{search.SearchStr}%");
}
return(base.QueryPaging <DtoStudentApplySchool>(fields, strWhere._ToString(), orderBy, search.Pagination, parameters).ToList());
}
public ActionResult GetApplyList(DtoApplyStudentSearch search)
{
var list = studentApplyBll.GetToDoApplyList(search);
list.ForEach(s =>
{
if (!s.Bst_Phone.HasValue() || s.Bst_Phone.Length < 11)
{
s.Bst_PhoneShow = "";
}
else
{
var tmp = s.Bst_Phone.Substring(0, 4) + "****" + s.Bst_Phone.Substring(7, 4);
s.Bst_PhoneShow = tmp;
}
s.Bst_Phone = "";
});
var table = AbhsTableFactory.Create(list, search.Pagination.TotalCount);
return(Json(table, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 学生入校申请列表
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public List <DtoStudentApplySchool> GetToDoApplyList(DtoApplyStudentSearch search)
{
return(StudentApplySchoolRepository.GetToDoApplyList(search));
}
