dlgworklog.cpp

用VC编写的立体仓库的管理软件源程序和设计说明书。

// DlgWorkLog.cpp : implementation file
//

#include "stdafx.h"
#include "Manage_WH.h"
#include "DlgWorkLog.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgWorkLog dialog


CDlgWorkLog::CDlgWorkLog(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgWorkLog::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgWorkLog)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
	m_hIcon = AfxGetApp()->LoadIcon(IDI_MYICON);
}


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


BEGIN_MESSAGE_MAP(CDlgWorkLog, CDialog)
	//{{AFX_MSG_MAP(CDlgWorkLog)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST, OnDblclkList)
	ON_BN_CLICKED(IDC_CLEAR, OnClear)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgWorkLog message handlers

BOOL CDlgWorkLog::PreTranslateMessage(MSG* pMsg) 
{
	if (pMsg->message==WM_KEYDOWN && (pMsg->wParam==13 || pMsg->wParam==27))
		return TRUE;
	return CDialog::PreTranslateMessage(pMsg);
}

BOOL CDlgWorkLog::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	SetIcon(m_hIcon,TRUE);
	
	m_list.InsertColumn(0,"操作员");
	m_list.InsertColumn(1,"操作日期");
	m_list.InsertColumn(2,"操作内容");
	
	RECT rect;
	m_list.GetWindowRect(&rect);
	int wid = rect.right - rect.left;
	m_list.SetColumnWidth(0,wid/3);
	m_list.SetColumnWidth(1,wid/3);
	m_list.SetColumnWidth(2,wid/3);
	m_list.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);

	if (gstrPopedom == "超级用户")
		GetDlgItem(IDC_CLEAR)->EnableWindow(TRUE);
	else
		GetDlgItem(IDC_CLEAR)->EnableWindow(FALSE);
	Refresh();

	return TRUE;
}

void CDlgWorkLog::Refresh()
{
	m_list.DeleteAllItems();

	CAdoConnection cn;
	CAdoRecordSet rs;
	cn.OpenUDLFile(gstrConSQLSer);
	rs.SetAdoConnection(&cn);
	rs.Open(_T("select F_User,F_Date,F_What from T_System_Log"),adCmdText);
	if (rs.GetRecordCount() != 0)
	{
		int row = 0;
		CString strVal;
		rs.MoveFirst();
		while (!rs.IsEOF())
		{
			row = m_list.InsertItem(row,"");
			for (int i = 0; i < 3; i++)
			{
				rs.GetCollect(i,strVal);
				m_list.SetItemText(row,i,strVal);
			}			
			rs.MoveNext();
			row++;
		}
	}
	rs.Close();
	cn.Close();
}

void CDlgWorkLog::OnDblclkList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	int i = m_list.GetSelectionMark();

	GetDlgItem(IDC_USER)->SetWindowText(m_list.GetItemText(i,0));
	GetDlgItem(IDC_DATE)->SetWindowText(m_list.GetItemText(i,1));
	GetDlgItem(IDC_LOG )->SetWindowText(m_list.GetItemText(i,2));	
	*pResult = 0;
}

void CDlgWorkLog::OnClear() 
{
	if (MessageBox("是否清空所有操作日志？","系统提示",MB_ICONINFORMATION|MB_YESNO) == IDYES)
	{
		CAdoConnection cn;
		cn.OpenUDLFile(gstrConSQLSer);
		
		cn.Execute("TRUNCATE TABLE T_System_Log",adCmdText);
		cn.Close();
		AddLog("清空系统操作日志");
		GetDlgItem(IDC_USER)->SetWindowText("");
		GetDlgItem(IDC_DATE)->SetWindowText("");
		GetDlgItem(IDC_LOG )->SetWindowText("");
		Refresh();
	}			
}