//확인버튼을 눌렀을 때
private void buttonConfirmClicked(object sender, EventArgs e)
{
string id = textBoxPasswdID.Text;
string name = textBoxPasswdName.Text;
DateTime date = dateTimePickerBirth.Value.Date;
string birth = date.Year + "-" + date.Month + "-" + date.Day;
if (name != "")
{
oracleCommand1.CommandText = "select consu_password from consumer where consu_id='" + id + "' AND consu_name='" + name + "' AND consu_birth=TO_DATE('" + birth + "', 'YYYY-MM-DD')";
OracleDataReader rdr = oracleCommand1.ExecuteReader();
int flag = 0;
while (rdr.Read())
{
FormChangePasswordData searchFrm = new FormChangePasswordData(mainform, "고객", id, rdr[0].ToString());
searchFrm.Owner = this;
searchFrm.Show();
this.Visible = false;
flag++;
}
oracleConnection1.Close();
if (flag == 0)
{
MessageBox.Show("해당하는 정보의 사용자가 없습니다.");
}
}
else
{
MessageBox.Show("모든 값을 입력해 주세요");
}
}
private void buttonConfirmClick(object sender, EventArgs e)
{
string id = textBoxPasswdID.Text;
string name = textBoxPasswdName.Text;
if (name != "")
{
switch (mode)
{
case "직원":
oracleCommand1.CommandText = "select employ_password from employee where employ_id='" + id + "' AND employ_name='" + name + "'";
break;
case "관리자":
oracleCommand1.CommandText = "select admin_password from administer where admin_id='" + id + "' AND admin_name='" + name + "'";
break;
}
OracleDataReader rdr = oracleCommand1.ExecuteReader();
int flag = 0;
while (rdr.Read())
{
FormChangePasswordData frm = new FormChangePasswordData(mainform, mode, id, rdr[0].ToString());
frm.Owner = this;
frm.Show();
this.Visible = false;
flag++;
}
oracleConnection1.Close();
if (flag == 0)
{
MessageBox.Show("해당하는 정보의 사용자가 없습니다.");
}
}
else
{
MessageBox.Show("모든 값을 입력해 주세요");
}
}