// InputCard3Dlg.cpp : implementation file
//

#include "stdafx.h"
#include "ylgl.h"
#include "InputCard3Dlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// InputCard3Dlg dialog IDC_STATIC3
InputCard3Dlg::InputCard3Dlg(CWnd* pParent /*=NULL*/)
	: CDialog(InputCard3Dlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(InputCard3Dlg)
	m_name = _T("");
	m_no = _T("");
	m_card2no1 = _T("");
	m_card2no2 = _T("");
	m_card2no3 = _T("");
	m_card2no4 = _T("");
	m_card2no5 = _T("");
	m_mode=0;
	//}}AFX_DATA_INIT
}


void InputCard3Dlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(InputCard3Dlg)
	DDX_Text(pDX, IDC_EDITname, m_name);
	DDX_Text(pDX, IDC_EDITno, m_no);
	DDX_Text(pDX, IDC_EDITcard2no1, m_card2no1);
	DDX_Text(pDX, IDC_EDITcard2no2, m_card2no2);
	DDX_Text(pDX, IDC_EDITcard2no3, m_card2no3);
	DDX_Text(pDX, IDC_EDITcard2no4, m_card2no4);
	DDX_Text(pDX, IDC_EDITcard2no5, m_card2no5);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// InputCard3Dlg message handlers

BOOL InputCard3Dlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void InputCard3Dlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	m_card2no1.TrimLeft ();
	m_card2no1.TrimRight ();
	m_card2no2.TrimLeft ();
	m_card2no2.TrimRight ();
	m_card2no3.TrimLeft ();
	m_card2no3.TrimRight ();
	m_card2no4.TrimLeft ();
	m_card2no4.TrimRight ();
	m_card2no5.TrimLeft ();
	m_card2no5.TrimRight ();

	int length=atol(g_cominfoarray.ElementAt (0).ElementAt (55));
	if(m_mode)
	{
		if(m_card2no1.IsEmpty () || m_card2no2.IsEmpty () || m_card2no3.IsEmpty () || m_card2no4.IsEmpty () || m_card2no5.IsEmpty () )
		{
			AfxMessageBox("子卡号不能为空!", MB_ICONINFORMATION);return;
		}	
		if(m_card2no1==m_card2no2 || m_card2no1==m_card2no3 || m_card2no1==m_card2no4 || m_card2no1==m_card2no5 || m_card2no2==m_card2no3 || m_card2no2==m_card2no4 || m_card2no2==m_card2no5 || m_card2no3==m_card2no4 || m_card2no3==m_card2no5 || m_card2no4==m_card2no5)
		{
			AfxMessageBox("子卡号不能相同!", MB_ICONINFORMATION);return;
		}
	}
	else
	{
		if( (m_card2no1==m_card2no2 && m_card2no1!="") || (m_card2no1==m_card2no3 && m_card2no1!="") || (m_card2no1==m_card2no4 && m_card2no1!="") || (m_card2no1==m_card2no5 && m_card2no1!="") || (m_card2no2==m_card2no3 && m_card2no2!="") || (m_card2no2==m_card2no4 && m_card2no2!="") || (m_card2no2==m_card2no5 && m_card2no2!="") || (m_card2no3==m_card2no4 && m_card2no3!="") || (m_card2no3==m_card2no5 && m_card2no3!="") || (m_card2no4==m_card2no5 && m_card2no4!=""))
		{
			AfxMessageBox("子卡号不能相同!", MB_ICONINFORMATION);return;
		}
	}

	CString sql;

	{
	sql="select count(*) as cot from membercard3 where ";
	CString temp;
	if(!m_card2no1.IsEmpty ())
	    temp+="or [card2no]='"+m_card2no1+"' ";
	if(!m_card2no2.IsEmpty ())
	    temp+="or [card2no]='"+m_card2no2+"' ";
	if(!m_card2no3.IsEmpty ())
	    temp+="or [card2no]='"+m_card2no3+"' ";
	if(!m_card2no4.IsEmpty ())
	    temp+="or [card2no]='"+m_card2no4+"' ";
	if(!m_card2no5.IsEmpty ())
	    temp+="or [card2no]='"+m_card2no5+"' ";
	temp.TrimLeft ("or");
	temp.TrimRight ();
	if(temp.IsEmpty ())return;
	sql+=temp;
	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
	if(g_ncount)
	{
		AfxMessageBox("此子卡发出尚未收回,请重新填写子卡号!", MB_ICONINFORMATION);return;
	}
	if(!m_card2no1.IsEmpty ())
	   sql="***insert into membercard3([memberno],[card2no],[date])values('"+m_no+"','"+m_card2no1+"','"+g_date+"')";
	if(!m_card2no2.IsEmpty ())
	   sql+="***insert into membercard3([memberno],[card2no],[date])values('"+m_no+"','"+m_card2no2+"','"+g_date+"')";
	if(!m_card2no3.IsEmpty ())
	   sql+="***insert into membercard3([memberno],[card2no],[date])values('"+m_no+"','"+m_card2no3+"','"+g_date+"')";
	if(!m_card2no4.IsEmpty ())
	   sql+="***insert into membercard3([memberno],[card2no],[date])values('"+m_no+"','"+m_card2no4+"','"+g_date+"')";
	if(!m_card2no5.IsEmpty ())
	   sql+="***insert into membercard3([memberno],[card2no],[date])values('"+m_no+"','"+m_card2no5+"','"+g_date+"')";
	}
	sql.TrimLeft ("***");
	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
    AfxMessageBox("保存成功!", MB_ICONINFORMATION);
	CDialog::OnOK();
}

BOOL InputCard3Dlg::PreTranslateMessage(MSG* pMsg) 
{
	// TODO: Add your specialized code here and/or call the base class
	if(pMsg->message==WM_KEYDOWN)
	{
		switch (pMsg->wParam)
		{
		case VK_RETURN:	
			return 1;
		}
	}
	return CDialog::PreTranslateMessage(pMsg);
}