?? storehousemandlg.cpp
字號:
// StoreHouseManDlg.cpp : implementation file
//
#include "stdafx.h"
#include "Stock.h"
#include "StoreHouseManDlg.h"
#include "StoreHouseEditDlg.h"
#include "Storehouse.h"
#include "COMDEF.H"
#include "Columns.h"
#include "Column.h"
#include "_recordset.h"
#include "StoreIn.h"
#include "TakeOut.h"
#include "ProInStore.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CStoreHouseManDlg dialog
CStoreHouseManDlg::CStoreHouseManDlg(CWnd* pParent /*=NULL*/)
: CDialog(CStoreHouseManDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CStoreHouseManDlg)
// NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
}
void CStoreHouseManDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CStoreHouseManDlg)
DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
DDX_Control(pDX, IDC_ADODC1, m_adodc);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CStoreHouseManDlg, CDialog)
//{{AFX_MSG_MAP(CStoreHouseManDlg)
ON_BN_CLICKED(IDC_ADD_BUTTON, OnAddButton)
ON_BN_CLICKED(IDC_MODI_BUTTON, OnModiButton)
ON_BN_CLICKED(IDC_DEL_BUTTON, OnDelButton)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CStoreHouseManDlg message handlers
void CStoreHouseManDlg::Refresh_Data()
{
UpdateData(TRUE);
CString cSource;
cSource = "SELECT Sid, Sname AS 倉庫單位, Memo AS 備注";
cSource += " FROM Storehouse ORDER BY Sname";
m_adodc.SetRecordSource(cSource);
m_adodc.Refresh();
//設(shè)置表格列寬度
_variant_t vIndex;
vIndex = long(0);
m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
vIndex = long(1);
m_datagrid.GetColumns().GetItem(vIndex).SetWidth(100);
vIndex = long(2);
m_datagrid.GetColumns().GetItem(vIndex).SetWidth(420);
}
void CStoreHouseManDlg::OnAddButton()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
//打開編輯對話框
CStoreHouseEditDlg dlg;
dlg.cSid = "";
if (dlg.DoModal() == IDOK)
Refresh_Data();
}
void CStoreHouseManDlg::OnModiButton()
{
// TODO: Add your control notification handler code here
if (m_adodc.GetRecordset().GetEof())
{
MessageBox("請選擇要修改的記錄");
return;
}
UpdateData(TRUE);
CStoreHouseEditDlg dlg;
dlg.cSid = m_datagrid.GetItem(0); //記錄編號
dlg.m_Sname = m_datagrid.GetItem(1); //倉庫名稱
dlg.m_Memo = m_datagrid.GetItem(2); //備注信息
if (dlg.DoModal() == IDOK)
Refresh_Data();
}
void CStoreHouseManDlg::OnDelButton()
{
// TODO: Add your control notification handler code here
if (m_adodc.GetRecordset().GetEof())
{
MessageBox("請選擇要刪除的記錄");
return;
}
CString Sid;
Sid = m_datagrid.GetItem(0);
CStoreIn obj;
if (obj.HaveStore(Sid) == 1)
{
MessageBox("此倉庫信息出現(xiàn)在入庫單中,不能刪除");
return;
}
CTakeOut obj1;
if (obj1.HaveStore(Sid) == 1)
{
MessageBox("此倉庫信息出現(xiàn)在出庫單中,不能刪除");
return;
}
CProInStore obj2;
if (obj2.HaveStore(Sid) == 1)
{
MessageBox("此倉庫信息出現(xiàn)在庫存產(chǎn)品信息中,不能刪除");
return;
}
if (MessageBox("是否刪除當(dāng)前記錄","請確定", MB_YESNO) == IDYES)
{
CStorehouse sh;
sh.sql_delete(Sid);
Refresh_Data();
}
}
BOOL CStoreHouseManDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
Refresh_Data();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -