resultdlg.cpp

开发的锌流量计算程序

// ResultDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ShaoYe.h"
#include "ResultDlg.h"
#include "flowset.h"

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

/////////////////////////////////////////////////////////////////////////////
// CResultDlg dialog


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


void CResultDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CResultDlg)
	DDX_Control(pDX, IDC_MSFLEXGRID1, m_grid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CResultDlg, CDialog)
	//{{AFX_MSG_MAP(CResultDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CResultDlg message handlers

BOOL CResultDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CString str;
	str.Format("%4d年%2d月%2d日流量表",year,month,day);
	SetDlgItemText(IDC_STATIC1,str);

	m_nRow = 1;
    m_nCol = 1;
	m_grid.SetColWidth(0,1500);
	m_grid.SetColWidth(2,1500);
	m_grid.SetColWidth(4,1500);
	char*   arCols[6] = { "时段","总流量(吨)","时段","总流量(吨)","时段","总流量(吨)"};
    char*   arRows[27] = { "0:00-1:00", "1:00-2:00", "2:00-3:00", "3:00-4:00",
		"4:00-5:00","5:00-6:00","6:00-7:00","7:00-8:00","早班总计",
		"8:00-9:00", "9:00-10:00", "10:00-11:00", "11:00-12:00",
		"12:00-13:00","13:00-14:00","14:00-15:00","15:00-16:00","中班总计",
		"16:00-17:00","17:00-18:00","18:00-19:00","19:00-20:00",
		"20:00-21:00","21:00-22:00","22:00-23:00","23:00-0:00","晚班总计"};
 
	for(int i=0;i<6;i++)
		m_grid.SetColAlignment(i,3);
	m_grid.SetRow( 0 );
	for( int nCol = 0; nCol <6; nCol++ )
	{
		m_grid.SetCol( nCol);
		m_grid.SetText( arCols[nCol] );
	}
	m_grid.SetCol(0);
	for( int nRow = 0; nRow <9; nRow++ )
	{
		m_grid.SetRow( nRow+1);
		m_grid.SetText( arRows[nRow] );
	}

	m_grid.SetCol(2);
	for(nRow = 0; nRow <9; nRow++ )
	{
		m_grid.SetRow( nRow+1);
		m_grid.SetText( arRows[nRow+9] );
	}
	m_grid.SetCol(4);
	for(nRow = 0; nRow <9; nRow++ )
	{
		m_grid.SetRow( nRow+1);
		m_grid.SetText( arRows[nRow+18] );
	}
	
	ManageData();

	return TRUE;
}

void CResultDlg::ManageData()
{
	int i,nCol,nRow;
	CString strValue;
	
	CFlowSet m_Flow;
	CString date;
	date.Format("%4d-%02d-%02d",year,month,day);
	CString SQL="SELECT * FROM flow where [日期]='"+date;
	SQL=SQL+"'";

	float total_flux[3]={0,0,0};
	try
	{
		if(!m_Flow.IsOpen())
		{
			m_Flow.Open(dbOpenDynaset,SQL);
		}
		while(!(m_Flow.IsEOF()))
		{
			i=m_Flow.m_nRange;
			nCol=i/8*2+1;
			nRow=i%8+1;
			total_flux[(nCol-1)/2]+=m_Flow.m_nFlow/1000;
			strValue.Format("%10.3f",m_Flow.m_nFlow/1000);
			m_grid.SetRow(nRow);
			m_grid.SetCol(nCol);
			m_grid.SetText(strValue);
			m_Flow.MoveNext();
		}
		for(i=0;i<3;i++)
		{
			strValue.Format("%10.3f",total_flux[i]);
			m_grid.SetRow(9);
			m_grid.SetCol(2*i+1);
			if(total_flux[i]!=0)
				m_grid.SetText(strValue);
		}
	}
	catch(CDaoException *e)
	{
		AfxMessageBox(e->m_pErrorInfo->m_strDescription);
		e->Delete();
	}
	m_Flow.Close();

}