//发表帖子 public ActionResult PostDetail(int id) { var sdew = PostManage.selectpost(id); var postef1 = PostManage.selectallpost().OrderByDescending(p => p.Post_Click).Skip(6).Take(5); var buser = sdew.User_id; var userid = Convert.ToInt32(Session["User_id"]); var commdpost = PostManage.findallcomment(id); int attef; ForumPost indew = new ForumPost(); if (userid > 0) { var atter = AttentionManage.selecatten(userid, buser); if (atter != null) { attef = 1; ViewBag.attenrenid = atter.Attention_id; } else { attef = 0; } var userinfo1 = UsersManage.finduser(userid); indew.Userinfo2 = userinfo1; } else { attef = 0; } ViewBag.atterceshi = attef; indew.Post7 = postef1; indew.Post5 = sdew; indew.Commentpost = commdpost; return(View(indew)); }
public ActionResult EssayDetail(int?id) { var esst = ForumManage.selectforum(id); var essaycomm = ForumManage.findallcomment(id); var userid = Convert.ToInt32(Session["user_id"]); int collectionsdea; if (userid > 0) { var sdedq = AttentionManage.selectcollec(userid, id); if (sdedq != null) { collectionsdea = 1; } else { collectionsdea = 0; } } else { collectionsdea = 0; } if (esst == null) { return(HttpNotFound()); } ViewBag.collection = collectionsdea; ForumEssay indepp = new ForumEssay(); indepp.Forum2 = esst; indepp.commForum1 = essaycomm; return(View(indepp)); }
/// <summary> /// 删除--关注信息 /// </summary> /// <param name="attentionmanage"></param> /// <returns></returns> public int DeleteAttention(AttentionManage attentionmanage) { SqlParameter[] prams = { data.MakeInParam("@attentionid", SqlDbType.Int, 4, attentionmanage._AttentionID), }; return(data.RunProc("delete from aspnet_Attention where AttentionID=@attentionid", prams)); }
/// <summary> /// 根据--关注编号--得到关注信息 /// </summary> /// <param name="attentionmanage"></param> /// <param name="tbName"></param> /// <returns></returns> public DataSet FindAttentionByID(AttentionManage attentionmanage, string tbName) { SqlParameter[] prams = { data.MakeInParam("@attentionid", SqlDbType.Int, 4, attentionmanage._AttentionID), }; return(data.RunProcReturn("select * from aspnet_Attention where AttentionID = @attentionid", prams, tbName)); }
/// <summary> /// 添加--关注信息 /// </summary> /// <param name="attentionmanage"></param> /// <returns></returns> public int AddAttention(AttentionManage attentionmanage) { SqlParameter[] prams = { data.MakeInParam("@userid", SqlDbType.UniqueIdentifier, 16, attentionmanage._UserId), data.MakeInParam("@createteamid", SqlDbType.Int, 4, attentionmanage._CreateTeamID), data.MakeInParam("@createtopicid", SqlDbType.Int, 4, attentionmanage._CreateTopicID), }; return(data.RunProc("INSERT INTO aspnet_Attention (UserId,CreateTeamID,CreateTopicID) VALUES (@userid,@createteamid,@createtopicid)", prams)); }
/// <summary> /// 修改--关注信息 /// </summary> /// <param name="attentionmanage"></param> /// <returns></returns> public int UpdateAttention(AttentionManage attentionmanage) { SqlParameter[] prams = { data.MakeInParam("@attentionid", SqlDbType.Int, 4, attentionmanage._AttentionID), data.MakeInParam("@userid", SqlDbType.UniqueIdentifier, 16, attentionmanage._UserId), data.MakeInParam("@createteamid", SqlDbType.Int, 4, attentionmanage._CreateTeamID), data.MakeInParam("@createtopicid", SqlDbType.Int, 4, attentionmanage._CreateTopicID), }; return(data.RunProc("update aspnet_Attention set UserId =@userid, CreateTeamID = @createteamid,CreateTopicID = @createtopicid where AttentionID=@attentionid", prams)); }
//军吧取消关注 public string DeleteGuan(int id) { if (id > 0) { AttentionManage.deleteaddpost(id); return("success"); } else { return("fail"); } }
public string DeleteAttention(int buserid) { if (buserid > 0) { AttentionManage.deleteadd(buserid); return("success"); } else { return("fail"); } }
public string AddAttention(Attention attention, int buserid) { var userid = Convert.ToInt32(Session["User_id"]); var sdesdw = AttentionManage.selecatten(userid, buserid); if (sdesdw == null) { attention.User_id = userid; attention.BUser_id = buserid; AttentionManage.Addatten(attention); return("success"); } else { return("fail"); } }
public string AddCollection(Collection collection, int forumid) { var userid = Convert.ToInt32(Session["User_id"]); var sdeqdw = AttentionManage.selectcollec(userid, forumid); if (sdeqdw != null) { return("fail"); } else { collection.User_id = userid; collection.Forum_id = forumid; AttentionManage.Addcollection(collection); return("success"); } }
public string Addattentionpost(AttentionPost attenpos, int id) { var userid = Convert.ToInt32(Session["User_id"]); if (id > 0) { attenpos.User_id = userid; attenpos.ForumSection_id = id; AttentionManage.Addattenpost(attenpos); return("success"); } else { return("fail"); } }
// GET: Communication public ActionResult Index(int?ruserid) { var userid = Convert.ToInt32(Session["User_id"]); if (userid > 0) { var messsage = CommunicationManage.SelectCommenicatio(userid).Take(12); var atten = AttentionManage.selectallatten(userid); var atten1 = AttentionManage.selectbatten(userid); var timesd = Int64.Parse(DateTime.Now.ToString("yyyyMMdd")) - 1; CommuMessage inde = new CommuMessage(); inde.Attention1 = atten; inde.Attention2 = atten1; inde.Communication1 = messsage; return(View(inde)); } else { return(View()); } }
public ActionResult ClassifyPost() { var pose = PostManage.selectallpost(); var usrid = Convert.ToInt32(Session["User_id"]); ForumPost idesw = new ForumPost(); if (usrid > 0) { var userinfo = UsersManage.finduser(usrid); var atte = AttentionManage.selectattenpost(usrid); if (atte != null) { idesw.AttentionPost1 = atte; } idesw.Userinfo = userinfo; } idesw.Post1 = pose; return(View(idesw)); }
public string AddSign(Signature signt, int id) { var userid = Convert.ToInt32(Session["User_id"]); if (id > 0) { signt.ForumSection_id = id; var sssude = UsersManage.finduser(userid); if (sssude != null) { sssude.Integral = sssude.Integral + 10; UsersManage.updateuser(sssude); } signt.User_id = userid; AttentionManage.AddSign(signt); return("success"); } else { return("fail"); } }
public ActionResult JunBa(int id, string search_internal_input) { var sdedw = PostManage.findforumsec(id); var userid = Convert.ToInt32(Session["user_id"]); var forupost = PostManage.selectzhepost(id); var userinfo = UsersManage.finduser(userid); var postef = PostManage.selectallpost().OrderByDescending(p => p.Post_Click).Take(5); if (!String.IsNullOrEmpty(search_internal_input)) { forupost = forupost.Where(s => s.PostName.Contains(search_internal_input) || s.PostContent.Contains(search_internal_input)); } int attentionposet; int signtrue; int attenid; if (userid > 0) { var sdedq = AttentionManage.selectattenpostforu(userid, id); var sdedfdf = AttentionManage.findsign(userid, id); if (sdedq != null) { attenid = sdedq.AttentionPost_id; ViewBag.attentionid = attenid; attentionposet = 1; } else { attentionposet = 0; } if (sdedfdf != null) { signtrue = 1; ViewBag.signtime = sdedfdf.SignatureTime; } else { signtrue = 0; } } else { attentionposet = 0; signtrue = 0; } ViewBag.atten = attentionposet; ViewBag.signid = signtrue; ViewBag.allcontgun = AttentionManage.findattenjisuan(id); ViewBag.postcount = AttentionManage.findallpost(id); ForumPost idnes = new ForumPost(); idnes.ForumSEC1 = sdedw; idnes.Post1 = forupost; idnes.Post2 = postef; if (userinfo != null) { idnes.Userinfo1 = userinfo; } return(View(idnes)); }