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)
{
}
}
}
