// DelArgueDlg.cpp : 實(shí)現(xiàn)文件
//

#include "stdafx.h"
#include "BankSystem.h"
#include "DelArgueDlg.h"
#include ".\delarguedlg.h"


// DelArgueDlg 對(duì)話框

IMPLEMENT_DYNAMIC(DelArgueDlg, CDialog)
DelArgueDlg::DelArgueDlg(CWnd* pParent /*=NULL*/)
	: CDialog(DelArgueDlg::IDD, pParent)
{
}

DelArgueDlg::~DelArgueDlg()
{
}

void DelArgueDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_LIST1, List3);
}


BEGIN_MESSAGE_MAP(DelArgueDlg, CDialog)
	ON_WM_SHOWWINDOW()
	ON_LBN_SELCHANGE(IDC_LIST1, OnLbnSelchangeList1)
	ON_BN_CLICKED(IDC_Del, OnBnClickedDel)
	ON_BN_CLICKED(IDC_Cancel, OnBnClickedCancel)
END_MESSAGE_MAP()


// DelArgueDlg 消息處理程序

void DelArgueDlg::OnShowWindow(BOOL bShow, UINT nStatus)
{
	CDialog::OnShowWindow(bShow, nStatus);

	// TODO: 在此處添加消息處理程序代碼
	CString strQuery="SELECT * FROM argue";
	


	try{
		pRst=pConn->Execute(_bstr_t(strQuery),NULL,adCmdText);
	}
	catch(_com_error &e)
	{
		MessageBox(e.ErrorMessage()); 
		return ;
	}

	while(!pRst->rsEOF)//將查詢到的數(shù)據(jù)加到列表框咯。
	{
		CString str=""+(_bstr_t)pRst->GetCollect("uname")+"  "+(_bstr_t)pRst->GetCollect("topic")+"  "+(_bstr_t)pRst->GetCollect("content")+"";
		
		List3.AddString(str);
		pRst->MoveNext();
	}
}

void DelArgueDlg::OnLbnSelchangeList1()
{
	// TODO: 在此添加控件通知處理程序代碼
	
}

void DelArgueDlg::OnBnClickedDel()
{
	// TODO: 在此添加控件通知處理程序代碼
	CString strQuery="SELECT * FROM argue";

	pRst.CreateInstance("ADODB.Recordset");
	pRst->Open(_bstr_t(strQuery),_variant_t((IDispatch*)pConn,true),adOpenStatic,adLockOptimistic,adCmdText);
		
	
	
	pRst->MoveFirst();
	int index=List3.GetCurSel();
	//index--;
	while(index)
	{
		pRst->MoveNext();
		index--;
	}

	try
	{
		pRst->Delete(adAffectCurrent);
		pRst->Update();
	}
	catch(_com_error &e)
	{
		MessageBox(e.ErrorMessage()); 
		return ;
	}

	AfxMessageBox("投訴撤銷成功");

	index=List3.GetCount();
	
	while(index>=0)
	{
		List3.DeleteString(index);
		index--;
	}

	
	//刷新列表
	strQuery="SELECT * FROM argue";
	
	try{
		pRst=pConn->Execute(_bstr_t(strQuery),NULL,adCmdText);
	}
	catch(_com_error &e)
	{
		MessageBox(e.ErrorMessage()); 
		return ;
	}

	while(!pRst->rsEOF)//將查詢到的數(shù)據(jù)加到列表框咯。
	{
		CString str=""+(_bstr_t)pRst->GetCollect("uname")+"  "+(_bstr_t)pRst->GetCollect("topic")+"  "+(_bstr_t)pRst->GetCollect("content")+"";
		
		List3.AddString(str);
		pRst->MoveNext();
	}
	
}

void DelArgueDlg::OnBnClickedCancel()
{
	// TODO: 在此添加控件通知處理程序代碼
	OnOK();
}