b_inf.cpp

本源码为图书管理系统

// B_INF.cpp : implementation file
//

#include "stdafx.h"
#include "TSG.h"
#include "B_INF.h"
#include "bookinfo.h"
#include "bookadd.h"
#include "BOOKMOD.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// B_INF dialog


B_INF::B_INF(CWnd* pParent /*=NULL*/)
	: CDialog(B_INF::IDD, pParent)
{
	//{{AFX_DATA_INIT(B_INF)
	m_field = _T("");
	m_relation = _T("");
	m_content = _T("");
	m_bid1 = 0;
	m_bname1 = _T("");
	m_bzuozhe1 = _T("");
	m_bpublic1 = _T("");
	m_bzongshu1 = 0;
	m_bleft1 = 0;
	m_bprice1 = 0;
	change=false;
	//}}AFX_DATA_INIT
}


void B_INF::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(B_INF)
	DDX_Control(pDX, IDC_LIST1, m_book);
	DDX_CBString(pDX, IDC_COMBO1, m_field);
	DDX_CBString(pDX, IDC_COMBO2, m_relation);
	DDX_Text(pDX, IDC_EDIT1, m_content);
	DDX_Text(pDX, IDC_EDIT001, m_bid1);
	DDX_Text(pDX, IDC_EDIT002, m_bname1);
	DDX_Text(pDX, IDC_EDIT003, m_bzuozhe1);
	DDX_Text(pDX, IDC_EDIT004, m_bpublic1);
	DDX_Text(pDX, IDC_EDIT007, m_bzongshu1);
	DDX_Text(pDX, IDC_EDIT008, m_bleft1);
	DDX_Text(pDX, IDC_EDIT006, m_bprice1);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(B_INF, CDialog)
	//{{AFX_MSG_MAP(B_INF)
	ON_BN_CLICKED(IDC_BOOKADD, OnBookadd)
	ON_BN_CLICKED(IDC_BOOKSUB, OnBooksub)
	ON_BN_CLICKED(IDC_BUTTONCHAZHAO, OnButtonchazhao)
	ON_BN_CLICKED(IDC_BUTTONMOD, OnButtonmod)
	ON_NOTIFY(LVN_ITEMCHANGED, IDC_LIST1, OnItemchangedList1)
	ON_BN_CLICKED(IDC_BUTTONFRESH, OnButtonfresh)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// B_INF message handlers





////////////////////////////////////////////////////////////////////////////////
BOOL B_INF::OnInitDialog()
{	CDialog::OnInitDialog();


	// TODO: Add extra initialization here
	m_book.InsertColumn(0,"书号");
	m_book.InsertColumn(1,"书名");
	m_book.InsertColumn(2,"作者");
	m_book.InsertColumn(3,"出版社");
	m_book.InsertColumn(4,"价格");
	m_book.InsertColumn(5,"总数");
    m_book.InsertColumn(6,"库存数");

	RECT rectbasic;
	m_book.GetWindowRect(&rectbasic);
	int widbasic = rectbasic.right - rectbasic.left;
	m_book.SetColumnWidth(0,widbasic/4);
	m_book.SetColumnWidth(1,widbasic/4);
	m_book.SetColumnWidth(2,widbasic/4);
	m_book.SetColumnWidth(3,widbasic/4);
	m_book.SetColumnWidth(4,widbasic/4);
	m_book.SetColumnWidth(5,widbasic/4);
	m_book.SetColumnWidth(6,widbasic/4);
	m_book.SetExtendedStyle(LVS_EX_FULLROWSELECT);
    if(!change)
	{p_query.Format("select * from bookinfo");}
//	RefreshData();
    
//	{m_book.SetHotItem(bb);}
    RefreshData();
	change=false;
	return true;

}


