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