EAS BOS sql 查询

最新推荐文章于 2023-03-08 14:56:16 发布

userRobee

最新推荐文章于 2023-03-08 14:56:16 发布

阅读量462

点赞数

CC 4.0 BY-SA版权

分类专栏： java 文章标签： java

本文链接：https://blog.youkuaiyun.com/userRobee/article/details/118941041

java 专栏收录该内容

2 篇文章

订阅专栏

在EditUI中查询

private BigDecimal getBatchIncomeBillAmount(String projectId, String createTime, String type) throws BOSException, SQLException {
		StringBuilder sqlAimCostResoure = new StringBuilder();
		sqlAimCostResoure.append("select sum(b.famount) amount from T_EC_BatchIncomeBill a")
			.append(" left join T_EC_BatchIncomeEntry b on a.fid = b.fparentid ")
			.append("where a.fprojectid = '"+projectId+"' and a.fbillsate = '03' and fAuditDate = '"+createTime+"'")
			.append(" and CFRECEIVABLESTYPE = '"+type+"'");
		
		ISQLExecutor executor = SQLExecutorFactory.getRemoteInstance(sqlAimCostResoure.toString());
		IRowSet irRowSet = executor.executeSQL(); 
		if (irRowSet.size() > 0) {
			while(irRowSet.next()) {
				BigDecimal amount = irRowSet.getBigDecimal("amount");
				return amount != null ? amount : BigDecimal.ZERO;
			}
		}
		return BigDecimal.ZERO;
	}

在ControllerBean中查询

public BigDecimal getAimHunmanTotalAmount(Context ctx,String projectId) throws BOSException, SQLException{
		StringBuilder sqlAimCostResoure = new StringBuilder();
		
		sqlAimCostResoure.append("select sum(acr.famount) amount from T_EC_AimCostResource acr left join T_EC_AimCostBill acb ")
			.append("on acb.fid = acr.fbillId left join T_EC_CostAccount ca on ca.fid = acr.fcostAccountid ")
			.append("where acb.fprojectID = ? and acb.fbillSate = '03' and ca.fnumber = '01.01' and acb.fisvalid = 1 ");
		IRowSet irRowSet = DbUtil.executeQuery(ctx, sqlAimCostResoure.toString(), new Object[]{projectId});
		if(irRowSet.size() > 0){
			while(irRowSet.next()){
				return irRowSet.getBigDecimal("amount");
			}
		}
		return BigDecimal.ZERO;
	}