/////////////////////////////////////////////////////////////////
void B_INF::RefreshData()
{if(!m_database.IsOpen()){
		m_database.Open(_T("TSG"));
	}
	m_book.DeleteAllItems();
	bookinfo m_basicset(&m_database);
	CString strSQL;
	m_basicset.Open(AFX_DB_USE_DEFAULT_TYPE,p_query);
	CDBVariant varValue;
	if(m_basicset.GetRecordCount()!=0) m_basicset.MoveFirst();
	char buf[20];
	int i=0;
	while(!m_basicset.IsEOF())
	{
		int temp=0;
		m_basicset.GetFieldValue(temp,varValue);
		sprintf(buf,"%d",varValue.m_lVal); m_book.InsertItem(i,buf);
	    
		m_basicset.GetFieldValue(1,varValue);
		m_book.SetItemText(i,1,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(2,varValue);
		m_book.SetItemText(i,2,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(3,varValue);
		m_book.SetItemText(i,3,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(4,varValue);
		sprintf(buf,"%d",varValue.m_chVal); m_book.SetItemText(i,4,buf);
        m_basicset.GetFieldValue(5,varValue);
		sprintf(buf,"%d",varValue.m_chVal); m_book.SetItemText(i,5,buf);
       m_basicset.GetFieldValue(6,varValue);
		sprintf(buf,"%d",varValue.m_chVal); m_book.SetItemText(i,6,buf);
		m_basicset.MoveNext();
		i++;
	}
     	

}
/////////////////////////////////////////////////////////////


/////////////////////////////////////////////////////
void B_INF::OnBookadd() 
{       m_database.Close();
		bookadd bookinfo;
		bookinfo.m_database.Open(_T("TSG"));
		bookinfo.DoModal();
		RefreshData();
	// TODO: Add your control notification handler code here
	
}

void B_INF::OnBooksub() 
{      	int i=m_book.GetSelectionMark();
		CString strSQL;
	if(i==-1){
			MessageBox("please choose a record first!");
		}
		else{
			int keyid=atoi(m_book.GetItemText(i,0));
			strSQL.Format("delete from bookinfo where 书号=%d",keyid);
			m_database.ExecuteSQL(strSQL);
			
			m_database.Close();
			RefreshData();
		}
	// TODO: Add your control notification handler code here
	
}
/////////////////////////////////////////////////////////////////////


void B_INF::OnButtonchazhao() 
{	UpdateData(TRUE);
	CString m_realfield;
	if(m_field.Compare("书号")==0)
	{
		m_realfield.Format("书号");
		p_query.Format("select * from bookinfo where %s%s%d",m_realfield,m_relation,atoi(m_content));
	}
	if(m_field.Compare("书名")==0)
	{
		m_realfield.Format("书名");
		p_query.Format("select * from bookinfo where %s%s'%s'",m_realfield,m_relation,m_content);
	}
	if(m_field.Compare("作者")==0)
	{
		m_realfield.Format("作者");
		p_query.Format("select * from bookinfo where %s%s'%s'",m_realfield,m_relation,m_content);
	}
	
	if(m_field.Compare("出版社")==0)
	{
		m_realfield.Format("出版社");
		p_query.Format("select * from bookinfo where %s%s'%s'",m_realfield,m_relation,m_content);
	}

	RefreshData();
	// TODO: Add your control notification handler code here
	
}

void B_INF::OnButtonmod() 
{       BOOKMOD BM;
        int r=m_book.GetSelectionMark();
		CString strSQL;
	    if(r==-1){
			MessageBox("please choose a record first!");
		}
		else {int i=m_book.GetSelectionMark();
        BM.m_bid=(int)atoi(m_book.GetItemText(i,0));
		BM.m_bname=m_book.GetItemText(i,1);
        BM.m_bzuozhe=m_book.GetItemText(i,2);
        BM.m_bpublic=m_book.GetItemText(i,3);
        BM.m_bprice=(int)atoi(m_book.GetItemText(i,4));
        BM.m_bzongshu=(int)atoi(m_book.GetItemText(i,5));
        BM.m_bleft=(int)atoi(m_book.GetItemText(i,6));
        m_database.Close();
		
		BM.m_database.Open(_T("TSG"));
		BM.DoModal();}
		RefreshData();
	// TODO: Add your control notification handler code here
	
}

void B_INF::OnItemchangedList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	    int i=m_book.GetNextItem(-1,LVNI_SELECTED);
	    m_bid1=(int)atoi(m_book.GetItemText(i,0));
		m_bname1=m_book.GetItemText(i,1);
        m_bzuozhe1=m_book.GetItemText(i,2);
        m_bpublic1=m_book.GetItemText(i,3);
        m_bprice1=(int)atoi(m_book.GetItemText(i,4));
        m_bzongshu1=(int)atoi(m_book.GetItemText(i,5));
        m_bleft1=(int)atoi(m_book.GetItemText(i,6));
		UpdateData(FALSE);
	   *pResult = 0;
}

void B_INF::OnButtonfresh() 
{   m_database.Close();
	RefreshData();
	// TODO: Add your control notification handler code here
	
}

/////////////////////////////////////////////////////////////
void B_INF::thebook(int aa)
{   //UpdateData();
    //UpdateData(TRUE);
    //DoModal();
	if(!m_database.IsOpen()){
		m_database.Open(_T("TSG"));
	}
   p_query.Format("select * from bookinfo where 书号=%d",aa);
	//bb=aa;
    change=true;
	m_database.Close();
}