protected void Page_Load(object sender, EventArgs e)
{
// 在此处放置用户代码以初始化页面
string ST_cmd_sql = "select top 10 * from ST_news where ST_n_iscmd=1 order by ST_n_date desc";
string ST_top_sql = "select top 10 * from ST_news order by ST_n_hit desc";
string personindex = "select top 10* from ST_news order by ST_n_id desc";
string TitleClass = "select ST_c_id, ST_c_name from ST_class order by ST_date desc";
DataSet ST_classds = myobj.GetDataSet(TitleClass, "ST_class");
DataSet ST_cmdds = myobj.GetDataSet(ST_cmd_sql, "ST_news");
DataSet ST_topds = myobj.GetDataSet(ST_top_sql, "ST_news");
DataSet mypersonds = myobj.GetDataSet(personindex, "ST_class");
//绑定博客文章类型列表
ClassList.DataSource = new DataView(ST_classds.Tables[0]);
ClassList.DataBind();
//绑定推荐文章列表
CmdList.DataSource = new DataView(ST_cmdds.Tables[0]);
CmdList.DataBind();
//绑定热点文章列表
TopList.DataSource = new DataView(ST_topds.Tables[0]);
TopList.DataBind();
//绑定最新个人最新发表的博客文章
ClassList0.DataSource = new DataView(mypersonds.Tables[0]);
ClassList0.DataBind();
if (Request.QueryString["c_id"] == null)
{
person_BindData();
}
else
{
NewsBlogList_Bind();
}
if (Request.Cookies["colors"] != null)
{
string ST_test = Request.Cookies["colors"].Value;
String[] ST_colorList = ST_test.Split(new[] { ',' });
ST_bgcolor = ST_colorList[0];
ST_tcolor = ST_colorList[1];
}
else
{
ST_bgcolor = "#FFFFFF";
ST_tcolor = "#cccccc";
}
Page.DataBind();
string rd = DateTime.Now.Ticks.ToString();
str = "imgFile/1.jpg?rd=" + rd + "|imgFile/2.jpg?rd=" + rd + "|imgFile/3.jpg?rd=" + rd + "|imgFile/4.jpg?rd=" +
rd + "";
string path = Server.MapPath("./") + "imgFile/LoopId.txt";
loopId = File.ReadAllText(path);
loopId = loopId.Replace(',', '|');
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] == null)
{
Response.Redirect("~/BlogIndex.aspx");
}
string sql = "select * from tb_Blog where UserName='******'";
DataSet mydataset = mydata.GetDataSet(sql, "tb_Blog");
DataRowView rowview = mydataset.Tables["tb_Blog"].DefaultView[0];
ID = rowview["BlogID"].ToString();
this.TextBox2.Text = Session["UserName"].ToString();
string sqlstr = "select * from ST_Class";
SqlConnection mycon = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
SqlCommand mycom = new SqlCommand(sqlstr, mycon);
mycon.Open();
SqlDataReader dr = mycom.ExecuteReader();
//判断是否有数据
while (dr.Read())
{
DropDownList1.Items.Add(new ListItem(dr["ST_c_name"].ToString(), dr["ST_c_id"].ToString()));
}
mycon.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (IsSafe(Request.QueryString["id"], 2) == false)
{
Response.Write("错误页面,<a href=BlogIndex.aspx>点此返回</a>");
Response.End();
}
string ST_sql = "select * from ST_news where ST_n_id=" + Request.QueryString["id"] + "";
//最新推荐文章
string ST_cmd_sql = "select top 10 * from ST_news where ST_n_iscmd=1 order by ST_n_id desc";
string sqlstr = "select ST_c_id,ST_c_name from ST_class";
DataSet ST_ds = myobj.GetDataSet(ST_sql, "ST_news");
DataSet ST_classds = myobj.GetDataSet(sqlstr, "ST_class");
DataSet ST_cmdds = myobj.GetDataSet(ST_cmd_sql, "ST_news");
NewsShow.DataSource = ST_ds.Tables[0];
NewsShow.DataBind();
ClassList.DataSource = new DataView(ST_classds.Tables[0]);
ClassList.DataBind();
CmdList.DataSource = new DataView(ST_cmdds.Tables[0]);
CmdList.DataBind();
//调用ST_UpdateHit()方法
ST_UpdateHit();
if (Request.Cookies["colors"] != null)
{
string ST_test = Request.Cookies["colors"].Value;
String[] ST_colorList = ST_test.Split(new[] { ',' });
ST_bgcolor = ST_colorList[0];
ST_tcolor = ST_colorList[1];
}
else
{
ST_bgcolor = "#FFFFFF";
ST_tcolor = "#cccccc";
}
Page.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
/*判断是否登录*/
ST_check_Login();
}
//定义一个查询用户信息的SQL语句
string sqlstr = "select * from tb_Blog where UserName='******'";
//调用公共类中的GetDataSet方法执行SQL语句，并返回DataSet类型的数据集
DataSet mydataset = da.GetDataSet(sqlstr, "tb_Blog");
//创建数据表的视图
DataRowView rowview1 = mydataset.Tables["tb_Blog"].DefaultView[0];
//获取注册博客的编号
ID = rowview1["BlogID"].ToString();
//调用自定义绑定方法绑定数据
ST_Article_Bind();
}
