// SBRYMANAGE.cpp : implementation file
//

#include "stdafx.h"
#include "SMS.h"
#include "SBRYMANAGE.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSBRYMANAGE dialog


CSBRYMANAGE::CSBRYMANAGE(CWnd* pParent /*=NULL*/)
	: CDialog(CSBRYMANAGE::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSBRYMANAGE)
	m_changhao = _T("");
	m_name = _T("");
	//}}AFX_DATA_INIT
}


void CSBRYMANAGE::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSBRYMANAGE)
	DDX_Control(pDX, IDC_LIST1, m_clist);
	DDX_Text(pDX, IDC_EDIT1, m_changhao);
	DDX_Text(pDX, IDC_EDIT2, m_name);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CSBRYMANAGE message handlers

void CSBRYMANAGE::OnButton1() 
{
		UpdateData(true);
		m_changhao.TrimRight(" ");
		m_name.TrimRight(" ");

   
    	
		if ( ""==m_changhao)
	{
		AfxMessageBox(_T("請(qǐng)輸入長(zhǎng)號(hào)"), MB_ICONEXCLAMATION);
        return;
	}
    

			if ( ""==m_name)
	{
		AfxMessageBox(_T("請(qǐng)輸入姓名"), MB_ICONEXCLAMATION);
        return;
	}

	_variant_t strQuery;


strQuery="insert reportp (name,code) values('" +m_name+"','"+m_changhao+"')";
if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) 
{	
			AfxMessageBox(_T("添加記錄成功！"), MB_ICONINFORMATION);
}



	else 
	{
		 AfxMessageBox(_T("添加記錄失敗！"), MB_ICONEXCLAMATION);
	}
	// TODO: Add your control notification handler code here
	
	
	
	
	
	// TODO: Add your control notification handler code here
	
}

void CSBRYMANAGE::OnButton2() 
{	 CString value;
	
     	value = m_clist.GetItemText(IndexInFieldList, 1);
	

		_variant_t strQuery;
		
	{strQuery="delete from reportp where code='"+value+"'";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
    AfxMessageBox("刪除用戶成功", MB_ICONEXCLAMATION);
	}
	
	// TODO: Add your control notification handler code here
	
}

BOOL CSBRYMANAGE::OnInitDialog()
{
   CDialog::OnInitDialog();
   	m_clist.SetExtendedStyle( LVS_EX_GRIDLINES | LVS_EX_FULLROWSELECT );
   int nColumnCount = m_clist.GetHeaderCtrl()->GetItemCount();
	
	for (int i=0;i < nColumnCount;i++)
	{
		m_clist.DeleteColumn(0);
	}
	
	m_clist.DeleteAllItems();
	
	char *title[] = 
	{
		"姓名",
		"長(zhǎng)號(hào)"
		
		
	
	};

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

	for(i = 0; i < 2; i++ )
	{
		m_clist.InsertColumn( i, title[i], LVCFMT_LEFT, nWidth[i], 0 );
	}
	
    CString strText;
    _variant_t Holder, strQuery;
    strQuery = "select * from reportp ";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	int iCount = theApp.m_pADOSet->GetRecordCount();

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

    theApp.m_pADOSet->MoveNext();
	}
	return true;
}

void CSBRYMANAGE::OnButton3() 
{ int nColumnCount = m_clist.GetHeaderCtrl()->GetItemCount();
	
	for (int i=0;i < nColumnCount;i++)
	{
		m_clist.DeleteColumn(0);
	}
	
	m_clist.DeleteAllItems();
	
	char *title[] = 
	{
		"姓名",
		"長(zhǎng)號(hào)"
		
		
	
	};

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

	for(i = 0; i < 2; i++ )
	{
		m_clist.InsertColumn( i, title[i], LVCFMT_LEFT, nWidth[i], 0 );
	}
	 CString strText;
    _variant_t Holder, strQuery;
    strQuery = "select * from reportp ";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	int iCount = theApp.m_pADOSet->GetRecordCount();
	theApp.m_pADOSet->MoveFirst();
    for ( i=0;i<iCount;i++)
	{Holder=theApp.m_pADOSet->GetCollect("name");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	m_clist.InsertItem( i, strText );
    Holder=theApp.m_pADOSet->GetCollect("code");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	m_clist.SetItemText( i, 1, strText );

    theApp.m_pADOSet->MoveNext();
	}
	// TODO: Add your control notification handler code here
	
}

void CSBRYMANAGE::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	POSITION pos;
	pos = m_clist.GetFirstSelectedItemPosition();
	IndexInFieldList = m_clist.GetNextSelectedItem(pos);
	// TODO: Add your control notification handler code here
	
	*pResult = 0;
}