public void LoadReply() { if (Request.QueryString["DynamicID"] == null) { return; } Model.Dynamic dynamic = BLL.DynamicBll.GetDynamicByID(Request.QueryString["DynamicID"]); var list = from r in BLL.ReplyBll.GetReplyByDynamicID(dynamic.DynamicID) join u in BLL.UserBll.GetUserList() on r.UserNum equals u.UserNum join p in BLL.PictureBll.GetPictureList() on u.UserNum equals p.PictureNum select new { UserNum = u.UserNum, UserName = u.UserName, Remark = u.Remark, PicturesPath = p.PicturesPath, ReplyContent = r.ReplyContent, PublishDate = r.PublishDate }; dgReplyList.DataSource = list.ToList(); dgReplyList.DataBind(); }
protected void imgPublishUserHead_Click(object sender, ImageClickEventArgs e) { Model.Dynamic dynamic = BLL.DynamicBll.GetDynamicByID(Request.QueryString["DynamicID"]); if (Session["LoginUser"] != null && dynamic.UserNum == (Session["LoginUser"] as Model.User).UserNum) { Response.Redirect("UserInfo.aspx"); } else { Response.Redirect("OtherUserInfo.html?" + dynamic.UserNum); } }
public static int InsertDynamicAndPic(Model.Dynamic dynamic, List <Model.Picture> picList) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConn"].ConnectionString)) { conn.Open(); SqlTransaction transaction = conn.BeginTransaction(); try { string strSql = "insert into [Dynamic] values(@DynamicID,@DynamicTitle,@DynamicContent,@SectionID,@PublishDate,@UserNum,@ReadCount,@State)"; SqlParameter[] p = { new SqlParameter("@DynamicID", dynamic.DynamicID), new SqlParameter("@DynamicTitle", dynamic.DynamicTitle), new SqlParameter("@DynamicContent", dynamic.DynamicContent), new SqlParameter("@SectionID", dynamic.SectionID), new SqlParameter("@PublishDate", dynamic.PublishDate), new SqlParameter("@UserNum", dynamic.UserNum), new SqlParameter("@ReadCount", dynamic.ReadCount), new SqlParameter("@State", dynamic.State) }; SqlCommand cmd = new SqlCommand(strSql, conn); cmd.Parameters.AddRange(p); cmd.Transaction = transaction; cmd.ExecuteNonQuery(); foreach (Model.Picture item in picList) { strSql = "insert into [Picture] values(@PicturesPath,@PictureNum,@State)"; SqlParameter[] parameter = { new SqlParameter("@PictureNum", item.PictureNum), new SqlParameter("@PicturesPath", item.PicturesPath), new SqlParameter("@State", item.State) }; cmd.CommandText = strSql; cmd.Parameters.Clear(); cmd.Parameters.AddRange(parameter); cmd.Transaction = transaction; cmd.ExecuteNonQuery(); } transaction.Commit(); return(1); } catch (Exception ex) { transaction.Rollback(); return(0); } finally { conn.Close(); } } }
public void LoadDynamicInfo() { if (Request.QueryString["DynamicID"] == null) { return; } Model.Dynamic dynamic = BLL.DynamicBll.GetDynamicByID(Request.QueryString["DynamicID"] as string); if (dynamic == null) { return; } Model.User user = BLL.UserBll.GetUserByUserNum(dynamic.UserNum); if (Session["LoginUser"] != null && BLL.FollowBll.CheckIsFollow((Session["LoginUser"] as Model.User).UserNum, dynamic.UserNum)) { btnFollow.Text = "已关注"; } if (Session["LoginUser"] != null && BLL.CollectionBll.CheckIsCollect((Session["LoginUser"] as Model.User).UserNum, dynamic.DynamicID)) { btnCollect.Text = "已收藏"; } if (Session["LoginUser"] != null && (Session["LoginUser"] as Model.User).UserNum == user.UserNum) { btnFollow.Visible = false; } Model.Picture userPic = BLL.PictureBll.GetUserHeadByPicNum(user.UserNum); List <Model.Picture> dynamicPic = BLL.PictureBll.GetPictureByDynamicID(dynamic.DynamicID); lblPublisherName.Text = user.UserName; imgPublishUserHead.ImageUrl = BLL.PictureBll.GetUserHeadByPicNum(user.UserNum).PicturesPath; lblUserRemark.Text = user.Remark; lblPublishDate.Text = dynamic.PublishDate.ToString(); lblDynamicTitle.Text = dynamic.DynamicTitle; lblDynamicContent.Text = " " + dynamic.DynamicContent; foreach (Model.Picture item in dynamicPic) { item.PicturesPath = "Image/UploadImg/watermark/" + item.PicturesPath; } dgPics.DataSource = dynamicPic; dgPics.DataBind(); BLL.DynamicBll.UpdateReadCount(dynamic); }
public static int UpdateReadCount(Model.Dynamic dynamic) { dynamic.ReadCount = dynamic.ReadCount + 1; return(DAL.DBHelper.DataUpdateMethod <Model.Dynamic>(dynamic)); }
public static int InsertDynamicAndPic(Model.Dynamic dynamic, List <Model.Picture> picList) { return(DAL.DynamicDal.InsertDynamicAndPic(dynamic, picList)); }
protected void btnAddNewDynamic_Click1(object sender, EventArgs e) { if (lblGG.Text == "选择话题") { Response.Write("<script>alert('请选择话题!')</script>"); return; } if (string.IsNullOrEmpty(textDynamicTitle.Text)) { Response.Write("<script>alert('请输入帖子标题!')</script>"); textDynamicTitle.Focus(); return; } if (string.IsNullOrEmpty(textDynamicContent.Text)) { Response.Write("<script>alert('请输入帖子内容!')</script>"); textDynamicContent.Focus(); return; } else if (textDynamicContent.Text.Length <= 6) { Response.Write("<script>alert('帖子内容不能少于6位!')</script>"); textDynamicContent.Focus(); return; } string code = textVerCode.Text; HttpCookie htco = Request.Cookies["ImageV"]; string scode = htco.Value.ToString(); if (string.IsNullOrEmpty(code) || textVerCode.Text.Length < 4 || code.ToLower() != scode.ToLower()) { Response.Write("<script>alert('验证码输入不正确!')</script>"); textVerCode.Text = ""; textVerCode.Focus(); return; } Model.Dynamic dynamic = new Model.Dynamic(); dynamic.DynamicID = "dynamic" + DateTime.Now.ToFileTime(); dynamic.DynamicTitle = textDynamicTitle.Text; dynamic.DynamicContent = textDynamicContent.Text; dynamic.PublishDate = DateTime.Now; dynamic.SectionID = BLL.SectionBll.GetSectionByName(lblGG.Text).SectionID; dynamic.UserNum = (Session["LoginUser"] as Model.User).UserNum; List <Model.Picture> picList = new List <Model.Picture>(); List <HttpPostedFile> fileList = Session["DynamicPicFiles"] as List <HttpPostedFile>; if (Session["DynamicPicFiles"] != null) { foreach (HttpPostedFile item in fileList) { Model.Picture pic = new Model.Picture(); pic.PictureNum = dynamic.DynamicID; pic.PicturesPath = DateTime.Now.ToFileTime() + item.FileName.Substring(item.FileName.LastIndexOf(".")); picList.Add(pic); } } if (BLL.DynamicBll.InsertDynamicAndPic(dynamic, picList) > 0) { Response.Write("<script>alert('发表成功!')</script>"); for (int i = 0; i < fileList.Count; i++) { fileList[i].SaveAs(Server.MapPath("Image/UploadImg/") + picList[i].PicturesPath); System.Drawing.Image img = System.Drawing.Image.FromFile(Server.MapPath("Image/UploadImg/") + picList[i].PicturesPath); Graphics g = Graphics.FromImage(img); SolidBrush brush = new SolidBrush(Color.Blue); g.DrawString("@" + (Session["LoginUser"] as Model.User).UserName, new Font("宋体", 13f), brush, 0, 0); img.Save(Server.MapPath("Image/UploadImg/watermark/") + picList[i].PicturesPath); g.Dispose(); img.Dispose(); File.Delete(Server.MapPath("Image/UploadImg/") + picList[i].PicturesPath); } Session["DynamicPicFiles"] = null; } else { Response.Write("<script>alert('发表失败,数据操作错误,请联系管理员!')</script>"); } }