/// <summary>
/// 使用该学习卡
/// </summary>
/// <param name="card">学习卡</param>
/// <param name="acc">学员账号</param>
public void CardUse(LearningCard card, Accounts acc)
{
if (card.Lc_State != 0)
{
throw new Exception("该学习卡已经使用");
}
LearningCardSet set = this.SetSingle(card.Lcs_ID);
if (set == null || set.Lcs_IsEnable == false)
{
throw new Exception("该学习卡不可使用");
}
//是否过期
if (!(DateTime.Now > card.Lc_LimitStart && DateTime.Now < card.Lc_LimitEnd.Date.AddDays(1)))
{
throw new Exception("该学习卡已经过期");
}
//设置学习卡的使用信息
card.Lc_UsedTime = DateTime.Now;
card.Lc_State = 1; //状态，0为初始，1为使用，-1为回滚
card.Ac_ID = acc.Ac_ID;
card.Ac_AccName = acc.Ac_AccName;
using (DbTrans tran = Gateway.Default.BeginTrans())
{
//学习时间的起始时间
DateTime start = DateTime.Now, end = DateTime.Now;
if (set.Lcs_Unit == "日" || set.Lcs_Unit == "天")
{
end = start.AddDays(set.Lcs_Span);
}
if (set.Lcs_Unit == "周")
{
end = start.AddDays(set.Lcs_Span * 7);
}
if (set.Lcs_Unit == "月")
{
end = start.AddMonths(set.Lcs_Span);
}
if (set.Lcs_Unit == "年")
{
end = start.AddYears(set.Lcs_Span);
}
int span = (end - start).Days;
try
{
Course[] courses = this.CoursesGet(set.Lcs_RelatedCourses);
foreach (Course cou in courses)
{
Song.Entities.Student_Course sc = null;
sc = tran.From <Student_Course>().Where(Student_Course._.Ac_ID == card.Ac_ID &&
Student_Course._.Cou_ID == cou.Cou_ID).ToFirst <Student_Course>();
if (sc != null)
{
//如果是免费或试用
if (sc.Stc_IsFree || sc.Stc_IsTry)
{
sc.Stc_StartTime = start;
sc.Stc_EndTime = end;
}
else
{
//已经过期，则重新设置时间
if (sc.Stc_EndTime < DateTime.Now)
{
sc.Stc_StartTime = start;
sc.Stc_EndTime = end;
}
else
{
//如果未过期，则续期
sc.Stc_EndTime = sc.Stc_EndTime.AddDays(span);
}
}
}
else
{
sc = new Student_Course();
sc.Stc_CrtTime = DateTime.Now;
sc.Stc_StartTime = start;
sc.Stc_EndTime = end;
}
sc.Ac_ID = card.Ac_ID;
sc.Cou_ID = cou.Cou_ID;
sc.Stc_Money = card.Lc_Price;
sc.Org_ID = card.Org_ID;
sc.Stc_IsFree = sc.Stc_IsTry = false;
tran.Save <Student_Course>(sc);
}
//使用数量加1
set.Lsc_UsedCount = tran.Count <LearningCard>(LearningCard._.Lcs_ID == set.Lcs_ID && LearningCard._.Lc_IsUsed == true);
set.Lsc_UsedCount = card.Lc_IsUsed ? set.Lsc_UsedCount : set.Lsc_UsedCount + 1;
tran.Save <LearningCardSet>(set);
//标注学习卡已经使用
card.Lc_IsUsed = true;
card.Lc_Span = span; //记录学习卡使后，增加的学习时间（单位：天），方便回滚扣除
tran.Save <LearningCard>(card);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
}