chakaoqing.cpp

来自「员工管理系统,基本的数据库操作,数据库类的设计,基本的查询等」· C++ 代码 · 共 206 行

// Chakaoqing.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CChakaoqing dialog


CChakaoqing::CChakaoqing(CWnd* pParent /*=NULL*/)
	: CDialog(CChakaoqing::IDD, pParent)
{
	//{{AFX_DATA_INIT(CChakaoqing)
	m_name = _T("");
	m_month = 0;
	m_kanggong = 0;
	//}}AFX_DATA_INIT
}


void CChakaoqing::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChakaoqing)
	DDX_Control(pDX, IDC_CHECK3, m_check3);
	DDX_Control(pDX, IDC_LIST2, m_list);
	DDX_Control(pDX, IDC_EDIT2, m_edit2);
	DDX_Control(pDX, IDC_EDIT3, m_edit1);
	DDX_Control(pDX, IDC_CHECK2, m_check2);
	DDX_Control(pDX, IDC_CHECK1, m_check1);
	DDX_Text(pDX, IDC_EDIT1, m_name);
	DDX_Text(pDX, IDC_EDIT3, m_month);
	DDX_Text(pDX, IDC_EDIT2, m_kanggong);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CChakaoqing, CDialog)
	//{{AFX_MSG_MAP(CChakaoqing)
	ON_BN_CLICKED(IDC_CHECK1, OnCheck1)
	ON_BN_CLICKED(IDC_CHECK2, OnCheck2)
	ON_BN_CLICKED(IDC_CHECK3, OnCheck3)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CChakaoqing message handlers

void CChakaoqing::OnOK() 
{
	// TODO: Add extra validation here
    
	

	  UpdateData(true);
    

	 
		_variant_t var;
		_RecordsetPtr pRecord;
		ADOConn Adoconn;
	 
        _bstr_t bSQL;
         CString sql ;
		 
		 if(m_check3.GetCheck( )!=1)
		 { 
			 if(m_check1.GetCheck( )!=1)
			 {
				 if(m_check2.GetCheck( )==1)
		           sql.Format("select * from 考勤表 where  旷工天数= %d",  m_kanggong);
				 else
					 sql.Format("select * from 考勤表 " );
			 }
			else 
			{
				if(m_check2.GetCheck( )==1)
                 sql.Format("select * from 考勤表 where 月份= %d and 旷工天数= %d",m_month, m_kanggong);
				else
					sql.Format("select * from 考勤表 where 月份= %d ",m_month );
			}

		 }
        else
		{
			m_name.TrimLeft();
		    m_name.TrimRight();
			sql.Format("select * from 考勤表 where 姓名='%s'",m_name);
		 }

		 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)
		 {
			//str1=(LPCSTR)_bstr_t(var);
			m_list.SetItemText(n,0,(LPCSTR)_bstr_t(var));
		 }
		pRecord->get_Collect(_variant_t("月份"),(_variant_t*)(&var));
		 if(var.vt!=VT_NULL)
		 {
			//i=var.iVal;
			 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));
			//j=var.iVal;
		  }
		  
		pRecord->get_Collect(_variant_t("早退次数"),(_variant_t*)(&var));
		  if(var.vt!=VT_NULL)
		  {m_list.SetItemText(n,3,(LPCSTR)_bstr_t(var));
			//k=var.iVal;
		  }*/
		  pRecord->get_Collect(_variant_t("旷工天数"),(_variant_t*)(&var));
		  if(var.vt!=VT_NULL)
		  {m_list.SetItemText(n,2,(LPCSTR)_bstr_t(var));
			//l=var.iVal;
		  }
	  n++;
	   pRecord->MoveNext();
	  
	}
	
}

BOOL CChakaoqing::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 CChakaoqing::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();

}

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

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

void CChakaoqing::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 CChakaoqing::OnCheck3() 
{
	// TODO: Add your control notification handler code here
	if(m_check3.GetCheck()==1) 
	GetDlgItem(IDC_EDIT1)->EnableWindow(TRUE);
	else
		GetDlgItem(IDC_EDIT1)->EnableWindow(FALSE);
}