protected void rptDraft_ItemCommand(object source, RepeaterCommandEventArgs e) { myClass myclass = new myClass(); //发布日志 if (e.CommandName == "Submit") { int logid = Convert.ToInt32(e.CommandArgument.ToString()); int id = Convert.ToInt32(Session["id"].ToString()); DataTable dt = new DataTable(); string sql = "select * from Log where logid ='" + logid + "'"; dt = myclass.JudgeIor(sql); string title = dt.Rows[0][1].ToString(); string simplify = dt.Rows[0][8].ToString(); DateTime now = DateTime.Now; //判断分类决定是否要同步动态到个人中心 sql = "select * from Log where logid = '" + logid + "'"; dt = myclass.JudgeIor(sql); string compare = "所有人可见"; if (string.Compare(compare, dt.Rows[0][5].ToString()) == 0) { sql = "update Log set draft = '1',logtime='" + now + "' where logid='" + logid + "'"; int flag = myclass.DataSQL(sql); string name = myclass.RerdName(id); string sculpture = myclass.RerdSculpture(id); string other = name + "发表了日志" + title; string state = "insert into State (stater,statetime,other,statelike,statername,staterscu,logs,lable) values('" + id + "','" + now + "','" + other + "',',','" + name + "','" + sculpture + "','" + logid + "','" + simplify + "')"; int stateflag = myclass.DataSQL(state); } Response.Write("<script>alert('发布成功!')</script>"); Server.Transfer("Log.aspx"); } }
protected void rptComment_ItemCommand(object source, RepeaterCommandEventArgs e) { myClass myclass = new myClass(); //跳页 if (e.CommandName == "Jump1") { int friendid = Convert.ToInt32(e.CommandArgument.ToString()); Session["Friendid"] = friendid.ToString(); Response.Write("<script>window.location='Person/Person.aspx'</script>"); } if (e.CommandName == "Jump2") { int friendid = Convert.ToInt32(e.CommandArgument.ToString()); Session["Friendid"] = friendid.ToString(); //Server.Transfer("Person/Person.asxp"); Response.Write("<script>window.location='Myhistory.aspx'</script>"); } //删除评论 if (e.CommandName == "Delete") { int statecommentid = Convert.ToInt32(e.CommandArgument.ToString()); string sql = "select * from StateComment where statecommentid = '" + statecommentid + "'"; DataTable dt = new DataTable(); dt = myclass.JudgeIor(sql); string time = dt.Rows[0][3].ToString(); //同步删除照片评论 if (dt.Rows[0][6].ToString().Length == 0) { int classid = Convert.ToInt32(dt.Rows[0][7].ToString()); string classfy = "photo"; sql = "delete from Reply where replytime='" + time + "' and classid ='" + classid + "' and replyclass = '" + classfy + "' "; myclass.DataSQL(sql); } //同步删除日志评论 else { int classid = Convert.ToInt32(dt.Rows[0][6].ToString()); string classfy = "log"; sql = "delete from Reply where replytime='" + time + "' and classid ='" + classid + "' and replyclass = '" + classfy + "' "; myclass.DataSQL(sql); } //删除评论 sql = "delete from StateComment where statecommentid='" + statecommentid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('删除成功!');location='Myhistory.aspx'</script>"); } } }
//用户外层repeater protected void rptMassage_ItemCommand(object source, RepeaterCommandEventArgs e) { myClass myclass = new myClass(); if (e.CommandName == "Delete") { int massageid = Convert.ToInt32(e.CommandArgument.ToString()); string sql = "delete from Massage where massageid='" + massageid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('删除成功!')</script>"); } Server.Transfer("Message.aspx"); } if (e.CommandName == "Anwser") { int id = Convert.ToInt32(Session["id"].ToString()); int massageid = Convert.ToInt32(e.CommandArgument.ToString()); string sql = "select * from Massage where massageid= '" + massageid + "'"; DataTable dt = new DataTable(); dt = myclass.JudgeIor(sql); int massageuserid = Convert.ToInt32(dt.Rows[0][3].ToString()); DateTime now = DateTime.Now; string txt = ((TextBox)e.Item.FindControl("txtAnwserCom")).Text; //sql = "insert into MassageComment (_massageid,_massageownerid,_massageuserid,massagecommendtext,_publishtime) values('" + massageid + "','" + massageuserid + "','" + id + "','" + txt + "','" + now + "')"; string massageusername = myclass.RerdName(id); string massageownername = myclass.RerdName(massageuserid); sql = "insert into MassageComment (_massageid,_massageownerid,_massageuserid,massagecommendtext,_publishtime,_massageownername,_massageusername) values('" + massageid + "','" + massageuserid + "','" + id + "','" + txt + "','" + now + "','" + massageownername + "','" + massageusername + "')"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('回复成功!')</script>"); } Server.Transfer("Message.aspx"); } if (e.CommandName == "Jump") { int friendid = Convert.ToInt32(e.CommandArgument.ToString()); Session["Friendid"] = friendid.ToString(); Response.Write("<script>window.location='../Person/Person.aspx'</script>"); } }
protected void btnUp_Click(object sender, EventArgs e) { myClass myclass = new myClass(); int id = Convert.ToInt32(Session["id"].ToString()); try { if (fup.PostedFile.FileName == "") { lblInfo.Text = "请选择文件!"; } else { //string filepath = fup.PostedFile.FileName; if (!IsAllowedExtension(fup)) { lblInfo.Text = "上传文件格式不正确!"; } if (IsAllowedExtension(fup) == true) { string filepath = fup.PostedFile.FileName; string filename = filepath.Substring(filepath.LastIndexOf("\\") + 1); string serverpath = Server.MapPath("../Album/picture/") + filename; fup.PostedFile.SaveAs(serverpath); serverpath = "Album/picture/" + filename; string sql = "update UserList set sculpture='" + serverpath + "' where id='" + id + "'"; int flag = myclass.DataSQL(sql); sql = "update Massage set ownersculpture='" + serverpath + "' where massageowner='" + id + "'"; flag = myclass.DataSQL(sql); sql = "update Reply set replyerscu='" + serverpath + "' where replyer='" + id + "'"; flag = myclass.DataSQL(sql); sql = "update Reply set replyownerscu='" + serverpath + "' where replyowner='" + id + "'"; flag = myclass.DataSQL(sql); sql = "update State set staterscu='" + serverpath + "' where stater='" + id + "'"; flag = myclass.DataSQL(sql); if (flag == 1) { lblInfo.Text = "上传成功!"; Server.Transfer("Person.aspx"); } else { lblInfo.Text = "上传失败!"; } } else { lblInfo.Text = "请上传图片!"; } } } catch (Exception ex) { lblInfo.Text = "上传发生错误!原因是:" + ex.ToString(); } }
protected void btnReply_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Session["id"].ToString()); int friendid; //判断是否在好友页面 if (Session["Friendid"] == null) { friendid = id; } else { friendid = Convert.ToInt32(Session["Friendid"].ToString()); } string reply = txtReply.Text; //验证空值 if (reply.Length == 0) { Response.Write("<script>alert('输入不能为空!')</script>"); } else { int photoid = Convert.ToInt32(Request.QueryString["photoid"]); DateTime now = DateTime.Now; myClass myclass = new myClass(); string replyername = myclass.RerdName(id); string replyowenername = myclass.RerdName(friendid); string replyerscu = myclass.RerdSculpture(id); string replyownerscu = myclass.RerdSculpture(friendid); string replyclass = "photo"; string sql = "insert into Reply (replytime,replyer,replyowner,replytext,replyername,replyownername,replyownerscu,replyerscu,replyclass,classid) values('" + now + "','" + id + "','" + friendid + "','" + reply + "','" + replyername + "','" + replyowenername + "','" + replyerscu + "','" + replyowenername + "','" + replyclass + "','" + photoid + "')"; int flag = myclass.DataSQL(sql); //评论同时添加到个人中心 DataTable dt = new DataTable(); sql = "select * from State where photos = '" + photoid + "'"; dt = myclass.JudgeIor(sql); int stateid = Convert.ToInt32(dt.Rows[0][0].ToString()); sql = "insert into StateComment (_stateid,_stater,_stateowner,_statetime,_statement,_photoid,_statername,_staterownername) values('" + stateid + "','" + id + "','" + friendid + "','" + now + "','" + reply + "','" + photoid + "','" + replyername + "','" + replyowenername + "')"; int stateflag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('发布成功!')</script>"); Server.Transfer("ThePhoto.aspx"); } } }
protected void btnPub_Click(object sender, EventArgs e) { int id = Convert.ToInt16(Session["id"].ToString()); int logid = Convert.ToInt32(Request.QueryString["logid"]); string title = txtTitle.Text; string content = Request.Form["content1"]; string classr = dropClass.SelectedValue; string power = dropPower.SelectedValue; DateTime now = DateTime.Now; DataTable dt = new DataTable(); myClass myclass = new myClass(); if (title.Length == 0 || content.Length == 0) { Response.Write("<script>alert('输入不能为空!')</script>"); } else { string sql = "select * from LogClass where classfyname='" + classr + "'and logowner ='" + id + "'"; dt = myclass.JudgeIor(sql); int classid = Convert.ToInt16(dt.Rows[0][0].ToString()); //获取纯文本 string simplify = System.Text.RegularExpressions.Regex.Replace(content, @"<[///!]*?[^<>]*?>", "").Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", "").Replace(" ", ""); //判断是否截取 if (simplify.Length >= 50) { simplify = simplify.Substring(0, 50) + "...."; } //判断是否要发动态 sql = "update Log set title='" + title + "',simplify='" + simplify + "',logtext='" + content + "',logtime='" + now + "',logpower='" + power + "', _classfyid='" + classid + "',draft='0' where logid = '" + logid + "'"; int flag = myclass.DataSQL(sql); string name = myclass.RerdName(id); string sculpture = myclass.RerdSculpture(id); string other = name + "发表了日志" + title; string state = "insert into State (stater,statetime,other,statelike,statername,staterscu,logs,lable) values('" + id + "','" + now + "','" + other + "',',','" + name + "','" + sculpture + "','" + logid + "','" + simplify + "')"; int stateflag = myclass.DataSQL(state); if (flag == 1) { Response.Write("<script>alert('发布成功!')</script>"); Server.Transfer("Draft.aspx"); } else { Response.Write("<script>alert('发布失败!')</script>"); Server.Transfer("DraftEditor.aspx"); } } }
protected void rptClass_ItemCommand(object source, RepeaterCommandEventArgs e) { myClass myclass = new myClass(); if (e.CommandName == "Delete") { int classid = Convert.ToInt32(e.CommandArgument.ToString()); string sql = "delete from LogClass where classfyid='" + classid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('删除成功!')</script>"); } Server.Transfer("EditorClass.aspx"); } if (e.CommandName == "Change") { int classid = Convert.ToInt32(e.CommandArgument.ToString()); string txt = ((TextBox)e.Item.FindControl("txtName")).Text; string sql = "select * from LogClass where classfyid = '" + classid + "'"; DataTable dt = new DataTable(); dt = myclass.JudgeIor(sql); string campare = "默认分类"; if (txt.Length == 0) { Response.Write("<script>alert('输入不能为空!')</script>"); } else if (string.Compare(campare, dt.Rows[0][1].ToString()) == 0) { Response.Write("<script>alert('默认分类不能修改!')</script>"); } else { sql = "update LogClass set classfyname='" + txt + "' where classfyid='" + classid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('修改成功!')</script>"); } Server.Transfer("EditorClass.aspx"); } } }
protected void btnChange_Click(object sender, EventArgs e) { string pwd = txtPwd.Text; string repwd = txtrePwd.Text; if (String.Compare(pwd, repwd) != 0) { Response.Write("<script>alert('前后两次密码不一样!')</script>"); } else { int id = Convert.ToInt32(Session["id"].ToString()); pwd = MD5(pwd); string sql = "update UserList set pwd='" + pwd + "' where id='" + id + "'"; myClass myclass = new myClass(); int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('重置成功!');location='Login.aspx'</script>"); } } }
protected void btnSub_Click(object sender, EventArgs e) { int id = Convert.ToInt16(Session["id"].ToString()); string classname = txtAdd.Text; if (classname.Length == 0) { Response.Write("<script>alert('输入不能为空!')</script>"); } else { string sql = "insert into LogClass (logowner,classfyname) values('" + id + "','" + classname + "')"; myClass myclass = new myClass(); int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('添加成功!')</script>"); } else { Response.Write("<script>alert('添加失败!')</script>"); } Server.Transfer("Abstract.aspx"); } }
//用户内层repeater protected void rptComment_ItemCommand(object source, RepeaterCommandEventArgs e) { myClass myclass = new myClass(); if (e.CommandName == "Delete") { int massagecommentid = Convert.ToInt32(e.CommandArgument.ToString()); string sql = "delete from MassageComment where massagecommentid='" + massagecommentid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('删除成功!')</script>"); } Server.Transfer("Message.aspx"); } if (e.CommandName == "Jump1") { int friendid = Convert.ToInt32(e.CommandArgument.ToString()); Session["Friendid"] = friendid.ToString(); Response.Write("<script>window.location='../Person/Person.aspx'</script>"); } if (e.CommandName == "Jump2") { int friendid = Convert.ToInt32(e.CommandArgument.ToString()); Session["Friendid"] = friendid.ToString(); Response.Write("<script>window.location='../Person/Person.aspx'</script>"); } }
protected void btnSub_Click(object sender, EventArgs e) { myClass myclass = new myClass(); int id = Convert.ToInt32(Session["id"].ToString()); string state = txtState.Text; DateTime now = DateTime.Now; //判断空值 if (state.Length == 0) { Response.Write("<script>alert('输入不能为空!')</script>"); } else { //发表说说 string name = myclass.RerdName(id); string sculpture = myclass.RerdSculpture(id); string sql = "insert into State (stater,statetime,statement,statelike,statername,staterscu) values('" + id + "','" + now + "','" + state + "',',','" + name + "','" + sculpture + "')"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('发布成功!');location='Myhistory.aspx'</script>"); } } }
protected void lbDelete_Click(object sender, EventArgs e) { myClass myclass = new myClass(); int logid = Convert.ToInt32(Request.QueryString["logid"]); string sql = "delete from Log where logid='" + logid + "'"; int flag = myclass.DataSQL(sql); sql = "delete from State where logs = '" + logid + "'"; flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('删除成功!')</script>"); Server.Transfer("Log.aspx"); } }
protected void rptClassfy_ItemCommand(object source, RepeaterCommandEventArgs e) { myClass myclass = new myClass(); if (e.CommandName == "Delete") { int classfyid = Convert.ToInt32(e.CommandArgument.ToString()); string sql = "select * from LogClass where classfyid = '" + classfyid + "'"; DataTable dt = new DataTable(); dt = myclass.JudgeIor(sql); string campare = "默认分类"; if (string.Compare(campare, dt.Rows[0][1].ToString()) == 0) { Response.Write("<script>alert('默认分类不能删除!')</script>"); } else { sql = "delete from LogClass where classfyid='" + classfyid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('删除成功!')</script>"); Server.Transfer("Abstract.aspx"); } } } }
protected void btnSub_Click(object sender, EventArgs e) { myClass myclass = new myClass(); int id = Convert.ToInt32(Session["id"].ToString()); string name = txtName.Text; string authority = rdlAuthority.SelectedValue; if (name.Length == 0) { Response.Write("<script>alert('名称不能为空!')</script>"); } else { string interfaces = "picture/QQ截图20161126121705.png"; string sql = "insert into Album (albumname,interface,owner,authority) values('" + name + "','" + interfaces + "','" + id + "','" + authority + "')"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('添加成功!');location='Album.aspx'</script>"); } else { Response.Write("<script>alert('添加失败!');location='AddAlbum.aspx'</script>"); } } }
protected void rptPhoto_ItemCommand(object source, RepeaterCommandEventArgs e) { myClass myclass = new myClass(); //删除照片 if (e.CommandName == "Delete") { int photoid = Convert.ToInt32(e.CommandArgument.ToString()); string sql = "delete from Photo where photoid='" + photoid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('删除成功!')</script>"); Server.Transfer("Photo.aspx"); } } if (e.CommandName == "Interface") { //修改封面 int albumid = Convert.ToInt32(Request.QueryString["albumid"]); int photoid = Convert.ToInt32(e.CommandArgument.ToString()); string sql = "select *from Photo where photoid='" + photoid + "'"; DataTable dt = new DataTable(); dt = myclass.JudgeIor(sql); string path = dt.Rows[0][3].ToString(); sql = "update Album set interface='" + path + "' where albumid = '" + albumid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('修改成功!')</script>"); Server.Transfer("Photo.aspx"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string hobby = radlHobby.SelectedValue; int id = Convert.ToInt32(Session["id"].ToString()); string sql = "update UserList set hobby = '" + hobby + "' where id='" + id + "'"; myClass myclass = new myClass(); myclass.DataSQL(sql); Session["hobby"] = hobby; Server.Transfer("Friends.aspx"); }
protected void btnSex_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Session["id"].ToString()); string sex = rdlSex.SelectedValue; myClass myclass = new myClass(); string sql = "update UserList set sex='" + sex + "' where id='" + id + "'"; int flag = myclass.DataSQL(sql); Response.Write("<script>alert('修改成功!');location='Person.aspx'</script>"); }
protected void btnPhone_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Session["id"].ToString()); string phone = txtPhone.Text; myClass myclass = new myClass(); string sql = "update UserList set phone='" + phone + "' where id='" + id + "'"; int flag = myclass.DataSQL(sql); Response.Write("<script>alert('修改成功!');location='Person.aspx'</script>"); }
protected void rptFriends_ItemCommand(object source, RepeaterCommandEventArgs e) { myClass myclass = new myClass(); int id = Convert.ToInt32(Session["id"].ToString()); if (e.CommandName == "Add") { int _id = Convert.ToInt32(e.CommandArgument.ToString()); string sql1 = "select * from Friends where me='" + id + "' and friends = '" + _id + "'"; int count = myclass.JudgeAcc(sql1); if (count > 0) { Response.Write("<script>alert('好友已存在!')</script>"); } else { string name = myclass.RerdName(id); string _name = myclass.RerdName(_id); string sql = "insert into Friends (me,friends,myname,friendname) values('" + id + "','" + _id + "','" + name + "','" + _name + "')"; string _sql = "insert into Friends (me,friends,myname,friendname) values('" + _id + "','" + id + "','" + _name + "','" + name + "')"; int flag = myclass.DataSQL(sql); int _flag = myclass.DataSQL(_sql); if (flag == 1 && _flag == 1) { Response.Write("<script>alert('添加成功!')</script>"); } else { Response.Write("<script>alert('添加失败!')</script>"); } } } }
protected void rptFriend_ItemCommand(object source, RepeaterCommandEventArgs e) { myClass myclass = new myClass(); if (e.CommandName == "Delete") { int relationid = Convert.ToInt32(e.CommandArgument.ToString()); string sql = "select from Friends where relationid='" + relationid + "'"; DataTable dt = new DataTable(); dt = myclass.JudgeIor(sql); int me = Convert.ToInt32(dt.Rows[0][1].ToString()); int friend = Convert.ToInt32(dt.Rows[0][2].ToString()); sql = "delete from Friends where me='" + me + "' and friends = '" + friend + "'"; int flag = myclass.DataSQL(sql); sql = "delete from Friends where me='" + friend + "' and friends = '" + me + "'"; flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('删除成功!');location='FriendList.aspx'</script>"); } } if (e.CommandName == "Jump") { int friendid = Convert.ToInt32(e.CommandArgument.ToString()); Session["Friendid"] = friendid.ToString(); Response.Write("<script>window.location='../Person/Person.aspx'</script>"); } }
protected void rptAdd_ItemCommand(object source, RepeaterCommandEventArgs e) { myClass myclass = new myClass(); //双向添加好友同时添加两条记录 if (e.CommandName == "Add") { int _id = Convert.ToInt32(e.CommandArgument.ToString()); int id = Convert.ToInt32(Session["id"].ToString()); string name = myclass.RerdName(id); string _name = myclass.RerdName(_id); string sql = "insert into Friends (me,friends,myname,friendname) values('" + id + "','" + _id + "','" + name + "','" + _name + "')"; string _sql = "insert into Friends (me,friends,myname,friendname) values('" + _id + "','" + id + "','" + _name + "','" + name + "')"; int flag = myclass.DataSQL(sql); int _flag = myclass.DataSQL(_sql); if (flag == 1 && _flag == 1) { Response.Write("<script>alert('添加成功!')</script>"); } else { Response.Write("<script>alert('添加失败!')</script>"); } } //跳转至好友空间 if (e.CommandName == "Jump") { int friendid = Convert.ToInt32(e.CommandArgument.ToString()); Session["Friendid"] = friendid.ToString(); Response.Write("<script>window.location='Person/Person.aspx'</script>"); } }
protected void btnDrafts_Click(object sender, EventArgs e) { //功能同上 int id = Convert.ToInt32(Session["id"].ToString()); string title = txtTitle.Text; string content = Request.Form["content1"]; string classr = dropClass.SelectedValue; string power = dropPower.SelectedValue; int draft = 1; DateTime now = DateTime.Now; DataTable dt = new DataTable(); myClass myclass = new myClass(); if (title.Length == 0 || content.Length == 0) { Response.Write("<script>alert('输入不能为空!')</script>"); } else { string sql = "select * from LogClass where classfyname='" + classr + "'and logowner ='" + id + "'"; dt = myclass.JudgeIor(sql); int classid = Convert.ToInt32(dt.Rows[0][0].ToString()); string simplify = System.Text.RegularExpressions.Regex.Replace(content, @"<[///!]*?[^<>]*?>", "").Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", "").Replace(" ", ""); if (simplify.Length > 50) { simplify = simplify.Substring(0, 50) + "...."; } sql = "insert into Log(title,logtext,author,logtime,logpower,_classfyid,draft,simplify) values('" + title + "','" + content + "','" + id + "','" + now + "','" + power + "','" + classid + "','" + draft + "','" + simplify + "')"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('保存成功!')</script>"); Server.Transfer("Log.aspx"); } else { Response.Write("<script>alert('保存失败!')</script>"); Server.Transfer("Default.aspx"); } } }
//图片上传并将图片重命名 protected void btnUp_Click(object sender, EventArgs e) { myClass myclass = new myClass(); int albumid = Convert.ToInt32(Request.QueryString["albumid"]); if (fup.PostedFile.FileName == "") { Response.Write("<script>alert('请选择文件!')</script>"); } else { //string filepath = fup.PostedFile.FileName; //判断文件格式类型 if (!IsAllowedExtension(fup)) { Response.Write("<script>alert('文件类型不正确!')</script>"); } if (IsAllowedExtension(fup) == true) { //获取文件路径名字并把绝对路径改成相对路径存到数据库 //修改相册封面 string filepath = fup.PostedFile.FileName; string filename = filepath.Substring(filepath.LastIndexOf("\\") + 1); string serverpath = Server.MapPath("picture/") + filename; fup.PostedFile.SaveAs(serverpath); serverpath = "picture/" + filename; DateTime now = DateTime.Now; string sql = "update Album set interface='" + serverpath + "' where albumid='" + albumid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('修改成功!')</script>"); Server.Transfer("EditorAlbum.aspx"); } else { Response.Write("<script>alert('修改失败!')</script>"); } } else { Response.Write("<script>alert('请上传图片!')</script>"); } } }
protected void btnSub_Click1(object sender, EventArgs e) { //修改草稿箱 int id = Convert.ToInt32(Session["id"].ToString()); int logid = Convert.ToInt32(Session["drafttextid"].ToString()); string title = txtTitle.Text; string content = Request.Form["content1"]; string classr = dropClass.SelectedValue; string power = dropPower.SelectedValue; DateTime now = DateTime.Now; DataTable dt = new DataTable(); myClass myclass = new myClass(); if (title.Length == 0 || content.Length == 0) { Response.Write("<script>alert('输入不能为空!')</script>"); } else { string sql = "select * from LogClass where classfyname='" + classr + "'and logowner ='" + id + "'"; dt = myclass.JudgeIor(sql); int classid = Convert.ToInt16(dt.Rows[0][0].ToString()); sql = "update Log set title='" + title + "',logtext='" + content + "',logtime='" + now + "',draft='1',logpower='" + power + "', _classfyid='" + classid + "' where logid = '" + logid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('修改成功!')</script>"); Server.Transfer("Draft.aspx"); } else { Response.Write("<script>alert('修改失败!')</script>"); Server.Transfer("DraftEditor.aspx"); } } }
protected void rptToday_ItemCommand(object source, RepeaterCommandEventArgs e) { myClass myclass = new myClass(); if (e.CommandName == "Delete") { int visiid = Convert.ToInt32(e.CommandArgument.ToString()); string sql = "delete from Visitor where visiid='" + visiid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('删除成功!');location='Visitor.aspx'</script>"); } } }
protected void btnSub_Click(object sender, EventArgs e) { int userid; myClass myclass = new myClass(); if (Session["Friendid"] != null) { userid = Convert.ToInt32(Session["Friendid"].ToString()); } else { userid = Convert.ToInt32(Session["id"].ToString()); } int id = Convert.ToInt32(Session["id"].ToString()); string massage = txtMassage.Text; DateTime now = DateTime.Now; if (massage.Length == 0) { Response.Write("<script>alert('输入不能为空!')</script>"); } else { string name = myclass.RerdName(id); string sculpture = "../" + myclass.RerdSculpture(userid); //string sql = "insert into Massage (massageowner,massageuser,publishtime,massagetext,ownername,ownersculpture) values ('" + id + "','" + userid + "','" + now + "','" + massage + "'.'" + name + "','" + sculpture + "')"; string sql = "insert into Massage (massageowner,massageuser,publishtime,massagetext,ownername,ownersculpture) values('" + userid + "','" + id + "','" + now + "','" + massage + "','" + name + "','" + sculpture + "')"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('留言成功!');location='Message.aspx'</script>"); } else { Response.Write("<script>alert('留言失败!')</script>"); } } }
protected void btnAuthority_Click(object sender, EventArgs e) { myClass myclass = new myClass(); int albumid = Convert.ToInt32(Request.QueryString["albumid"]); string authority = rdlAuthority.SelectedValue; string sql = "update Album set authority='" + authority + "'where albumid = '" + albumid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('修改成功!')</script>"); } else { Response.Write("<script>alert('修改失败!')</script>"); } }
protected void btnName_Click(object sender, EventArgs e) { myClass myclass = new myClass(); int albumid = Convert.ToInt32(Request.QueryString["albumid"]); string name = changename.Text; if (name.Length == 0) { Response.Write("<script>alert('输入不能为空!')</script>"); } { string sql = "update Album set albumname='" + name + "' where albumid='" + albumid + "'"; int flag = myclass.DataSQL(sql); if (flag == 1) { Response.Write("<script>alert('修改成功!')</script>"); } Server.Transfer("EditorAlbum.aspx"); } }
protected void rptState_ItemCommand(object source, RepeaterCommandEventArgs e) { myClass myclass = new myClass(); if (e.CommandName == "Anwser") { int id = Convert.ToInt32(Session["id"].ToString()); int stateid = Convert.ToInt32(e.CommandArgument.ToString()); string sql = "select * from State where stateid= '" + stateid + "'"; DataTable dt = new DataTable(); dt = myclass.JudgeIor(sql); int staterid = Convert.ToInt32(dt.Rows[0][1].ToString()); string statername = myclass.RerdName(staterid); string name = myclass.RerdName(id); DateTime now = DateTime.Now; string txt = ((TextBox)e.Item.FindControl("txtAnwserCom")).Text; if (txt.Length == 0) { Response.Write("<script>alert('输入不能为空!')</script>"); } else { //判断是否要添加到相册/日志 int flag, stateflag; string locks = "上传"; if (dt.Rows[0][3].ToString().Length != 0) { //发表说说不需要同步评论 stateflag = 1; sql = "insert into StateComment (_stateid,_stater,_stateowner,_statetime,_statement,_statername,_staterownername) values('" + stateid + "','" + id + "','" + staterid + "','" + now + "','" + txt + "','" + name + "','" + statername + "')"; flag = myclass.DataSQL(sql); } else if (dt.Rows[0][8].ToString().Contains(locks)) { //上传相册同步评论到相册 int photoid = Convert.ToInt32(dt.Rows[0][11].ToString()); string sculpture = myclass.RerdSculpture(id); sql = "insert into StateComment (_stateid,_stater,_stateowner,_statetime,_statement,_photoid,_statername,_staterownername) values('" + stateid + "','" + id + "','" + staterid + "','" + now + "','" + txt + "','" + photoid + "','" + name + "','" + statername + "')"; flag = myclass.DataSQL(sql); string replyclass = "photo"; sql = "insert into Reply (replytime,replyer,replyowner,replytext,replyername,replyownername,replyownerscu,replyerscu,replyclass,classid) values('" + now + "','" + id + "','" + id + "','" + txt + "','" + name + "','" + name + "','" + sculpture + "','" + sculpture + "','" + replyclass + "','" + photoid + "')"; stateflag = myclass.DataSQL(sql); } else { //上传相册同步评论到日志 int logid = Convert.ToInt32(dt.Rows[0][10].ToString()); string sculpture = myclass.RerdSculpture(id); sql = "insert into StateComment (_stateid,_stater,_stateowner,_statetime,_statement,_logid,_statername,_staterownername) values('" + stateid + "','" + id + "','" + staterid + "','" + now + "','" + txt + "','" + logid + "','" + name + "','" + statername + "')"; flag = myclass.DataSQL(sql); string replyclass = "log"; sql = "insert into Reply (replytime,replyer,replyowner,replytext,replyername,replyownername,replyownerscu,replyerscu,replyclass,classid) values('" + now + "','" + id + "','" + id + "','" + txt + "','" + name + "','" + name + "','" + sculpture + "','" + sculpture + "','" + replyclass + "','" + logid + "')"; stateflag = myclass.DataSQL(sql); } if (flag == 1) { Response.Write("<script>alert('回复成功!');location='Home.aspx'</script>"); } } } if (e.CommandName == "Like") { int id = Convert.ToInt32(Session["id"].ToString()); int stateid = Convert.ToInt32(e.CommandArgument.ToString()); string locks = ',' + Convert.ToString(id) + ','; string sql = "select * from State where stateid = '" + stateid + "'"; DataTable dt = new DataTable(); dt = myclass.JudgeIor(sql); string like = dt.Rows[0][6].ToString(); if (like.Contains(locks)) { Response.Write("<script>alert('已经点过赞了哟!');location='Home.aspx'</script>"); } else { like = dt.Rows[0][6].ToString() + Convert.ToString(id) + ','; int count = Convert.ToInt32(dt.Rows[0][7].ToString()) + 1; sql = "update State set statelike ='" + like + "',statelikecount = '" + count + "' where stateid = '" + stateid + "'"; int flag = myclass.DataSQL(sql); Server.Transfer("Home.aspx"); } } if (e.CommandName == "Jump") { int friendid = Convert.ToInt32(e.CommandArgument.ToString()); Session["Friendid"] = friendid.ToString(); Response.Write("<script>window.location='Person/Person.aspx'</script>"); } /* if (e.CommandName == "DetailLog") * { * int friendid = Convert.ToInt32(e.CommandArgument.ToString()); * Session["Friendid"] = friendid.ToString(); * } * * if (e.CommandName == "DetailPhoto") * { * int friendid = Convert.ToInt32(e.CommandArgument.ToString()); * Session["Friendid"] = friendid.ToString(); * }*/ }
protected void btnRegister_Click1(object sender, EventArgs e) { myClass myclass = new myClass(); string pwd = NewPwd.Text; string repwd = reNewPwd.Text; string email = Email.Text; string phone = Phone.Text; string name = Name.Text; string sculpture = "Album/picture/timg.jpg"; string sex = rdlSex.SelectedValue; //string province = if (pwd.Length == 0 || repwd.Length == 0 || email.Length == 0 || phone.Length == 0 || name.Length == 0 || sex.Length == 0) { Response.Write("<script>alert('输入不能为空!')</script>"); } else { string sql1 = "select * from UserList where phone='" + phone + "'"; string sql2 = "select * from UserList where email='" + email + "'"; string sql4 = "select * from UserList where phone='" + phone + "'"; int count1 = (myclass.JudgeIor(sql1)).Rows.Count; int count2 = (myclass.JudgeIor(sql2)).Rows.Count; if (Session["CheckCode"] != null) { string checkcode = Session["CheckCode"].ToString(); if (TextBox1.Text != checkcode) { Response.Write("<script>alert('验证码错误!')</script>"); } else if (String.Compare(pwd, repwd) != 0) { Response.Write("<script>alert('前面密码两次错误!')</script>"); } else if (count1 > 0) { Response.Write("<script>alert('手机号码已被绑定!')</script>"); } else if (count2 > 0) { Response.Write("<script>alert('邮箱已被验证!')</script>"); } else { pwd = MD5(pwd); int count = 1, rad = 0; while (count > 0) { Int32 x = 1000000; Random Random = new System.Random(); rad = Random.Next(x, x * 10); string sql = "select * from UserList where id = '" + rad + "'"; count = myclass.JudgeAcc(sql); } string sql3 = "insert into UserList (id,name,pwd,email,phone,sculpture,sex) values('" + rad + "','" + name + "','" + pwd + "','" + email + "','" + phone + "','" + sculpture + "','" + sex + "')"; int flag = myclass.DataSQL(sql3); if (flag != 1) { Response.Write("<script>alert('注册失败!')</script>"); } else { DataTable dt = new DataTable(); dt = myclass.JudgeIor(sql4); string id = dt.Rows[0][0].ToString(); string sql = "insert into LogClass (classfyname,logowner) values('默认分类','" + id + "')"; myclass.DataSQL(sql); Session["id"] = id; Session["name"] = name; Response.Write("<script>alert('注册成功!');location='Register/RegisterSuccess.aspx'</script>"); } } } } }