// APPANDN.cpp : implementation file
//

#include "stdafx.h"
#include "SMS.h"
#include "APPANDN.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAPPANDN dialog


CAPPANDN::CAPPANDN(CWnd* pParent /*=NULL*/)
	: CDialog(CAPPANDN::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAPPANDN)
	m_code = _T("");
	m_name = _T("");
	m_makegroup = _T("");
	//}}AFX_DATA_INIT
}


void CAPPANDN::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAPPANDN)
	DDX_Control(pDX, IDC_LIST1, m_clist);
	DDX_Text(pDX, IDC_EDIT1, m_code);
	DDX_Text(pDX, IDC_EDIT2, m_name);
	DDX_CBString(pDX, IDC_COMBO1, m_makegroup);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAPPANDN, CDialog)
	//{{AFX_MSG_MAP(CAPPANDN)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAPPANDN message handlers

void CAPPANDN::OnOK() 
{
	// TODO: Add extra validation here
		UpdateData(true);
	    m_code.TrimRight(" ");
		m_name.TrimRight(" ");
		m_makegroup.TrimRight(" ");

    	if ( ""==m_code)
	{
		AfxMessageBox(_T("請輸入長號(hào)"), MB_ICONEXCLAMATION);
        return;
	}
    	
		if ( ""==m_name)
	{
		AfxMessageBox(_T("請輸入姓名"), MB_ICONEXCLAMATION);
        return;
	}
    

			if ( ""==m_makegroup)
	{
		AfxMessageBox(_T("請選擇用戶組"), MB_ICONEXCLAMATION);
        return;
	}

_variant_t strQuery;


strQuery="insert guser values('" +m_code+"','"+m_name+"','"+m_makegroup+"')";
if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) 
{	
	 m_clist.InsertItem( iCount, m_code );
	m_clist.SetItemText( iCount, 1, m_name );
    m_clist.SetItemText( iCount, 2, m_makegroup );

    iCount++;		
	
	
	AfxMessageBox(_T("添加記錄成功！"), MB_ICONINFORMATION);
			return;
}



	else 
	{
		 AfxMessageBox(_T("添加記錄失敗！"), MB_ICONEXCLAMATION);
		 return;
	}


	CDialog::OnOK();
}

BOOL CAPPANDN::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_clist.SetExtendedStyle( LVS_EX_GRIDLINES | LVS_EX_FULLROWSELECT );
   int nColumnCount = m_clist.GetHeaderCtrl()->GetItemCount();
		CComboBox* pComb=(CComboBox*)this->GetDlgItem(IDC_COMBO1);
    _variant_t strQuery,Holder;
	strQuery="select *from gname";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
    iCount=theApp.m_pADOSet->GetRecordCount();
	 if (iCount>0)
	{
		 theApp.m_pADOSet->MoveFirst();
    for (int i=0;i<iCount;i++)
	{Holder=theApp.m_pADOSet->GetCollect("groupname");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	pComb->AddString(strText);
    theApp.m_pADOSet->MoveNext();
	}
    
	}
 
	 
	
	for (int i=0;i < nColumnCount;i++)
	{
		m_clist.DeleteColumn(0);
	}
	
	m_clist.DeleteAllItems();
	
	char *title[] = 
	{
		"手機(jī)長號(hào)",
		"姓名",
		"用戶組"	
	};

	int nWidth[3] = { 100, 100,150};

	for(i = 0; i < 3; i++ )
	{
		m_clist.InsertColumn( i, title[i], LVCFMT_LEFT, nWidth[i], 0 );
	}
   strQuery = "select * from guser ";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
    iCount = theApp.m_pADOSet->GetRecordCount();
    if (iCount>0)
    {for (i=0;i<iCount;i++)
	{Holder=theApp.m_pADOSet->GetCollect("gmobilenumber");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	m_clist.InsertItem( i, strText );
    Holder=theApp.m_pADOSet->GetCollect("guser");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	m_clist.SetItemText( i, 1, strText );
	Holder=theApp.m_pADOSet->GetCollect("gname");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	m_clist.SetItemText( i, 2, strText );
    theApp.m_pADOSet->MoveNext();
	}
	}


	// 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 CAPPANDN::OnCancel() 
{
	// TODO: Add extra cleanup here
	m_code="";
	m_name="";
	m_makegroup="";

		UpdateData(false);
}

void CAPPANDN::OnButton2() 
{	CDialog::OnCancel();
	// TODO: Add your control notification handler code here
	
}

void CAPPANDN::OnButton1() 
{       CString value;
     	value = m_clist.GetItemText(IndexInFieldList, 0);
		_variant_t strQuery;
       strQuery="delete from guser where gmobilenumber='"+value+"'";
		if (""==value)
		{
		AfxMessageBox(_T("請選擇要?jiǎng)h除的用戶"), MB_ICONEXCLAMATION);

        return; 
		}
		

   else if(theApp.ADOExecute(theApp.m_pADOSet, strQuery))
    
   { refersh();

	 AfxMessageBox("刪除用戶成功", MB_ICONEXCLAMATION);
     return;

	}

 else{
		AfxMessageBox(_T("刪除用戶失敗"), MB_ICONEXCLAMATION);
	return;
}
	
	// TODO: Add your control notification handler code here
	
}

void CAPPANDN::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here


	POSITION pos;
	pos = m_clist.GetFirstSelectedItemPosition();
	IndexInFieldList = m_clist.GetNextSelectedItem(pos);
	// TODO: Add your control notification handler code here
	


	*pResult = 0;
}

void CAPPANDN::refersh()
{	
	_variant_t strQuery,Holder;
	
	strQuery = "select * from guser ";
	m_clist.DeleteAllItems();
   
    
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	 iCount = theApp.m_pADOSet->GetRecordCount();
	if (iCount >0 )
	{

	 
    for (int i=0;i<iCount;i++)
	{Holder=theApp.m_pADOSet->GetCollect("gmobilenumber");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	m_clist.InsertItem( i, strText );
    Holder=theApp.m_pADOSet->GetCollect("guser");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	m_clist.SetItemText( i, 1, strText );
	Holder=theApp.m_pADOSet->GetCollect("gname");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	m_clist.SetItemText( i, 2, strText );

    theApp.m_pADOSet->MoveNext();
	}



	}

	else {return;}


}