protected void btnZoneSave_Click(object sender, EventArgs e) { try { SQLOperation sql = new SQLOperation(); string userID = Session["NowUserId"].ToString(); if (txtZoneTitle == null) { helper.alertHelper(this, "空间标题不可以为空!"); } else { string limit = dplstLimit.SelectedValue.ToString(); sql.update(" zoneInfo ", " title='" + txtZoneTitle.Text + "',WhoCanSee='" + limit + "' ", " userid= " + userID); btnZoneChange.Text = "空间设置修改"; txtZoneTitle.Visible = false; dplstLimit.Visible = false; btnZoneSave.Visible = false; helper.alertHelper(this, "空间修改成功!", "PersonalInfoPage.aspx"); } } catch (Exception exception) { helper.alertHelper(this, "空间修改失败!"); } }
protected void Page_Load(object sender, EventArgs e) { SQLOperation sql = new SQLOperation(); if (Session["NowUserId"] != null) { string id; /*权限设置的选项初始化*/ dplstLimit.Items.Add("所有人可见"); dplstLimit.Items.Add("仅双方可见"); if (Request.QueryString["id"] != null) //正在被访问 { id = Request.QueryString["id"].ToString(); } else { divAddMessage.Visible = false;//自己不可以给自己留言 id = Session["NowUserId"].ToString(); } DataTable dt = sql.select(" a_message.*,users.nickname ", " a_message,users ", " a_message.userid= " + id + " and users.id=a_message.messagerId"); /*然后是repeater的数据绑定*/ } else { helper.alertHelper(this, "请先登录", "MainPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["NowUserId"] != null) { if (Request.QueryString["id"] == null) { string id; id = Session["NowUserId"].ToString(); SQLOperation sql = new SQLOperation(); RepeaterOperate rptOperate = new RepeaterOperate(); DataTable dtt = sql.select(" distinct users.NickName,A_Status.* ", " Friends,(users join A_Status on users.id = A_Status.UserId) ", " (users.id = " + id + ") or (Friends.UserId =" + id + " and Users.id = Friends.FriendId)"); //rptOperate.dataBound(ref rptAllStatus, ref dtt); rptOperate.dataBound(ref rptAllStatus, ref dtt, 1, ref lblTotal, 5); lblNow.Text = "1"; } else { helperSpecial.alertHelper(this, "您无权访问他人的个人中心!"); } } else { Response.Write("<script> alert('请先登录!');location= 'MainPage.aspx'</script> "); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["NowUserId"] != null) { /*权限设置的选项初始化*/ dplstLimit.Items.Add("所有人可见"); dplstLimit.Items.Add("仅好友可见"); dplstLimit.Items.Add("仅自己可见"); dplstLimit.Items.Add("部分好友不可见"); if (Request.QueryString["id"] != null)//说明现在是在被访问状态 { divStatusAdd.Visible = false; } else { string id; id = Session["NowUserId"].ToString(); SQLOperation sql = new SQLOperation(); RepeaterOperate rptOperate = new RepeaterOperate(); DataTable dtt = sql.select(" users.NickName,A_Status.* ", " users,a_status ", " users.id = " + id); //rptOperate.dataBound(ref rptAllStatus, ref dtt); // rptOperate.dataBound(ref rptStatusShow, ref dtt, 1, ref lblTotal, 5); // lblNow.Text = "1"; } } else { helper.alertHelper(this, "请先登录!", "MainPage.aspx"); } }
protected void rptClasses_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "hyptClass") //查看该分类下的所有日志列表 { classID = e.CommandArgument.ToString(); SQLOperation sql = new SQLOperation(); string id = Session["NowUserId"].ToString(); DataTable dt = sql.select(" a_diary.title,a_diary.id ,a_diary.time ", " a_diary,classes ", " a_diary.classId = classes.id and classes.userId = " + id + " and classes.id =" + classID); RepeaterOperate rptHelper = new RepeaterOperate(); rptHelper.dataBound(ref rptAllDiaries, ref dt, 1, ref lblTotal, 5); } if (e.CommandName == "btnDelClass") //删除分类 { classID = e.CommandArgument.ToString(); SQLOperation sql = new SQLOperation(); if (sql.delete(" classes ", " id= " + classID) && sql.delete(" a_diary ", " classId= " + classID)) { helper.alertHelper(this, "删除分类成功", "DiaryPage.aspx"); } } }
protected void rptInReply_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "btnCommentDel") //删除评论按钮 { try { SQLOperation sql = new SQLOperation(); string commentID = e.CommandArgument.ToString(); DataTable dtReply = sql.select(" id ", " a_comment ", " commentedID= " + commentID + " and kind='comment'"); for (int j = 0; j < dtReply.Rows.Count; j++) //删除评论下面的回复 { sql.delete(" a_comment ", " id=" + dtReply.Rows[j][0].ToString()); } sql.delete(" a_comment ", " id=" + commentID); helper.alertHelper(this, "删除评论成功!", "DiaryWritingPage.aspx?op=" + Request.QueryString["op"].ToString()); } catch (Exception exception) { helper.alertHelper(this, "删除评论失败!"); } } if (e.CommandName == "btnReply") { Button btn = (Button)e.Item.FindControl("btnReply"); if (e.Item.FindControl("btnAddReply").Visible) //正在回复时点击 { btn.Text = "回复"; e.Item.FindControl("btnAddReply").Visible = false; e.Item.FindControl("txtReply").Visible = false; } else { e.Item.FindControl("btnAddReply").Visible = true; e.Item.FindControl("txtReply").Visible = true; btn.Text = "取消回复"; } } else if (e.CommandName == "btnAddReply") { TextBox txt = (TextBox)e.Item.FindControl("txtReply"); string id; string content = txt.Text; if (txt == null) { txt.ForeColor = System.Drawing.Color.Red; txt.Text = "回复不可以为空!"; } else { id = Session["NowUserId"].ToString(); SQLOperation sql = new SQLOperation(); // if(sql.add(" a_comment "," ")) string commentedId = e.CommandArgument.ToString(); string time = DateTime.Now.ToString(); string kind = "comment"; if (sql.add(" a_comment ", commentedId + "," + id + ",'" + content + "','" + time + "','" + kind + "'," + commentedId)) { e.Item.FindControl("txtReply").Visible = false; e.Item.FindControl("btnReply").Visible = false; e.Item.FindControl("btnAddReply").Visible = false; Response.Write("<script> alert('回复成功!');location= 'PersonalCenterPage.aspx'</script> "); } else { txt.Text = "回复失败"; } } } } //评论的按钮判断