public IHttpActionResult PutUser_Collect(long id, User_Collect user_Collect)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != user_Collect.ID)
{
return(BadRequest());
}
db.Entry(user_Collect).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!User_CollectExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(long id)
{
User_Collect user_Collect = db.User_Collect.Find(id);
db.User_Collect.Remove(user_Collect);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult GetUser_Collect(long id)
{
User_Collect user_Collect = db.User_Collect.Find(id);
if (user_Collect == null)
{
return(NotFound());
}
return(Ok(user_Collect));
}
public ActionResult Edit([Bind(Include = "ID,HouseID,UserID,CollectDate,OrderID,Status")] User_Collect user_Collect)
{
if (ModelState.IsValid)
{
db.Entry(user_Collect).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.HouseID = new SelectList(db.Project_House, "ID", "UnitName", user_Collect.HouseID);
ViewBag.UserID = new SelectList(db.System_User, "ID", "UserName", user_Collect.UserID);
return(View(user_Collect));
}
public IHttpActionResult PostUser_Collect(User_Collect user_Collect)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.User_Collect.Add(user_Collect);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = user_Collect.ID }, user_Collect));
}
// GET: Collect/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
User_Collect user_Collect = db.User_Collect.Find(id);
if (user_Collect == null)
{
return(HttpNotFound());
}
return(View(user_Collect));
}
public IHttpActionResult DeleteUser_Collect(long id)
{
User_Collect user_Collect = db.User_Collect.Find(id);
if (user_Collect == null)
{
return(NotFound());
}
db.User_Collect.Remove(user_Collect);
db.SaveChanges();
return(Ok(user_Collect));
}
// GET: Collect/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
User_Collect user_Collect = db.User_Collect.Find(id);
if (user_Collect == null)
{
return(HttpNotFound());
}
ViewBag.HouseID = new SelectList(db.Project_House, "ID", "UnitName", user_Collect.HouseID);
ViewBag.UserID = new SelectList(db.System_User, "ID", "UserName", user_Collect.UserID);
return(View(user_Collect));
}
public JsonResult DelCollectItem(string collectid)
{
#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;
try
{
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
{
long myLong = 0; //
bool isLong = long.TryParse(collectid, out myLong);
User_Collect myUser_Collect = new User_Collect();
myUser_Collect = myOperating.User_Collect.FirstOrDefault(p => p.MobilePhone == myMobilePhone && p.CollectId == myLong);;
//
if (myUser_Collect != null)
{
myOperating.User_Collect.Remove(myUser_Collect);
//
myOperating.SaveChanges();
//
myStatusData.operateStatus = 200;
}
}
}
catch
{
myStatusData.operateStatus = -1;
}
}
else
{
myStatusData.operateStatus = 5;
}
return(Json(myStatusData));
}
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 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));
}