xjxfxdlg.cpp

这是一个学生管理系统

		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);
}