12 2019 档案

sql 分析2
摘要：SELECT case WHEN (LOCATE('nocheck', d.VALUE) > 0 && FORMAT(SUM(G.total_amount2023), 2) is NOT null) || (d.VALUE = '' && (FORMAT(SUM(G.total_amount2023 阅读全文

posted @ 2019-12-27 16:15 小白菜好吃 阅读(145) 评论(0) 推荐(0)

sql 分析
摘要：SELECT case when a.value is null || a.`value` = '' || LOCATE('nocheck', a.VALUE) > 0 then '' ELSE a.value end as bgy_contract_project , case when c.va 阅读全文

posted @ 2019-12-27 14:01 小白菜好吃 阅读(223) 评论(0) 推荐(0)

mysql
摘要：SELECT b.uuid AS document_id, b.file_name, a.need_num, a.valid_num, d.scanning_file_id, d.scanning_flag, d.receive_num, d.come_from, d.from_person, d. 阅读全文

posted @ 2019-12-11 17:17 小白菜好吃 阅读(282) 评论(0) 推荐(0)

java 8 的使用
摘要：package com.cdyfsz.autoaudit.demo; import com.alibaba.fastjson.JSON; import com.cdyfsz.autoaudit.dto.AutoApproveEntryOpinionDTO; import com.cdyfsz.aut 阅读全文

posted @ 2019-12-04 20:19 小白菜好吃 阅读(253) 评论(0) 推荐(0)

导航