www.pudn.com > student_system.rar > XjXfxDlg.cpp

// XjXfxDlg.cpp : implementation file 
// 
 
#include "stdafx.h" 
#include "student.h" 
#include "XjXfxDlg.h" 
#include "studentview.h" 
 
#ifdef _DEBUG 
#define new DEBUG_NEW 
#undef THIS_FILE 
static char THIS_FILE[] = __FILE__; 
#endif 
 
///////////////////////////////////////////////////////////////////////////// 
// CXjXfxDlg dialog 
 
 
CXjXfxDlg::CXjXfxDlg(CWnd* pParent /*=NULL*/) 
	: CDialog(CXjXfxDlg::IDD, pParent) 
{ 
	//{{AFX_DATA_INIT(CXjXfxDlg) 
	m_IsBj = FALSE; 
	m_IsJb = FALSE; 
	m_IsQt = FALSE; 
	m_IsXh = FALSE; 
	m_IsXm = FALSE; 
	m_IsZy = FALSE; 
	m_Bj = _T(""); 
	m_Jb = _T(""); 
	m_Qt = _T(""); 
	m_Xh = _T(""); 
	m_Xm = _T(""); 
	m_Zy = _T(""); 
	m_Qt_G = _T(""); 
	m_Xfx_Bj = _T(""); 
	m_Xfx_Bz = _T(""); 
	m_Xfx_ID = _T(""); 
	m_Xfx_Jb = _T(""); 
	m_Xfx_Jsr = _T(""); 
	m_Xfx_Xm = _T(""); 
	m_Xfx_Yy = _T(""); 
	m_Xfx_Lx = _T(""); 
	m_Xfx_Xjzt = _T(""); 
	m_Xfx_Rq = 0; 
	//}}AFX_DATA_INIT 
	IsInit = false; 
	sql=""; 
} 
 
 
void CXjXfxDlg::DoDataExchange(CDataExchange* pDX) 
{ 
	CDialog::DoDataExchange(pDX); 
	//{{AFX_DATA_MAP(CXjXfxDlg) 
	DDX_Control(pDX, IDC_LIST_XFX, m_XfxList); 
	DDX_Control(pDX, IDC_LIST_STU, m_StuList); 
	DDX_Control(pDX, IDC_COMBO_QT, m_Qt_G_Con); 
	DDX_Control(pDX, IDC_COMBO_ZY, m_Zy_Con); 
	DDX_Control(pDX, IDC_EDIT_BJ, m_Bj_Con); 
	DDX_Control(pDX, IDC_EDIT_JB, m_Jb_Con); 
	DDX_Control(pDX, IDC_EDIT_QT, m_Qt_Con); 
	DDX_Control(pDX, IDC_EDIT_XH, m_Xh_Con); 
	DDX_Control(pDX, IDC_EDIT_XM, m_Xm_Con); 
	DDX_Check(pDX, IDC_CHECK_BJ, m_IsBj); 
	DDX_Check(pDX, IDC_CHECK_JB, m_IsJb); 
	DDX_Check(pDX, IDC_CHECK_QT, m_IsQt); 
	DDX_Check(pDX, IDC_CHECK_XH, m_IsXh); 
	DDX_Check(pDX, IDC_CHECK_XM, m_IsXm); 
	DDX_Check(pDX, IDC_CHECK_ZY, m_IsZy); 
	DDX_Text(pDX, IDC_EDIT_BJ, m_Bj); 
	DDX_Text(pDX, IDC_EDIT_JB, m_Jb); 
	DDX_Text(pDX, IDC_EDIT_QT, m_Qt); 
	DDX_Text(pDX, IDC_EDIT_XH, m_Xh); 
	DDX_Text(pDX, IDC_EDIT_XM, m_Xm); 
	DDX_CBString(pDX, IDC_COMBO_ZY, m_Zy); 
	DDX_CBString(pDX, IDC_COMBO_QT, m_Qt_G); 
	DDX_Text(pDX, IDC_EDIT_XFX_BJ, m_Xfx_Bj); 
	DDX_Text(pDX, IDC_EDIT_XFX_BZ, m_Xfx_Bz); 
	DDX_Text(pDX, IDC_EDIT_XFX_ID, m_Xfx_ID); 
	DDX_Text(pDX, IDC_EDIT_XFX_JB, m_Xfx_Jb); 
	DDX_Text(pDX, IDC_EDIT_XFX_JSR, m_Xfx_Jsr); 
	DDX_Text(pDX, IDC_EDIT_XFX_XM, m_Xfx_Xm); 
	DDX_Text(pDX, IDC_EDIT_XFX_YY, m_Xfx_Yy); 
	DDX_CBString(pDX, IDC_COMBO_XFX_LX, m_Xfx_Lx); 
	DDX_CBString(pDX, IDC_COMBO_XFX_XJZT, m_Xfx_Xjzt); 
	DDX_DateTimeCtrl(pDX, IDC_DATETIME_XFX_RQ, m_Xfx_Rq); 
	//}}AFX_DATA_MAP 
	if(!IsInit) 
	{ 
	CRect rect1,rect2; 
	this->GetClientRect(&rect1); 
	this->m_parent->GetClientRect(&rect2); 
	int x= (rect2.Width()-STATIC_MYWIN_LEFT-rect1.Width())/2 +STATIC_MYWIN_LEFT; 
	int y= (rect2.Height()-STATIC_MYWIN_TOP-rect1.Height())/2 +STATIC_MYWIN_TOP; 
	if(xMoveWindow(x,y,rect1.Width(),rect1.Height()); 
 
	// 
	m_Bj_Con.EnableWindow(false); 
	m_Jb_Con.EnableWindow(false); 
	m_Qt_G_Con.EnableWindow(false); 
	m_Qt_Con.EnableWindow(false); 
	m_Xh_Con.EnableWindow(false); 
	m_Xm_Con.EnableWindow(false); 
	m_Zy_Con.EnableWindow(false); 
	 
	m_parent->m_recSet->Open("SELECT * FROM ZyTable"); 
	CString zname; 
	while(!m_parent->m_recSet->IsEOF()) 
	{ 
		m_parent->m_recSet->GetFieldValue("Z_Name",zname); 
		m_Zy_Con.AddString(zname); 
		m_parent->m_recSet->MoveNext(); 
	} 
	m_parent->m_recSet->Close(); 
	m_Zy_Con.SetCurSel(0); 
	m_Qt_G_Con.SetCurSel(0); 
	// 
	LV_COLUMN lvc; 
	 
	lvc.mask = LVCF_TEXT | LVCF_SUBITEM | LVCF_WIDTH /*| LVCF_FMT*/; 
	 
	lvc.iSubItem = 0; 
	lvc.pszText = (char *)"学号"; 
	lvc.cx = 100; 
	m_StuList.InsertColumn(0,&lvc); 
	 
	lvc.iSubItem = 1; 
	lvc.pszText = (char *)"姓名"; 
	lvc.cx = 100; 
	m_StuList.InsertColumn(1,&lvc); 
	 
	lvc.iSubItem = 2; 
	lvc.pszText = (char *)"性别"; 
	lvc.cx = 100; 
	m_StuList.InsertColumn(2,&lvc); 
	 
	lvc.iSubItem = 3; 
	lvc.pszText = (char *)"级别"; 
	lvc.cx = 100; 
	m_StuList.InsertColumn(3,&lvc); 
	 
	lvc.iSubItem = 4; 
	lvc.pszText = (char *)"班级"; 
	lvc.cx = 100; 
	m_StuList.InsertColumn(4,&lvc); 
	 
	lvc.iSubItem = 5; 
	lvc.pszText = (char *)"专业"; 
	lvc.cx = 100; 
	m_StuList.InsertColumn(5,&lvc); 
 
	lvc.iSubItem = 6; 
	lvc.pszText = (char *)"学籍状态"; 
	lvc.cx = 100; 
	m_StuList.InsertColumn(6,&lvc); 
 
	lvc.iSubItem = 0; 
	lvc.pszText = (char *)"编号"; 
	lvc.cx = 100; 
	m_XfxList.InsertColumn(0,&lvc); 
 
	lvc.iSubItem = 1; 
	lvc.pszText = (char *)"类型"; 
	lvc.cx = 100; 
	m_XfxList.InsertColumn(1,&lvc); 
 
	lvc.iSubItem = 2; 
	lvc.pszText = (char *)"日期"; 
	lvc.cx = 100; 
	m_XfxList.InsertColumn(2,&lvc); 
 
	lvc.iSubItem = 3; 
	lvc.pszText = (char *)"经手人"; 
	lvc.cx = 100; 
	m_XfxList.InsertColumn(3,&lvc); 
	// 
	IsInit = true; 
	} 
} 
 
 
BEGIN_MESSAGE_MAP(CXjXfxDlg, CDialog) 
	//{{AFX_MSG_MAP(CXjXfxDlg) 
	ON_BN_CLICKED(IDC_BU_CLOSE, OnBuClose) 
	ON_BN_CLICKED(IDC_BU_S, OnBuS) 
	ON_BN_CLICKED(IDC_CHECK_BJ, OnCheckBj) 
	ON_BN_CLICKED(IDC_CHECK_JB, OnCheckJb) 
	ON_BN_CLICKED(IDC_CHECK_QT, OnCheckQt) 
	ON_BN_CLICKED(IDC_CHECK_XH, OnCheckXh) 
	ON_BN_CLICKED(IDC_CHECK_XM, OnCheckXm) 
	ON_BN_CLICKED(IDC_CHECK_ZY, OnCheckZy) 
	ON_NOTIFY(NM_CLICK, IDC_LIST_STU, OnClickListStu) 
	ON_NOTIFY(NM_CLICK, IDC_LIST_XFX, OnClickListXfx) 
	ON_BN_CLICKED(IDC_BU_XFX_ADD, OnBuXfxAdd) 
	ON_BN_CLICKED(IDC_BU_XFX_DEL, OnBuXfxDel) 
	ON_BN_CLICKED(IDC_BU_XFX_SAVE, OnBuXfxSave) 
	//}}AFX_MSG_MAP 
END_MESSAGE_MAP() 
 
///////////////////////////////////////////////////////////////////////////// 
// CXjXfxDlg message handlers 
 
void CXjXfxDlg::OnBuClose()  
{ 
	// TODO: Add your control notification handler code here 
	this->m_parent->m_Dlg_XjXfx = NULL; 
 
	LVFINDINFO info; 
	info.psz = "修复学处理"; 
	info.flags = LVFI_STRING; 
	this->m_parent->m_listCtrlGN.DeleteItem(this->m_parent->m_listCtrlGN.FindItem(&info))	; 
	 
	this->DestroyWindow(); 
} 
 
void CXjXfxDlg::OnBuS()  
{ 
	// TODO: Add your control notification handler code here 
	this->UpdateData(true); 
	if(!(m_IsBj || m_IsJb || m_IsQt || m_IsXh || m_IsXm || m_IsZy)) 
	{ 
		MessageBox("请选择查询条件"); 
		return; 
	} 
	sql = "SELECT * FROM student,ZyTable WHERE student.Z_ID = ZyTable.Z_ID"; 
	if(m_IsBj) 
	{ 
		sql+=" AND S_Bj='"+m_Bj+"'"; 
	} 
	if(m_IsJb) 
	{ 
		sql+=" AND S_Jb='"+m_Jb+"'"; 
	} 
	if(m_IsQt) 
	{ 
		CString temp; 
		if(m_Qt_G.Compare("性别")==0) 
		{ 
			temp = "S_Xb"; 
		} 
		else if(m_Qt_G.Compare("学籍状态")==0) 
		{ 
			temp = "S_Zt"; 
		} 
		else if(m_Qt_G.Compare("民族")==0) 
		{ 
			temp = "S_Mz"; 
		} 
		else if(m_Qt_G.Compare("政治面貌")==0) 
		{ 
			temp = "S_Zzmm"; 
		} 
		else if(m_Qt_G.Compare("住宿情况")==0) 
		{ 
			temp = "S_Zsqk"; 
		} 
		else if(m_Qt_G.Compare("全部") == 0) 
		{ 
			temp = "'"+m_Qt+"'"; 
		} 
		else 
		{ 
			temp = m_Qt_G; 
		} 
		sql+=" AND "+temp+"='"+m_Qt+"'"; 
	} 
	if(m_IsXh) 
	{ 
		sql+=" AND S_ID='"+m_Xh+"'"; 
	} 
	if(m_IsXm) 
	{ 
		sql+=" AND S_Name='"+m_Xm+"'"; 
	} 
	if(m_IsZy) 
	{ 
		sql+=" AND Z_Name='"+m_Zy+"'"; 
	} 
	 
	m_parent->m_recSet->Open(sql.GetBuffer(200)); 
	if(!m_parent->m_recSet->IsEOF()) 
	{ 
		m_StuList.DeleteAllItems(); 
		CString temp; 
		COleDateTime dateTemp; 
		int i=0; 
		LV_ITEM lvitem; 
		lvitem.mask = LVIF_TEXT | LVIF_IMAGE | LVIF_STATE; 
		lvitem.state = 0;       
		lvitem.stateMask = 0;  
		char temp1[50]; 
		 
		while(!m_parent->m_recSet->IsEOF()) 
		{ 
			 
			 
			lvitem.iItem = i; 
			lvitem.iSubItem = 0; 
			lvitem.pszText =itoa(i, temp1, 10);  
			m_StuList.InsertItem(&lvitem); 
			 
			m_parent->m_recSet->GetFieldValue("S_ID",temp); 
			m_StuList.SetItemText(i,0,temp); 
			m_parent->m_recSet->GetFieldValue("S_Name",temp); 
			m_StuList.SetItemText(i,1,temp); 
			m_parent->m_recSet->GetFieldValue("S_Xb",temp); 
			m_StuList.SetItemText(i,2,temp); 
			m_parent->m_recSet->GetFieldValue("S_Jb",temp); 
			m_StuList.SetItemText(i,3,temp); 
			m_parent->m_recSet->GetFieldValue("S_Bj",temp); 
			m_StuList.SetItemText(i,4,temp); 
			m_parent->m_recSet->GetFieldValue("Z_Name",temp); 
			m_StuList.SetItemText(i,5,temp); 
			m_parent->m_recSet->GetFieldValue("S_Zt",temp); 
			m_StuList.SetItemText(i,6,temp); 
			i++; 
			m_parent->m_recSet->MoveNext(); 
		} 
	} 
	else 
	{ 
		MessageBox("未找到此人"); 
	} 
	m_parent->m_recSet->Close(); 
} 
 
void CXjXfxDlg::OnCheckBj()  
{ 
	// TODO: Add your control notification handler code here 
	this->UpdateData(true); 
	if(m_IsBj) 
	{ 
		m_Bj_Con.EnableWindow(true); 
	} 
	else 
	{ 
		m_Bj_Con.EnableWindow(false); 
	} 
	this->UpdateData(false); 
} 
 
void CXjXfxDlg::OnCheckJb()  
{ 
	// TODO: Add your control notification handler code here 
	this->UpdateData(true); 
	if(m_IsJb) 
	{ 
		m_Jb_Con.EnableWindow(true); 
	} 
	else 
	{ 
		m_Jb_Con.EnableWindow(false); 
	} 
	this->UpdateData(false); 
} 
 
void CXjXfxDlg::OnCheckQt()  
{ 
	// TODO: Add your control notification handler code here 
	this->UpdateData(true); 
	if(m_IsQt) 
	{ 
		m_Qt_Con.EnableWindow(true); 
		m_Qt_G_Con.EnableWindow(true); 
	} 
	else 
	{ 
		m_Qt_Con.EnableWindow(false); 
		m_Qt_G_Con.EnableWindow(false); 
	} 
	this->UpdateData(false); 
} 
 
void CXjXfxDlg::OnCheckXh()  
{ 
	// TODO: Add your control notification handler code here 
	this->UpdateData(true); 
	if(m_IsXh) 
	{ 
		m_Xh_Con.EnableWindow(true); 
	} 
	else 
	{ 
		m_Xh_Con.EnableWindow(false); 
	} 
	this->UpdateData(false); 
} 
 
void CXjXfxDlg::OnCheckXm()  
{ 
	// TODO: Add your control notification handler code here 
 
	this->UpdateData(true); 
	if(m_IsXm) 
	{ 
		m_Xm_Con.EnableWindow(true); 
	} 
	else 
	{ 
		m_Xm_Con.EnableWindow(false); 
	} 
	this->UpdateData(false); 
} 
 
void CXjXfxDlg::OnCheckZy()  
{ 
	// TODO: Add your control notification handler code here 
	this->UpdateData(true); 
	if(m_IsZy) 
	{ 
		m_Zy_Con.EnableWindow(true); 
	} 
	else 
	{ 
		m_Zy_Con.EnableWindow(false); 
	} 
	this->UpdateData(false); 
} 
 
void CXjXfxDlg::RefreshXfx(CString SID) 
{ 
	m_XfxList.DeleteAllItems(); 
	CString sqlt; 
	sqlt.Format("SELECT * FROM XfxTable WHERE S_ID='%s'",SID); 
	m_parent->m_recSet->Open(sqlt.GetBuffer(100)); 
	if(!m_parent->m_recSet->IsEOF()) 
	{ 
		CString temp; 
		COleDateTime dateTemp; 
		int i=0; 
		LV_ITEM lvitem; 
		lvitem.mask = LVIF_TEXT | LVIF_IMAGE | LVIF_STATE; 
		lvitem.state = 0;       
		lvitem.stateMask = 0;  
		char temp1[50]; 
		 
		while(!m_parent->m_recSet->IsEOF()) 
		{ 
			lvitem.iItem = i; 
			lvitem.iSubItem = 0; 
			lvitem.pszText =itoa(i, temp1, 10);  
			m_XfxList.InsertItem(&lvitem); 
			 
			m_parent->m_recSet->GetFieldValue("XFX_ID",temp); 
			m_XfxList.SetItemText(i,0,temp); 
			m_parent->m_recSet->GetFieldValue("XFX_Lx",temp); 
			m_XfxList.SetItemText(i,1,temp); 
			m_parent->m_recSet->GetFieldValue("XFX_Date",dateTemp); 
			m_XfxList.SetItemText(i,2,dateTemp.Format("%Y/%m/%d")); 
			m_parent->m_recSet->GetFieldValue("XFX_Jsr",temp); 
			m_XfxList.SetItemText(i,3,temp); 
		 
			 
			i++; 
			m_parent->m_recSet->MoveNext(); 
		} 
	} 
	m_parent->m_recSet->Close(); 
} 
 
void CXjXfxDlg::OnClickListStu(NMHDR* pNMHDR, LRESULT* pResult)  
{ 
	// TODO: Add your control notification handler code here 
	int index = m_StuList.GetSelectionMark(); 
	if(index <0) 
	{ 
		return; 
	} 
	 
	RefreshXfx(m_StuList.GetItemText(index,0)); 
	 
	this->UpdateData(true); 
	m_Xfx_Jb = m_StuList.GetItemText(index,3); 
	m_Xfx_Bj = m_StuList.GetItemText(index,4); 
	m_Xfx_ID = m_StuList.GetItemText(index,0); 
	m_Xfx_Xm = m_StuList.GetItemText(index,1); 
	m_Xfx_Xjzt = m_StuList.GetItemText(index,6); 
	this->UpdateData(false); 
 
	*pResult = 0; 
} 
 
void CXjXfxDlg::OnClickListXfx(NMHDR* pNMHDR, LRESULT* pResult)  
{ 
	// TODO: Add your control notification handler code here 
	int index = m_XfxList.GetSelectionMark(); 
 
	if(index <0) 
	{ 
		return; 
	} 
 
	CString sqlt; 
	sqlt.Format("SELECT * FROM XfxTable WHERE XFX_ID=%s",m_XfxList.GetItemText(index,0)); 
	m_parent->m_recSet->Open(sqlt.GetBuffer(100)); 
 
	COleDateTime dateTemp; 
 
	this->UpdateData(true); 
	m_parent->m_recSet->GetFieldValue("XFX_Lx",m_Xfx_Lx); 
	m_parent->m_recSet->GetFieldValue("XFX_Date",dateTemp); 
 
	CTime t(dateTemp.GetYear(),dateTemp.GetMonth(),dateTemp.GetDay(),0,0,0); 
	m_Xfx_Rq = t; 
	 
	m_parent->m_recSet->GetFieldValue("XFX_Yy",m_Xfx_Yy); 
	m_parent->m_recSet->GetFieldValue("XFX_Jsr",m_Xfx_Jsr); 
	m_parent->m_recSet->GetFieldValue("XFX_Bz",m_Xfx_Bz); 
	this->UpdateData(false); 
	m_parent->m_recSet->Close(); 
	*pResult = 0; 
} 
 
void CXjXfxDlg::OnBuXfxAdd()  
{ 
	// TODO: Add your control notification handler code here 
	this->UpdateData(true); 
	m_Xfx_ID.TrimLeft(); 
	m_Xfx_ID.TrimRight(); 
	if(m_Xfx_ID == "") 
	{ 
		MessageBox("请选择学生"); 
		this->UpdateData(false); 
		return; 
	} 
	 
	m_Xfx_Lx.TrimLeft(); 
	m_Xfx_Lx.TrimRight(); 
	if(m_Xfx_Lx =="") 
	{ 
		MessageBox("请选择类型"); 
		this->UpdateData(false); 
		return; 
	} 
	 
	m_Xfx_Yy.TrimLeft(); 
	m_Xfx_Yy.TrimRight(); 
	if(m_Xfx_Yy =="") 
	{ 
		MessageBox("请输入原因"); 
		this->UpdateData(false); 
		return; 
	} 
	 
	m_Xfx_Jsr.TrimLeft(); 
	m_Xfx_Jsr.TrimRight(); 
	if(m_Xfx_Jsr =="") 
	{ 
		MessageBox("请输入经手人"); 
		this->UpdateData(false); 
		return; 
	} 
 
	m_Xfx_Xjzt.TrimLeft(); 
	m_Xfx_Xjzt.TrimRight(); 
	if(m_Xfx_Xjzt =="") 
	{ 
		MessageBox("请选择学籍状态"); 
		this->UpdateData(false); 
		return; 
	} 
	 
	CString sqlt; 
	sqlt.Format("UPDATE Student SET S_Zt='%s' WHERE S_ID='%s'",m_Xfx_Xjzt,m_Xfx_ID); 
	m_parent->m_conn->Execute(sqlt); 
	 
	sqlt.Format("INSERT INTO XfxTable(S_ID,XFX_Lx,XFX_Date,XFX_Yy,XFX_Bz,XFX_Jsr) VALUES('%s','%s',DATE(),'%s','%s','%s')"\ 
		,m_Xfx_ID,m_Xfx_Lx,m_Xfx_Yy,m_Xfx_Bz,m_Xfx_Jsr); 
	 
	m_parent->m_conn->Execute(sqlt); 
	 
	RefreshXfx(m_Xfx_ID); 
	this->UpdateData(false); 
} 
 
void CXjXfxDlg::OnBuXfxDel()  
{ 
	// TODO: Add your control notification handler code here 
	this->UpdateData(true); 
	m_Xfx_ID.TrimLeft(); 
	m_Xfx_ID.TrimRight(); 
	if(m_Xfx_ID == "") 
	{ 
		MessageBox("请选择学生"); 
		this->UpdateData(false); 
		return; 
	} 
	int index =m_XfxList.GetSelectionMark(); 
	if(index<0) 
	{ 
		MessageBox("请选择异动行"); 
		this->UpdateData(false); 
		return; 
	} 
 
	CString sqlt; 
	sqlt.Format("DELETE FROM XfxTable WHERE XFX_ID=%s",m_XfxList.GetItemText(index,0)); 
	m_parent->m_conn->Execute(sqlt); 
 
	RefreshXfx(m_Xfx_ID); 
 
} 
 
void CXjXfxDlg::OnBuXfxSave()  
{ 
	// TODO: Add your control notification handler code here 
	this->UpdateData(true); 
	m_Xfx_ID.TrimLeft(); 
	m_Xfx_ID.TrimRight(); 
	if(m_Xfx_ID == "") 
	{ 
		MessageBox("请选择学生"); 
		this->UpdateData(false); 
		return; 
	} 
	 
	int index = m_XfxList.GetSelectionMark(); 
	if(index<0) 
	{ 
		MessageBox("请选择异动行"); 
		this->UpdateData(false); 
		return; 
	} 
 
	m_Xfx_Lx.TrimLeft(); 
	m_Xfx_Lx.TrimRight(); 
	if(m_Xfx_Lx =="") 
	{ 
		MessageBox("请选择类型"); 
		this->UpdateData(false); 
		return; 
	} 
	 
	m_Xfx_Yy.TrimLeft(); 
	m_Xfx_Yy.TrimRight(); 
	if(m_Xfx_Yy =="") 
	{ 
		MessageBox("请输入原因"); 
		this->UpdateData(false); 
		return; 
	} 
	 
	m_Xfx_Jsr.TrimLeft(); 
	m_Xfx_Jsr.TrimRight(); 
	if(m_Xfx_Jsr =="") 
	{ 
		MessageBox("请输入经手人"); 
		this->UpdateData(false); 
		return; 
	} 
	 
	m_Xfx_Xjzt.TrimLeft(); 
	m_Xfx_Xjzt.TrimRight(); 
	if(m_Xfx_Xjzt =="") 
	{ 
		MessageBox("请选择学籍状态"); 
		this->UpdateData(false); 
		return; 
	} 
	 
	CString sqlt; 
	sqlt.Format("UPDATE XfxTable SET XFX_Lx='%s',XFX_Yy='%s',XFX_Bz='%s',XFX_Jsr='%s' WHERE XFX_ID=%s"\ 
		,m_Xfx_Lx,m_Xfx_Yy,m_Xfx_Bz,m_Xfx_Jsr,m_XfxList.GetItemText(index,0)); 
	m_parent->m_conn->Execute(sqlt); 
 
	sqlt.Format("UPDATE Student SET S_Zt='%s' WHERE S_ID='%s'"\ 
		,m_Xfx_Xjzt,m_Xfx_ID); 
	m_parent->m_conn->Execute(sqlt); 
	 
	RefreshXfx(m_Xfx_ID); 
}