摘要：SELECT pay_id, invoice_num, task_name, pay_priority, core_enterprise_name, financial_institutions_name, suppliers_name, item_company_name, account_rec 阅读全文

摘要：//上个界面传过来的时间，可能是一个时间段，可能是当天String startTime = ctr.getPara("startDate").replaceAll(" ","");String endTime = ctr.getPara("endDate").replaceAll(" ","");i 阅读全文

摘要：/** * 音泰思计算机技术(成都)有限公司 * 2017年11月21日 17:55:18 * */ package com.qhyf.app.bl.service; import java.text.ParseException; import java.util.ArrayList; import java.util.List; import com.alibaba.fas... 阅读全文

摘要：SELECT (@i :=@i + 1) AS number, x.uuid, x.payment_code, x.supplier_name, x.receive_money, x.is_export_flag, x.export_time, x.payer, x.region_name, x.user_name,... 阅读全文

摘要：// 获取任务类型的uuidString taskUuids = ctr.getPara("taskUuids"); // 获取的数组 String isTakes ="";// 不为空时添加查询条件if (StringUtils.notBlank(taskUuids)) { String[] ta 阅读全文

摘要：SELECT a.uuid AS user_uuid, a.user_name, a.user_id, IF ( c.online_state IS NULL, '1', c.online_state ) AS online_state, e.level_name, group_concat(DISTINCT(d.role_name)) AS... 阅读全文

摘要：/** * 保存发票信息 * @param controller * @return * @throws ParseException * @throws ActiveRecordException */ @Before(Tx.class) public boolean addInvoice(QhyfController... 阅读全文

摘要：SELECT (@i :=@i + 1) AS number, x.uuid, x.payment_code, x.supplier_name, x.receive_money, x.is_export_flag, x.export_time, x.payer, x.region_name, x.user_name,... 阅读全文

摘要：SELECT x.core_enterprise_id, x.years, x.months, SUM( x.invoice_amount ), SUM( x.invoice_tax_amount ), SUM( x.total_amount ) , x.invoice_date FROM ( SELECT a.co... 阅读全文

摘要：//对组任务类型进行转义处理 if(StringUtils.notBlank(groupTaskType)){ groupTaskType=qhyfService.strEscape(groupTaskType); String groupTaskTypes="%"+groupTaskType+"%"; St... 阅读全文

摘要：SELECT a.user_name, a.user_id, b.online_state , z.task_user_uuid , z.pay_priority , z.yiLingQuStatus , z.yiWanChengStatus , z.totalFROM sys_user aLEFT 阅读全文

摘要：三范式 1NF:字段不可分; 2NF:有主键，非主键字段依赖主键; 3NF:非主键字段不能相互依赖; 解释: 1NF:原子性 字段不可再分,否则就不是关系数据库; 2NF:唯一性 一个表只说明一个事物; 3NF:每列都与主键有直接关系，不存在传递依赖; 阅读全文