banksystemdlg.cpp

各个银行

void CBankSystemDlg::OnBankser() //银行办理
{   theApp.flag="银行";
	m_op1.ShowWindow(!SW_HIDE);m_op2.ShowWindow(!SW_HIDE);
	m_op3.ShowWindow(!SW_HIDE);m_op4.ShowWindow(!SW_HIDE);
	m_op5.ShowWindow(!SW_HIDE);m_op6.ShowWindow(!SW_HIDE);
	m_op7.ShowWindow(!SW_HIDE);m_op8.ShowWindow(!SW_HIDE);
	m_op4.EnableWindow(true);
	m_op7.EnableWindow(true);
	if(theApp.type=="死期")
    m_op7.EnableWindow(false);
    m_bankser.ShowWindow(SW_HIDE);
    m_atm.ShowWindow(SW_HIDE);
    m_inte.ShowWindow(SW_HIDE);
	m_outop.ShowWindow(SW_HIDE);
	
}

void CBankSystemDlg::OnBack() //返回
{
	m_op1.ShowWindow(SW_HIDE);m_op2.ShowWindow(SW_HIDE);
	m_op3.ShowWindow(SW_HIDE);m_op4.ShowWindow(SW_HIDE);
	m_op5.ShowWindow(SW_HIDE);m_op6.ShowWindow(SW_HIDE);
	m_op7.ShowWindow(SW_HIDE);m_op8.ShowWindow(SW_HIDE);
	m_bankser.ShowWindow(!SW_HIDE);
    m_atm.ShowWindow(!SW_HIDE);
    m_inte.ShowWindow(!SW_HIDE);
	m_outop.ShowWindow(!SW_HIDE);
	
}

void CBankSystemDlg::OnOutop() //退出
{
  if(MessageBox("确定退出管理吗?","系统提示",MB_OKCANCEL|MB_ICONQUESTION)==1)
  {  SetWindowText("银联系统");
  GetDlgItem(IDC_USERREG)->EnableWindow(true);
  	 GetDlgItem(IDC_RADIO2)->ShowWindow(SW_HIDE);
	 GetDlgItem(IDC_RADIO1)->ShowWindow(SW_HIDE);
	 GetDlgItem(IDC_STATIC)->ShowWindow(SW_HIDE);
	  m_print.ShowWindow(false);
	 m_edit.ShowWindow(SW_HIDE);
	m_bankser.ShowWindow(SW_HIDE);
    m_atm.ShowWindow(SW_HIDE);
    m_inte.ShowWindow(SW_HIDE);
	m_outop.ShowWindow(SW_HIDE);
	m_bankreg.ShowWindow(SW_HIDE);
	m_usereg.ShowWindow(!SW_HIDE);
	m_list.ShowWindow(SW_HIDE);
	m_find.EnableWindow(false);
	theApp.IsonName="";//已登陆名
	theApp.IsonID="";//ID
	theApp.IsonPID="";//身份
	 theApp.IsonAddr=theApp.IsonTel="";
   theApp.CARDID="";//记住登陆的卡号
     theApp.flag="";//地点
	 theApp.transcode="";//交易码
   theApp.transmoney="";//交易钱	
	 theApp.type="";//是否为死期
	theApp.UserID="";
   theApp.BANKID="";
	theApp.CARDID="";
	theApp.IsonID="";
	theApp.info="";
	theApp.isloss="";
	GetDlgItem(IDC_USERREG)->SetWindowText("银行开户");
    GetDlgItem(IDC_LOGIN)->EnableWindow(true);
	GetDlgItem(IDC_OPERATE)->EnableWindow(false);

  }
}
void CBankSystemDlg::OnInfo() //所有卡信息
{
	CCardInfo card;
	card.DoModal();
}

void CBankSystemDlg::OnBalance() //查询余额
{
	// TODO: Add your control notification handler code here
LOCALINFO  local;
local.DoModal();


}

void CBankSystemDlg::OnMove() //转帐
{
     MOVE move;
	 move.DoModal();
	
}

