// SetClientIPDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LYFZSendMsg.h"
#include "SetClientIPDlg.h"
#include "mysqldata.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// SetClientIPDlg dialog IDC_branchname
SetClientIPDlg::SetClientIPDlg(CWnd* pParent /*=NULL*/)
	: CDialog(SetClientIPDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(SetClientIPDlg)
	m_name = _T(".ly.com");
	m_remark = _T("");
	m_enterprisename = _T("");
	m_check1 = 0;
	m_branchname = _T("");
	m_oldenterprisename = _T("");
	m_mode=0;
	m_ip = _T("");
	//}}AFX_DATA_INIT
}

void SetClientIPDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(SetClientIPDlg)
	DDX_Text(pDX, IDC_name, m_name);
	DDX_Text(pDX, IDC_remark, m_remark);
	DDX_Text(pDX, IDC_enterprisename, m_enterprisename);
	DDX_Check(pDX, IDC_CHECK1, m_check1);
	DDX_Text(pDX, IDC_branchname, m_branchname);
	DDX_Text(pDX, IDC_EDIT1, m_ip);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(SetClientIPDlg, CDialog)
	//{{AFX_MSG_MAP(SetClientIPDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// SetClientIPDlg message handlers

BOOL SetClientIPDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	// TODO: Add extra initialization here
 	if(m_mode==1)
	{
 		SetWindowText("×ÊÁÏÐÞ¸Ä");
		((CEdit*)GetDlgItem(IDC_name))->SetReadOnly();
 
	//	GetDlgItem(IDC_enterprisename)->EnableWindow(0);
	CRstClientIP rsSt;
	rsSt.m_strFilter ="name='"+m_name+"'";
	rsSt.Open();
	if(!rsSt.IsEOF())
	{
		m_name=rsSt.m_name ;
		m_remark=rsSt.m_bz ;
		m_oldenterprisename=m_enterprisename=rsSt.m_enterprisename ;
		m_branchname=rsSt.m_branchname ;
		if(rsSt.m_bmain=="×ܵê")
			m_check1=1;
		else
			m_check1=0;
	}
	rsSt.Close();
	}
	UpdateData(false);
	CenterWindow(g_pMainWnd);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void SetClientIPDlg::OnOK() 
{
	// TODO: Add extra validation here
  
}

BOOL SetClientIPDlg::IsAccountExist(CString account)
{
	CRecordset myset(&g_db);
	CString	sql="select count(*) as cot from clientip where [name]='"+account+"'"; 
	myset.Open (CRecordset::forwardOnly, sql);
	myset.GetFieldValue ("cot", sql);
	myset.Close();
	if(atoi(sql))return 1;
	return 0;
}

BOOL SetClientIPDlg::IsEnterPriseExist(CString name)
{
	CRecordset myset(&g_db);
	CString	sql="select count(*) as cot from clientip where [branchname]='"+name+"'"; 
	myset.Open (CRecordset::forwardOnly, sql);
	myset.GetFieldValue ("cot", sql);
	myset.Close();
	if(atoi(sql))return 1;
	return 0;
}