Revision history [back]

I have two zul files, one is "orders.zul",the other is "ordersdetail.zul". I click "save" button in "orders.zul",it's runing:Executions.createComponents("/zul/ordersdetail.zul",view,arg), when I delete item in "ordersdetail.zul",I want refresh "ordersamount" in "orders.zul".

The following code desc "orders.zul" and "ordersdetail.zul":

"orders.zul"

<zk> <window id="ordersfrm"> <decimalbox format="#,##0.#" id="ordersamount"> ..... ..... <button label="Save" width="60px" onclick="submit();"/>

<zscript> void submit() { Map arg = new HashMap(); arg.put("orderid",orderid.value); Components.removeAllChildren(view); Executions.createComponents("/zul/ordersdetail.zul",view,arg);

} </zscript>

</window>

<window id="view"/> </zk>

"OrdersDetail.zul"

<zk>

<hbox> <window width="30px"/> <window &gt;="" <zscript=""> import my.ordersdManager; orderitembean = new OrdersdManager().findAll(arg.get("orderid")); </zscript> <grid id="billdList" width="680px" height="160px" &gt;="" <columns="" &gt;="" <column="" label="Itemcode" width="60px"/> <column label="ItemDesc" width="210px"/> <column label="Unit" width="60px"/> <column label="Type" width="60px"/> <column label="Price" width="60px"/> <column label="qty" width="40px"/> <column label="Discount" width="40px"/> <column label="Amount" width="80px"/>

</columns> <rows> <row value="${each.Itemcode}" foreach="${orderitembean}" &gt;="" <label="" value="${each.Itemcode}" onclick="delrec(self.parent)"/> <label value="${each.Itemdesc}"/> <label value="${each.Unit}"/> <label value="${each.Type}"/> <label value="${each.Price}"/> <label value="${each.Qty}"/> <label value="${each.Discount}"/> <label value="${each.Amount}"/>

</row> </rows> </grid> <zscript>

String orderno=arg.get("orderid"); void delrec(Row row) { if (Messagebox.show("Confirm Delete?"+"("+self.value+")", "Information", Messagebox.OK|Messagebox.CANCEL,Messagebox.QUESTION)==Messagebox.OK) { import java.sql.; import javax.sql.DataSource; import javax.naming.; import my.DBPool; Connection conn = null; PreparedStatement stmt = null; conn = DBPool.getPool().getConnection(); stmt = conn.prepareStatement("delete from ordersd where orderid=? and itemcode=?"); stmt.setString(1, orderno); stmt.setString(2, self.value); stmt.executeUpdate(); conn.commit(); stmt = conn.prepareStatement("update orders a,(select orderid,sum(amount) as amount from ordersd where orderid=? group by orderid) b set a.amount=b.amount,disamount=b.amount-a.nosale where a.orderid=b.orderid"); stmt.setString(1, orderno); stmt.executeUpdate(); conn.commit();

stmt.close(); conn.close(); row.detach(); } } </zscript> </window> </hbox> </zk>