CDSWebUserF.h 2.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. //---------------------------------------------------------------------------
  2. #ifndef CDSWebUserFH
  3. #define CDSWebUserFH
  4. //---------------------------------------------------------------------------
  5. #include <Classes.hpp>
  6. #include <ADODB.hpp>
  7. #include <DB.hpp>
  8. #include "ITSLibF.h"
  9. //---------------------------------------------------------------------------
  10. /*
  11. * User class
  12. */
  13. class TWebUser
  14. {
  15. public:
  16. TWebUser();
  17. virtual ~TWebUser();
  18. void Clear();
  19. private:
  20. bool FCompleted;
  21. int FEditMode;
  22. int FGridIndex;
  23. public:
  24. String USER_ID; // N NUMBER(10) N 홈페이지 사용자 아이디
  25. String EMAIL; // N VARCHAR2(50) N 이메일 주소(유일키)
  26. String NAME; // N VARCHAR2(30) Y 사용자 명
  27. String PWD; // N VARCHAR2(64) Y 비밀번호
  28. String CONTACTNUM; // N VARCHAR2(20) Y 연락처
  29. String USERAUTH; // N VARCHAR2(3) Y 사용자인증
  30. String QUESTION; // N VARCHAR2(200) Y 사용자인증질문
  31. String ANSWER; // N VARCHAR2(100) Y 사용자인증답변
  32. String RGST_DT; // N VARCHAR2(14) Y 등록일시
  33. String LOGIN_FAIL_COUNT; // N NUMBER(10) Y 0 로그인실패횟수
  34. String IS_ACCOUNT_LOCK; // N CHAR(1) Y 'N' 계정잠김여부
  35. String IP_ADDRESS; // N VARCHAR2(100) Y 관리자계정접속가능아이피
  36. String DEL_YN; // N CHAR(1) Y 'N' 삭제여부(Y:삭제됨,N:삭제안됌)
  37. String IS_ACCOUNT_LOCK_NM;
  38. String USERAUTH_NM;
  39. String MEM_DEL;
  40. public:
  41. __property bool Completed = {read = FCompleted, write = FCompleted};
  42. __property int EditMode = {read = FEditMode, write = FEditMode };
  43. __property int GridIndex = {read = FGridIndex, write = FGridIndex };
  44. };
  45. //---------------------------------------------------------------------------
  46. /*
  47. * User Manager
  48. */
  49. class TWebUserManager
  50. {
  51. public:
  52. TWebUserManager();
  53. virtual ~TWebUserManager();
  54. public:
  55. TItsMap<String, TWebUser*> FLists;
  56. public:
  57. bool LoadFromDb(TADOConnection *ADbConn=NULL);
  58. bool GetNextUserId(int &AId, TADOConnection *ADbConn=NULL);
  59. };
  60. //---------------------------------------------------------------------------
  61. extern TWebUserManager *WebUserManager;
  62. //---------------------------------------------------------------------------
  63. #endif