new3dlg.cpp

用数据库ACCESS和VISUAL C++编程

// new3Dlg.cpp : implementation file
//

#include "stdafx.h"
#include "new3.h"
#include "splash.h"
#include "new3Dlg.h"
#include "Cxndiaodong.h"
#include "Ceditdlg.h"
#include "Czgqndlg.h"
#include "Cgzdiaoli.h"
#include "Cxwdiaoru.h"
#include "Cgongziset.h"
#include "Czgtable.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAboutDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
	//{{AFX_DATA_INIT(CAboutDlg)
	//}}AFX_DATA_INIT
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAboutDlg)
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
		// No message handlers
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CNew3Dlg dialog

CNew3Dlg::CNew3Dlg(CWnd* pParent /*=NULL*/)
	: CDialog(CNew3Dlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CNew3Dlg)
	m_static1 = _T("");
	m_betie22 = 0.0f;
	m_butie11 = 0.0f;
	m_butieid = _T("");
	m_ff = 0.0f;
	m_fsbt = 0.0f;
	m_jtbt = 0.0f;
	m_jzkk = 0.0f;
	m_kkzgid = _T("");
	m_mlbt = 0.0f;
	m_qtkk = 0.0f;
	m_sdf = 0.0f;
	m_terf = 0.0f;
	m_zhigongidchaxun = _T("");
	m_bumennamecheck = _T("");
	m_howmany = _T("");
	//}}AFX_DATA_INIT
	// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CNew3Dlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CNew3Dlg)
	DDX_Control(pDX, IDC_BUMENCHAXUN, m_bumenchaxun);
	DDX_Control(pDX, IDC_ZIGONGCHAXUN, m_zigongchaxun);
	DDX_Control(pDX, IDOK, m_ok);
	DDX_Control(pDX, IDC_QUANNIANGZ, m_qngzqk);
	DDX_Control(pDX, IDC_NEXT, m_next);
	DDX_Control(pDX, IDC_RYDIAOLI, m_rydl);
	DDX_Control(pDX, IDC_XWDIAORU, m_xwdr);
	DDX_Control(pDX, IDC_XNDIAODONG, m_xndd);
	DDX_Control(pDX, IDC_RESET2, m_reset2);
	DDX_Control(pDX, IDC_RESET1, m_reset1);
	DDX_Control(pDX, IDC_YES2, m_yes2);
	DDX_Control(pDX, IDC_YES1, m_yes1);
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Text(pDX, IDC_STATIC1, m_static1);
	DDX_Text(pDX, IDC_BT2, m_betie22);
	DDX_Text(pDX, IDC_BT1, m_butie11);
	DDX_Text(pDX, IDC_BTZGID, m_butieid);
	DDX_Text(pDX, IDC_FF, m_ff);
	DDX_Text(pDX, IDC_FSBT, m_fsbt);
	DDX_Text(pDX, IDC_JTBT, m_jtbt);
	DDX_Text(pDX, IDC_JZKK, m_jzkk);
	DDX_Text(pDX, IDC_KKZGID, m_kkzgid);
	DDX_Text(pDX, IDC_MLBT, m_mlbt);
	DDX_Text(pDX, IDC_QTKK, m_qtkk);
	DDX_Text(pDX, IDC_SDF, m_sdf);
	DDX_Text(pDX, IDC_TERF, m_terf);
	DDX_Text(pDX, IDC_ZHIGONGIDCHAXUN, m_zhigongidchaxun);
	DDX_Text(pDX, IDC_BUMENNAMECHAXUN, m_bumennamecheck);
	DDX_Text(pDX, IDC_HOWMANY, m_howmany);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CNew3Dlg, CDialog)
	//{{AFX_MSG_MAP(CNew3Dlg)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	ON_BN_CLICKED(IDC_NEXT, OnNext)
	ON_BN_CLICKED(IDC_YES1, OnYes1)
	ON_BN_CLICKED(IDC_YES2, OnYes2)
	ON_BN_CLICKED(IDC_RESET1, OnReset1)
	ON_BN_CLICKED(IDC_RESET2, OnReset2)
	ON_BN_CLICKED(IDC_XNDIAODONG, OnXndiaodong)
	ON_BN_CLICKED(IDC_RYDIAOLI, OnRydiaoli)
	ON_BN_CLICKED(IDC_XWDIAORU, OnXwdiaoru)
	ON_BN_CLICKED(IDC_QUANNIANGZ, OnQuanniangz)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
	ON_EN_CHANGE(IDC_BTZGID, OnChangeBtzgid)
	ON_EN_CHANGE(IDC_KKZGID, OnChangeKkzgid)
	ON_BN_CLICKED(IDC_ZIGONGCHAXUN, OnZigongchaxun)
	ON_BN_CLICKED(IDC_BUMENCHAXUN, OnBumenchaxun)
	ON_BN_CLICKED(IDC_REFLESH, OnReflesh)
	ON_NOTIFY(LVN_COLUMNCLICK, IDC_LIST1, OnColumnclickList1)
	ON_BN_CLICKED(IDC_PRINT, OnPrint)
	ON_WM_CLOSE()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CNew3Dlg message handlers

