libcleardlg.cpp

数据库包括教材表 教材管理系统数据库设计

// LibClearDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookManager.h"
#include "LibClearDlg.h"
#include "BookIMSet.h"
#include "AddimDlg.h"
#include "ModifyimDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLibClearDlg dialog


CLibClearDlg::CLibClearDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLibClearDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLibClearDlg)
	m_str_Content = _T("");
	m_str_Lookway = _T("");
	//}}AFX_DATA_INIT
}


void CLibClearDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLibClearDlg)
	DDX_Control(pDX, IDC_Lookway, m_ctr_Lookway);
	DDX_Control(pDX, IDC_Liddelete, m_bnt_Libdelete);
	DDX_Control(pDX, IDC_Libmodify, m_bnt_Libmodify);
	DDX_Control(pDX, IDC_Liblist, m_Liblist);
	DDX_Control(pDX, IDC_LibCotent, m_ctr_Content);
	DDX_Text(pDX, IDC_LibCotent, m_str_Content);
	DDX_CBString(pDX, IDC_Lookway, m_str_Lookway);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLibClearDlg, CDialog)
	//{{AFX_MSG_MAP(CLibClearDlg)
	ON_CBN_SELCHANGE(IDC_Lookway, OnSelchangeLookway)
	ON_BN_CLICKED(IDC_Liblookup, OnLiblookup)
	ON_BN_CLICKED(IDC_Lib_alllook, OnLiballlook)
	ON_BN_CLICKED(IDC_Libadd, OnLibadd)
	ON_NOTIFY(NM_CLICK, IDC_Liblist, OnClickLiblist)
	ON_BN_CLICKED(IDC_Liddelete, OnLiddelete)
	ON_BN_CLICKED(IDC_Libmodify, OnLibmodify)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLibClearDlg message handlers

BOOL CLibClearDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
    m_Liblist.InsertColumn(0,"序号");
	m_Liblist.InsertColumn(1,"书籍条码");
	m_Liblist.InsertColumn(2,"书籍名称");
	m_Liblist.InsertColumn(3,"作者姓名");
	m_Liblist.InsertColumn(4,"出版社");
    m_Liblist.InsertColumn(5,"单价");
	m_Liblist.InsertColumn(6,"库存量");
	m_Liblist.InsertColumn(7,"开课单位");
	m_Liblist.InsertColumn(8,"版次");
	m_Liblist.InsertColumn(9,"备注说明");
	m_Liblist.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
    m_Liblist.SetColumnWidth(0,60);
	m_Liblist.SetColumnWidth(1,80);
    m_Liblist.SetColumnWidth(2,140);
	m_Liblist.SetColumnWidth(3,100);
	m_Liblist.SetColumnWidth(4,150);
	m_Liblist.SetColumnWidth(5,100);
	m_Liblist.SetColumnWidth(6,80);
	m_Liblist.SetColumnWidth(7,150);
    m_Liblist.SetColumnWidth(8,80);
	m_Liblist.SetColumnWidth(9,500);
	
	m_ctr_Lookway.SetFocus();
	m_bnt_Libdelete.EnableWindow(FALSE);
	m_bnt_Libmodify.EnableWindow(FALSE);
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CLibClearDlg::OnSelchangeLookway() 
{
	// TODO: Add your control notification handler code here
	m_ctr_Lookway.GetLBText(m_ctr_Lookway.GetCurSel(),member);
	
	
}

void CLibClearDlg::OnLiblookup() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_ctr_Lookway.GetCurSel()==-1)
	{
	  MessageBox("请选择查询条件！");
	  return;
	}
	else if(m_str_Content.IsEmpty())
	{
	   MessageBox("请输入查询内容！");
	   m_ctr_Content.SetFocus();
	   return;
	}
	CBookIMSet recordset;
	CString strSQL;
	if(member=="按书籍条码")
	{
	  strSQL.Format("select * from bookIM where book_id='%s'",m_str_Content);
	}
	if(member=="按书籍名")
	{
		strSQL = "select * from bookIM where book_name like '%"+m_str_Content+"%'";
	   //strSQL.Format("select * from bookIM where book_name like '% %s %'",m_str_Content);
	}
	if(member=="按出版社")
	{
	   strSQL="select * from bookIM where publishment like '%"+m_str_Content+"%'";
	}
	if(member=="按作者名")
	{
	   strSQL="select * from bookIM where author like '%"+m_str_Content+"%'";
	}
	if(member=="按开课部门")
	{
	   strSQL="select * from bookIM where department like '%"+m_str_Content+"%'";
	}
	if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
	   MessageBox("打开数据库失败！","数据库错误",MB_OK);
	   return;
	}
	
	if(recordset.GetRecordCount()==0)
	{
	   MessageBox("没有找到你要查询的记录！","查找失败",MB_OK);
	   m_str_Content.Empty();
	   m_ctr_Content.SetFocus();
	   UpdateData(FALSE);
       return;	   
	}
	else 
	{  
		m_Liblist.DeleteAllItems();
	   m_Liblist.SetRedraw(FALSE);
	   int i=0;
	   while(!recordset.IsEOF())
	   {

	   
       m_Liblist.InsertItem(i," ");
	   CString temp;
	   temp.Format("%d",i+1);
	   m_Liblist.SetItemText(i,0,temp);
	   m_Liblist.SetItemText(i,1,recordset.m_book_id);
	   m_Liblist.SetItemText(i,2,recordset.m_book_name);
	   m_Liblist.SetItemText(i,3,recordset.m_author);
	   CString str1;
	   CString str2;
       str1.Format("%f",recordset.m_price);
	   str2.Format("%d",recordset.m_number);
	   m_Liblist.SetItemText(i,4,recordset.m_publishment);
	   m_Liblist.SetItemText(i,5,str1);
	   m_Liblist.SetItemText(i,6,str2);
	   m_Liblist.SetItemText(i,7,recordset.m_department);
	   m_Liblist.SetItemText(i,8,recordset.m_version);
	   m_Liblist.SetItemText(i,9,recordset.m_note);
	   
	   recordset.MoveNext();
	   i++;
	   }
	   m_Liblist.SetRedraw(TRUE);
	   

	}
	recordset.Close();

	
}

