DlgUser.cpp 6.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288
  1. // AnalogPropertyDlg1.cpp : implementation file
  2. //
  3. #include "stdafx.h"
  4. #include "IDE.h"
  5. #include "DlgUser.h"
  6. #include "StringOperation.h"
  7. #include "UserDBProcess.h"
  8. #ifdef _DEBUG
  9. #define new DEBUG_NEW
  10. #undef THIS_FILE
  11. static char THIS_FILE[] = __FILE__;
  12. #endif
  13. /////////////////////////////////////////////////////////////////////////////
  14. // CDlgUser dialog
  15. CDlgUser::CDlgUser(CWnd* pParent /*=NULL*/)
  16. : CDialog(CDlgUser::IDD, pParent)
  17. {
  18. //{{AFX_DATA_INIT(CDlgUser)
  19. //}}AFX_DATA_INIT
  20. m_operation=EDIT;
  21. m_DDXFields.SetSize(9);
  22. }
  23. void CDlgUser::DoDataExchange(CDataExchange* pDX)
  24. {
  25. CDialog::DoDataExchange(pDX);
  26. //{{AFX_DATA_MAP(CDlgUser)
  27. //}}AFX_DATA_MAP
  28. m_DDXFields.DDX(pDX);
  29. }
  30. BEGIN_MESSAGE_MAP(CDlgUser, CDialog)
  31. //{{AFX_MSG_MAP(CDlgUser)
  32. //}}AFX_MSG_MAP
  33. ON_BN_CLICKED(IDC_BTN_CANCEL, OnBnClickedBtnCancel)
  34. ON_BN_CLICKED(IDC_BTN_SAVE, OnBnClickedBtnSave)
  35. END_MESSAGE_MAP()
  36. /////////////////////////////////////////////////////////////////////////////
  37. // CDlgUser message handlers
  38. BOOL CDlgUser::OnInitDialog()
  39. {
  40. CDialog::OnInitDialog();
  41. int i;
  42. m_DDXFields.m_pWnd=this;
  43. m_DDXFields.SetDBType( g_strDBType );
  44. i=0;
  45. m_DDXFields.ElementAt(i).Set(_T("id"), IDC_EDT_ID);
  46. m_DDXFields.ElementAt(i).m_description=_T("ID");
  47. m_DDXFields.ElementAt(i).m_nDataType = DATA_NUM;
  48. i=1;
  49. m_DDXFields.ElementAt(i).Set(_T( "uid" ),IDC_EDT_USER_ID) ;
  50. m_DDXFields.ElementAt(i).m_description=g_strUserID;
  51. m_DDXFields.ElementAt(i).m_nDataType = DATA_STR;
  52. i=2;
  53. m_DDXFields.ElementAt(i).Set(_T( "username" ),IDC_EDT_USER_NAME);
  54. m_DDXFields.ElementAt(i).m_description=g_strUserName;
  55. m_DDXFields.ElementAt(i).m_nDataType = DATA_STR;
  56. i=3;
  57. m_DDXFields.ElementAt(i).Set(_T( "tel" ),IDC_EDT_TEL);
  58. m_DDXFields.ElementAt(i).m_description=g_strTel;
  59. m_DDXFields.ElementAt(i).m_nDataType = DATA_STR;
  60. i=4;
  61. m_DDXFields.ElementAt(i).Set(_T( "mobiletel" ),IDC_EDT_MOBIL) ;
  62. m_DDXFields.ElementAt(i).m_description=g_strMobile;
  63. m_DDXFields.ElementAt(i).m_nDataType = DATA_STR;
  64. i=5;
  65. m_DDXFields.ElementAt(i).Set(_T( "fax" ),IDC_EDT_FAX);
  66. m_DDXFields.ElementAt(i).m_description=g_strFax;
  67. m_DDXFields.ElementAt(i).m_nDataType = DATA_STR;
  68. i=6;
  69. m_DDXFields.ElementAt(i).Set(_T( "email" ),IDC_EDT_EMAIL);
  70. m_DDXFields.ElementAt(i).m_description=_T("Email");
  71. m_DDXFields.ElementAt(i).m_nDataType = DATA_STR;
  72. i=7;
  73. m_DDXFields.ElementAt(i).Set(_T( "status" ),IDC_EDT_USER_STATUS);
  74. m_DDXFields.ElementAt(i).m_description=g_strStatus;
  75. m_DDXFields.ElementAt(i).m_nDataType = DATA_BOOL;
  76. i=8;
  77. m_DDXFields.ElementAt(i).Set(_T( "pwd" ),IDC_EDT_USER_PWD);
  78. m_DDXFields.ElementAt(i).m_description=g_strPassword;
  79. m_DDXFields.ElementAt(i).m_nDataType = DATA_MD5;
  80. UpdateData(TRUE);
  81. switch (m_operation)
  82. {
  83. case NEW:
  84. break;
  85. default:
  86. m_DDXFields.ReadData(m_pSet);
  87. break;
  88. }
  89. UpdateData(FALSE);
  90. CString str;
  91. str.Format("%d", m_nID);
  92. GetDlgItem(IDC_EDT_ID)->SetWindowText(str);
  93. if( m_operation == EDIT )
  94. {
  95. GetDlgItem(IDC_EDT_USER_PWD)->EnableWindow(FALSE);
  96. GetDlgItem(IDC_EDT_USER_PWD_CONFIRM)->EnableWindow(FALSE);
  97. //CString str;
  98. //GetDlgItem(IDC_EDT_USER_PWD)->GetWindowText( str );
  99. //GetDlgItem(IDC_EDT_USER_PWD_CONFIRM)->SetWindowText( str );
  100. }
  101. GetDlgItem(IDC_EDT_USER_STATUS)->GetWindowText(str);
  102. ((CButton *)GetDlgItem(IDC_CHK_USER_STATUS))->SetCheck(!str.Compare("TRUE") || !str.Compare("1") ? TRUE : FALSE );
  103. m_btnSave.SubclassDlgItem(IDC_BTN_SAVE, this);
  104. m_btnSave.SetBitmaps(IDB_SAVE, RGB(255, 0, 255));
  105. m_btnSave.SetFlat(FALSE);
  106. m_btnSave.SetAlign(CButtonST::ST_ALIGN_HORIZ);
  107. m_btnCancel.SubclassDlgItem(IDC_BTN_CANCEL, this);
  108. m_btnCancel.SetBitmaps(IDB_DEL, RGB(255, 0, 255));
  109. m_btnCancel.SetFlat(FALSE);
  110. m_btnCancel.SetAlign(CButtonST::ST_ALIGN_HORIZ);
  111. UpdateData( false );
  112. GetDlgItem(IDC_EDT_USER_ID)->GetWindowText( m_sUserID_Old );
  113. return TRUE; // return TRUE unless you set the focus to a control
  114. // EXCEPTION: OCX Property Pages should return FALSE
  115. }
  116. void CDlgUser::OnBnClickedBtnCancel()
  117. {
  118. // TODO: 在此添加控件通知处理程序代码
  119. OnCancel();
  120. }
  121. int CDlgUser::CheckDataValid()
  122. {
  123. CString strID, strUserID, strUserName, strPwd, strConfirmPwd;
  124. CString strTel, strMobileTel, strEmail, strFax;
  125. strID = m_DDXFields.ElementAt(0).m_value;
  126. strUserID = m_DDXFields.ElementAt(1).m_value;
  127. strPwd = m_DDXFields.ElementAt(8).m_value;
  128. GetDlgItem(IDC_EDT_USER_PWD_CONFIRM)->GetWindowText(strConfirmPwd);
  129. m_sUserID = strUserID;
  130. if( strUserID.IsEmpty() )
  131. {
  132. MessageBox(g_strUserNameCannotEmpty, g_strTip, MB_ICONINFORMATION);
  133. GetDlgItem(IDC_EDT_USER_ID)->SetFocus();
  134. return 1;
  135. }
  136. else if(strPwd.Compare(strConfirmPwd))
  137. {
  138. if( m_operation == NEW || m_operation == COPY )
  139. {
  140. MessageBox(g_strPasswordNotMatch2, g_strTip, MB_ICONINFORMATION);
  141. GetDlgItem(IDC_EDT_USER_PWD)->SetFocus();
  142. return 1;
  143. }
  144. else if( m_operation==EDIT )
  145. ;
  146. return 2;
  147. }
  148. CHAR szID[MAX_ID] = {0};
  149. if( m_operation == NEW || m_operation == COPY )
  150. {
  151. int nRet = CDBInterface::GetInstancePtr()->GetUserID( szID, (char *)(LPCTSTR)strUserID );
  152. if( nRet > 0 )
  153. {
  154. MessageBox(g_strUserNameExit, g_strTip, MB_ICONINFORMATION);
  155. return 1;
  156. }
  157. }
  158. return 0;
  159. }
  160. void CDlgUser::OnBnClickedBtnSave()
  161. {
  162. // TODO: 在此添加控件通知处理程序代码
  163. // 存盘操作
  164. CExString strField;
  165. CHAR szMaxID[MAX_ID + 1] = {0};
  166. CHAR strSQLText[MAX_SQL_LENGTH + 1] = {0};
  167. if( ((CButton *)GetDlgItem(IDC_CHK_USER_STATUS))->GetCheck() )
  168. {
  169. GetDlgItem(IDC_EDT_USER_STATUS)->SetWindowText("1");
  170. }
  171. else
  172. {
  173. GetDlgItem(IDC_EDT_USER_STATUS)->SetWindowText("0");
  174. }
  175. CDBInterface::GetInstancePtr()->GetMaxID("t_user_info", "id", szMaxID);
  176. int nID;
  177. CString strID;
  178. try
  179. {
  180. switch (m_operation)
  181. {
  182. case EDIT:
  183. //nID = atoi(szMaxID);
  184. break;
  185. default:
  186. if( atoi(szMaxID) > 0 )
  187. {
  188. nID = atoi(szMaxID) + 1;
  189. }
  190. else if( atoi(szMaxID) == 0 )
  191. {
  192. nID = 1;
  193. }
  194. strID.Format("%d", nID);
  195. GetDlgItem(IDC_EDT_ID)->SetWindowText(strID);
  196. //m_pSet->AddNew();
  197. break;
  198. }
  199. UpdateData(TRUE);
  200. try
  201. {
  202. // 校验数据的正确性
  203. int nRet = CheckDataValid();
  204. if( nRet == 1 )
  205. {
  206. return;
  207. //CDialog::OnOK();
  208. }
  209. //else if( nRet == 0 )
  210. {
  211. sprintf(strSQLText, "insert into t_user_info(id, uid, username, tel, mobiletel, fax, email, status, pwd) values(");
  212. if( m_DDXFields.WriteData("t_user_info", strSQLText, m_operation) == -1 ) return;
  213. }
  214. }
  215. catch(...)
  216. {
  217. ;
  218. }
  219. UpdateData(FALSE);
  220. CDialog::OnOK();
  221. }//try
  222. catch( _com_error &e )
  223. {
  224. CString mes1,mes2,mes3,mes4;
  225. mes1.Format(_T("Error:%08lx.\n"), e.Error());
  226. mes2.Format(_T("ErrorMessage:%s.\n"), e.ErrorMessage());
  227. mes3.Format(_T("Source:%s.\n"), (LPCTSTR) _bstr_t(e.Source()));
  228. mes4.Format(_T("Description:%s.\n"), (LPCTSTR) _bstr_t(e.Description()));
  229. MessageBox(mes1+mes2+mes3+mes4,_T("Invalid field "),MB_ICONERROR);
  230. return;
  231. }
  232. catch(...)
  233. {
  234. MessageBox(_T("Unhandled Exception"),_T("Invalid field ")+strField,MB_ICONERROR);
  235. return;
  236. }
  237. }