//
#region 文章查看
public ActionResult ItemView(DiscoverArticleModel model, string ReturnUrl, Nullable <long> myid = 0)
{
#region 获取来路路径
if (System.Web.HttpContext.Current.Request.UrlReferrer != null)
{
ViewBag.ReturnUrl = System.Web.HttpContext.Current.Request.UrlReferrer.PathAndQuery;
}
#endregion
ViewBag.Headline = "文章查看"; //栏目主题
//
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
{
if ((myid > 0) && (model.Operate == null))
{
long mySelfId = 0;
long.TryParse(myid.ToString(), out mySelfId);
ViewBag.Headline = "文章查看";
//
model.Operate = "";
#region 取出数据
Discover_Article editRecord = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == mySelfId);
if (editRecord != null)
{
model.ArticlId = editRecord.ArticlId;
model.MobilePhone = editRecord.MobilePhone;
model.ArticleTitle = editRecord.ArticleTitle;
model.ArticleImages = FunctionClass.GetFileUrl(editRecord.ArticleImages);
model.ArticleVideo = FunctionClass.GetFileUrl(editRecord.ArticleVideo);
model.ArticleContent = editRecord.ArticleContent;
model.ReadTimes = editRecord.ReadTimes;
model.OrderBy = editRecord.OrderBy;
model.Status = editRecord.Status;
model.Operate = "look";
}
#endregion
}
}
//
return(View(model));
}
//
#region 阅读播放次数加一
public bool TimesAdd(int classid, long aboutid)
{
bool isOk = false;
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
{
try
{
switch (classid)
{///1点一点；2听一听；3看一看；
///4课程讲解；5幼儿公开课；6教育技能；
///7操作说明；8教师社区；9精彩瞬间;12用户录音
case 1: //点一点
Child_Book_Click myChild_Book_Click = new Child_Book_Click();
myChild_Book_Click = myOperating.Child_Book_Click.FirstOrDefault(p => p.BookID == aboutid);
if (myChild_Book_Click != null)
{
myChild_Book_Click.ReadCount = myChild_Book_Click.ReadCount + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
case 2: //2听一听
Child_Audio_List myChild_Audio_List = new Child_Audio_List();
myChild_Audio_List = myOperating.Child_Audio_List.FirstOrDefault(p => p.AudioId == aboutid);
if (myChild_Audio_List != null)
{
myChild_Audio_List.PlayTimes = myChild_Audio_List.PlayTimes + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
case 3: //3看一看
Child_Video_List myChild_Video_List = new Child_Video_List();
myChild_Video_List = myOperating.Child_Video_List.FirstOrDefault(p => p.VideoId == aboutid);
if (myChild_Video_List != null)
{
myChild_Video_List.PlayTimes = myChild_Video_List.PlayTimes + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
case 4:
case 5:
case 6:
case 7: //4课程讲解；5幼儿公开课；6教育技能；7操作说明
Teacher_Video_List myTeacher_Video_List = new Teacher_Video_List();
myTeacher_Video_List = myOperating.Teacher_Video_List.FirstOrDefault(p => p.VideoId == aboutid);
if (myTeacher_Video_List != null)
{
myTeacher_Video_List.PlayTimes = myTeacher_Video_List.PlayTimes + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
case 8: //8教师社区
Teacher_Article myTeacher_Article = new Teacher_Article();
myTeacher_Article = myOperating.Teacher_Article.FirstOrDefault(p => p.ArticlId == aboutid);
if (myTeacher_Article != null)
{
myTeacher_Article.ReadTimes = myTeacher_Article.ReadTimes + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
case 9: //9精彩瞬间
Discover_Article myDiscover_Article = new Discover_Article();
myDiscover_Article = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == aboutid);
if (myDiscover_Article != null)
{
myDiscover_Article.ReadTimes = myDiscover_Article.ReadTimes + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
case 12: //用户录音
Child_Audio_List_User myChild_Audio_List_User = new Child_Audio_List_User();
myChild_Audio_List_User = myOperating.Child_Audio_List_User.FirstOrDefault(p => p.AudioUserId == aboutid);
if (myChild_Audio_List_User != null)
{
myChild_Audio_List_User.PlayTimes = myChild_Audio_List_User.PlayTimes + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
}
}
catch
{ }
}
return(isOk);
}
public bool CollectOption(int classid, long aboutid, bool editOrdel)
{ ///editOrdel=true编辑；false删除
///1点一点；2听一听；3看一看；
///4课程讲解；5幼儿公开课；6教育技能；
///7操作说明；8教师社区；9精彩瞬间;
//
bool OptionComplet = false;
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
{
bool isExict = false; //是否存在
string myCoverImage = ""; //图片
string myTitle = ""; //标题
string mySummart = ""; //摘要
if (!editOrdel)
{
#region 根据收藏类别取出图片和标题
switch (classid)
{///1点一点；2听一听；3看一看；
///4课程讲解；5幼儿公开课；6教育技能；
///7操作说明；8教师社区；9精彩瞬间;
case 1: //点一点
Child_Book_Click myChild_Book_Click = new Child_Book_Click();
myChild_Book_Click = myOperating.Child_Book_Click.FirstOrDefault(p => p.BookID == aboutid);
if (myChild_Book_Click != null)
{
myTitle = myChild_Book_Click.BookName;
if (!String.IsNullOrWhiteSpace(myChild_Book_Click.BookImage))
{
myCoverImage = StaticVarClass.BookClickResourceUrl + myChild_Book_Click.BookImage;
}
isExict = true;
}
break;
case 2: //2听一听
Child_Audio_List myChild_Audio_List = new Child_Audio_List();
myChild_Audio_List = myOperating.Child_Audio_List.FirstOrDefault(p => p.AudioId == aboutid);
if (myChild_Audio_List != null)
{
myTitle = myChild_Audio_List.AudioTitle;
if (!String.IsNullOrWhiteSpace(myChild_Audio_List.AudioImage))
{
myCoverImage = StaticVarClass.myDomain + myChild_Audio_List.AudioImage;
}
isExict = true;
}
break;
case 3: //3看一看
Child_Video_List myChild_Video_List = new Child_Video_List();
myChild_Video_List = myOperating.Child_Video_List.FirstOrDefault(p => p.VideoId == aboutid);
if (myChild_Video_List != null)
{
myTitle = myChild_Video_List.VideoTitle;
if (!String.IsNullOrWhiteSpace(myChild_Video_List.VideoImage))
{
myCoverImage = StaticVarClass.myDomain + myChild_Video_List.VideoImage;
}
isExict = true;
}
break;
case 4:
case 5:
case 6:
case 7: //4课程讲解；5幼儿公开课；6教育技能；7操作说明
Teacher_Video_List myTeacher_Video_List = new Teacher_Video_List();
myTeacher_Video_List = myOperating.Teacher_Video_List.FirstOrDefault(p => p.VideoId == aboutid);
if (myTeacher_Video_List != null)
{
myTitle = myTeacher_Video_List.VideoTitle;
if (!String.IsNullOrWhiteSpace(myTeacher_Video_List.VideoImage))
{
myCoverImage = StaticVarClass.myDomain + myTeacher_Video_List.VideoImage;
}
isExict = true;
}
break;
case 8: //8教师社区
Teacher_Article myTeacher_Article = new Teacher_Article();
myTeacher_Article = myOperating.Teacher_Article.FirstOrDefault(p => p.ArticlId == aboutid);
if (myTeacher_Article != null)
{
myTitle = myTeacher_Article.ArticleTitle;
if (!String.IsNullOrWhiteSpace(myTeacher_Article.ArticleImages))
{
myCoverImage = StaticVarClass.myDomain + myTeacher_Article.ArticleImages;
}
if (myTeacher_Article.ArticleSummary.Length > 50)
{
mySummart = myTeacher_Article.ArticleSummary.Substring(0, 50);
}
else
{
mySummart = myTeacher_Article.ArticleSummary;
}
isExict = true;
}
break;
case 9: //9精彩瞬间
Discover_Article myDiscover_Article = new Discover_Article();
myDiscover_Article = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == aboutid);
if (myDiscover_Article != null)
{
myTitle = myDiscover_Article.ArticleTitle;
if (!String.IsNullOrWhiteSpace(myDiscover_Article.ArticleImages))
{ //取出第一幅图
string[] imageOne = myDiscover_Article.ArticleImages.Split(';');
if (imageOne.Count() > 0)
{
myCoverImage = StaticVarClass.myDomain + imageOne[0];
}
}
if (myDiscover_Article.ArticleContent.Length > 50)
{
mySummart = myDiscover_Article.ArticleContent.Substring(0, 50);
}
else
{
mySummart = myDiscover_Article.ArticleContent;
}
isExict = true;
}
break;
}
#endregion
}
else
{//要执行删除操作，直接允许执行
isExict = true;
}
//
if (isExict)
{
User_Collect myUser_Collect = myOperating.User_Collect.FirstOrDefault(p => p.ClassId == classid && p.AboutId == aboutid);
if (myUser_Collect != null)
{
try
{
if (editOrdel)
{
myUser_Collect.AboutTitle = myTitle;
myUser_Collect.AboutImage = myCoverImage;
myUser_Collect.AboutSummary = mySummart;
}
else
{
myOperating.User_Collect.Remove(myUser_Collect);
}
myOperating.SaveChanges();
OptionComplet = true;
}
catch
{
OptionComplet = false;
}
}
}
}
return(OptionComplet);
}
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 JsonResult AddCollect(string classid, string aboutid)
{ //
#region 检查授权
string myMobilePhone = ""; //手机号
AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
AuthCodeClass myAuthCodeClass = new AuthCodeClass();
bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
#endregion
//
StatusData myStatusData = new StatusData();//返回状态
//
if (checkAuthCodeBool)
{
myMobilePhone = myAuthCodeInstance.mobilePhone;
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
{
int myClassid = 0; //类别
long myAboutid = 0; //主键
#region 判断输入参数
bool classIsNumber = false; //判断输入参数类型
bool AboutIsNumber = false; //判断输入参数类型
if (!String.IsNullOrEmpty(aboutid))
{
classIsNumber = int.TryParse(classid, out myClassid);
}
//
if (!String.IsNullOrEmpty(aboutid))
{
AboutIsNumber = long.TryParse(aboutid, out myAboutid);
}
//
if ((myClassid < 1) || (myClassid > 9) || (myAboutid < 1))
{
myStatusData.operateMsg = "输入参数错误";
myStatusData.operateStatus = 400;
return(Json(myStatusData));
}
#endregion
//
#region 检查是否已经收藏
int checkUser_Collect = myOperating.User_Collect.Count(p => p.ClassId == myClassid && p.AboutId == myAboutid && p.MobilePhone == myMobilePhone);
if (checkUser_Collect > 0)
{
myStatusData.operateMsg = "已收藏，不能重复收藏";
myStatusData.operateStatus = 400;
return(Json(myStatusData));
}
#endregion
//
bool isTeacherVideo = false; //类别为45679的收藏为true
bool isExict = false; //是否存在
string myCoverImage = ""; //图片
string myTitle = ""; //标题
string mySummart = ""; //摘要
#region 根据收藏类别取出图片和标题
switch (myClassid)
{///1点一点；2听一听；3看一看；
///4课程讲解；5幼儿公开课；6教育技能；
///7操作说明；8教师社区；9精彩瞬间;
case 1: //点一点
#region 点一点
Child_Book_Click myChild_Book_Click = new Child_Book_Click();
myChild_Book_Click = myOperating.Child_Book_Click.FirstOrDefault(p => p.BookID == myAboutid);
if (myChild_Book_Click != null)
{
myTitle = myChild_Book_Click.BookName;
if (!String.IsNullOrWhiteSpace(myChild_Book_Click.BookOnlineUrl))
{
myCoverImage = StaticVarClass.BookClickResourceUrl + myChild_Book_Click.BookOnlineUrl + "main.png";
}
isExict = true;
}
#endregion
break;
case 2: //2听一听
#region 听一听
Child_Audio_List myChild_Audio_List = new Child_Audio_List();
myChild_Audio_List = myOperating.Child_Audio_List.FirstOrDefault(p => p.AudioId == myAboutid);
if (myChild_Audio_List != null)
{
myTitle = myChild_Audio_List.AudioTitle;
int AlibumId = myChild_Audio_List.AlbumId;
string AudioBgImg = "";
try
{
AudioBgImg = myOperating.Child_Audio_Album.FirstOrDefault(p => p.AlbumId == AlibumId).AlbumImage;
if (!String.IsNullOrWhiteSpace(AudioBgImg))
{
myCoverImage = StaticVarClass.myDomain + AudioBgImg;
}
}
catch { }
isExict = true;
}
#endregion
break;
case 3: //3看一看
#region 一看
Child_Video_List myChild_Video_List = new Child_Video_List();
myChild_Video_List = myOperating.Child_Video_List.FirstOrDefault(p => p.VideoId == myAboutid);
if (myChild_Video_List != null)
{
myTitle = myChild_Video_List.VideoTitle;
myCoverImage = StaticVarClass.myDomain + myChild_Video_List.VideoImage;
isExict = true;
}
#endregion
break;
case 4:
case 5:
case 6:
case 7: //4课程讲解；5幼儿公开课；6教育技能；7操作说明
#region 教师社区
Teacher_Video_List myTeacher_Video_List = new Teacher_Video_List();
myTeacher_Video_List = myOperating.Teacher_Video_List.FirstOrDefault(p => p.VideoId == myAboutid);
if (myTeacher_Video_List != null)
{
myTitle = myTeacher_Video_List.VideoTitle;
myCoverImage = StaticVarClass.myDomain + myTeacher_Video_List.VideoImage;
isExict = true;
isTeacherVideo = true;
}
#endregion
break;
case 8: //8教师社区
#region 教师社区
Teacher_Article myTeacher_Article = new Teacher_Article();
myTeacher_Article = myOperating.Teacher_Article.FirstOrDefault(p => p.ArticlId == myAboutid);
if (myTeacher_Article != null)
{
myTitle = myTeacher_Article.ArticleTitle;
if (!String.IsNullOrWhiteSpace(myTeacher_Article.ArticleImages))
{
myCoverImage = StaticVarClass.myDomain + myTeacher_Article.ArticleImages;
}
if ((myTeacher_Article.ArticleSummary != null) && (myTeacher_Article.ArticleSummary.Length > 50))
{
mySummart = myTeacher_Article.ArticleSummary.Substring(0, 50);
}
else
{
mySummart = myTeacher_Article.ArticleSummary;
}
isExict = true;
}
#endregion
break;
case 9: //9精彩瞬间
#region 精彩瞬间
Discover_Article myDiscover_Article = new Discover_Article();
myDiscover_Article = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == myAboutid);
if (myDiscover_Article != null)
{
myTitle = myDiscover_Article.ArticleTitle;
if (!String.IsNullOrWhiteSpace(myDiscover_Article.ArticleImages))
{ //取出第一幅图
string[] imageOne = myDiscover_Article.ArticleImages.Split(';');
if (imageOne.Count() > 0)
{
myCoverImage = StaticVarClass.myDomain + imageOne[0];
}
}
if ((myDiscover_Article.ArticleContent != null) && (myDiscover_Article.ArticleContent.Length > 50))
{
mySummart = myDiscover_Article.ArticleContent.Substring(0, 50);
}
else
{
mySummart = myDiscover_Article.ArticleContent;
}
isExict = true;
}
#endregion
break;
}
#endregion
//
#region 添加到数据库
if (isExict)
{
try
{
User_Collect myUser_Collect = new User_Collect();
//
myUser_Collect.ClassId = myClassid;
myUser_Collect.AboutId = myAboutid;
myUser_Collect.AboutTitle = myTitle;
myUser_Collect.AboutImage = myCoverImage;
myUser_Collect.AboutSummary = mySummart;
myUser_Collect.MobilePhone = myMobilePhone;
myUser_Collect.ClassId = myClassid;//收藏类别
myUser_Collect.CollectDate = DateTime.Now;
myUser_Collect.IsTeacherVideo = isTeacherVideo;
myUser_Collect.OrderBy = 10000;
//
myOperating.User_Collect.Add(myUser_Collect);
myOperating.SaveChanges();
myStatusData.operateStatus = 200;
}
catch
{
myStatusData.operateStatus = -1;
}
}
else
{
myStatusData.operateMsg = "不存在";
myStatusData.operateStatus = 400;
}
#endregion
}
}
else
{
myStatusData.operateStatus = 5;//登陆失效
}
return(Json(myStatusData));
}
public ActionResult Share(int classtype = 0, long aboutid = 0)
{
ShareModel myShareModel = new ShareModel();
myShareModel.ClassType = classtype;//属于哪一个表的内容
myShareModel.AboutTitle = "芮卡家园";
//
#region 根据类别取出分享的内容
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
{
switch (classtype)
{///1点一点；2听一听；3看一看；
///4课程讲解；5幼儿公开课；6教育技能；
///7操作说明；8教师社区；9精彩瞬间;
case 1: //点一点
#region 点一点
Child_Book_Click myChild_Book_Click = new Child_Book_Click();
myChild_Book_Click = myOperating.Child_Book_Click.FirstOrDefault(p => p.BookID == aboutid);
if (myChild_Book_Click != null)
{
myShareModel.AboutTitle = myChild_Book_Click.BookName;
if (!String.IsNullOrWhiteSpace(myChild_Book_Click.BookImage))
{
myShareModel.AboutImages = StaticVarClass.BookClickResourceUrl + myChild_Book_Click.BookImage;
}
}
#endregion
return(View("ShareClick", myShareModel));
//break;
case 2: //2听一听
#region 听一听
Child_Audio_List myChild_Audio_List = new Child_Audio_List();
myChild_Audio_List = myOperating.Child_Audio_List.FirstOrDefault(p => p.AudioId == aboutid);
if (myChild_Audio_List != null)
{
myShareModel.AboutTitle = myChild_Audio_List.AudioTitle;
#region 取专辑图片
int AlibumId = myChild_Audio_List.AlbumId;
try
{
Child_Audio_Album myChild_Audio_Album = new Child_Audio_Album();
myChild_Audio_Album = myOperating.Child_Audio_Album.FirstOrDefault(p => p.AlbumId == AlibumId);
if (myChild_Audio_Album != null)
{
if (!String.IsNullOrWhiteSpace(myChild_Audio_Album.Anchor))
{
myShareModel.AboutAuthor = myChild_Audio_Album.Anchor;
}
if (!String.IsNullOrWhiteSpace(myChild_Audio_Album.AlbumImage))
{
myShareModel.AboutImages = StaticVarClass.myDomain + myChild_Audio_Album.AlbumImage;
}
}
}
catch { }
#endregion
if (!String.IsNullOrWhiteSpace(myChild_Audio_List.AudioUrl))
{
myShareModel.AboutAudio = StaticVarClass.myDomain + myChild_Audio_List.AudioUrl;
}
myShareModel.AboutContent = myChild_Audio_List.AudioWords;
DateTime myDateTime = DateTime.Now;
DateTime.TryParse(myChild_Audio_List.AddDate.ToString(), out myDateTime);
myShareModel.AddDate = myDateTime;
}
#endregion
break;
case 3: //3看一看
#region 一看
Child_Video_List myChild_Video_List = new Child_Video_List();
myChild_Video_List = myOperating.Child_Video_List.FirstOrDefault(p => p.VideoId == aboutid);
if (myChild_Video_List != null)
{
myShareModel.AboutTitle = myChild_Video_List.VideoTitle;
if (!String.IsNullOrWhiteSpace(myChild_Video_List.VideoImage))
{
myShareModel.AboutImages = StaticVarClass.myDomain + myChild_Video_List.VideoImage;
}
if (!String.IsNullOrWhiteSpace(myChild_Video_List.VideoUrl))
{
myShareModel.AboutVideo = StaticVarClass.myDomain + myChild_Video_List.VideoUrl;
}
myShareModel.AboutContent = myChild_Video_List.VideoDes;
DateTime myDateTime = DateTime.Now;
DateTime.TryParse(myChild_Video_List.AddDate.ToString(), out myDateTime);
myShareModel.AddDate = myDateTime;
}
#endregion
break;
case 4:
case 5:
case 6:
case 7: //4课程讲解；5幼儿公开课；6教育技能；7操作说明
#region 教师视频
Teacher_Video_List myTeacher_Video_List = new Teacher_Video_List();
myTeacher_Video_List = myOperating.Teacher_Video_List.FirstOrDefault(p => p.VideoId == aboutid);
if (myTeacher_Video_List != null)
{
myShareModel.AboutTitle = myTeacher_Video_List.VideoTitle;
if (!String.IsNullOrWhiteSpace(myTeacher_Video_List.VideoImage))
{
myShareModel.AboutImages = StaticVarClass.myDomain + myTeacher_Video_List.VideoImage;
}
if (!String.IsNullOrWhiteSpace(myTeacher_Video_List.VideoUrl))
{
myShareModel.AboutVideo = StaticVarClass.myDomain + myTeacher_Video_List.VideoUrl;
}
myShareModel.AboutContent = myTeacher_Video_List.VideoDes;
DateTime myDateTime = DateTime.Now;
DateTime.TryParse(myTeacher_Video_List.AddDate.ToString(), out myDateTime);
myShareModel.AddDate = myDateTime;
}
#endregion
break;
case 8: //8教师社区
#region 教师社区
Teacher_Article myTeacher_Article = new Teacher_Article();
myTeacher_Article = myOperating.Teacher_Article.FirstOrDefault(p => p.ArticlId == aboutid);
if (myTeacher_Article != null)
{
myShareModel.AboutTitle = myTeacher_Article.ArticleTitle;
if (!String.IsNullOrWhiteSpace(myTeacher_Article.ArticleImages))
{
myShareModel.AboutImages = StaticVarClass.myDomain + myTeacher_Article.ArticleImages;
}
if (!String.IsNullOrWhiteSpace(myTeacher_Article.ArticleVideo))
{
myShareModel.AboutVideo = StaticVarClass.myDomain + myTeacher_Article.ArticleVideo;
}
myShareModel.AboutContent = myTeacher_Article.ArticleContent;
DateTime myDateTime = DateTime.Now;
DateTime.TryParse(myTeacher_Article.AddDate.ToString(), out myDateTime);
myShareModel.AddDate = myDateTime;
}
#endregion
break;
case 9: //9精彩瞬间
#region 精彩瞬间
Discover_Article myDiscover_Article = new Discover_Article();
myDiscover_Article = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == aboutid);
if (myDiscover_Article != null)
{
myShareModel.AboutTitle = myDiscover_Article.ArticleTitle;
myShareModel.AboutImages = myDiscover_Article.ArticleImages;
myShareModel.AboutVideo = myDiscover_Article.ArticleVideo;
myShareModel.AboutContent = myDiscover_Article.ArticleContent;
DateTime myDateTime = DateTime.Now;
DateTime.TryParse(myDiscover_Article.AddDate.ToString(), out myDateTime);
myShareModel.AddDate = myDateTime;
}
#endregion
break;
}
}
#endregion
return(View(myShareModel));
}
public JsonResult AddArticleContent(string articletitle, string content, string images, string videos)
{
//
string mobilePhone = ""; //
//
StatusData myStatusData = new StatusData(); //返回状态
#region 判断条件
if (String.IsNullOrWhiteSpace(articletitle.Trim()))
{
myStatusData.operateStatus = 400;
myStatusData.operateMsg = "标题不能为空";
return(Json(myStatusData));
}
else if (articletitle.Trim().Length > 50)
{
myStatusData.operateStatus = 400;
myStatusData.operateMsg = "标题不能多于50个字符";
return(Json(myStatusData));
}
if (String.IsNullOrWhiteSpace(content.Trim()))
{
myStatusData.operateStatus = 400;
myStatusData.operateMsg = "内容不能为空";
return(Json(myStatusData));
}
else if (content.Trim().Length < 2)
{
myStatusData.operateStatus = 400;
myStatusData.operateMsg = "内容太少";
return(Json(myStatusData));
}
#endregion
//
#region 检查授权
AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
AuthCodeClass myAuthCodeClass = new AuthCodeClass();
bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
#endregion
if (checkAuthCodeBool)
{
mobilePhone = myAuthCodeInstance.mobilePhone;
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
{
try
{
Discover_Article myDiscover_Article = new Discover_Article();
myDiscover_Article.MobilePhone = mobilePhone;
myDiscover_Article.ArticleTitle = articletitle;
myDiscover_Article.ArticleContent = content;
myDiscover_Article.ArticleImages = images;
myDiscover_Article.ArticleVideo = videos;
myDiscover_Article.AddDate = DateTime.Now;
myDiscover_Article.OrderBy = 10000;
myDiscover_Article.PraiseCount = 0;
myDiscover_Article.ReadTimes = 0;
myDiscover_Article.Status = 200;
myOperating.Discover_Article.Add(myDiscover_Article);
myOperating.SaveChanges();
myStatusData.operateStatus = 200;
}
catch
{
myStatusData.operateStatus = -1;
}
}
}
else
{
myStatusData.operateStatus = 5;
}
return(Json(myStatusData));
}
public JsonResult ArticleContent(string articleid)
{
string mobilePhone = ""; //
//
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())//数据库操作
{
DiscoverDataContent myDiscoverDataContent = new DiscoverDataContent();
long myLong = 0;//文章主键
bool isLong = long.TryParse(articleid, out myLong);
if (isLong)
{
Discover_Article myTable = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == myLong && p.Status == 200);
if (myTable != null)
{
#region 昵称和头像
string dataMobilePhone = myTable.MobilePhone;
DataMethodClass myDataMethodClass = new DataMethodClass();
string myHeadImage = StaticVarClass.DefaultHeadImage; //头像
string myNickName = "匿名"; //昵称
myDataMethodClass.GetNickNameAndPic(dataMobilePhone, out myNickName, out myHeadImage);
#endregion
int myCommentTimes = 0;//评论次数
myDiscoverDataContent.ArticleId = myTable.ArticlId;
myDiscoverDataContent.ArticleTitle = myTable.ArticleTitle;
myDiscoverDataContent.ArticleImages = FunctionClass.GetFileUrl(myTable.ArticleImages);
myDiscoverDataContent.ArticleVideo = FunctionClass.GetFileUrl(myTable.ArticleVideo);
myDiscoverDataContent.ArticleContent = myTable.ArticleContent;
myDiscoverDataContent.AddDate = myTable.AddDate;
myDiscoverDataContent.ReadTimes = myTable.ReadTimes;
myCommentTimes = myOperating.Discover_Article_Comment.Count(p => p.AboutId == myLong);
//
myDiscoverDataContent.CommentTimes = myCommentTimes;
myDiscoverDataContent.HeadImage = myHeadImage;
myDiscoverDataContent.NickName = myNickName;
//
#region 阅读次数加一
if (myTable.ReadTimes != null)
{
myTable.ReadTimes = myTable.ReadTimes + 1;
}
else
{
myTable.ReadTimes = 1;
}
myOperating.SaveChanges();
#endregion
}
myStatusData.dataTable = myDiscoverDataContent;
}
myStatusData.operateStatus = 200;
}
return(Json(myStatusData));
}
public JsonResult DeleteItem(string myid, string del)
{
#region 检查授权
string myMobilePhone = "";//手机号
AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
AuthCodeClass myAuthCodeClass = new AuthCodeClass();
bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
#endregion
//
StatusData myStatusData = new StatusData();//返回状态
//
if (checkAuthCodeBool)
{
myMobilePhone = myAuthCodeInstance.mobilePhone;
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
{
int operatType = 0; //1删除全部，2删除指定
long idLong = 0;
#region 判断参数
if (!String.IsNullOrWhiteSpace(del))
{
switch (del.ToLower())
{
case "all":
operatType = 1;
break;
case "single":
if (!String.IsNullOrWhiteSpace(myid))
{
bool isLong = long.TryParse(myid, out idLong);
if (isLong)
{
operatType = 2;
}
}
break;
}
}
#endregion
//
if (operatType == 1)
{
IQueryable <Discover_Article> myList = myOperating.Discover_Article.Where(p => p.MobilePhone == myMobilePhone);
if (myList != null)
{
foreach (Discover_Article recordItem in myList)
{
FunctionClass.DeleteFile(recordItem.ArticleImages);
FunctionClass.DeleteFile(recordItem.ArticleVideo);
myOperating.Discover_Article.Remove(recordItem);
}
myOperating.SaveChanges();
}
myStatusData.operateStatus = 200;
}
else if (operatType == 2)
{
Discover_Article myDataRecord = new Discover_Article();
myDataRecord = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == idLong && p.MobilePhone == myMobilePhone);
if (myDataRecord != null)
{
FunctionClass.DeleteFile(myDataRecord.ArticleImages);
FunctionClass.DeleteFile(myDataRecord.ArticleVideo);
myOperating.Discover_Article.Remove(myDataRecord);
myOperating.SaveChanges();
myStatusData.operateStatus = 200;
}
}
else
{
myStatusData.operateStatus = 0;
}
}
}
else
{
myStatusData.operateStatus = 5;
}
return(Json(myStatusData));
}
