public ActionResult LeaveIn(int pageIndex = 1) { long userid = GetLoginID(); int ToUserType = 2; LeaveOutListModel model = new LeaveOutListModel(); //查询数据 LeaveOutPageResult leaveoutModel = new LeaveOutPageResult(); leaveoutModel = LeavewordsService.GetPageList(userid, ToUserType, pageIndex, PageSize); model.leaveoutList = leaveoutModel.LeaveOuts; //分页 Pagination pager = new Pagination(); pager.PageIndex = pageIndex; pager.PageSize = PageSize; pager.TotalCount = leaveoutModel.TotalCount; if (leaveoutModel.TotalCount <= PageSize) { model.Page = ""; } else { model.Page = pager.GetPagerHtml(); } return(Json(new AjaxResult { Status = "1", Data = model })); }
public ActionResult LeaveWordsDetail(long Id, int pageIndex = 1) { LeaveWordsDetailModel model = new LeaveWordsDetailModel(); //查询数据 LeaveReMsgPageResult leaveModel = new LeaveReMsgPageResult(); leaveModel = LeavewordsService.GetLeaveReMsgPageList(Id, pageIndex, PageSize); model.leaveReMsgList = leaveModel.Leaveremsgs; //分页 Pagination pager = new Pagination(); pager.PageIndex = pageIndex; pager.PageSize = PageSize; pager.TotalCount = leaveModel.TotalCount; if (leaveModel.TotalCount <= PageSize) { model.Page = ""; } else { model.Page = pager.GetPagerHtml(); } return(Json(new AjaxResult { Status = "1", Data = model })); }
public ActionResult Leavewords(string Title, string Context) { long UserID = GetLoginID(); if (Title == "") { return(Json(new AjaxResult { Msg = "标题不能为空" })); } if (Context == "") { return(Json(new AjaxResult { Msg = "内容不能为空" })); } long result = LeavewordsService.Add(UserID, Title, Context); if (result > 0) { return(Json(new AjaxResult { Msg = "添加成功" })); } else { return(Json(new AjaxResult { Msg = "添加失败" })); } }
public ActionResult LeaveOut() { long userid = GetLoginID(); int FromUserType = 1; int PageIndex = 1; LeaveOutListModel model = new LeaveOutListModel(); //查询数据 LeaveOutPageResult leaveoutModel = new LeaveOutPageResult(); leaveoutModel = LeavewordsService.GetPageList(userid, FromUserType, PageIndex, PageSize); model.leaveoutList = leaveoutModel.LeaveOuts; //分页 Pagination pager = new Pagination(); pager.PageIndex = PageIndex; pager.PageSize = PageSize; pager.TotalCount = leaveoutModel.TotalCount; if (leaveoutModel.TotalCount <= PageSize) { model.Page = ""; } else { model.Page = pager.GetPagerHtml(); } return(View(model)); }
//收件箱 public ActionResult leaveMsg() { long userid = GetLoginID(); int ToUserType = 2; int PageIndex = 1; LeaveMsgListModel model = new LeaveMsgListModel(); //查询数据 LeaveMsgPageResult LeaveMsgModel = new LeaveMsgPageResult(); LeaveMsgModel = LeavewordsService.GetLeaveMsgPageList(userid, ToUserType, PageIndex, pageSize); model.leaveMsgList = LeaveMsgModel.LeaveMsg; //分页 Pagination pager = new Pagination(); pager.PageIndex = PageIndex; pager.PageSize = pageSize; pager.TotalCount = LeaveMsgModel.TotalCount; if (LeaveMsgModel.TotalCount <= pageSize) { model.Page = ""; } else { model.Page = pager.GetPagerHtml(); } return(View(model)); }
//发表评论 protected void pinglun_Click(object sender, EventArgs e) { if (Session["User_ID"] != null) { try { int id = Convert.ToInt32(Request.QueryString["id"].ToString()); Leavewords leavewords = new Leavewords(); leavewords.News_ID = id; leavewords.User_ID = int.Parse(Session["User_ID"].ToString()); leavewords.Leavewords_Time = DateTime.Now; leavewords.Leavewords_Content = txtContent.Text; if (LeavewordsService.InsertLeavewords(leavewords) == 1) { txtContent.Text = ""; ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "alert('评论成功!');", true); BindBC(); } else { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "alert('评论失败!');", true); } } catch (Exception ex) { Response.Write("错误原因:" + ex.Message); } } else { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "alert('对不起,请先登录!');", true); } }
protected void btnMessage_Click(object sender, EventArgs e) { int id = Convert.ToInt32(ViewState["VideoID"]); if (Session["UserName"] != null) { if (Page.IsValid) { int userid = Convert.ToInt32(Session["UserID"]); int videoid = Convert.ToInt32(Request.QueryString["VideoID"]); Leavewords leavewords = new Leavewords(); leavewords.UserID = userid; leavewords.VideoID = videoid; leavewords.LeaveContent = txtMessage.Text.Trim(); leavewords.LeaveTime = DateTime.Now; int result = LeavewordsService.InsertLeavewords(leavewords); if (result >= 1) { ScriptManager.RegisterClientScriptBlock(MessageUpdatePanel, this.GetType(), "click", "alert('留言成功')", true); BindMessage(); txtMessage.Text = ""; } else { ScriptManager.RegisterClientScriptBlock(MessageUpdatePanel, this.GetType(), "click", "alert('留言失败')", true); } } } else { ScriptManager.RegisterClientScriptBlock(MessageUpdatePanel, this.GetType(), "click", "alert('您必须先登录才能发表评论');", true); ScriptManager.RegisterStartupScript(MessageUpdatePanel, MessageUpdatePanel.GetType(), "updateScript", "window.location.href='Login.aspx'", true); } }
//留言详情 public ActionResult LeaveWordsDetail(long Id) { LeaveWordsDetailModel model = new LeaveWordsDetailModel(); model.data = LeavewordsService.GetModelByID(Id); LeaveReMsgPageResult leaveModel = new LeaveReMsgPageResult(); leaveModel = LeavewordsService.GetLeaveReMsgPageList(Id, 1, PageSize); model.leaveReMsgList = leaveModel.Leaveremsgs; //分页 Pagination pager = new Pagination(); pager.PageIndex = 1; pager.PageSize = PageSize; pager.TotalCount = leaveModel.TotalCount; if (leaveModel.TotalCount <= PageSize) { model.Page = ""; } else { model.Page = pager.GetPagerHtml(); } return(View(model)); }
public ActionResult LeaveWordsContext(long Id, string Context) { long userid = GetLoginID(); string UserCode = user.GetModel(userid).UserCode; if (Context == "") { return(Json(new AjaxResult { Msg = "内容不能为空" })); } long result = LeavewordsService.LeaveReMsgAdd(Id, userid, UserCode, Context); if (result > 0) { return(Json(new AjaxResult { Msg = "添加成功" })); } else { return(Json(new AjaxResult { Msg = "添加失败" })); } }
//数据绑定 private void BindAct() { DataTable dt = LeavewordsService.SelectAllliuyan(); if (dt != null && dt.Rows.Count > 0) { ListView1.DataSource = dt; ListView1.DataBind(); } }
//留言删除 protected void btnDelete_Click(object sender, EventArgs e) { Button bt = (Button)sender; int id = Convert.ToInt32(((HiddenField)(bt.Parent.FindControl("HiddenField1"))).Value); if (LeavewordsService.usersDelete(id) > 0) { ClientScript.RegisterStartupScript(this.GetType(), "message", "<script language='javascript' >alert('删除成功!');</script>"); } }
protected void BindBC() { int id = int.Parse(Request.QueryString["id"].ToString()); DataTable dt = LeavewordsService.SelectLeavewords(id); if (dt != null) { listView1.DataSource = dt; listView1.DataBind(); } }
//绑定留言信息 private void BindMessage() { //int id = Convert.ToInt32(ViewState["VideoID"]); int id = int.Parse(Request.QueryString["id"]); DataTable dt = LeavewordsService.SelectLeavewords(id); if (dt != null && dt.Rows.Count > 0) { MessageListView.DataSource = dt; MessageListView.DataBind(); } }
public ActionResult Leavewords(long UserID, string UserCode, string Title, string Context) { if (UserCode == "") { return(Json(new AjaxResult { Msg = "留言对象不能为空" })); } var user = UserService.GetModelCode(UserCode); if (user == null) { return(Json(new AjaxResult { Msg = "留言对象不存在" })); } if (Title == "") { return(Json(new AjaxResult { Msg = "标题不能为空" })); } if (Context == "") { return(Json(new AjaxResult { Msg = "内容不能为空" })); } long result = LeavewordsService.Add(UserID, Title, Context); if (result > 0) { return(Json(new AjaxResult { Msg = "添加成功" })); } else { return(Json(new AjaxResult { Msg = "添加失败" })); } }
public ActionResult LeaveWordsContext(long Id, string Context) { if (Context == "") { return(Json(new AjaxResult { Msg = "内容不能为空" })); } long result = LeavewordsService.ContentAdd(Id, Context); if (result > 0) { return(Json(new AjaxResult { Msg = "添加成功" })); } else { return(Json(new AjaxResult { Msg = "添加失败" })); } }
protected void Page_Load(object sender, EventArgs e) { //测试 int id; #region 如果用户登录了,将用户信息绑定 //如果用户登录了,将用户信息绑定 if (Session["User_Name"] != null) { BindAcg(); BindComments(); BingLeavewords(); SqlDataReader dt = UserInfoService.users(int.Parse(Session["User_ID"].ToString())); dt.Read(); if (dt != null) { User_Name.Text = dt[1].ToString(); User_Email.Text = dt[4].ToString(); User_Password.Text = dt[2].ToString(); User_Phone.Text = dt[5].ToString(); User_Img.ImageUrl = dt[3].ToString(); } } #endregion if (!IsPostBack) { try { #region Acg投稿数据绑定和删除 if (Request.QueryString["proid"] != null) { id = Convert.ToInt32(Request.QueryString["proid"].ToString()); if (AcgService.delete(id) == 1) { BindAcg(); Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('删除成功!');</script>"); } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('删除删除失败!');</script>"); } } #endregion #region 用户评论数据绑定和删除 if (Request.QueryString["commentsid"] != null) { id = Convert.ToInt32(Request.QueryString["commentsid"].ToString()); if (CommentService.usersDelete(id) == 1) { BindComments(); Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('删除成功!');</script>"); } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('删除删除失败!');</script>"); } } #endregion #region 用户回复数据绑定和删除 if (Request.QueryString["Leavewordsid"] != null) { id = Convert.ToInt32(Request.QueryString["Leavewordsid"].ToString()); if (LeavewordsService.usersDelete(id) == 1) { BingLeavewords(); Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('删除成功!');</script>"); } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('删除删除失败!');</script>"); } } #endregion } catch (Exception ex) { } } }
//绑定留言 protected void BindLeavewords() { UserIndex_Leavewords.DataSource = LeavewordsService.usersSellect(int.Parse(Session["User_ID"].ToString())); UserIndex_Leavewords.DataBind(); }
//绑定被回复 protected void BindReplyLeavewords() { UserIndex_replayleawords.DataSource = LeavewordsService.SelectBLae(int.Parse(Session["User_ID"].ToString())); UserIndex_replayleawords.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { CKFinder.FileBrowser fileBrowser = new CKFinder.FileBrowser(); fileBrowser.BasePath = "../ckfinder/"; //设置CKFinder的基路径 fileBrowser.SetupCKEditor(txtContent); UnobtrusiveValidationMode = new UnobtrusiveValidationMode(); int id; if (!IsPostBack) { #region 前台panel控件可见与否 if (Request.QueryString["menupanel"] != null) { #region a1可见 if (Request.QueryString["menupanel"] == "a1") { a1.Visible = true; b1.Visible = false; b2.Visible = false; c1.Visible = false; c2.Visible = false; c3.Visible = false; c4.Visible = false; d1.Visible = false; d2.Visible = false; d3.Visible = false; } #endregion #region b1可见 if (Request.QueryString["menupanel"] == "b1") { a1.Visible = false; b1.Visible = true; b2.Visible = false; c1.Visible = false; c2.Visible = false; c3.Visible = false; c4.Visible = false; d1.Visible = false; d2.Visible = false; d3.Visible = false; } #endregion #region b2可见 if (Request.QueryString["menupanel"] == "b2") { a1.Visible = false; b1.Visible = false; b2.Visible = true; c1.Visible = false; c2.Visible = false; c3.Visible = false; c4.Visible = false; d1.Visible = false; d2.Visible = false; d3.Visible = false; } #endregion #region c1可见 if (Request.QueryString["menupanel"] == "c1") { a1.Visible = false; b1.Visible = false; b2.Visible = false; c1.Visible = true; c2.Visible = false; c3.Visible = false; c4.Visible = false; d1.Visible = false; d2.Visible = false; d3.Visible = false; } #endregion #region c2可见 if (Request.QueryString["menupanel"] == "c2") { a1.Visible = false; b1.Visible = false; b2.Visible = false; c1.Visible = false; c2.Visible = true; c3.Visible = false; c4.Visible = false; d1.Visible = false; d2.Visible = false; d3.Visible = false; } #endregion #region c3可见 if (Request.QueryString["menupanel"] == "c3") { a1.Visible = false; b1.Visible = false; b2.Visible = false; c1.Visible = false; c2.Visible = false; c3.Visible = true; c4.Visible = false; d1.Visible = false; d2.Visible = false; d3.Visible = false; } #endregion #region c4可见 if (Request.QueryString["menupanel"] == "c4") { a1.Visible = false; b1.Visible = false; b2.Visible = false; c1.Visible = false; c2.Visible = false; c3.Visible = false; c4.Visible = true; d1.Visible = false; d2.Visible = false; d3.Visible = false; } #endregion #region d1可见 if (Request.QueryString["menupanel"] == "d1") { a1.Visible = false; b1.Visible = false; b2.Visible = false; c1.Visible = false; c2.Visible = false; c3.Visible = false; c4.Visible = false; d1.Visible = true; d2.Visible = false; d3.Visible = false; } #endregion #region d2可见 if (Request.QueryString["menupanel"] == "d2") { a1.Visible = false; b1.Visible = false; b2.Visible = false; c1.Visible = false; c2.Visible = false; c3.Visible = false; c4.Visible = false; d1.Visible = false; d2.Visible = true; d3.Visible = false; } #endregion #region d3可见 if (Request.QueryString["menupanel"] == "d3") { a1.Visible = false; b1.Visible = false; b2.Visible = false; c1.Visible = false; c2.Visible = false; c3.Visible = false; c4.Visible = false; d1.Visible = false; d2.Visible = false; d3.Visible = true; } #endregion } #endregion #region 如果用户登录了,将用户信息绑定 overlogin.Visible = false; nologin.Visible = false; //如果用户登录了,将用户信息绑定 if (Session["User_Name"] != null) { overlogin.Visible = true; //绑定ACG BindAcg(); //绑定评论 BindComments(); //绑定留言 BindLeavewords(); //绑定他人评论 BindTComments(); //绑定他人留言 BindTLea(); //绑定被评论 BindReplyComments(); //绑定被回复 BindReplyLeavewords(); SqlDataReader dt = UserInfoService.users(int.Parse(Session["User_ID"].ToString())); dt.Read(); if (dt != null) { UserName.Text = dt[1].ToString(); UserEmail.Text = dt[4].ToString(); //Image1.ImageUrl = dt[3].ToString(); //UserPhone.Text = dt[5].ToString(); UserImg.ImageUrl = dt[3].ToString(); } #region 修改用户信息 if (Request.QueryString["queren"] != null) { if (ChangMima.Text.Trim() == ChangMima2.Text.Trim()) { UserInfo user = new UserInfo(); user.User_ID = int.Parse(Session["User_ID"].ToString()); user.User_Name = ChangName.Text.Trim(); user.User_Password = ChangMima.Text.Trim(); user.User_Phone = ChangPhone.Text.Trim(); user.User_Email = ChangEmail.Text.Trim(); user.User_Img = "Img\\UserImg\\" + ChangImg.PostedFile.FileName; if (UserInfoService.usersupdate(user) == 1) { //Session["UserImg"] = @"~/User_Img/" + FileUpload_img.PostedFile.FileName; Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('修改成功!');</script>"); } else { Page.ClientScript.RegisterClientScriptBlock(typeof(object), "alert", "<script>alert('修改失败!');</script>"); } } else { Page.ClientScript.RegisterClientScriptBlock(typeof(object), "alert", "<script>alert('前后密码不一致!');</script>"); } } #endregion } else { nologin.Visible = true; } #endregion try { #region Acg投稿数据绑定和删除 if (Request.QueryString["proid"] != null) { id = Convert.ToInt32(Request.QueryString["proid"].ToString()); if (AcgService.delete(id) == 1) { BindAcg(); Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('删除成功!');</script>"); } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('删除删除失败!');</script>"); } } #endregion #region 用户评论删除 if (Request.QueryString["commentsid"] != null) { id = Convert.ToInt32(Request.QueryString["commentsid"].ToString()); if (CommentService.usersDelete(id) == 1) { BindComments(); Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('删除成功!');</script>"); } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('删除删除失败!');</script>"); } } #endregion #region 用户回复数据绑定和删除 if (Request.QueryString["Leavewordsid"] != null) { id = Convert.ToInt32(Request.QueryString["Leavewordsid"].ToString()); if (LeavewordsService.usersDelete(id) == 1) { BindLeavewords(); Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('删除成功!');</script>"); } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('删除删除失败!');</script>"); } } #endregion } catch (Exception ex) { } } }