?? material_misview.cpp
字號:
// Material_MISView.cpp : implementation of the CMaterial_MISView class
//
#include "stdafx.h"
#include "Material_MIS.h"
#include "Material_MISDoc.h"
#include "Material_MISView.h"
#include "AddBasicInfo.h"
#include "CheckBasicInfoDLG.h"
#include "AppendInInfo.h"
#include "Search.h"
#include "AppendOutInfo.h"
#include "SearchplusInfo.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CMaterial_MISView
IMPLEMENT_DYNCREATE(CMaterial_MISView, CView)
BEGIN_MESSAGE_MAP(CMaterial_MISView, CView)
//{{AFX_MSG_MAP(CMaterial_MISView)
ON_COMMAND(ID_MENU_ADDBASICINFO, OnMenuAddbasicinfo)
ON_COMMAND(ID_MENU_ADDININFO, OnMenuAddininfo)
ON_COMMAND(ID_MENU_ADDOUTINFO, OnMenuAddoutinfo)
ON_COMMAND(ID_MENU_ALTERBASICINFO, OnMenuAlterbasicinfo)
ON_COMMAND(ID_MENU_ALTERININFO, OnMenuAlterininfo)
ON_COMMAND(ID_MENU_ALTEROUTINFO, OnMenuAlteroutinfo)
ON_COMMAND(ID_MENU_DELBASICINFO, OnMenuDelbasicinfo)
ON_COMMAND(ID_MENU_DELININFO, OnMenuDelininfo)
ON_COMMAND(ID_MENU_DELOUTINFO, OnMenuDeloutinfo)
ON_COMMAND(ID_MENU_SEARCHBASICINFO, OnMenuSearchbasicinfo)
ON_COMMAND(ID_MENU_SEARCHININFO, OnMenuSearchininfo)
ON_COMMAND(ID_MENU_SEARCHOUTINFO, OnMenuSearchoutinfo)
ON_COMMAND(ID_MENU_SEARCHSURPLUS, OnMenuSearchsurplus)
ON_WM_CONTEXTMENU()
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CMaterial_MISView construction/destruction
CMaterial_MISView::CMaterial_MISView()
{
// TODO: add construction code here
}
CMaterial_MISView::~CMaterial_MISView()
{
}
BOOL CMaterial_MISView::PreCreateWindow(CREATESTRUCT& cs)
{
// TODO: Modify the Window class or styles here by modifying
// the CREATESTRUCT cs
return CView::PreCreateWindow(cs);
}
/////////////////////////////////////////////////////////////////////////////
// CMaterial_MISView drawing
void CMaterial_MISView::OnDraw(CDC* pDC)
{
CMaterial_MISDoc* pDoc = GetDocument();
ASSERT_VALID(pDoc);
// TODO: add draw code for native data here
}
/////////////////////////////////////////////////////////////////////////////
// CMaterial_MISView diagnostics
#ifdef _DEBUG
void CMaterial_MISView::AssertValid() const
{
CView::AssertValid();
}
void CMaterial_MISView::Dump(CDumpContext& dc) const
{
CView::Dump(dc);
}
CMaterial_MISDoc* CMaterial_MISView::GetDocument() // non-debug version is inline
{
ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CMaterial_MISDoc)));
return (CMaterial_MISDoc*)m_pDocument;
}
#endif //_DEBUG
/////////////////////////////////////////////////////////////////////////////
// CMaterial_MISView message handlers
void CMaterial_MISView::OnMenuAddbasicinfo()
{
// TODO: Add your command handler code here
AddBasicInfo dlg;
dlg.m_bAppend = true;
dlg.DoModal();
}
void CMaterial_MISView::OnMenuAddininfo()
{
// TODO: Add your command handler code here
CAppendInInfo dlg;
dlg.m_bAppend = true;
dlg.DoModal();
}
void CMaterial_MISView::OnMenuAddoutinfo()
{
// TODO: Add your command handler code here
CAppendOutInfo dlg;
dlg.m_bAppend =true;
dlg.DoModal();
}
void CMaterial_MISView::OnMenuAlterbasicinfo()
{
// TODO: Add your command handler code here
if ( m_ListCtrl && m_sCurrentList!="物資列表" )
{
m_ListCtrl.DestroyWindow();
CreateMaterialInfo();
return;
}
if ( !m_ListCtrl )
{
CreateMaterialInfo();
return;
}
//彈出警告對話框
POSITION pos = m_ListCtrl.GetFirstSelectedItemPosition();
if (pos == NULL) AfxMessageBox(_T("沒有選中記錄！"), MB_ICONEXCLAMATION);
else
{
AddBasicInfo dlg;
dlg.m_bAppend = false;
CString str;
int iItem = m_ListCtrl.GetNextSelectedItem(pos);
//獲得ID
dlg.m_wzID = m_ListCtrl.GetItemText(iItem, 0);
//獲得名稱
dlg.m_wzName = m_ListCtrl.GetItemText(iItem, 1);
//獲得規格
dlg.m_wzSpec = m_ListCtrl.GetItemText(iItem, 2);
//獲得類別
dlg.m_wzKind = m_ListCtrl.GetItemText(iItem, 3);
//獲得單位
dlg.m_wzUnit = m_ListCtrl.GetItemText(iItem, 4);
dlg.DoModal();
}
}
void CMaterial_MISView::OnMenuAlterininfo()
{
// TODO: Add your command handler code here
_variant_t strQuery;
if ( m_ListCtrl && m_sCurrentList!=_T("物資入庫列表") )
{
m_ListCtrl.DestroyWindow();
strQuery = "select * from msave";
CreateIn(strQuery);
m_sCurrentList = _T("物資入庫列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
if ( !m_ListCtrl )
{
strQuery = "select * from msave";
CreateIn(strQuery);
m_sCurrentList = _T("物資入庫列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
POSITION pos = m_ListCtrl.GetFirstSelectedItemPosition();
if (pos == NULL) AfxMessageBox(_T("沒有選中的記錄！"), MB_ICONEXCLAMATION);
else
{
CAppendInInfo dlg;
dlg.m_bAppend = false;
CString str;
int iItem = m_ListCtrl.GetNextSelectedItem(pos);
dlg.m_rkNO=m_ListCtrl.GetItemText(iItem,0);
dlg.m_wzID=m_ListCtrl.GetItemText(iItem,1);
dlg.m_wzName=m_ListCtrl.GetItemText(iItem,2);
dlg.m_wzSpec=m_ListCtrl.GetItemText(iItem,3);
dlg.m_wzKind=m_ListCtrl.GetItemText(iItem,4);
dlg.m_wzUnit=m_ListCtrl.GetItemText(iItem,5);
dlg.m_sQuantity=m_ListCtrl.GetItemText(iItem,6);
dlg.m_sUnit=m_ListCtrl.GetItemText(iItem,7);
dlg.m_sMoney=m_ListCtrl.GetItemText(iItem,8);
// dlg.m_sTime=m_ListCtrl.GetItemText(iItem,8);
dlg.m_sDealPerson=m_ListCtrl.GetItemText(iItem,10);
dlg.m_sSavePerson=m_ListCtrl.GetItemText(iItem,11);
dlg.m_sStorage=m_ListCtrl.GetItemText(iItem,12);
dlg.m_sMemo=m_ListCtrl.GetItemText(iItem,13);
dlg.DoModal();
}
}
void CMaterial_MISView::OnMenuAlteroutinfo()
{
// TODO: Add your command handler code here
_variant_t strQuery;
if ( m_ListCtrl && m_sCurrentList!=_T("物資出庫列表") )
{
m_ListCtrl.DestroyWindow();
strQuery = "select * from muse";
CreateOut(strQuery);
m_sCurrentList = _T("物資出庫列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
if ( !m_ListCtrl )
{
strQuery = "select * from muse";
CreateOut(strQuery);
m_sCurrentList = _T("物資出庫列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
POSITION pos = m_ListCtrl.GetFirstSelectedItemPosition();
if (pos == NULL) AfxMessageBox(_T("沒有選中的記錄！"), MB_ICONEXCLAMATION);
else
{
CAppendOutInfo dlg;
dlg.m_bAppend = false;
CString str;
int iItem = m_ListCtrl.GetNextSelectedItem(pos);
dlg.m_rkNO=m_ListCtrl.GetItemText(iItem,0);
dlg.m_wzID=m_ListCtrl.GetItemText(iItem,1);
dlg.m_wzName=m_ListCtrl.GetItemText(iItem,2);
dlg.m_wzSpec=m_ListCtrl.GetItemText(iItem,3);
dlg.m_wzKind=m_ListCtrl.GetItemText(iItem,4);
dlg.m_wzUnit=m_ListCtrl.GetItemText(iItem,5);
dlg.m_sQuantity=m_ListCtrl.GetItemText(iItem,6);
dlg.m_sUnit=m_ListCtrl.GetItemText(iItem,7);
dlg.m_sMoney=m_ListCtrl.GetItemText(iItem,8);
dlg.m_sDealPerson=m_ListCtrl.GetItemText(iItem,10);
dlg.m_sSavePerson=m_ListCtrl.GetItemText(iItem,11);
dlg.m_sStorage=m_ListCtrl.GetItemText(iItem,12);
dlg.m_sMemo=m_ListCtrl.GetItemText(iItem,13);
dlg.DoModal();
}
}
void CMaterial_MISView::OnMenuDelbasicinfo()
{
// TODO: Add your command handler code here
if ( m_ListCtrl && m_sCurrentList!="物資列表" )
{
m_ListCtrl.DestroyWindow();
CreateMaterialInfo();
return;
}
if ( !m_ListCtrl )
{
CreateMaterialInfo();
return;
}
//刪除記錄
POSITION pos = m_ListCtrl.GetFirstSelectedItemPosition();
if ( pos == NULL )
{
AfxMessageBox(_T("沒有選中記錄！"), MB_ICONEXCLAMATION);
return;
}
else
{
int iItem;
CString sID;
_variant_t Holder, strQuery;
while (pos)
{
iItem = m_ListCtrl.GetNextSelectedItem(pos);
sID = m_ListCtrl.GetItemText(iItem, 0);
strQuery = "delete from material where wzid='"+sID+"'";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
}
}
//刷新列表
RefreshMaterial();
}
void CMaterial_MISView::OnMenuDelininfo()
{
// TODO: Add your command handler code here
_variant_t Holder, strQuery;
if ( m_ListCtrl && m_sCurrentList!="物資入庫列表" )
{
m_ListCtrl.DestroyWindow();
strQuery = "select * from msave";
CreateIn(strQuery);
m_sCurrentList = _T("物資入庫列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
if ( !m_ListCtrl )
{
strQuery = "select * from msave";
CreateIn(strQuery);
m_sCurrentList = _T("物資入庫列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
//刪除記錄
POSITION pos = m_ListCtrl.GetFirstSelectedItemPosition();
if ( pos == NULL )
{
AfxMessageBox(_T("沒有選中記錄！"), MB_ICONEXCLAMATION);
return;
}
else
{
int iItem;
CString sNO;
CString sID;
CString sAccount;
CString sValue;
CString sBase;
while (pos)
{
iItem = m_ListCtrl.GetNextSelectedItem(pos);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -