modifyimdlg.cpp

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

// ModifyimDlg.cpp : implementation file
//

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


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

/////////////////////////////////////////////////////////////////////////////
// CModifyimDlg dialog


CModifyimDlg::CModifyimDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CModifyimDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CModifyimDlg)
	m_str_author = _T("");
	m_str_bookid = _T("");
	m_str_bookname = _T("");
	m_str_department = _T("");
	m_str_note = _T("");
	m_str_publishment = _T("");
	m_str_version = _T("");
	m_price = 0.0f;
	m_number = 0;
	//}}AFX_DATA_INIT
}


void CModifyimDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CModifyimDlg)
	DDX_Text(pDX, IDC_Modify_author, m_str_author);
	DDX_Text(pDX, IDC_Modify_bookid, m_str_bookid);
	DDX_Text(pDX, IDC_Modify_bookname, m_str_bookname);
	DDX_Text(pDX, IDC_Modify_department, m_str_department);
	DDX_Text(pDX, IDC_Modify_note, m_str_note);
	DDX_Text(pDX, IDC_Modify_publishment, m_str_publishment);
	DDX_Text(pDX, IDC_Modify_version, m_str_version);
	DDX_Text(pDX, IDC_Modify_price, m_price);
	DDX_Text(pDX, IDC_Modify_number, m_number);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CModifyimDlg, CDialog)
	//{{AFX_MSG_MAP(CModifyimDlg)
	ON_BN_CLICKED(IDC_Modifyok, OnModifyok)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CModifyimDlg message handlers

BOOL CModifyimDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	/*CLibClearDlg dd;
	int i=dd.m_Liblist.GetSelectionMark();
	if(i<0)
	{
	   MessageBox("没有选择列表框数据！");
	}
	else{

	m_str_bookid=dd.m_Liblist.GetItemText(i,1);
	m_str_bookname=dd.m_Liblist.GetItemText(i,2);
	m_str_author=dd.m_Liblist.GetItemText(i,3);
	m_str_publishment=dd.m_Liblist.GetItemText(i,4);
	m_price=atof(dd.m_Liblist.GetItemText(i,5));
	CString b;
	b.Format("%d",dd.m_Liblist.GetItemText(i,6));
	m_number=atoi(b);
	m_str_department=dd.m_Liblist.GetItemText(i,7);
	m_str_version=dd.m_Liblist.GetItemText(i,8);
	m_str_note=dd.m_Liblist.GetItemText(i,9);
	UpdateData(FALSE);
	
	}*/

	CString strSQL;
	CBookIMSet recordset;
	CBookManagerApp* app=(CBookManagerApp*)::AfxGetApp();
	strSQL.Format("select * from bookIM where book_id='%s'",app->temp);
	if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
	  MessageBox("打开数据库失败！","数据库错误",MB_OK);
	  return FALSE;
	}
	m_number=recordset.m_number;
	m_price=recordset.m_price;
	m_str_author=recordset.m_author;
	m_str_bookid=recordset.m_book_id;
	m_str_bookname=recordset.m_book_name;
	m_str_department=recordset.m_department;
	m_str_note=recordset.m_note;
	m_str_publishment=recordset.m_publishment;
	m_str_version=recordset.m_version;
	UpdateData(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 CModifyimDlg::OnModifyok() 
{
	// TODO: Add your control notification handler code here
	
	CString strSQL;
	CBookIMSet recordset;
	CBookManagerApp* app=(CBookManagerApp*)::AfxGetApp();
	UpdateData(TRUE);
	strSQL.Format("select * from bookIM where book_id='%s'",app->temp);
	if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
	   MessageBox("打开数据库失败！","数据库错误",MB_OK);
	   return;
	}
	int k=MessageBox("确定要修改此记录吗？","选择操作",MB_OKCANCEL);
	if(k==1)
	{
      recordset.Edit();
	  recordset.m_author=m_str_author;
	  recordset.m_book_name=m_str_bookname;
	  recordset.m_department=m_str_department;
	  recordset.m_note=m_str_note;
	  recordset.m_number=m_number;
	  recordset.m_price=m_price;
	  recordset.m_publishment=m_str_publishment;
	  recordset.m_version=m_str_version;
	  recordset.Update();
	  MessageBox("记录修改成功！");
	}
	if(k==2){recordset.Move(0);}
	CDialog::OnOK();
	
}