BOOL CNew3Dlg::OnInitDialog()
{
	CDialog::OnInitDialog();
//m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);
    m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
//m_list.SetTextBkColor(RGB(255,0,0)); 
//    m_list.SetTextColor(RGB(110,0,255)); 
	// Add "About..." menu item to system menu.
    AfxGetMainWnd()->ShowWindow(SW_SHOWMAXIMIZED);
	// IDM_ABOUTBOX must be in the system command range.
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
	ASSERT(IDM_ABOUTBOX < 0xF000);

	CMenu* pSysMenu = GetSystemMenu(FALSE);
	if (pSysMenu != NULL)
	{
		CString strAboutMenu;
		strAboutMenu.LoadString(IDS_ABOUTBOX);
		if (!strAboutMenu.IsEmpty())
		{
			pSysMenu->AppendMenu(MF_SEPARATOR);
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
		}
	}
    CSplashWnd::ShowSplashScreen(this);
	buttonBMP.LoadBitmap(IDB_BITMAP1);
	m_yes1.SetBitmap((HBITMAP)buttonBMP.m_hObject);
	buttonBMP1.LoadBitmap(IDB_BITMAP3);
	m_reset1.SetBitmap((HBITMAP)buttonBMP1.m_hObject);

	buttonBMP2.LoadBitmap(IDB_BITMAP1);
	m_yes2.SetBitmap((HBITMAP)buttonBMP2.m_hObject);
	buttonBMP3.LoadBitmap(IDB_BITMAP3);
	m_reset2.SetBitmap((HBITMAP)buttonBMP3.m_hObject); 

	buttonBMP4.LoadBitmap(IDB_BITMAP4);
	m_next.SetBitmap((HBITMAP)buttonBMP4.m_hObject); 

	buttonBMP5.LoadBitmap(IDB_BITMAP5);
	m_qngzqk.SetBitmap((HBITMAP)buttonBMP5.m_hObject); 

    buttonBMP6.LoadBitmap(IDB_BITMAP6);
	m_ok.SetBitmap((HBITMAP)buttonBMP6.m_hObject); 

	buttonBMP7.LoadBitmap(IDB_BITMAP7);
	m_xwdr.SetBitmap((HBITMAP)buttonBMP7.m_hObject); 

	buttonBMP8.LoadBitmap(IDB_BITMAP8);
	m_xndd.SetBitmap((HBITMAP)buttonBMP8.m_hObject); 

	buttonBMP9.LoadBitmap(IDB_BITMAP9);
	m_rydl.SetBitmap((HBITMAP)buttonBMP9.m_hObject); 

	buttonBMP10.LoadBitmap(IDB_BITMAP11);
	m_bumenchaxun.SetBitmap((HBITMAP)buttonBMP10.m_hObject); 

	buttonBMP11.LoadBitmap(IDB_BITMAP11);
	m_zigongchaxun.SetBitmap((HBITMAP)buttonBMP11.m_hObject); 
    CTime time1;

    
	// Set the icon for this dialog.  The framework does this automatically
	//  when the application's main window is not a dialog
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	//m_list.SetImageList( &m_lgImageList, LVSIL_NORMAL );
	//m_list.SetImageList( &m_lgImageList, LVSIL_SMALL );
	
	// set up main list box columns
		m_list.InsertColumn ( 0, "编号", LVCFMT_CENTER, 40 );
	m_list.InsertColumn ( 1, "部门ID", LVCFMT_CENTER, 50 );
	m_list.InsertColumn ( 2, "部门名称", LVCFMT_CENTER,120 );
	m_list.InsertColumn ( 3, "职工ID", LVCFMT_CENTER, 60 );
	m_list .InsertColumn ( 4, "职工名字", LVCFMT_CENTER,60 );
	m_list.InsertColumn(5,"性别",LVCFMT_CENTER,40); 
	m_list .InsertColumn ( 6, "基本工资", LVCFMT_CENTER,60 );
	m_list .InsertColumn ( 7, "工龄工资", LVCFMT_CENTER, 60 );
	m_list.InsertColumn ( 8, "副食补贴", LVCFMT_CENTER, 60 );
	m_list.InsertColumn ( 9, "煤粮补贴", LVCFMT_CENTER,60 );
	m_list.InsertColumn ( 10, "交通补贴", LVCFMT_CENTER, 60 );
	m_list .InsertColumn ( 11, "补贴1", LVCFMT_CENTER,50 );
	m_list .InsertColumn ( 12, "补贴2", LVCFMT_CENTER,50 );
	m_list .InsertColumn ( 13, "补贴合计", LVCFMT_CENTER, 60 );
	m_list.InsertColumn ( 14, "应发工资", LVCFMT_CENTER, 60 );
	m_list.InsertColumn ( 15, "房费", LVCFMT_CENTER,50 );
	m_list.InsertColumn ( 16, "水电费", LVCFMT_CENTER, 60 );
	m_list .InsertColumn ( 17, "托儿费", LVCFMT_CENTER,60 );
	m_list .InsertColumn ( 18, "借支扣款", LVCFMT_CENTER,60 );
	m_list .InsertColumn ( 19, "其它扣款", LVCFMT_CENTER, 60 );
	m_list.InsertColumn ( 20, "扣款合计", LVCFMT_CENTER, 60 );
	m_list.InsertColumn ( 21, "实发工资", LVCFMT_CENTER,60 );
	m_list.InsertColumn ( 22, "备注", LVCFMT_CENTER, 40 );
	//m_list .InsertColumn ( 3, "职工名字", LVCFMT_LEFT,60 );
	//m_list .InsertColumn ( 4, "基本工资", LVCFMT_LEFT,60 );
	//m_list .InsertColumn ( 5, "工龄工资", LVCFMT_LEFT, 60 );
    loadlist();
   UpdateData(false);
	// show the splash screen
	 
	//CSplashWnd::ShowSplashScreen ( this );
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE  unless you set the focus to a control
}

