private SyncResponse GetUserFinallyOperationRecord(SyncRequest request) { PageInit submitData = JsonHelper.DecodeJson <PageInit>(request.Data); using (var db = new fz_wisdomcampusEntities()) { clr_pageInit page = db.clr_pageInit.FirstOrDefault(p => p.UserID == submitData.UserID && p.AspxName == "Common"); return(SyncResponse.GetResponse(request, page)); } }
public PageInit GET(string UserID, int SubjectID, int GradeID) { PageInit m = new PageInit(); clr_electronic_book eb = null; List <r_resource> lRes = null; using (var db = new fz_wisdomcampusEntities()) { eb = db.clr_electronic_book.Where(w => w.UserID == UserID && w.SubjectID == SubjectID && w.GradeID == GradeID).FirstOrDefault(); } //using (var db1 = new fz_resourceEntities()) //{ // lRes = db1.r_resource.Where(w => w.ResourceCreaterID == UserID && w.SubjectID == SubjectID && w.GradeID == eb.GradeID).ToList(); //} //foreach (var ds in eb) //{ // m.Add(new PageInit // { // BookID = ds.BookID, // BookName = ds.BookID == null ? "" : Bll.DictTextbookBll.GetName((int)ds.BookID), // UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)ds.BookID).Select(s => new UnitInfo // { // UnitID = s.Id, // UnitName = s.Name // }).ToList(), // UserID = ds.UserID // }); //} m.UserID = UserID; m.BookID = eb.BookID; m.BookName = eb.BookID == null ? "" : Bll.DictTextbookBll.GetName((int)eb.BookID); //m.UnitInfo = lRes.Select(s => new UnitInfo //{ // UnitID = s.Catalog, // UnitName = s.KeyWords //}).ToList(); m.UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)eb.BookID).Select(s => new UnitInfo { UnitID = s.Id, UnitName = s.Name }).ToList(); return(m); }
/// <summary> /// 学生端获取目录信息 /// </summary> /// <param name="UserID">131b1f49-7064-4fba-a380-9c169701a818</param> /// <param name="SubjectID"></param> /// <returns></returns> public PageInit GET(string UserID, int SubjectID, int GradeID) { string tid = ""; int? grade = null; List <r_resource> lRes = 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 + 1; 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 db2 = new fz_resourceEntities()) { lRes = db2.r_resource.Where(w => w.ResourceCreaterID == tid && w.SubjectID == SubjectID && w.GradeID == GradeID).ToList(); } PageInit m = new PageInit(); clr_electronic_book eb = null; using (var db = new fz_wisdomcampusEntities()) { eb = db.clr_electronic_book.Where(w => w.UserID == tid && w.GradeID == GradeID && w.SubjectID == SubjectID).FirstOrDefault(); } m.UserID = tid; m.BookID = eb.BookID; m.BookName = eb.BookID == null ? "" : Bll.DictTextbookBll.GetName((int)eb.BookID); List <UnitInfo> nonDuplicateList1 = lRes.Select(s => new UnitInfo { UnitID = s.Catalog, UnitName = GetUnitNameStu(s.Catalog) }).Distinct().ToList(); List <UnitInfo> nonDuplicateList2 = nonDuplicateList1.Where((x, i) => nonDuplicateList1.FindIndex(z => z.UnitID == x.UnitID) == i).ToList();//Lambda表达式去重 m.UnitInfo = nonDuplicateList2; //m.UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)eb.BookID).Select(s => new UnitInfo //{ // UnitID = s.Id, // UnitName = s.Name //}).ToList(); return(m); }
/// <summary> /// 老师端获取目录信息 /// </summary> /// <param name="UserID"></param> /// <param name="SubjectID"></param> /// <param name="GradeID"></param> /// <returns></returns> public PageInit GET(string UserID, int SubjectID, int GradeID) { PageInit m = new PageInit(); clr_electronic_book eb = null; List <r_resource> lRes = null; using (var db = new fz_wisdomcampusEntities()) { eb = db.clr_electronic_book.Where(w => w.UserID == UserID && w.SubjectID == SubjectID && w.GradeID == GradeID).FirstOrDefault(); } using (var db1 = new fz_resourceEntities()) { lRes = db1.r_resource.Where(w => w.ResourceCreaterID == UserID && w.SubjectID == SubjectID && w.GradeID == eb.GradeID).ToList(); } m.UserID = UserID; m.BookID = eb.BookID; m.BookName = GetBookName(eb.BookID); List <UnitInfo> nonDuplicateList1 = lRes.Select(s => new UnitInfo { UnitID = s.Catalog, UnitName = GetUnitNameTech(s.Catalog) }).Distinct().ToList(); List <UnitInfo> nonDuplicateList2 = nonDuplicateList1.Where((x, i) => nonDuplicateList1.FindIndex(z => z.UnitID == x.UnitID) == i).ToList();//Lambda表达式去重 m.UnitInfo = nonDuplicateList2; //m.UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)eb.BookID).Select(s => new UnitInfo //{ // UnitID = s.Id, // UnitName = s.Name //}).ToList(); //string UnitID = null; //foreach (UnitInfo un in m.UnitInfo) //{ // if (un.UnitID == UnitID) // { // } // UnitID= //} return(m); }
/// <summary> /// 老师获取单元目录 /// </summary> /// <param name="UserID"></param> /// <param name="SubjectID"></param> /// <returns></returns> public PageInit GET(string UserID, int SubjectID, int GradeID) { string tid = UserID; PageInit m = new PageInit(); clr_electronic_book eb = null; using (var db = new fz_wisdomcampusEntities()) { eb = db.clr_electronic_book.Where(w => w.UserID == tid && w.GradeID == GradeID).FirstOrDefault(); } m.UserID = tid; m.BookID = eb.BookID; m.BookName = eb.BookID == null ? "" : Bll.DictTextbookBll.GetName((int)eb.BookID); m.UnitInfo = Bll.DictTextbookCatalogBll.GetTextbookCatalogByBookid((int)eb.BookID).Select(s => new UnitInfo { UnitID = s.Id, UnitName = s.Name }).ToList(); return(m); }
public override void Startup(IService service) { ContentRepository = new ContentRepository(); CategoryClassRepository = new CategoryClassRepository(); CategoryRepository = new CategoryRepository(); DepartmentRepository = new DepartmentRepository(); IdentifierRuleRepository = new IdentifierRuleRepository(); IdentifierSeqRepository = new IdentifierSeqRepository(); service .AddContentModel(ContentRepository.TableName, ContentRepository.TableColumns, ContentRepository.InputStyles) .AddDatabaseTable(CategoryClassRepository.TableName, CategoryClassRepository.TableColumns) .AddDatabaseTable(CategoryRepository.TableName, CategoryRepository.TableColumns) .AddDatabaseTable(DepartmentRepository.TableName, DepartmentRepository.TableColumns) .AddDatabaseTable(IdentifierRuleRepository.TableName, IdentifierRuleRepository.TableColumns) .AddDatabaseTable(IdentifierSeqRepository.TableName, IdentifierSeqRepository.TableColumns) .AddSiteMenu(siteId => new Menu { Text = "主动信息公开", IconClass = "ion-ios-book", Menus = new List <Menu> { new Menu { Text = "信息采集", Href = PageMain.GetRedirectUrl(siteId, Context.UtilsApi.GetAdminUrl($"cms/pageContentAdd.aspx?siteId={siteId}")) }, new Menu { Text = "信息管理", Href = PageMain.GetRedirectUrl(siteId, Context.UtilsApi.GetAdminUrl($"cms/contents.cshtml?siteId={siteId}")) }, new Menu { Text = "信息审核", Href = PageMain.GetRedirectUrl(siteId, Context.UtilsApi.GetAdminUrl($"cms/pageContentSearch.aspx?isCheckOnly=true&siteId={siteId}")) }, new Menu { Text = "分类法管理", Href = PageInit.GetRedirectUrl(siteId, PageCategoryMain.GetRedirectUrl(siteId)) }, new Menu { Text = "索引号生成规则", Href = PageInit.GetRedirectUrl(siteId, PageIdentifierRule.GetRedirectUrl(siteId)) }, new Menu { Text = "重新生成索引号", Href = PageInit.GetRedirectUrl(siteId, PageIdentifierCreate.GetRedirectUrl(siteId)) }, new Menu { Text = "部门设置", Href = "pages/departments.html" }, new Menu { Text = "信息公开设置", Href = PageInit.GetRedirectUrl(siteId, PageSettings.GetRedirectUrl(siteId)) }, new Menu { Text = "数据统计分析", Href = PageInit.GetRedirectUrl(siteId, PageAnalysis.GetRedirectUrl(siteId)) } } }); service.ContentFormSubmit += Service_ContentFormSubmited; // 页面提交处理函数 service.ContentFormLoad += Service_ContentFormLoad; // // 页面加载处理函数 }
// 插件被激活时初始化工作 public override void Startup(IService service) { PluginId = Id; service.AddContentModel(ContentDao.TableName, ContentDao.Columns) // 插件对应的内容模型表 .AddDatabaseTable(ChannelDao.TableName, ChannelDao.Columns) // 插件需要用到的其他表结构 .AddDatabaseTable(LogDao.TableName, LogDao.Columns) .AddDatabaseTable(PermissionsDao.TableName, PermissionsDao.Columns) .AddDatabaseTable(RemarkDao.TableName, RemarkDao.Columns) .AddDatabaseTable(ReplyDao.TableName, ReplyDao.Columns) .AddDatabaseTable(TypeDao.TableName, TypeDao.Columns) .AddSiteMenu(siteId => new Menu { Text = "互动交流", IconClass = "ion-chatbox-working", Menus = new List <Menu> { new Menu { Text = "待受理办件", Href = PageMain.GetRedirectUrl(siteId, PageListAccept.GetRedirectUrl(siteId, 0)) }, new Menu { Text = "待办理办件", Href = PageMain.GetRedirectUrl(siteId, PageListReply.GetRedirectUrl(siteId, 0)) }, new Menu { Text = "待审核办件", Href = PageMain.GetRedirectUrl(siteId, PageListCheck.GetRedirectUrl(siteId, 0)) }, new Menu { Text = "所有办件", Href = PageMain.GetRedirectUrl(siteId, PageListAll.GetRedirectUrl(siteId, 0)) }, new Menu { Text = "新增办件", Href = PageMain.GetRedirectUrl(siteId, $"@/cms/pageContentAdd.aspx?siteId={siteId}") }, new Menu { Text = "互动交流设置", Href = PageInit.GetRedirectUrl(siteId, PageConfiguration.GetRedirectUrl(siteId)) }, new Menu { Text = "前台页面标签", Href = PageInit.GetRedirectUrl(siteId, PageFormStyle.GetRedirectUrl(siteId)) }, new Menu { Text = "数据统计分析", Href = PageInit.GetRedirectUrl(siteId, PageAnalysis.GetRedirectUrl(siteId)) } } }); // 插件站点菜单 service.ContentFormSubmit += Service_ContentFormSubmited; // 页面提交处理函数 service.ContentFormLoad += Service_ContentFormLoad; // 页面加载处理函数 }