常用SQL 方法

最新推荐文章于 2024-04-26 17:51:48 发布

Cc_Rain0624

最新推荐文章于 2024-04-26 17:51:48 发布

阅读量328

点赞数 9

文章标签： sql python 数据库

本文链接：https://blog.csdn.net/Cc_Rain0624/article/details/135471016

版权

IUifService queryService = NCLocator.getInstance().lookup(IUifService.class);
		String pk_dept = String.valueOf(queryService.findColValue("org_dept", "pk_dept",
				"pk_org='" + toOrgID + "' and code='" + VAL_PSC_SODEPT + "'"));
		if (pk_dept.equals("null")) {
			throw new BusinessException("获取不到提货人所在组织的销售部门【" + VAL_PSC_SODEPT + "】，请核对");
		}

		String pk_dept_v = String.valueOf(queryService.findColValue("org_dept", "pk_vid", "pk_dept='" + pk_dept + "'"));
		String toOrgID_v = String
				.valueOf(queryService.findColValue("org_salesorg", "pk_vid", "pk_salesorg ='" + toOrgID + "'"));
		String pk_billtypeid = String
				.valueOf(queryService.findColValue("bd_billtype", "pk_billtypeid", "pk_billtypecode='30-Cxx-99' and nvl(dr,0)=0"));
		String pk_busitype = String
				.valueOf(queryService.findColValue("bd_busitype", "pk_busitype", "primarybilltype='30-Cxx-99' and validity=1 and nvl(dr,0)=0"));
		String pk_stockorg = String.valueOf(queryService.findColValue("org_relation", "target", "sourcer = '" + toOrgID
				+ "' and pk_relationtype = 'SALESTOCKCONSIGN0000' and isdefault = 'Y' and enablestate = 2 and dr=0"));
		String pk_stockorg_v = String
				.valueOf(queryService.findColValue("org_stockorg", "pk_vid", "pk_stockorg='" + pk_stockorg + "'"));
		String pk_stordoc = String.valueOf(queryService.findColValue("bd_stordoc", "pk_stordoc",
				"pk_org='" + toOrgID + "' and code='" + VAL_PSC_SOSTOR + "'"));

BillQuery<SaleOrderVO> queryVO = new BillQuery<SaleOrderVO>(SaleOrderVO.class);
				SaleOrderVO[] saleOrderAggVOs = queryVO.query(orderPKs.toArray(new String[0]));

// 加锁 + 检查ts
BillTransferTool<OrderVO> transTool = new BillTransferTool<OrderVO>(
									saveOrderLst.toArray(new OrderVO[0]));

//查询参数
import nc.pub.uap.initquery.InitQueryVariable;
String OP_UMS9006_30TO30E1 = InitQueryVariable.queryVariable(aggVO.getParentVO().getPk_org(),
						"OP_UMS9006_30TO30E1");