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