chagongzhi.cpp

员工管理系统,基本的数据库操作,数据库类的设计,基本的查询等

// Chagongzhi.cpp : implementation file
//

#include "stdafx.h"
#include "数据库.h"
#include "Chagongzhi.h"
#include "ADOConn.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CChagongzhi dialog


CChagongzhi::CChagongzhi(CWnd* pParent /*=NULL*/)
	: CDialog(CChagongzhi::IDD, pParent)
{
	//{{AFX_DATA_INIT(CChagongzhi)
	m_name = _T("");
	//}}AFX_DATA_INIT
}


void CChagongzhi::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChagongzhi)
	DDX_Control(pDX, IDC_CHECK2, m_check2);
	DDX_Control(pDX, IDC_CHECK1, m_check1);
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Control(pDX, IDC_COMBO1, m_combo1);
	DDX_Text(pDX, IDC_EDIT1, m_name);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CChagongzhi, CDialog)
	//{{AFX_MSG_MAP(CChagongzhi)
	ON_BN_CLICKED(IDC_CHECK1, OnCheck1)
	ON_BN_CLICKED(IDC_CHECK2, OnCheck2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CChagongzhi message handlers

BOOL CChagongzhi::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	InitList();
	 


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

void CChagongzhi::OnOK() 
{
	// TODO: Add extra validation here
	 
	  UpdateData(true);
     
	   
		_variant_t var;
		_RecordsetPtr pRecord;
		ADOConn Adoconn;
		
        _bstr_t bSQL;
         CString sql ;
		int nIndex = m_combo1.GetCurSel();
	   int nCount =  (nIndex +1 ) ;

		m_name.TrimLeft();
		m_name.TrimRight();
       
		 if(m_check1.GetCheck()!=1)
		 {
			 if(m_check2.GetCheck()!=1)
				 sql.Format("select * from 工资表 " );
             else
	        sql.Format("select * from 工资表 where 月份= %d",nCount);
			
		 }
        else
		{ 
			if(m_check2.GetCheck()!=1)
				sql.Format("select 姓名,月份,最后工资 from 工资表 where 姓名='%s' ",m_name );
			else
			sql.Format("select 姓名,月份,最后工资 from 工资表 where 姓名='%s' and 月份= %d",m_name,nCount );
		 }

		 bSQL=(_bstr_t)sql;
		pRecord=Adoconn.GetRecordSet(bSQL);
		///////
		CString str1,str2,str6;
		int n=0 ;
 
	if(pRecord->adoEOF)
	{
			MessageBox("没有这人");
			return;
	}
	m_list.DeleteAllItems();
	 m_list.Invalidate(TRUE);
		///////////
	while(!pRecord->adoEOF)
	{
			m_list.InsertItem(n,"");
	   pRecord->get_Collect(variant_t("姓名"),(_variant_t*)(&var));
		 if(var.vt!=VT_NULL)
		 {
				m_list.SetItemText(n,0,(LPCSTR)_bstr_t(var));
		 }
		pRecord->get_Collect(_variant_t("月份"),(_variant_t*)(&var));
		 if(var.vt!=VT_NULL)
		 {
		m_list.SetItemText(n,1,(LPCSTR)_bstr_t(var));
		 }
		pRecord->get_Collect(_variant_t("最后工资"),(_variant_t*)(&var));
		  if(var.vt!=VT_NULL)
		  {
		m_list.SetItemText(n,2,(LPCSTR)_bstr_t(var));
		  }
	n++;

	
	 


	   pRecord->MoveNext();
	  
	}
	//CDialog::OnOK();
}

void CChagongzhi::InitList()
{
   LV_COLUMN lvc;
   ListView_SetExtendedListViewStyle(m_list.m_hWnd,LVS_EX_FULLROWSELECT |LVS_EX_GRIDLINES);
   lvc.mask=LVCF_FMT|LVCF_WIDTH|LVCF_TEXT|LVCF_SUBITEM;
   lvc.fmt=LVCFMT_LEFT;
   m_list.InsertColumn(1,"姓名",LVCFMT_LEFT,80);
   m_list.InsertColumn(2,"月份",LVCFMT_LEFT,50);
   m_list.InsertColumn(3,"工资",LVCFMT_LEFT,90);
}

void CChagongzhi::OnCheck1() 
{
	// TODO: Add your control notification handler code here
	if(m_check1.GetCheck()==1) 
	GetDlgItem(IDC_EDIT1)->EnableWindow(TRUE);
	else
		GetDlgItem(IDC_EDIT1)->EnableWindow(FALSE);
}

void CChagongzhi::OnCheck2() 
{
	// TODO: Add your control notification handler code here
	if(m_check2.GetCheck()==1) 
	GetDlgItem(IDC_COMBO1)->EnableWindow(TRUE);
	else
		GetDlgItem(IDC_COMBO1)->EnableWindow(FALSE);
}