📄 material_misview.cpp

📁 OS: Windows 2000 Server + SP2 IDE: Visual Studio 6.0 + SP5 DataBase: SQL 2000 Server + SP2 物资管理系统
💻 CPP
📖 第 1 页 / 共 3 页
字号:
12 3 下一页
// 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);
12 3 下一页
💿 文件大小 104 K
👤 上传用户 delsboy
📂 所属分类 SQL Server
🏷️ 相关标签

#Server #2000 #SP2 #DataBase
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -