// DaDjxsDlg.cpp : implementation file
//

#include "stdafx.h"
#include "student.h"
#include "DaDjxsDlg.h"
#include "studentview.h"
#include "ado.h"
#include "resource.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDaDjxsDlg dialog


CDaDjxsDlg::CDaDjxsDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDaDjxsDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDaDjxsDlg)
	m_S_Jb = _T("");
	m_S_Bj = _T("");
	m_S_ID = _T("");
	m_S_Xm = _T("");
	m_S_Xsly = _T("");
	m_S_Yb = _T("");
	m_S_Zzmm = _T("");
	m_S_Hkd = _T("");
	m_S_Jzzz = _T("");
	m_S_Tcah = _T("");
	m_S_Mz = _T("");
	m_S_Lxdh = _T("");
	m_S_Jzxm = _T("");
	m_S_Jtxm = _T("");
	m_S_Jtnl = _T("");
	m_S_Jtgzdw = _T("");
	m_S_Jtgx = _T("");
	m_S_Jtdh = _T("");
	m_S_Jlrm = _T("");
	m_S_Jlm = _T("");
	m_S_Jkzk = _T("");
	m_S_Jg = _T("");
	m_S_Bz = _T("");
	m_S_Byxx = _T("");
	m_S_Sfyd = FALSE;
	m_S_Xb = _T("");
	m_S_Xjzk = _T("");
	m_S_Zsqk = _T("");
	m_S_Csrq = 0;
	m_S_Jlf = 0;
	m_S_Jlt = 0;
	m_S_Zy = _T("");
	//}}AFX_DATA_INIT
	IsInit = false;
	m_zp.Buffer =NULL;
	m_zp.Size = 0;
}

CDaDjxsDlg::~CDaDjxsDlg()
{
	if(m_zp.Buffer!=NULL)
	{
		delete m_zp.Buffer;
	}
}

void CDaDjxsDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDaDjxsDlg)
	DDX_Control(pDX, IDC_COMBO_ZSQK, m_S_Zsqk_Con);
	DDX_Control(pDX, IDC_COMBO_XB, m_S_Xb_Con);
	DDX_Control(pDX, IDC_COMBO_XJZK, m_S_Xjzk_Con);
	DDX_Control(pDX, IDC_COMBO_ZY, m_S_Zy_Con);
	DDX_Control(pDX, IDC_IMAGE_ZP, m_S_Zp);
	DDX_Control(pDX, IDC_LIST_JT, m_S_JT);
	DDX_Control(pDX, IDC_LIST_JL, m_S_JL);
	DDX_Text(pDX, IDC_EDIT_JB, m_S_Jb);
	DDV_MaxChars(pDX, m_S_Jb, 4);
	DDX_Text(pDX, IDC_EDIT_BJ, m_S_Bj);
	DDX_Text(pDX, IDC_EDIT_ID, m_S_ID);
	DDV_MaxChars(pDX, m_S_ID, 10);
	DDX_Text(pDX, IDC_EDIT_XM, m_S_Xm);
	DDX_Text(pDX, IDC_EDIT_XSLY, m_S_Xsly);
	DDX_Text(pDX, IDC_EDIT_YB, m_S_Yb);
	DDX_Text(pDX, IDC_EDIT_ZZMM, m_S_Zzmm);
	DDX_Text(pDX, IDC_EDIT1_HKD, m_S_Hkd);
	DDX_Text(pDX, IDC_EDIT1_JZZZ, m_S_Jzzz);
	DDX_Text(pDX, IDC_EDIT_TCAH, m_S_Tcah);
	DDX_Text(pDX, IDC_EDIT_MZ, m_S_Mz);
	DDX_Text(pDX, IDC_EDIT_LXDH, m_S_Lxdh);
	DDX_Text(pDX, IDC_EDIT_JZXM, m_S_Jzxm);
	DDX_Text(pDX, IDC_EDIT_JTXM, m_S_Jtxm);
	DDX_Text(pDX, IDC_EDIT_JTNL, m_S_Jtnl);
	DDX_Text(pDX, IDC_EDIT_JTGZDW, m_S_Jtgzdw);
	DDX_Text(pDX, IDC_EDIT_JTGX, m_S_Jtgx);
	DDX_Text(pDX, IDC_EDIT_JTDH, m_S_Jtdh);
	DDX_Text(pDX, IDC_EDIT_JLRM, m_S_Jlrm);
	DDX_Text(pDX, IDC_EDIT_JLM, m_S_Jlm);
	DDX_Text(pDX, IDC_EDIT_JKZK, m_S_Jkzk);
	DDX_Text(pDX, IDC_EDIT_JG, m_S_Jg);
	DDX_Text(pDX, IDC_EDIT_BZ, m_S_Bz);
	DDX_Text(pDX, IDC_EDIT_BYXX, m_S_Byxx);
	DDX_Check(pDX, IDC_CHECK_SFYD, m_S_Sfyd);
	DDX_CBString(pDX, IDC_COMBO_XB, m_S_Xb);
	DDX_CBString(pDX, IDC_COMBO_XJZK, m_S_Xjzk);
	DDX_CBString(pDX, IDC_COMBO_ZSQK, m_S_Zsqk);
	DDX_DateTimeCtrl(pDX, IDC_DATETIME_CSRQ, m_S_Csrq);
	DDX_DateTimeCtrl(pDX, IDC_DATETIME_JLF, m_S_Jlf);
	DDX_DateTimeCtrl(pDX, IDC_DATETIME_JLT, m_S_Jlt);
	DDX_CBString(pDX, IDC_COMBO_ZY, m_S_Zy);
	//}}AFX_DATA_MAP
	if(!IsInit)
	{
//設(shè)置窗口位置
	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(x<STATIC_MYWIN_LEFT)
	{
		x = STATIC_MYWIN_LEFT;
	}
	if(y<STATIC_MYWIN_TOP)
	{
		y = STATIC_MYWIN_TOP;
	}
	this->MoveWindow(x,y,rect1.Width(),rect1.Height());

//設(shè)置初始值
	InitValues();


	LV_COLUMN lvc;
	
	lvc.mask = LVCF_TEXT | LVCF_SUBITEM | LVCF_WIDTH /*| LVCF_FMT*/;
	
	lvc.iSubItem = 0;
	lvc.pszText = (char *)"關(guān)系";
	lvc.cx = 50;
	m_S_JT.InsertColumn(0,&lvc);
	
	lvc.iSubItem = 1;
	lvc.pszText = (char *)"姓名";
	lvc.cx = 100;
	m_S_JT.InsertColumn(1,&lvc);
	
	lvc.iSubItem = 2;
	lvc.pszText = (char *)"年齡";
	lvc.cx =50;
	m_S_JT.InsertColumn(2,&lvc);
	
	lvc.iSubItem = 3;
	lvc.pszText = (char *)"工作單位及職位";
	lvc.cx = 300;
	m_S_JT.InsertColumn(3,&lvc);
	
	lvc.iSubItem = 4;
	lvc.pszText = (char *)"聯(lián)系電話";
	lvc.cx = 100;
	m_S_JT.InsertColumn(4,&lvc);

	lvc.iSubItem = 0;
	lvc.pszText = (char *)"何年月起";
	lvc.cx = 100;
	m_S_JL.InsertColumn(0,&lvc);
	
	lvc.iSubItem = 1;
	lvc.pszText = (char *)"到何年月";
	lvc.cx = 100;
	m_S_JL.InsertColumn(1,&lvc);
	
	lvc.iSubItem = 2;
	lvc.pszText = (char *)"在何學(xué)校及任職";
	lvc.cx =200;
	m_S_JL.InsertColumn(2,&lvc);
	
	lvc.iSubItem = 3;
	lvc.pszText = (char *)"證明人";
	lvc.cx = 100;
	m_S_JL.InsertColumn(3,&lvc);
//
	m_S_Zy_Con.SetCurSel(0);
	m_S_Xb_Con.SetCurSel(0);
	m_S_Xjzk_Con.SetCurSel(0);
	m_S_Zsqk_Con.SetCurSel(0);
	
//完成初始化
	IsInit = true;
	}
}


BEGIN_MESSAGE_MAP(CDaDjxsDlg, CDialog)
	//{{AFX_MSG_MAP(CDaDjxsDlg)
	ON_BN_CLICKED(IDC_BU_CLOSE, OnBuClose)
	ON_BN_CLICKED(IDC_BU_UP, OnBuUp)
	ON_BN_CLICKED(IDC_BU_JTCY, OnBuJtcy)
	ON_BN_CLICKED(IDC_BU_JTCY_DEL, OnBuJtcyDel)
	ON_BN_CLICKED(IDC_BU_JL, OnBuJl)
	ON_BN_CLICKED(IDC_BU_JL_DEL, OnBuJlDel)
	ON_BN_CLICKED(IDC_BU_PIC_LL, OnBuPicLl)
	ON_WM_SHOWWINDOW()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDaDjxsDlg message handlers

void CDaDjxsDlg::OnBuClose() 
{
	// TODO: Add your control notification handler code here
	this->m_parent->m_Dlg_DaDjxs = NULL;
	LVFINDINFO info;
	info.psz = "登記學(xué)生";
	info.flags = LVFI_STRING;
	this->m_parent->m_listCtrlGN.DeleteItem(this->m_parent->m_listCtrlGN.FindItem(&info))	;
	
	this->DestroyWindow();
}

