?? backup.cpp
字號:
// 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();}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -