studentdlg.cpp

最后的成品vc考勤ACCSEE数据库做的 还有文档 希望大家多多指点[e-mail]

// StudentDlg.cpp : implementation file
//

#include "stdafx.h"
#include "studentscore.h"
#include "StudentDlg.h"
#include"StudentSet.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CStudentDlg dialog


CStudentDlg::CStudentDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CStudentDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CStudentDlg)
	//}}AFX_DATA_INIT
    m_brush.CreateSolidBrush(RGB(0,0,255));
	m_font.CreatePointFont(200,"华文行楷");
}


void CStudentDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CStudentDlg)
	
	DDX_Control(pDX, IDC_STUDNET_EDIT, m_bEdit);
	DDX_Control(pDX, IDC_STUDNET_DEL, m_bDel);
	DDX_Control(pDX, IDC_STUDENT_OK, m_bConfirm);
	DDX_Control(pDX, IDC_STUDENT_ADD, m_bAdd);
	DDX_Control(pDX, IDC_STUDENT_PHONE, m_strPhone);
	DDX_Control(pDX, IDC_STUDENT_NO, m_strNo);
	DDX_Control(pDX, IDC_STUDENT_NAME, m_strName);
	DDX_Control(pDX, IDC_STUDENT_AGE, m_strAge);
	DDX_Control(pDX, IDC_STUDENT_ADDRESS, m_strAddress);
	DDX_Control(pDX, IDC_LIST_STUDENT, m_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CStudentDlg, CDialog)
	//{{AFX_MSG_MAP(CStudentDlg)
	ON_NOTIFY(NM_CLICK, IDC_LIST_STUDENT, OnClickListStudent)
	ON_BN_CLICKED(IDC_STUDENT_ADD, OnStudentAdd)
	ON_BN_CLICKED(IDC_STUDNET_DEL, OnStudnetDel)
	ON_BN_CLICKED(IDC_STUDNET_EDIT, OnStudnetEdit)
	ON_BN_CLICKED(IDC_STUDENT_OK, OnStudentOk)
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CStudentDlg message handlers

void CStudentDlg::RefreshList()
{
    m_list.DeleteAllItems();
    m_studentSet.Open();
    m_studentSet.m_strFilter="active_status='Y'";
    m_studentSet.Requery();
    for(int i=0;i<m_studentSet.GetRecordCount();i++)
	{
   CString temp;
   m_studentSet.GetFieldValue("student_id",temp);
   m_list.InsertItem(i,temp);
  // m_studentSet.SetFieldValue("student_name",temp);
   m_list.SetItemText(i,1,m_studentSet.m_student_no);
   //m_studentSet.GetFieldValue("student_password",temp);
   m_list.SetItemText(i,2,m_studentSet.m_student_name);
  // m_studentSet.GetFieldValue("student_level",temp);
   m_list.SetItemText(i,3,m_studentSet.m_student_sex);
    m_studentSet.GetFieldValue("student_age",temp);

   m_list.SetItemText(i,4,temp);

m_list.SetItemText(i,5,m_studentSet.m_student_phone);
m_list.SetItemText(i,6,m_studentSet.m_student_address);
   m_studentSet.MoveNext();
	 
	}
m_studentSet.Close();

}

void CStudentDlg::ResetButton()
{
    m_strNo.EnableWindow(false);
	m_strName.EnableWindow(false);
	m_strAge.EnableWindow(false);
	m_strAddress.EnableWindow(false);

	m_strPhone.EnableWindow(false);
    femaleRadio->EnableWindow(false);
    maleRadio->EnableWindow(false);


    m_bConfirm.EnableWindow(false);
  
	m_bEdit.EnableWindow(true);
	m_bAdd.EnableWindow(true);
	m_bDel.EnableWindow(true);
}

BOOL CStudentDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_list.InsertColumn(0,"记录号");
	m_list.InsertColumn(1,"编号");
	m_list.InsertColumn(2,"姓名");
	m_list.InsertColumn(3,"性别");
	m_list.InsertColumn(4,"年龄");
	m_list.InsertColumn(5,"电话");
	m_list.InsertColumn(6,"地址");
    
	RECT rectList;
	m_list.GetWindowRect(&rectList);
    
	int wid=rectList.right-rectList.left-4;

	for(int i=0;i<7;i++)
	{
		m_list.SetColumnWidth(i,wid/7);
	}
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);
	RefreshList();
	for(int j=0;j<30;j++)
	{
		CString s;
		s.Format("%d",j);
		m_strAge.AddString(s);
	}
       femaleRadio=(CButton*)this->GetDlgItem(IDC_RADIO_SEX_FEMALE);
       maleRadio=(CButton*)this->GetDlgItem(IDC_RADIO_SEX_MALE);

      femaleRadio->EnableWindow(false);
    maleRadio->EnableWindow(false);
    ResetButton();

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

void CStudentDlg::OnClickListStudent(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	
	int row=m_list.GetSelectionMark();
    CString s;
	s=m_list.GetItemText(row,1);
	m_strNo.SetWindowText(s);

    s=m_list.GetItemText(row,2);
	m_strName.SetWindowText(s);
    s=m_list.GetItemText(row,3);
//	m_strUser.SetWindowText(s);
	if(s=="女")
	{
    femaleRadio->SetCheck(true);
	maleRadio->SetCheck(false);
	}
	else
	{
     femaleRadio->SetCheck(false);
	 maleRadio->SetCheck(true);
	}


	s=m_list.GetItemText(row,4);
	int i=m_strAge.FindString(0,s);
     m_strAge.SelectString(i,s);
	 s=m_list.GetItemText(row,5);
	 m_strPhone.SetWindowText(s);


	 s=m_list.GetItemText(row,6);
	 m_strAddress.SetWindowText(s);
	
	 *pResult = 0;
}

