dlgrequest.cpp

数据库服务

// DlgRequest.cpp : implementation file
//

#include "stdafx.h"
#include "NServer.h"
#include "DlgRequest.h"
#include "RequestRst.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgRequest dialog


CDlgRequest::CDlgRequest(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgRequest::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgRequest)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CDlgRequest::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgRequest)
	DDX_Control(pDX, IDC_LIST_MAIN, m_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgRequest, CDialog)
	//{{AFX_MSG_MAP(CDlgRequest)
	ON_BN_CLICKED(IDC_BTN_REXIT, OnBtnRexit)
	ON_BN_CLICKED(IDC_BTN_DOOK, OnBtnDook)
	ON_BN_CLICKED(IDC_BTN_DONO, OnBtnDono)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgRequest message handlers

void CDlgRequest::OnBtnRexit() 
{
	CDialog::OnCancel();	
}

BOOL CDlgRequest::OnInitDialog() 
{
	CDialog::OnInitDialog();	
	
	m_list.ModifyStyle(0, LVS_REPORT | LVS_SHOWSELALWAYS | LVS_SINGLESEL);
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | LVS_EX_HEADERDRAGDROP);
	
	m_list.InsertColumn(0,"编号",LVCFMT_LEFT,70);
	m_list.InsertColumn(1,"用户编号",LVCFMT_LEFT,70);
	m_list.InsertColumn(2,"用户名称",LVCFMT_LEFT,100);
	m_list.InsertColumn(3,"申请空间大小",LVCFMT_LEFT,100);
	m_list.InsertColumn(4,"是否同意",LVCFMT_LEFT,100);

	LoadRequest();

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDlgRequest::LoadRequest()
{
	try{
		CRequestRst m_ReqRst;

		if(m_ReqRst.IsOpen())
			m_ReqRst.Close();

		m_ReqRst.Open();
		while(!m_ReqRst.IsEOF()){
			
			CString tempstr = "";
			tempstr.Format("%d",m_ReqRst.m_RequestIndex);
			int nItem = m_list.InsertItem(0,tempstr);
			tempstr.Format("%d",m_ReqRst.m_RequestUserCode);
			m_list.SetItemText(nItem,1,tempstr);
			m_list.SetItemText(nItem,2,m_ReqRst.m_RequestUserName);
			tempstr.Format("%d",m_ReqRst.m_RequestSpace);
			m_list.SetItemText(nItem,3,tempstr);
			if(m_ReqRst.m_HasAgree == 0)
				m_list.SetItemText(nItem,4,"未处理");
			else if(m_ReqRst.m_HasAgree == 2)
				m_list.SetItemText(nItem,4,"否");
			else if(m_ReqRst.m_HasAgree == 1)
				m_list.SetItemText(nItem,4,"是");

			m_ReqRst.MoveNext();
		}

		m_ReqRst.Close();
	}
	catch(...){
	}
}	

void CDlgRequest::OnBtnDook() 
{
	int nItem = m_list.GetNextItem(-1, LVNI_SELECTED);
	if (nItem < 0)	return;

	CString tempstr = "";
	tempstr = m_list.GetItemText(nItem,0);
	int pNum = atoi(tempstr);
	if(pNum <= 0) return;	

	try{
		CRequestRst m_ReqRst;

		if(m_ReqRst.IsOpen())
			m_ReqRst.Close();

		CString strFt = "";
		strFt.Format("RequestIndex = %d" , pNum);
		m_ReqRst.m_strFilter = strFt;

		m_ReqRst.Open();
		if(!m_ReqRst.IsEOF()){
			m_ReqRst.Edit();
			m_ReqRst.m_HasAgree = 1;
			m_ReqRst.Update();
			m_list.SetItemText(nItem,4,"是");
		}

		m_ReqRst.Close();
	}
	catch(...){
	}			
}

void CDlgRequest::OnBtnDono() 
{
	int nItem = m_list.GetNextItem(-1, LVNI_SELECTED);
	if (nItem < 0)	return;

	CString tempstr = "";
	tempstr = m_list.GetItemText(nItem,0);
	int pNum = atoi(tempstr);
	if(pNum <= 0) return;	

	try{
		CRequestRst m_ReqRst;

		if(m_ReqRst.IsOpen())
			m_ReqRst.Close();

		CString strFt = "";
		strFt.Format("RequestIndex = %d" , pNum);
		m_ReqRst.m_strFilter = strFt;

		m_ReqRst.Open();
		if(!m_ReqRst.IsEOF()){
			m_ReqRst.Edit();
			m_ReqRst.m_HasAgree = 2;
			m_ReqRst.Update();
			m_list.SetItemText(nItem,4,"否");
		}

		m_ReqRst.Close();
	}
	catch(...){
	}					
}