querydlg1.cpp

开发的锌流量计算程序

// QueryDlg1.cpp : implementation file
//

#include "stdafx.h"
#include "ShaoYe.h"
#include "QueryDlg1.h"
#include "ResultDlg1.h"
#include "shaoyedoc.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQueryDlg1 dialog


CQueryDlg1::CQueryDlg1(CWnd* pParent /*=NULL*/)
	: CDialog(CQueryDlg1::IDD, pParent)
{
	CTime time=CTime::GetCurrentTime();
	int yy,mm,dd;
	yy=time.GetYear();
	mm=time.GetMonth();
	dd=time.GetDay();
	//{{AFX_DATA_INIT(CQueryDlg)
	m_day = dd;
	m_month = mm;
	m_year = yy;
	//}}AFX_DATA_INIT
	
}


void CQueryDlg1::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQueryDlg1)
	DDX_Text(pDX, IDC_DAY, m_day);
	DDX_Text(pDX, IDC_MONTH, m_month);
	DDX_Text(pDX, IDC_YEAR, m_year);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CQueryDlg1 message handlers

/*void CQueryDlg1::OnOK() 
{
	// TODO: Add extra validation here
	CShaoYeDoc* pDoc=GetDocument();

	UpdateData();
	if(m_year>2050||m_year<2000) 
		MessageBox("请输入2000－2050之间的整数","年份输入错误",MB_OK);
	else
	{
		if(m_month>12||m_month<1)
			MessageBox("请输入1－12之间的整数","月份输入错误",MB_OK);
		else
		{
			int dd;
			CString str_dd;
			if(m_month==2)
			{
				if(m_year%4==0)
					dd=29;
				else
					dd=28;
			}
			else if(m_month==4||m_month==6||m_month==9||m_month==11)
				dd=30;
			else
				dd=31;
			str_dd.Format("%d",dd);
			str_dd="请输入1－"+str_dd;
			str_dd=str_dd+"之间的整数";
			if(m_day>dd||m_day<1)
				MessageBox(str_dd,"日期输入错误",MB_OK);
			else
			{
				CDaoDatabase m_DB;
				try
				{
					m_DB.Open("e:\\shaoye\\test_result.mdb");
                    CDaoTableDef m_OpenTable1(&m_DB);
     				try
					{	
    					CString tbname;
	    				CTime time=CTime::GetCurrentTime();
		    			tbname.Format("%4d%02d%02d",m_year,m_month,m_day);
			    		m_OpenTable1.Open(tbname);
        				try
						{
							CDaoRecordset rs1;
        					rs1.Open(&m_OpenTable1,dbOpenDynaset,dbInconsistent);
                        	rs1.MoveFirst();
//							int ir=0;
							int time_time,i,j;
							while(!rs1.IsEOF())//到纪录尾,跳出循环
							{
						    	COleVariant varValue1;
								varValue1=rs1.GetFieldValue("time");
								time_time=varValue1.iVal;
								i=time_time/720;
								j=time_time-720*i;
								varValue1=rs1.GetFieldValue("flux");
							//	query_flux[i][j]=varValue1.fltVal;
								pDoc->query_flux[i][j]=varValue1.fltVal;
								//g_pDoc->m_nZxrd[ir]=varValue1.fltVal;		
//								ir++;
								rs1.MoveNext();
							}
							if(rs1.IsOpen())
								rs1.Close();
							if(m_OpenTable1.IsOpen())
								m_OpenTable1.Close();
							CResultDlg1 dlg;
							dlg.DoModal();
							CDialog::OnOK();
						}
        				catch(CDaoException* e)
						{
        					e->Delete();
						}
					}
    				catch(CDaoException* e)
					{
    					e->Delete();
	    				MessageBox("只能查询当前日期前30天的数据","没有数据",MB_OK);
					}
				}
				catch(CDaoException *e)
				{
					e->Delete();
	    			MessageBox("只能查询当前日期前30天的数据","没有数据",MB_OK);
				}
				

/*				CFlowSet search_result;
				CString strsearch;
				strsearch.Format("%4d-%02d-%02d",m_year,m_month,m_day);
				strsearch="[日期]='"+strsearch+"'";
				if(!search_result.IsOpen())
					search_result.Open();
				if(!search_result.Find(AFX_DAO_FIRST,strsearch))
				{
					MessageBox("没有数据!","请重新输入",MB_OK);
				}
				else
				{
					CResultDlg dlg;
					dlg.day=m_day;
					dlg.month=m_month;
					dlg.year=m_year;
					dlg.DoModal();
					CDialog::OnOK();
				}
			}
		}
	}
}*/

/*
CShaoYeDoc * CQueryDlg1::GetDocument()
{
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CShaoYeDoc)));
	return (CShaoYeDoc*)m_pDocument;
}
*/