void CLibClearDlg::OnLiballlook() 
{
	// TODO: Add your control notification handler code here
	CString strSQL;
	CBookIMSet recordset;
	strSQL="select * from bookIM";
    if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
	   MessageBox("打开数据库失败！","数据库错误",MB_OK);
	   return;
	}
	if(recordset.GetRecordCount==0)
	{
	  MessageBox("数据库记录为空！");
	  return;
	}
	int i=0;
	m_Liblist.DeleteAllItems();
    m_Liblist.SetRedraw(FALSE);
	while(!recordset.IsEOF())
	{

	   
       m_Liblist.InsertItem(i," ");
	   CString temp;
	   temp.Format("%d",i+1);
	   m_Liblist.SetItemText(i,0,temp);
	   m_Liblist.SetItemText(i,1,recordset.m_book_id);
	   m_Liblist.SetItemText(i,2,recordset.m_book_name);
	   m_Liblist.SetItemText(i,3,recordset.m_author);
	   CString str1;
	   CString str2;
       str1.Format("%f",recordset.m_price);
	   str2.Format("%d",recordset.m_number);
	   m_Liblist.SetItemText(i,4,recordset.m_publishment);
	   m_Liblist.SetItemText(i,5,str1);
	   m_Liblist.SetItemText(i,6,str2);
	   m_Liblist.SetItemText(i,7,recordset.m_department);
	   m_Liblist.SetItemText(i,8,recordset.m_version);
	   m_Liblist.SetItemText(i,9,recordset.m_note);
	   
	   recordset.MoveNext();
	   i++;
	}
	m_Liblist.SetRedraw(TRUE);
	recordset.Close();

	
}

void CLibClearDlg::OnLibadd() 
{
	// TODO: Add your control notification handler code here
	CAddimDlg dlg;
	dlg.DoModal();
	RefreshData();

	
}

void CLibClearDlg::OnClickLiblist(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int i=m_Liblist.GetSelectionMark();
	if(i<0)
	{
	   MessageBox("请选择一条记录！");
	   return;
	}

	m_bnt_Libdelete.EnableWindow(TRUE);
	m_bnt_Libmodify.EnableWindow(TRUE);
	mode=m_Liblist.GetItemText(i,1);

	*pResult = 0;
}

void CLibClearDlg::OnLiddelete() 
{
	// TODO: Add your control notification handler code here
	m_bnt_Libdelete.EnableWindow(FALSE);
	CString strSQL;
	CBookIMSet recordset;
	strSQL.Format("select * from bookIM where book_id='%s'",mode);
	if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
	   MessageBox("打开数据库失败！","数据库错误",MB_OK);
	   return;
	}
	int k=MessageBox("确定要删除此记录吗？","选择操作",MB_OKCANCEL);
	if(k==1)
	{
      recordset.Delete();
	  MessageBox("记录删除成功！");
	}
	else{recordset.Move(0);}
	RefreshData();
	
}

void CLibClearDlg::RefreshData()
{
	CString strSQL;
	CBookIMSet recordset;
	strSQL="select * from bookIM";
	m_Liblist.DeleteAllItems();
	if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
	   MessageBox("打开数据库失败！","数据库错误",MB_OK);
	   return;
	}
	int i=0;
    m_Liblist.SetRedraw(FALSE);
	while(!recordset.IsEOF())
	{
       m_Liblist.InsertItem(i," ");
	   CString temp;
	   temp.Format("%d",i+1);
	   m_Liblist.SetItemText(i,0,temp);
	   m_Liblist.SetItemText(i,1,recordset.m_book_id);
	   m_Liblist.SetItemText(i,2,recordset.m_book_name);
	   m_Liblist.SetItemText(i,3,recordset.m_author);
	   CString str1;
	   CString str2;
       str1.Format("%f",recordset.m_price);
	   str2.Format("%d",recordset.m_number);
	   m_Liblist.SetItemText(i,4,recordset.m_publishment);
	   m_Liblist.SetItemText(i,5,str1);
	   m_Liblist.SetItemText(i,6,str2);
	   m_Liblist.SetItemText(i,7,recordset.m_department);
	   m_Liblist.SetItemText(i,8,recordset.m_version);
	   m_Liblist.SetItemText(i,9,recordset.m_note);
	   
	   recordset.MoveNext();
	   i++;
	}
	m_Liblist.SetRedraw(TRUE);
	recordset.Close();

}



void CLibClearDlg::OnLibmodify() 
{
	// TODO: Add your control notification handler code here
	CModifyimDlg dlg;
	dlg.DoModal();
	CBookManagerApp* app=(CBookManagerApp*)::AfxGetApp();
	app->temp=mode;
	m_bnt_Libmodify.EnableWindow(FALSE);
	RefreshData();
	
}