📄 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 "SearchplusInfo.h"
#include "SearchPriceInfo.h"
#include "ChangePswd.h"
#include "AddNewUsr.h"
#include "DelConfirm.h"
#include "EditPrice.h"
#include "AddRead.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_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_COMMAND(ID_MENU_SEARCHPRICE, OnMenuSearchprice)
ON_WM_CONTEXTMENU()
ON_COMMAND(ID_MENU_LISTBASICINFO, OnMenuListbasicinfo)
ON_COMMAND(ID_MENU_LISTININFO, OnMenuListininfo)
ON_COMMAND(ID_MENU_LISTOUTINFO, OnMenuListoutinfo)
ON_COMMAND(ID_MENU_EDITPRICE, OnMenuEditprice)
ON_COMMAND(ID_MAINMENU_CHANGEPWD, OnMainmenuChangepwd)
ON_COMMAND(ID_MAINMENU_APPENDACCOUNT, OnMainmenuAppendaccount)
ON_COMMAND(ID_MAINMENU_ADDREAD, OnMainmenuAddread)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CMaterial_MISView construction/destruction
CMaterial_MISView::CMaterial_MISView()
{
// TODO: add construction code here
del_confirm = FALSE;
}
CMaterial_MISView::~CMaterial_MISView()
{
}
BOOL CMaterial_MISView::PreCreateWindow(CREATESTRUCT& cs)
{
// TODO: Modify the Window class or styles here by modifying
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
CRect rect_client, rect;
GetClientRect(&rect_client);
rect.left = rect.top =0;
rect.bottom = 30;
rect.right = rect_client.Width();
m_StaticCtrl.MoveWindow(&rect);
m_StaticCtrl.SetFont(&font);
}
/////////////////////////////////////////////////////////////////////////////
// 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
_variant_t strQuery;
theApp.inorout=_T("in");
strQuery = "select * from ProductStock where State='"+theApp.inorout+"'";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
CAppendInInfo dlg;
dlg.m_bAppend = true;
dlg.DoModal();
}
void CMaterial_MISView::OnMenuAddoutinfo()
{
// TODO: Add your command handler code here
_variant_t strQuery;
theApp.inorout=_T("out");
CString lin=_T("0");
strQuery = "select * from ProductRemain where StockNum>'"+lin+"'";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
int iCount= theApp.m_pADOSet->GetRecordCount();
if(iCount<=0)
{
AfxMessageBox(_T("当前没有产品剩余记录"),MB_ICONEXCLAMATION);
return;
}
CAppendInInfo 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);
//获得
dlg.m_basicinfo_mapid = m_ListCtrl.GetItemText(iItem, 0);
//获得
dlg.m_basicinfo_version = m_ListCtrl.GetItemText(iItem, 1);
//获得
dlg.m_basicinfo_productname = m_ListCtrl.GetItemText(iItem, 2);
//获得
dlg.m_basicinfo_materialid = m_ListCtrl.GetItemText(iItem, 3);
//获得
dlg.m_basicinfo_safestocknum = m_ListCtrl.GetItemText(iItem, 4);
//获得
dlg.m_basicinfo_unit = m_ListCtrl.GetItemText(iItem, 5);
theApp.m_sn_sn = m_ListCtrl.GetItemText(iItem, 8);
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
{
CDelConfirm m_delconf;
m_delconf.DoModal();
if(!del_confirm)
return;
int iItem;
CString sID,s2ID;
_variant_t Holder, strQuery;
while (pos)
{
iItem = m_ListCtrl.GetNextSelectedItem(pos);
sID = m_ListCtrl.GetItemText(iItem, 8);
strQuery = "delete from ProductInfo where SN = '"+sID+"'\
delete from ProductRemain where SN = '"+sID+"'\
delete from ProductPrice where SN = '"+sID+"'";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
}
}
//刷新列表
RefreshMaterial();
}
void CMaterial_MISView::OnMenuDelininfo()
{
// TODO: Add your command handler code here
theApp.inorout=_T("in");
_variant_t Holder, strQuery;
if ( m_ListCtrl && m_sCurrentList!="产品入库列表" )
{
m_ListCtrl.DestroyWindow();
strQuery = "select * from ProductStock where State='"+theApp.inorout+"'";
CreateIn(strQuery);
m_sCurrentList = _T("产品入库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
if ( !m_ListCtrl )
{
strQuery = "select * from ProductStock where State='"+theApp.inorout+"'";
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
{
CDelConfirm m_delconf;
m_delconf.DoModal();
if(!del_confirm)
return;
int iItem;
CString sSN;
while (pos)
{
iItem = m_ListCtrl.GetNextSelectedItem(pos);
sSN = m_ListCtrl.GetItemText(iItem, 8);
strQuery="delete from ProductStock where SN='"+sSN+"'";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
}
}
//刷新列表
RefreshIn();
}
void CMaterial_MISView::OnMenuDeloutinfo()
{
// TODO: Add your command handler code here
_variant_t Holder, strQuery;
if ( m_ListCtrl && m_sCurrentList!="产品出库列表" )
{
m_ListCtrl.DestroyWindow();
theApp.inorout=_T("out");
strQuery = "select * from ProductStock where State='"+theApp.inorout+"' ";
CreateIn(strQuery);
m_sCurrentList = _T("产品出库列表");
m_StaticCtrl.SetWindowText(m_sCurrentList);
return;
}
if ( !m_ListCtrl )
{
strQuery = "select * from ProductStock where State='"+theApp.inorout+"'";
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
{
CDelConfirm m_delconf;
m_delconf.DoModal();
if(!del_confirm)
return;
int iItem;
CString sSN;
while (pos)
{
iItem = m_ListCtrl.GetNextSelectedItem(pos);
sSN = m_ListCtrl.GetItemText(iItem, 8);
strQuery="delete from ProductStock where SN='"+sSN+"'";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
}
}
//刷新列表
RefreshIn();
}
void CMaterial_MISView::OnMenuSearchbasicinfo()
{
// TODO: Add your command handler code here
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -