看看我的代码,为什么余额那个字段返回的值会把0截掉,余额的数据类型为数字15位,两位小数
序号 柜员号 币种 余额1 0010 01 4145而余额的实际值为414500.00代码如下:
m_MSFGrid.SetCols(4);
m_MSFGrid.SetRows(1);
//m_MSFGrid.SetColAlignment(3,0);
m_MSFGrid.SetTextMatrix(0,0,"序号");
m_MSFGrid.SetTextMatrix(0,1,"柜员号");
m_MSFGrid.SetTextMatrix(0,2,"币种");
m_MSFGrid.SetTextMatrix(0,3,"余额");
m_MSFGrid.SetColWidth(0,8*120);
m_MSFGrid.SetColWidth(1,10*120);
m_MSFGrid.SetColWidth(2,10*120);
m_MSFGrid.SetColWidth(3,15*120); if(m_pRecordset == NULL)
{
return;
} try
{
m_pRecordset->MoveFirst();
}
catch(_com_error e)
{
AfxMessageBox(_T("没有满足条件记录"));
return;
}
m_MSFGrid.SetCols(4);
int iCount=0;
while(!m_pRecordset->adoEOF)
{
m_pRecordset->MoveNext();
iCount++;
} m_pRecordset->MoveFirst();
m_MSFGrid.SetRows(iCount +1); _variant_t vTRTL,vCYTP,vACBL;
int iRow = 1;
while(!m_pRecordset->adoEOF)
{
CString str; str.Format("%d",iRow);
m_MSFGrid.SetRow(iRow);m_MSFGrid.SetCol(0);
m_MSFGrid.SetText(str); m_MSFGrid.SetRow(iRow);m_MSFGrid.SetCol(1);
vTRTL = m_pRecordset->GetCollect("TRTL");
m_MSFGrid.SetText((_bstr_t)vTRTL); m_MSFGrid.SetRow(iRow);m_MSFGrid.SetCol(2);
vCYTP = m_pRecordset->GetCollect("CYTP");
m_MSFGrid.SetText((_bstr_t)vCYTP); m_MSFGrid.SetRow(iRow);m_MSFGrid.SetCol(3);
vACBL = m_pRecordset->GetCollect("ACBL");
m_MSFGrid.SetText((_bstr_t)vACBL); iRow++;
m_pRecordset->MoveNext(); }
m_MSFGrid.SetRow(1);
m_MSFGrid.SetCol(1);
序号 柜员号 币种 余额1 0010 01 4145而余额的实际值为414500.00代码如下:
m_MSFGrid.SetCols(4);
m_MSFGrid.SetRows(1);
//m_MSFGrid.SetColAlignment(3,0);
m_MSFGrid.SetTextMatrix(0,0,"序号");
m_MSFGrid.SetTextMatrix(0,1,"柜员号");
m_MSFGrid.SetTextMatrix(0,2,"币种");
m_MSFGrid.SetTextMatrix(0,3,"余额");
m_MSFGrid.SetColWidth(0,8*120);
m_MSFGrid.SetColWidth(1,10*120);
m_MSFGrid.SetColWidth(2,10*120);
m_MSFGrid.SetColWidth(3,15*120); if(m_pRecordset == NULL)
{
return;
} try
{
m_pRecordset->MoveFirst();
}
catch(_com_error e)
{
AfxMessageBox(_T("没有满足条件记录"));
return;
}
m_MSFGrid.SetCols(4);
int iCount=0;
while(!m_pRecordset->adoEOF)
{
m_pRecordset->MoveNext();
iCount++;
} m_pRecordset->MoveFirst();
m_MSFGrid.SetRows(iCount +1); _variant_t vTRTL,vCYTP,vACBL;
int iRow = 1;
while(!m_pRecordset->adoEOF)
{
CString str; str.Format("%d",iRow);
m_MSFGrid.SetRow(iRow);m_MSFGrid.SetCol(0);
m_MSFGrid.SetText(str); m_MSFGrid.SetRow(iRow);m_MSFGrid.SetCol(1);
vTRTL = m_pRecordset->GetCollect("TRTL");
m_MSFGrid.SetText((_bstr_t)vTRTL); m_MSFGrid.SetRow(iRow);m_MSFGrid.SetCol(2);
vCYTP = m_pRecordset->GetCollect("CYTP");
m_MSFGrid.SetText((_bstr_t)vCYTP); m_MSFGrid.SetRow(iRow);m_MSFGrid.SetCol(3);
vACBL = m_pRecordset->GetCollect("ACBL");
m_MSFGrid.SetText((_bstr_t)vACBL); iRow++;
m_pRecordset->MoveNext(); }
m_MSFGrid.SetRow(1);
m_MSFGrid.SetCol(1);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货