}
	this->m_parent->m_recSet->Update();
	this->m_parent->m_recSet->Close();

	//經歷
	sql.Format("SELECT * FROM JlTable WHERE S_ID='%s'",m_S_ID);
	this->m_parent->m_recSet->Open(sql.GetBuffer(100));
	count = m_S_JL.GetItemCount();
	COleDateTime dateTemp;
	for(i=0;i<count;i++)
	{
		this->m_parent->m_recSet->AddNew();		
		this->m_parent->m_recSet->SetFieldValue("S_ID",m_S_ID);
		this->m_parent->m_recSet->SetFieldValue("L_ID",i);
		dateTemp.ParseDateTime(m_S_JL.GetItemText(i,0));
		this->m_parent->m_recSet->SetFieldValue("L_From",dateTemp);
		dateTemp.ParseDateTime(m_S_JL.GetItemText(i,1));
		this->m_parent->m_recSet->SetFieldValue("L_To",dateTemp);
		this->m_parent->m_recSet->SetFieldValue("L_Xxm",m_S_JL.GetItemText(i,2));
		this->m_parent->m_recSet->SetFieldValue("L_Zmr",m_S_JL.GetItemText(i,3));
		
	}
	this->m_parent->m_recSet->Update();
	this->m_parent->m_recSet->Close();
	
	if(6 ==MessageBox("是否繼續(xù)添加?","添加",MB_YESNO))
	{
		InitValues()	;
	}
	this->UpdateData(false);
}

bool CDaDjxsDlg::TestValues()
{
	
	m_S_ID.TrimRight();
	m_S_ID.TrimLeft();
	if(m_S_ID =="")
	{
		ErrorText = "學號不能為空";
		return false;
	}
	this->m_S_Xb.TrimLeft();
	this->m_S_Xb.TrimRight();
	if(!(m_S_Xb.Compare("男")==0 || m_S_Xb.Compare("女")==0))
	{
		ErrorText = "請選擇性別";
		return false;
	}
	
	this->m_S_Xm.TrimLeft();
	this->m_S_Xm.TrimRight();
	if(m_S_Xm == "")
	{
		ErrorText = "請輸入姓名";
		return false;
	}
	
	this->m_S_Bj.TrimLeft();
	this->m_S_Bj.TrimRight();
	if(this->m_S_Bj == "")
	{
		ErrorText = "請輸入班級";
		return false;
	}

	this->m_S_Jb.TrimLeft();
	this->m_S_Jb.TrimRight();
	if(this->m_S_Jb == "")
	{
		ErrorText = "請輸入級別";
		return false;
	}


	return true;
}

void CDaDjxsDlg::InitValues()
{
		m_S_Jb		="";
		m_S_Bj		="";
		m_S_ID		="";
		m_S_Xm		="";
		m_S_Xsly	="";
		m_S_Yb		="";
		m_S_Zzmm	="";
		m_S_Hkd		="";
		m_S_Jzzz	="";
		m_S_Tcah	="";
		m_S_Mz		="";
		m_S_Lxdh	="";
		m_S_Jzxm	="";
		m_S_Jtxm	="";
		m_S_Jtnl	="";
		m_S_Jtgzdw	="";
		m_S_Jtgx	="";
		m_S_Jtdh	="";
		m_S_Jlrm	="";
		m_S_Jlm		="";
		m_S_Jkzk	="";
		m_S_Jg		="";
		m_S_Bz		="";
		m_S_Byxx	="";
		m_S_Sfyd	=false;
		m_S_Xb		="";
		m_S_Xjzk	="";
		m_S_Zsqk	="";
		
		int count  = m_S_Zy_Con.GetCount();
		int i;
		for(i=0;i<count;i++)
		{
			m_S_Zy_Con.DeleteString(0);
		}
		m_S_Zy_Con.SetCurSel(0);
		m_S_Xb_Con.SetCurSel(0);
		m_S_Xjzk_Con.SetCurSel(0);
		m_S_Zsqk_Con.SetCurSel(0);
		
		this->m_parent->m_recSet->Open("SELECT * FROM ZyTable");
		CString temp;
		while(!this->m_parent->m_recSet->IsEOF())
		{
			this->m_parent->m_recSet->GetFieldValue("Z_Name",temp);
			m_S_Zy_Con.AddString(temp);
			this->m_parent->m_recSet->MoveNext();
		}
		this->m_parent->m_recSet->Close();
		m_S_JL.DeleteAllItems();
		m_S_JT.DeleteAllItems();

		if(m_zp.Buffer !=NULL)
		{
			delete m_zp.Buffer;
			m_zp.Buffer =NULL;
			m_zp.Size=0;
		}
		m_S_Zp.Invalidate(false);
		
}

