// 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(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());

	//
	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)
	{