查询后弹出信息日志项目关联打开项目关联的窗体,如图
查询写在了按钮事件下:
View Code void clicked(){ SalesLine t_salesLine; QueryBuildDataSource m_qbds; QueryBuildRange m_qbrTime,m_qbrExtId; QueryRun m_qr; Query m_q = new Query(); Str m_frTime,m_toTime,m_ExtId; Boolean m_isFind = true ; ; super(); m_frTime = frDateEdit.valueStr(); m_toTime = toDateEdit.valueStr(); m_ExtId = ExtIdEdit.valueStr(); m_qbds = m_q.addDataSource(tablenum(SalesLine)); m_qbrTime = m_qbds.addRange(fieldnum(SalesLine,createdDateTime)); m_qbrTime.value(m_frTime + " .. " + m_toTime); m_qbrExtId = m_qbds.addRange(fieldnum(SalesLine,ExternalItemId)); m_qbrExtId.value(m_ExtId); m_qr = new QueryRun(m_q); while (m_qr.next()) { t_salesLine = m_qr. get (tablenum(SalesLine)); info(strfmt( " @IWS1070 " ,t_salesLine.SalesId,t_salesLine.ItemId), '' ,SysInfoAction_TableField::newBuffer(t_salesLine)); m_isFind = false ; } if (m_isFind) { info( " 此条件范围没有数据! " ); }}
转载于:https://www.cnblogs.com/Kurodo/archive/2011/07/15/2107320.html
相关资源:JAVA上百实例源码以及开源项目