cx_fksqd_dlg.cpp

用C++写的数据库软件

// CX_FKSQD_Dlg.cpp : implementation file
//

#include "stdafx.h"
#include "fksqxt.h"
#include "CX_FKSQD_Dlg.h"
#include "SR_FKSQ_Dlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCX_FKSQD_Dlg dialog


CCX_FKSQD_Dlg::CCX_FKSQD_Dlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCX_FKSQD_Dlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCX_FKSQD_Dlg)
	m_NYR = _T("2008-10");
	//}}AFX_DATA_INIT
}


void CCX_FKSQD_Dlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCX_FKSQD_Dlg)
	DDX_Control(pDX, IDC_LIST1, m_ListCtrl);
	DDX_Text(pDX, IDC_NYR, m_NYR);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCX_FKSQD_Dlg, CDialog)
	//{{AFX_MSG_MAP(CCX_FKSQD_Dlg)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
	ON_BN_CLICKED(IDC_BtnReNew, OnBtnReNew)
	ON_NOTIFY(LVN_COLUMNCLICK, IDC_LIST1, OnColumnclickList1)
	ON_BN_CLICKED(IDC_BtnChaXun, OnBtnChaXun)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCX_FKSQD_Dlg message handlers

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

	// 连接数据库
	m_encaAdo.InitADOConn("","", "", "dbo.FKSQXT"); 

	// 查询记录
	m_rs = m_encaAdo.GetRecordSet("SELECT * FROM FKSQD"); 

	
	m_ListCtrl.ModifyStyle(0,LVS_REPORT);
	m_ListCtrl.SetExtendedStyle(LVS_EX_GRIDLINES | LVS_EX_FULLROWSELECT);


	//title

	m_ListCtrl.InsertColumn(1,"经办人",LVCFMT_LEFT,60);
	m_ListCtrl.InsertColumn(2,"单据编号",LVCFMT_LEFT,110);
	m_ListCtrl.InsertColumn(3,"申请单名称",LVCFMT_LEFT,150);
	m_ListCtrl.InsertColumn(4,"收款单位编号及名称",LVCFMT_LEFT,150);
	m_ListCtrl.InsertColumn(5,"预算科目编号及名称",LVCFMT_LEFT,150);
	m_ListCtrl.InsertColumn(6,"合同编号",LVCFMT_LEFT,60);

	m_ListCtrl.InsertColumn(7,"金额",LVCFMT_LEFT,60);
	m_ListCtrl.InsertColumn(8,"审批状态",LVCFMT_LEFT,90);
	m_ListCtrl.InsertColumn(9,"制单日期",LVCFMT_LEFT,120);
	m_ListCtrl.InsertColumn(10,"事由",LVCFMT_LEFT,90);
	m_ListCtrl.InsertColumn(11,"制单人",LVCFMT_LEFT,90);

	UpdateData();

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCX_FKSQD_Dlg::UpdateData()
{
//	m_rs = m_encaAdo.GetRecordSet("SELECT * FROM FKSQD");//,BH_RM where FKSQD.ZDR = BH_RM.RM "); 
	int a=-1;
	while(!m_rs->adoEOF)
	{
		a++ ;
		m_rs->MoveNext();
	}

	if(a < 0)
	{
		return;
	}
	m_ListCtrl.DeleteAllItems();
	_variant_t var;
	int iCount = 0;
	m_rs->MoveFirst();
	while( !m_rs->adoEOF )
	{
		if(iCount >= m_ListCtrl.GetItemCount())
		{
			m_ListCtrl.InsertItem(iCount,"");
		}
		m_ListCtrl.InsertItem(iCount,"");
		var = m_rs->GetCollect("JBRMC");//经办人
		if(var.vt != VT_NULL)
		{
				m_ListCtrl.SetItemText(iCount,0,(LPCSTR)_bstr_t(var));
		}

		var = m_rs->GetCollect("DJBH");//单据编号
		if(var.vt != VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,1,(LPCSTR)_bstr_t(var));
		}

		var = m_rs->GetCollect("FKSQDMC");//申请单名称
		if(var.vt != VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,2,(LPCSTR)_bstr_t(var));
		}
		
		var = m_rs->GetCollect("SKDWMC");//收款单位编号及名称
		if(var.vt != VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,3,(LPCSTR)_bstr_t(var));
		}
		var = m_rs->GetCollect("YSKMMC");//预算科目编号及名称
		if(var.vt!= VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,4,(LPCSTR)_bstr_t(var));
		}

		var = m_rs->GetCollect("HTBH");//合同编号
		if(var.vt!= VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,5,(LPCSTR)_bstr_t(var));
		}

		var = m_rs->GetCollect("HTJE");//金额
		if(var.vt!= VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,6,(LPCSTR)_bstr_t(var));
		}
		var = m_rs->GetCollect("SPZT");//审批状态
		if(var.vt!= VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,7,(LPCSTR)_bstr_t(var));
		}
		var = m_rs->GetCollect("NYR_ZD");//制单日期
		if(var.vt!= VT_NULL)
		{
			CString NYR = (LPCSTR)_bstr_t(var);
			NYR =NYR.Mid(0,NYR.Find(' ',0));
	//		MessageBox(NYR);
			m_ListCtrl.SetItemText(iCount,8,LPCSTR(NYR));
			//m_ListCtrl.SetItemText(iCount,7,(LPCSTR)_bstr_t(var));
		}
/*		var = m_rs->GetCollect("NYR_SZ");//增加日期
		if(var.vt!= VT_NULL)
		{
			CString NYR = (LPCSTR)_bstr_t(var);
			NYR =NYR.Mid(0,NYR.Find(' ',0));
	//		MessageBox(NYR);
			m_ListCtrl.SetItemText(iCount,7,LPCSTR(NYR));
			//m_ListCtrl.SetItemText(iCount,7,(LPCSTR)_bstr_t(var));
		}
*/		var = m_rs->GetCollect("SY");//事由
		if(var.vt!= VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,9,(LPCSTR)_bstr_t(var));
		}
		var = m_rs->GetCollect("ZDRMC");//制单人
		if(var.vt!= VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,10,(LPCSTR)_bstr_t(var));
		}

		m_rs->MoveNext();
		iCount++;
	}
}

void CCX_FKSQD_Dlg::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	if(m_ListCtrl.GetSelectionMark() == -1)
	{
//		MessageBox("unselected");
	}
	else
	{
//		MessageBox("selected");
		CSR_FKSQ_Dlg dlg;
		CString str = m_ListCtrl.GetItemText(m_ListCtrl.GetSelectionMark(),1);
//		MessageBox(str);
		if(dlg.readDJBH(str))
		{
//			MessageBox("before DoModal");
			dlg.DoModal();
		}
	}
	*pResult = 0;
}

void CCX_FKSQD_Dlg::OnBtnReNew() 
{
	UpdateData();
}

void CCX_FKSQD_Dlg::OnColumnclickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
//	MessageBox("click column");	
	*pResult = 0;
}

void CCX_FKSQD_Dlg::OnBtnChaXun() 
{
	CDialog::UpdateData(TRUE);
	CString sql;
	sql.Format("SELECT * FROM FKSQD where NYR_ZD like '%s'",m_NYR);
	m_rs = m_encaAdo.GetRecordSet(LPCSTR(sql));
	UpdateData();		
}