protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] != null)
{
Sql_StringChar sql_String = new Sql_StringChar(); //动态数据源
sql_String.ConnectionString = sql_String.sql_char; //连接字符串
DropDownList dr1 = new DropDownList();
dr1 = (DropDownList)DetailsView1.FindControl("caName");
//AccessDataSource ads = new AccessDataSource();
//ads.DataFile = "~/date/blog_Data.mdb";
sql_String.SelectCommand = "SELECT * FROM blogCategory ";
DataView dv = (DataView)sql_String.Select(DataSourceSelectArguments.Empty);
dr1.Items.Clear();
for (int i = 0; i < dv.Count; i++)
{
ListItem li = new ListItem(dv[i]["ca_name"].ToString(), dv[i]["ca_id"].ToString());
//li.Text = dv[i]["ca_name"].ToString();
//li.Value = dv[i]["ca_id"].ToString();
ca_id = dv[i]["ca_id"].ToString();
dr1.Items.Add(li);
ca_i++;
}
}
else
{
Response.Redirect("_boke.aspx");
}
}
protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
String year, month, day;
year = Convert.ToString(e.Day.Date.Year);
month = Convert.ToString(e.Day.Date.Month);
day = Convert.ToString(e.Day.Date.Day);
//AccessDataSource ads = new AccessDataSource();
//ads.DataFile = "~/App_data/webData.mdb";
Sql_StringChar sql_String = new Sql_StringChar(); //动态数据源
sql_String.ConnectionString = sql_String.sql_char; //连接字符串
//sql_String.SelectCommand = "select * from blogMessages where day(cdate(blog_date))=" + day + " and month(cdate(blog_date))=" + month + " and year(cdate(blog_date))=" + year;
sql_String.SelectCommand = "select * from blogMessages where day(cast(blog_date as datetime))=" + day + " and month(cast(blog_date as datetime))=" + month + " and year(cast(blog_date as datetime))=" + year;
DataView dv = (DataView)sql_String.Select(DataSourceSelectArguments.Empty);
if (dv.Count != 0)
{
e.Cell.BackColor = Color.LightPink;
e.Cell.Controls.Clear();
HyperLink hl = new HyperLink();
hl.NavigateUrl = "blogSearch.aspx?year=" + year + "&month=" + month + "&day=" + day;
hl.Text = e.Day.Date.Day.ToString();
e.Cell.Controls.Add(hl);
}
else
{
e.Cell.Controls.Clear();
e.Cell.Text = e.Day.Date.Day.ToString();
}
}
protected void DetailsView1_ItemInserted(object sender, DetailsViewInsertedEventArgs e)
{
Sql_StringChar sql_String = new Sql_StringChar(); //动态数据源
sql_String.ConnectionString = sql_String.sql_char; //连接字符串
sql_String.SelectCommand = "SELECT * FROM blogCategory ";
DataView dv = (DataView)sql_String.Select(DataSourceSelectArguments.Empty);
}
protected void DataListDataBind()
{
//AccessDataSource ads = new AccessDataSource();
//ads.DataFile = "~/date/blog_Data.mdb";
//sql_stringchar sql_string = new sql_stringchar();//动态数据源
//sql_string.connectionstring = sql_string.sql_char;//连接字符串
Sql_StringChar sql_String = new Sql_StringChar(); //动态数据源
sql_String.ConnectionString = sql_String.sql_char; //连接字符串
GetCa_id();
sql_String.SelectCommand = "SELECT * FROM [blogMessages] where ca_id=" + ca_id + " ";
DataView dv = (DataView)sql_String.Select(DataSourceSelectArguments.Empty);
PagedDataSource objPage = new PagedDataSource();
objPage.DataSource = dv;
objPage.AllowPaging = true;
objPage.PageSize = 3;
int TolPage;
TolPage = objPage.PageCount;
int CurPage;
if (Request.QueryString["Page"] != null)
{
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
}
else
{
CurPage = 1;
}
objPage.CurrentPageIndex = CurPage - 1;
pagenum.Text = CurPage.ToString();
pagecount.Text = objPage.PageCount + "";
lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1" + "&PageSize=" + Convert.ToString(objPage.PageSize);
lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + TolPage.ToString() + "&PageSize=" + Convert.ToString(objPage.PageSize);
if (!objPage.IsFirstPage)
{
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1) + "&PageSize=" + Convert.ToString(objPage.PageSize);
}
else
{
lnkPrev.Visible = false;
lnkFirst.Visible = false;
}
if (!objPage.IsLastPage)
{
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1) + "&PageSize=" + Convert.ToString(objPage.PageSize);
}
else
{
lnkNext.Visible = false;
lnkLast.Visible = false;
}
DataList2.DataSource = objPage;
DataList2.DataBind();
}
/***************************/
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//AccessDataSource ads = new AccessDataSource();
//ads.DataFile = "~/date/blog_Data.mdb";
Sql_StringChar sql_String = new Sql_StringChar(); //动态数据源
sql_String.ConnectionString = sql_String.sql_char; //连接字符串
sql_String.SelectCommand = "select * from blogMessages ";
DataView dv = (DataView)sql_String.Select(DataSourceSelectArguments.Empty);
string b_id = e.Keys[0].ToString();
sql_String.DeleteCommand = "delete from blogComments where blog_id=?";//删除留言
sql_String.DeleteParameters.Add("blog_id", b_id);
Sql_StringChar sql_String3 = new Sql_StringChar(); //动态数据源
sql_String3.ConnectionString = sql_String3.sql_char; //连接字符串
sql_String3.SelectCommand = "select ca_id,blog_id from blogMessages where blog_id=" + b_id; //通过文章id查询分类id，绑定到一个隐藏控件。
DataView dv3 = (DataView)sql_String3.Select(DataSourceSelectArguments.Empty);
FormView2.DataSource = sql_String3;
FormView2.DataBind();
Label cid = (Label)FormView2.FindControl("ca_id");//获得隐藏控件里的控件值，即是分类id。
string c_id = cid.Text;
//AccessDataSource ads2 = new AccessDataSource();
//ads2.DataFile = "~/date/blog_Data.mdb";
Sql_StringChar sql_String2 = new Sql_StringChar(); //动态数据源
sql_String2.ConnectionString = sql_String2.sql_char; //连接字符串
sql_String2.SelectCommand = "select * from blogCategory ";
DataView dv2 = (DataView)sql_String2.Select(DataSourceSelectArguments.Empty);
sql_String2.UpdateCommand = "update blogCategory set ca_num=ca_num-1 where ca_id='" + c_id + "'";//更新文章分类数目
sql_String2.Update();
Sql_StringChar sql_String4 = new Sql_StringChar(); //动态数据源
sql_String4.ConnectionString = sql_String4.sql_char; //连接字符串
sql_String4.SelectCommand = "select * from blogMessages ";
DataView dv1 = (DataView)sql_String4.Select(DataSourceSelectArguments.Empty);
string b_id1 = e.Keys[0].ToString();
sql_String4.DeleteCommand = "delete from blogMessages where blog_id='" + b_id1 + "'";//删除文章
//sql_String4.DeleteParameters.Add("blog_id", b_id1);
sql_String4.Delete();
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
txt_TextBoxMode_Password();
sql_String = new Sql_StringChar(); //动态数据源
sql_String.ConnectionString = sql_String.sql_char; //连接字符串
sql_String.SelectCommand = "select userName from blogUserTable where userName='******'";
dv = (DataView)sql_String.Select(DataSourceSelectArguments.Empty);
if (dv.Count > 0)
{
Msg.Text = "用户已存在";
LinkButton3.Enabled = false;
return;
}
else
{
Msg.Text = "可注册";
LinkButton3.Enabled = true;
}
}
protected void DataListDataBind()
{
try
{
//AccessDataSource ads = new AccessDataSource();
//ads.DataFile = "~/date/blog_Data.mdb";
Sql_StringChar sql_String = new Sql_StringChar(); //动态数据源
sql_String.ConnectionString = sql_String.sql_char; //连接字符串
string year = Request.QueryString["year"].ToString();
string month = Request.QueryString["month"].ToString();
string day = Request.QueryString["day"].ToString();
sql_String.SelectCommand = "SELECT * FROM [blogMessages] WHERE day(blog_date)='" + day + "' and month(blog_date)='" + month + "'and year(blog_date)='" + year + "' ORDER BY [blog_date] DESC ";
DataView dv = (DataView)sql_String.Select(DataSourceSelectArguments.Empty);
PagedDataSource objPage = new PagedDataSource();
objPage.DataSource = dv;
objPage.AllowPaging = true;
objPage.PageSize = 4;
int TolPage;
TolPage = objPage.PageCount;
int CurPage;
if (Request.QueryString["Page"] != null)
{
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
}
else
{
CurPage = 1;
}
objPage.CurrentPageIndex = CurPage - 1;
pagenum.Text = CurPage.ToString();
pagecount.Text = objPage.PageCount + "";
lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1" + "&PageSize=" + Convert.ToString(objPage.PageSize);
lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + TolPage.ToString() + "&PageSize=" + Convert.ToString(objPage.PageSize);
if (!objPage.IsFirstPage)
{
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1) + "&PageSize=" + Convert.ToString(objPage.PageSize);
}
else
{
lnkPrev.Visible = false;
lnkFirst.Visible = false;
}
if (!objPage.IsLastPage)
{
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1) + "&PageSize=" + Convert.ToString(objPage.PageSize);
}
else
{
lnkNext.Visible = false;
lnkLast.Visible = false;
}
DataList2.DataSource = objPage;
DataList2.DataBind();
}
catch (Exception ee)
{
Response.Redirect("_boke.aspx");
}
}
protected void DataListDataBind()
{
Sql_StringChar sql_String = new Sql_StringChar(); //动态数据源
sql_String.ConnectionString = sql_String.sql_char; //连接字符串
sql_String.SelectCommand = "SELECT * FROM [blogMessages] ORDER BY [blog_date] DESC ";
DataView dv = (DataView)sql_String.Select(DataSourceSelectArguments.Empty);
PagedDataSource objPage = new PagedDataSource();
objPage.DataSource = dv;
objPage.AllowPaging = true;
objPage.PageSize = 10;
int TolPage;
TolPage = objPage.PageCount;
int CurPage;
if (Request.QueryString["Page"] != null)
{
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
}
else
{
CurPage = 1;
}
objPage.CurrentPageIndex = CurPage - 1;
pagenum.Text = CurPage.ToString();
pagecount.Text = objPage.PageCount + "";
lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1" + "&PageSize=" + Convert.ToString(objPage.PageSize);
lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + TolPage.ToString() + "&PageSize=" + Convert.ToString(objPage.PageSize);
if (!objPage.IsFirstPage)
{
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1) + "&PageSize=" + Convert.ToString(objPage.PageSize);
}
else
{
lnkPrev.Visible = false;
lnkFirst.Visible = false;
}
if (!objPage.IsLastPage)
{
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1) + "&PageSize=" + Convert.ToString(objPage.PageSize);
}
else
{
lnkNext.Visible = false;
lnkLast.Visible = false;
}
sql_String.Dispose();
DataList2.DataSource = objPage;
DataList2.DataBind();
#region/******************千万不能删************************/
//get评论数
//string j = string.Empty;
//for (int i = 0; i < DataList2.Items.Count; i++)
//{
// j = ((Label)DataList2.Items[i].FindControl("Label12")).Text;
// string sql_char = "server=.;Initial Catalog=Blog_wwww;User ID=sa;Password=1";//连接字符串
// string sql = "SELECT count(blog_id) FROM [blogComments] WHERE BLOG_ID='" + j + "'";
// using (SqlConnection conn = new SqlConnection(sql_char))
// {
// conn.Open();
// using (SqlCommand cmd = conn.CreateCommand())
// {
// string k = conn.State.ToString();
// cmd.CommandText = sql;
// //if (cmd.ExecuteReader() > 0)
// //{
// //}
// int n = cmd.ExecuteNonQuery();
// using (SqlDataReader dr = cmd.ExecuteReader())
// {
// //string k=dr[""]
// }
// }
// }
//}
#endregion /******************千万不能删************************/
}
protected void DataListDataBind()
{
//AccessDataSource ads = new AccessDataSource();
//ads.DataFile = "~/date/blog_Data.mdb";
//SqlDataSource srcMov = new SqlDataSource();
//srcMov.ConnectionString =
// WebConfigurationManager.ConnectionStrings["DawnEnterpriseDBConnectionString"].ConnectionString;
//SqlDataSource ads = new SqlDataSource();
//ads.ConnectionString = "server=.;Initial Catalog=Blog_wwww;User ID=sa;Password=1";
Sql_StringChar sql_String = new Sql_StringChar(); //动态数据源
sql_String.ConnectionString = sql_String.sql_char; //连接字符串
sql_String.SelectCommand = "SELECT * FROM [blogMessages] ORDER BY [blog_date] DESC ";
DataView dv = (DataView)sql_String.Select(DataSourceSelectArguments.Empty);
PagedDataSource objPage = new PagedDataSource();
objPage.DataSource = dv;
objPage.AllowPaging = true;
objPage.PageSize = 5;
int TolPage;
TolPage = objPage.PageCount;
int CurPage;
if (Request.QueryString["Page"] != null)
{
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
}
else
{
CurPage = 1;
}
objPage.CurrentPageIndex = CurPage - 1;
//pagenum.Text = CurPage.ToString();
//pagecount.Text = objPage.PageCount + "";
lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1" + "&PageSize=" + Convert.ToString(objPage.PageSize);
lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + TolPage.ToString() + "&PageSize=" + Convert.ToString(objPage.PageSize);
if (!objPage.IsFirstPage)
{
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1) + "&PageSize=" + Convert.ToString(objPage.PageSize);
}
else
{
lnkPrev.Visible = false;
lnkFirst.Visible = false;
}
if (!objPage.IsLastPage)
{
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1) + "&PageSize=" + Convert.ToString(objPage.PageSize);
}
else
{
lnkNext.Visible = false;
lnkLast.Visible = false;
}
FormView1.DataSource = objPage;
FormView1.DataBind();
// DataList1.DataSource = objPage;
//DataList1.DataBind();
}
