newdatadlg.cpp

一个用C

// NewdataDlg.cpp : implementation file
//

#include "stdafx.h"
#include "TS3.h"
#include "NewdataDlg.h"
#include "Teacherdata.h"
#include "Studentdata.h"
#include <afxdb.h>


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

/////////////////////////////////////////////////////////////////////////////
// CNewdataDlg dialog
 extern int flag2=3;

CNewdataDlg::CNewdataDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CNewdataDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CNewdataDlg)
	m_address = _T("");
	m_age = 0;
	m_job = _T("");
	m_name = _T("");
	m_study = _T("");
	m_workday = _T("");
	//}}AFX_DATA_INIT
}


void CNewdataDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CNewdataDlg)
	DDX_Text(pDX, IDC_ADDRESS_EDIT, m_address);
	DDX_Text(pDX, IDC_AGE_EDIT, m_age);
	DDX_Text(pDX, IDC_JOB_EDIT, m_job);
	DDX_Text(pDX, IDC_NAME_EDIT, m_name);
	DDX_Text(pDX, IDC_STUDY_EDIT, m_study);
	DDX_Text(pDX, IDC_WORKDAY_EDIT, m_workday);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CNewdataDlg, CDialog)
	//{{AFX_MSG_MAP(CNewdataDlg)
	ON_BN_CLICKED(IDC_RADIO3, OnRadio3)
	ON_BN_CLICKED(IDC_RADIO4, OnRadio4)
	ON_BN_CLICKED(IDC_ADD_BUTTON, OnAddButton)
	ON_BN_CLICKED(IDC_BACK_BUTTON, OnBackButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CNewdataDlg message handlers

void CNewdataDlg::OnRadio3() 
{
	// TODO: Add your control notification handler code here
	flag2=0;
    GetDlgItem(IDC_JOB_STATIC)->SetWindowText("职称:");
	GetDlgItem(IDC_WORKDAY_STATIC)->SetWindowText("工作日期:");
	GetDlgItem(IDC_STUDY_EDIT)->EnableWindow(true);
	GetDlgItem(IDC_XUEHAO_STATIC)->SetWindowText("");
}

void CNewdataDlg::OnRadio4() 
{
	// TODO: Add your control notification handler code here
	flag2=1;
	GetDlgItem(IDC_JOB_STATIC)->SetWindowText("学号:");
	GetDlgItem(IDC_WORKDAY_STATIC)->SetWindowText("入学日期:");
	GetDlgItem(IDC_STUDY_EDIT)->EnableWindow(false);
	GetDlgItem(IDC_XUEHAO_STATIC)->SetWindowText("数字型数据");
}

void CNewdataDlg::OnAddButton() 
{
	// TODO: Add your control notification handler code here
    //CShowDlg *sp;
	CDatabase db;
	
	if(a>=1)
	{
		if(flag==0)
		{
			
			if(!db.OpenEx("DSN=ts"))
			{
				MessageBox("数据源打开失败");
				return ;
			}
			MessageBox("success");
			UpdateData(true);
			Teacherdata t(&db);
			CString str="select * from teacher where 姓名='";
			str+=str3;
			str+="'";
			if(!t.Open(CRecordset::dynaset,str))
			{
				MessageBox("表打开失败");
			}
			t.Edit();
			t.m_column1=m_name;
			t.m_column2=m_age;
			t.m_column3=m_job;
			t.m_column4=m_study;
			t.m_column5=m_address;
			t.m_column6=m_workday;
			t.Update();
			t.Close();
			db.Close();
			MessageBox("修改成功!");
			a=0;
			
		}
		else
		{
			if(!db.OpenEx("DSN=ts"))
			{
				MessageBox("数据源打开失败");
				return ;
			}
			UpdateData(true);
			Studentdata t(&db);
			CString str="select * from student where 学号=";
			
			str+=str3;
			
			
			
			if(!t.Open(Studentdata::dynaset,str))
			{
				MessageBox("表打开失败");
			}
			t.Edit();
			t.m_column1=m_name;
			t.m_column2=m_age;
			
			t.m_column3=atoi(m_job);  
			t.m_column4=m_address;
			t.m_column5=m_workday;
			t.Update();
			t.Close();
			db.Close();
			MessageBox("修改成功!");
				a=0;
		}
		return;
	}
	else	
	{
		if(flag2==0)
		{
			if(!db.OpenEx("DSN=ts"))
			{
				MessageBox("数据源打开失败");
				return ;
			}
			UpdateData(true);
			Teacherdata t(&db);
			
			CString str="select * from teacher";
			if(!t.Open(Teacherdata::dynaset,_T(str)))
			{
				MessageBox("表打开失败");
			}
			
			t.AddNew();
			
			t.m_column1=m_name;
			t.m_column2=m_age;
			t.m_column3=m_job;
			t.m_column4=m_study;
			t.m_column5=m_address;
			t.m_column6=m_workday;
			m_name="";
			m_age=0;
			m_job="";
			m_study="";
			m_address="";
			m_workday="";
			UpdateData(false);
			MessageBox("添加成功!");
			t.Update();
			t.Close();
			db.Close();
		}
		else
		{
			if(!db.OpenEx("DSN=ts"))
			{
				MessageBox("数据源打开失败");
				return ;
			}
			UpdateData(true);
			Studentdata t(&db);
			
			CString str="select * from student";
			if(!t.Open(Studentdata::dynaset,_T(str)))
			{
				MessageBox("表打开失败");
			}
			
			t.AddNew();
			
			t.m_column1=m_name;
			t.m_column2=m_age;
			t.m_column3=atoi(m_job);
			t.m_column4=m_address;
			t.m_column5=m_workday;
			
			m_name="";
			m_age=0;
			m_job="";
			m_study="";
			m_address="";
			m_workday="";
			UpdateData(false);
			MessageBox("添加成功!");
			t.Update();
			t.Close();
			db.Close();
		}
	}
}

BOOL CNewdataDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	
    if(a==1)
	{ 
	    GetDlgItem(IDC_ADD_BUTTON)->SetWindowText("修改");
		if(newflag==1)
		{
			GetDlgItem(IDC_RADIO3)->EnableWindow(false);
            GetDlgItem(IDC_RADIO4)->EnableWindow(false);
			GetDlgItem(IDC_JOB_STATIC)->SetWindowText("学号:");
			GetDlgItem(IDC_STUDY_EDIT)->EnableWindow(false);
			GetDlgItem(IDC_XUEHAO_STATIC)->SetWindowText("数字型数据");
			GetDlgItem(IDC_WORKDAY_STATIC)->SetWindowText("入学日期:");
		}
	a=2;
	}
	UpdateData(false);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CNewdataDlg::OnBackButton() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnOK();	
}