public ActionResult GetSchool(DtoSchoolSearch search) { var list = schoolBll.GetSchoolList(search); var table = AbhsTableFactory.Create(list, search.Pagination.TotalCount); return(Json(table, JsonRequestBehavior.AllowGet)); }
public DtoSchool GetSchoolDto(int schoolId) { DtoSchoolSearch search = new DtoSchoolSearch(); search.SchoolId = schoolId; return(SchoolRepository.GetSchoolList(search).FirstOrDefault()); }
public List <DtoSchool> GetSchoolList(DtoSchoolSearch search) { if (search == null) { return(null); } var strWhere = new StringBuilder(); var fields = "s.*,sl.Bhl_Name AS LevelName,sl.Bhl_DividePercent,r.Reg_FullName AS RegionName ,st.Yoh_Phone AS LoginPhone "; var orderBy = "s.Bsl_Id DESC "; var parameters = new DynamicParameters(); strWhere.Append($@"dbo.Bas_School s INNER JOIN dbo.Bas_SchoolLevel sl ON s.Bsl_Level=sl.Bhl_Id AND sl.Bhl_Status = {(int)StatusEnum.有效} INNER JOIN dbo.Bas_Region r ON s.Bsl_County = r.Reg_ID LEFT JOIN dbo.Yw_SchoolTeacher st ON s.Bsl_SchoolMasterId=st.Yoh_Id AND st.Yoh_Status = {(int)StatusEnum.有效} WHERE 1=1"); if (search.SchoolId > 0) { strWhere.Append(" AND s.Bsl_Id=@Bsl_Id "); parameters.Add("Bsl_Id", search.SchoolId); } else { if (search.Status > 0) { strWhere.Append(" AND s.Bsl_Status=@Bsl_Status "); parameters.Add("Bsl_Status", search.Status); } if (search.CountyId > 0) { strWhere.Append(" AND s.Bsl_County=@CountyId "); parameters.Add("CountyId", search.CountyId); } else if (search.CityId > 0) { strWhere.Append(" AND s.Bsl_City=@CityId "); parameters.Add("CityId", search.CityId); } else if (search.ProvId > 0) { strWhere.Append(" AND s.Bsl_Province=@ProvId "); parameters.Add("ProvId", search.ProvId); } if (search.SearchStr.HasValue()) { strWhere.Append(" AND (s.Bsl_MasterName LIKE @Bsl_MasterName OR s.Bsl_MasterPhone LIKE @Bsl_MasterPhone OR s.Bsl_SchoolName=@Bsl_SchoolName) "); parameters.Add("Bsl_MasterName", $"%{search.SearchStr}%"); parameters.Add("Bsl_MasterPhone", $"%{search.SearchStr}%"); parameters.Add("Bsl_SchoolName", $"%{search.SearchStr}%"); } } return(base.QueryPaging <DtoSchool>(fields, strWhere._ToString(), orderBy, search.Pagination, parameters).ToList()); }
// GET: School #region school public ActionResult Index() { DtoSchoolSearch search = new DtoSchoolSearch(); return(View(search)); }
/// <summary> /// 学校列表 /// </summary> /// <param name="search"></param> /// <returns></returns> public List <DtoSchool> GetSchoolList(DtoSchoolSearch search) { return(SchoolRepository.GetSchoolList(search)); }