⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 gzcrdlg.cpp

📁 工资表数据库系统
💻 CPP
📖 第 1 页 / 共 2 页
字号:
// gzcrdlg.cpp : implementation file
//

#include "stdafx.h"
#include "工资表.h"
#include "gzcrdlg.h"
#include "gzlldlg.h"
#include "jjljdlg.h"
#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// Cgzcrdlg dialog


Cgzcrdlg::Cgzcrdlg(CWnd* pParent /*=NULL*/)
	: CDialog(Cgzcrdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(Cgzcrdlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void Cgzcrdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cgzcrdlg)
		// NOTE: the ClassWizard will add DDX and DDV calls here
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Cgzcrdlg, CDialog)
	//{{AFX_MSG_MAP(Cgzcrdlg)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
	ON_EN_CHANGE(IDC_EDIT21, OnChangeEdit21)
	ON_BN_CLICKED(IDC_CHECK2, OnCheck2)
	ON_EN_CHANGE(IDC_EDIT33, OnChangeEdit33)
	ON_EN_CHANGE(IDC_EDIT34, OnChangeEdit34)
	ON_BN_CLICKED(IDC_CHECK3, OnCheck3)
	ON_BN_CLICKED(IDC_CHECK4, OnCheck4)
	ON_BN_CLICKED(IDC_CHECK5, OnCheck5)
	ON_BN_CLICKED(IDC_RADIO3, OnRadio3)
	ON_BN_CLICKED(IDC_RADIO4, OnRadio4)
	ON_EN_CHANGE(IDC_EDIT31, OnChangeEdit31)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON5, OnButton5)
	ON_BN_CLICKED(IDC_BUTTON6, OnButton6)
	ON_EN_CHANGE(IDC_EDIT35, OnChangeEdit35)
	ON_BN_CLICKED(IDC_BUTTON8, OnButton8)
	ON_BN_CLICKED(IDC_BUTTON7, OnButton7)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON10, OnButton10)
	ON_BN_CLICKED(IDC_BUTTON11, OnButton11)
	ON_BN_CLICKED(IDC_BUTTON12, OnButton12)
	ON_BN_CLICKED(IDC_BUTTON13, OnButton13)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cgzcrdlg message handlers

BOOL Cgzcrdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
UpdateData(TRUE);
CString  m_list1; 
CString  m_edit1; 
CString  m_edit2; 
CString  m_edit3; 
CString  m_edit4; 
CString  m_edit5; 
CString  m_edit6; 
CString  m_edit7; 
CString  m_edit10; 
CString  m_edit11; 
CString  m_edit29; 
CString  m_edit12; 
CString  m_edit32; 
CString  m_edit36; 
CString  m_edit13; 
CString  m_edit14; 
CString  m_edit15; 
CString  m_edit16; 
CString  m_edit17; 
CString  m_edit18; 
CString  m_edit19; 

CString str;   
CTime t=CTime::GetCurrentTime();   
str.Format("%d-%d-%d",t.GetYear(),t.GetMonth(),t.GetDay());  
SetDlgItemText(IDC_EDIT24,str); 
UpdateData(FALSE);

