/// <summary>
/// 获取下个学习任务(支持多课程)
/// </summary>
/// <param name="memberId"></param>
/// <returns></returns>
protected ArrayList GetNextGoodsInfo(string memberId)
{
AdoHelper adoHelper = AdoHelper.CreateHelper("DB_Instance");
ArrayList list = new ArrayList();
//获取目前所有的课程
DataTable dtGroup = adoHelper.ExecuteSqlDataset("select GoodsToTypeId from V_Member_StudyRecord where MemberId='" + memberId + "' group by GoodsToTypeId").Tables[0];
foreach (DataRow row in dtGroup.Rows)
{
//获取最新的任务
DataTable curGoods = adoHelper.ExecuteSqlDataset("select top 1 * from V_Member_StudyRecord where GoodsToTypeId='" + row["GoodsToTypeId"] + "' and MemberId='" + memberId + "' order by Orderby desc").Tables[0];
if (curGoods.Rows.Count > 0)
{
//当前已完成的课程
if (curGoods.Rows[0]["IfReachedTotalTime"].ToString() == "1" && curGoods.Rows[0]["IfPassExamination"].ToString() == "1")
{
DataTable dtNext = adoHelper.ExecuteSqlDataset("select * from T_Goods_Info where GoodsToTypeId='" + row["GoodsToTypeId"] + "' and Orderby>" + curGoods.Rows[0]["Orderby"] + " order by Orderby asc").Tables[0];
if (dtNext.Rows.Count > 0)
{
string GoodsDesc = PubFunction.CheckStr(dtNext.Rows[0]["GoodsDesc"].ToString());
list.Add(dtNext.Rows[0]["GoodsId"] + "$" + dtNext.Rows[0]["GoodsName"] + "$" + GoodsDesc);
}
}
else
{
//当前未完成的课程
string GoodsDesc = PubFunction.CheckStr(curGoods.Rows[0]["GoodsDesc"].ToString());
list.Add(curGoods.Rows[0]["GoodsId"] + "$" + curGoods.Rows[0]["GoodsName"] + "$" + GoodsDesc);
}
}
}
return(list);
}
