lyfz_repos/经典版源码/旧的后台处理/LYFZMsgManage/LYFZSendMsg/SetPathDlg.cpp

// SetPathDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LYFZSendMsg.h"
#include "SetPathDlg.h"
#include "mysqldata.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern BOOL g_bLoadroad2clientarray;
/////////////////////////////////////////////////////////////////////////////
// SetPathDlg dialog IDC_psw


SetPathDlg::SetPathDlg(CWnd* pParent /*=NULL*/)
	: CDialog(SetPathDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(SetPathDlg)
	m_account = _T("");
	m_addr = _T("");
	m_name = _T("");
	m_phone = _T("");
	m_psw = _T("");
	m_qq = _T("");
	m_remark = _T("");
	m_signname = _T("【】");
	m_mode=0;
	m_check1 = 0;
	m_check2 = 0;
	//}}AFX_DATA_INIT
}

void SetPathDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(SetPathDlg)
	DDX_Text(pDX, IDC_account, m_account);
	DDX_Text(pDX, IDC_addr, m_addr);
	DDX_Text(pDX, IDC_name, m_name);
	DDX_Text(pDX, IDC_phone, m_phone);
	DDX_Text(pDX, IDC_psw, m_psw);
	DDX_Text(pDX, IDC_qq, m_qq);
	DDX_Text(pDX, IDC_remark, m_remark);
	DDX_Text(pDX, IDC_signname, m_signname);
	DDX_Check(pDX, IDC_CHECK1, m_check1);
	DDX_Check(pDX, IDC_CHECK2, m_check2);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(SetPathDlg, CDialog)
	//{{AFX_MSG_MAP(SetPathDlg)
	//}}AFX_MSG_MAP
	ON_BN_CLICKED(IDC_CHECK1, OnBnClickedCheck1)
	ON_BN_CLICKED(IDC_CHECK2, OnBnClickedCheck2)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// SetPathDlg message handlers

BOOL SetPathDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	// TODO: Add extra initialization here
 	if(m_mode==1)
	{
 		SetWindowText("客户资料修改");
MyLock lock("xiaoaccessdbmsg");
	CRstClientInfo rsSt;
	rsSt.m_strFilter ="account='"+m_account+"'";
	rsSt.Open();
	if(!rsSt.IsEOF())
	{
		m_name=rsSt.m_name ;
		m_phone=rsSt.m_phone ;
		m_qq=rsSt.m_qq ;
		m_addr=rsSt.m_addr ;
		m_remark=rsSt.m_remark ;
		m_psw=rsSt.m_psw;
		m_signname=rsSt.m_signname;	
		if(atoi(rsSt.m_road)==1)
			m_check1=1;
		if(atoi(rsSt.m_road)==2)
			m_check2=1;
	}
	rsSt.Close();
	if(m_signname=="")m_signname = _T("【】");
	}
	else
	{
	 
		CString account;
		while( IsAccountExist(account) || account.IsEmpty () )
		{
		  while(account.GetLength ()<6)
		  {
			CString temp;
			temp.Format ("%d", ::GetTickCount ());
			account+=temp;
		  }
		  account=account.Right (6);
		}
		m_account=account;
	}
	UpdateData(false);
	CenterWindow(g_pMainWnd);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
extern int CheckPhoneType(CString phoneno);
void SetPathDlg::OnOK() 
{
	// TODO: Add extra validation here
 	UpdateData();
	m_account.TrimLeft ();
	m_account.TrimRight ();
	m_name.TrimLeft ();
	m_name.TrimRight ();
	m_signname.TrimLeft ();
	m_signname.TrimRight ();
	if(m_account.IsEmpty ()||m_name.IsEmpty ()||m_psw.IsEmpty ())
	{
		AfxMessageBox("*号项目为必填项目!");
		return;
	}

	if(m_signname.GetLength ()<4)
	{
		m_signname="【】";
		AfxMessageBox("签名不合规范!");
			UpdateData(0);
		return;
	}
	if(m_signname.Left (2)!="【" || m_signname.Right (2)!="】")
	{
		m_signname="【】";
		AfxMessageBox("签名不合规范!");
			UpdateData(0);
		return;
	}
	CString sql;
	CString road="0";
	if(m_check1)
		road="1";
	if(m_check2)
		road="2";
	if(m_mode==0)
	{
	if(IsAccountExist(m_account))
	{
		AfxMessageBox("此账号已存在!");
		return;
	}
	CString date=CTime::GetCurrentTime ().Format ("%Y-%m-%d");
sql= "insert into clientinfo([account],[name],[psw],[phone],\
[qq],[addr],[remark],[applydate],[balance],[signname],[road]) values(\
'"+m_account+"',\
'"+m_name+"',\
'"+m_psw+"',\
'"+m_phone+"',\
'"+m_qq+"',\
'"+m_addr+"',\
'"+m_remark+"',\
'"+date+"','0','"+m_signname+"','"+road+"')";  
	}
	else
	{
sql= "update clientinfo set [name]='"+m_name+"',[phone]='"+m_phone+"',\
[qq]='"+m_qq+"',[addr]='"+m_addr+"',[psw]='"+m_psw+"',[remark]='"+m_remark+"',[signname]='"+m_signname+"',[road]='"+road+"' \
where [account]='"+m_account+"'";
	}
  MyExecuteSQL(&g_db, sql);
  if(m_check1)g_bLoadroad2clientarray=1;
  if(m_check2)g_bLoadroad2clientarray=1;
	AfxMessageBox("保存成功!", MB_ICONINFORMATION);
	CDialog::OnOK();
}

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

void SetPathDlg::OnBnClickedCheck1()
{
	// TODO: 在此添加控件通知处理程序代码
	 UpdateData();
	 if(m_check1 && m_check2)
	 {
		 m_check2=0;
		 UpdateData(0);
	 }
}

void SetPathDlg::OnBnClickedCheck2()
{
	// TODO: 在此添加控件通知处理程序代码
	 UpdateData();
	 if(m_check1 && m_check2)
	 {
		 m_check1=0;
		 UpdateData(0);
	 }
}

void SetPathDlg::OnBnClickedOk()
{
	// TODO: 在此添加控件通知处理程序代码
	OnOK();
}