SetDlgItemText(IDC_EDIT8,"35");
SetDlgItemText(IDC_EDIT9,"120");

	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString sql;
	sql.Format("select* from employees order by id desc");
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet((_bstr_t)sql);
	m_list1=((char*)(_bstr_t)m_pRecordset->GetCollect("name"));
	m_edit1=((char*)(_bstr_t)m_pRecordset->GetCollect("a1"));
	m_edit2=((char*)(_bstr_t)m_pRecordset->GetCollect("a2"));
	m_edit3=((char*)(_bstr_t)m_pRecordset->GetCollect("a3"));
	m_edit4=((char*)(_bstr_t)m_pRecordset->GetCollect("a4"));
	m_edit5=((char*)(_bstr_t)m_pRecordset->GetCollect("a5"));
	m_edit6=((char*)(_bstr_t)m_pRecordset->GetCollect("a6"));
	m_edit7=((char*)(_bstr_t)m_pRecordset->GetCollect("a7"));
	m_edit10=((char*)(_bstr_t)m_pRecordset->GetCollect("a10"));
	m_edit11=((char*)(_bstr_t)m_pRecordset->GetCollect("a11"));
	m_edit29=((char*)(_bstr_t)m_pRecordset->GetCollect("a12"));
	m_edit12=((char*)(_bstr_t)m_pRecordset->GetCollect("a13"));
	m_edit32=((char*)(_bstr_t)m_pRecordset->GetCollect("a14"));
	m_edit36=((char*)(_bstr_t)m_pRecordset->GetCollect("a15"));
	m_edit13=((char*)(_bstr_t)m_pRecordset->GetCollect("s1"));
	m_edit14=((char*)(_bstr_t)m_pRecordset->GetCollect("b1"));
	m_edit15=((char*)(_bstr_t)m_pRecordset->GetCollect("b2"));
	m_edit16=((char*)(_bstr_t)m_pRecordset->GetCollect("b3"));
	m_edit17=((char*)(_bstr_t)m_pRecordset->GetCollect("b4"));
	m_edit18=((char*)(_bstr_t)m_pRecordset->GetCollect("b5"));
	m_edit19=((char*)(_bstr_t)m_pRecordset->GetCollect("s2"));

	SetDlgItemText(IDC_COMBO1,m_list1);  
	SetDlgItemText(IDC_EDIT1,m_edit1);  
    SetDlgItemText(IDC_EDIT2,m_edit2);  
    SetDlgItemText(IDC_EDIT3,m_edit3);  
    SetDlgItemText(IDC_EDIT4,m_edit4);  
    SetDlgItemText(IDC_EDIT5,m_edit5);  
    SetDlgItemText(IDC_EDIT6,m_edit6);        
    SetDlgItemText(IDC_EDIT7,m_edit7);  
 
    SetDlgItemText(IDC_EDIT10,m_edit10);     
    SetDlgItemText(IDC_EDIT11,m_edit11); 
    SetDlgItemText(IDC_EDIT29,m_edit29);  
    SetDlgItemText(IDC_EDIT12,m_edit12);  
    SetDlgItemText(IDC_EDIT32,m_edit32);  
    SetDlgItemText(IDC_EDIT36,m_edit36); 
    SetDlgItemText(IDC_EDIT13,m_edit13);  
    SetDlgItemText(IDC_EDIT14,m_edit14);  
    SetDlgItemText(IDC_EDIT15,m_edit15);  
    SetDlgItemText(IDC_EDIT16,m_edit16);        
    SetDlgItemText(IDC_EDIT17,m_edit17);  
    SetDlgItemText(IDC_EDIT18,m_edit18);  
    SetDlgItemText(IDC_EDIT19,m_edit19);  
		m_AdoConn.ExitConnect();
return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void Cgzcrdlg::OnButton3() 
{
	// TODO: Add your control notification handler code here
  UpdateData(TRUE);
	//保存记录文件  
  CString  m_list1; 
  GetDlgItemText(IDC_COMBO1,m_list1);  
	if(m_list1!=_T(""))
	{
  CString str;
  CString name;
  //  name=m_edit161+".txt";
  name="工资.txt";
  CString  m_edit1;   
  CString  m_edit2;  
  CString  m_edit3; 
  CString  m_edit4;  
  CString  m_edit5;
  CString  m_edit6;  
  CString  m_edit7;   
  CString  m_edit8;  
  CString  m_edit9; 
  CString  m_edit10;  
  CString  m_edit11;
  CString  m_edit29;
  CString  m_edit12; 
  CString  m_edit32; 
  CString  m_edit36; 
  CString  m_edit13; 
  CString  m_edit14;  
  CString  m_edit15;
  CString  m_edit16;  
  CString  m_edit17;   
  CString  m_edit18;  
  CString  m_edit19; 
  


  GetDlgItemText(IDC_COMBO1,m_list1);  
  GetDlgItemText(IDC_EDIT1,m_edit1);  
  GetDlgItemText(IDC_EDIT1,m_edit1);  
  GetDlgItemText(IDC_EDIT2,m_edit2);  
  GetDlgItemText(IDC_EDIT3,m_edit3); 
  GetDlgItemText(IDC_EDIT4,m_edit4);  
  GetDlgItemText(IDC_EDIT5,m_edit5);  
  GetDlgItemText(IDC_EDIT6,m_edit6);  
  GetDlgItemText(IDC_EDIT7,m_edit7);  
  GetDlgItemText(IDC_EDIT8,m_edit8); 
  GetDlgItemText(IDC_EDIT9,m_edit9);  
  GetDlgItemText(IDC_EDIT10,m_edit10); 
  GetDlgItemText(IDC_EDIT11,m_edit11); 
  GetDlgItemText(IDC_EDIT29,m_edit29); 
  GetDlgItemText(IDC_EDIT12,m_edit12); 
  GetDlgItemText(IDC_EDIT32,m_edit32); 
  GetDlgItemText(IDC_EDIT36,m_edit36);
  GetDlgItemText(IDC_EDIT13,m_edit13); 
  GetDlgItemText(IDC_EDIT14,m_edit14);  
  GetDlgItemText(IDC_EDIT15,m_edit15);  
  GetDlgItemText(IDC_EDIT16,m_edit16);  
  GetDlgItemText(IDC_EDIT17,m_edit17);  
  GetDlgItemText(IDC_EDIT18,m_edit18); 
  GetDlgItemText(IDC_EDIT19,m_edit19);   
    	CStdioFile mFile; 
		CFileException mExcept;
		if(!mFile.Open(name,CFile::modeWrite,&mExcept))
        mFile.Open(name,CFile::modeCreate|CFile::modeWrite,&mExcept);	
		mFile.SeekToEnd();
		str.Format("%s\n",m_list1);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit1);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit2);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit3);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit4);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit5);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit6);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit7);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit8);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit9);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit10);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit11);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit29);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit12);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit32);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit36);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit13);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit14);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit15);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit16);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit17);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit18);
		mFile.WriteString(str);
		str.Format("%s\n",m_edit19);
		mFile.WriteString(str);


	//	CDialog::OnOK();		
	}
	else AfxMessageBox("请输入姓名!");	
}

