// Opedit.cpp : implementation file
//

#include "stdafx.h"
#include "BankSystem.h"
#include "Opedit.h"
#include "BankSystemDlg.h"
#include "ADOConn.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// Opedit dialog


Opedit::Opedit(CWnd* pParent /*=NULL*/)
	: CDialog(Opedit::IDD, pParent)
{
	//{{AFX_DATA_INIT(Opedit)
	m_balance = 0.0;
	//}}AFX_DATA_INIT
}


void Opedit::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Opedit)
	DDX_Control(pDX, IDC_COMBO1, m_state);
	DDX_Control(pDX, IDC_EDIT, m_edit);
	DDX_Control(pDX, IDC_LIST1, m_userlist);
	DDX_Text(pDX, IDC_BAL, m_balance);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Opedit, CDialog)
	//{{AFX_MSG_MAP(Opedit)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	ON_BN_CLICKED(IDC_EDIT, OnEdit)
	ON_BN_CLICKED(IDC_RADIO1, OnRadio1)
	ON_BN_CLICKED(IDC_RADIO2, OnRadio2)
	ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Opedit message handlers

BOOL Opedit::OnInitDialog() 
{
	CDialog::OnInitDialog();
	GetDlgItem(IDC_BAL)->EnableWindow(false);
	GetDlgItem(IDC_COMBO1)->EnableWindow(false);
	m_edit.ShowWindow(false);
	bankId=theApp.BANKID;
	//refreshUser();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void Opedit::refreshUser()
{

    m_userlist.DeleteAllItems();
	for(int i=0;i!=7;++i)
	{
	 m_userlist.DeleteColumn(0);
	}

	m_userlist.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
    m_userlist.InsertColumn(0,_T("卡號"),LVCFMT_CENTER ,100);
	m_userlist.InsertColumn(1,_T("貨幣"),LVCFMT_LEFT,120);
    m_userlist.InsertColumn(2,_T("種類"),LVCFMT_LEFT,60);
	m_userlist.InsertColumn(3,_T("總余額"),LVCFMT_LEFT,120);
    m_userlist.InsertColumn(4,_T("狀況"),LVCFMT_LEFT,60);
    m_userlist.InsertColumn(5,_T("注冊時間"),LVCFMT_LEFT,150);
   
    ADOConn Conn;
	Conn.OnInitADOConn();
	_RecordsetPtr pRst,pRst1;
	CString sql;
    _variant_t v;
	sql.Format("select * from userInfo where bankId=\'%s\'",bankId);
	pRst=Conn.Execute((_bstr_t)sql);
	while(!pRst->adoEOF)
	{
         v=pRst->GetCollect("userID");
	     userID=v.bstrVal;
      	 sql.Format("select * from cardInfo where cardOwer=\'%s\'",userID);
         pRst1=Conn.Execute((_bstr_t)sql);
		 while(!pRst1->adoEOF)
		 {
             v=pRst1->GetCollect("cardId");
			 cardId=v.bstrVal;
			 v=pRst1->GetCollect("curType");
			 curType=v.bstrVal;
             v=pRst1->GetCollect("saveType");
			 saveType=v.bstrVal;
			 v=pRst1->GetCollect("balance");
			 balance.Format("%f",v.dblVal);
			 v=pRst1->GetCollect("IsReportLoss");
			 IsReportLoss=v.bstrVal;
			 v=pRst1->GetCollect("yearCurr");
			 yearCurr.Format("%f",v.dblVal);
             v=pRst1->GetCollect("regtime");
             regtime=v.bstrVal;
             m_userlist.InsertItem(0,cardId);
            m_userlist.SetItemText(0,1,curType);
            m_userlist.SetItemText(0,2,saveType);
			m_userlist.SetItemText(0,3,balance);
			m_userlist.SetItemText(0,4,IsReportLoss);
			m_userlist.SetItemText(0,5,regtime);
         pRst1->MoveNext();
		 }
		pRst->MoveNext();
	}
	
}

void Opedit::refreshHis()
{
    m_userlist.DeleteAllItems();
	for(int i=0;i!=7;++i)
	{
	 m_userlist.DeleteColumn(0);
	}
	m_userlist.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
	m_userlist.InsertColumn(0,_T("卡號"),LVCFMT_CENTER ,100);
    m_userlist.InsertColumn(1,_T("交易碼"),LVCFMT_CENTER ,100);
	m_userlist.InsertColumn(2,_T("交易金額"),LVCFMT_CENTER ,140);
	m_userlist.InsertColumn(3,_T("交易地點"),LVCFMT_CENTER ,100);
	m_userlist.InsertColumn(4,_T("交易時間"),LVCFMT_CENTER ,140);

	ADOConn Conn;
	Conn.OnInitADOConn();
	_RecordsetPtr pRst;
	CString sql;
    _variant_t v;
	sql.Format("select * from transInfo where opId=\'%s\'",theApp.UserID);
	pRst=Conn.Execute((_bstr_t)sql);
	while(!pRst->adoEOF)
	{
     v=pRst->GetCollect("cardId");
     cardId=v.bstrVal;
     v=pRst->GetCollect("transCode");
	 transCode=v.bstrVal;
	 v=pRst->GetCollect("transMoney");
     transMoney=v.bstrVal;
	 v=pRst->GetCollect("transPlace");
     transPlace=v.bstrVal;
	 v=pRst->GetCollect("transDate");
     transDate=v.bstrVal;
      m_userlist.InsertItem(0,cardId);
	  m_userlist.SetItemText(0,1,transCode);
      m_userlist.SetItemText(0,2,transMoney);
      m_userlist.SetItemText(0,3,transPlace);
	  m_userlist.SetItemText(0,4,transDate);
      pRst->MoveNext();
	}

}
void Opedit::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
    Count=m_userlist.GetItemCount();
	sel=m_userlist.GetSelectionMark();
    if(sel<=Count&&sel!=-1)
	{
		if(flag==1)
		{
		  m_userlist.SetHotItem(sel);
		  selcardId=m_userlist.GetItemText(sel,0);
		  ba=m_userlist.GetItemText(sel,3);
		  m_state.SetDlgItemText(0,m_userlist.GetItemText(sel,4));
		  m_balance=atof(ba);
		  UpdateData(false);
		  //MessageBox(ba);
          m_edit.ShowWindow(true);m_edit.EnableWindow(true);
		  	GetDlgItem(IDC_BAL)->EnableWindow(false);
	        GetDlgItem(IDC_COMBO1)->EnableWindow(false);
        }
	}
	
	*pResult = 0;
}

