예제 #1
0
        protected override void Page_Show()
        {
            pagetitle = "投递文章";
            UserInfo userinfo = GetUserInfo();
            if (userinfo == null)
            {
                ShowError("投递文章", "请登录后再投递文章,谢谢~", "", "login.aspx");
            }
            columnlist = Columns.GetColumnCollection();
            if (YRequest.IsPost())
            {
                int columnid = YRequest.GetInt("columnid", 0);
                string title = Utils.RemoveHtml(YRequest.GetString("title"));
                string summary = Utils.RemoveHtml(YRequest.GetString("summary"));
                string content = Utils.RemoveUnsafeHtml(YRequest.GetString("content"));

                ArticleInfo articleinfo = new ArticleInfo();
                articleinfo.Columnid = columnid;
                articleinfo.Title = title;
                //articleinfo.Highlight = ddlHightlight.SelectedValue;
                articleinfo.Summary = summary.Length > 160 ? summary.Substring(0, 159) : summary;
                articleinfo.Content = content;
                articleinfo.Postdate = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
                articleinfo.Uid = userinfo.Uid;
                articleinfo.Username = userinfo.Username;
                Articles.CreateArticle(articleinfo);
                Articles.RemoveArtilceCache();
                ShowMsg("投递文章", "发布成功,跳转到栏目列表.", "", string.Format("showcolumn-{0}-1.aspx", articleinfo.Columnid));
            }
        }
예제 #2
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            ArticleInfo articleinfo = new ArticleInfo();
            articleinfo.Columnid = Convert.ToInt32(ddlColumns.SelectedValue);
            articleinfo.Title = tbxTitle.Text.Trim();
            articleinfo.Highlight = ddlHightlight.SelectedValue;
            articleinfo.Summary = tbxSummary.Text.TrimEnd();
            articleinfo.Content = tbxContent.Text.TrimEnd();
            articleinfo.Postdate = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
            articleinfo.Recommend = Convert.ToInt32(ckbxRecommand.Checked);
            articleinfo.Uid = userinfo.Uid;
            articleinfo.Username = userinfo.Username;
            if (articleid > 0)
            {
                articleinfo.Articleid = articleid;
                Articles.EditArticle(articleinfo);
            }
            else
            {
                Articles.CreateArticle(articleinfo);
            }
            Articles.RemoveArtilceCache();

            ShowMsg("���¹���", "�����ύ�ɹ�.", "", "articlelist.aspx?cid=" + articleinfo.Columnid, true);
            //Response.Redirect("articlelist.aspx?cid=" + articleinfo.Columnid);
        }
예제 #3
0
        protected override void Page_Show()
        {
            int articleid = YRequest.GetQueryInt("id", 1);
            articleinfo = Articles.GetArticleInfo(articleid);
            if (articleinfo == null)
            {
                ShowError("查看文章", "错误,不存在的文章!", "", "");
            }
            pagetitle = string.Format("{0} - {1}", Natsuhime.Web.Utils.RemoveHtml(articleinfo.Title), articleinfo.Columnname);

            int commentpageid=YRequest.GetQueryInt("commentpageid", 1);
            commentlist = Comments.GetCommentCollection(articleid, 8, commentpageid);
            int commentpagecount = Comments.GetCommentCollectionPageCount(articleid, 8);
            commentcounthtml = config.Urlrewrite == 1 ? Natsuhime.Web.Utils.GetStaticPageNumbersHtml(commentpageid, commentpagecount, string.Format("showarticle-{0}", articleid), ".aspx", 8) : Utils.GetPageNumbersHtml(commentpageid, commentpagecount, string.Format("showarticle.aspx?id={0}", articleid), 8, "commentpageid", "");
        }