void Cgzcrdlg::OnButton4() 
{
	// TODO: Add your control notification handler code here

}

void Cgzcrdlg::OnChangeEdit21() 
{

}

void Cgzcrdlg::OnCheck2() 
{
  CString  m_edit20;  
  CString  m_edit25;  
  CString  m_edit26; 
  CString  m_edit27;  
  CString  m_edit28;
  CString  m_edit29;  
  GetDlgItemText(IDC_EDIT20,m_edit20);  
  GetDlgItemText(IDC_EDIT25,m_edit25);  
  GetDlgItemText(IDC_EDIT26,m_edit26); 
  GetDlgItemText(IDC_EDIT27,m_edit27);  
  GetDlgItemText(IDC_EDIT28,m_edit28);  
  double fData25;
  double fData26;
  double fData27;
  double fData28;
  double fData29;
  fData25 = atof(m_edit20)*20/100;  
  m_edit25.Format("%.2f",fData25);     
  SetDlgItemText(IDC_EDIT25,m_edit25); 
	
  fData29=atof(m_edit25)+ atof(m_edit26)+ atof(m_edit27)+ atof(m_edit28);  
  m_edit29.Format("%.2f",fData29);  
  SetDlgItemText(IDC_EDIT29,m_edit29); 
}

void Cgzcrdlg::OnChangeEdit33() 
{
  CString  m_edit33;  
  CString  m_edit34;  
  CString  m_edit35;  
  CString  m_edit36;  
  GetDlgItemText(IDC_EDIT33,m_edit33);  
  GetDlgItemText(IDC_EDIT34,m_edit34);   
  GetDlgItemText(IDC_EDIT35,m_edit35);  
  GetDlgItemText(IDC_EDIT36,m_edit36);  
  double fData33 = atof(m_edit33);  
  double fData34 = atof(m_edit34); 
  double fData35 = atof(m_edit35); 
  double fData36;
  fData36 = fData33+(120*fData34+0.2*fData35)*1/12;   
  m_edit36.Format("%.2f",fData36);     
  SetDlgItemText(IDC_EDIT36,m_edit36); 
}

void Cgzcrdlg::OnChangeEdit34() 
{
  CString  m_edit33;  
  CString  m_edit34;  
  CString  m_edit35;  
  CString  m_edit36;  
  GetDlgItemText(IDC_EDIT33,m_edit33);  
  GetDlgItemText(IDC_EDIT34,m_edit34);   
  GetDlgItemText(IDC_EDIT35,m_edit35);  
  GetDlgItemText(IDC_EDIT36,m_edit36);  
  double fData33 = atof(m_edit33);  
  double fData34 = atof(m_edit34); 
  double fData35 = atof(m_edit35); 
  double fData36;
  fData36 = fData33+(120*fData34+0.2*fData35)*1/12;   
  m_edit36.Format("%.2f",fData36);     
  SetDlgItemText(IDC_EDIT36,m_edit36); 
}

