// SetClientIPDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LYFZIPManage.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_ip = _T("");
	m_oldenterprisename = _T("");
	m_mode=0;
	m_name2 = _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);
	DDX_Text(pDX, IDC_name2, m_name2);
	//}}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);
		MyLock lock("xiaoaccessdbmsg");
		CRstClientIP rsSt;
		rsSt.m_strFilter ="name='"+m_name+"'";
		rsSt.Open();
		if(!rsSt.IsEOF())
		{
			m_name=rsSt.m_name ;
			m_name2=rsSt.m_name2 ;
			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
	UpdateData();
	m_name.TrimLeft ();
	m_name.TrimRight ();
	m_name2.TrimLeft ();
	m_name2.TrimRight ();
	m_branchname.TrimLeft ();
	m_branchname.TrimRight ();

	if(m_name.IsEmpty () || m_branchname.IsEmpty ())
	{
		AfxMessageBox("*号项目为必填项目!");
		return;
	}
	CString sBranch;
	if(m_check1)
		sBranch="总店";
	else
		sBranch="分店";
	CString sql;
	if(m_mode==0)
	{
		if(IsAccountExist(m_name))
		{
			AfxMessageBox("此域名已存在!");
			return;
		}
		if(1)//m_enterprisename.IsEmpty ()==0 )
		{
			if(IsEnterPriseExist(m_branchname))
			{
				AfxMessageBox("此分店已存在!");
				return;
			}
		}

		CString date=CTime::GetCurrentTime ().Format ("%Y-%m-%d");
		CString date2=CTime::GetCurrentTime ().Format ("%Y%m%d%H%M%S");
		sql= "insert into clientip([enterprisename],[name],[name2],[bz],[applydate],[bmain],[branchname],[modifydate]) values(\
			 '"+m_enterprisename+"',\
			 '"+m_name+"',\
			 '"+m_name2+"',\
			 '"+m_remark+"',\
			 '"+date+"',\
			 '"+sBranch+"',\
			 '"+m_branchname+"',\
			 '"+date2+"')";  
	}
	else
	{
		CString date2=CTime::GetCurrentTime ().Format ("%Y%m%d%H%M%S");
		if(m_oldenterprisename!="" && m_oldenterprisename!=m_enterprisename)
		{
			sql= "update clientip set [enterprisename]='"+
				m_enterprisename+"' where [enterprisename]='"+m_oldenterprisename+"'"; 
			MyExecuteSQL(&g_db, sql);
		}
		sql= "update clientip set [bz]='"+
			m_remark+"',[name2]='"+m_name2+"',[bmain]='"+
			sBranch+"',[enterprisename]='"+m_enterprisename+"',[branchname]='"+
			m_branchname+"',[modifydate]='"+date2+"',[ip]='"+m_ip+"' where [name]='"+m_name+"'";
	}
	MyExecuteSQL(&g_db, sql);

	AfxMessageBox("保存成功!", MB_ICONINFORMATION);

	sql="delete from noregisterdomain where [name]='"+m_name+"'";
	MyExecuteSQL(&g_db, sql);

	CDialog::OnOK();
}

BOOL SetClientIPDlg::IsAccountExist(CString account)
{
	MyLock lock("xiaoaccessdbmsg");
	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)
{
	MyLock lock("xiaoaccessdbmsg");
	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;
}