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