/// <summary>
/// 검색 기능을 담당하는 메소드
/// </summary>
/// <param name="list"></param>
public void PrintSearch()
{
bool exitFlag = true;
while (exitFlag)
{
printAboutControlMembers.SearchMenu();
id = Console.ReadLine();
Console.Clear();
switch (id)
{
case LibraryConstants.SEARCH_WITH_NAME:
SearchSub(LibraryConstants.SEARCH_WITH_NAME);
if (search.Equals("0"))
{
return;
}
printAboutControlMembers.Category();
logDAO.AddLog(DateTime.Now, search, "회원 검색");
memberDAO.SearchWithQuary("select * from member where name like \"%" + search + "%\"");
printAboutControlMembers.PressAnyKey();
break;
case LibraryConstants.SEARCH_WITH_RESIDENT_NUMBER:
SearchSub(LibraryConstants.SEARCH_WITH_RESIDENT_NUMBER);
if (search.Equals("0"))
{
return;
}
printAboutControlMembers.Category();
logDAO.AddLog(DateTime.Now, search, "회원 검색");
memberDAO.SearchWithQuary("select * from member where residentNumber like \"%" + search + "%\"");
printAboutControlMembers.PressAnyKey();
break;
case LibraryConstants.SEARCH_WITH_ID:
SearchSub(LibraryConstants.SEARCH_WITH_ID);
if (search.Equals("0"))
{
return;
}
printAboutControlMembers.Category();
logDAO.AddLog(DateTime.Now, search, "회원 검색");
memberDAO.SearchWithQuary("select * from member where id like \"%" + search + "%\"");
printAboutControlMembers.PressAnyKey();
break;
case LibraryConstants.SEARCH_WITH_PASSWORD:
SearchSub(LibraryConstants.SEARCH_WITH_PASSWORD);
if (search.Equals("0"))
{
return;
}
printAboutControlMembers.Category();
logDAO.AddLog(DateTime.Now, search, "회원 검색");
memberDAO.SearchWithQuary("select * from member where password like \"%" + search + "%\"");
printAboutControlMembers.PressAnyKey();
break;
case LibraryConstants.SEARCH_WITH_ADDRESS:
SearchSub(LibraryConstants.SEARCH_WITH_ADDRESS);
if (search.Equals("0"))
{
return;
}
printAboutControlMembers.Category();
logDAO.AddLog(DateTime.Now, search, "회원 검색");
memberDAO.SearchWithQuary("select * from member where address like \"%" + search + "%\"");
printAboutControlMembers.PressAnyKey();
break;
case LibraryConstants.SEARCH_WITH_PHONE:
SearchSub(LibraryConstants.SEARCH_WITH_PHONE);
if (search.Equals("0"))
{
return;
}
printAboutControlMembers.Category();
logDAO.AddLog(DateTime.Now, search, "회원 검색");
memberDAO.SearchWithQuary("select * from member where phoneNumber like \"%" + search + "%\"");
printAboutControlMembers.PressAnyKey();
break;
case LibraryConstants.SEARCH_WITH_AGE:
SearchSub(LibraryConstants.SEARCH_WITH_AGE);
if (search.Equals("0"))
{
return;
}
printAboutControlMembers.Category();
logDAO.AddLog(DateTime.Now, search, "회원 검색");
memberDAO.SearchWithQuary("select * from member where age like \"%" + search + "%\"");
printAboutControlMembers.PressAnyKey();
break;
case LibraryConstants.RETURN_BACK:
exitFlag = false;
return;
default:
break;
}
}
}