void CDaDjxsDlg::OnBuUp() 
{
	// TODO: Add your control notification handler code here
	this->UpdateData(true);

	if(!TestValues())
	{
		MessageBox(ErrorText);
		return ;
	}
	m_S_Zy.TrimRight();
	CString sql ;
	sql.Format("SELECT * FROM ZyTable WHERE Z_Name='%s'",m_S_Zy);
	this->m_parent->m_recSet->Open(sql.GetBuffer(100));
	int ZyID;
	this->m_parent->m_recSet->GetFieldValue("Z_ID",ZyID);
	this->m_parent->m_recSet->Close();
	
	sql.Format("SELECT * FROM Student WHERE S_ID='%s'",m_S_ID);
	this->m_parent->m_recSet->Open(sql.GetBuffer(100));
	if(this->m_parent->m_recSet->GetRecordCount() >0)
	{
		MessageBox("學(xué)號已存在");
		return;
	}
	this->m_parent->m_recSet->AddNew();
	this->m_parent->m_recSet->SetFieldValue("S_ID",m_S_ID);
	this->m_parent->m_recSet->SetFieldValue("S_Xb",m_S_Xb);
	this->m_parent->m_recSet->SetFieldValue("S_Name",m_S_Xm);
	this->m_parent->m_recSet->SetFieldValue("S_CSRQ",COleDateTime(m_S_Csrq.GetYear(),m_S_Csrq.GetMonth(),m_S_Csrq.GetDay(),m_S_Csrq.GetHour(),m_S_Csrq.GetMinute(),m_S_Csrq.GetSecond()));
	this->m_parent->m_recSet->SetFieldValue("S_Bj",m_S_Bj);
	this->m_parent->m_recSet->SetFieldValue("S_Jb",m_S_Jb);
	this->m_parent->m_recSet->SetFieldValue("S_Mz",m_S_Mz);
	this->m_parent->m_recSet->SetFieldValue("S_Jg",m_S_Jg);
	this->m_parent->m_recSet->SetFieldValue("S_Zzmm",m_S_Zzmm);
	this->m_parent->m_recSet->SetFieldValue("S_Jkzk",m_S_Jkzk);
	this->m_parent->m_recSet->SetFieldValue("S_Jzxm",m_S_Jzxm);
	this->m_parent->m_recSet->SetFieldValue("S_Jtzz",m_S_Jzzz);
	this->m_parent->m_recSet->SetFieldValue("S_Lxdh",m_S_Lxdh);
	this->m_parent->m_recSet->SetFieldValue("S_Hkd",m_S_Hkd);
	this->m_parent->m_recSet->SetFieldValue("S_Yb",m_S_Yb);
	this->m_parent->m_recSet->SetFieldValue("S_Xsly",m_S_Xsly);
	this->m_parent->m_recSet->SetFieldValue("S_Byxx",m_S_Byxx);
	this->m_parent->m_recSet->SetFieldValue("S_Ahtc",m_S_Tcah);
	this->m_parent->m_recSet->SetFieldValue("S_Zt",m_S_Xjzk);
	this->m_parent->m_recSet->SetFieldValue("S_Zsqk",m_S_Zsqk);
	this->m_parent->m_recSet->SetFieldValue("S_Sfyd",m_S_Sfyd);
	this->m_parent->m_recSet->SetFieldValue("S_BZ",m_S_Bz);
	this->m_parent->m_recSet->SetFieldValue("Z_ID",ZyID);

	if(m_zp.Buffer !=NULL)
	{
		BYTE *pBuf = m_zp.Buffer;     ///下面這一大段是把pBuffer里的jpg數(shù)據(jù)放到庫中
		_variant_t			varBLOB;
		SAFEARRAY		*psa;
		SAFEARRAYBOUND	rgsabound[1];

		if(pBuf)
		{    
			rgsabound[0].lLbound = 0;
			rgsabound[0].cElements = m_zp.Size;
			psa = SafeArrayCreate(VT_UI1, 1, rgsabound);
			for (long i = 0; i < (long)m_zp.Size; i++)
				SafeArrayPutElement (psa, &i, pBuf++);
			varBLOB.vt = VT_ARRAY | VT_UI1;
			varBLOB.parray = psa;
			this->m_parent->m_recSet->SetFieldValue("S_Zp",varBLOB);
		}
	
	}
	this->m_parent->m_recSet->Update();
	this->m_parent->m_recSet->Close();
	
	//家庭成員
	sql.Format("SELECT * FROM JtcyTable WHERE S_ID='%s'",m_S_ID);
	this->m_parent->m_recSet->Open(sql.GetBuffer(100));
	int count = m_S_JT.GetItemCount();
	int i;
	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("J_ID",i);
		this->m_parent->m_recSet->SetFieldValue("J_Gx",m_S_JT.GetItemText(i,0));
		this->m_parent->m_recSet->SetFieldValue("J_Name",m_S_JT.GetItemText(i,1));
		this->m_parent->m_recSet->SetFieldValue("J_Nl",m_S_JT.GetItemText(i,2));
		this->m_parent->m_recSet->SetFieldValue("J_Dw",m_S_JT.GetItemText(i,3));
		this->m_parent->m_recSet->SetFieldValue("J_Dh",m_S_JT.GetItemText(i,4));