SupplementTaskOneEdit1单逻辑.cfg 1.4 KB

12345678
  1. <?xml version="1.0" encoding="UTF-8"?><root><product><type>log</type><code>SupplementTaskOneEdit1</code><version>8</version><name>数据补录任务管理维护基本信息查询</name><desc></desc><state>latest</state><visiblerange>public</visiblerange><suptype>_PUBLIC</suptype><supcode>_PUBLIC</supcode><createenv>10.1.80.882883rmcdb</createenv><updateenv>10.1.80.1572883rdcdb</updateenv><recmodifyid>admin</recmodifyid><auditorid>admin</auditorid><recmodifydate>2024-12-19 15:40:35:426</recmodifydate><importmodifydate>2024-12-19 15:40:35:426</importmodifydate><changedesc>1</changedesc><module>_public</module><parameter></parameter><relation></relation><detail><![CDATA[<RDP_LOGICINFO><lid>SupplementTaskOneEdit1</lid><lverno>8</lverno><ltype>0</ltype><usetime>0</usetime><errormsg></errormsg><sqlexecutetype>1</sqlexecutetype><lbody><select>
  2. select a.taskcode,a.tmpname,a.orgcode,b.orgname,a.account,c.cnname,d.nounname,a.frequency,cast(adjustment as number) as adjustment,ischeck
  3. from rmc_imput_suptaskconf_baseinfo a
  4. left join sys_organization b on a.orgcode = b.orgcode
  5. left join sys_user c on a.account = c.account
  6. left join sys_noun d on a.frequency = d.nounvalue and d.nounitem = 'frequency'
  7. where 1=1 and a.taskcode = #{taskcode}
  8. </select></lbody><lbodyDbt></lbodyDbt><lbodyOra></lbodyOra><lbodyMysql></lbodyMysql></RDP_LOGICINFO>]]></detail></product></root>