private void Member_Chk(string p1)
{
Dictionary <string, string> myRecord;
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
if (cmbSel.EditValue.ToString() == "0")
{
sql.Query = "SELECT login_id FROM domalife.member_master " +
"WHERE u_name like '%" + p1 + "%' ";
}
else if (cmbSel.EditValue.ToString() == "1")
{
sql.Query = "SELECT login_id FROM domalife.member_master " +
"WHERE u_nickname like '%" + p1 + "%' ";
}
else if (cmbSel.EditValue.ToString() == "2")
{
sql.Query = "SELECT login_id FROM domalife.member_master " +
"WHERE login_id like '%" + p1 + "%' ";
}
else if (cmbSel.EditValue.ToString() == "3")
{
sql.Query = "SELECT login_id FROM domalife.member_master " +
"WHERE replace(u_cell_num, '-','') = '" + p1.Replace("-", "") + "'";
}
myRecord = sql.selectQueryForSingleRecord();
if (myRecord != null && myRecord.Count > 0)
{
lblID.Text = myRecord["login_id"].ToString();
}
}
}