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;
}