void Cgzcrdlg::OnCheck3() 
{
  CString  m_edit21;   
  CString  m_edit25;  
  CString  m_edit26; 
  CString  m_edit27;  
  CString  m_edit28;
  CString  m_edit29;   
  GetDlgItemText(IDC_EDIT21,m_edit21);  
  GetDlgItemText(IDC_EDIT25,m_edit25);  
  GetDlgItemText(IDC_EDIT26,m_edit26); 
  GetDlgItemText(IDC_EDIT27,m_edit27);  
  GetDlgItemText(IDC_EDIT28,m_edit28);  
  double fData25;
  double fData26;
  double fData27;
  double fData28;
  double fData29;
  fData26 = atof(m_edit21)*15/100;  
  m_edit26.Format("%.2f",fData26);     
  SetDlgItemText(IDC_EDIT26,m_edit26); 
  fData29=atof(m_edit25)+ atof(m_edit26)+ atof(m_edit27)+ atof(m_edit28);  
  m_edit29.Format("%.2f",fData29);  
  SetDlgItemText(IDC_EDIT29,m_edit29); 
}

void Cgzcrdlg::OnCheck4() 
{
  CString  m_edit22;  
  CString  m_edit25;  
  CString  m_edit26; 
  CString  m_edit27;  
  CString  m_edit28;
  CString  m_edit29;  
  GetDlgItemText(IDC_EDIT22,m_edit22);  
  GetDlgItemText(IDC_EDIT25,m_edit25);  
  GetDlgItemText(IDC_EDIT26,m_edit26); 
  GetDlgItemText(IDC_EDIT27,m_edit27);  
  GetDlgItemText(IDC_EDIT28,m_edit28);  
  double fData25;
  double fData26;
  double fData27;
  double fData28;
  double fData29;
  fData27 = atof(m_edit22)*10/100;  
  m_edit27.Format("%.2f",fData27);     
  SetDlgItemText(IDC_EDIT27,m_edit27); 	
  fData29=atof(m_edit25)+ atof(m_edit26)+ atof(m_edit27)+ atof(m_edit28);  
  m_edit29.Format("%.2f",fData29);  
  SetDlgItemText(IDC_EDIT29,m_edit29); 
}

void Cgzcrdlg::OnCheck5() 
{
  CString  m_edit23;   
  CString  m_edit25;  
  CString  m_edit26; 
  CString  m_edit27;  
  CString  m_edit28;
  CString  m_edit29;  
  GetDlgItemText(IDC_EDIT23,m_edit23);  
  GetDlgItemText(IDC_EDIT25,m_edit25);  
  GetDlgItemText(IDC_EDIT26,m_edit26); 
  GetDlgItemText(IDC_EDIT27,m_edit27);  
  GetDlgItemText(IDC_EDIT28,m_edit28);  
  double fData25;
  double fData26;
  double fData27;
  double fData28;
  double fData29;
  fData28 = atof(m_edit23)*5/100;  
  m_edit28.Format("%.2f",fData28);     
  SetDlgItemText(IDC_EDIT28,m_edit28); 	 
  fData29=atof(m_edit25)+ atof(m_edit26)+ atof(m_edit27)+ atof(m_edit28);  
  m_edit29.Format("%.2f",fData29);  
  SetDlgItemText(IDC_EDIT29,m_edit29); 
}

void Cgzcrdlg::OnRadio3() 
{
  SetDlgItemText(IDC_EDIT32,"100"); 	
}

void Cgzcrdlg::OnRadio4() 
{
  SetDlgItemText(IDC_EDIT32,""); 

}

void Cgzcrdlg::OnChangeEdit31() 
{
  CString  m_edit31;  
  CString  m_edit32;  
  GetDlgItemText(IDC_EDIT31,m_edit31);     
  double fData31 = atof(m_edit31);  
  double fData32; 
  fData32 = (fData31-3000)*0.02;   
  m_edit32.Format("%.2f",fData32);     
  SetDlgItemText(IDC_EDIT32,m_edit32); 
}

void Cgzcrdlg::OnButton2() 
{
  CString  m_edit1;   
  CString  m_edit2;  
  CString  m_edit3; 
  CString  m_edit4;  
  CString  m_edit5;
  CString  m_edit6;  
  CString  m_edit7;   

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -