📄 latestdatadlg.cpp
字号:
CDBTenSec m_DBOnePage[RecordNum_PerPage];
pApp->m_curConfig.GetDataFromTenSec(stempsql,m_DBOnePage,m_nCurRecNum);
int nItem, RowNumber;
CString strNo, strTimeIndex;
m_grid.DeleteAllItems();//.SetRedraw(true);
for(RowNumber=0;RowNumber<m_nCurRecNum;RowNumber++)
{
strNo.Format("%d", RowNumber);
strTimeIndex = GetTimeFromIndex(m_DBOnePage[RowNumber].m_nIndex);
int nVIndex=0;//可见条目序号
int nk = 0;
nItem = m_grid.InsertItem(RowNumber, _T(strNo));
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)strTimeIndex);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sSO2SC);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sNOSC);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sNO2SC);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanchenSC);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sSO2ZS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sNOZS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sNO2ZS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanchenZS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanqiWD);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanqiSD);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanqiLS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanqiHY);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
}
}
else
{
AfxMessageBox("没有记录!请重新设置查询条件!");
return;
}
// COleDateTime m_EndTime;
// m_nCurPage = 2;
// m_grid.SetRedraw();
}
CString CLatestDataDlg::GetTimeFromIndex(int index)
{
CString sDate("2008-1-18");//获取数据库表名带的日期信息
CString sDateTime,sHour,sMin,sSec;
int nHour,nMin,nSec;
nHour=index/360;
nMin=(index%360)/6;
nSec=((index%360)%6)*10;
if(nHour>9)
sHour.Format("%d::",nHour);
else
sHour.Format("0%d::",nHour);
if(nMin>9)
sMin.Format("%d::",nMin);
else
sMin.Format("0%d::",nMin);
if(nSec>9)
sSec.Format("%d",nSec);
else
sSec.Format("0%d",nSec);
// sTime.Format("%d::%d::%d",nHour,nMin,nSec);
sDateTime = sDate +" "+sHour+sMin+sSec;
return sDateTime;
}
void CLatestDataDlg::OnNextpage()
{
// TODO: Add your control notification handler code here
m_nCurPage++;
GetDlgItem(IDC_PREPAGE)->EnableWindow(true);
int nStart,nEnd;
if(m_nCurPage>m_npages)
if(m_nLProw==0)
{
GetDlgItem(IDC_NEXTPAGE)->EnableWindow(false);
return;
}
else
{
m_nCurRecNum = m_nLProw;
nEnd = m_npages*RecordNum_PerPage+m_nLProw;
nStart = m_npages*RecordNum_PerPage;
m_nCurPage = m_npages+1;
GetDlgItem(IDC_NEXTPAGE)->EnableWindow(false);
//设置“下一页”按钮变灰色，不响应
}
else
{
m_nCurRecNum = RecordNum_PerPage;
nEnd = m_nCurPage*RecordNum_PerPage;
nStart = (m_nCurPage-1)*RecordNum_PerPage;
}
CDataTestApp* pApp = (CDataTestApp*) AfxGetApp();
CString stempsql;
if(!m_bquery)
{
stempsql.Format(m_sInitNsql,nEnd,m_sCurTable,nStart,m_sCurTable);
}
else
{
stempsql.Format(m_sQueryNsql,nEnd,m_sCurTable,nStartIndex,nEndIndex,nStart,m_sCurTable,nStartIndex,nEndIndex);
}
// stempsql.Format(m_sCursql,nEnd,m_sCurTable,nStart,m_sCurTable);
CDBTenSec m_DBOnePage[RecordNum_PerPage];
/**************/
// stempsql.Format("SELECT TOP %d * FROM TenSec WHERE TenS_nID NOT IN(SELECT TOP %d TenS_nID FROM TenSec)",nEnd,nStart);
pApp->m_curConfig.GetDataFromTenSec(stempsql,m_DBOnePage,m_nCurRecNum);
int nItem, RowNumber;
CString strNo, strTimeIndex;
m_grid.DeleteAllItems();//.SetRedraw(true);
for(RowNumber=0;RowNumber<m_nCurRecNum;RowNumber++)
{
strNo.Format("%d", RowNumber);
strTimeIndex = GetTimeFromIndex(m_DBOnePage[RowNumber].m_nIndex);
int nVIndex=0;//可见条目序号
int nk = 0;
nItem = m_grid.InsertItem(RowNumber, _T(strNo));
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)strTimeIndex);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sSO2SC);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sNOSC);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sNO2SC);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanchenSC);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sSO2ZS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sNOZS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sNO2ZS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanchenZS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanqiWD);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanqiSD);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanqiLS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanqiHY);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
}
}
void CLatestDataDlg::OnPrepage()
{
// TODO: Add your control notification handler code here
m_nCurPage--;
GetDlgItem(IDC_NEXTPAGE)->EnableWindow(true);
int nStart,nEnd;
if(m_nCurPage<2)
{
GetDlgItem(IDC_PREPAGE)->EnableWindow(false);
}
m_nCurRecNum = RecordNum_PerPage;
nEnd = m_nCurPage*RecordNum_PerPage;
nStart = (m_nCurPage-1)*RecordNum_PerPage;
CDataTestApp* pApp = (CDataTestApp*) AfxGetApp();
CString stempsql;
if(!m_bquery)
{
if(m_nCurPage==1)
stempsql.Format(m_sInitPsql,nEnd,m_sCurTable,nStart,m_sCurTable);
else
stempsql.Format(m_sInitNsql,nEnd,m_sCurTable,nStart,m_sCurTable);
}
else
{
if(m_nCurPage==1)
stempsql.Format(m_sQueryPsql,nEnd,m_sCurTable,nStart,m_sCurTable);
else
stempsql.Format(m_sQueryNsql,nEnd,m_sCurTable,nStartIndex,nEndIndex,nStart,m_sCurTable,nStartIndex,nEndIndex);
}
// CString stempsql;
// stempsql.Format(m_sCursql,nEnd,m_sCurTable,nStart,m_sCurTable);
CDBTenSec m_DBOnePage[RecordNum_PerPage];
pApp->m_curConfig.GetDataFromTenSec(stempsql,m_DBOnePage,m_nCurRecNum);
int nItem, RowNumber;
CString strNo, strTimeIndex;
m_grid.DeleteAllItems();//.SetRedraw(true);
for(RowNumber=0;RowNumber<m_nCurRecNum;RowNumber++)
{
strNo.Format("%d", RowNumber);
strTimeIndex = GetTimeFromIndex(m_DBOnePage[RowNumber].m_nIndex);
int nVIndex=0;//可见条目序号
int nk = 0;
nItem = m_grid.InsertItem(RowNumber, _T(strNo));
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)strTimeIndex);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sSO2SC);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sNOSC);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sNO2SC);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanchenSC);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sSO2ZS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sNOZS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sNO2ZS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanchenZS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanqiWD);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanqiSD);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanqiLS);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,(char*)(_bstr_t)m_DBOnePage[RowNumber].m_sYanqiHY);
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
if(m_bItemState[nk++])
m_grid.SetItemText(nItem,nVIndex++,"");
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -