financebankdlg.cpp

这是一个学生信息管理系统

		m_cBankListCtrl.InsertItem(nItem,dlg.m_sCardId ,0);
		if(dlg.m_bAction ==false)
			m_cBankListCtrl.SetItemText (nItem,1,L"存");
		else 
			m_cBankListCtrl.SetItemText (nItem,1,L"取");
		s.Format (L"%f",dlg.m_dLastleft );
		Length=s.GetLength ();
		s.Delete (Length-4,4);
	    m_cBankListCtrl.SetItemText (nItem,2,s );
		s.Format (L"%f",dlg.m_dAccount );
		Length=s.GetLength ();
		s.Delete (Length-4,4);
		m_cBankListCtrl.SetItemText (nItem,3,s);
		s.Format (L"%f",dlg.m_dLeft );
		Length=s.GetLength ();
		s.Delete (Length-4,4);
		m_cBankListCtrl.SetItemText (nItem,4,s);
		m_cBankListCtrl.SetItemText (nItem,5,FormatDate(dlg.m_tODate ) );
		m_cBankListCtrl.SetItemText (nItem,6,FormatDate(CTime::GetCurrentTime()) );
		m_cBankListCtrl.SetItemText (nItem,7,dlg.m_sRemark );
        s.Format (L"%d",m_iFinanceBank_Id);
		m_cBankListCtrl.SetItemText (nItem,8,s);
	}
}
void CFinanceBankDlg::OnBnClickedFinanceBankUpdateBt()
{
	// TODO: 在此添加控件通知处理程序代码
    Update();
}

void CFinanceBankDlg::Delete ()
{
	POSITION pos = m_cBankListCtrl.GetFirstSelectedItemPosition();
    if (pos == NULL)
	{
		MessageBox(L"\n你没有选中任何一个银行卡操作，不可以删除！\n",L"提示",MB_ICONEXCLAMATION);
	}
    else
   {
	   if(MessageBox(L"\n此操作将永久删除该项，确定吗？\n",L"删除提醒",MB_OKCANCEL|MB_ICONQUESTION|MB_DEFBUTTON2)==IDCANCEL)
		   return ;
	   while (pos)
      {
		  int nItem = m_cBankListCtrl.GetNextSelectedItem(pos);
		  CString str;
		  str="Select * from Bank order by bODate";
	      m_pSet.Open (AFX_DB_USE_DEFAULT_TYPE,str);
		  //获取该单词
		  int m_iId;
		  m_iId=_ttol(m_cBankListCtrl.GetItemText (nItem,8));
		  m_pSet.m_strFilter.Empty ();
		  m_pSet.MoveFirst ();//刚开始移动到第一个位置
		  while(!m_pSet.IsEOF ())
		  {
			  if(m_iId ==m_pSet.m_bId )
			  {
				  m_pSet.Delete ();
				  break;
			  }
			  m_pSet.MoveNext ();
		  }		 
		  if(!m_pSet.IsDeleted ())
		  {
			  MessageBox(L"\n删除失败！\n",L"错误", MB_ICONSTOP);
			  return ;
		  }
		  m_pSet.MoveNext ();
		  //数据库删除成功后就删除列表了
		  m_cBankListCtrl.DeleteItem (nItem);
		  m_pSet.Close ();
		  //现在在右边显示个数
	      m_iBankAmount--;
	      CString s;
	      s.Format (L"%d",m_iBankAmount);
	      SetDlgItemText(IDC_BANK_AMOUNT_STATIC,s);//显示
      }
   }
}
void CFinanceBankDlg::OnBnClickedFinanceBankDeleteBt()
{
	// TODO: 在此添加控件通知处理程序代码
    Delete();
}


BOOL CFinanceBankDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	// TODO:  在此添加额外的初始化
	SetTimer(1,100,NULL);
	m_cBankListCtrl.SetExtendedStyle (LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_cBankListCtrl.InsertColumn (0,L"银行卡简号",LVCFMT_IMAGE|LVCFMT_LEFT);
	m_cBankListCtrl.InsertColumn (1,L"操作类型");
	m_cBankListCtrl.InsertColumn (2,L"上次余额");
	m_cBankListCtrl.InsertColumn (3,L"操作金额");
	m_cBankListCtrl.InsertColumn (4,L"卡内余额");
	m_cBankListCtrl.InsertColumn (5,L"操作日期");
    m_cBankListCtrl.InsertColumn (6,L"登记日期");
	m_cBankListCtrl.InsertColumn (7,L"备注");
	m_cBankListCtrl.InsertColumn (8,L"主键");
	for(int i=1; i<8; i++)
		m_cBankListCtrl.SetColumnWidth (i,63);
	m_cBankListCtrl.SetColumnWidth (0,75);
	m_cBankListCtrl.SetColumnWidth (8,0);
	return TRUE;  // return TRUE unless you set the focus to a control
	// 异常: OCX 属性页应返回 FALSE
}

void CFinanceBankDlg::Print()
{
	if(m_cBankListCtrl.GetItemCount()<= 0)
	{
		MessageBox(L"\n打印列表为空！\n",L"提示",MB_ICONEXCLAMATION);
		return;
	}
	PRNINFO PrnInfo = {0};
	PrnInfo.hListView = m_cBankListCtrl.m_hWnd;
	PrnInfo.hWnd = this->m_hWnd;
	PrnInfo.IsPrint = FALSE;
	PrnInfo.nCurPage = 1;
	PrnInfo.nMaxLine = m_cBankListCtrl.GetItemCount();
	
	CPreParentDlg DlgPreView;
	DlgPreView.SetCallBackFun(DrawInfo, PrnInfo);
	DlgPreView.DoModal();
}
void CFinanceBankDlg::OnBnClickedFinanceBankPrintBt()
{
	// TODO: 在此添加控件通知处理程序代码
    Print();
}
//打印
HCURSOR CFinanceBankDlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}
//
void CFinanceBankDlg::DrawInfo(CDC &memDC, PRNINFO PrnInfo)
{
     PrintBank(memDC,PrnInfo);
}
HBRUSH CFinanceBankDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor)
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);

	// TODO:  在此更改 DC 的任何属性
	if(m_bColor)//如果用系统的，则直接返回
		return hbr;
	pDC->SetTextColor (m_RGB_CtrlColor);
	pDC->SetBkMode(BKMODE_LAST);pDC->SetBkColor (m_RGB_BkColor);
	return (HBRUSH)m_brush.GetSafeHandle ();
	// TODO:  如果默认的不是所需画笔，则返回另一个画笔
//	return hbr;
}

void CFinanceBankDlg::OnClose()
{
	// TODO: 在此添加消息处理程序代码和/或调用默认值
    KillTimer(1);
	CDialog::OnClose();
}

void CFinanceBankDlg::OnContextMenu(CWnd* pWnd, CPoint point)
{
	// TODO: 在此处添加消息处理程序代码
	CMenu menu;
    CPoint pos=point;
	ScreenToClient(&pos);
	CRect rect;
	GetClientRect(&rect);
	if(rect.PtInRect (pos))
	{
	menu.LoadMenu(IDR_FINANCE_BANK_MENU);
	menu.GetSubMenu (0)->TrackPopupMenu (TPM_LEFTALIGN|TPM_RIGHTBUTTON, point.x, point.y, this);
	return ;
	}
	CWnd::OnContextMenu (pWnd,point);
}

void CFinanceBankDlg::OnTimer(UINT_PTR nIDEvent)
{
	// TODO: 在此添加消息处理程序代码和/或调用默认值
	POSITION pos = m_cBankListCtrl.GetFirstSelectedItemPosition();
    if (pos != NULL)//如果有列表项被选中
	{
		m_bItemClick=true;
		m_cDeleteBt.EnableWindow (true);
		m_cUpdateBt.EnableWindow (true);
	}
	else
	{
		m_bItemClick=false;
		m_cDeleteBt.EnableWindow (false);
		m_cUpdateBt.EnableWindow (false);
	}
	if(m_iBankAmount!=0)
	{
		m_cPrintBt.EnableWindow (true);
	}
	else
	{
		m_cPrintBt.EnableWindow (false);
	}
	CDialog::OnTimer(nIDEvent);
}
void CFinanceBankDlg::OnBankAll()
{
	// TODO: 在此添加命令处理程序代码
	ViewAll();
	Invalidate();
}
void CFinanceBankDlg::OnBankKind()
{
	// TODO: 在此添加命令处理程序代码
	Kind();
	Invalidate();
}
void CFinanceBankDlg::OnBankAdd()
{
	// TODO: 在此添加命令处理程序代码
	Add();
	Invalidate();
}
void CFinanceBankDlg::OnBankUpdate()
{
	// TODO: 在此添加命令处理程序代码
	Update();
	Invalidate();
}
void CFinanceBankDlg::OnBankDelete()
{
	// TODO: 在此添加命令处理程序代码
	Delete();
	Invalidate();
}
void CFinanceBankDlg::OnBankSearch()
{
	// TODO: 在此添加命令处理程序代码
	Search();
	Invalidate();
}
void CFinanceBankDlg::OnBankPrint()
{
	// TODO: 在此添加命令处理程序代码
	Print();
	Invalidate();
}

