// BUILDG.cpp : implementation file
//

#include "stdafx.h"
#include "SMS.h"
#include "BUILDG.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBUILDG dialog


CBUILDG::CBUILDG(CWnd* pParent /*=NULL*/)
	: CDialog(CBUILDG::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBUILDG)
	m_groupname = _T("");
	//}}AFX_DATA_INIT
}


void CBUILDG::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBUILDG)
	DDX_Control(pDX, IDC_LIST1, m_clist);
	DDX_Text(pDX, IDC_EDIT1, m_groupname);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBUILDG, CDialog)
	//{{AFX_MSG_MAP(CBUILDG)
	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()

/////////////////////////////////////////////////////////////////////////////
// CBUILDG message handlers

void CBUILDG::OnOK() 
{  
	_variant_t strQuery;
	UpdateData(true);
   
  
		if ( ""==m_groupname)
	{
		AfxMessageBox(_T("請輸入組名"), MB_ICONEXCLAMATION);
        return;
	}
   

	
strQuery="insert gname values('" +m_groupname+"','"+theApp.m_sCurrentUser+"')";
if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) 
{	refersh();
			AfxMessageBox(_T("組建立成功！"), MB_ICONINFORMATION);
			return;
}



	else 
	{
		 AfxMessageBox(_T("組建立失敗！"), MB_ICONEXCLAMATION);
		 return;
	}
	// TODO: Add your control notification handler code here
	
	
	// TODO: Add extra validation here
	
	CDialog::OnOK();
}

void CBUILDG::OnCancel() 
{
    m_groupname="";
	UpdateData(false);
	// TODO: Add extra cleanup here
	
	
}

BOOL CBUILDG::OnInitDialog() 
{
	CDialog::OnInitDialog();
		m_clist.SetExtendedStyle( LVS_EX_GRIDLINES | LVS_EX_FULLROWSELECT );
         int nColumnCount = m_clist.GetHeaderCtrl()->GetItemCount();
	
       _variant_t strQuery,Holder;
     	strQuery="select *from gname";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
    iCount=theApp.m_pADOSet->GetRecordCount();

 
	 
	
	for (int i=0;i < nColumnCount;i++)
	{
		m_clist.DeleteColumn(0);
	}
	
	m_clist.DeleteAllItems();
	
	char *title[] = 
	{
		"用戶組名",
		"組建立人",
	
	};

	int nWidth[2] = { 200, 150};

	for(i = 0; i < 2; i++ )
	{
		m_clist.InsertColumn( i, title[i], LVCFMT_LEFT, nWidth[i], 0 );
	}
     strQuery = "select * from gname ";
	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("groupname");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	m_clist.InsertItem( i, strText );
    Holder=theApp.m_pADOSet->GetCollect("foundperson");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	m_clist.SetItemText( i, 1, 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 CBUILDG::OnButton2() 
{CDialog::OnCancel();
	// TODO: Add your control notification handler code here
	
}

void CBUILDG::OnButton1() 
{
	
	     CString value;
     	value = m_clist.GetItemText(IndexInFieldList, 0);
		_variant_t strQuery;
       strQuery="delete from gname where groupname='"+value+"'";
		if (""==value)
		{
		AfxMessageBox(_T("請選擇要刪除的用戶組"), 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 CBUILDG::refersh()
{	
	_variant_t strQuery,Holder;
	
	strQuery = "select * from gname ";
	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("groupname");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	m_clist.InsertItem( i, strText );
    Holder=theApp.m_pADOSet->GetCollect("foundperson");
	strText=(Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
	m_clist.SetItemText( i, 1, strText );


    theApp.m_pADOSet->MoveNext();
	}



	}

	else {return;}


}

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