sum ,pack , addSelectionField() 合计字段
//breakpoint;
//-------------------行数
m_qrCount = new QueryRun(NJ_MF_SilverModelInventory_ds.queryRun().query().pack());
m_qbdsCount = m_qrCount.query().dataSourceNo(1);
m_qbdsCount.addSelectionField(fieldNum(NJ_MF_SilverModelInventory_tbl,RecId),SelectionField::Count);
if (!m_qrCount.getNo(1)) //叛断记录是否空,如果为空则返回0
LineCount.value(0);
while(m_qrCount.next())
{
LineCount.value(any2int(m_qrCount.getNo(1).RecId));
}
//----------------------------银版总量
m_qrCount = new QueryRun(NJ_MF_SilverModelInventory_ds.queryRun().query().pack());
m_qbdsCount = m_qrCount.query().dataSourceNo(1);
m_qbdsCount.addSelectionField(fieldnum(NJ_MF_SilverModelInventory_tbl,Set_qty),SelectionField::Sum);
if (!m_qrCount.getNo(1)) //叛断记录是否空,如果为空则返回0
ModelTotal.value(0);
while(m_qrCount.next())
{
tmp = m_qrCount.getNo(1);
ModelTotal.value(any2int(m_qrCount.getNo(1).(fieldnum(NJ_MF_SilverModelInventory_tbl,Set_qty))));
}
【推荐】还在用 ECharts 开发大屏?试试这款永久免费的开源 BI 工具!
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步