|
楼主 |
发表于 2016-8-3 15:00:45
|
显示全部楼层
String sql="select ER_Order,ER_Order.PactNumber as PactNumber,ER_Order.SetMealName as SetMealName,ER_Order.DesignerName as DesignerName,ER_Order.ForemanName as ForemanName,ER_Order.MonitorName as MonitorName,ER_Order.MachineCupboardPersonName as MachineCupboardPersonName,ER_Order.MachineDoorPersonName as MachineDoorPersonName, ERS_OrderState.Description as Description,ER_Order.ConfirmIncreaseA as ConfirmIncreaseA,ER_ForemanLastSettle.ForemanCheckState as ForemanCheckState,ER_ForemanLastSettle.LastStateName as LastStateName,ER_CRM.SubCityName as SubCityName,ER_CustomerInfo.CustomerName as CustomerName,ER_CRM.Address as Address,ER_Order.AreaSize as AreaSize, ER_Order.OrderState as OrderState , ER_CRM.SubCityCode as SubCityCode from ER_Order ER_Order optional join ERS_OrderState ERS_OrderState on ER_Order.OrderState = ERS_OrderState.StateNum optional join ER_ForemanLastSettle ER_ForemanLastSettle on ER_ForemanLastSettle.LastOrderID = ER_Order optional join ER_CRM ER_CRM on ER_Order.CRM = ER_CRM optional join ER_CustomerInfo ER_CustomerInfo on ER_CustomerInfo = ER_CRM.CustomerInfo where ER_Order.PactNumber in ('"+condition+"') and ER_CRM.SubCityCode = :currentOgnCode() order by ER_Order.PactNumber desc";
Table table = KSQL.select(sql,null, "/ERP/OrderUpdate/data", null);
table.getProperties().put(Table.PROP_NAME_ROWID, "ER_Order");
return table; |
|