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

📄 gzlldlg.cpp

📁 工资表数据库系统
💻 CPP
字号:
🔍 
// gzlldlg.cpp : implementation file
//

#include "stdafx.h"
#include "工资表.h"
#include "gzlldlg.h"
#include "ADOConn.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// Cgzlldlg dialog


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


void Cgzlldlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cgzlldlg)
	DDX_Control(pDX, IDC_LIST1, m_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Cgzlldlg, CDialog)
	//{{AFX_MSG_MAP(Cgzlldlg)
	ON_BN_CLICKED(IDOK4, OnOk4)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cgzlldlg message handlers

BOOL Cgzlldlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	
	// TODO: Add extra initialization here
	m_list.InsertColumn(0,"号",LVCFMT_LEFT,25);
	m_list.InsertColumn(1,"姓名",LVCFMT_LEFT,40);
	m_list.InsertColumn(2,"基本工资",LVCFMT_LEFT,60);
	m_list.InsertColumn(3,"工龄工资",LVCFMT_LEFT,60);
	m_list.InsertColumn(4,"任务工资",LVCFMT_LEFT,60);
	m_list.InsertColumn(5,"级别工资",LVCFMT_LEFT,60);
	m_list.InsertColumn(6,"职务工资",LVCFMT_LEFT,60);
	m_list.InsertColumn(7,"加班工资",LVCFMT_LEFT,60);
	m_list.InsertColumn(8,"电话补贴",LVCFMT_LEFT,60);
	m_list.InsertColumn(9,"交通补贴",LVCFMT_LEFT,60);
	m_list.InsertColumn(10,"午餐补贴",LVCFMT_LEFT,60);
	m_list.InsertColumn(11,"保险费",LVCFMT_LEFT,50);
	m_list.InsertColumn(12,"全勤奖",LVCFMT_LEFT,60);
	m_list.InsertColumn(13,"业务提成",LVCFMT_LEFT,60);
	m_list.InsertColumn(14,"技术津贴",LVCFMT_LEFT,60);
	m_list.InsertColumn(15,"市内差旅费",LVCFMT_LEFT,80);
	m_list.InsertColumn(16,"基金提成",LVCFMT_LEFT,60);
	m_list.InsertColumn(17,"应发工资总额",LVCFMT_LEFT,90);
	m_list.InsertColumn(18,"扣保险费",LVCFMT_LEFT,60);
	m_list.InsertColumn(19,"扣迟到",LVCFMT_LEFT,50);
	m_list.InsertColumn(20,"扣全勤",LVCFMT_LEFT,50);
	m_list.InsertColumn(21,"扣任务工资",LVCFMT_LEFT,80);
	m_list.InsertColumn(22,"扣其它",LVCFMT_LEFT,50);
	m_list.InsertColumn(23,"实发工资",LVCFMT_LEFT,60);


    //给列表加上表格
	LONG lStyle = m_list.SendMessage(LVM_GETEXTENDEDLISTVIEWSTYLE);
    lStyle |= LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES |LVS_EX_HEADERDRAGDROP;
    m_list.SendMessage(LVM_SETEXTENDEDLISTVIEWSTYLE, 0,(LPARAM)lStyle);
	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);
	while(m_AdoConn.m_pRecordset->adoEOF==0)
	{
		m_list.InsertItem(0,"1");
		m_list.SetItemText(0,0,(char*)(_bstr_t)m_pRecordset->GetCollect("id"));
		m_list.SetItemText(0,1,(char*)(_bstr_t)m_pRecordset->GetCollect("name"));
		m_list.SetItemText(0,2,(char*)(_bstr_t)m_pRecordset->GetCollect("a1"));
		m_list.SetItemText(0,3,(char*)(_bstr_t)m_pRecordset->GetCollect("a2"));
		m_list.SetItemText(0,4,(char*)(_bstr_t)m_pRecordset->GetCollect("a3"));
		m_list.SetItemText(0,5,(char*)(_bstr_t)m_pRecordset->GetCollect("a4"));
		m_list.SetItemText(0,6,(char*)(_bstr_t)m_pRecordset->GetCollect("a5"));
		m_list.SetItemText(0,7,(char*)(_bstr_t)m_pRecordset->GetCollect("a6"));
		m_list.SetItemText(0,8,(char*)(_bstr_t)m_pRecordset->GetCollect("a7"));
		m_list.SetItemText(0,9,(char*)(_bstr_t)m_pRecordset->GetCollect("a8"));
		m_list.SetItemText(0,10,(char*)(_bstr_t)m_pRecordset->GetCollect("a9"));
		m_list.SetItemText(0,11,(char*)(_bstr_t)m_pRecordset->GetCollect("a10"));
		m_list.SetItemText(0,12,(char*)(_bstr_t)m_pRecordset->GetCollect("a11"));
		m_list.SetItemText(0,13,(char*)(_bstr_t)m_pRecordset->GetCollect("a12"));
		m_list.SetItemText(0,14,(char*)(_bstr_t)m_pRecordset->GetCollect("a13"));
		m_list.SetItemText(0,15,(char*)(_bstr_t)m_pRecordset->GetCollect("a14"));
		m_list.SetItemText(0,16,(char*)(_bstr_t)m_pRecordset->GetCollect("a15"));
		m_list.SetItemText(0,17,(char*)(_bstr_t)m_pRecordset->GetCollect("s1"));
		m_list.SetItemText(0,18,(char*)(_bstr_t)m_pRecordset->GetCollect("b1"));
		m_list.SetItemText(0,19,(char*)(_bstr_t)m_pRecordset->GetCollect("b2"));
		m_list.SetItemText(0,20,(char*)(_bstr_t)m_pRecordset->GetCollect("b3"));
		m_list.SetItemText(0,21,(char*)(_bstr_t)m_pRecordset->GetCollect("b4"));
		m_list.SetItemText(0,22,(char*)(_bstr_t)m_pRecordset->GetCollect("b5"));
		m_list.SetItemText(0,23,(char*)(_bstr_t)m_pRecordset->GetCollect("s2"));


		m_pRecordset->MoveNext();
	}
	m_AdoConn.ExitConnect();