void CBankSystemDlg::OnLoss() //挂失
{
	if(MessageBox("确定挂失","系统提示",MB_OKCANCEL|MB_ICONQUESTION)==1)
	{
		ADOConn Conn;
		Conn.OnInitADOConn();
		_RecordsetPtr pRst;
			_variant_t v;
        CString sql,opName,Time,randName;
           if(theApp.flag=="银行")
		   {
      sql.Format("select * from operator,cardInfo,userInfo where cardInfo.cardId=\'%s\'and cardInfo.cardOwer=userInfo.userID and userInfo.bankId=Operator.BankId",theApp.CARDID); 
	try
	{
	 pRst= Conn.Execute((_bstr_t)sql);
    }
	catch(_com_error &e)
	{
		AfxMessageBox(e.Description());
	}
    vector<CString>ID;
	while(!pRst->adoEOF)
	{
      v=pRst->GetCollect("opId");
      opName=v.bstrVal;  
	  ID.push_back(opName);
	  pRst->MoveNext();
	}
	srand((unsigned)time(NULL));
	int x = rand()%(ID.size());
    randName=ID.at(x);
		   }
    Time=Conn.GetCurrTime();
	theApp.transcode="挂失";
    sql.Format("Update cardInfo set IsReportLoss=\'%s\' where cardId=\'%s\'","挂失",theApp.CARDID);
		Conn.Execute((_bstr_t)sql);
    sql.Format("insert into transInfo(transCode,cardId,transMoney,transDate,transPlace,opId) values(\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\')",\
		theApp.transcode,theApp.CARDID,theApp.transmoney,Time,theApp.flag,randName);
        Conn.Execute((_bstr_t)sql);

	}
	

}

void CBankSystemDlg::OnSaveget() //存取
{
	SAVEGET  save;
	save.DoModal();
}

void CBankSystemDlg::OnExchang() //兑换
{
	EXChange  change;
	theApp.transcode="兑换";
	change.DoModal();
}

HBRUSH CBankSystemDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) //背景
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
	 if(nCtlColor==CTLCOLOR_DLG)
    {
        return m_brush;
    }
	 if(nCtlColor=CTLCOLOR_STATIC)
	 {
		 pDC->SetBkMode(TRANSPARENT);
		 pDC->SetTextColor(RGB(255,255,0));
		 return m_brush;
	 }
	return hbr;
}

void CBankSystemDlg::OnFind() 
{
	if(theApp.UserID=="admin")//超级管理员
	{   
      	GetDlgItem(IDC_RADIO2)->ShowWindow(!SW_HIDE);
	    GetDlgItem(IDC_RADIO1)->ShowWindow(!SW_HIDE);

	}
	else//普通管理员
	{
		Opedit edit;
		if(edit.DoModal()==IDOK)
        AfxMessageBox("成功");
	}
}
void CBankSystemDlg::OnRadio1() //银行
{   isbank=1;//判断调用哪个对话框
	m_edit.ShowWindow(SW_HIDE);
  RefreshData();
  GetDlgItem(IDC_LIST1)->ShowWindow(!SW_HIDE);
	
}
void CBankSystemDlg::refresh()
{
m_list.DeleteAllItems();
 GetDlgItem(IDC_LIST1)->ShowWindow(!SW_HIDE);
 for(int i=0;i!=7;++i)
 {
	 m_list.DeleteColumn(0);
 }
 ADOConn Conn;
 Conn.OnInitADOConn();
 _RecordsetPtr pRst;
 _variant_t v;
 CString sql;
 CString MoneyName,Live,Dead,Curr;
 m_list.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
 m_list.InsertColumn(0,_T("币种"),LVCFMT_CENTER ,120);
 m_list.InsertColumn(1,_T("活期利率"),LVCFMT_CENTER ,100);
 m_list.InsertColumn(2,_T("死期利率"),LVCFMT_CENTER ,100);
 m_list.InsertColumn(3,_T("汇率"),LVCFMT_CENTER ,100);
  sql.Format("select  * from MoneyOP");	
  pRst=Conn.Execute((_bstr_t)sql);
  while(!pRst->adoEOF)
  {
	          v=pRst->GetCollect("MoneyName");
              MoneyName=v.bstrVal;
			  v=pRst->GetCollect("Live");
              Live.Format("%f",v.dblVal);
              v=pRst->GetCollect("dead");
              Dead.Format("%f",v.dblVal);
			   v=pRst->GetCollect("currency");
              Curr.Format("%f",v.dblVal);
            
			  m_list.InsertItem(0,MoneyName);
	          m_list.SetItemText(0,1,Live);
			  m_list.SetItemText(0,2,Dead);
              m_list.SetItemText(0,3,Curr);
			  pRst->MoveNext();
  }

}
void CBankSystemDlg::OnRadio2() //利率
{ 
	isbank=0;
 m_edit.ShowWindow(SW_HIDE);
 refresh();
}



void CBankSystemDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{ 

  Count=m_list.GetItemCount();
  sel=m_list.GetSelectionMark();
  if(sel<=Count&&sel!=-1)
  {  
	  m_list.SetHotItem(sel);
	  m_edit.ShowWindow(!SW_HIDE);
  }
	*pResult = 0;
}

