/// <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));
}