//	ReadRecord();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void Cgzlldlg::ReadRecord()
{
	//读出纪录
    CStdioFile mFile; 
	CFileException mExcept;
	CString readstr;
	CString IDstr;
	int i=0;
	if(!mFile.Open("工资.txt",CFile::modeRead,&mExcept))
        mFile.Open("工资.txt",CFile::modeCreate|CFile::modeRead,&mExcept);
	while(mFile.ReadString(readstr))
	{
		IDstr.Format("%d",(i+1));
		m_list.InsertItem(i,IDstr);
	    m_list.SetItemText(i,1,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,2,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,3,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,4,readstr);	
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,5,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,6,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,7,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,8,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,9,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,10,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,11,readstr);

        mFile.ReadString(readstr);
     	m_list.SetItemText(i,12,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,13,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,14,readstr);	
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,15,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,16,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,17,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,18,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,19,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,20,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,21,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,22,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,23,readstr);

		i++;		
	}
}

void Cgzlldlg::OnOk4() 
{
 UpdateData(TRUE);
	//保存记录文件  

  CString str;
  CString name;
 //   name=m_edit161+".txt";
  name="工资1.xls";
   	CStdioFile mFile; 
		CFileException mExcept;
		if(!mFile.Open(name,CFile::modeWrite,&mExcept))
        mFile.Open(name,CFile::modeCreate|CFile::modeWrite,&mExcept);	
		mFile.SeekToEnd();

	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);
	while(m_AdoConn.m_pRecordset->adoEOF==0)
	{
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("id"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("name"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a1"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a2"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a3"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a4"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a5"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a6"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a7"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a8"));
		mFile.WriteString(str);	
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a9"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a10"));
		mFile.WriteString(str);	
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a11"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a12"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a13"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a14"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a15"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("s1"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("b1"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("b2"));
		mFile.WriteString(str);	
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("b3"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("b4"));
		mFile.WriteString(str);
		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("b5"));
		mFile.WriteString(str);
		str.Format("%s\n",(char*)(_bstr_t)m_pRecordset->GetCollect("s2"));
		mFile.WriteString(str);

		m_pRecordset->MoveNext();
	}
	m_AdoConn.ExitConnect();


//	ReadRecord();
}

void Cgzlldlg::OnButton1() 
{
if (!UpdateData(TRUE))
{
AfxMessageBox("数据交换有误!");
}
//if (m_strPrintString==_T(""))
//{
//AfxMessageBox("请输入需要打印的文字?quot");
//return;
//}
CPrintDialog dlg(FALSE,
PD_NOPAGENUMS|PD_NOSELECTION,
this);
if(dlg.DoModal() == IDOK)
{
CDC dc;
dc.Attach(dlg.GetPrinterDC());//把打印设备环境附加到DC对象
	int leftmargin;
		leftmargin = dc.GetDeviceCaps(PHYSICALOFFSETX);
		CRect m_rect(-leftmargin,0,dc.GetDeviceCaps(PHYSICALWIDTH)-leftmargin,dc.GetDeviceCaps(PHYSICALHEIGHT));
	dc.StartDoc("printinformation");		
	CFont font150;
	font150.CreatePointFont(150,_T("黑体"),&dc);
	dc.SelectObject(&font150);
	    float ratex =5;
        float ratey =10;
int lx=30;	
	dc.Rectangle(20*ratey,0*ratex,950*ratex,lx*ratex+25*51*ratex);
			//绘制横线
      for(int i=1;i<=50;i++)
	  {
		dc.MoveTo(20*ratey,lx*ratex+25*i*ratex);
		dc.LineTo(950*ratey,lx*ratex+25*i*ratex);
	  }
	  		//绘制竖线
	        for(int i1=1;i<=10;i++)
	  {
		dc.MoveTo(56*ratey*i1,lx*ratex+25*2*ratex);
		dc.LineTo(56*ratey*i1,lx*ratex+25*51*ratex);
		}

	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString sql;
	CString str;
	sql.Format("select* from employees order by id desc");
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet((_bstr_t)sql);
	while(m_AdoConn.m_pRecordset->adoEOF==0)
	{

		dc.TextOut(20*ratey+50,90,"Quotation(工资表):");

		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("id"));
		dc.TextOut(20*ratey+50,ratex+25*2*ratex,str);

		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("name"));
		dc.TextOut(20*ratey+550,ratex+25*2*ratex,str);

		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a1"));
		dc.TextOut(20*ratey+1050,ratex+25*2*ratex,str);

		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a2"));
		dc.TextOut(20*ratey+1550,ratex+25*2*ratex,str);

		str.Format("%s\t",(char*)(_bstr_t)m_pRecordset->GetCollect("a3"));
		dc.TextOut(20*ratey+2050,ratex+25*2*ratex,str);

		m_pRecordset->MoveNext();
	}
	m_AdoConn.ExitConnect();


	dc.TextOut(20*ratey+50,90,"Quotation(报价单):");
	dc.EndDoc();
}	
}

⌨️ 快捷键说明

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