backup.cpp

java 大作业 《处方跟踪系统》源代码 gui界面

// BackUp.cpp : implementation file
//

#include "stdafx.h"
#include "libraryMS.h"
#include "BackUp.h"
/////////////////////////////////////////////
#include "column.h"
#include "columns.h"
////////////////////////////////////////////
#include "ADOConn.h"

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


extern _bstr_t ConnectionString; 
extern _bstr_t UserID; 
extern _bstr_t Password;
extern _bstr_t strConnect;

/////////////////////////////////////////////////////////////////////////////
// CBackUp dialog
CBackUp::CBackUp(CWnd* pParent /*=NULL*/)
	: CDialog(CBackUp::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBackUp)
	m_Query = _T("");
	//}}AFX_DATA_INIT
}


void CBackUp::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBackUp)
	DDX_Control(pDX, IDC_STATICasdfasdf, m_tipe);
	DDX_Control(pDX, IDC_Condition, m_condition);
	DDX_Control(pDX, IDC_ADODC1, m_adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
	DDX_Text(pDX, IDC_EDIT1, m_Query);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBackUp, CDialog)
	//{{AFX_MSG_MAP(CBackUp)
	ON_COMMAND(ID_MENUITEM32802, OnMenuitem32802)
	ON_COMMAND(ID_MENUITEM32801, OnMenuitem32801)
	ON_COMMAND(ID_MENUITEM32807, OnMenuitem32807)
	ON_UPDATE_COMMAND_UI(ID_MENUITEM32807, OnUpdateMenuitem32807)
	ON_COMMAND(ID_MENUITEM32803, OnMenuitem32803)
	ON_COMMAND(ID_MENUITEM32804, OnMenuitem32804)
	ON_COMMAND(ID_MENUITEM32805, OnMenuitem32805)
	ON_COMMAND(ID_MENUITEM32806, OnMenuitem32806)
	ON_BN_CLICKED(IDC_QueryAll, OnQueryAll)
	ON_BN_CLICKED(IDC_Query, OnQuery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBackUp message handlers



BOOL CBackUp::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	status = 0;
    m_condition.SetCurSel(0);
	UpdateData(false);
	//GetDlgItem(IDC_Clear)->EnableWindow(false);

	m_adodc.SetRecordSource(SQL);
	m_adodc.Refresh();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CBackUp::OnMenuitem32802() 
{
	// TODO: Add your command handler code here
	m_adodc.SetRecordSource("SELECT ID_t_UserOP as 操作者, Event_t_UserOP as 操作行为, Comment_t_UserrOP 操作原因, ID_t_User as 被操作对象ID, NameUser as 被操作者, Time_t_UserOP as 日期 FROM t_UserBack ORDER BY Time_t_UserOP");
	m_adodc.Refresh();

	status = 1;

}

void CBackUp::OnMenuitem32801() 
{
	// TODO: Add your command handler code here
	OnOK();
}

void CBackUp::OnMenuitem32807() 
{
	// TODO: Add your command handler code here
	if(status==1)//status==1  标识，当前为系统用户管理日志
	{
		//连接数据库
		ADOConn m_Adoconn;
		m_Adoconn.OnInitADOConn();

		_bstr_t vSQL;
		vSQL="DELETE t_UserBack";

		m_Adoconn.ExecuteSQL(vSQL);			//执行SQL语句
	    m_Adoconn.ExitConnect();			//断开数据库连接

		m_adodc.Refresh();
		//GetDlgItem(IDC_Clear)->EnableWindow(false);
		status = 0;
	}
    else if(status==2)//status==2 标识，当前为读者信息管理日志
	{
		ADOConn m_Adoconn;
		m_Adoconn.OnInitADOConn();

		_bstr_t vSQL;
		vSQL="DELETE t_ReaderBack";

		m_Adoconn.ExecuteSQL(vSQL);			//执行SQL语句
	    m_Adoconn.ExitConnect();			//断开数据库连接

		m_adodc.Refresh();
		//GetDlgItem(IDC_Clear)->EnableWindow(false);
		status = 0;
	}
	else if(status==3)//status==3 标识，当前为图书信息管理日志
	{
		ADOConn m_Adoconn;
		m_Adoconn.OnInitADOConn();

		_bstr_t vSQL;
		vSQL="DELETE t_BookBack";

		m_Adoconn.ExecuteSQL(vSQL);			//执行SQL语句
	    m_Adoconn.ExitConnect();			//断开数据库连接

		m_adodc.Refresh();
		//GetDlgItem(IDC_Clear)->EnableWindow(false);
		status = 0;
	}
	else if(status==4)//status==4 标识，当前为借书信息管理日志
	{
		ADOConn m_Adoconn;
		m_Adoconn.OnInitADOConn();

		_bstr_t vSQL;
		vSQL="DELETE t_BorrowBack";

		m_Adoconn.ExecuteSQL(vSQL);			//执行SQL语句
	    m_Adoconn.ExitConnect();			//断开数据库连接

		m_adodc.Refresh();
		//GetDlgItem(IDC_Clear)->EnableWindow(false);
		status = 0;
	}
	else if(status==5)//status==5 标识，当前为还书信息管理日志
	{
		ADOConn m_Adoconn;
		m_Adoconn.OnInitADOConn();

		_bstr_t vSQL;
		vSQL="DELETE t_Retur";

		m_Adoconn.ExecuteSQL(vSQL);			//执行SQL语句
	    m_Adoconn.ExitConnect();			//断开数据库连接

		m_adodc.Refresh();
		//GetDlgItem(IDC_Clear)->EnableWindow(false);
		status = 0;
	}

	
}

void CBackUp::OnUpdateMenuitem32807(CCmdUI* pCmdUI) 
{
	// TODO: Add your command update UI handler code here
	if(status==0)
	{pCmdUI->Enable(false);
	 MessageBox("没有记录可以删除");
	}
	else 
	{
		pCmdUI->Enable(true);
	}
	
}

void CBackUp::OnMenuitem32803() 
{
	// TODO: Add your command handler code here
		// TODO: Add your command handler code here
	m_adodc.SetRecordSource("SELECT ID_UserOP as 操作者, Event_t_ReaderOP as 操作行为, Comment_t_ReaderOP 操作原因, ID_t_Reader as 被操作对象ID, Name_t_Reader as 被操作者, Time_t_ReaderOP as 日期 FROM t_ReaderBack ORDER BY Time_t_ReaderOP");
	m_adodc.Refresh();

	status = 2;//标识显示信息
	
	
}

void CBackUp::OnMenuitem32804() 
{
	// TODO: Add your command handler code here
	m_adodc.SetRecordSource("SELECT ID_UserOP as 操作者, Event_t_BookOP as 操作行为, Comment as 备注, Title_t_Book as 书名, ISBN_t_Book as ISBN, Author_t_Book as 作者, PressName_t_Book as 出版社, Comment_t_BookOP as 操作原因, Time_t_BookOP as 日期 FROM [libraryMS].[dbo].[t_BookBack]");
	m_adodc.Refresh();

	status = 3;//标识显示信息
	
}

void CBackUp::OnMenuitem32805() 
{
	// TODO: Add your command handler code here
	m_adodc.SetRecordSource("SELECT IDReader as 借书证号, Title as 书名, ISBN, DateB as 借书时间 FROM [libraryMS].[dbo].[t_BorrowBack]");
	m_adodc.Refresh();
	
	status = 4;//标识显示信息
	
}

void CBackUp::OnMenuitem32806() 
{
	// TODO: Add your command handler code here
	m_adodc.SetRecordSource("SELECT IDReader as 借书证号,NameReader as 姓名, Title as 书名, ISBN, DateR as 还书时间 FROM [libraryMS].[dbo].[t_Return]");
	m_adodc.Refresh();

	status = 5;//标识显示信息

	
}

void CBackUp::OnQueryAll() 
{
	// TODO: Add your control notification handler code here
    if(status==1)//status==1  标识，当前为系统用户管理日志
	{
     m_adodc.SetRecordSource("SELECT ID_t_UserOP as 操作者, Event_t_UserOP as 操作行为, Comment_t_UserrOP 操作原因, ID_t_User as 被操作对象ID, NameUser as 被操作者, Time_t_UserOP as 日期 FROM t_UserBack ");
     m_adodc.Refresh();
	}
	else if(status==2)
	{m_adodc.SetRecordSource("SELECT ID_UserOP as 操作者, Event_t_ReaderOP as 操作行为, Comment_t_ReaderOP 操作原因, ID_t_Reader as 被操作对象ID, Name_t_Reader as 被操作者, Time_t_ReaderOP as 日期 FROM t_ReaderBack ");
	m_adodc.Refresh();}
	else if(status==3)
	{m_adodc.SetRecordSource("SELECT ID_UserOP as 操作者, Event_t_BookOP as 操作行为, Comment as 备注, Title_t_Book as 书名, ISBN_t_Book as ISBN, Author_t_Book as 作者, PressName_t_Book as 出版社, Comment_t_BookOP as 操作原因, Time_t_BookOP as 日期 FROM [libraryMS].[dbo].[t_BookBack] ");
	m_adodc.Refresh();}
	else if(status==4)
	{m_adodc.SetRecordSource("SELECT IDReader as 借书证号, Title as 书名, ISBN, DateB as 借书时间 FROM [libraryMS].[dbo].[t_BorrowBack]");
	m_adodc.Refresh();}
	else if(status==5)
	{m_adodc.SetRecordSource("SELECT IDReader as 借书证号,NameReader as 姓名, Title as 书名, ISBN, DateR as 还书时间 FROM [libraryMS].[dbo].[t_Return] ");
	m_adodc.Refresh();}
	
}

void CBackUp::OnQuery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	if(status==1)//status==1  标识，当前为系统用户管理日志
	{
     m_adodc.SetRecordSource("SELECT ID_t_UserOP as 操作者, Event_t_UserOP as 操作行为, Comment_t_UserrOP 操作原因, ID_t_User as 被操作对象ID, NameUser as 被操作者, Time_t_UserOP as 日期 FROM t_UserBack where ID_t_UserOP ='"+m_Query+"'");
     m_adodc.Refresh();
	}
	else if(status==2)
	{m_adodc.SetRecordSource("SELECT ID_UserOP as 操作者, Event_t_ReaderOP as 操作行为, Comment_t_ReaderOP 操作原因, ID_t_Reader as 被操作对象ID, Name_t_Reader as 被操作者, Time_t_ReaderOP as 日期 FROM t_ReaderBack where ID_UserOP='"+m_Query+"'");
	m_adodc.Refresh();}
	else if(status==3)
	{m_adodc.SetRecordSource("SELECT ID_UserOP as 操作者, Event_t_BookOP as 操作行为, Comment as 备注, Title_t_Book as 书名, ISBN_t_Book as ISBN, Author_t_Book as 作者, PressName_t_Book as 出版社, Comment_t_BookOP as 操作原因, Time_t_BookOP as 日期 FROM [libraryMS].[dbo].[t_BookBack] where ID_UserOP='"+m_Query+"'");
	m_adodc.Refresh();}
	else if(status==4)
	{m_adodc.SetRecordSource("SELECT ID_UserOP as 操作者, Event_t_BookOP as 操作行为, Comment as 备注, Title_t_Book as 书名, ISBN_t_Book as ISBN, Author_t_Book as 作者, PressName_t_Book as 出版社, Comment_t_BookOP as 操作原因, Time_t_BookOP as 日期 FROM [libraryMS].[dbo].[t_BookBack] where ID_UserOP='"+m_Query+"'");
	m_adodc.Refresh();}
	else if(status==5)
	{m_adodc.SetRecordSource("SELECT IDReader as 借书证号, Title as 书名, ISBN, DateB as 借书时间 FROM [libraryMS].[dbo].[t_BorrowBack] where IDReader='"+m_Query+"'");
	m_adodc.Refresh();}
	else if(status==6)
	{m_adodc.SetRecordSource("SELECT IDReader as 借书证号,NameReader as 姓名, Title as 书名, ISBN, DateR as 还书时间 FROM [libraryMS].[dbo].[t_Return] where IDReader='"+m_Query+"'");
	m_adodc.Refresh();}
}