//保存按钮 protected void btnSave_Click(object sender, EventArgs e) { try { string[] fileInfo = ConfigurationManager.AppSettings["UpImagePath"].Split('|'); string getPath = fileInfo[0]; string getName = fileInfo[1]; string copyPath = Server.MapPath("images/AllHead") + "\\" + getName; if (File.Exists(copyPath)) { File.Delete(copyPath); } if (File.Exists(getPath)) { File.Copy(getPath, copyPath); File.Delete(getPath); PersonageInfo Uif = PersonageInfo_Manager.GetPersonageInfoByConn("P_LoginName", this.userName.Text); Uif.P_Head = "../images/AllHead/" + getName; int n = PersonageInfo_Manager.UpdatePersonageInfo(Uif); this.lbHint.InnerHtml = "头像修改成功!"; this.btnUp.Text = "未选择图片"; } else { this.lbHint.InnerHtml = "保存失败,请重新选择图片!"; } } catch (Exception ex) { this.lbHint.InnerHtml = "系统出现异常,请联系管理员!"; } }
/// <summary> /// 根据条件查询个人信息 /// </summary> /// <returns></returns> public static PersonageInfo GetPersonageInfoByConn(string demandType, string demandContent) { string sql = "Select * from PersonageInfo where " + demandType + " = @" + demandType; PersonageInfo personagerInfo = new PersonageInfo(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType, demandContent) }); if (dr.Read()) { personagerInfo = new PersonageInfo() { P_DataTime = dr["P_DataTime"].ToString(), P_Head = dr["P_Head"].ToString(), P_LoginName = dr["P_LoginName"].ToString(), P_LoginPwd = dr["P_LoginPwd"].ToString(), P_MyExplain = dr["P_MyExplain"].ToString(), P_Phone = dr["P_Phone"].ToString(), P_NickName = dr["P_NickName"].ToString() }; } dr.Close(); DBHelper.CloseCon(); return(personagerInfo); }
/// <summary> /// 删除个人信息数据 /// </summary> /// <returns></returns> public static int DeletePersonageInfo(PersonageInfo obj) { int n = DBHelper.ExecuteNonQuery("Delete_PersonageInfo", CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@P_LoginName", obj.P_LoginName) }); return(n); }
/// <summary> /// 添加个人信息数据 /// </summary> /// <returns></returns> public static int InsertPersonageInfo(PersonageInfo obj) { int n = DBHelper.ExecuteNonQuery("Insert_PersonageInfo", CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@P_DataTime", obj.P_DataTime), new SqlParameter("@P_Head", obj.P_Head), new SqlParameter("@P_LoginName", obj.P_LoginName), new SqlParameter("@P_LoginPwd", obj.P_LoginPwd), new SqlParameter("@P_MyExplain", obj.P_MyExplain), new SqlParameter("@P_Phone", obj.P_Phone), new SqlParameter("@P_NickName", obj.P_NickName) }); return(n); }
/// <summary> /// 获取全部个人信息 /// </summary> /// <returns></returns> public static List <PersonageInfo> GetAllPersonageInfo() { List <PersonageInfo> list = new List <PersonageInfo>(); SqlDataReader dr = DBHelper.ExecuteReader("Select_PersonageInfo", CommandType.StoredProcedure); while (dr.Read()) { PersonageInfo personagerInfo = new PersonageInfo() { P_DataTime = dr["P_DataTime"].ToString(), P_Head = dr["P_Head"].ToString(), P_LoginName = dr["P_LoginName"].ToString(), P_LoginPwd = dr["P_LoginPwd"].ToString(), P_MyExplain = dr["P_MyExplain"].ToString(), P_Phone = dr["P_Phone"].ToString(), P_NickName = dr["P_NickName"].ToString() }; list.Add(personagerInfo); } dr.Close(); DBHelper.CloseCon(); return(list); }
/// <summary> /// 删除个人信息数据 /// </summary> /// <returns></returns> public static int DeletePersonageInfo(PersonageInfo obj) { return(PersonageInfo_Service.DeletePersonageInfo(obj)); }
/// <summary> /// 修改个人信息数据 /// </summary> /// <returns></returns> public static int UpdatePersonageInfo(PersonageInfo obj) { return(PersonageInfo_Service.UpdatePersonageInfo(obj)); }
/// <summary> /// 添加个人信息数据 /// </summary> /// <returns></returns> public static int InsertPersonageInfo(PersonageInfo obj) { return(PersonageInfo_Service.InsertPersonageInfo(obj)); }