//发表帖子
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));
}
