llzldlg.cpp

毕业生信息管理系统的基本功能是对毕业生的信息进行管理

// LLZLDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BySys.h"
#include "LLZLDlg.h"
#include "_recordset.h"
#include "columns.h"
#include "column.h"
#include "COMDEF.H"
#include "Student.h"
#include "SearchDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLLZLDlg dialog

CStudent stu;
CLLZLDlg::CLLZLDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLLZLDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLLZLDlg)
	m_Name = _T("");
	m_xuehao = _T("");
	//}}AFX_DATA_INIT
}


void CLLZLDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLLZLDlg)
	DDX_Control(pDX, IDC_ADODC1, m_adodc1);
	DDX_Control(pDX, IDC_ADODC2, m_adodc2);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid1);
	DDX_Control(pDX, IDC_DATAGRID2, m_datagrid2);
	DDX_Control(pDX, IDC_DATALIST2, m_datalist);
	DDX_Text(pDX, IDC_NAME_EDIT, m_Name);
	DDX_Text(pDX, IDC_XUEHAO_EDIT, m_xuehao);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLLZLDlg, CDialog)
	//{{AFX_MSG_MAP(CLLZLDlg)
	ON_BN_CLICKED(IDC_DISALLSTU_BUTTON, OnDisallstuButton)
	ON_BN_CLICKED(IDC_JBDN_BUTTON, OnJbdnButton)
	ON_BN_CLICKED(IDC_JTCY_BUTTON, OnJtcyButton)
	ON_BN_CLICKED(IDC_GZJL_BUTTON, OnGzjlButton)
	ON_BN_CLICKED(IDC_CFJL_BUTTON, OnCfjlButton)
	ON_BN_CLICKED(IDC_ZCPD_BUTTON, OnZcpdButton)
	ON_BN_CLICKED(IDC_PXJL_BUTTON, OnPxjlButton)
	ON_BN_CLICKED(IDC_GRJL_BUTTON, OnGrjlButton)
	ON_BN_CLICKED(IDC_CX_BUTTON, OnCxButton)
	ON_BN_CLICKED(IDC_LL_BUTTON, OnLlButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLLZLDlg message handlers

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

	m_adodc1.SetRecordSource("SELECT Stu_id AS 学生学号,Stu_Name AS 学生姓名,Yard_name AS 所在学院 FROM Students");
	m_adodc1.Refresh();
	
	m_adodc2.SetRecordSource(" SELECT Stu_id AS 学号,Stu_Name AS 姓名,Stu_Nat AS 民族,Birthday AS 生日,Age AS 年龄,Education AS 教育程度,Mar_Sta AS 婚姻状况,Sex AS 性别,Pol_lan AS 政治面貌, Ide_Num AS 省份证号码,Origin AS 籍贯,Stu_Type AS 学生类型,Sep AS 专业,For_lan AS 外语语种,Lan_Lev AS 外语级别,Com_Cla AS 计算机等级,Post AS 担任职务,Other_Exp AS 其他专长,Emp_Whe AS 就业去向,Emp_Req AS 就业需求,Telephone AS 联系电话,MoblieP AS 手机,E_Mail AS 邮件地址,Post_Add AS 通信地址,Postal AS 邮政编码,Gra_Sch AS 毕业学校,Gra_Time AS 毕业时间,Address AS 家庭住址 FROM Base_Mat ");
	m_adodc2.Refresh();

	return TRUE;

}

void CLLZLDlg::OnDisallstuButton() 
{
	// TODO: Add your control notification handler code here
	m_adodc1.SetRecordSource("SELECT * FROM Students");
	m_adodc1.Refresh();
}

void CLLZLDlg::RefreshData()
{
//	m_adodc1.Refresh();
	m_adodc2.Refresh();

	//设置列宽度

	_variant_t vIndex;
	vIndex = long(0);
	m_datagrid2.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(1);
	m_datagrid2.GetColumns().GetItem(vIndex).SetWidth(100);
	vIndex = long(2);
	m_datagrid2.GetColumns().GetItem(vIndex).SetWidth(80);
	vIndex = long(3);
	m_datagrid2.GetColumns().GetItem(vIndex).SetWidth(100);
	vIndex = long(4);
	m_datagrid2.GetColumns().GetItem(vIndex).SetWidth(90);
	vIndex = long(5);
	m_datagrid2.GetColumns().GetItem(vIndex).SetWidth(80);

}

void CLLZLDlg::OnJbdnButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	m_adodc2.SetRecordSource("SELECT Stu_id AS 学号,Stu_Name AS 姓名,Stu_Nat AS 民族,Birthday AS 生日,Age AS 年龄,Education AS 教育程度,Mar_Sta AS 婚姻状况,Sex AS 性别,Pol_lan AS 政治面貌, Ide_Num AS 省份证号码,Origin AS 籍贯,Stu_Type AS 学生类型,Sep AS 专业,For_lan AS 外语语种,Lan_Lev AS 外语级别,Com_Cla AS 计算机等级,Post AS 担任职务,Other_Exp AS 其他专长,Emp_Whe AS 就业去向,Emp_Req AS 就业需求,Telephone AS 联系电话,MoblieP AS 手机,E_Mail AS 邮件地址,Post_Add AS 通信地址,Postal AS 邮政编码,Gra_Sch AS 毕业学校,Gra_Time AS 毕业时间,Address AS 家庭住址 FROM Base_Mat WHERE Stu_id = '"+m_xuehao+"' ");
	RefreshData();
	
}

