public MemberVO FindMember(string input, int mode) { MemberVO member = null; connection.Open(); command = connection.CreateCommand(); switch (mode) { case Constants.SEARCH_WITH_EMAIL: command.CommandText = "select * from member where email = @email"; command.Parameters.Add("@email", MySqlDbType.VarChar).Value = input; break; case Constants.SEARCH_WITH_ID: command.CommandText = "select * from member where id = @id"; command.Parameters.Add("@id", MySqlDbType.VarChar).Value = input; break; } reader = command.ExecuteReader(); while (reader.Read()) { member = new MemberVO(); member.Id = reader.GetString(0); member.Password = reader.GetString(1); member.Name = reader.GetString(2); member.ResidentNumber = reader.GetString(3); member.AddressNumber = reader.GetString(4); member.Address = reader.GetString(5); member.AddressDetail = reader.GetString(6); member.PhoneNumber = reader.GetString(7); member.Email = reader.GetString(8); } reader.Close(); connection.Close(); if (member == null) { return(null); } else { return(member); } }
/// <summary> /// 회원의 전화번호를 수정하는 역할을 한다. /// </summary> /// <param name="id">회원의 아이디</param> /// <param name="phone">수정할 전화번호</param> public void EditMemberInfo(MemberVO member) { connection.Open(); command = connection.CreateCommand(); command.CommandText = "UPDATE member SET password = @password, name = @name,residentNumber = @residentNumber, " + "addressNumber = @addressNumber,address = @address, addressdetail = @addressDetail,phoneNumber = @phoneNumber,email = @email where id = @id"; command.Parameters.Add("@name", MySqlDbType.VarChar).Value = member.Name; command.Parameters.Add("@residentNumber", MySqlDbType.VarChar).Value = member.ResidentNumber; command.Parameters.Add("@id", MySqlDbType.VarChar).Value = member.Id; command.Parameters.Add("@password", MySqlDbType.VarChar).Value = member.Password; command.Parameters.Add("@phoneNumber", MySqlDbType.VarChar).Value = member.PhoneNumber; command.Parameters.Add("@address", MySqlDbType.VarChar).Value = member.Address; command.Parameters.Add("@addressDetail", MySqlDbType.VarChar).Value = member.AddressDetail; command.Parameters.Add("@addressNumber", MySqlDbType.VarChar).Value = member.AddressNumber; command.Parameters.Add("@email", MySqlDbType.VarChar).Value = member.Email; command.ExecuteNonQuery(); connection.Close(); }
public void AddMember(MemberVO member) { connection.Open(); command = connection.CreateCommand(); command.CommandText = "INSERT INTO member values(@id,@password,@name,@residentNumber,@addressNumber,@address,@addressDetail,@phoneNumber,@email)"; command.Parameters.Add("@name", MySqlDbType.VarChar).Value = member.Name; command.Parameters.Add("@residentNumber", MySqlDbType.VarChar).Value = member.ResidentNumber; command.Parameters.Add("@id", MySqlDbType.VarChar).Value = member.Id; command.Parameters.Add("@password", MySqlDbType.VarChar).Value = member.Password; command.Parameters.Add("@phoneNumber", MySqlDbType.VarChar).Value = member.PhoneNumber; command.Parameters.Add("@address", MySqlDbType.VarChar).Value = member.Address; command.Parameters.Add("@addressDetail", MySqlDbType.VarChar).Value = member.AddressDetail; command.Parameters.Add("@addressNumber", MySqlDbType.VarChar).Value = member.AddressNumber; command.Parameters.Add("@email", MySqlDbType.VarChar).Value = member.Email; command.ExecuteNonQuery(); connection.Close(); }
public void InitTextBoxes(MemberVO member) { id.Text = member.Id; pw.Text = member.Password; pw.BorderBrush = Brushes.Black; pw2.Text = member.Password; pw2.BorderBrush = Brushes.Black; name.Text = member.Name; frontResiNum.Text = member.ResidentNumber.Substring(0, 6); behindResiNum.Text = member.ResidentNumber.Substring(6, 7); addressNumber.Text = member.AddressNumber; addressNumber.BorderBrush = Brushes.Black; frontAddress.Text = member.Address; behindAddress.Text = member.AddressDetail; phone1.BorderBrush = Brushes.Black; phone2.BorderBrush = Brushes.Black; phone3.BorderBrush = Brushes.Black; if (member.PhoneNumber.Length.Equals(11)) { phone1.Text = member.PhoneNumber.Substring(0, 3); phone2.Text = member.PhoneNumber.Substring(3, 4); phone3.Text = member.PhoneNumber.Substring(7, 4); } else if (member.PhoneNumber.Length.Equals(10)) { phone1.Text = member.PhoneNumber.Substring(0, 3); phone2.Text = member.PhoneNumber.Substring(3, 3); phone3.Text = member.PhoneNumber.Substring(6, 4); } int index = member.Email.IndexOf('@'); emailFront.Text = member.Email.Substring(0, index); emailBehind.Text = member.Email.Substring(index + 1, member.Email.Length - index - 1); }