//保存
protected void Button1_Click(object sender, EventArgs e)
{
if (fulpath.HasFile)//是否存在头像
{
//if (fulpath.PostedFile.ContentType.ToLower() == "image/jpeg")//文件格式
//{
Blogtable blogabout = new Blogtable();
blogabout.username = Session ["username"].ToString();
blogabout.describe = txtdescribe.Text;
blogabout.userphoto = @"~\blog image\" + Session["username"].ToString() + ".jpg";
blogabout.selfname = txtname.Text;
int a = new BLL_blog().BLL_select_bolge(blogabout);
if (a != 0)
{
string filenamessvr = Server.MapPath(@"~\blog image\" + Session["username"] + ".jpg");
fulpath.PostedFile.SaveAs(filenamessvr);
Page.ClientScript.RegisterStartupScript(typeof(string), "s", "<script>alert('更新成功')</script>");
Response.Redirect(@"~/bogleaspx/JournalList.aspx");
}
else
{
Page.ClientScript.RegisterStartupScript(typeof(string), "s", "<script>alert('更新失败')</script>");
}
//}
//else
//{
// Page.ClientScript.RegisterStartupScript(typeof(string), "s", "<script>alert('文件内容不是image/jpeg格式')</script>");
//}
}
else
{
Page.ClientScript.RegisterStartupScript(typeof(string), "s", "<script>alert('文件不存在')</script>");
}
}
/// <summary>
/// 个人设置中 返回受影响的行
/// </summary>
/// <param name="blog">实体对象 </param>
/// <returns> int</returns>
public int select_boge(Blogtable blog)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter("@username", blog.username),
new SqlParameter("@selfname", blog.selfname),
new SqlParameter("@describe", blog.describe),
new SqlParameter("@userphoto", blog.userphoto)
};
int a = sqlHelper.ExecuteNonQuery("select_Blogtable_selfnmae", parm);
return(a);
}
// username nvarchar(20) not null primary key, ----用户名
// selfname nvarchar (50), ----个性设置博客名称
// describe nvarchar(50), ----自定义博客描述
//userphoto nvarchar(50),
#region 根据用户名据查询博客表之中所有数
/// <summary>
/// 根据用户名据查询博客表之中所有数
/// </summary>
/// <param name="str"></param>
/// <returns></returns>
public List <Blogtable> select_Blogtable_all(string str)
{
List <Blogtable> list = new List <Blogtable>();
SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@username", str) };
SqlDataReader dr = sqlHelper.ExecuteReader("select_Blogtable_all", parm);
dr.Read();
Blogtable bl = new Blogtable();
bl.username = dr["username"].ToString();
bl.selfname = dr["selfname"].ToString();
bl.describe = dr["describe"].ToString();
bl.userphoto = dr["userphoto"].ToString();
list.Add(bl);
return(list);
}
/// <summary>
/// 返回数据库搜影响的行
/// </summary>
/// <param name="ble"></param>
/// <returns>int</returns>
public int BLL_select_bolge(Blogtable ble)
{
return(new DAL_boke().select_boge(ble));
}