void CFinanceBankDlg::OnUpdateBankUpdate(CCmdUI *pCmdUI)
{
	// TODO: 在此添加命令更新用户界面处理程序代码
	if(m_bItemClick)
	   pCmdUI->Enable (true);
	else		
	   pCmdUI->Enable(false);
}
void CFinanceBankDlg::OnUpdateBankDelete (CCmdUI *pCmdUI)
{
	// TODO: 在此添加命令更新用户界面处理程序代码
	if(m_bItemClick)
	   pCmdUI->Enable (true);
	else		
	   pCmdUI->Enable(false);
}
void CFinanceBankDlg::OnUpdateBankPrint (CCmdUI *pCmdUI)
{
	// TODO: 在此添加命令更新用户界面处理程序代码
	if(m_iBankAmount)
	   pCmdUI->Enable (true);
	else		
	   pCmdUI->Enable(false);
}

void CFinanceBankDlg::OnInitMenuPopup(CMenu *pPopupMenu, UINT nIndex,BOOL bSysMenu)
{   
	ASSERT(pPopupMenu != NULL);    // Check the enabled state of various menu items.    
    CCmdUI state;    
	state.m_pMenu = pPopupMenu;    
	ASSERT(state.m_pOther == NULL);    
	ASSERT(state.m_pParentMenu == NULL);    // Determine if menu is popup in top-level menu and set m_pOther to    
	// it if so (m_pParentMenu == NULL indicates that it is secondary popup).    
	HMENU hParentMenu;    
	if (AfxGetThreadState()->m_hTrackingMenu == pPopupMenu->m_hMenu)        state.m_pParentMenu = pPopupMenu;   
	// Parent == child for tracking popup.    
	else if ((hParentMenu = ::GetMenu(m_hWnd)) != NULL)    
	{        
		CWnd* pParent = this;           
		// Child windows don't have menus--need to go to the top!       
		if (pParent != NULL &&(hParentMenu = ::GetMenu(pParent->m_hWnd)) != NULL)        
		{           
			int nIndexMax = ::GetMenuItemCount(hParentMenu);          
			for (int nIndex = 0; nIndex < nIndexMax; nIndex++)           
			{            
				if (::GetSubMenu(hParentMenu, nIndex) == pPopupMenu->m_hMenu)            
				{               
					// When popup is found, m_pParentMenu is containing menu.                
					state.m_pParentMenu = CMenu::FromHandle(hParentMenu);                
					break;            
				}           
			}        
		}    
	}    
	state.m_nIndexMax = pPopupMenu->GetMenuItemCount();    
	for (state.m_nIndex = 0; state.m_nIndex < state.m_nIndexMax;      
		state.m_nIndex++)    
	{        
		state.m_nID = pPopupMenu->GetMenuItemID(state.m_nIndex);        
		if (state.m_nID == 0)           
			continue; // Menu separator or invalid cmd - ignore it.        
		ASSERT(state.m_pOther == NULL);        
		ASSERT(state.m_pMenu != NULL);        
		if (state.m_nID == (UINT)-1)        
		{           
			// Possibly a popup menu, route to first item of that popup.          
			state.m_pSubMenu = pPopupMenu->GetSubMenu(state.m_nIndex);  
			if (state.m_pSubMenu == NULL||(state.m_nID = state.m_pSubMenu->GetMenuItemID(0)) == 0 ||state.m_nID == (UINT)-1)           
			{            
				continue;       // First item of popup can't be routed to.           
			}           
			state.DoUpdate(this, TRUE);   // Popups are never auto disabled.       
		}        
		else        
		{           // Normal menu item.           
			// Auto enable/disable if frame window has m_bAutoMenuEnable           
			// set and command is _not_ a system command.           
			state.m_pSubMenu = NULL;           
			state.DoUpdate(this, FALSE);        
		}        
		// Adjust for menu deletions and additions.        
		UINT nCount = pPopupMenu->GetMenuItemCount();        
		if (nCount < state.m_nIndexMax)        
		{           
			state.m_nIndex -= (state.m_nIndexMax - nCount);           
			while (state.m_nIndex < nCount &&            
				pPopupMenu->GetMenuItemID(state.m_nIndex) == state.m_nID) 
			{            
				state.m_nIndex++;          
			}        
		}        
		state.m_nIndexMax = nCount;    
	}
}