/// <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); }