moddlg.cpp

这是一个简单的体检管理系统

// ModDlg.cpp : implementation file
//

#include "stdafx.h"
#include "HealManage.h"
#include "ModDlg.h"
#include "SearchDlg.h"
#include "TijSet.h"
#include "StuInfoSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CModDlg dialog


CModDlg::CModDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CModDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CModDlg)
	m_tjxh = _T("");
	m_ksh = _T("");
	m_xm = _T("");
	m_xb = _T("");
	m_cerq = _T("");
	m_mz = _T("");
	m_sfzh = _T("");
	m_byxx = _T("");
	m_jwbsT = _T("");
	m_jwbs = _T("");
	m_jzslz = _T("");
	m_jzsly = _T("");
	m_jzdsy = _T("");
	m_jzdsz = _T("");
	m_yb = _T("");
	m_gan = _T("");
	m_pi = _T("");
	m_nk = _T("");
	m_ztl = _T("");
	m_ytl = _T("");
	m_eb = _T("");
	m_kq = _T("");
	m_xt = _T("");
	m_gg = _T("");
	m_sxzy1 = _T("");
	m_sxzy2 = _T("");
	m_sxzy3 = _T("");
	m_sxzy4 = _T("");
	m_sxzy5 = _T("");
	m_sxzy6 = _T("");
	m_tjjl = _T("");
	m_nzssy = _T("");
	m_nzszy = _T("");
	m_sg = _T("");
	m_tz = _T("");
	m_wk = _T("");
	m_nkysyj = _T("");
	m_ykysyj = _T("");
	m_tjjldm = _T("");
	m_ggysyj = _T("");
	m_wkysyj = _T("");
	m_ebysyj = _T("");
	m_kqysyj = _T("");
	m_xtysyj = _T("");
	m_lysly = _T("");
	m_lyslz = _T("");
	m_sjjc = _T("");
	m_sjjct = _T("");
	m_red = _T("");
	m_green = _T("");
	m_pink = _T("");
	m_blue = _T("");
	m_yellow = _T("");
	m_fyqk = _T("");
	m_xzjxg = _T("");
	m_hxxt = _T("");
	m_sjxt = _T("");
	m_gxz = _T("");
	m_pxz = _T("");
	m_pf = _T("");
	m_mb = _T("");
	m_jb = _T("");
	m_jz = _T("");
	m_sz = _T("");
	m_gj = _T("");
	m_xj = _T("");
	m_ebyh = _T("");
	m_ce = _T("");
	m_sfkc = _T("");
	m_yc = _T("");
	m_zam = _T("");
	m_ygky = _T("");
	m_xtT = _T("");
	//}}AFX_DATA_INIT
}

void CModDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CModDlg)
	DDX_Control(pDX, IDC_XT, m_cxtT);
	DDX_Control(pDX, IDC_KQ, m_ckq);
	DDX_Control(pDX, IDC_EB, m_ceb);
	DDX_Control(pDX, IDC_YETL, m_cytl);
	DDX_Control(pDX, IDC_ZETL, m_cztl);
	DDX_Control(pDX, IDC_WK, m_cwk);
	DDX_Control(pDX, IDC_TZ, m_ctz);
	DDX_Control(pDX, IDC_SG, m_csg);
	DDX_Control(pDX, IDC_NK, m_cnk);
	DDX_Control(pDX, IDC_PI, m_cpi);
	DDX_Control(pDX, IDC_GAN, m_cgan);
	DDX_Control(pDX, IDC_NZSZY, m_cnzszy);
	DDX_Control(pDX, IDC_NZSSY, m_cnzssy);
	DDX_Control(pDX, IDC_GG, m_cgg);
	DDX_Control(pDX, IDC_TJJL, m_ctjjl);
	DDX_Control(pDX, IDC_YB, m_cyb);
	DDX_Control(pDX, IDC_JZDSY, m_cjzdsy);
	DDX_Control(pDX, IDC_JZDSZ, m_cjzdsz);
	DDX_Control(pDX, IDC_JZSLY, m_cjzsly);
	DDX_Control(pDX, IDC_JZSLZ, m_cjzslz);
	DDX_Control(pDX, IDC_LYSLY, m_clysly);
	DDX_Control(pDX, IDC_LYSLZ, m_clyslz);
	DDX_Control(pDX, IDC_JWBS, m_cjwbsT);
	DDX_Control(pDX, IDC_wkysyj_COMBO, m_cwkysyj);
	DDX_Control(pDX, IDC_xj_COMBO, m_cxj);
	DDX_Control(pDX, IDC_ebysyj_COMBO, m_cebysyj);
	DDX_Control(pDX, IDC_ce_COMBO, m_cce);
	DDX_Control(pDX, IDC_sfkc_COMBO, m_csfkc);
	DDX_Control(pDX, IDC_yc_COMBO, m_cyc);
	DDX_Control(pDX, IDC_kqysyj_COMBO, m_ckqysyj);
	DDX_Control(pDX, IDC_xt_COMBO, m_cxt);
	DDX_Control(pDX, IDC_xtysyj_COMBO, m_cxtysyj);
	DDX_Control(pDX, IDC_zam_COMBO, m_czam);
	DDX_Control(pDX, IDC_ygky_COMBO, m_cygky);
	DDX_Control(pDX, IDC_ggysyj_COMBO, m_cggysyj);
	DDX_Control(pDX, IDC_tjjldm_COMBO, m_ctjjldm);
	DDX_Control(pDX, IDC_ebyh_COMBO, m_cebyh);
	DDX_Control(pDX, IDC_ykysyj_COMBO, m_cykysyj);
	DDX_Control(pDX, IDC_sz_COMBO, m_csz);
	DDX_Control(pDX, IDC_jz_COMBO, m_cjz);
	DDX_Control(pDX, IDC_mb_COMBO, m_cmb);
	DDX_Control(pDX, IDC_gj_COMBO, m_cgj);
	DDX_Control(pDX, IDC_jb_COMBO, m_cjb);
	DDX_Control(pDX, IDC_pf_COMBO, m_cpf);
	DDX_Control(pDX, IDC_nkysyj_COMBO, m_cnkysyj);
	DDX_Control(pDX, IDC_pxz_COMBO, m_cpxz);
	DDX_Control(pDX, IDC_gxz_COMBO, m_cgxz);
	DDX_Control(pDX, IDC_sjxt_COMBO, m_csjxt);
	DDX_Control(pDX, IDC_xzjxg_COMBO, m_cxzjxg);
	DDX_Control(pDX, IDC_hxxt_COMBO, m_chxxt);
	DDX_Control(pDX, IDC_fyqk_COMBO, m_cfyqk);
	DDX_Control(pDX, IDC_yellow_COMBO, m_cyellow);
	DDX_Control(pDX, IDC_blue_COMBO, m_cblue);
	DDX_Control(pDX, IDC_pink_COMBO, m_cpink);
	DDX_Control(pDX, IDC_green_COMBO, m_cgreen);
	DDX_Control(pDX, IDC_red_COMBO, m_cred);
	DDX_Control(pDX, IDC_sjjct_COMBO, m_csjjct);
	DDX_Control(pDX, IDC_sjjc_COMBO, m_csjjc);
	DDX_Control(pDX, IDC_jwbs_COMBO, m_cjwbs);
	DDX_Text(pDX, IDC_TJXH, m_tjxh);
	DDX_Text(pDX, IDC_KSH, m_ksh);
	DDX_Text(pDX, IDC_XM, m_xm);
	DDX_Text(pDX, IDC_XB, m_xb);
	DDX_Text(pDX, IDC_CERQ, m_cerq);
	DDX_Text(pDX, IDC_MZ, m_mz);
	DDX_Text(pDX, IDC_SFZH, m_sfzh);
	DDX_Text(pDX, IDC_BYXX, m_byxx);
	DDX_Text(pDX, IDC_JWBS, m_jwbsT);
	DDX_CBString(pDX, IDC_jwbs_COMBO, m_jwbs);
	DDX_Text(pDX, IDC_JZSLZ, m_jzslz);
	DDX_Text(pDX, IDC_JZSLY, m_jzsly);
	DDX_Text(pDX, IDC_JZDSY, m_jzdsy);
	DDX_Text(pDX, IDC_JZDSZ, m_jzdsz);
	DDX_Text(pDX, IDC_YB, m_yb);
	DDX_Text(pDX, IDC_GAN, m_gan);
	DDX_Text(pDX, IDC_PI, m_pi);
	DDX_Text(pDX, IDC_NK, m_nk);
	DDX_Text(pDX, IDC_ZETL, m_ztl);
	DDX_Text(pDX, IDC_YETL, m_ytl);
	DDX_Text(pDX, IDC_EB, m_eb);
	DDX_Text(pDX, IDC_KQ, m_kq);
	DDX_Text(pDX, IDC_XT, m_xt);
	DDX_Text(pDX, IDC_GG, m_gg);
	DDX_Text(pDX, IDC_SXZY1, m_sxzy1);
	DDX_Text(pDX, IDC_SXZY2, m_sxzy2);
	DDX_Text(pDX, IDC_SXZY3, m_sxzy3);
	DDX_Text(pDX, IDC_SXZY4, m_sxzy4);
	DDX_Text(pDX, IDC_SXZY5, m_sxzy5);
	DDX_Text(pDX, IDC_SXZY6, m_sxzy6);
	DDX_Text(pDX, IDC_TJJL, m_tjjl);
	DDX_Text(pDX, IDC_NZSSY, m_nzssy);
	DDX_Text(pDX, IDC_NZSZY, m_nzszy);
	DDX_Text(pDX, IDC_SG, m_sg);
	DDX_Text(pDX, IDC_TZ, m_tz);
	DDX_Text(pDX, IDC_WK, m_wk);
	DDX_CBString(pDX, IDC_nkysyj_COMBO, m_nkysyj);
	DDX_CBString(pDX, IDC_ykysyj_COMBO, m_ykysyj);
	DDX_CBString(pDX, IDC_tjjldm_COMBO, m_tjjldm);
	DDX_CBString(pDX, IDC_ggysyj_COMBO, m_ggysyj);
	DDX_CBString(pDX, IDC_wkysyj_COMBO, m_wkysyj);
	DDX_CBString(pDX, IDC_ebysyj_COMBO, m_ebysyj);
	DDX_CBString(pDX, IDC_kqysyj_COMBO, m_kqysyj);
	DDX_CBString(pDX, IDC_xtysyj_COMBO, m_xtysyj);
	DDX_Text(pDX, IDC_LYSLY, m_lysly);
	DDX_Text(pDX, IDC_LYSLZ, m_lyslz);
	DDX_CBString(pDX, IDC_sjjc_COMBO, m_sjjc);
	DDX_CBString(pDX, IDC_sjjct_COMBO, m_sjjct);
	DDX_CBString(pDX, IDC_red_COMBO, m_red);
	DDX_CBString(pDX, IDC_green_COMBO, m_green);
	DDX_CBString(pDX, IDC_pink_COMBO, m_pink);
	DDX_CBString(pDX, IDC_blue_COMBO, m_blue);
	DDX_CBString(pDX, IDC_yellow_COMBO, m_yellow);
	DDX_CBString(pDX, IDC_fyqk_COMBO, m_fyqk);
	DDX_CBString(pDX, IDC_xzjxg_COMBO, m_xzjxg);
	DDX_CBString(pDX, IDC_hxxt_COMBO, m_hxxt);
	DDX_CBString(pDX, IDC_sjxt_COMBO, m_sjxt);
	DDX_CBString(pDX, IDC_gxz_COMBO, m_gxz);
	DDX_CBString(pDX, IDC_pxz_COMBO, m_pxz);
	DDX_CBString(pDX, IDC_pf_COMBO, m_pf);
	DDX_CBString(pDX, IDC_mb_COMBO, m_mb);
	DDX_CBString(pDX, IDC_jb_COMBO, m_jb);
	DDX_CBString(pDX, IDC_jz_COMBO, m_jz);
	DDX_CBString(pDX, IDC_sz_COMBO, m_sz);
	DDX_CBString(pDX, IDC_gj_COMBO, m_gj);
	DDX_CBString(pDX, IDC_xj_COMBO, m_xj);
	DDX_CBString(pDX, IDC_ebyh_COMBO, m_ebyh);
	DDX_CBString(pDX, IDC_ce_COMBO, m_ce);
	DDX_CBString(pDX, IDC_sfkc_COMBO, m_sfkc);
	DDX_CBString(pDX, IDC_yc_COMBO, m_yc);
	DDX_CBString(pDX, IDC_zam_COMBO, m_zam);
	DDX_CBString(pDX, IDC_ygky_COMBO, m_ygky);
	DDX_CBString(pDX, IDC_xt_COMBO, m_xtT);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CModDlg, CDialog)
	//{{AFX_MSG_MAP(CModDlg)
	ON_BN_CLICKED(IDC_SEARCHALL, OnSearchall)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CModDlg message handlers