void CStudentDlg::OnStudentAdd() 
{
	// TODO: Add your control notification handler code here
	m_strNo.EnableWindow(true);
	m_strNo.SetWindowText("");
	m_strName.EnableWindow(true);
	m_strName.SetWindowText("");
	m_strAge.EnableWindow(true);
	m_strAge.SelectString(0,"20");
	m_strPhone.EnableWindow(true);
//m_strPhone.SetWindowText("");
	m_strAddress.EnableWindow(true);
	femaleRadio->EnableWindow(true);

	maleRadio->EnableWindow(true);

	m_studentSet.Open();
	m_studentSet.AddNew();
    m_bConfirm.EnableWindow(true);
	m_bAdd.EnableWindow(false);
	m_bEdit.EnableWindow(false);
    m_bDel.EnableWindow(false);

}

void CStudentDlg::OnStudnetDel() 
{
	// TODO: Add your control notification handler code here
	int row=m_list.GetSelectionMark();
	CString s,strSQL;
	s=m_list.GetItemText(row,0);
	if(s=="")
	{
		MessageBox("请选择一行");

	}
	else
	{
		if(MessageBox("确定要删除?","删除询问！",MB_ICONQUESTION | MB_OKCANCEL)==IDOK)
		{
	      strSQL.Format("user_id=%s",s);
	      m_studentSet.Open();
	     m_studentSet.m_strFilter=strSQL;
	     m_studentSet.Requery();
         m_studentSet.Edit();
		 m_studentSet.m_active_status="N";
		 m_studentSet.Update();
		 m_studentSet.Close();
		 RefreshList();
		}
	}
}

void CStudentDlg::OnStudnetEdit() 
{
	// TODO: Add your control notification handler code here
	int row=m_list.GetSelectionMark();
	CString s,strSQL;
	s=m_list.GetItemText(row,0);
	if(s=="")
	{
		MessageBox("请选择一行");

	}
	else{
	strSQL.Format("student_id=%s",s);
	m_studentSet.Open();
	m_studentSet.m_strFilter=strSQL;
	m_studentSet.Requery();
    m_studentSet.Edit();
	m_bConfirm.EnableWindow(true);
	m_bAdd.EnableWindow(false);
	m_bEdit.EnableWindow(false);
	m_bDel.EnableWindow(false);
    m_strName.EnableWindow(true);
	femaleRadio->EnableWindow(true);
	maleRadio->EnableWindow(true);
    
    m_strNo.EnableWindow(true);
    m_strAge.EnableWindow(true);
    
    m_strPhone.EnableWindow(true);
    m_strAddress.EnableWindow(true);








	}
}

void CStudentDlg::OnStudentOk() 
{
	// TODO: Add your control notification handler code here
	CString no,name,phone,address,strSex;
    m_strNo.GetWindowText(no);
   m_strName.GetWindowText(name);
   m_strPhone.GetWindowText(phone);
   m_strAddress.GetWindowText(address);

    int age;
	CString s;
	m_strAge.GetWindowText(s);
	age=atoi(s);


	int sex=this->GetCheckedRadioButton(IDC_RADIO_SEX_MALE,IDC_RADIO_SEX_FEMALE);
	if(sex==IDC_RADIO_SEX_FEMALE)
		strSex="女";
	else
		strSex="男";
	if(name=="")
   {
	   MessageBox("请输入用户名");

   }

   else 
   {
	   m_studentSet.m_student_no=no;
	   m_studentSet.m_student_name=name;
	   m_studentSet.m_student_sex=strSex;
	   m_studentSet.m_student_age=age;
       m_studentSet.m_student_phone=phone;
       m_studentSet.m_student_address=address;
       m_studentSet.m_active_status="Y";
	   m_studentSet.Update();
	   m_studentSet.Close();
	   RefreshList();
	   ResetButton();

   }
}

void CStudentDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}

HBRUSH CStudentDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
	// TODO: Change any attributes of the DC here
	if(pWnd->GetDlgCtrlID()==IDD_DIALOG3)
	{
	pDC->SetTextColor(RGB(255,0,0));
	//pDC->SetBkColor(TRANSPARENT); 
      pDC->SetBkColor(RGB(0,0,255));
	return m_brush;
	}
 if(pWnd->GetDlgCtrlID()==IDC_BIANHAO)
	{
	pDC->SetTextColor(RGB(255,0,0));
	//pDC->SetBkColor(TRANSPARENT); 
    pDC->SetBkColor(RGB(0,0,255));
	return m_brush;
	}
  if(pWnd->GetDlgCtrlID()==IDC_XINGMING  )
	{
	pDC->SetTextColor(RGB(255,0,0));
	//pDC->SetBkColor(TRANSPARENT);  
    pDC->SetBkColor(RGB(0,0,255));
	return m_brush;
	}
  if(pWnd->GetDlgCtrlID()== IDC_STUDENT_NO )
	{
	pDC->SetTextColor(RGB(255,0,0));
	//pDC->SetBkColor(TRANSPARENT); 
    pDC->SetBkColor(RGB(0,0,255));
	return m_brush;
	}
if(pWnd->GetDlgCtrlID()== IDC_STUDENT_NAME )
	{
	pDC->SetTextColor(RGB(255,0,0));
	//pDC->SetBkColor(TRANSPARENT); 
    pDC->SetBkColor(RGB(0,0,255));
	return m_brush;
	}
	
	// TODO: Return a different brush if the default is not desired
//	return hbr;
	return m_brush;
	// TODO: Return a different brush if the default is not desired
	//return hbr;
}