/// <summary>
/// 学生获取课堂笔记
/// </summary>
/// <param name="UserID"></param>
/// <param name="SubjectID"></param>
/// <param name="UnitID"></param>
/// <returns></returns>
public List <ClassResource> GET(string UserID, int SubjectID, int UnitID)
{
string tid = "";
int? grade = null;
using (var db1 = new FzDatabase.Basic.fz_basicEntities())
{
var stu = db1.sy_student.Where(w => w.UserId == UserID.Trim()).FirstOrDefault();
grade = stu.sy_grade.SGradeId;
tid = db1.sy_teacher_and_class_and_subject.Where(w => w.ClassId == stu.Class && w.Subject == SubjectID).Select(s => s.sy_teacher.UserId).FirstOrDefault();
}
UserID = tid;
string path = System.Configuration.ConfigurationManager.AppSettings["FileServer"];
List <ClassResource> query;
using (var db = new fz_resourceEntities())
{
query = (from order in db.r_files
join d in db.r_resource on order.Id equals d.FileID
where d.ResourceCreaterID == UserID && d.SubjectID == SubjectID && d.Catalog == UnitID
select new ClassResource
{
FileID = d.FileID,
ResourceName = order.FileName,
ResourceUrl = order.FilePath,
FileExtension = order.FileExtension
}).ToList();
foreach (ClassResource cr in query)
{
cr.ResourceUrl = path + "KingsunFiles/SmartClassFile/" + Bll.SyUserBll.GetAccount(UserID) + "/" + cr.FileID + "." + cr.FileExtension;
}
}
return(query);
}
/// <summary>
/// 学生获取（课堂练习）自然拼读
/// </summary>
/// <param name="UserID"></param>
/// <returns></returns>
public List <Exercises> Get(string UserID, int SubjectID)
{
string tid = "";
int? grade = null;
using (var db1 = new FzDatabase.Basic.fz_basicEntities())
{
var stu = db1.sy_student.Where(w => w.UserId == UserID).FirstOrDefault();
grade = stu.sy_grade.SGradeId;
tid = db1.sy_teacher_and_class_and_subject.Where(w => w.ClassId == stu.Class && w.Subject == SubjectID).Select(s => s.sy_teacher.UserId).FirstOrDefault();
}
using (var db = new fz_wisdomcampusEntities())
{
return(db.clr_exercises.Where(w => w.UserID == tid.Trim()).Select(s => new Exercises
{
Resources = s.Resources
}).ToList());
}
}
