//保存 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)); }