/// <summary> /// 검색 기능을 담당하는 메소드 /// </summary> /// <param name="list"></param> public void DrawSearch() { bool exitFlag = true; while (exitFlag) { drawControlMember.SearchMenu(); id = Console.ReadLine(); Console.Clear(); switch (id) { case LibraryConstants.SearchWithName: SearchSub(LibraryConstants.SearchWithName); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where name = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.SearchWithResidentNum: SearchSub(LibraryConstants.SearchWithResidentNum); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where residentNumber = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.SearchWithId: SearchSub(LibraryConstants.SearchWithId); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where id = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.SearchWithPassword: SearchSub(LibraryConstants.SearchWithPassword); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where password = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.SearchWithAddress: SearchSub(LibraryConstants.SearchWithAddress); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where address = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.SearchWithPhone: SearchSub(LibraryConstants.SearchWithPhone); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where phoneNumber = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.SearchWithAge: SearchSub(LibraryConstants.SearchWithAge); if (search.Equals("0")) { return; } drawControlMember.Category(); memberDAO.SearchWithQuary("select * from member where age = \"" + search + "\""); drawControlMember.PressAnyKey(); break; case LibraryConstants.ReturnBack: exitFlag = false; break; default: break; } } }