void CBankSystemDlg::OnEdititem() 
{
	if(isbank==1)
  {
	  bankId=m_list.GetItemText(sel,0);
      Name=m_list.GetItemText(sel,1);
      Addr=m_list.GetItemText(sel,2);
	  Tel=m_list.GetItemText(sel,3);
      PostCode=m_list.GetItemText(sel,4);
	  CEDIT edit;
	  edit.DoModal();
  }
	if(isbank==0)
	{
        moneyname=m_list.GetItemText(sel,0);
		live=m_list.GetItemText(sel,1);
		dead=m_list.GetItemText(sel,2);
		curr=m_list.GetItemText(sel,3);
		CEDITMON editmon;
		editmon.DoModal();
	}
	
}

void CBankSystemDlg::OnPrint() 
{
	//从数据库中查找所有信息
	AllData="超级管理员：admin  12345";
 
    AllData+="\r\n";
    ADOConn Conn;
    Conn.OnInitADOConn();
    _RecordsetPtr pRst,pRst1,pRst2,pRst3;
    _variant_t v;
    CString sql;
	sql.Format("select *from bankInfo ");
	pRst=Conn.Execute((_bstr_t)sql);
	while(!pRst->adoEOF)
	{
         v=pRst->GetCollect("bankId");
		 bankId=v.bstrVal;
		 v=pRst->GetCollect("bankName");
		 Name=v.bstrVal;
		 AllData+="银行:"+Name+"\r\n";
       sql.Format("select *from Operator where BankId=\'%s\'",bankId);//操作员
	   pRst1=Conn.Execute((_bstr_t)sql);
	   while(!pRst1->adoEOF)
	   {
		   v=pRst1->GetCollect("opId");
		   opId=v.bstrVal;
		   v=pRst1->GetCollect("opPwd");
		   opPwd=v.bstrVal;
         AllData+="操作员："+opId+"  "+opPwd+"\r\n";
		 pRst1->MoveNext();
	   }
	   sql.Format("select *from userInfo where BankId=\'%s\'",bankId);//用户
       pRst2=Conn.Execute((_bstr_t)sql);
	    while(!pRst2->adoEOF)
		{
           v=pRst2->GetCollect("userID");
		   userId=v.bstrVal;
		   AllData+="用户"+userId+"\r\n";
           sql.Format("select *from cardInfo where cardOwer=\'%s\'",userId);//卡
           pRst3=Conn.Execute((_bstr_t)sql);
		   while(!pRst3->adoEOF)
		   {
               v=pRst3->GetCollect("cardId");
			   cardId=v.bstrVal;
			   v=pRst3->GetCollect("cardPwd");
			   cardPwd=v.bstrVal;
			   AllData+="卡号"+cardId+"密码"+cardPwd+"\r\n";
			   pRst3->MoveNext();
		   }
		   pRst2->MoveNext();
		}
	 pRst->MoveNext();
	}
	//MessageBox(AllData);
	CString  sPath="c://BankUserData.txt";
	CFile   file;
	file.Open(sPath,CFile::modeCreate|CFile::modeWrite);
	file.Write(AllData,AllData.GetLength());
	file.Close();
	::ShellExecute(NULL,"open",sPath,NULL,NULL,SW_SHOWNORMAL);

}

void CBankSystemDlg::OnAtmser() 
{
    theApp.flag="ATM";
	m_op1.ShowWindow(!SW_HIDE);m_op2.ShowWindow(!SW_HIDE);
	m_op3.ShowWindow(!SW_HIDE);m_op4.ShowWindow(!SW_HIDE);
	m_op5.ShowWindow(!SW_HIDE);m_op6.ShowWindow(!SW_HIDE);
	m_op7.ShowWindow(!SW_HIDE);m_op8.ShowWindow(!SW_HIDE);
    m_op4.EnableWindow(false);
    m_op7.EnableWindow(false);
    m_bankser.ShowWindow(SW_HIDE);
    m_atm.ShowWindow(SW_HIDE);
    m_inte.ShowWindow(SW_HIDE);
	m_outop.ShowWindow(SW_HIDE);
	
}

void CBankSystemDlg::OnInterser() 
{
	theApp.flag="网上";
	m_op1.ShowWindow(!SW_HIDE);m_op2.ShowWindow(!SW_HIDE);
	m_op3.ShowWindow(!SW_HIDE);m_op4.ShowWindow(!SW_HIDE);
	m_op5.ShowWindow(!SW_HIDE);m_op6.ShowWindow(!SW_HIDE);
	m_op7.ShowWindow(!SW_HIDE);m_op8.ShowWindow(!SW_HIDE);
	
	m_op4.EnableWindow(false);
    m_op7.EnableWindow(false);
	if(theApp.type=="死期")
     m_op4.EnableWindow(true);
    m_bankser.ShowWindow(SW_HIDE);
    m_atm.ShowWindow(SW_HIDE);
    m_inte.ShowWindow(SW_HIDE);
	m_outop.ShowWindow(SW_HIDE);
	
}