void CNew3Dlg::OnSysCommand(UINT nID, LPARAM lParam)
{
	if ((nID & 0xFFF0) == IDM_ABOUTBOX)
	{
		CAboutDlg dlgAbout;
		dlgAbout.DoModal();
	}
	else
	{
		CDialog::OnSysCommand(nID, lParam);
	}
}

// If you add a minimize button to your dialog, you will need the code below
//  to draw the icon.  For MFC applications using the document/view model,
//  this is automatically done for you by the framework.

void CNew3Dlg::OnPaint() 
{
	if (IsIconic())
	{
		CPaintDC dc(this); // device context for painting

		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);

		// Center icon in client rectangle
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;

		// Draw the icon
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

// The system calls this to obtain the cursor to display while the user drags
//  the minimized window.
HCURSOR CNew3Dlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}

void CNew3Dlg::loadlist()
{
   
   char szBuffer [ 256 ];
   int k=0;
   CTime ti;
   CString str,strmySql,ss,sex1;
   m_list.DeleteAllItems(); 
   
   gz_set.Open();
   gz_set.MoveFirst();
   int i=0;	
   y=ti.GetCurrentTime().GetYear() ;
	 m=ti.GetCurrentTime().GetMonth();
   while(!gz_set.IsEOF() )
   {
	   if(gz_set.m_flag==0)
	   {
		y=gz_set.m_timey;
		m=gz_set.m_timem; 
	   m_list.InsertItem (i, LPCTSTR ( ltoa (i+1, szBuffer, 10 )), 0 );
	   m_list.SetItemText(i,1,LPCTSTR(gz_set.m_bumenID));
	   m_list.SetItemText(i,2,LPCTSTR(gz_set.m_bumenname ));
	   m_list.SetItemText(i,3,LPCTSTR(gz_set.m_zhigongID ));
	   m_list.SetItemText(i,4,LPCTSTR(gz_set.m_zhigongname ));
	   //if(gz_set.m_sex=="m")
        m_list.SetItemText(i,5,LPCTSTR(gz_set.m_sex));            
	   str.Format("%.3f",gz_set.m_jibengongzi); 
	   m_list.SetItemText(i,6,LPCTSTR(str ));
	   str.Format("%.3f",gz_set.m_gonglinggongzi);
	   m_list.SetItemText(i,7,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_fushibutie );
	   m_list.SetItemText(i,8,LPCTSTR(str));
       
	   str.Format("%.3f",gz_set.m_meiliangbutie );
	   m_list.SetItemText(i,9,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_jiaotongbutie);
	   m_list.SetItemText(i,10,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_butie1 );
	   m_list.SetItemText(i,11,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_butie2);
	   m_list.SetItemText(i,12,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_butieheji );
	   m_list.SetItemText(i,13,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_yingfagongzi);
	   m_list.SetItemText(i,14,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_fangfei );
	   m_list.SetItemText(i,15,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_shuidianfei );
	   m_list.SetItemText(i,16,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_tuoerfei );
	   m_list.SetItemText(i,17,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_jiezhikoukuang );
	   m_list.SetItemText(i,18,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_qitakoukuang );
	   m_list.SetItemText(i,19,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_koukuangheji );
	   m_list.SetItemText(i,20,LPCTSTR(str));

	   str.Format("%.3f",gz_set.m_shifagongzi );
	   m_list.SetItemText(i,21,LPCTSTR(str));

	   m_list.SetItemText(i,22,LPCTSTR(gz_set.m_beizhu ));
	   i=i+1;
	   }
	   gz_set.MoveNext();
	   
   }
   ss.Format("===你正在处理的是%d年%d月的工资情况===",y ,m); 
	m_static1.Format(ss);
	ss.Format("(共有%d条记录)",i);
	m_howmany.Format(ss); 
	UpdateData(false);
 
}

void CNew3Dlg::OnNext() 
{
	// TODO: Add your control notification handler code here