924 lines
41 KiB
C#
924 lines
41 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Text;
|
||
using System.Data;
|
||
|
||
using WeiSha.Common;
|
||
using Song.Entities;
|
||
|
||
using WeiSha.Data;
|
||
using Song.ServiceInterfaces;
|
||
using System.Data.Common;
|
||
using System.Text.RegularExpressions;
|
||
using NPOI.HSSF.UserModel;
|
||
using System.Xml;
|
||
using NPOI.SS.UserModel;
|
||
using System.IO;
|
||
|
||
|
||
|
||
namespace Song.ServiceImpls
|
||
{
|
||
public class LearningCardCom : ILearningCard
|
||
{
|
||
#region 学习卡设置管理
|
||
/// <summary>
|
||
/// 添加学习卡设置项
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void SetAdd(LearningCardSet entity)
|
||
{
|
||
entity.Lcs_CrtTime = DateTime.Now;
|
||
Song.Entities.Organization org = Business.Do<IOrganization>().OrganCurrent();
|
||
if (org != null) entity.Org_ID = org.Org_ID;
|
||
Gateway.Default.Save<LearningCardSet>(entity);
|
||
//生成学习卡
|
||
LearningCard[] cards = CardGenerate(entity);
|
||
if (cards != null)
|
||
{
|
||
foreach (LearningCard c in cards)
|
||
Gateway.Default.Save<LearningCard>(c);
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 修改学习卡设置项
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void SetSave(LearningCardSet entity)
|
||
{
|
||
using (DbTrans tran = Gateway.Default.BeginTrans())
|
||
{
|
||
try
|
||
{
|
||
Song.Entities.LearningCardSet rs = tran.From<LearningCardSet>().Where(LearningCardSet._.Lcs_ID == entity.Lcs_ID).ToFirst<LearningCardSet>();
|
||
LearningCard[] cards = CardGenerate(entity, tran);
|
||
if (cards != null)
|
||
{
|
||
foreach (LearningCard c in cards)
|
||
Gateway.Default.Save<LearningCard>(c);
|
||
}
|
||
tran.Update<LearningCard>(new Field[] { LearningCard._.Lc_Price, LearningCard._.Lc_LimitStart, LearningCard._.Lc_LimitEnd },
|
||
new object[] { entity.Lcs_Price, entity.Lcs_LimitStart, entity.Lcs_LimitEnd },
|
||
LearningCard._.Lcs_ID == entity.Lcs_ID && LearningCard._.Lc_IsUsed == false);
|
||
tran.Save<LearningCardSet>(entity);
|
||
tran.Commit();
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
tran.Rollback();
|
||
throw ex;
|
||
|
||
}
|
||
finally
|
||
{
|
||
tran.Close();
|
||
}
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 删除学习卡设置项
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void SetDelete(LearningCardSet entity)
|
||
{
|
||
int used = CardOfCount(entity.Org_ID, entity.Lcs_ID, true, true);
|
||
if (used > 0) throw new Exception("当前设置项中涉及的学习卡已经存在使用记录，不能删除！可以选择禁用。");
|
||
using (DbTrans tran = Gateway.Default.BeginTrans())
|
||
{
|
||
try
|
||
{
|
||
tran.Delete<LearningCardSet>(entity);
|
||
tran.Delete<LearningCard>(LearningCard._.Lcs_ID == entity.Lcs_ID);
|
||
|
||
tran.Commit();
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
tran.Rollback();
|
||
throw ex;
|
||
|
||
}
|
||
finally
|
||
{
|
||
tran.Close();
|
||
}
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 删除，按主键ID；
|
||
/// </summary>
|
||
/// <param name="identify">实体的主键</param>
|
||
public void SetDelete(int identify)
|
||
{
|
||
LearningCardSet set = SetSingle(identify);
|
||
SetDelete(set);
|
||
}
|
||
/// <summary>
|
||
/// 获取单一实体对象，按主键ID；
|
||
/// </summary>
|
||
/// <param name="identify">实体的主键</param>
|
||
/// <returns></returns>
|
||
public LearningCardSet SetSingle(int identify)
|
||
{
|
||
return Gateway.Default.From<LearningCardSet>().Where(LearningCardSet._.Lcs_ID == identify).ToFirst<LearningCardSet>();
|
||
}
|
||
/// <summary>
|
||
/// 获取所有设置项
|
||
/// </summary>
|
||
/// <param name="orgid">所在机构id</param>
|
||
/// <param name="isEnable"></param>
|
||
/// <returns></returns>
|
||
public LearningCardSet[] SetCount(int orgid, bool? isEnable, int count)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
if (orgid > 0) wc &= LearningCardSet._.Org_ID == orgid;
|
||
if (isEnable != null) wc &= LearningCardSet._.Lcs_IsEnable == isEnable;
|
||
return Gateway.Default.From<LearningCardSet>().Where(wc).OrderBy(LearningCardSet._.Lcs_CrtTime.Desc).ToArray<LearningCardSet>(count);
|
||
}
|
||
/// <summary>
|
||
/// 所有设置项数量
|
||
/// </summary>
|
||
/// <param name="orgid">机构id</param>
|
||
/// <returns></returns>
|
||
public int SetOfCount(int orgid, bool? isEnable)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
if (orgid > 0) wc &= LearningCardSet._.Org_ID == orgid;
|
||
if (isEnable != null) wc &= LearningCardSet._.Lcs_IsEnable == isEnable;
|
||
return Gateway.Default.Count<LearningCardSet>(wc);
|
||
}
|
||
/// <summary>
|
||
/// 分页获取学习卡设置项
|
||
/// </summary>
|
||
/// <param name="orgid"></param>
|
||
/// <param name="isUse"></param>
|
||
/// <param name="searTxt"></param>
|
||
/// <param name="size"></param>
|
||
/// <param name="index"></param>
|
||
/// <param name="countSum"></param>
|
||
/// <returns></returns>
|
||
public LearningCardSet[] SetPager(int orgid, bool? isEnable, string searTxt, int size, int index, out int countSum)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
if (orgid > 0) wc &= LearningCardSet._.Org_ID == orgid;
|
||
if (isEnable != null) wc &= LearningCardSet._.Lcs_IsEnable == isEnable;
|
||
if (!string.IsNullOrWhiteSpace(searTxt))
|
||
{
|
||
WhereClip like = new WhereClip();
|
||
like &= LearningCardSet._.Lcs_Theme.Like("%" + searTxt + "%");
|
||
like |= LearningCardSet._.Lcs_Intro.Like("%" + searTxt + "%");
|
||
wc.And(like);
|
||
}
|
||
countSum = Gateway.Default.Count<LearningCardSet>(wc);
|
||
return Gateway.Default.From<LearningCardSet>()
|
||
.Where(wc).OrderBy(LearningCardSet._.Lcs_CrtTime.Desc).ToArray<LearningCardSet>(size, (index - 1) * size);
|
||
}
|
||
#endregion
|
||
|
||
#region 学习卡管理
|
||
/// <summary>
|
||
/// 生成学习卡
|
||
/// </summary>
|
||
/// <param name="set">学习卡的设置项</param>
|
||
/// <param name="factor">随机因子</param>
|
||
/// <returns></returns>
|
||
public LearningCard CardGenerate(LearningCardSet set, int factor=-1)
|
||
{
|
||
Song.Entities.LearningCard card = new LearningCard();
|
||
card.Lc_Price = set.Lcs_Price; //面额
|
||
card.Lc_IsEnable = true; //是否启用
|
||
card.Lc_CrtTime = DateTime.Now; //创建时间
|
||
card.Lcs_ID = set.Lcs_ID; //设置项id
|
||
card.Org_ID = set.Org_ID; //机构id
|
||
card.Lc_LimitStart = set.Lcs_LimitStart; //时间效
|
||
card.Lc_LimitEnd = set.Lcs_LimitEnd;
|
||
//卡值码与其密码
|
||
card.Lc_Code = _CardBuildCoder(set.Lcs_SecretKey, factor, set.Lcs_CodeLength);
|
||
card.Lc_Pw = _CardBuildPw(factor, set.Lcs_PwLength);
|
||
return card;
|
||
}
|
||
/// <summary>
|
||
/// 批量生成学习卡
|
||
/// </summary>
|
||
/// <param name="set">学习卡的设置项</param>
|
||
/// <returns></returns>
|
||
public LearningCard[] CardGenerate(LearningCardSet set)
|
||
{
|
||
return CardGenerate(set, null);
|
||
}
|
||
/// <summary>
|
||
/// <param name="tran">事务</param>
|
||
/// </summary>
|
||
/// <param name="set"></param>
|
||
/// <param name="tran"></param>
|
||
/// <returns></returns>
|
||
public LearningCard[] CardGenerate(LearningCardSet set, DbTrans tran)
|
||
{
|
||
int count = 0; //要生成的数量
|
||
int realcount = Gateway.Default.Count<LearningCard>(LearningCard._.Lcs_ID == set.Lcs_ID); //实际数量
|
||
//如果实际数量小于要生成的数量，则只生成差额
|
||
if (realcount < set.Lcs_Count) count = set.Lcs_Count - realcount;
|
||
//如果实际数量小于要生成的数量，则删除多余（如果已经使用的过的，不可删除）
|
||
if (realcount > set.Lcs_Count)
|
||
{
|
||
bool isNull = false;
|
||
if (tran == null)
|
||
{
|
||
tran = Gateway.Default.BeginTrans();
|
||
isNull = true;
|
||
}
|
||
Song.Entities.LearningCard[] rcs = tran.From<LearningCard>().Where(LearningCard._.Lcs_ID == set.Lcs_ID && LearningCard._.Lc_IsUsed == false)
|
||
.ToArray<LearningCard>(realcount - set.Lcs_Count);
|
||
foreach (LearningCard r in rcs)
|
||
tran.Delete<LearningCard>(r);
|
||
if (isNull)
|
||
{
|
||
tran.Commit();
|
||
tran.Dispose();
|
||
tran.Close();
|
||
}
|
||
return null;
|
||
}
|
||
//生成学习卡
|
||
LearningCard[] cards = new LearningCard[count];
|
||
for (int i = 0; i < count; i++)
|
||
cards[i] = CardGenerate(set, i);
|
||
//判断是否重复
|
||
for (int i = 0; i < cards.Length; i++)
|
||
{
|
||
for (int j = 0; j < cards.Length; j++)
|
||
{
|
||
if (j <= i) continue;
|
||
if (cards[i].Lc_Code == cards[j].Lc_Code)
|
||
{
|
||
cards[i] = CardGenerate(set, i * j + DateTime.Now.Millisecond);
|
||
i = j = 0;
|
||
}
|
||
}
|
||
}
|
||
return cards;
|
||
}
|
||
/// <summary>
|
||
/// 添加学习卡设置项
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void CardAdd(LearningCard entity)
|
||
{
|
||
entity.Lc_CrtTime = DateTime.Now;
|
||
Gateway.Default.Save<LearningCard>(entity);
|
||
}
|
||
/// <summary>
|
||
/// 修改学习卡设置项
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void CardSave(LearningCard entity)
|
||
{
|
||
Gateway.Default.Save<LearningCard>(entity);
|
||
}
|
||
/// <summary>
|
||
/// 删除学习卡设置项
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void CardDelete(LearningCard entity)
|
||
{
|
||
CardRollback(entity);
|
||
Gateway.Default.Delete<LearningCard>(LearningCard._.Lc_ID == entity.Lc_ID);
|
||
}
|
||
/// <summary>
|
||
/// 删除，按主键ID；
|
||
/// </summary>
|
||
/// <param name="identify">实体的主键</param>
|
||
public void CardDelete(int identify)
|
||
{
|
||
LearningCard card = this.CardSingle(identify);
|
||
this.CardDelete(card);
|
||
}
|
||
/// <summary>
|
||
/// 获取单一实体对象，按主键ID；
|
||
/// </summary>
|
||
/// <param name="identify">实体的主键</param>
|
||
/// <returns></returns>
|
||
public LearningCard CardSingle(int identify)
|
||
{
|
||
return Gateway.Default.From<LearningCard>().Where(LearningCard._.Lc_ID == identify).ToFirst<LearningCard>();
|
||
}
|
||
/// <summary>
|
||
/// 获取单一实体对象，按主键ID；
|
||
/// </summary>
|
||
/// <param name="code">学习卡编码</param>
|
||
/// <param name="pw">学习卡密码</param>
|
||
/// <returns></returns>
|
||
public LearningCard CardSingle(string code, string pw)
|
||
{
|
||
return Gateway.Default.From<LearningCard>().Where(LearningCard._.Lc_Code == code && LearningCard._.Lc_Pw == pw)
|
||
.ToFirst<LearningCard>();
|
||
}
|
||
/// <summary>
|
||
/// 校验学习卡是否存在，或过期
|
||
/// </summary>
|
||
/// <param name="code"></param>
|
||
/// <returns></returns>
|
||
public LearningCard CardCheck(string code)
|
||
{
|
||
code = Regex.Replace(code, @"[^\d-]", "", RegexOptions.IgnoreCase | RegexOptions.Singleline | RegexOptions.IgnorePatternWhitespace);
|
||
if (code.IndexOf("-") < 0) throw new Exception("该学习卡不正确！");
|
||
//取密码与充值码
|
||
string pw = code.Substring(code.IndexOf("-") + 1);
|
||
code = code.Substring(0, code.IndexOf("-"));
|
||
//验证是否正确
|
||
WhereClip wc = new WhereClip();
|
||
Song.Entities.Organization org = Business.Do<IOrganization>().OrganCurrent();
|
||
wc &= LearningCard._.Org_ID == org.Org_ID;
|
||
wc &= LearningCard._.Lc_Code == code.Trim();
|
||
wc &= LearningCard._.Lc_Pw == pw.Trim();
|
||
wc &= LearningCard._.Lc_LimitStart < DateTime.Now;
|
||
wc &= LearningCard._.Lc_LimitEnd > DateTime.Now;
|
||
LearningCard single = Gateway.Default.From<LearningCard>().Where(wc).ToFirst<LearningCard>();
|
||
if (single == null) throw new Exception("该学习卡不存在，或已经过期！");
|
||
//如果学习卡已经被领用
|
||
if (single.Ac_ID > 0)
|
||
{
|
||
if (single.Lc_IsUsed && single.Lc_State != 0) throw new Exception("该学习卡已经使用过！");
|
||
}
|
||
else
|
||
{
|
||
if (single.Lc_IsUsed) throw new Exception("该学习卡已经使用过！");
|
||
}
|
||
return single;
|
||
}
|
||
/// <summary>
|
||
/// 学习卡的使用数量
|
||
/// </summary>
|
||
/// <param name="lscid"></param>
|
||
/// <returns></returns>
|
||
public int CardUsedCount(int lscid)
|
||
{
|
||
return Gateway.Default.Count<LearningCard>(LearningCard._.Lcs_ID == lscid && LearningCard._.Lc_IsUsed == true);
|
||
}
|
||
/// <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();
|
||
}
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 获取该学习卡，只是暂存在学员账户名下，并不使用
|
||
/// </summary>
|
||
/// <param name="entity"></param>
|
||
/// <param name="acc">学员账号</param>
|
||
public void CardGet(LearningCard entity, Accounts acc)
|
||
{
|
||
if (entity.Lc_State != 0) throw new Exception("该学习卡已经使用");
|
||
LearningCardSet set = this.SetSingle(entity.Lcs_ID);
|
||
if (set == null || set.Lcs_IsEnable == false) throw new Exception("该学习卡不可使用");
|
||
//是否过期
|
||
if (!(DateTime.Now > entity.Lc_LimitStart && DateTime.Now < entity.Lc_LimitEnd.Date.AddDays(1)))
|
||
throw new Exception("该学习卡已经过期");
|
||
//标注已经使用
|
||
entity.Lc_IsUsed = true;
|
||
entity.Lc_UsedTime = DateTime.Now;
|
||
entity.Lc_State = 0; //状态，0为初始，1为使用，-1为回滚
|
||
entity.Ac_ID = acc.Ac_ID;
|
||
entity.Ac_AccName = acc.Ac_AccName;
|
||
//使用数量加1
|
||
int usecount = Gateway.Default.Count<LearningCard>(LearningCard._.Lcs_ID == set.Lcs_ID && LearningCard._.Lc_IsUsed == true);
|
||
set.Lsc_UsedCount = usecount + 1;
|
||
Gateway.Default.Save<LearningCardSet>(set);
|
||
Gateway.Default.Save<LearningCard>(entity);
|
||
}
|
||
/// <summary>
|
||
/// 学习卡使用后的回滚，将删除学员的关联课程
|
||
/// </summary>
|
||
/// <param name="entity"></param>
|
||
public void CardRollback(LearningCard entity)
|
||
{
|
||
CardRollback(entity,false);
|
||
}
|
||
/// <summary>
|
||
/// 学习卡使用后的回滚，将删除学员的关联课程
|
||
/// </summary>
|
||
/// <param name="entity"></param>
|
||
/// <param name="isclear">是否清理学习记录</param>
|
||
public void CardRollback(LearningCard entity, bool isclear)
|
||
{
|
||
|
||
//只是领用，但未使用
|
||
if (entity.Lc_IsUsed && entity.Lc_State == 0)
|
||
{
|
||
//标注状态为回滚
|
||
entity.Lc_State = -1;
|
||
Gateway.Default.Save<LearningCard>(entity);
|
||
}
|
||
//真正使用过，回滚较复杂
|
||
if (entity.Lc_IsUsed && entity.Lc_State == 1)
|
||
{
|
||
LearningCardSet set = this.SetSingle(entity.Lcs_ID);
|
||
//学习时间的起始时间
|
||
int day = entity.Lc_Span;
|
||
if (day <= 0)
|
||
{
|
||
if (set.Lcs_Unit == "日" || set.Lcs_Unit == "天") day = set.Lcs_Span;
|
||
if (set.Lcs_Unit == "周") day = set.Lcs_Span * 7;
|
||
if (set.Lcs_Unit == "月") day = set.Lcs_Span * 30;
|
||
if (set.Lcs_Unit == "年") day = set.Lcs_Span * 365;
|
||
}
|
||
//关联的课程
|
||
Course[] courses = this.CoursesGet(set.Lcs_RelatedCourses);
|
||
using (DbTrans tran = Gateway.Default.BeginTrans())
|
||
{
|
||
try
|
||
{
|
||
foreach (Course cou in courses)
|
||
{
|
||
Song.Entities.Student_Course sc = tran.From<Student_Course>().Where(Student_Course._.Ac_ID == entity.Ac_ID
|
||
&& Student_Course._.Cou_ID == cou.Cou_ID).ToFirst<Student_Course>();
|
||
if (sc == null) continue;
|
||
//扣除学习卡所增加的时间，计算出学习结束时间
|
||
DateTime end = sc.Stc_EndTime.AddDays(-day);
|
||
if (sc.Stc_StartTime < end)
|
||
{
|
||
//如果扣除学习卡增加的时间后，仍然大于开始时间，则更改
|
||
tran.Update<Student_Course>(new Field[] { Student_Course._.Stc_EndTime }, new object[] { end },
|
||
Student_Course._.Ac_ID == entity.Ac_ID && Student_Course._.Cou_ID == cou.Cou_ID);
|
||
}
|
||
else
|
||
{
|
||
//如果扣除学习卡增加的时间后，小于开始时间，则直接删除课程
|
||
tran.Delete<Student_Course>(Student_Course._.Ac_ID == entity.Ac_ID && Student_Course._.Cou_ID == cou.Cou_ID);
|
||
if (isclear) _cardRollback_clear(entity.Ac_ID, cou.Cou_ID);
|
||
tran.Update<Accounts>(new Field[] { Accounts._.Ac_CurrCourse }, new object[] { -1 },
|
||
Accounts._.Ac_ID == entity.Ac_ID && Accounts._.Ac_CurrCourse == cou.Cou_ID);
|
||
}
|
||
}
|
||
entity.Lc_State = -1;
|
||
tran.Save<LearningCard>(entity);
|
||
tran.Commit();
|
||
Extend.LoginState.Accounts.Refresh(entity.Ac_ID);
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
tran.Rollback();
|
||
throw ex;
|
||
}
|
||
finally
|
||
{
|
||
tran.Close();
|
||
}
|
||
}
|
||
}
|
||
}
|
||
private void _cardRollback_clear(int acc,int couid)
|
||
{
|
||
//学习记录
|
||
Gateway.Default.Delete<LogForStudentQuestions>(LogForStudentQuestions._.Ac_ID == acc && LogForStudentQuestions._.Cou_ID==couid);
|
||
Gateway.Default.Delete<LogForStudentStudy>(LogForStudentStudy._.Ac_ID == acc && LogForStudentStudy._.Cou_ID == couid);
|
||
//试题，收藏、笔记、错题
|
||
Gateway.Default.Delete<Student_Collect>(Student_Collect._.Ac_ID == acc && Student_Collect._.Cou_ID==couid);
|
||
Gateway.Default.Delete<Student_Notes>(Student_Notes._.Ac_ID == acc && Student_Notes._.Cou_ID == couid);
|
||
Gateway.Default.Delete<Student_Ques>(Student_Ques._.Ac_ID == acc && Student_Ques._.Cou_ID == couid);
|
||
//模拟测试
|
||
Gateway.Default.Delete<TestResults>(TestResults._.Ac_ID == acc && TestResults._.Cou_ID == couid);
|
||
}
|
||
/// <summary>
|
||
/// 学习卡设置项下的所有学习卡
|
||
/// </summary>
|
||
/// <param name="orgid">所在机构id</param>
|
||
/// <param name="lcsid">充码设置项的id</param>
|
||
/// <param name="isEnable">是否启用</param>
|
||
/// <param name="isUsed">是否已经使用</param>
|
||
/// <param name="isUse"></param>
|
||
/// <returns></returns>
|
||
public LearningCard[] CardCount(int orgid, int lcsid, bool? isEnable, bool? isUsed, int count)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
if (orgid > 0) wc &= LearningCard._.Org_ID == orgid;
|
||
if (lcsid > 0) wc &= LearningCard._.Lcs_ID == lcsid;
|
||
if (isEnable != null) wc &= LearningCard._.Lc_IsEnable == isEnable;
|
||
if (isUsed != null) wc &= LearningCard._.Lc_IsUsed == isUsed;
|
||
return Gateway.Default.From<LearningCard>().Where(wc).OrderBy(LearningCard._.Lc_CrtTime.Desc).ToArray<LearningCard>(count);
|
||
}
|
||
/// <summary>
|
||
/// 所有设置项数量
|
||
/// </summary>
|
||
/// <param name="orgid">机构id</param>
|
||
/// <param name="lcsid">充码设置项的id</param>
|
||
/// <param name="isEnable">是否启用</param>
|
||
/// <param name="isUsed">是否已经使用</param>
|
||
/// <returns></returns>
|
||
public int CardOfCount(int orgid, int lcsid, bool? isEnable, bool? isUsed)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
if (orgid > 0) wc &= LearningCard._.Org_ID == orgid;
|
||
if (lcsid > 0) wc &= LearningCard._.Lcs_ID == lcsid;
|
||
if (isEnable != null) wc &= LearningCard._.Lc_IsEnable == isEnable;
|
||
if (isUsed != null) wc &= LearningCard._.Lc_IsUsed == isUsed;
|
||
return Gateway.Default.Count<LearningCard>(wc);
|
||
}
|
||
/// <summary>
|
||
/// 导出Excel格式的学习卡信息
|
||
/// </summary>
|
||
/// <param name="path">导出文件的路径（服务器端）</param>
|
||
/// <param name="orgid">机构id</param>
|
||
/// <param name="lcsid">学习卡设置项的id</param>
|
||
/// <returns></returns>
|
||
public string Card4Excel(string path, int orgid, int lcsid)
|
||
{
|
||
HSSFWorkbook hssfworkbook = new HSSFWorkbook();
|
||
//xml配置文件
|
||
XmlDocument xmldoc = new XmlDocument();
|
||
string confing = WeiSha.Common.App.Get["ExcelInputConfig"].VirtualPath + "学习卡.xml";
|
||
xmldoc.Load(WeiSha.Common.Server.MapPath(confing));
|
||
XmlNodeList nodes = xmldoc.GetElementsByTagName("item");
|
||
//创建工作簿对象
|
||
LearningCardSet rs = Gateway.Default.From<LearningCardSet>().Where(LearningCardSet._.Lcs_ID == lcsid).ToFirst<LearningCardSet>();
|
||
ISheet sheet = hssfworkbook.CreateSheet(rs.Lcs_Theme);
|
||
//sheet.DefaultColumnWidth = 30;
|
||
//创建数据行对象
|
||
IRow rowHead = sheet.CreateRow(0);
|
||
for (int i = 0; i < nodes.Count; i++)
|
||
rowHead.CreateCell(i).SetCellValue(nodes[i].Attributes["Column"].Value);
|
||
//生成数据行
|
||
ICellStyle style_size = hssfworkbook.CreateCellStyle();
|
||
style_size.WrapText = true;
|
||
WhereClip wc = LearningCard._.Org_ID == orgid;
|
||
if (lcsid >= 0) wc.And(LearningCard._.Lcs_ID == lcsid);
|
||
LearningCard[] rcodes = Gateway.Default.From<LearningCard>().Where(wc).OrderBy(LearningCard._.Lc_CrtTime.Desc).ToArray<LearningCard>();
|
||
for (int i = 0; i < rcodes.Length; i++)
|
||
{
|
||
IRow row = sheet.CreateRow(i + 1);
|
||
for (int j = 0; j < nodes.Count; j++)
|
||
{
|
||
Type type = rcodes[i].GetType();
|
||
System.Reflection.PropertyInfo propertyInfo = type.GetProperty(nodes[j].Attributes["Field"].Value); //获取指定名称的属性
|
||
object obj = propertyInfo.GetValue(rcodes[i], null);
|
||
if (obj != null)
|
||
{
|
||
string format = nodes[j].Attributes["Format"] != null ? nodes[j].Attributes["Format"].Value : "";
|
||
string datatype = nodes[j].Attributes["DataType"] != null ? nodes[j].Attributes["DataType"].Value : "";
|
||
string defvalue = nodes[j].Attributes["DefautValue"] != null ? nodes[j].Attributes["DefautValue"].Value : "";
|
||
string value = "";
|
||
switch (datatype)
|
||
{
|
||
case "date":
|
||
DateTime tm = Convert.ToDateTime(obj);
|
||
value = tm > DateTime.Now.AddYears(-100) ? tm.ToString(format) : "";
|
||
break;
|
||
default:
|
||
value = obj.ToString();
|
||
break;
|
||
}
|
||
if (defvalue.Trim() != "")
|
||
{
|
||
foreach (string s in defvalue.Split('|'))
|
||
{
|
||
string h = s.Substring(0, s.IndexOf("="));
|
||
string f = s.Substring(s.LastIndexOf("=") + 1);
|
||
if (value.ToLower() == h.ToLower()) value = f;
|
||
}
|
||
}
|
||
row.CreateCell(j).SetCellValue(value);
|
||
}
|
||
}
|
||
}
|
||
FileStream file = new FileStream(path, FileMode.Create);
|
||
hssfworkbook.Write(file);
|
||
file.Close();
|
||
return path;
|
||
}
|
||
/// <summary>
|
||
/// 分页获取学习卡设置项
|
||
/// </summary>
|
||
/// <param name="orgid">机构id</param>
|
||
/// <param name="lcsid">学习卡设置项的id</param>
|
||
/// <param name="isEnable">是否启用</param>
|
||
/// <param name="isUsed">是否已经使用</param>
|
||
/// <param name="size"></param>
|
||
/// <param name="index"></param>
|
||
/// <param name="countSum"></param>
|
||
/// <returns></returns>
|
||
public LearningCard[] CardPager(int orgid, int lcsid, bool? isEnable, bool? isUsed, int size, int index, out int countSum)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
if (orgid > 0) wc &= LearningCard._.Org_ID == orgid;
|
||
if (lcsid > 0) wc &= LearningCard._.Lcs_ID == lcsid;
|
||
if (isEnable != null) wc &= LearningCard._.Lc_IsEnable == isEnable;
|
||
if (isUsed != null) wc &= LearningCard._.Lc_IsUsed == isUsed;
|
||
countSum = Gateway.Default.Count<LearningCard>(wc);
|
||
return Gateway.Default.From<LearningCard>()
|
||
.Where(wc).OrderBy(LearningCard._.Lc_CrtTime.Desc).ToArray<LearningCard>(size, (index - 1) * size);
|
||
}
|
||
public LearningCard[] CardPager(int orgid, int lcsid, string code, bool? isEnable, bool? isUsed, int size, int index, out int countSum)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
if (orgid > 0) wc &= LearningCard._.Org_ID == orgid;
|
||
if (lcsid > 0) wc &= LearningCard._.Lcs_ID == lcsid;
|
||
if (!string.IsNullOrWhiteSpace(code)) wc &= LearningCard._.Lc_Code.Like("%" + code + "%");
|
||
if (isEnable != null) wc &= LearningCard._.Lc_IsEnable == isEnable;
|
||
if (isUsed != null) wc &= LearningCard._.Lc_IsUsed == isUsed;
|
||
countSum = Gateway.Default.Count<LearningCard>(wc);
|
||
return Gateway.Default.From<LearningCard>()
|
||
.Where(wc).OrderBy(LearningCard._.Lc_CrtTime.Desc).ToArray<LearningCard>(size, (index - 1) * size);
|
||
}
|
||
#endregion
|
||
|
||
#region 生成
|
||
/// <summary>
|
||
/// 生成单个学习卡的编码
|
||
/// </summary>
|
||
/// <param name="scretKey">密钥</param>
|
||
/// <param name="factor">随机因子</param>
|
||
/// <param name="length">充值码的长度</param>
|
||
private string _CardBuildCoder(string scretKey, int factor, int length)
|
||
{
|
||
if (factor <= 0) factor = DateTime.Now.Millisecond;
|
||
//充值码基础值（来自时间）
|
||
string baseCode = DateTime.Now.ToString("yyMMddhhmmssfff");
|
||
System.Random rd = new System.Random(((int)DateTime.Now.Ticks) * factor);
|
||
int rdNumber = rd.Next(0, 1000);
|
||
baseCode += rdNumber.ToString("000");
|
||
//充值码加密值（来自密钥中随机字符）
|
||
if (string.IsNullOrWhiteSpace(scretKey))
|
||
scretKey = WeiSha.Common.Request.UniqueID();
|
||
string pwstr = "";
|
||
while (pwstr.Length < baseCode.Length)
|
||
{
|
||
System.Random rdpw = new System.Random(pwstr.Length * factor);
|
||
int tm = rd.Next(0, scretKey.Length - 1);
|
||
pwstr += scretKey.Substring(tm, 1);
|
||
}
|
||
//基础值与加密值运算
|
||
byte[] typeBase = System.Text.Encoding.Default.GetBytes(baseCode);
|
||
byte[] typePw = System.Text.Encoding.Default.GetBytes(pwstr);
|
||
string str = "";
|
||
for (int i = 0; i < typeBase.Length; i++)
|
||
{
|
||
typeBase[i] ^= typePw[i];
|
||
str += typeBase[i].ToString();
|
||
}
|
||
return str.Substring(str.Length - length);
|
||
}
|
||
/// <summary>
|
||
/// 生成单个学习卡的密码
|
||
/// </summary>
|
||
/// <param name="factor">随机因子</param>
|
||
/// <param name="length">密码的长度</param>
|
||
/// <returns></returns>
|
||
private string _CardBuildPw(int factor, int length)
|
||
{
|
||
if (factor <= 0) factor = DateTime.Now.Millisecond;
|
||
System.Random rd = new System.Random(((int)DateTime.Now.Ticks) * factor);
|
||
string lenstr = "9";
|
||
while (lenstr.Length < length) lenstr += "9";
|
||
int max = Convert.ToInt32(lenstr);
|
||
int rdNumber = rd.Next(0, max);
|
||
return rdNumber.ToString(lenstr.Replace("9", "0"));
|
||
}
|
||
#endregion
|
||
|
||
#region 关联课程
|
||
/// <summary>
|
||
/// 获取关联的课程
|
||
/// </summary>
|
||
/// <param name="set"></param>
|
||
/// <returns></returns>
|
||
public Course[] CoursesGet(LearningCardSet set)
|
||
{
|
||
return CoursesGet(set.Lcs_RelatedCourses);
|
||
}
|
||
public Course[] CoursesGet(string xml)
|
||
{
|
||
if (string.IsNullOrWhiteSpace(xml)) return null;
|
||
XmlDocument xmlDoc = new XmlDocument();
|
||
xmlDoc.XmlResolver = null;
|
||
xmlDoc.LoadXml(xml, false);
|
||
XmlNodeList items = xmlDoc.SelectNodes("Items/item");
|
||
List<Course> list = new List<Course>();
|
||
for (int i = 0; i < items.Count; i++)
|
||
{
|
||
string couid = ((XmlElement)items[i]).GetAttribute("Cou_ID");
|
||
if (string.IsNullOrWhiteSpace(couid)) continue;
|
||
int id = 0;
|
||
int.TryParse(couid, out id);
|
||
if (id <= 0) continue;
|
||
Course cou = Business.Do<ICourse>().CourseSingle(id);
|
||
if (cou == null) continue;
|
||
list.Add(cou);
|
||
}
|
||
return list.ToArray();
|
||
}
|
||
/// <summary>
|
||
/// 学习卡关联的课程
|
||
/// </summary>
|
||
/// <param name="code">学习卡编码</param>
|
||
/// <param name="pw">学习卡密码</param>
|
||
/// <returns></returns>
|
||
public Course[] CoursesForCard(string code, string pw)
|
||
{
|
||
LearningCard card = this.CardSingle(code, pw);
|
||
if (card != null)
|
||
{
|
||
LearningCardSet set = this.SetSingle(card.Lcs_ID);
|
||
if (set != null)
|
||
{
|
||
return this.CoursesGet(set);
|
||
}
|
||
}
|
||
return null;
|
||
}
|
||
/// <summary>
|
||
/// 设置关联的课程
|
||
/// </summary>
|
||
/// <param name="set"></param>
|
||
/// <param name="courses"></param>
|
||
/// <returns>LearningCardSet对象中的Lcs_RelatedCourses将记录关联信息</returns>
|
||
public LearningCardSet CoursesSet(LearningCardSet set, Course[] courses)
|
||
{
|
||
if (courses == null || courses.Length <= 0)
|
||
{
|
||
set.Lcs_RelatedCourses = string.Empty;
|
||
set.Lcs_CoursesCount = 0;
|
||
return set;
|
||
}
|
||
int[] couid = new int[courses.Length];
|
||
for (int i = 0; i < courses.Length; i++)
|
||
couid[i] = courses[i].Cou_ID;
|
||
return CoursesSet(set, couid);
|
||
}
|
||
|
||
public LearningCardSet CoursesSet(LearningCardSet set, int[] couid)
|
||
{
|
||
if (couid == null || couid.Length < 1)
|
||
{
|
||
set.Lcs_RelatedCourses = string.Empty;
|
||
set.Lcs_CoursesCount = 0;
|
||
return set;
|
||
}
|
||
XmlDocument xmlDoc = new XmlDocument();
|
||
//创建根节点
|
||
XmlNode root = xmlDoc.CreateElement("Items");
|
||
xmlDoc.AppendChild(root);
|
||
for (int i = 0; i < couid.Length; i++)
|
||
{
|
||
XmlElement item = xmlDoc.CreateElement("item");
|
||
item.SetAttribute("Cou_ID", couid[i].ToString());
|
||
root.AppendChild(item);
|
||
}
|
||
set.Lcs_RelatedCourses = root.OuterXml;
|
||
set.Lcs_CoursesCount = couid.Length;
|
||
return set;
|
||
}
|
||
/// <summary>
|
||
/// 设置关联的课程
|
||
/// </summary>
|
||
/// <param name="set"></param>
|
||
/// <param name="couids">课程id串，以逗号分隔</param>
|
||
/// <returns></returns>
|
||
public LearningCardSet CoursesSet(LearningCardSet set, string couids)
|
||
{
|
||
List<int> list = new List<int>();
|
||
foreach (string s in couids.Split(','))
|
||
{
|
||
if (string.IsNullOrWhiteSpace(s)) continue;
|
||
if (s.Trim() == "") continue;
|
||
int id = 0;
|
||
int.TryParse(s, out id);
|
||
if (id == 0) continue;
|
||
list.Add(id);
|
||
}
|
||
return CoursesSet(set, list.ToArray());
|
||
}
|
||
#endregion
|
||
|
||
#region 学员的卡
|
||
/// <summary>
|
||
/// 学员名下学习卡的数量
|
||
/// </summary>
|
||
/// <param name="accid">学员账号id</param>
|
||
/// <returns></returns>
|
||
public int AccountCardOfCount(int accid)
|
||
{
|
||
return Gateway.Default.Count<LearningCard>(LearningCard._.Ac_ID == accid);
|
||
}
|
||
/// <summary>
|
||
/// 学员名下学习卡的数量
|
||
/// </summary>
|
||
/// <param name="accid"></param>
|
||
/// <param name="state">状态，0为初始，1为使用，-1为回滚</param>
|
||
/// <returns></returns>
|
||
public int AccountCardOfCount(int accid, int state)
|
||
{
|
||
return Gateway.Default.Count<LearningCard>(LearningCard._.Ac_ID == accid && LearningCard._.Lc_State == state);
|
||
}
|
||
/// <summary>
|
||
/// 学员名下的学习卡
|
||
/// </summary>
|
||
/// <param name="state">状态，0为初始，1为使用，-1为回滚</param>
|
||
/// <returns></returns>
|
||
public LearningCard[] AccountCards(int accid, int state)
|
||
{
|
||
return Gateway.Default.From<LearningCard>().Where(LearningCard._.Ac_ID == accid && LearningCard._.Lc_State == state)
|
||
.OrderBy(LearningCard._.Lc_UsedTime.Asc)
|
||
.ToArray<LearningCard>();
|
||
}
|
||
/// <summary>
|
||
/// 学员名下的所有学习卡
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
public LearningCard[] AccountCards(int accid)
|
||
{
|
||
return Gateway.Default.From<LearningCard>().Where(LearningCard._.Ac_ID == accid)
|
||
.OrderBy(LearningCard._.Lc_UsedTime.Asc)
|
||
.ToArray<LearningCard>();
|
||
}
|
||
#endregion
|
||
}
|
||
}
|