void CDaDjxsDlg::OnBuJtcy() 
{
	// TODO: Add your control notification handler code here
	this->UpdateData(true);
	m_S_Jtgx.TrimLeft();
	m_S_Jtgx.TrimRight();
	if(m_S_Jtgx =="")
	{
		MessageBox("關系不能為空");
		return;
	}
	m_S_Jtxm.TrimLeft();
	m_S_Jtxm.TrimRight();
	if(m_S_Jtxm =="")
	{
		MessageBox("姓名不能為空");
		return;
	}
	m_S_Jtnl.TrimLeft();
	m_S_Jtnl.TrimRight();
	if(m_S_Jtnl =="")
	{
		MessageBox("年齡不能為空");
		return;
	}
	int count = m_S_JT.GetItemCount();
	LV_ITEM lvitem;
	lvitem.mask = LVIF_TEXT | LVIF_IMAGE | LVIF_STATE;
	lvitem.state = 0;      
	lvitem.stateMask = 0; 
	char temp[50];
	
	lvitem.iItem = count;
	lvitem.iSubItem = 0;
	lvitem.pszText =itoa(count, temp, 10); 
	m_S_JT.InsertItem(&lvitem);
	
	m_S_JT.SetItemText(count,0,m_S_Jtgx);
	m_S_JT.SetItemText(count,1,m_S_Jtxm);
	m_S_JT.SetItemText(count,2,m_S_Jtnl);
	m_S_JT.SetItemText(count,3,m_S_Jtgzdw);
	m_S_JT.SetItemText(count,4,m_S_Jtdh);

	this->UpdateData(false);
}




void CDaDjxsDlg::OnBuJtcyDel() 
{
	// TODO: Add your control notification handler code here
	int index = m_S_JT.GetSelectionMark();
	if(index<0)
	{
		MessageBox("請選擇要刪除的行");
		return;
	}
	m_S_JT.DeleteItem(index);
}

void CDaDjxsDlg::OnBuJl() 
{
	// TODO: Add your control notification handler code here
	this->UpdateData(true);
	m_S_Jlm.TrimLeft();
	m_S_Jlm.TrimRight();
	if(m_S_Jlm =="")
	{
		MessageBox("請輸入校名");
		return;
	}
	m_S_Jlrm.TrimLeft();
	m_S_Jlrm.TrimRight();
	if(m_S_Jlm == "")
	{
		MessageBox("請輸入證明人");
		return;
	}
	int count = m_S_JL.GetItemCount();
	LV_ITEM lvitem;
	lvitem.mask = LVIF_TEXT | LVIF_IMAGE | LVIF_STATE;
	lvitem.state = 0;      
	lvitem.stateMask = 0; 
	char temp[50];
	
	lvitem.iItem = count;
	lvitem.iSubItem = 0;
	lvitem.pszText =itoa(count, temp, 10); 
	m_S_JL.InsertItem(&lvitem);
	
	m_S_JL.SetItemText(count,0,m_S_Jlf.Format("%Y/%m/%d"));
	m_S_JL.SetItemText(count,1,m_S_Jlt.Format("%Y/%m/%d"));
	m_S_JL.SetItemText(count,2,m_S_Jlm);
	m_S_JL.SetItemText(count,3,m_S_Jlrm);

	this->UpdateData(false);
}

void CDaDjxsDlg::OnBuJlDel() 
{
	// TODO: Add your control notification handler code here
	int index = m_S_JL.GetSelectionMark();
	if(index<0)
	{
		MessageBox("請選擇要刪除的行");
		return;
	}
	m_S_JL.DeleteItem(index);
}



void CDaDjxsDlg::OnBuPicLl() 
{
	// TODO: Add your control notification handler code here
	CFile f;
	CString  FilePathName;
	CFileException e;
	CPicture m_Pic;
	
	CFileDialog dlg(TRUE,NULL,NULL,0,"jpg Files (*.jpg)|*.jpg||",this);///TRUE為OPEN對話框，FALSE為SAVE AS對話框
	if(dlg.DoModal()==IDOK)
	{FilePathName=dlg.GetPathName();
	
	if(m_Pic.m_IPicture != NULL) m_Pic.FreePictureData(); // Important - Avoid Leaks...
	
	if(f.Open(FilePathName, CFile::modeRead | CFile::typeBinary, &e)) //打開了一個jpg文件
	{	
		
		int nSize = f.GetLength();          //先得到jpg文件長度
		BYTE * pBuffer = new BYTE [nSize];  //按文件的大小在堆上申請一塊內存
		f.Read(pBuffer, nSize);
		
		if(this->m_zp.Buffer != NULL)
		{
			delete m_zp.Buffer;
			m_zp.Buffer = NULL;
			m_zp.Size = 0;
		}
		m_zp.Buffer = pBuffer;
		m_zp.Size = nSize;
	}
	
	ShowDataImage();
	}
}

void CDaDjxsDlg::ShowDataImage()
{
	m_S_Zp.Invalidate(true);
	
	(m_Pic.LoadPictureData(m_zp.Buffer, m_zp.Size));
		
	///生成BITMAP對象
	CDC *dc = m_S_Zp.GetDC();
	CRect  rect;
	m_S_Zp.GetClientRect(rect);
	m_Pic.UpdateSizeOnDC(dc); // Get Picture Dimentions In Pixels
	m_Pic.Show(dc, CRect(0,0,rect.Width(),rect.Height()));
}

void CDaDjxsDlg::OnShowWindow(BOOL bShow, UINT nStatus) 
{
	CDialog::OnShowWindow(bShow, nStatus);
	
	// TODO: Add your message handler code here

}