public void GetBalance(CoachStudent coachStudent, string StudentUserId, string coachId)
{
//取大课的余额
var bigCourseId = GetBigCourseId(StudentUserId, coachId);
if (!string.IsNullOrEmpty(bigCourseId))
{
var moneyObj = CoachHelper.Instance.GetBigCourseBalance(StudentUserId, bigCourseId);
if (moneyObj != null)
{
CoachStudentBalance coachStudentBalance = new CoachStudentBalance();
coachStudentBalance.Amount = moneyObj.Amount;
coachStudentBalance.TotalAmount = moneyObj.ThenTotalAmount;
//取大课最后一次上课日期
coachStudentBalance.LastGoCourseTime = CoachHelper.Instance.GetLastGoCourseTime(StudentUserId, CoachDic.BigCourse);
coachStudent.BigCourseBalance = coachStudentBalance;
}
}
//取私教的余额
var moneyObjPrivate = CoachHelper.Instance.GetPrivateCourseBalance(StudentUserId, coachId);
if (moneyObjPrivate != null)
{
CoachStudentBalance coachStudentBalance = new CoachStudentBalance();
coachStudentBalance.Amount = moneyObjPrivate.Amount;
coachStudentBalance.TotalAmount = moneyObjPrivate.ThenTotalAmount;
//取大课最后一次上课日期
coachStudentBalance.LastGoCourseTime = CoachHelper.Instance.GetLastGoCourseTime(StudentUserId, CoachDic.PrivateCourse);
coachStudent.PrivateCourseBalance = coachStudentBalance;
}
//取集训班的余额
var moneyObjBootcamp = CoachHelper.Instance.GetBootcampAllBalance(StudentUserId);
if (moneyObjBootcamp != null)
{
CoachStudentBalance coachStudentBalance = new CoachStudentBalance();
coachStudentBalance.Amount = moneyObjBootcamp.Amount;
coachStudentBalance.TotalAmount = moneyObjBootcamp.ThenTotalAmount;
coachStudentBalance.LastGoCourseTime = CoachHelper.Instance.GetLastGoCourseTimeInBootcamp(StudentUserId, CoachDic.BootcampCourse);
coachStudent.CoachBootcampBalance = coachStudentBalance;
}
}
public Response Execute(User currentUser, string request)
{
var req = JsonConvert.DeserializeObject <Request <GetCoachRelatedFilter> >(request);
//先获取教练有哪些学员
var cmd = CommandHelper.CreateProcedure <CoachStudentMoney>(text: "GetCoachStudentList");
cmd.Params.Add("@CoachId", req.Filter.CoachId);//(不传教练Id是获取所有学员)
cmd.Params.Add("@Name", req.Filter.StudentName);
cmd.CreateParamPager(req.Filter);
var result = DbContext.GetInstance().Execute(cmd);
result.SetRowCount();
List <CoachStudent> studentList = new List <CoachStudent>();
foreach (var item in result.Entities)
{
CoachStudent coachStudent = new CoachStudent();
var StudentUserId = (item as CoachStudentMoney).StudentUserId;
//获取学员的基本信息
var user = UserHelper.GetUserById(StudentUserId);
if (user == null)
{
continue;
}
coachStudent.HeadUrl = user.HeadUrl;
coachStudent.Name = UserHelper.GetUserName(user);
coachStudent.Sex = user.Sex;
coachStudent.Id = StudentUserId;
//获取学员的余额信息
GetBalance(coachStudent, StudentUserId, req.Filter.CoachId);
studentList.Add(coachStudent);
}
result.Entities.Clear();
result.Entities.AddRange(studentList);
return(result);
}
