public void editMySetting(settingClass s, string userMail)
{
string sql = @"
update Member
set m_Name=@mName,m_Alias=@mAlias,m_Gender=@mGender,m_Intro=@mIntro
where m_Email=@userMail;
update SystemAccount
set s_Pwd=@userPwd
where s_id=@userMail
";//m_id=@userMid
List <SqlParameter> paras = new List <SqlParameter>();
//paras.Add(new SqlParameter("mEmail", (object)s.m_Email));//m_Email=@mEmail,
/* if (s.s_Pwd == null)
* {
* s.s_Pwd = "";
* }*/
paras.Add(new SqlParameter("userPwd", (object)s.s_Pwd));
paras.Add(new SqlParameter("mName", (object)s.m_Name));
if (s.m_Alias == null)
{
s.m_Alias = "";
}
paras.Add(new SqlParameter("mAlias", (object)s.m_Alias));
paras.Add(new SqlParameter("mGender", (object)s.m_Gender));
if (s.m_Intro == null)
{
s.m_Intro = "";
}
paras.Add(new SqlParameter("mIntro", (object)s.m_Intro));
paras.Add(new SqlParameter("userMail", userMail));
//paras.Add(new SqlParameter("userMid", s.m_id));
executeSql(sql, paras);
}
private List <settingClass> getBySql(string sql, List <SqlParameter> paras)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=.;Initial Catalog=RentBookdb;Integrated Security=True";
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = sql;
if (paras != null)
{
foreach (SqlParameter p in paras)
{
cmd.Parameters.Add(p);
}
}
SqlDataReader reader = cmd.ExecuteReader();
List <settingClass> list = new List <settingClass>();
while (reader.Read())
{
settingClass x = new settingClass();
x.m_id = reader["m_id"].ToString();
x.m_Image = reader["m_Image"].ToString();
x.m_Name = reader["m_Name"].ToString();
x.m_Gender = reader["m_Gender"].ToString();
x.m_Alias = reader["m_Alias"].ToString();
if (x.m_Alias == null)
{
x.m_Alias = "";
}
x.m_Email = reader["m_Email"].ToString();
x.s_Pwd = reader["s_Pwd"].ToString();
x.m_Intro = reader["m_Intro"].ToString();
if (x.m_Intro == null)
{
x.m_Intro = "";
}
if (x.m_Image == "未知")
{
x.m_Image = "Default.jpg";
}
list.Add(x);
}
con.Close();
return(list);
}