groovy:測試1

groovy:測試1
程序
=========
import java.sql.Timestamp
import java.math.BigDecimal
import java.sql.PreparedStatement
import java.sql.ResultSet
import org.compiere.util.DB
import org.compiere.model.MUser
import org.compiere.util.Env
//@script:groovy:getQuotationForOrder
def now = new Timestamp(System.currentTimeMillis());
int client=Env.getContextAsInt(A_Ctx, "AD_Client_ID");
int org=Env.getContextAsInt(A_Ctx, "AD_Org_ID");
int uid=Env.getContextAsInt(A_Ctx, "#AD_User_ID");
// int parent_id=((Integer)A_PO.get_Value("出貨通知_ID")).intValue();

// DB.getSQLValueString(null,"select \"序號\" from \"報價單明細\" where \"報價單明細_id\"= ?", id);
// int getSQLValue (String trxName, String sql)
// getSQLValueString(trxName, sql, new Object[]{int_param1});
String uu1=DB.getSQLValueString(null, "SELECT adempiere.Generate_UUID()  AS uu1  " );
int id1= DB.getSQLValue(null, "SELECT adempiere.NextID('儲位內容', 'N')   AS  id1  " );

result="成功 uu1="+uu1+" ,id1="+id1