protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if(!string.IsNullOrEmpty(Request.QueryString["id"])) { myArticle = ArticleManage.GetItem(Convert.ToInt32(Request.QueryString["id"])); if (string.IsNullOrEmpty(myArticle.art_title)) { Response.Write("<script type='text/javascript'>alert('错误的链接!');document.location.href='ArticleMgmt.aspx'</script>"); } else { this.ArticleClassDDL1.LoadTree(); this.ArticleClassDDL1.InnerDropDownListTree.Items.FindByValue(myArticle.ac_id.ToString()).Selected = true; this.tbxTitle.Text = myArticle.art_title; this.tbxAuthor.Text = myArticle.art_author; this.tbxFrom.Text = myArticle.art_from; this.tbxImage.Text = myArticle.art_image; CKEditor1.Text = myArticle.art_content; this.txtDescription.Value = myArticle.art_description; this.cbxTop.Checked = myArticle.istop; this.cbxCommend.Checked = myArticle.iscommend; Page.Title = myArticle.art_title; } } else { Response.Write("<script language=JavaScript>alert('错误的链接!');document.location.href='ArticleMgmt.aspx'</script>"); } } }
public static Article GetItem(int art_id) { Article myArticle = new Article(); string sql = @"SELECT * FROM t_article WHERE art_id = ?art_id;"; MySqlParameter[] parms = { new MySqlParameter("?art_id", MySqlDbType.Int32) }; parms[0].Value = art_id; MySqlDataReader myReader = DbHelper.ExecuteDataReader(sql,parms); if (myReader.HasRows) { if (myReader.Read()) { myArticle = FillDataRecord(myReader); } } myReader.Close(); return myArticle; }
protected void btnAdd_Click(object sender, EventArgs e) { if (!ArticleClassManage.IsLeafNode(Convert.ToInt32(ArticleClassDDL1.CurrentValue))) { ClientScript.RegisterClientScriptBlock(this.GetType(),"err", "<script >alert('文章只能添加到子分类,请选择一个正确的分类!');</script>"); } else { Article myArticle = new Article(); myArticle.art_title = this.tbxTitle.Text; myArticle.art_author = this.tbxAuthor.Text; myArticle.art_from = this.tbxFrom.Text; myArticle.art_content = CKEditor1.Text; myArticle.art_click = 0; myArticle.art_date = DateTime.Now; myArticle.art_description = this.txtDescription.Value; myArticle.istop = this.cbxTop.Checked; myArticle.iscommend = this.cbxCommend.Checked; myArticle.ac_id = Convert.ToInt32(ArticleClassDDL1.CurrentValue); if (string.IsNullOrEmpty(this.tbxImage.Text) || this.tbxImage.Text == " ") { string fckStr = CKEditor1.Text; MatchCollection matchs = Regex.Matches(fckStr, @"<img[^src]*src=""[^http\://]*(?<src>[^""]*?)""", RegexOptions.IgnoreCase); foreach (Match m in matchs) { myArticle.art_image = m.Groups["src"].Value.ToString(); break; } if (string.IsNullOrEmpty(myArticle.art_image)) { myArticle.art_image = " "; } } else { myArticle.art_image = this.tbxImage.Text.Trim(); } if (ArticleManage.Insert(myArticle)) { Response.Write("<script>alert('文章添加成功!!!');window.location.href=document.URL;</script>"); } else { this.lblError.Visible = true; } } }
public static bool Insert(Article myArticle) { if (!string.IsNullOrEmpty(myArticle.art_title) && !string.IsNullOrEmpty(myArticle.art_content) && myArticle.ac_id > 0) { myArticle.art_date = DateTime.Now; return ArticleService.Insert(myArticle); } else { return false; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Master.SetSiteProperty(); string artID = null; try { artID = Request.QueryString["id"].ToString(); } catch (Exception ex) { } Article myArticle = new Article(); if(BaseCommon.ValidQueryString(artID)) { ArticleManage.Update(Convert.ToInt32(artID)); myArticle = ArticleManage.GetItem(Convert.ToInt32(artID)); acnav = ArticleClassManage.ArticleClassNav(myArticle.ac_id, acnav); Page.Title = myArticle.art_title; HtmlMeta keywords = (HtmlMeta)Master.FindControl("keywords"); HtmlMeta Description = (HtmlMeta)Master.FindControl("Description"); keywords.Attributes["content"] = keywords.Attributes["content"] + "," + myArticle.art_title; Description.Attributes["content"] = Description.Attributes["content"] + "," + myArticle.art_description; this.litTitle.Text = myArticle.art_title; this.lblDate.Text = myArticle.art_date.ToString(); this.lblAuthor.Text = myArticle.art_author; this.lblSource.Text = myArticle.art_from; this.lblBrowse.Text = myArticle.art_click.ToString(); this.lblContent.Text = myArticle.art_content; } else { Response.Write("错误的连接!"); } } }
private static Article FillDataRecord(IDataRecord myDataRecord) { Article myArticle = new Article(); myArticle.art_id = myDataRecord.GetInt32(myDataRecord.GetOrdinal("art_id")); myArticle.art_title = myDataRecord.GetString(myDataRecord.GetOrdinal("art_title")); myArticle.art_content = myDataRecord.GetString(myDataRecord.GetOrdinal("art_content")); myArticle.art_date = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("art_date")); myArticle.ac_id = myDataRecord.GetInt32(myDataRecord.GetOrdinal("ac_id")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("art_author"))) { myArticle.art_author = myDataRecord.GetString(myDataRecord.GetOrdinal("art_author")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("art_from"))) { myArticle.art_from = myDataRecord.GetString(myDataRecord.GetOrdinal("art_from")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("art_description"))) { myArticle.art_description = myDataRecord.GetString(myDataRecord.GetOrdinal("art_description")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("art_image"))) { myArticle.art_image = myDataRecord.GetString(myDataRecord.GetOrdinal("art_image")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("art_click"))) { myArticle.art_click = myDataRecord.GetInt32(myDataRecord.GetOrdinal("art_click")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("istop"))) { myArticle.istop = myDataRecord.GetBoolean(myDataRecord.GetOrdinal("istop")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("iscommend"))) { myArticle.iscommend = myDataRecord.GetBoolean(myDataRecord.GetOrdinal("iscommend")); } return myArticle; }
public static bool Update(Article myArticle) { int result = 0; string sql = @"UPDATE t_article SET art_title = ?art_title, art_author = ?art_author, art_from = ?art_from, art_content = ?art_content, art_description = ?art_description, art_image = ?art_image, art_date = ?art_date, istop = ?istop, iscommend = ?iscommend, ac_id = ?ac_id WHERE art_id = ?art_id;"; MySqlParameter[] parms = { new MySqlParameter("?art_title",MySqlDbType.VarChar), new MySqlParameter("?art_author",MySqlDbType.VarChar), new MySqlParameter("?art_from",MySqlDbType.VarChar), new MySqlParameter("?art_content",MySqlDbType.Text), new MySqlParameter("?art_description",MySqlDbType.Text), new MySqlParameter("?art_image",MySqlDbType.VarChar), new MySqlParameter("?art_date",MySqlDbType.DateTime), new MySqlParameter("?istop", MySqlDbType.Bit), new MySqlParameter("?iscommend", MySqlDbType.Bit), new MySqlParameter("?ac_id", MySqlDbType.Int32), new MySqlParameter("?art_id", MySqlDbType.Int32) }; parms[0].Value = myArticle.art_title; parms[1].Value = myArticle.art_author; parms[2].Value = myArticle.art_from; parms[3].Value = myArticle.art_content; parms[4].Value = myArticle.art_description; parms[5].Value = myArticle.art_image; parms[6].Value = myArticle.art_date; parms[7].Value = myArticle.istop; parms[8].Value = myArticle.iscommend; parms[9].Value = myArticle.ac_id; parms[10].Value = myArticle.art_id; result = DbHelper.ExecuteNonQuery(sql, parms); return result > 0; }
public static bool Insert(Article myArticle) { int result = 0; string sql = @"INSERT INTO t_article ( art_title, art_author, art_from, art_content, art_description, art_image, art_date, art_click, istop, iscommend, ac_id ) VALUES ( ?art_title, ?art_author, ?art_from, ?art_content, ?art_description, ?art_image, ?art_date, ?art_click, ?istop, ?iscommend, ?ac_id )"; MySqlParameter[] parms = { new MySqlParameter("?art_title", MySqlDbType.VarChar), new MySqlParameter("?art_author", MySqlDbType.VarChar), new MySqlParameter("?art_from", MySqlDbType.VarChar), new MySqlParameter("?art_content", MySqlDbType.Text), new MySqlParameter("?art_description", MySqlDbType.Text), new MySqlParameter("?art_image", MySqlDbType.VarChar), new MySqlParameter("?art_date", MySqlDbType.DateTime), new MySqlParameter("?art_click", MySqlDbType.Int32), new MySqlParameter("?istop", MySqlDbType.Bit), new MySqlParameter("?iscommend", MySqlDbType.Bit), new MySqlParameter("?ac_id", MySqlDbType.Int32) }; parms[0].Value = myArticle.art_title; parms[1].Value = myArticle.art_author; parms[2].Value = myArticle.art_from; parms[3].Value = myArticle.art_content; parms[4].Value = myArticle.art_description; parms[5].Value = myArticle.art_image; parms[6].Value = myArticle.art_date; parms[7].Value = myArticle.art_click; parms[8].Value = myArticle.istop; parms[9].Value = myArticle.iscommend; parms[10].Value = myArticle.ac_id; result = DbHelper.ExecuteNonQuery(sql, parms); return result > 0; }