oderefdlg.cpp

access dao 数据库

// oderefdlg.cpp : 实现文件
//

#include "stdafx.h"
#include "kaoqing.h"
#include "oderefdlg.h"
#include ".\oderefdlg.h"


// coderefdlg 对话框

IMPLEMENT_DYNAMIC(coderefdlg, CDialog)
coderefdlg::coderefdlg(CWnd* pParent /*=NULL*/)
	: CDialog(coderefdlg::IDD, pParent)
	, refcode(_T(""))
	, refname(_T(""))
	,getcode(_T(""))
	,getname(_T(""))
	
{
}

coderefdlg::~coderefdlg()
{
}

void coderefdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_LIST1, codereflist);
	DDX_Control(pDX, IDC_BUTTON1, hidebt);
}


BEGIN_MESSAGE_MAP(coderefdlg, CDialog)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnNMClickList1)
//	ON_WM_CREATE()
ON_BN_CLICKED(IDC_BUTTON1, OnBnClickedButton1)
END_MESSAGE_MAP()


// coderefdlg 消息处理程序

BOOL coderefdlg::OnInitDialog()
{
	CDialog::OnInitDialog();
CRect rectt;     
	codereflist.SetTextColor(RGB(0,0,0));
	 //codereflist.SetTextBkColor(RGB(220,235,220));//文本背景色
	 //codereflist.SetBkColor(RGB(200,220,220));//背景色
     codereflist.SetExtendedStyle (LVS_EX_GRIDLINES|LVS_REPORT|LVS_EX_FULLROWSELECT|LVS_EX_FLATSB);
	
	 codereflist.InsertColumn (0,_T("编号"));
	 codereflist.InsertColumn (1,_T("姓名"));
	// TODO:  在此添加额外的初始化
codereflist.SetColumnWidth (0,100); 
codereflist.SetColumnWidth (1,100); 

this->GetClientRect (&rectt);

this->MoveWindow (10,200,rectt.Width (),rectt.Height ()+20);

kaoqingbu.Open (".\\kqbook.mdb",0,0,";PWD=caolinjie1226loveyou");//打开数据库

//this->GetParent ()->GetDlgItem (IDC_EDIT2)->SetWindowText ("99");
	return TRUE;  // return TRUE unless you set the focus to a control
	// 异常: OCX 属性页应()返回 FALSE
}

void coderefdlg::OnCancel()
{
	// TODO: 在此添加专用代码和/或调用基类
//theApp.already =false;
//m_pParent->closeref//dlg();


kaoqingbu.Close ();
DestroyWindow ();
	
}

int coderefdlg::refreshreflist(bool condition)
{CDaoRecordset personrec;
CString str;
int count=0;
personrec.m_pDatabase=&kaoqingbu;
if(!condition) personrec.Open (dbOpenDynaset, _T("select * from [人员编码表]"));
else
{//GetParent ()->GetDlgItem (IDC_EDIT1)->GetWindowText (refcode);
 //GetParent ()->GetDlgItem (IDC_EDIT3)->GetWindowText (refname);
str.Format ("select * from [人员编码表] where [编号] like '*%s*' and [姓名] like '*%s*'",refcode,refname);
personrec.Open (dbOpenDynaset,str);
}

codereflist.DeleteAllItems ();
if(personrec.IsBOF ()) {personrec.Close (); return count;}

while (!personrec.IsEOF ())
	{codereflist.InsertItem (count,CString(V_BSTRT(&personrec.GetFieldValue( 0 ))));
	 codereflist.SetItemText (count,1,CString(V_BSTRT(&personrec.GetFieldValue( 1 ))));
     personrec.MoveNext ();
	 count++;
	}
personrec.Close ();

if(count==1)  {getcode=codereflist.GetItemText (0,0);getname=codereflist.GetItemText (0,1);}
return count;
	
}

void coderefdlg::PostNcDestroy()
{
	if(kaoqingbu.IsOpen ()) kaoqingbu.Close ();
    delete this;
	//CDialog::PostNcDestroy();
}

void coderefdlg::OnNMClickList1(NMHDR *pNMHDR, LRESULT *pResult)
{int codereflistindex=-1;
 codereflistindex=codereflist.GetSelectionMark ();
 if(codereflistindex>=0)	 
  GetParent ()->GetDlgItem (IDC_EDIT1)->SetWindowText (CString(codereflist.GetItemText (codereflistindex,0)));
	
	
}

BOOL coderefdlg::PreTranslateMessage(MSG* pMsg)
{
	if(pMsg->message ==WM_KEYDOWN)
		switch(pMsg->wParam)
	             {case VK_RETURN:   return TRUE;
				  case VK_ESCAPE:   return TRUE; 
		      }

	return CDialog::PreTranslateMessage(pMsg);
}

//int coderefdlg::OnCreate(LPCREATESTRUCT lpCreateStruct)
//{
//	if (CDialog::OnCreate(lpCreateStruct) == -1)
//		return -1;
//
//	// TODO:  在此添加您专用的创建代码
//
//	return 0;
//}

void coderefdlg::OnBnClickedButton1()
{this->ShowWindow (SW_HIDE);
	// TODO: 在此添加控件通知处理程序代码
}