public JsonResult TimesAdd(int classid, long aboutid) {///1点一点;2听一听;3看一看; ///4课程讲解;5幼儿公开课;6教育技能; ///7操作说明;8教师社区;9精彩瞬间;12用户录音 bool isOk = false; StatusData myStatusData = new StatusData();//返回状态 DataOptionClass myDataOptionClass = new DataOptionClass(); isOk = myDataOptionClass.TimesAdd(classid, aboutid); if (isOk) { myStatusData.operateStatus = 200; } else { myStatusData.operateStatus = 400; } return(Json(myStatusData)); }
public ActionResult ItemList(int currentpage = 1, int status = 0, long del = 0) { #region 翻页定义 ViewBag.CurrentPage = 0; //当前页 ViewBag.PPage = 0; //上一页 ViewBag.NPage = 0; //下一页 ViewBag.PageCount = 0; //总页数 ViewBag.RecordCount = 0; //记录总数 ViewBag.IsFirstPage = ""; //第一条记录,禁用首页和上一页 ViewBag.IsEndPage = ""; //最后条记录,禁用首页和下一页 #endregion // ViewBag.Headline = "文章列表";//栏目主题 // ViewBag.DataList = null; ViewBag.RecordItem = null; // StatusData myStatusData = new StatusData(); //返回状态 // using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作 { #region 除 if (del > 0) { Discover_Article myDelRecord = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == del); if (myDelRecord != null) { FunctionClass.delFile(myDelRecord.ArticleImages); FunctionClass.delFile(myDelRecord.ArticleVideo); myOperating.Discover_Article.Remove(myDelRecord); #region 步删除收藏中的内容 DataOptionClass myDataOptionClass = new DataOptionClass(); myDataOptionClass.CollectOption(9, del, true);//删除收藏中的内容 #endregion myOperating.SaveChanges(); } } #endregion // #region 审核 if (status > 0) { Discover_Article myStatusRecord = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == status); if (myStatusRecord != null) { if (myStatusRecord.Status == 200) { myStatusRecord.Status = 300; } else { myStatusRecord.Status = 200; } myOperating.SaveChanges(); } } #endregion // #region 翻页属性 int recordCount = 0; int pageCount = 0; string orderbyfiled = "ArticlId"; // //当前页 int sqlCurrentpage = currentpage; if (sqlCurrentpage < 1) { sqlCurrentpage = 1; } //页大小 int sqlPagesize = 10; #endregion // #region 取出内容 IQueryable <Discover_Article> myIQueryable = null; myIQueryable = myOperating.Discover_Article; // if (myIQueryable != null) { IQueryable <Discover_Article> BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, true); List <DiscoverArticleList> myDiscoverArticleList = new List <DiscoverArticleList>(); long temId = 0; foreach (Discover_Article item in BookTable) { temId = item.ArticlId; DiscoverArticleList DiscoverArticleItem = new DiscoverArticleList(); DiscoverArticleItem.ArticlId = temId; DiscoverArticleItem.ArticleTitle = item.ArticleTitle; DiscoverArticleItem.AddDate = item.AddDate; DiscoverArticleItem.MobilePhone = item.MobilePhone; DiscoverArticleItem.ReadTimes = item.ReadTimes; DiscoverArticleItem.Status = item.Status; DiscoverArticleItem.CommentCount = myOperating.Discover_Article_Comment.Count(p => p.AboutId == temId); myDiscoverArticleList.Add(DiscoverArticleItem); } // ViewBag.DataList = myDiscoverArticleList; #region 页数取值 ViewBag.CurrentPage = sqlCurrentpage; ViewBag.PageCount = pageCount; ViewBag.RecordCount = recordCount; if (sqlCurrentpage > 1) { ViewBag.PPage = sqlCurrentpage - 1; } else { ViewBag.IsFirstPage = "disabled"; ViewBag.PPage = 1; } if (sqlCurrentpage < pageCount) { ViewBag.NPage = sqlCurrentpage + 1; } else { ViewBag.NPage = sqlCurrentpage; ViewBag.IsEndPage = "disabled"; } #endregion } #endregion } return(View()); }
public ActionResult ItemList(int currentpage = 1, int ClassId = 0, long del = 0) { #region 翻页定义 ViewBag.CurrentPage = 0; //当前页 ViewBag.PPage = 0; //上一页 ViewBag.NPage = 0; //下一页 ViewBag.PageCount = 0; //总页数 ViewBag.RecordCount = 0; //记录总数 ViewBag.IsFirstPage = ""; //第一条记录,禁用首页和上一页 ViewBag.IsEndPage = ""; //最后条记录,禁用首页和下一页 #endregion // ViewBag.Headline = "图书管理";//栏目主题 // ViewBag.DataList = null; ViewBag.RecordItem = null; ViewBag.Operate = "add"; //add添加;edit编辑取出数据;editsave编辑保存 // StatusData myStatusData = new StatusData(); //返回状态 // using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作 { #region 除 if (del > 0) { Child_Book_Click myDelRecord = myOperating.Child_Book_Click.FirstOrDefault(p => p.BookID == del); if (myDelRecord != null) { myOperating.Child_Book_Click.Remove(myDelRecord); #region 步删除收藏中的内容 DataOptionClass myDataOptionClass = new DataOptionClass(); myDataOptionClass.CollectOption(1, del, true);//删除收藏中的内容 #endregion myOperating.SaveChanges(); } } #endregion // #region 翻页属性 int recordCount = 0; int pageCount = 0; string orderbyfiled = "OrderBy"; // //当前页 int sqlCurrentpage = currentpage; if (sqlCurrentpage < 1) { sqlCurrentpage = 1; } //页大小 int sqlPagesize = 10; #endregion // #region 取出内容 IQueryable <Child_Book_Click> myIQueryable = null; if (ClassId > 0) { myIQueryable = myOperating.Child_Book_Click.Where(p => p.BookClassID == ClassId); } else { myIQueryable = myOperating.Child_Book_Click; } // if (myIQueryable != null) { List <Child_Book_Click> BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, true).ToList(); // ViewBag.DataList = BookTable; #region 页数取值 ViewBag.CurrentPage = sqlCurrentpage; ViewBag.PageCount = pageCount; ViewBag.RecordCount = recordCount; if (sqlCurrentpage > 1) { ViewBag.PPage = sqlCurrentpage - 1; } else { ViewBag.IsFirstPage = "disabled"; ViewBag.PPage = 1; } if (sqlCurrentpage < pageCount) { ViewBag.NPage = sqlCurrentpage + 1; } else { ViewBag.NPage = sqlCurrentpage; ViewBag.IsEndPage = "disabled"; } #endregion } #endregion // ViewBag.ClassId = ClassId;//当前类别 // List <Child_Book_Click_Class> ClassTable = myOperating.Child_Book_Click_Class.Where(p => p.Status == 200).OrderByDescending(p => p.OrderBy).ToList(); ViewBag.DataListClass = ClassTable; } return(View()); }
public JsonResult AlbumList(string classid, string currentpage, string pagesize) { string mobilePhone = "";// // DataOptionClass myDataOptionClass = new DataOptionClass(); // StatusData myStatusData = new StatusData();//返回状态 // #region 检查授权 AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance(); AuthCodeClass myAuthCodeClass = new AuthCodeClass(); bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance); if (checkAuthCodeBool) { mobilePhone = myAuthCodeInstance.mobilePhone; } #endregion using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作 { #region 翻页属性 int recordCount = 0; int pageCount = 0; string orderbyfiled = "OrderBy"; // //当前页 int sqlCurrentpage = 1; if (!String.IsNullOrWhiteSpace(currentpage)) { bool isOk = int.TryParse(currentpage, out sqlCurrentpage); if (!isOk) { sqlCurrentpage = 1; } } //页大小 int sqlPagesize = 10; if (!String.IsNullOrWhiteSpace(pagesize)) { bool isOk = int.TryParse(pagesize, out sqlPagesize); if (!isOk) { sqlPagesize = 10; } } #endregion IQueryable <Child_Audio_Album> myIQueryable = null; if (!String.IsNullOrWhiteSpace(classid)) { int myInt = 0; bool isOk = int.TryParse(classid, out myInt); if (isOk) { myIQueryable = myOperating.Child_Audio_Album.Where(p => p.ClassId == myInt && p.Status == 200); } else { myIQueryable = null; } } else { myIQueryable = myOperating.Child_Audio_Album.Where(p => p.Status == 200); } // if (myIQueryable != null) { DataMethodClass myDataMethodClass = new DataMethodClass(); List <AudioAlbumData> myAudioAlbumDataList = new List <AudioAlbumData>(); var BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, true).Select(s => new { AlbumId = s.AlbumId, AlbumTitle = s.AlbumTitle, Anchor = s.Anchor, AlbumImage = StaticVarClass.myDomain + s.AlbumImage, AlbumDescrib = s.AlbumDescrib, AudioCount = s.AudioCount, PlayTimes = s.PlayTimes, ClassId = s.ClassId }).ToList(); if (BookTable != null) { for (int i = 0; i < BookTable.Count(); i++) { AudioAlbumData myAudioAlbumData = new AudioAlbumData(); int myInt = BookTable[i].AlbumId; int ListCount = 0;//总共数量 Child_Audio_List myChild_Audio_List = new Child_Audio_List(); ListCount = myOperating.Child_Audio_List.Count(p => p.AlbumId == myInt); // myAudioAlbumData.AlbumId = BookTable[i].AlbumId; myAudioAlbumData.AlbumTitle = BookTable[i].AlbumTitle; myAudioAlbumData.Anchor = BookTable[i].Anchor; myAudioAlbumData.AlbumImage = BookTable[i].AlbumImage; myAudioAlbumData.AlbumDescrib = BookTable[i].AlbumDescrib; myAudioAlbumData.AudioCount = ListCount; myAudioAlbumData.PlayTimes = myDataOptionClass.GetReadPlayTimes(2, myInt); myAudioAlbumData.ClassName = myDataMethodClass.GetAudioClassName(BookTable[i].ClassId); myAudioAlbumDataList.Add(myAudioAlbumData); } } myStatusData.dataPageCount = pageCount; myStatusData.dataRecordCount = recordCount; myStatusData.dataTable = myAudioAlbumDataList; } myStatusData.operateStatus = 200; } return(Json(myStatusData)); }
// #region 音频列表 public ActionResult AudioList(string albumid, string currentpage, long del = 0) { #region 翻页定义 ViewBag.CurrentPage = 0; //当前页 ViewBag.PPage = 0; //上一页 ViewBag.NPage = 0; //下一页 ViewBag.PageCount = 0; //总页数 ViewBag.RecordCount = 0; //记录总数 ViewBag.IsFirstPage = ""; //第一条记录,禁用首页和上一页 ViewBag.IsEndPage = ""; //最后条记录,禁用首页和下一页 #endregion // ViewBag.Headline = "音频管理";//栏目主题 // ViewBag.AlbumId = albumid; ViewBag.DataList = null; ViewBag.RecordItem = null; ViewBag.Operate = "add"; //add添加;edit编辑取出数据;editsave编辑保存 // StatusData myStatusData = new StatusData(); //返回状态 // using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作 { #region 除 if (del > 0) { Child_Audio_List myDelRecord = myOperating.Child_Audio_List.FirstOrDefault(p => p.AudioId == del); if (myDelRecord != null) { FunctionClass.delFile(myDelRecord.AudioImage); myOperating.Child_Audio_List.Remove(myDelRecord); #region 步删除收藏中的内容 DataOptionClass myDataOptionClass = new DataOptionClass(); myDataOptionClass.CollectOption(2, del, true);//删除收藏中的内容 #endregion myOperating.SaveChanges(); } } #endregion #region 翻页属性 int recordCount = 0; int pageCount = 0; string orderbyfiled = "OrderBy"; bool isDesc = true;//倒序 // //当前页 int sqlCurrentpage = 1; if (!String.IsNullOrWhiteSpace(currentpage)) { bool isOk = int.TryParse(currentpage, out sqlCurrentpage); if (!isOk) { sqlCurrentpage = 1; } } //页大小 int sqlPagesize = 10; #endregion IQueryable <Child_Audio_List> myIQueryable = null; if (!String.IsNullOrWhiteSpace(albumid)) { int myInt = 0; bool isOk = int.TryParse(albumid, out myInt); if (isOk) { myIQueryable = myOperating.Child_Audio_List.Where(p => p.AlbumId == myInt); } else { myIQueryable = null; } } // if (myIQueryable != null) { List <Child_Audio_List> BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc).ToList(); ViewBag.DataList = BookTable; #region 页数取值 ViewBag.CurrentPage = sqlCurrentpage; ViewBag.PageCount = pageCount; ViewBag.RecordCount = recordCount; if (sqlCurrentpage > 1) { ViewBag.PPage = sqlCurrentpage - 1; } else { ViewBag.IsFirstPage = "disabled"; ViewBag.PPage = 1; } if (sqlCurrentpage < pageCount) { ViewBag.NPage = sqlCurrentpage + 1; } else { ViewBag.NPage = sqlCurrentpage; ViewBag.IsEndPage = "disabled"; } #endregion } } return(View()); }
//============================== #region 教师社区文章列表 public ActionResult TeacherCommunityList(int currentpage = 1, int ClassId = 0, long del = 0) { #region 翻页定义 ViewBag.CurrentPage = 0; //当前页 ViewBag.PPage = 0; //上一页 ViewBag.NPage = 0; //下一页 ViewBag.PageCount = 0; //总页数 ViewBag.RecordCount = 0; //记录总数 ViewBag.IsFirstPage = ""; //第一条记录,禁用首页和上一页 ViewBag.IsEndPage = ""; //最后条记录,禁用首页和下一页 #endregion // ViewBag.Headline = "教师社区管理";//栏目主题 // ViewBag.DataList = null; ViewBag.RecordItem = null; ViewBag.Operate = "add"; //add添加;edit编辑取出数据;editsave编辑保存 // StatusData myStatusData = new StatusData(); //返回状态 // using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作 { #region 除 if (del > 0) { Teacher_Article myDelRecord = myOperating.Teacher_Article.FirstOrDefault(p => p.ArticlId == del); if (myDelRecord != null) { FunctionClass.delFile(myDelRecord.ArticleImages); FunctionClass.delFile(myDelRecord.ArticleVideo); string[] contentImages = FunctionClass.GetHtmlImageUrlList(myDelRecord.ArticleContent); FunctionClass.delFile("", contentImages); myOperating.Teacher_Article.Remove(myDelRecord); #region 步删除收藏中的内容 DataOptionClass myDataOptionClass = new DataOptionClass(); myDataOptionClass.CollectOption(8, del, true);//删除收藏中的内容 #endregion myOperating.SaveChanges(); } } #endregion // #region 翻页属性 int recordCount = 0; int pageCount = 0; string orderbyfiled = "OrderBy"; // //当前页 int sqlCurrentpage = currentpage; if (sqlCurrentpage < 1) { sqlCurrentpage = 1; } //页大小 int sqlPagesize = 10; #endregion // #region 取出内容 IQueryable <Teacher_Article> myIQueryable = null; if (ClassId > 0) { myIQueryable = myOperating.Teacher_Article.Where(p => p.ClassId == ClassId); } else { myIQueryable = myOperating.Teacher_Article; } // if (myIQueryable != null) { IQueryable <Teacher_Article> BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, true); // List <teacherCommunityList> myCommunityList = new List <teacherCommunityList>(); long temId = 0; foreach (Teacher_Article item in BookTable) { temId = item.ArticlId; teacherCommunityList CommunityItem = new teacherCommunityList(); CommunityItem.ArticlId = item.ArticlId; CommunityItem.ArticleTitle = item.ArticleTitle; CommunityItem.OrderBy = item.OrderBy; CommunityItem.CommentCount = myOperating.Teacher_Article_Comment.Count(p => p.AboutId == temId); myCommunityList.Add(CommunityItem); } ViewBag.DataList = myCommunityList; #region 页数取值 ViewBag.CurrentPage = sqlCurrentpage; ViewBag.PageCount = pageCount; ViewBag.RecordCount = recordCount; if (sqlCurrentpage > 1) { ViewBag.PPage = sqlCurrentpage - 1; } else { ViewBag.IsFirstPage = "disabled"; ViewBag.PPage = 1; } if (sqlCurrentpage < pageCount) { ViewBag.NPage = sqlCurrentpage + 1; } else { ViewBag.NPage = sqlCurrentpage; ViewBag.IsEndPage = "disabled"; } #endregion } #endregion // ViewBag.ClassId = ClassId;//当前类别 // List <Teacher_Article_Class> ClassTable = myOperating.Teacher_Article_Class.Where(p => p.Status == 200).OrderByDescending(p => p.OrderBy).ToList(); ViewBag.DataListClass = ClassTable; } return(View()); }
public ActionResult TeacherVideoList(int currentpage = 1, int ClassId = 0, int LessonId = 0, long del = 0) { #region 翻页定义 ViewBag.CurrentPage = 0; //当前页 ViewBag.PPage = 0; //上一页 ViewBag.NPage = 0; //下一页 ViewBag.PageCount = 0; //总页数 ViewBag.RecordCount = 0; //记录总数 ViewBag.IsFirstPage = ""; //第一条记录,禁用首页和上一页 ViewBag.IsEndPage = ""; //最后条记录,禁用首页和下一页 #endregion // ViewBag.Headline = "教师视频管理";//栏目主题 #region 栏目名称 switch (ClassId) { case 1: ViewBag.Headline = "芮卡课程讲解"; break; case 2: ViewBag.Headline = "幼儿公开课"; break; case 3: ViewBag.Headline = "教育技能"; break; case 4: ViewBag.Headline = "芮卡多媒体操作说明"; break; } #endregion // ViewBag.DataList = null; ViewBag.RecordItem = null; ViewBag.Operate = "add"; //add添加;edit编辑取出数据;editsave编辑保存 // StatusData myStatusData = new StatusData(); //返回状态 // using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作 { #region 除 if (del > 0) { Teacher_Video_List myDelRecord = myOperating.Teacher_Video_List.FirstOrDefault(p => p.VideoId == del); if (myDelRecord != null) { FunctionClass.delFile(myDelRecord.VideoImage); FunctionClass.delFile(myDelRecord.VideoUrl); myOperating.Teacher_Video_List.Remove(myDelRecord); #region 步删除收藏中的内容 DataOptionClass myDataOptionClass = new DataOptionClass(); myDataOptionClass.CollectOption(4, del, true); //删除收藏中的内容 myDataOptionClass.CollectOption(5, del, true); //删除收藏中的内容 myDataOptionClass.CollectOption(6, del, true); //删除收藏中的内容 myDataOptionClass.CollectOption(7, del, true); //删除收藏中的内容 #endregion myOperating.SaveChanges(); } } #endregion // #region 翻页属性 int recordCount = 0; int pageCount = 0; string orderbyfiled = "Recommended"; string orderbyfiled2 = "OrderBy"; // //当前页 int sqlCurrentpage = currentpage; if (sqlCurrentpage < 1) { sqlCurrentpage = 1; } //页大小 int sqlPagesize = 10; #endregion // #region 取出内容 IQueryable <Teacher_Video_List> myIQueryable = null; if (ClassId > 0) { if ((ClassId == 1) && (LessonId > 0)) { myIQueryable = myOperating.Teacher_Video_List.Where(p => p.ClassId == ClassId && p.LessonId == LessonId); } else { myIQueryable = myOperating.Teacher_Video_List.Where(p => p.ClassId == ClassId); } } else { myIQueryable = myOperating.Teacher_Video_List; } // if (myIQueryable != null) { List <Teacher_Video_List> BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, true, orderbyfiled2).ToList(); // ViewBag.DataList = BookTable; #region 页数取值 ViewBag.CurrentPage = sqlCurrentpage; ViewBag.PageCount = pageCount; ViewBag.RecordCount = recordCount; if (sqlCurrentpage > 1) { ViewBag.PPage = sqlCurrentpage - 1; } else { ViewBag.IsFirstPage = "disabled"; ViewBag.PPage = 1; } if (sqlCurrentpage < pageCount) { ViewBag.NPage = sqlCurrentpage + 1; } else { ViewBag.NPage = sqlCurrentpage; ViewBag.IsEndPage = "disabled"; } #endregion } #endregion // ViewBag.ClassId = ClassId; //当前类别 ViewBag.LessonId = LessonId; //当前课程门类 // #region 芮卡课程讲解需要取出课程门类 if (ClassId == 1) {//芮卡课程讲解 List <Teacher_Video_Class_Lesson> LessonTable = myOperating.Teacher_Video_Class_Lesson.Where(p => p.Status == 200).OrderByDescending(p => p.OrderBy).ToList(); ViewBag.DataListLesson = LessonTable; } #endregion } return(View()); }