BOOL CModDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
    
	CTiJSet m_recordset;
	CString m_k;
	CString m_strSQL;
	CHealManageApp*  ptheApp = (CHealManageApp *) AfxGetApp();
    m_k=ptheApp->m_ksId;
	m_strSQL.Format("select * from tjk where ksh='%s'",m_k);
	if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,m_strSQL))
	{
	    MessageBox("打开数据库失败","连接失败",MB_OK);
		return FALSE;
	}
	m_cjwbs.AddString("无");
	m_cjwbs.AddString("有");
	if(m_recordset.m_jwbs=="无")
	{
	   m_cjwbs.SetCurSel(0);
	}
	else
	{
       m_cjwbs.SetCurSel(1);
	}
    
	//眼科
	m_csjjc.AddString("正常");
	m_csjjc.AddString("不正常");
	if(m_recordset.m_yk_sjjc=="正常")
	{
        m_csjjc.SetCurSel(0);
    }
	else
	{
        m_csjjc.SetCurSel(1);       
	}
	m_csjjct.AddString("图1");
    m_csjjct.AddString("图2");
	m_csjjct.AddString("图3");
	m_csjjct.AddString("图4");
	m_csjjct.AddString("图5");
	m_csjjct.SetCurSel(0);

	m_cred.AddString("能");
	m_cred.AddString("不能");
	if(m_recordset.m_yk_sjds1=="能")
	{
	   m_cred.SetCurSel(0);
    }
	else
	{
       m_cred.SetCurSel(1);
	}
	m_cgreen.AddString("能");
	m_cgreen.AddString("不能");
	if(m_recordset.m_yk_sjds2=="能")
	{
	   m_cgreen.SetCurSel(0);
    }
	else
	{
       m_cgreen.SetCurSel(1);
	}
	m_cpink.AddString("能");
	m_cpink.AddString("不能");
    if(m_recordset.m_yk_sjds3=="能")
	{
	   m_cpink.SetCurSel(0);
    }
	else
	{
       m_cpink.SetCurSel(1);
	}
	m_cblue.AddString("能");
	m_cblue.AddString("不能");
	if(m_recordset.m_yk_sjds4=="能")
	{
	   m_cblue.SetCurSel(0);
    }
	else
	{
       m_cblue.SetCurSel(1);
	}
	m_cyellow.AddString("能");
	m_cyellow.AddString("不能");
	if(m_recordset.m_yk_sjds5=="能")
	{
	   m_cyellow.SetCurSel(0);
    }
	else
	{
       m_cyellow.SetCurSel(1);
	}
	m_cykysyj.AddString("正常");
	m_cykysyj.AddString("不正常");
	if(m_recordset.m_yk_ysyj=="正常")
	{
		m_cykysyj.SetCurSel(0);
	}
    else
	{
        m_cykysyj.SetCurSel(1);
	}
	//内科
	m_cfyqk.AddString("优");
	m_cfyqk.AddString("良");
	m_cfyqk.AddString("中");
	m_cfyqk.AddString("差");
	if(m_recordset.m_nk_fyqk=="优")
	{
	    m_cfyqk.SetCurSel(0);
    }
	else if(m_recordset.m_nk_fyqk=="良")
	{
        m_cfyqk.SetCurSel(1);
	}
	else if(m_recordset.m_nk_fyqk=="中")
	{
        m_cfyqk.SetCurSel(2);
	}
	else
	{
		m_cfyqk.SetCurSel(3);
	}
	m_chxxt.AddString("正常");
	m_chxxt.AddString("不正常");
	if(m_recordset.m_nk_hxxt=="正常")
	{
	    m_chxxt.SetCurSel(0);
    }
	else
	{
        m_chxxt.SetCurSel(1);
	}
	m_cxzjxg.AddString("正常");
	m_cxzjxg.AddString("不正常");
	if(m_recordset.m_nk_xzjxg=="正常")
	{
	    m_cxzjxg.SetCurSel(0);
    }
	else
	{ 
        m_cxzjxg.SetCurSel(1);
	}
	m_csjxt.AddString("正常");
	m_csjxt.AddString("不正常");
	if(m_recordset.m_nk_sjxt=="正常")
	{
	    m_csjxt.SetCurSel(0);
    }
	else
	{
        m_csjxt.SetCurSel(1);
	}
	m_cgxz.AddString("正常");
	m_cgxz.AddString("不正常");
	if(m_recordset.m_nk_gxz=="正常")
	{
	    m_cgxz.SetCurSel(0);
    }
	else
	{
        m_cgxz.SetCurSel(1);
	}
	m_cpxz.AddString("正常");
	m_cpxz.AddString("不正常");
	if(m_recordset.m_nk_pxz=="正常")
	{
	    m_cpxz.SetCurSel(0);
    }
	else
	{
        m_cpxz.SetCurSel(1);
	}
	m_cnkysyj.AddString("正常");
	m_cnkysyj.AddString("不正常");
	if(m_recordset.m_nk_ysyj=="正常")
	{
	    m_cnkysyj.SetCurSel(0);
    }
	else
	{
        m_cnkysyj.SetCurSel(1);
	}

	//外科
	m_cpf.AddString("正常");
    m_cpf.AddString("不正常");
	if(m_recordset.m_wk_pf=="正常")
	{