/// <summary> /// 获取我的教练列表 /// </summary> /// <param name="request"></param> /// <returns></returns> public GetMyCoachListResponse GetMyCoachList(GetMyCoachListRequest request) { var result = new GetMyCoachListResponse() { Result = true, ResultMessage = "获取我的教练列表成功" }; try { // string sql = string.Format(@"SELECT DISTINCT A.CoachNumber,B.UserID,B.UserType,A.Level,B.IsInterested,B.NickName,A.PersonalSign, // E.GymName,E.Address as GymAddress,A.HeadPortraitUri // FROM Coach A INNER JOIN User B ON A.UserID=B.UserID // inner join CourseCoach C ON A.CoachNumber=C.CoachNumber // INNER JOIN CourseUser D ON C.CourseNumber=D.CourseNumber // LEFT JOIN Gym E ON A.GymID=E.GymID WHERE D.UserID={0} // ORDER BY A.CoachNumber", request.UserID); // var query = db.Database.SqlQuery<CoachInfoDTO>(sql).ToList(); // if (query == null || query.Count == 0) // { // result.ResultMessage = "没有找到我的教练信息"; // result.Coaches = new List<CoachInfoDTO>(); // return result; // } // result.Coaches = query; // foreach (var coachInfo in query) // { // //搜索Coach对应的课程信息 // string sql2 = 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}'", coachInfo.CoachNumber); // var ds2 = MySqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings[dbName].ConnectionString, sql2); // 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 // } } catch (Exception ex) { result.Result = false; result.ResultMessage = "获取我的教练列表异常"; result.Errors.Add(ex.Message); } return(result); }
public GetMyCoachListResponse GetMyCoachList(GetMyCoachListRequest request) { return(FiveStarCoachManager.GetInstance().GetMyCoachList(request)); }