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