void CLLZLDlg::OnJtcyButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	m_adodc2.SetRecordSource("SELECT xuehao AS 学号,Mem_Name AS 成员姓名,Relation AS 与本人关系,Birthday AS出生日期,Work_place AS 工作单位,Post AS 担任职务,Pol_lan AS 政治面貌,Telephone AS 联系电话 FROM Fam_Men WHERE xuehao = '"+m_xuehao+"' ");
	RefreshData();
	
}

void CLLZLDlg::OnGzjlButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	m_adodc2.SetRecordSource("SELECT xuehao AS 学号,Sta_Time AS 开始时间,End_Time AS 结束时间,Work_Place AS 工作单位,Sec_Name AS 部门名称,Post AS 担任职务,Levels AS 级别 FROM Work_Exp WHERE xuehao = '"+m_xuehao+"' ");
	RefreshData();
	
}

void CLLZLDlg::OnCfjlButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	m_adodc2.SetRecordSource("SELECT xuehao AS 学号,Rew_Type AS 种类,Rew_Time AS 时间, Rew_Reason AS 惩罚原因,App_Uni AS 奖惩批准单位,Lift_Time AS 解除处分日期,Lift_Res AS 解除处分原因 FROM Rew_Rec WHERE xuehao = '"+m_xuehao+"' ");
	RefreshData();
	
}

void CLLZLDlg::OnZcpdButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	m_adodc2.SetRecordSource("SELECT xuehao AS 学号,Stu_Name AS 姓名,Tec_Qua AS 专业技术资格名,Get_Met AS 取得方式,Get_Data AS 取得日期,Fire_Spe AS 聘用专业技术职务,Fire_Sta AS 聘用开始时间,Fire_End AS 聘用结束时间,Fire_Whe AS 聘用单位 FROM Title_Exp WHERE xuehao = '"+m_Name+"' ");
	RefreshData();
	
}

void CLLZLDlg::OnPxjlButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	m_adodc2.SetRecordSource("SELECT xuehao AS 学号,Train_Way AS 培训方式,Sta_Time AS 开始培训时间,End_Time AS 培训结束时间,Train_Date AS 培训期限,Train_Post AS 培训职位,Train_Text AS 培训内容, Train_Money AS 培训经费,Train_Result AS 培训结果 FROM Train_Rec WHERE xuehao = '"+m_xuehao+"' ");
	RefreshData();
	
}

void CLLZLDlg::OnGrjlButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	m_adodc2.SetRecordSource("SELECT Stu_id AS 学号,JianLi AS 简历 FROM JLSelf WHERE Stu_id = '"+m_xuehao+"' ");
	m_adodc2.Refresh();
	
}

BEGIN_EVENTSINK_MAP(CLLZLDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CLLZLDlg)
	ON_EVENT(CLLZLDlg, IDC_DATAGRID1, -601 /* DblClick */, OnDblClickDatagrid1, VTS_NONE)
	ON_EVENT(CLLZLDlg, IDC_DATAGRID1, -600 /* Click */, OnClickDatagrid1, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()


void CLLZLDlg::OnDblClickDatagrid1() 
{
	// TODO: Add your control notification handler code here
	if(m_adodc1.GetRecordset().GetEof()==1)
	{
		MessageBox("没有数据!");
		return ;
	}
	CString cStuid;
	CString cStuName;
	cStuid = m_datagrid1.GetItem(0);
	cStuName =m_datagrid1.GetItem(1);

	stu.setStu_Id(atoi(cStuid));
	stu.setStu_Name(cStuName);
	
}

void CLLZLDlg::OnClickDatagrid1() 
{
	// TODO: Add your control notification handler code here
	if(m_adodc1.GetRecordset().GetEof()==1)
	{
		MessageBox("没有数据!");
		return ;
	}
	CString cStuid;
	CString cStuName;
	cStuid = m_datagrid1.GetItem(1);
	cStuName =m_datagrid1.GetItem(2);

	stu.setStu_Id(atoi(cStuid));
	stu.setStu_Name(cStuName);
	
}

void CLLZLDlg::OnCxButton() 
{
	// TODO: Add your control notification handler code here
	CSearchDlg dlg9;
	dlg9.DoModal();
}

void CLLZLDlg::OnLlButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	m_adodc2.SetRecordSource("SELECT Stu_id AS 学号,Stu_Name AS 姓名,Stu_Nat AS 民族,Birthday AS 生日,Age AS 年龄,Education AS 教育程度,Mar_Sta AS 婚姻状况,Sex AS 性别,Pol_lan AS 政治面貌, Ide_Num AS 省份证号码,Origin AS 籍贯,Stu_Type AS 学生类型,Sep AS 专业,For_lan AS 外语语种,Lan_Lev AS 外语级别,Com_Cla AS 计算机等级,Post AS 担任职务,Other_Exp AS 其他专长,Emp_Whe AS 就业去向,Emp_Req AS 就业需求,Telephone AS 联系电话,MoblieP AS 手机,E_Mail AS 邮件地址,Post_Add AS 通信地址,Postal AS 邮政编码,Gra_Sch AS 毕业学校,Gra_Time AS 毕业时间,Address AS 家庭住址 FROM Base_Mat WHERE Stu_id = '"+m_xuehao+"' ");
	RefreshData();
	
}