/// <summary> /// 采用循环 /// </summary> /// <param name="db"></param> /// <param name="id"></param> /// <returns></returns> public string GetcataidListbyXH(ModMetaEntities db, int id) { sbcata.Append(id); List <tb_Code_Knowledge> CataAllids = CacheHelper.Get("CataIds") as List <tb_Code_Knowledge>; int[] Secondcatas = CataAllids.Where(w => w.ParentID == id).Select(s => s.ID).ToArray(); foreach (int scata in Secondcatas) { if (sbcata != null) { sbcata.Append(","); } sbcata.Append(scata); int[] lcatas = CataAllids.Where(w => w.ParentID == scata).Select(s => s.ID).ToArray(); foreach (int lcata in lcatas) { if (sbcata != null) { sbcata.Append(","); } sbcata.Append(lcata); } } return(sbcata.ToString()); }
public MicroCourseModel GetMicroCourseInfo(int subjectId, int stageId) { using (var metadb = new ModMetaEntities()) { MicroCourseModel micrcomodel = new MicroCourseModel(); tb_Code_ListTable2 subject = metadb.tb_Code_ListTable2.Where(w => w.ID == subjectId && w.Deleted == 0).FirstOrDefault(); micrcomodel.subjectID = subject.ID; micrcomodel.subjectName = subject.CodeName; micrcomodel.knowledgeList = new List <KnowledgeModel>(); List <tb_Code_Knowledge> knowlist = metadb.tb_Code_Knowledge.Where(w => w.SubjectID == subjectId && w.StageID == stageId && w.Deleted == 0 && w.ParentID == 0).OrderBy(o => o.Seq).ToList(); foreach (tb_Code_Knowledge konwledge in knowlist) { KnowledgeModel knowledgemodel = new KnowledgeModel(); knowledgemodel.ID = konwledge.ID; knowledgemodel.stage = konwledge.StageID; knowledgemodel.subject = konwledge.SubjectID; knowledgemodel.CodeName = konwledge.CodeName; knowledgemodel.Children = GetKnowlegeList(metadb, knowledgemodel.ID); micrcomodel.knowledgeList.Add(knowledgemodel); } if (CacheHelper.Get("CataIds") == null) { List <tb_Code_Knowledge> listcatas = metadb.tb_Code_Knowledge.Where(w => w.Deleted == 0 && w.SubjectID == subjectId && w.StageID == stageId).OrderBy(o => o.Seq).ToList(); CacheHelper.Insert("CataIds", listcatas); } return(micrcomodel); } }
/// <summary> /// 获取学段 /// </summary> /// <returns></returns> public static List <StageModel> GetStage() { using (var db = new ModMetaEntities()) { using (var dbres = new MODResourceEntities()) { int[] stage = dbres.tb_Course.Select(s => s.SchoolStage != null?(int)s.SchoolStage:2).Distinct().ToArray(); List <StageModel> stageList = db.tb_Code_SchoolStage.Where(w => w.Deleted == 0 && stage.Contains(w.ID)).Select(s => new StageModel { stageID = s.ID, stageName = s.CodeName, IsCurrent = false }).ToList(); if (string.IsNullOrEmpty(CookieHelper.GetCookieValue("StageID"))) { CookieHelper.SetCookie("StageID", "2"); } int stageID = int.Parse(CookieHelper.GetCookieValue("StageID")); foreach (StageModel smodel in stageList) { if (smodel.stageID == stageID) { smodel.IsCurrent = true; } } return(stageList); } } }
/// <summary> /// 获取目录的子集目录 /// </summary> /// <param name="cataID"></param> /// <returns></returns> public static string GetChildCataByCataID(int bookID, int cataID) { string cataIDs = cataID.ToString(); using (var db = new ModMetaEntities()) { List <tb_StandardCatalog> list = new List <tb_StandardCatalog>(); List <StandBookCata> treeList = new List <StandBookCata>(); list = db.tb_StandardCatalog.Where(m => m.BookID == bookID && m.Deleted == 0).ToList(); foreach (var item in list) { if (item.ParentID == cataID) { StandBookCata model = new StandBookCata(); model.ID = item.ID; model.BookID = item.BookID; model.CataName = item.FolderName; model.ParentID = item.ParentID; model.PageStart = item.PageStart; model.PageStart = item.PageStart; treeList.Add(model); ///递归获取目录子集列表/// LoopToAppendChildrenForCata(list, model); } } if (treeList.Count != 0) { cataIDs += GetCataID(treeList); } } return(cataIDs); }
/// <summary> /// 获取教材通过版本 /// </summary> /// <param name="ediID"></param> /// <param name="subjectId"></param> /// <param name="stageId"></param> /// <returns></returns> public List <CourseModel> GetBookListByEditionID(int ediID, int subjectId, int stageId) { using (var db = new ModMetaEntities()) { using (var dbres = new MODResourceEntities()) { List <CourseModel> courseModelList = new List <CourseModel>(); IQueryable <tb_Course> tempCourse = dbres.tb_Course.Where(w => w.Subject == subjectId.ToString() && w.SchoolStage == stageId); courseModelList = tempCourse.Where(w => w.EditionID == ediID && w.Coursetype != "movie").OrderBy(o => o.CoursePath).Select(s => new CourseModel { CourseName = s.CourseName, EditionID = s.EditionID, GradeID = s.Grade, ID = s.ID, ImageUrl = AppSetting.ReslibUrl + "/DigitalClass/" + s.CoursePath + "/Course.gif", IsOwnApply = ((s.Coursetype != "course") ? false : true) }).ToList(); foreach (CourseModel course in courseModelList) { if (!course.IsOwnApply) { tb_Course tempcourse = dbres.tb_Course.Find(course.ID); int grade = int.Parse(tempcourse.Grade); int subject = int.Parse(tempcourse.Subject); tb_StandardBook book = db.tb_StandardBook.Where(w => w.Edition == course.EditionID && w.Subject == subject && w.Grade == grade && w.Booklet == tempcourse.BookReel).FirstOrDefault(); course.ID = book.ID; } } return(courseModelList); } } }
public string GetKnowledgeIDs(int id) { using (var metadb = new ModMetaEntities()) { string tempcataids = id.ToString(); tempcataids += ","; tempcataids += GetcataidListbyXH(metadb, id); return(tempcataids); } }
/// <summary> /// 云课堂电影课 /// </summary> /// <param name="subjectID"></param> /// <param name="stageID"></param> /// <returns></returns> public ApplyModel GetCourseAndMovice(string subjectID, int stageID) { using (var db = new ModMetaEntities()) { using (var dbres = new MODResourceEntities()) { ApplyModel appModel = new ApplyModel(); appModel.CourseAllList = new CourseAllModel(); // string[] grades = db.tb_Code_ListTable1_Relationship.Where(w => w.End_ID == stageID).Select(s => s.Start_ID.ToString()).ToArray(); IQueryable <tb_Course> tempCourse = dbres.tb_Course.Where(w => w.Subject == subjectID && w.SchoolStage == stageID); int[] edi = tempCourse.Where(w => w.Coursetype != "movie").Select(s => s.EditionID).Distinct().ToArray(); appModel.CourseAllList.EditionList = db.tb_Code_ListTable3.Where(w => edi.Contains(w.ID)).OrderBy(o => o.Seq).Select(s => new Edition { EditionID = s.ID, EditionName = s.CodeName }).ToList(); if (appModel.CourseAllList.EditionList != null && appModel.CourseAllList.EditionList.Count > 0) { int ediID = appModel.CourseAllList.EditionList[0].EditionID; appModel.CourseAllList.CourseList = tempCourse.Where(w => w.EditionID == ediID && w.Coursetype != "movie").OrderBy(o => o.CoursePath).Select(s => new CourseModel { CourseName = s.CourseName, EditionID = s.EditionID, GradeID = s.Grade, ID = s.ID, ImageUrl = AppSetting.ReslibUrl + "/DigitalClass/" + s.CoursePath + "/Course.gif", IsOwnApply = ((s.Coursetype != "course") ?false:true) }).ToList(); foreach (CourseModel course in appModel.CourseAllList.CourseList) { if (!course.IsOwnApply) { tb_Course tempcourse = dbres.tb_Course.Find(course.ID); int grade = int.Parse(tempcourse.Grade); int subject = int.Parse(tempcourse.Subject); tb_StandardBook book = db.tb_StandardBook.Where(w => w.Edition == course.EditionID && w.Subject == subject && w.Grade == grade && w.Booklet == tempcourse.BookReel && w.Deleted == 0).FirstOrDefault(); course.ID = book.ID; } } } appModel.MoviceList = tempCourse.Where(w => w.Coursetype == "movie").OrderBy(o => o.Grade).Select(s => new MovieModel { MoviceName = s.CourseName, ID = s.ID, Url = AppSetting.ReslibUrl + "/MovieListen/" + s.CoursePath + "/Start.htm", ImageUrl = AppSetting.ReslibUrl + "/MovieListen/" + s.CoursePath + "/Course.gif", SubjectID = s.Subject }).ToList(); CacheHelper.Remove("CataIds"); return(appModel); } } }
private void comboSubject_SelectionChanged(object sender, SelectionChangedEventArgs e) { using (var db = new ModMetaEntities()) { int[] edis = db.tb_Code_ListTable3_Relationship.Where(w => w.End_ID == (int)comboSubject.SelectedValue).Select(s => s.Start_ID).ToArray(); List <tb_Code_ListTable3> editionList = db.tb_Code_ListTable3.Where(w => w.Deleted == 0 && edis.Contains(w.ID)).OrderBy(o => o.Seq).ToList(); comboEdition.ItemsSource = editionList; comboEdition.SelectedValuePath = "ID"; comboEdition.DisplayMemberPath = "CodeName"; } TotalResource(); }
/// <summary> /// 采用递归 /// </summary> /// <param name="db"></param> /// <param name="id"></param> /// <returns></returns> public string GetcataidListbyDG(ModMetaEntities db, int id) { int[] catas = db.tb_Code_Knowledge.Where(w => w.Deleted == 0 && w.ParentID == id).Select(s => s.ID).ToArray(); foreach (int cata in catas) { if (!string.IsNullOrEmpty(scatalist)) { scatalist += ","; } scatalist += cata; scatalist = GetcataidListbyDG(db, cata); } return(scatalist); }
private void comboStage_SelectionChanged(object sender, SelectionChangedEventArgs e) { using (var db = new ModMetaEntities()) { int[] grades = db.tb_Code_ListTable1_Relationship.Where(w => w.End_ID == (int)comboStage.SelectedValue).Select(s => s.Start_ID).ToArray(); List <tb_Code_ListTable1> gradeList = db.tb_Code_ListTable1.Where(w => w.Deleted == 0 && grades.Contains(w.ID)).OrderBy(o => o.Seq).ToList(); gradeList.Insert(0, new tb_Code_ListTable1 { ID = 0, CodeName = "--全部--" }); comboGrade.ItemsSource = gradeList; comboGrade.SelectedValuePath = "ID"; comboGrade.DisplayMemberPath = "CodeName"; } TotalResource(); }
/// <summary> /// 根据学段id取出已有教材从而动态获取到学段所有学科 /// </summary> /// <param name="stageid">学段id</param> /// <returns></returns> public List <SubjectModel> GetSubjectByStage(int stageid) { using (var db = new ModMetaEntities()) { using (var dbres = new MODResourceEntities()) { string[] subIdlist = dbres.tb_Course.Where(w => w.SchoolStage == stageid).Select(s => s.Subject).Distinct().ToArray(); List <SubjectModel> subModel = db.tb_Code_ListTable2.Where(w => subIdlist.Contains(w.ID.ToString())).OrderBy(o => o.Seq).Select(s => new SubjectModel { SubjectID = s.ID, SubjectName = s.CodeName }).ToList(); return(subModel); } } }
/// <summary> /// 递归目录节点 /// </summary> /// <param name="db"></param> /// <param name="parentId"></param> /// <returns></returns> private List <KnowledgeModel> GetKnowlegeList(ModMetaEntities db, int parentId) { List <KnowledgeModel> knowledgeList = new List <KnowledgeModel>(); List <tb_Code_Knowledge> tempkonwledgeList = db.tb_Code_Knowledge.Where(w => w.Deleted == 0 && w.ParentID == parentId).OrderBy(o => o.Seq).ToList(); foreach (tb_Code_Knowledge konwledge in tempkonwledgeList) { KnowledgeModel knowledgemodel = new KnowledgeModel(); knowledgemodel.ID = konwledge.ID; knowledgemodel.stage = konwledge.StageID; knowledgemodel.subject = konwledge.SubjectID; knowledgemodel.CodeName = konwledge.CodeName; knowledgemodel.Children = null; knowledgeList.Add(knowledgemodel); } return(knowledgeList); }
public MainWindow() { InitializeComponent(); using (var db = new ModMetaEntities()) { List <tb_Code_ListTable2> subjectList = db.tb_Code_ListTable2.Where(w => w.Deleted == 0).OrderBy(o => o.Seq).ToList(); comboSubject.ItemsSource = subjectList; comboSubject.SelectedValuePath = "ID"; comboSubject.DisplayMemberPath = "CodeName"; List <tb_Code_SchoolStage> stageList = db.tb_Code_SchoolStage.Where(w => w.Deleted == 0).OrderBy(o => o.Seq).ToList(); comboStage.ItemsSource = stageList; comboStage.SelectedValuePath = "ID"; comboStage.DisplayMemberPath = "CodeName"; List <tb_Code_BookReel> breelList = db.tb_Code_BookReel.Where(w => w.Deleted == 0).OrderBy(o => o.Seq).ToList(); breelList.Insert(0, new tb_Code_BookReel { ID = 0, CodeName = "--全部--" }); comboBrlee.ItemsSource = breelList; comboBrlee.SelectedValuePath = "ID"; comboBrlee.DisplayMemberPath = "CodeName"; } }
private void UploadDataBase_Click(object sender, EventArgs e) { using (var db = new ModMetaEntities()) { using (var dbres = new MODResourceEntities()) { using (var dbfile = new MODkingfilesEntities()) { /////////////先增加文件信息////////////// foreach (tb_Files file in filelist) { tb_Files tempfile = dbfile.tb_Files.Find(file.ID); if (tempfile == null) { dbfile.tb_Files.Add(file); } } dbfile.SaveChanges(); /////////////再增加资源信息////////////// foreach (tb_Resource resource in resourcelist) { tb_Resource tempresource = dbres.tb_Resource.Find(resource.ID); if (tempresource == null) { if (resource.Edition == 66 && resource.Grade == 3 && resource.BookReel == 2 && resource.Subject == 1) { ViewMod_Trunt_Branch tbmodel = db.ViewMod_Trunt_Branch.Where(w => w.tID == resource.Catalog).FirstOrDefault(); resource.Catalog = tbmodel.bID; } resource.ResourceClass = 1; dbres.tb_Resource.Add(resource); } } dbres.SaveChanges(); MessageBox.Show("操作成功"); } } } }
/// <summary> /// 获取云课堂子应用 /// </summary> /// <param name="subjectID"></param> /// <param name="ediID"></param> /// <param name="gradeID"></param> /// <param name="BookletID"></param> /// <returns></returns> public ApplyPartModel GetCourseAppList(int CourseID) { using (var db = new ModMetaEntities()) { using (var dbres = new MODResourceEntities()) { ApplyPartModel applyModel = new ApplyPartModel(); applyModel.appList = new List <AppPartModel>(); tb_Course course = dbres.tb_Course.Find(CourseID); tb_StandardBook book = db.tb_StandardBook.Where(w => w.Edition == course.EditionID && w.Subject.ToString() == course.Subject && w.Grade.ToString() == course.Grade && w.Booklet == course.BookReel && w.Deleted == 0).FirstOrDefault(); applyModel.ImageUrl = AppSetting.ReslibUrl + "/DigitalClass/" + course.CoursePath + "/Course.gif"; applyModel.BookUrl = AppSetting.ReslibUrl + "/DigitalClass/" + course.CoursePath + "/Start.htm"; applyModel.appList = dbres.tb_CourseApp.Where(w => w.CourseID == CourseID).Select(apps => new AppPartModel { AppName = apps.AppName, AppType = apps.AppType, Url = apps.AppType == 0? (apps.Folder + "?BookID=" + book.ID): (AppSetting.ReslibUrl + "/DigitalClass/" + course.CoursePath + "/" + apps.Folder + "/Start.htm") }).ToList(); return(applyModel); } } }
/// <summary> /// 获取资源类型列表 /// </summary> public static List <ResourceType> GetResourceTypeList() { using (var db = new ModMetaEntities()) { List <tb_Code_TreeTable2> list = new List <tb_Code_TreeTable2>(); List <ResourceType> treeList = new List <ResourceType>(); list = db.tb_Code_TreeTable2.Where(m => m.Deleted == 0).ToList(); foreach (var item in list) { if (item.ParentID == 0) { ResourceType model = new ResourceType(); model.ID = item.ID; model.CodeName = item.CodeName; model.ParentID = item.ParentID; model.Child = new List <ResourceType>(); treeList.Add(model); ///递归获取子集列表/// LoopToAppendChildrenForResourceType(list, model); } } return(treeList); } }
public static StandBook GetStandBookByID(int bookID) { StandBook book = new StandBook(); using (var db = new ModMetaEntities()) { var list = db.tb_StandardBook.Where(m => m.ID == bookID && m.Deleted == 0).ToList(); book.ID = list[0].ID; book.BookName = list[0].BooKName; book.SubjectID = list[0].Subject; var subject = db.tb_Code_ListTable2.Where(m => m.ID == book.SubjectID && m.Deleted == 0).ToList(); book.SubjectName = subject[0].CodeName; book.StageID = list[0].Stage; var stage = db.tb_Code_SchoolStage.Where(m => m.ID == book.StageID && m.Deleted == 0).ToList(); book.StageName = stage[0].CodeName; book.EditionID = list[0].Edition; var edition = db.tb_Code_ListTable3.Where(m => m.ID == book.EditionID && m.Deleted == 0).ToList(); book.EditionName = edition[0].CodeName; } return(book); }