void Opedit::OnEdit() 
{
   
	GetDlgItem(IDC_BAL)->EnableWindow(true);
	GetDlgItem(IDC_COMBO1)->EnableWindow(true);
	
}

void Opedit::OnRadio1() //卡
{   m_edit.ShowWindow(false);
	GetDlgItem(IDC_BAL)->EnableWindow(false);
	GetDlgItem(IDC_COMBO1)->EnableWindow(false);
  flag=1;
  refreshUser();
	
}

void Opedit::OnRadio2() //歷史
{   m_edit.ShowWindow(false);
	GetDlgItem(IDC_BAL)->EnableWindow(false);
	GetDlgItem(IDC_COMBO1)->EnableWindow(false);
	flag=0;
	refreshHis();
}

void Opedit::OnSelchangeCombo1() 
{
   int iPos=m_state.GetCurSel();
	if(iPos!=-1)
		m_state.GetLBText(iPos,selState);	
        
	
}

void Opedit::OnOK() 
{
    this->UpdateData(true);
	if(selState=="")
	{
		AfxMessageBox("選擇");
		return;
	}
	ADOConn Conn;
	Conn.OnInitADOConn();
	_RecordsetPtr pRst;
	CString sql;
    _variant_t v;
    sql.Format("Update cardInfo set balance=\'%f\',IsReportLoss=\'%s\' where cardId=\'%s\'",m_balance,selState,selcardId);
	Conn.Execute((_bstr_t)sql);
	Time=Conn.GetCurrTime();
		theApp.transcode="操作員修改";
		theApp.flag="銀行";
		CString changeM;
        changeM.Format("改為%f",m_balance);
	sql.Format("insert into transInfo(transCode,cardId,transMoney,transDate,transPlace,opId) values(\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\')",\
		theApp.transcode,selcardId,changeM,Time,theApp.flag,theApp.UserID);
	Conn.Execute((_bstr_t)sql);
	CDialog::OnOK();
}