material_misview.cpp

利用vc开发的一个数据库管理信息系统

            sNO = m_ListCtrl.GetItemText(iItem, 0);
			sID = m_ListCtrl.GetItemText(iItem, 1);
			sAccount = m_ListCtrl.GetItemText(iItem, 6);
			//double sfAccount=atof(sAccount);
			sValue = m_ListCtrl.GetItemText(iItem,8);
			//double sfValue=atof(sValue);
			sBase = m_ListCtrl.GetItemText(iItem,12);

		    strQuery = "delete from msave where rkno='"+sNO+"'";
	        theApp.ADOExecute(theApp.m_pADOSet, strQuery);
			
			strQuery="update msurplus set yeaccount=yeaccount-"+sAccount+",yevalue=yevalue-"\
				+sValue+" where yeid='"+sID+"'and yebase='"+sBase+"'";
			theApp.ADOExecute(theApp.m_pADOSet,strQuery); 

			strQuery="delete from msurplus where yeaccount=0";
			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();
		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);
		return;
	}
    else
	{
        int iItem;       
		CString sNO;
		CString sID;
		CString sAccount;
		CString sValue;
		CString sBase;

		
		while (pos)
		{
            iItem = m_ListCtrl.GetNextSelectedItem(pos);
            sNO = m_ListCtrl.GetItemText(iItem, 0);
			sID = m_ListCtrl.GetItemText(iItem, 1);
			sAccount = m_ListCtrl.GetItemText(iItem, 6);
			sValue = m_ListCtrl.GetItemText(iItem,8);
			sBase = m_ListCtrl.GetItemText(iItem,12);
		    strQuery = "delete from muse where lyno='"+sNO+"'";
	        theApp.ADOExecute(theApp.m_pADOSet, strQuery);
			
			strQuery="update msurplus set yeaccount=yeaccount+"+sAccount+",yevalue=yevalue+"\
				+sValue+" where yeid='"+sID+"'and yebase='"+sBase+"'";
			theApp.ADOExecute(theApp.m_pADOSet,strQuery); 

			strQuery="delete from msurplus where yeaccount=0";
			theApp.ADOExecute(theApp.m_pADOSet,strQuery);
	
		}
	}
	//刷新列表
	RefreshOut();
}

void CMaterial_MISView::OnMenuSearchbasicinfo() 
{
	// TODO: Add your command handler code here	
	_variant_t strQuery, Holder;	
	strQuery = "select wzname from material";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	int iCount = theApp.m_pADOSet->GetRecordCount();
	if ( 0==iCount ) 
	{
		AfxMessageBox(_T("目前没有记录！"), MB_ICONEXCLAMATION);
		return;
	}
	CCheckBasicInfoDLG dlg;
	dlg.DoModal();
}

void CMaterial_MISView::OnMenuSearchininfo() 
{
	// TODO: Add your command handler code here
	
	CSearch dlg;
	dlg.m_sType=true;
	_variant_t strQuery;
	strQuery="select * from msave";
	theApp.ADOExecute(theApp.m_pADOSet,strQuery);
	int icount=theApp.m_pADOSet->GetRecordCount();
	if(0==icount)
	{
		AfxMessageBox(_T("目前没有入库信息！"), MB_ICONEXCLAMATION);
		return;
	}
	dlg.DoModal();
}

void CMaterial_MISView::OnMenuSearchoutinfo() 
{
	// TODO: Add your command handler code here
	CSearch dlg;
	dlg.m_sType=false;
	_variant_t strQuery;
	strQuery="select * from muse";
	theApp.ADOExecute(theApp.m_pADOSet,strQuery);
	int icount=theApp.m_pADOSet->GetRecordCount();
	if(0==icount)
	{
		AfxMessageBox(_T("目前没有出库信息！"), MB_ICONEXCLAMATION);
		return;
	}
	dlg.DoModal();
}

void CMaterial_MISView::OnMenuSearchsurplus() 
{
	// TODO: Add your command handler code here
	_variant_t strQuery;
	
	m_ListCtrl.DestroyWindow();
	strQuery = "select * from msurplus";
	CreateSurplusInfo(strQuery);
	m_sCurrentList = _T("物资余额列表");
    m_StaticCtrl.SetWindowText(m_sCurrentList);

	CSearchplusInfo dlg;
	dlg.DoModal();
	return;
}


void CMaterial_MISView::RefreshMaterial()
{
	if (m_ListCtrl)	m_ListCtrl.DestroyWindow();
	
    CreateMaterialInfo();
    
	m_sCurrentList = _T("物资列表");
    m_StaticCtrl.SetWindowText(m_sCurrentList);
}

void CMaterial_MISView::CreateMaterialInfo()
{
	m_sCurrentList = _T("物资列表");
    m_StaticCtrl.SetWindowText(m_sCurrentList);
	
	CRect rect;
	GetClientRect(rect);
	rect.top += 30;

	m_ListCtrl.Create(WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT, rect, this, 1);

	m_ListCtrl.SetBkColor(RGB(177, 151, 240));
	m_ListCtrl.SetTextColor(RGB(0,0,0));
	m_ListCtrl.SetTextBkColor(RGB(177, 151, 240));
	
	// Set EX-Style
	m_ListCtrl.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);

	// 创建标题
	m_ListCtrl.InsertColumn(0,_T("物资编号"), LVCFMT_LEFT, 100);
	m_ListCtrl.InsertColumn(1,_T("物资名称"), LVCFMT_LEFT, 100);
    m_ListCtrl.InsertColumn(2,_T("规格型号"), LVCFMT_LEFT, 100);
	m_ListCtrl.InsertColumn(3,_T("类    别"), LVCFMT_LEFT, 100);
	m_ListCtrl.InsertColumn(4,_T("计量单位"), LVCFMT_LEFT, 100);

	// 获得所有记录
	_variant_t Holder, strQuery;
    strQuery = "select * from material order by wzid";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
    int iCount = theApp.m_pADOSet->GetRecordCount();
	if ( 0==iCount ) return;
	
    CString str;
	theApp.m_pADOSet->MoveFirst();
	for(int i=0; i<iCount; i++)
	{
		// 获得物资ID
		Holder = theApp.m_pADOSet->GetCollect("wzid");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.InsertItem(i, str);
	    // 获得物资名称
        Holder = theApp.m_pADOSet->GetCollect("wzname");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 1, str);
		// 获得物资规格型号
        Holder = theApp.m_pADOSet->GetCollect("wzspec");
		str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 2, str);
		// 获得物资类别
        Holder = theApp.m_pADOSet->GetCollect("wzkind");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 3, str);
		// 获得物资计量单位
        Holder = theApp.m_pADOSet->GetCollect("wzunit");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 4, str);		
		theApp.m_pADOSet->MoveNext();
	}
}