예제 #4
0
 protected void Page_Load(object sender, EventArgs e)
 {
     articleid = Convert.ToInt32(Request.QueryString["articleid"]);
     articleinfo = Articles.GetArticleInfo(articleid);
     if (articleinfo != null)
     {
         lbMessage.Text = string.Format("ȷ��ɾ������: {0} ��?", articleinfo.Title);
     }
     else
     {
         lbMessage.Text = "�����ڴ�����,�뷵��!";
         btnYes.Visible = false;
         btnCancel.Visible = false;
     }
 }
예제 #5
0
 public void CreateArticle(ArticleInfo articleinfo)
 {
     DbParameter[] prams =
     {
         DbHelper.MakeInParam("@title", DbType.String, 100,articleinfo.Title),
         DbHelper.MakeInParam("@columnid", DbType.Int32, 4,articleinfo.Columnid),
         DbHelper.MakeInParam("@highlight", DbType.String, 20,articleinfo.Highlight),
         DbHelper.MakeInParam("@summary", DbType.String, 160,articleinfo.Summary),
         DbHelper.MakeInParam("@content", DbType.String, 5000,articleinfo.Content),
         DbHelper.MakeInParam("@postdate", DbType.DateTime, 8,articleinfo.Postdate),
         DbHelper.MakeInParam("@uid", DbType.Int32, 4,articleinfo.Uid),
         DbHelper.MakeInParam("@username", DbType.String, 20,articleinfo.Username),
         DbHelper.MakeInParam("@recommend", DbType.Int32, 4,articleinfo.Recommend)
     };
     DbHelper.ExecuteNonQuery(CommandType.Text, "INSERT INTO wy_articles(title,columnid,highlight,summary,content,postdate,uid,username,recommend) VALUES(@title,@columnid,@highlight,@summary,@content,@postdate,@uid,@username,@recommend)", prams);
 }
예제 #6
0
 public void EditArticle(ArticleInfo articleinfo)
 {
     DbParameter[] prams =
     {
         DbHelper.MakeInParam("@title", DbType.String, 100,articleinfo.Title),
         DbHelper.MakeInParam("@columnid", DbType.Int32, 4,articleinfo.Columnid),
         DbHelper.MakeInParam("@highlight", DbType.String, 20,articleinfo.Highlight),
         DbHelper.MakeInParam("@summary", DbType.String, 160,articleinfo.Summary),
         DbHelper.MakeInParam("@content", DbType.String, 5000,articleinfo.Content),
         DbHelper.MakeInParam("@postdate", DbType.DateTime, 8,articleinfo.Postdate),
         DbHelper.MakeInParam("@uid", DbType.Int32, 4,articleinfo.Uid),
         DbHelper.MakeInParam("@username", DbType.String, 20,articleinfo.Username),
         DbHelper.MakeInParam("@articleid", DbType.Int32, 4,articleinfo.Articleid),
         DbHelper.MakeInParam("@recommend", DbType.Int32, 4,articleinfo.Recommend)
     };
     DbHelper.ExecuteNonQuery(CommandType.Text, "UPDATE wy_articles SET title=@title,columnid=@columnid,highlight=@highlight,summary=@summary,content=@content,postdate=@postdate,uid=@uid,username=@username,recommend=@recommend WHERE articleid=@articleid", prams);
 }
예제 #7
0
 public void EditArticle(ArticleInfo articleinfo)
 {
     DbParameter[] prams =
     {
         DbHelper.MakeInParam("?title", (DbType)MySqlDbType.String, 100,articleinfo.Title),
         DbHelper.MakeInParam("?columnid", (DbType)MySqlDbType.Int32, 4,articleinfo.Columnid),
         DbHelper.MakeInParam("?highlight", (DbType)MySqlDbType.String, 20,articleinfo.Highlight),
         DbHelper.MakeInParam("?summary", (DbType)MySqlDbType.String, 160,articleinfo.Summary),
         DbHelper.MakeInParam("?content", (DbType)MySqlDbType.String, 5000,articleinfo.Content),
         DbHelper.MakeInParam("?postdate", (DbType)MySqlDbType.Datetime, 8,articleinfo.Postdate),
         DbHelper.MakeInParam("?uid", (DbType)MySqlDbType.Int32, 4,articleinfo.Uid),
         DbHelper.MakeInParam("?username", (DbType)MySqlDbType.String, 20,articleinfo.Username),
         DbHelper.MakeInParam("?articleid", (DbType)MySqlDbType.Int32, 4,articleinfo.Articleid),
         DbHelper.MakeInParam("?recommend", (DbType)MySqlDbType.Int32, 4,articleinfo.Recommend)
     };
     DbHelper.ExecuteNonQuery(CommandType.Text, "UPDATE wy_articles SET title=?title,columnid=?columnid,highlight=?highlight,summary=?summary,content=?content,postdate=?postdate,uid=?uid,username=?username,recommend=?recommend WHERE articleid=?articleid", prams);
 }
예제 #8
0
 /// <summary>
 /// 将DataReader的Article转换为ArticleInfo泛型列表
 /// </summary>
 /// <param name="reader"></param>
 /// <returns></returns>
 private static ArticleInfo DataReader2ArticleInfo(IDataReader reader)
 {
     ArticleInfo info = new ArticleInfo();
     info.Articleid = Convert.ToInt32(reader["articleid"]);
     info.Columnid = Convert.ToInt32(reader["columnid"]);
     info.Title = reader["title"].ToString();
     info.Badcount = Convert.ToInt32(reader["badcount"]);
     info.Goodcount = Convert.ToInt32(reader["goodcount"]);
     info.Commentcount = Convert.ToInt32(reader["commentcount"]);
     info.Viewcount = Convert.ToInt32(reader["viewcount"]);
     info.Sort = Convert.ToInt32(reader["sort"]);
     info.Highlight = reader["highlight"].ToString();
     info.Summary = reader["summary"].ToString();
     info.Content = reader["content"].ToString();
     info.Image = reader["image"].ToString();
     info.Uid = Convert.ToInt32(reader["uid"]);
     info.Username = reader["username"].ToString();
     info.Ip = reader["ip"].ToString();
     info.Postdate = Convert.ToDateTime(reader["postdate"]).ToString("yyyy-MM-dd");
     info.Del = Convert.ToInt32(reader["del"]);
     info.Recommend = Convert.ToInt32(reader["recommend"]);
     //高亮主题
     if (info.Highlight != "")
     {
         info.Title = string.Format("<span style=\"{0}\">{1}</span>", info.Highlight, info.Title);
     }
     //文章的栏目前缀
     if (info.Columnid > 0)
     {
         info.Columnname = Columns.GetColumnName(info.Columnid);
     }
     else
     {
         info.Columnname = "";
     }
     return info;
 }
예제 #9
0
 /// <summary>
 /// 编辑文章
 /// </summary>
 /// <param name="articleinfo"></param>
 public static void EditArticle(ArticleInfo articleinfo)
 {
     DatabaseProvider.GetInstance().EditArticle(articleinfo);
 }
예제 #10
0
 /// <summary>
 /// 发布新文章
 /// </summary>
 /// <param name="articleinfo"></param>
 public static void CreateArticle(ArticleInfo articleinfo)
 {
     DatabaseProvider.GetInstance().CreateArticle(articleinfo);
 }
예제 #11
0
 /// <summary>
 /// 取得文章内容
 /// </summary>
 /// <param name="articleid">文章id</param>
 /// <returns>AritlceInfo</returns>
 public static ArticleInfo GetArticleInfo(int articleid)
 {
     ArticleInfo info = new ArticleInfo();
     IDataReader reader = DatabaseProvider.GetInstance().GetArticleInfo(articleid);
     if (reader.Read())
     {
         info = DataReader2ArticleInfo(reader);
     }
     else
     {
         info = null;
     }
     reader.Close();
     return info;
 }