【无标题】

20230919代码

新知识：for xml path(‘’) 连接多个字段为一个字段

// 取每次参会人员合并为一条数据
select  c.Id,c.Title,c.host,c.meetdate,c.position,c.content,
  ( select   ' '+hum_name from sa_aqsc_hyjl_zz b  WHERE b.FK=c.Id for xml path('') 
  ) 
  as names 
from sa_aqsc_hyjl_z c 
WHERE CAST(c.FK as varchar(36))='${Id}'  
GROUP by c.Id ,c.Title,c.host,c.meetdate,c.position,c.content

20230920代码

// 窗体配置文件
 "item": {
        "ComponentType": "ComboBox",
        "SourceType": "sql",
        "Source": "SELECT Id as id, CAST(xuhao AS varchar(36))+' '+fxd_name+' '+name as text FROM   sa_aqsc_fxqd WHERE fxd_name!='风险点名称' AND qdlb='1' order by xuhao ",
        "textField": "text",
        "valueField": "id"
    }

新知识：charindex(a,b)如果字符串a包含在b里面返回值大于0，反之小于0.

// 窗体配置文件
select * from
 sa_aqsc_fxqd where qdlb=2 AND CHARINDEX(CAST(Id as varchar(36)),'${item}')>0 order by xuhao

资本论

科目一通过，开始学习别的，资本论+代码+写作。