resultxgdialog.cpp

这是目前正应用于辽宁省很多县级中学的试题库系统源代码

// ResultXgDialog.cpp : implementation file
//

#include "stdafx.h"
#include "TestPaper.h"
#include "ResultXgDialog.h"
#include "MainFrm.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CResultXgDialog dialog


CResultXgDialog::CResultXgDialog(CWnd* pParent /*=NULL*/)
	: CDialog(CResultXgDialog::IDD, pParent)
{
	//{{AFX_DATA_INIT(CResultXgDialog)
	m_Xgbox1 = _T("");
	m_Xgbox2 = _T("");
	m_Xgedit1 = _T("");
	m_Xgedit10 = _T("");
	m_Xgedit4 = _T("");
	m_Xgedit5 = _T("");
	m_Xgedit6 = _T("");
	m_Xgedit7 = _T("");
	m_Xgedit8 = _T("");
	//}}AFX_DATA_INIT
}


void CResultXgDialog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CResultXgDialog)
	DDX_Control(pDX, IDC_COMBO2, m_conXgbox2);
	DDX_CBString(pDX, IDC_COMBO1, m_Xgbox1);
	DDX_CBString(pDX, IDC_COMBO2, m_Xgbox2);
	DDX_Text(pDX, IDC_EDIT1, m_Xgedit1);
	DDX_Text(pDX, IDC_EDIT10, m_Xgedit10);
	DDX_Text(pDX, IDC_EDIT4, m_Xgedit4);
	DDX_Text(pDX, IDC_EDIT5, m_Xgedit5);
	DDX_Text(pDX, IDC_EDIT6, m_Xgedit6);
	DDX_Text(pDX, IDC_EDIT7, m_Xgedit7);
	DDX_Text(pDX, IDC_EDIT8, m_Xgedit8);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CResultXgDialog, CDialog)
	//{{AFX_MSG_MAP(CResultXgDialog)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
	ON_WM_DESTROY()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CResultXgDialog message handlers