void CMaterial_MISView::LoadListCtrl()
{
	CRect rect;
	GetClientRect(rect);
	rect.top += 30;

	m_ListCtrl.Create(WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT,
                      rect, this, 1);

	m_ListCtrl.SetBkColor(RGB(177, 151, 240));
	m_ListCtrl.SetTextColor(RGB(0,0,0));
	m_ListCtrl.SetTextBkColor(RGB(177, 151, 240));
	
	m_ListCtrl.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);
	m_ListCtrl.InsertColumn(0,"Node ID", LVCFMT_LEFT, 250);
	m_ListCtrl.InsertColumn(1,"2 ID", LVCFMT_LEFT, 250);
	
	CString str;
	for (int i=0; i<100; i++)
	{
		str.Format("%d", i);
		m_ListCtrl.InsertItem(i, str);
	}	
}

void CMaterial_MISView::UnLoadListCtrl()
{
	m_ListCtrl.DestroyWindow();
}

void CMaterial_MISView::OnContextMenu(CWnd* pWnd, CPoint point) 
{
	// TODO: Add your message handler code here
	if ( ""==m_sCurrentList ) return;
	
	CMenu menu;
	if ( _T("物资列表")==m_sCurrentList ) menu.LoadMenu(IDR_MENU_BASICINFO);
	else if ( _T("物资入库列表")==m_sCurrentList ) menu.LoadMenu(IDR_MENU_IN);
	else if ( _T("物资出库列表")==m_sCurrentList ) menu.LoadMenu(IDR_MENU_OUT);
	CMenu* pMenu=menu.GetSubMenu(0);
	pMenu->TrackPopupMenu(TPM_LEFTALIGN|TPM_LEFTBUTTON|TPM_RIGHTBUTTON,point.x,point.y,this);
	
	return;
}

void CMaterial_MISView::OnInitialUpdate() 
{
	CView::OnInitialUpdate();
	
	// TODO: Add your specialized code here and/or call the base class
	CRect rect;
	rect.left = rect.top =5;
    rect.bottom = 30;
	rect.right = 120;
	m_StaticCtrl.Create(m_sCurrentList, WS_VISIBLE, rect, this, 1);	
}

void CMaterial_MISView::RefreshMaterialWindow(_variant_t strQuery)
{
	if (m_ListCtrl)	m_ListCtrl.DestroyWindow();
	
 	CreateMaterialWindow( strQuery );
    
	m_sCurrentList = _T("物资列表");
    m_StaticCtrl.SetWindowText(m_sCurrentList);
}

void CMaterial_MISView::CreateMaterialWindow(_variant_t strQuery)
{
	m_sCurrentList = _T("物资列表");
    m_StaticCtrl.SetWindowText(m_sCurrentList);
	
	// Get Client Rect
	CRect rect;
	GetClientRect(rect);
	rect.top += 30;

	// Create
	m_ListCtrl.Create(WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT, rect, this, 1);

	// Set Color
	m_ListCtrl.SetBkColor(RGB(177, 151, 240));
	m_ListCtrl.SetTextColor(RGB(0,0,0));
	m_ListCtrl.SetTextBkColor(RGB(177, 151, 240));
	
	// Set EX-Style
	m_ListCtrl.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);

	// Create Header
	m_ListCtrl.InsertColumn(0,_T("物资编号"), LVCFMT_LEFT, 100);
	m_ListCtrl.InsertColumn(1,_T("物资名称"), LVCFMT_LEFT, 100);
    m_ListCtrl.InsertColumn(2,_T("规格型号"), LVCFMT_LEFT, 100);
	m_ListCtrl.InsertColumn(3,_T("类    别"), LVCFMT_LEFT, 100);
	m_ListCtrl.InsertColumn(4,_T("计量单位"), LVCFMT_LEFT, 100);

	// 获得记录集
	_variant_t Holder;
    theApp.ADOExecute(theApp.m_pADOSet, strQuery);
    int iCount = theApp.m_pADOSet->GetRecordCount();
	if ( 0==iCount ) return;
	
    CString str;
	theApp.m_pADOSet->MoveFirst();
	for(int i=0; i<iCount; i++)
	{

		Holder = theApp.m_pADOSet->GetCollect("wzid");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.InsertItem(i, str);

        Holder = theApp.m_pADOSet->GetCollect("wzname");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 1, str);
	
        Holder = theApp.m_pADOSet->GetCollect("wzspec");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 2, str);
	
        Holder = theApp.m_pADOSet->GetCollect("wzkind");
		str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 3, str);
	
        
        Holder = theApp.m_pADOSet->GetCollect("wzunit");
		str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_ListCtrl.SetItemText(i, 4, str);