SetClientIPDlg.cpp 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111
  1. // SetClientIPDlg.cpp : implementation file
  2. //
  3. #include "stdafx.h"
  4. #include "LYFZSendMsg.h"
  5. #include "SetClientIPDlg.h"
  6. #include "mysqldata.h"
  7. #ifdef _DEBUG
  8. #define new DEBUG_NEW
  9. #undef THIS_FILE
  10. static char THIS_FILE[] = __FILE__;
  11. #endif
  12. /////////////////////////////////////////////////////////////////////////////
  13. // SetClientIPDlg dialog IDC_branchname
  14. SetClientIPDlg::SetClientIPDlg(CWnd* pParent /*=NULL*/)
  15. : CDialog(SetClientIPDlg::IDD, pParent)
  16. {
  17. //{{AFX_DATA_INIT(SetClientIPDlg)
  18. m_name = _T(".ly.com");
  19. m_remark = _T("");
  20. m_enterprisename = _T("");
  21. m_check1 = 0;
  22. m_branchname = _T("");
  23. m_oldenterprisename = _T("");
  24. m_mode=0;
  25. m_ip = _T("");
  26. //}}AFX_DATA_INIT
  27. }
  28. void SetClientIPDlg::DoDataExchange(CDataExchange* pDX)
  29. {
  30. CDialog::DoDataExchange(pDX);
  31. //{{AFX_DATA_MAP(SetClientIPDlg)
  32. DDX_Text(pDX, IDC_name, m_name);
  33. DDX_Text(pDX, IDC_remark, m_remark);
  34. DDX_Text(pDX, IDC_enterprisename, m_enterprisename);
  35. DDX_Check(pDX, IDC_CHECK1, m_check1);
  36. DDX_Text(pDX, IDC_branchname, m_branchname);
  37. DDX_Text(pDX, IDC_EDIT1, m_ip);
  38. //}}AFX_DATA_MAP
  39. }
  40. BEGIN_MESSAGE_MAP(SetClientIPDlg, CDialog)
  41. //{{AFX_MSG_MAP(SetClientIPDlg)
  42. //}}AFX_MSG_MAP
  43. END_MESSAGE_MAP()
  44. /////////////////////////////////////////////////////////////////////////////
  45. // SetClientIPDlg message handlers
  46. BOOL SetClientIPDlg::OnInitDialog()
  47. {
  48. CDialog::OnInitDialog();
  49. // TODO: Add extra initialization here
  50. if(m_mode==1)
  51. {
  52. SetWindowText("×ÊÁÏÐÞ¸Ä");
  53. ((CEdit*)GetDlgItem(IDC_name))->SetReadOnly();
  54. // GetDlgItem(IDC_enterprisename)->EnableWindow(0);
  55. CRstClientIP rsSt;
  56. rsSt.m_strFilter ="name='"+m_name+"'";
  57. rsSt.Open();
  58. if(!rsSt.IsEOF())
  59. {
  60. m_name=rsSt.m_name ;
  61. m_remark=rsSt.m_bz ;
  62. m_oldenterprisename=m_enterprisename=rsSt.m_enterprisename ;
  63. m_branchname=rsSt.m_branchname ;
  64. if(rsSt.m_bmain=="×ܵê")
  65. m_check1=1;
  66. else
  67. m_check1=0;
  68. }
  69. rsSt.Close();
  70. }
  71. UpdateData(false);
  72. CenterWindow(g_pMainWnd);
  73. return TRUE; // return TRUE unless you set the focus to a control
  74. // EXCEPTION: OCX Property Pages should return FALSE
  75. }
  76. void SetClientIPDlg::OnOK()
  77. {
  78. // TODO: Add extra validation here
  79. }
  80. BOOL SetClientIPDlg::IsAccountExist(CString account)
  81. {
  82. CRecordset myset(&g_db);
  83. CString sql="select count(*) as cot from clientip where [name]='"+account+"'";
  84. myset.Open (CRecordset::forwardOnly, sql);
  85. myset.GetFieldValue ("cot", sql);
  86. myset.Close();
  87. if(atoi(sql))return 1;
  88. return 0;
  89. }
  90. BOOL SetClientIPDlg::IsEnterPriseExist(CString name)
  91. {
  92. CRecordset myset(&g_db);
  93. CString sql="select count(*) as cot from clientip where [branchname]='"+name+"'";
  94. myset.Open (CRecordset::forwardOnly, sql);
  95. myset.GetFieldValue ("cot", sql);
  96. myset.Close();
  97. if(atoi(sql))return 1;
  98. return 0;
  99. }