dlglogmgt.cpp

数据库服务

// DlgLogMgt.cpp : implementation file
//

#include "stdafx.h"
#include "NServer.h"
#include "DlgLogMgt.h"
#include "LogRst.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgLogMgt dialog


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


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


BEGIN_MESSAGE_MAP(CDlgLogMgt, CDialog)
	//{{AFX_MSG_MAP(CDlgLogMgt)
	ON_BN_CLICKED(IDC_BTN_LOGDEL, OnBtnLogdel)
	ON_BN_CLICKED(IDC_BTN_LOGEXIT, OnBtnLogexit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgLogMgt message handlers

void CDlgLogMgt::OnBtnLogdel() 
{
	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{
		CLogRst dLog;
		if(dLog.IsOpen())
			dLog.Close();
		
		dLog.m_strFilter.Format("LogIndex = %d",pNum);
		dLog.Open();
		if(!dLog.IsEOF()){
			dLog.Delete();
			m_list.DeleteItem(nItem);
		}
		dLog.Close();
	}
	catch(...){;}
}

void CDlgLogMgt::OnBtnLogexit() 
{
	CDialog::OnCancel();	
}

BOOL CDlgLogMgt::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,200);
	m_list.InsertColumn(2,"用户编号",LVCFMT_LEFT,70);
	m_list.InsertColumn(3,"用户名称",LVCFMT_LEFT,100);
	m_list.InsertColumn(4,"内容",LVCFMT_LEFT,300);

	LoadLog();

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

void CDlgLogMgt::LoadLog()
{

	try{
		CLogRst dLog;
		if(dLog.IsOpen())
			dLog.Close();
		
		dLog.Open();
		while(!dLog.IsEOF()){
			CString tempstr = "";
			tempstr.Format("%d",dLog.m_LogIndex);
			int nItem = m_list.InsertItem(0,tempstr);
			m_list.SetItemText(nItem+1,1,dLog.m_LogTime);
			tempstr.Format("%d",dLog.m_ComeUserCode);
			m_list.SetItemText(nItem+1,2,tempstr);
			m_list.SetItemText(nItem+1,3,dLog.m_ComeUserName);
			m_list.SetItemText(nItem+1,4,dLog.m_LogContent);
			dLog.MoveNext();
		}
		dLog.Close();
	}
	catch(...){;}

	return;
}