public SearchCoachResponse SearchCoach(SearchCoachRequest request) { var result = base.CreateResponse <SearchCoachResponse>("查找教练信息"); try { using (var con = new DbConnectionProvider(dbName).GetOpenConnection()) { result.Coaches = con.Query <BriefCoachDTO>("sp_SearchCoach", request, CommandType.StoredProcedure).ToList(); } //TODO 处理复杂对象查询 } catch (Exception ex) { base.HandleResponseException(ref result, ex); } return(result); }
/// <summary> /// 查找教练 /// </summary> /// <param name="request"></param> /// <returns></returns> public SearchCoachResponse SearchCoach(SearchCoachRequest request) { var result = new SearchCoachResponse() { Result = true, ResultMessage = "查找教练成功", Coaches = new List <CoachDTO>() }; try { // StringBuilder strBuilder = new StringBuilder(); // strBuilder.Append(@"SELECT DISTINCT A.CoachNumber,C.UserID,C.UserType,A.Level,C.IsInterested,C.NickName,C.PersonalSign, // B.GymName,B.Address AS GymAddress,A.HeadPortraitUri FROM Coach A LEFT JOIN Gym B ON A.GymID=B.GymID // INNER JOIN User C ON A.UserID=C.UserID LEFT JOIN CourseCoach D ON A.CoachNumber=D.CoachNumber LEFT JOIN Course E ON D.CourseNumber=E.CourseNumber"); // strBuilder.Append(" WHERE 1=1"); // if (!string.IsNullOrEmpty(request.Keyword)) strBuilder.Append(string.Format(" AND (Lower(C.NickName) Like '%{0}%' or C.Mobile='{0}')", request.Keyword)); // if (!string.IsNullOrEmpty(request.CourseName)) strBuilder.Append(string.Format(" AND E.CourseName like '%{0}%'", request.CourseName)); // var ds = MySqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings[dbName].ConnectionString, strBuilder.ToString()); // if (ds != null && ds.Tables.Count > 0) // { // var dt = ds.Tables[0]; // foreach (DataRow row in dt.Rows) // { // var coachInfo = new CoachInfoDTO() // { // CoachNumber = row["CoachNumber"].ToString(), // UserID = Convert.ToInt32(row["UserID"]), // UserType = Convert.ToSByte(row["UserType"]), // Level = Convert.ToSByte(row["Level"]), // IsInterested = Convert.ToBoolean(row["IsInterested"]), // NickName = Convert.ToString(row["NickName"]), // PersonalSign = Convert.ToString(row["PersonalSign"]), // GymName = row["GymName"].ToString(), // GymAddress = row["GymAddress"].ToString(), // HeadPortraitUri = row["HeadPortraitUri"].ToString() // }; // result.Coaches.Add(coachInfo); // //搜索Coach对应的课程信息 // string sql = string.Format(@"select B.CourseNumber,B.CourseName,B.CourseType FROM CourseCoach A inner join // Course B on A.CourseNumber=B.CourseNumber where A.CoachNumber='{0}'",row["CoachNumber"].ToString()); // var ds2 = MySqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings[dbName].ConnectionString,sql); // if (ds2 != null && ds2.Tables.Count > 0) // { // var dt2 = ds2.Tables[0]; // foreach (DataRow row2 in dt2.Rows) // { // coachInfo.CourseDesc.Add(new CourseInfoDTO() { // CourseNumber = row2["CourseNumber"].ToString(), // CourseName = row2["CourseName"].ToString(), // CourseType = Convert.ToInt16(row2["CourseType"]) // }); // }//foreach // }//if // }//foreach // } } catch (Exception ex) { result.Result = false; result.ResultMessage = "查找教练异常"; result.Errors.Add(ex.Message); } return(result); }
public SearchCoachResponse SearchCoach(SearchCoachRequest request) { return(FiveStarCoachManager.GetInstance().SearchCoach(request)); }
public SearchCoachResponse SearchCoach(SearchCoachRequest request) { return(BasicDataManager.GetInstance().SearchCoach(request)); }