public void GetBalance(CoachCourse coachCourse, CoachCoursePersonInfo item) { if (coachCourse.Type == CoachDic.BigCourse) { var money = CoachHelper.Instance.GetBigCourseBalance(item.YdlUserId, coachCourse.BigCourseId); if (money != null) { item.Amount = money.Amount; item.ThenTotalAmount = money.ThenTotalAmount; } } else if (coachCourse.Type == CoachDic.PrivateCourse) { var money = CoachHelper.Instance.GetPrivateCourseBalance(item.YdlUserId, coachCourse.CoachId); if (money != null) { item.Amount = money.Amount; item.ThenTotalAmount = money.ThenTotalAmount; } } else if (coachCourse.Type == CoachDic.BootcampCourse) { var money = CoachHelper.Instance.GetBootcampBalance(item.YdlUserId, coachCourse.CoachBootcampId); if (money != null) { item.Amount = money.Amount; item.ThenTotalAmount = money.ThenTotalAmount; } } }
/// <summary> /// 如果此用户是ydl用户 就设置相关余额等信息 /// </summary> public void SetPersonInfo(CoachCoursePersonInfo item, CoachCourse coachCourse) { //获取基本信息 var user = UserHelper.GetUserById(item.YdlUserId); if (user != null) { item.HeadUrl = user.HeadUrl; item.Sex = user.Sex; //item.StudentName = UserHelper.GetUserName(user); } //获取余额信息 GetBalance(coachCourse, item); //如果私教有训练计划的话就赋私教的训练计划内容 if (coachCourse.Type == CoachDic.PrivateCourse) { var plan = CoachHelper.Instance.GetTrainingPlan(coachCourse.CoachId, item.YdlUserId); if (plan != null && !string.IsNullOrEmpty(plan.TrainingPlanContent)) { item.CourseContent = plan.TrainingPlanContent; } } }
//获取之前的购买记录 public CoachCourse GetPreviousBuyRecord(string reservedPersonId, string courseType, string courseNameId) { string sql = ""; if (courseType == CoachDic.BigCourse) { sql = @" SELECT TOP 1 a.*, b.Name AS VenueName, c.Name AS CourseGoalName FROM dbo.CoachStudentMoney a LEFT JOIN dbo.Venue b ON a.VenueId =b.Id LEFT JOIN dbo.SysDic c ON a.CourseGoalCode=c.Code AND c.Code!='' WHERE BigCourseInfoId=@BigCourseInfoId AND StudentUserId=@StudentUserId ORDER BY a.CreateDate DESC "; } else if (courseType == CoachDic.PrivateCourse) { sql = @" SELECT TOP 1 a.*, b.Name AS VenueName, c.Name AS CourseGoalName, d.Code AS CoachCode FROM dbo.CoachStudentMoney a LEFT JOIN dbo.Venue b ON a.VenueId =b.Id LEFT JOIN dbo.SysDic c ON a.CourseGoalCode=c.Code AND c.Code!='' LEFT JOIN dbo.UserAccount d ON a.CoachId=d.Id WHERE a.CoachId=@CoachId AND StudentUserId=@StudentUserId ORDER BY a.CreateDate DESC "; } var cmd = CommandHelper.CreateText <CoachStudentMoney>(FetchType.Fetch, sql); cmd.Params.Add("@BigCourseInfoId", courseNameId); cmd.Params.Add("@StudentUserId", reservedPersonId); cmd.Params.Add("@CoachId", courseNameId); var result = DbContext.GetInstance().Execute(cmd); CoachStudentMoney coachStudentMoney = result.FirstEntity <CoachStudentMoney>(); CoachCourse coachCourse = new CoachCourse(); if (coachStudentMoney != null) { //获取 CoachCourse对象信息 coachCourse.VenueId = coachStudentMoney.VenueId; coachCourse.VenueName = coachStudentMoney.VenueName; coachCourse.StudentRemark = coachStudentMoney.StudentRemark; coachCourse.CourseGoalCode = coachStudentMoney.CourseGoalCode; coachCourse.CourseGoalName = coachStudentMoney.CourseGoalName; coachCourse.Type = coachStudentMoney.CourseTypeId; coachCourse.CoachCode = coachStudentMoney.CoachCode; coachCourse.CoachId = coachStudentMoney.CoachId; coachCourse.BigCourseId = coachStudentMoney.BigCourseInfoId; //获取CoachCoursePersonInfo对象信息 CoachCoursePersonInfo coachCoursePersonInfo = new CoachCoursePersonInfo(); var frequentStudentObj = GetFrequentStudent(coachStudentMoney.FrequentStudentId); if (frequentStudentObj != null) { coachCoursePersonInfo.FrequentStudentId = frequentStudentObj.Id; coachCoursePersonInfo.StudentName = frequentStudentObj.Name; coachCoursePersonInfo.StudentMobile = frequentStudentObj.Mobile; coachCourse.CoursePersonInfoList.Add(coachCoursePersonInfo); } } return(coachCourse); }