BOOL CResultXgDialog::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here

	CMainFrame* pMainFrame=(CMainFrame*) AfxGetMainWnd();
	HICON hIcon=AfxGetApp()->LoadIcon(IDI_ICON13);
	this->SendMessage(WM_SETICON,ICON_BIG,(LPARAM)hIcon);
	CStdioFile MyFile;
	CString str;
	MyFile.Open("外部接口\\题库管理之考试对象.txt",CFile::modeRead|CFile::typeText);
	MyFile.SeekToBegin();
	while(MyFile.ReadString(str))
	{
		if(str!="")
		{
		m_conXgbox2.AddString(str); 
		str.Empty();
		}
	}
	MyFile.Close();

	if(pMainFrame->BoolConnent==FALSE)
	{
		GetDlgItem(IDC_BUTTON1)->EnableWindow(false);
	}
	
	if(!pMainFrame->m_queryset.CanUpdate()|| !pMainFrame->m_queryset.IsOpen())
         return FALSE;
	int i=pMainFrame->redlg.nItem;
    int keyid=atoi(pMainFrame->redlg.m_ListCtrl.GetItemText(i,9));
    pMainFrame->m_queryset.MoveFirst();
	CString Xgtemp;
	while(!pMainFrame->m_queryset.IsEOF())
	{
		int jj=9;
		CDBVariant XgVa;
		pMainFrame->m_queryset.GetFieldValue(jj,XgVa);
		if(keyid==XgVa.m_iVal)
		{
			int www=0;
            pMainFrame->m_queryset.GetFieldValue(www,XgVa);
			Xgtemp.Format("%d",XgVa.m_iVal);
	        m_Xgedit1=Xgtemp;

			pMainFrame->m_queryset.GetFieldValue(1,XgVa);
			m_Xgbox2=XgVa.m_pstring->GetBuffer(1);


		    pMainFrame->m_queryset.GetFieldValue(2,XgVa);
            CString Xgtemp3;
	        Xgtemp3.Format("%d",XgVa.m_iVal);
	        m_Xgbox1=Xgtemp3;

	        pMainFrame->m_queryset.GetFieldValue(3,XgVa);
	        m_Xgedit5=XgVa.m_pstring->GetBuffer(1);

	        pMainFrame->m_queryset.GetFieldValue(4,XgVa);
	        m_Xgedit10=XgVa.m_pstring->GetBuffer(1);

	        pMainFrame->m_queryset.GetFieldValue(5,XgVa);
            m_Xgedit7=XgVa.m_pstring->GetBuffer(1);

	
	        pMainFrame->m_queryset.GetFieldValue(6,XgVa);
         	m_Xgedit4=XgVa.m_pstring->GetBuffer(1);

	        pMainFrame->m_queryset.GetFieldValue(7,XgVa);
	        m_Xgedit8=XgVa.m_pstring->GetBuffer(1);

	        pMainFrame->m_queryset.GetFieldValue(8,XgVa);
	        m_Xgedit6=XgVa.m_pstring->GetBuffer(1);
			
			break;
		}
		pMainFrame->m_queryset.MoveNext();
	}
	
	GetDlgItem(IDC_EDIT1)->EnableWindow(true);
	UpdateData(FALSE);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CResultXgDialog::OnButton1() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CMainFrame* pMainFrame=(CMainFrame*) AfxGetMainWnd();
	int j=pMainFrame->redlg.nItem;
    int keyid=atoi(pMainFrame->redlg.m_ListCtrl.GetItemText(j,9));
	CString keystr;
	keystr.Format("%d",keyid);
	if(!pMainFrame->m_queryset.CanUpdate())
	{
		AfxMessageBox("不可更新!");
		return;
	}
	if(atoi(m_Xgedit1)<=0)
	{
		AfxMessageBox("请输入正确的题目编号值!");
		return;
	}
	if(m_Xgedit10=="")
	{
		m_Xgedit10=" ";
	}
	if(m_Xgedit5=="")
	{
		m_Xgedit5=" ";
	}
	if(m_Xgedit4=="")
	{
		m_Xgedit4=" ";
	}
	if(m_Xgedit8=="")
	{
		m_Xgedit8=" ";
	}
	if(m_Xgedit6=="")
	{
		m_Xgedit6=" ";
	}
	if(m_Xgedit7=="")
	{
		m_Xgedit7=" ";
	}
	if(m_Xgbox2=="")
	{
		m_Xgbox2=" ";
	}
	
	CString editstr;
	editstr.Empty();
	editstr.Format("update %s%s set 题目编号='"+m_Xgedit1
		            +"',考试对象='"+m_Xgbox2+"',难度级别='"+m_Xgbox1+"',题目内容='"+m_Xgedit5
		            +"',选项A='"+m_Xgedit10+"',选项B='"+m_Xgedit7
		            +"',选项C='"+m_Xgedit4+"',选项D='"+m_Xgedit8+"',标准答案='"+m_Xgedit6+"'where 识别号=%d",pMainFrame->tempyang1,pMainFrame->tempyang2,keyid);
    try
	{
		pMainFrame->m_database.ExecuteSQL(editstr);
	
	}
	catch(...)
	{
		AfxMessageBox("出现异常!");
		return;
	}
	pMainFrame->Refreshdata();
	pMainFrame->redlg.m_ListCtrl.DeleteItem(j);
	int temp=0;
	pMainFrame->redlg.m_ListCtrl.InsertItem(j,"");
	pMainFrame->redlg.m_ListCtrl.SetItemText(j,0,m_Xgedit1);
    pMainFrame->redlg.m_ListCtrl.SetItemText(j,1,m_Xgbox2);
    pMainFrame->redlg.m_ListCtrl.SetItemText(j,2,m_Xgbox1);
	pMainFrame->redlg.m_ListCtrl.SetItemText(j,3,m_Xgedit5);
	pMainFrame->redlg.m_ListCtrl.SetItemText(j,4,m_Xgedit10);
	pMainFrame->redlg.m_ListCtrl.SetItemText(j,5,m_Xgedit7);
	pMainFrame->redlg.m_ListCtrl.SetItemText(j,6,m_Xgedit4);
	pMainFrame->redlg.m_ListCtrl.SetItemText(j,7,m_Xgedit8);
	pMainFrame->redlg.m_ListCtrl.SetItemText(j,8,m_Xgedit6);
	pMainFrame->redlg.m_ListCtrl.SetItemText(j,9,keystr);

	
	CDialog::OnOK();
	pMainFrame->redlg.ShowWindow(SW_RESTORE);

	
}

void CResultXgDialog::OnButton4() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel();
	CMainFrame* pMainFrame=(CMainFrame*) AfxGetMainWnd();
	pMainFrame->redlg.ShowWindow(SW_RESTORE);
	
}

void CResultXgDialog::OnDestroy() 
{
	CDialog::OnDestroy();
	
	// TODO: Add your message handler code here
	CMainFrame* pMainFrame=(CMainFrame*) AfxGetMainWnd();
	pMainFrame->redlg.ShowWindow(SW_RESTORE);
	
}