public bool HaveBalance(CoachBootcampCourseJoin obj)
{
string sql = "";
sql = @"
SELECT
SUM(Amount) AS Amount
FROM dbo.CoachStudentMoney
WHERE StudentUserId=@StudentUserId
AND CoachBootcampId=@CoachBootcampId
";
var cmd = CommandHelper.CreateText <CoachStudentMoney>(FetchType.Fetch, sql);
cmd.Params.Add("@StudentUserId", obj.StudentId);
cmd.Params.Add("@CoachBootcampId", obj.CoachBootcampId);
var result = DbContext.GetInstance().Execute(cmd);
var money = result.FirstEntity <CoachStudentMoney>();
if (money == null) //没余额记录可扣
{
return(false);
}
if (money.Amount > 0) //有余额可以扣
{
return(true);
}
else // 余额次数用完了
{
return(false);
}
}
public Response AddOne(CoachBootcampCourseJoin obj)
{
var sql = @"
UPDATE dbo.CoachStudentMoney
SET Amount=Amount+1
WHERE CoachBootcampId=@CoachBootcampId
AND StudentUserId=@StudentId
";
var cmd = CommandHelper.CreateText <ClubUser>(FetchType.Execute, sql);
cmd.Params.Add("@CoachBootcampId", obj.CoachBootcampId);
cmd.Params.Add("@StudentId", obj.StudentId);
var result = DbContext.GetInstance().Execute(cmd);
return(result);
}
