frm_baseinfo.cpp

VC++6.0课程设计,影碟信息管理系统

// frm_BaseInfo.cpp : implementation file
//

#include "stdafx.h"
#include "影碟信息.h"
#include "frm_BaseInfo.h"
#include "dataSet.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// frm_BaseInfo dialog


frm_BaseInfo::frm_BaseInfo(CWnd* pParent /*=NULL*/)
	: CDialog(frm_BaseInfo::IDD, pParent)
{
	//{{AFX_DATA_INIT(frm_BaseInfo)
	m_id = _T("");
	//}}AFX_DATA_INIT
}


void frm_BaseInfo::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(frm_BaseInfo)
	DDX_Control(pDX, IDC_LIST2, m_LIST);
	DDX_Text(pDX, IDC_EDIT1, m_id);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(frm_BaseInfo, CDialog)
	//{{AFX_MSG_MAP(frm_BaseInfo)
	ON_BN_CLICKED(IDC_search, Onsearch)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// frm_BaseInfo message handlers

void frm_BaseInfo::Onsearch() 
{
	 CDatabase m_database;
	 if(!m_database.Open(_T("影碟信息")))
	{
		MessageBox("不能打开数据库!");
	}
    else
	
	CDBVariant varValue;
	CString strSQL;
	DataSet *m_recordset=new DataSet(&m_database);	
	UpdateData(TRUE);
	strSQL.Format("select * from [影碟信息表] where [主演] like '%%%s%%'",m_id);
    

	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	CString strN;
	int i=0;
	int n;
	if(m_recordset->GetRecordCount !=0)
	{
		m_LIST.DeleteAllItems();
		while(!m_recordset->IsEOF())
		{
		    int m_nYear = m_recordset->m_column5.GetYear();    //年
			int m_nMonth = m_recordset->m_column5.GetMonth();      //月
			int m_nDay = m_recordset->m_column5.GetDay();        //日
			CString strD1;
			strD1.Format("%d-%d-%d",m_nYear,m_nMonth,m_nDay);
			strN.Format("%d",i+1);
			n=m_LIST.InsertItem(i,strN);		
	    	m_LIST.SetItemText(n,0,m_recordset->m_column1);
			m_LIST.SetItemText(n,1,m_recordset->m_column2);
			m_LIST.SetItemText(n,2,m_recordset->m_column3);
			m_LIST.SetItemText(n,3,m_recordset->m_column4);	
			m_LIST.SetItemText(n,4,strD1);
			m_LIST.SetItemText(n,5,m_recordset->m_column6);
			m_LIST.SetItemText(n,6,m_recordset->m_column7);

			i++;
			m_recordset->MoveNext();
		}

	m_database.ExecuteSQL(strSQL);
	m_database.Close();

   // Update();
	}
    

	UpdateData(FALSE);
	
}

BOOL frm_BaseInfo::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
m_LIST.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_LIST.InsertColumn(0,"影碟号",LVCFMT_LEFT,70);
		m_LIST.InsertColumn(1,"影碟名",LVCFMT_LEFT,110);
	
		m_LIST.InsertColumn(2,"主演",LVCFMT_LEFT,90);
		m_LIST.InsertColumn(3,"导演",LVCFMT_LEFT,100);
		m_LIST.InsertColumn(4,"发行日期",LVCFMT_LEFT,100);
		m_LIST.InsertColumn(5,"影碟类型",LVCFMT_LEFT,100);
			m_LIST.InsertColumn(6,"库存量",LVCFMT_LEFT,100);
			//	m_LIST.InsertColumn(7,"影碟类型",LVCFMT_LEFT,100);
	 

	UpdateData();

			CDatabase m_database;
			if(!m_database.Open(_T("影碟信息")))
	{
		MessageBox("不能打开数据库!","影碟管理系统",64);
	}


			CDBVariant varValue;
	CString strSQL;
	DataSet *m_recordset=new DataSet(&m_database);	
	UpdateData(TRUE);
	strSQL.Format("select * from [影碟信息表]");
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	CString strN;
	int i=0;
	int n;
	if(m_recordset->GetRecordCount !=0)
	{
		while(!m_recordset->IsEOF())
		{
		    int m_nYear = m_recordset->m_column5.GetYear();    //年
			int m_nMonth = m_recordset->m_column5.GetMonth();      //月
			int m_nDay = m_recordset->m_column5.GetDay();        //日
			CString strD1;
			strD1.Format("%d-%d-%d",m_nYear,m_nMonth,m_nDay);
			strN.Format("%d",i+1);
			n=m_LIST.InsertItem(i,strN);		
	    	m_LIST.SetItemText(n,0,m_recordset->m_column1);
			m_LIST.SetItemText(n,1,m_recordset->m_column2);
			m_LIST.SetItemText(n,2,m_recordset->m_column3);
			m_LIST.SetItemText(n,3,m_recordset->m_column4);	
			m_LIST.SetItemText(n,4,strD1);
			m_LIST.SetItemText(n,5,m_recordset->m_column6);
			m_LIST.SetItemText(n,6,m_recordset->m_column7);



			i++;
			m_recordset->MoveNext();
		}
	}
	
	m_database.Close();

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

void frm_BaseInfo::Update()
{


			//	m_LIST.InsertColumn(7,"影碟类型",LVCFMT_LEFT,100);
	 
	m_LIST.DeleteAllItems();
	//UpdateData();

			CDatabase m_database;
			if(!m_database.Open(_T("影碟信息")))
	{
		MessageBox("不能打开数据库!","影碟管理系统",64);
	}


			CDBVariant varValue;
	CString strSQL;
	DataSet *m_recordset=new DataSet(&m_database);	
	UpdateData(TRUE);
	strSQL.Format("select * from [影碟信息表]");
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	CString strN;
	int i=0;
	int n;
	if(m_recordset->GetRecordCount !=0)
	{
		while(!m_recordset->IsEOF())
		{
		    int m_nYear = m_recordset->m_column5.GetYear();    //年
			int m_nMonth = m_recordset->m_column5.GetMonth();      //月
			int m_nDay = m_recordset->m_column5.GetDay();        //日
			CString strD1;
			strD1.Format("%d-%d-%d",m_nYear,m_nMonth,m_nDay);
			strN.Format("%d",i+1);
			n=m_LIST.InsertItem(i,strN);		
	    	m_LIST.SetItemText(n,0,m_recordset->m_column1);
			m_LIST.SetItemText(n,1,m_recordset->m_column2);
			m_LIST.SetItemText(n,2,m_recordset->m_column3);
			m_LIST.SetItemText(n,3,m_recordset->m_column4);	
			m_LIST.SetItemText(n,4,strD1);
			m_LIST.SetItemText(n,5,m_recordset->m_column6);
			m_LIST.SetItemText(n,6,m_recordset->m_column7);



			i++;
			m_recordset->MoveNext();
		}
	}
	
	m_database.Close();

}