reslut.cpp

基于access数据库的图书馆管理系统

// Reslut.cpp : implementation file
//

#include "stdafx.h"
#include "课程设计.h"
#include "Reslut.h"

#include "column.h"
#include "columns.h"
#include "COMDEF.H"
#include "ADOConn.h"
#include "KANUM.h"
#include "QUERYKA.h"

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

/////////////////////////////////////////////////////////////////////////////
// CReslut dialog


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


void CReslut::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CReslut)
	DDX_Control(pDX, IDC_ADODC, m_adodc);
	DDX_Control(pDX, IDC_DATAGRID_Result, m_Result);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CReslut, CDialog)
	//{{AFX_MSG_MAP(CReslut)
	ON_BN_CLICKED(IDC_BTN_BORROW, OnBtnBorrow)
	ON_BN_CLICKED(IDC_BTN_RETURN, OnBtnReturn)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CReslut message handlers

void CReslut::sql_query(CString cSource)
{
  m_adodc.SetRecordSource(cSource);
  m_adodc.Refresh();

}

BOOL CReslut::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here

	_variant_t vIndex;
	vIndex = long(0);
	m_Result.GetColumns().GetItem(vIndex).SetWidth(0);
	for (int i = 1; i<7; i++)
	{
		vIndex = long(i);
		m_Result.GetColumns().GetItem(vIndex).SetWidth(80);
	}

	if(!m_borrow)
	{
		CQUERYKA * dlg;
		dlg = (CQUERYKA *) GetParent();
		sql_query(dlg->m_cSource);
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CReslut::OnBtnBorrow() 
{
	// TODO: Add your control notification handler code here    
    if(m_borrow)
	{
		CKANUM *dlg;
		dlg = new CKANUM;
		dlg->Create(IDD_DIALOG_KA_NUM,this);
		dlg->ShowWindow(SW_SHOW);
	}
	else
	{
		sql_update("");
		DestroyWindow();
    }
}

void CReslut::OnBtnReturn() 
{
	// TODO: Add your control notification handler code here
	
	DestroyWindow();
}

void CReslut::WSEEN_adjust()
{
    _variant_t vIndex;
	vIndex = long(0);
	m_Result.GetColumns().GetItem(vIndex).SetWidth(0);
	for (int i = 1; i<=6; i++)
	{
		vIndex = long(i);
		m_Result.GetColumns().GetItem(vIndex).SetWidth(80);
	}
}

CString CReslut::WSEEN_GetItem(int ColNum)
{
   CColumns cols = m_Result.GetColumns();
   VARIANT v_ColNum,v_Value;
   //设置列编号
   v_ColNum.vt = VT_I2;
   v_ColNum.intVal = ColNum;
   CColumn col = cols.GetItem(v_ColNum);
   v_Value = col.GetValue();
   return v_Value.bstrVal;
}

void CReslut::sql_update(CString kanum)
{
  ADOConn m_adoconn;
  m_adoconn.OnInitDBConnect();
  _bstr_t sql;
  if(m_borrow)
  {
  CString booknum;
  booknum = WSEEN_GetItem(3);
  booknum = "'"+booknum+"'";
  CTime tNow;
  CString Now;
  tNow = CTime::GetCurrentTime();
  Now = tNow.Format("%y-%m-%d");
  Now = "'"+Now+"'";           
  kanum = "'"+kanum+"'";
  CString str;
  str = Now+ " where 图书ID = " + booknum;
  sql = "update 馆藏图书信息表 set 是否在库 = '0',借书卡ID = " +kanum+ ",归还日期 = NULL,借出日期 = " +str;
  m_adoconn.ExecuteSQL(sql);
  
  
  //sql = "update 借书卡表 set "
  m_adoconn.ExitConnect();
  }
  else
  if(m_borrow == 0)
  {
  CString booknum;
  booknum = WSEEN_GetItem(3);
  booknum = "'"+booknum+"'";
  CTime tNow;
  CString Now;
  tNow = CTime::GetCurrentTime();
  Now = tNow.Format("%y-%m-%d");
  Now = "'"+Now+"'";           
  kanum = "'"+kanum+"'";
  CString str;
  str = Now+ " where 图书ID = " + booknum;
  sql = "update 馆藏图书信息表 set 是否在库 = '1',借书卡ID =  NULL,借出日期 = NULL,归还日期= " +str;
  m_adoconn.ExecuteSQL(sql);
  m_adoconn.ExitConnect();
  }
  
}