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