private void BindData()
{
int ArticleID = Int32.Parse(Request.QueryString["ArticleID"].ToString());
string SqlStr = "select Title,ViceTitle,TitleImage,ArtSource,ArtContent,ReadCount,PostTime from Article where ArticleID = @ArticleID";
string SqlUpdate = "Update Article set ReadCount=ReadCount+1 where ArticleID=@ArticleID";
SqlParameter pArticleID = new SqlParameter("@ArticleID",SqlDbType.Int,4);
pArticleID.Value = ArticleID;
SqlParameter[] parms = new SqlParameter[]
{
pArticleID
};
try
{
SqlDataReader dr = SQLHelper.ExecuteReader(SQLHelper.CONN_STRING,CommandType.Text,SqlStr,parms);
while(dr.Read())
{
Lb_Title.Text = dr["Title"].ToString();
if(dr["ArtSource"].ToString().Length>0)
Lb_ArtSource.Text = "来源:" + dr["ArtSource"].ToString();
else
Lb_ArtSource.Visible = false;
if(dr["TitleImage"].ToString().Trim() !="" )
{
Image1.ImageUrl = dr["TitleImage"].ToString();
}
else
{
Image1.Visible = false;
}
try
{
Lb_PostTime.Text = "发布时间:" + Convert.ToDateTime(dr["PostTime"].ToString()).ToShortDateString();
}
catch
{
Lb_PostTime.Text = "";
}
Lb_ReadCount.Text = "浏览次数:" + Convert.ToString(Int32.Parse(dr["ReadCount"].ToString().Length==0?"0":dr["ReadCount"].ToString())+1) + "次";
Lb_Content.Text = dr["ArtContent"].ToString();
}
dr.Close();
SQLHelper.ExecuteNonQuery(SQLHelper.CONN_STRING,CommandType.Text,SqlUpdate,parms);
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
}