dlgfilemgt.cpp

数据库服务

// DlgFileMgt.cpp : implementation file
//

#include "stdafx.h"
#include "NServer.h"
#include "DlgFileMgt.h"
#include "StoreFileRst.h"
#include "UserRst.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgFileMgt dialog


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


void CDlgFileMgt::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgFileMgt)
	DDX_Control(pDX, IDC_DT_START, m_dtstart);
	DDX_Control(pDX, IDC_DT_END, m_dtend);
	DDX_Control(pDX, IDC_CMB_USER, m_userlist);
	DDX_Control(pDX, IDC_LIST_FILE, m_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgFileMgt, CDialog)
	//{{AFX_MSG_MAP(CDlgFileMgt)
	ON_BN_CLICKED(IDC_BTNEXIT, OnBtnexit)
	ON_BN_CLICKED(IDC_BTN_QUERY, OnBtnQuery)
	ON_BN_CLICKED(IDC_BTN_DELETE, OnBtnDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgFileMgt message handlers

BOOL CDlgFileMgt::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,100);
	m_list.InsertColumn(2,"文件路径",		LVCFMT_LEFT,200);
	m_list.InsertColumn(3,"存储用户编号",	LVCFMT_LEFT,150);
	m_list.InsertColumn(4,"存储用户名称",	LVCFMT_LEFT,150);
	m_list.InsertColumn(5,"文件大小",		LVCFMT_LEFT,150);
	m_list.InsertColumn(6,"存储日期",		LVCFMT_LEFT,200);
	
	LoadUser();

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

void CDlgFileMgt::OnBtnexit() 
{
	CDialog::OnCancel();	
}

void CDlgFileMgt::OnBtnQuery() 
{
	CString strCond = "";
	CString tempstr = "";
	CString strDT1 = "";
	CString strDT2 = "";

	CTime tm1=CTime::GetCurrentTime();
	CTime tm2=CTime::GetCurrentTime();

	m_dtstart.GetTime(tm1);
	m_dtend.GetTime(tm2);

	strDT1.Format("%04d-%02d-%02d",tm1.GetYear(),tm1.GetMonth(),tm1.GetDay());
	strDT2.Format("%04d-%02d-%02d",tm2.GetYear(),tm2.GetMonth(),tm2.GetDay());
	strCond.Format("StoreTime <= '%s' and StoreTime >= '%s' ",strDT2,strDT1);

	m_userlist.GetWindowText(tempstr);
	if(strlen(tempstr) >0 ){
		CString str = "";
		str.Format(" and StoreUserName = %s " , tempstr);
		strCond += str;
	}

	try{
		CStoreFileRst m_FileRst;

		if(m_FileRst.IsOpen())
			m_FileRst.Close();

		m_FileRst.m_strFilter =	strCond;
		m_FileRst.Open();
		while(!m_FileRst.IsEOF()){

			CString tempstr = "";
			tempstr.Format("%d",m_FileRst.m_FileIndex);
			int nItem = m_list.InsertItem(0,tempstr);
			m_list.SetItemText(nItem,1,m_FileRst.m_FileName);
			m_list.SetItemText(nItem,2,m_FileRst.m_FilePath);
			tempstr.Format("%d",m_FileRst.m_StoreUserCode);
			m_list.SetItemText(nItem,3,tempstr);
			m_list.SetItemText(nItem,4,m_FileRst.m_StoreUserName);
			tempstr.Format("%d",m_FileRst.m_FileSpace);
			m_list.SetItemText(nItem,5,tempstr);
			m_list.SetItemText(nItem,6,m_FileRst.m_StoreTime);

			m_FileRst.MoveNext();
		}

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

void CDlgFileMgt::OnBtnDelete() 
{
	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{
		CStoreFileRst m_FileRst;
		if(m_FileRst.IsOpen())
			m_FileRst.Close();
		
		m_FileRst.m_strFilter.Format("FileIndex = %d",pNum);
		m_FileRst.Open();
		if(!m_FileRst.IsEOF()){
			m_FileRst.Delete();
			m_list.DeleteItem(nItem);
		}
		m_FileRst.Close();
	}
	catch(...){;}	
}

void CDlgFileMgt::LoadUser()
{
	try{
		CUserRst m_UserRst;

		if(m_UserRst.IsOpen())
			m_UserRst.Close();

		m_UserRst.Open();
		while(!m_UserRst.IsEOF()){
			m_userlist.AddString(m_UserRst.m_UserName);
			m_UserRst.MoveNext();
		}

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